Batch import data from csv files to Redis 1 hash key without programming

by

Want to batch import multiple CSV files into a single Redis hash key without programming?

Using RedisDataStudio, a native GUI tool, you can batch import multiple CSV files into a single Redis hash key easily and fast, no need to program, just a few mouse clicks!

Support Windows, Linux, macOS.

Example

Source CSV file folder

Batch import CSV file into 1 Redis hash key - source CSV folder

An example CSV file in this folder

Batch import CSV file into 1 Redis hash key - view a source CSV file

After importing, you can see string keys, and key value

Import CSV file into Redis hash key - view hash key

Here’s how to.

Import

Click “Import From File” at task dialog.

Batch import Csv file into 1 Redis hash key - task window

Choose “Files”, “CSV”, “Key”, “Hash”.

Batch import Csv file into 1 Redis hash key - task window

1. Select source file folder.

Batch import Csv file into 1 Redis hash key - source folder

2. Config first source CSV file.

Batch import Csv file into 1 Redis hash key - config first source CSV file

3. Config destination hash key, choose an exists key or create a new one.

Batch import Csv file into 1 Redis hash key - config destination hash key

4. Summary.

Batch import Csv file into 1 Redis hash key - summary

5. Batch import CSV files into a single Redis hash key.

Batch import Csv file into 1 Redis hash key - import file

View Hash Key.

Import Csv file into Redis hash key - view hash key

Save/load session

Save Session.

Click “Save Session” button, then enter a session file name.

save session

click “OK” button.

Load Session.

Click link to a session file.

load session

Then the wizard form shows, click a few “Next” to import CSV data.

start session

Run in command line

When you save session, you can click “Save & Make Batch File”.

save session

The “Save & Make Batch File” form shows.

create batch file

Click “OK” button, you’ll create a batch file, in Windows, like this:

C:
cd "C:\Users\pansh\AppData\Local\Programs\RedisDataStudio"
RedisDataStudio task="C:\Users\pansh\Documents\test.rdcs" logfile="C:\Users\pansh\Documents\test.log"

You can run this batch file in command line.

Run as scheduled task

On Linux/macOS, you can use Crontab.

For macOS, How to Fix Cron Permission Issues in macOS.

On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.

create batch file

And then, with scheduled task wizard, step by step.

scheduled task application

scheduled task name

scheduled task time

scheduled task user

scheduled task information

You’ll see created task listed in scheduled task list.

scheduled task list

Download

Here you can download RedisDataStudio, and buy RedisDataStudio.