Import data from csv file to Redis string keys in same namespace without programming

by

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

Using RedisDataStudio, a native GUI tool, you can import CSV file 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

An example CSV file to import

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

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

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

Here’s how to.

Import

Click “Import From File” at task dialog.

Import CSV file into Redis string keys in same namespace - task window

Choose “File”, “CSV”, “Namespace Keys”, “Strng”.

Import CSV file into Redis string keys in same namespace - choose types

1. Open source CSV file.

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

2. Config destination string keys namespace.

Import CSV file into Redis string keys in same namespace - config destination string keys namespace

3. Summary.

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

4. Import CSV file into Redis string keys in same namespace.

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

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

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

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.