Batch import data from csv files to Redis string keys in same namespace without programming

by

Want to batch import CSV files into Redis string keys in same namespace without programming?

Using RedisDataStudio, a native GUI tool, you can batch import CSV files into Redis namespaced string keys (key name contains ‘:’) 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 string keys in same namespace - source CSV folder

An example CSV file in this folder

Batch import CSV file into string keys in same namespace - view a source CSV file

After importing, you can view data in Redis string keys.

Import CSV file into Redis string keys in same namespace - view string keys

Here’s how to.

Import

Click “Import From File” at task dialog.

Batch import CSV files into Redis string keys in same namespace - task window

Choose “Files”, “CSV”, “Namespace Keys”, “String”.

Batch import CSV files into Redis string keys in same namespace - task window

1. Open source CSV file folder.

Batch import CSV files into Redis string keys in same namespace - source file folder

2. Config first source CSV file.

Batch import CSV files into Redis string keys in same namespace - config first source CSV file

3. Config destination string keys namespace.

Batch import CSV files into Redis string keys in same namespace - config destination string keys namespace

4. Summary.

Batch import CSV files into Redis string keys in same namespace - summary

5. Import CSV files into Redis string keys in same namespace.

Batch import CSV files into Redis string keys in same namespace - import file

After importing, you can view string keys in the namespace.

Batch import CSV files into Redis string keys in same namespace - view string 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.