Batch import data from json files to Redis string keys without programming

by

Want to batch import JSON files into Redis string keys without programming?

Using RedisDataStudio, a native GUI tool, you can batch import JSON files into Redis string keys easily and fast, no need to program, just a few mouse clicks!

Support Windows, Linux, macOS.

Here’s how to.

An example JSON file

Import JSON files into Redis string keys - view the source JSON file

Import

Click “Import From File” at task dialog.

Import JSON files into Redis string keys - task window

Choose “Files”, “JSON”, “Keys”.

Import JSON files into Redis string keys - task window

1. Select source JSON file folder.

Import JSON files into Redis string keys - source file folder

2. Config first source JSON file, check “Whole File Content As One Column”.

Import JSON files into Redis string keys - config first source JSON file

3. List exists Redis string keys, choose “Import Type”.

Import JSON files into Redis string keys - config destination string keys

4. Map JSON files to Redis string keys.

Import JSON files into Redis string keys - Map JSON files to string keys

5. Summary.

Import JSON files into Redis string keys - summary

6. Import JSON files into Redis string keys.

Import JSON files into Redis string keys - import files

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

Import JSON files into Redis string keys - view data

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 JSON 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.