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

by

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

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

Support Windows, Linux, macOS

Example

Source JSON file folder

Import JSON files into Redis hash keys - source JSON folder

An example JSON file

Import JSON files into Redis hash keys - view a source JSON file

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

Import JSON files into Redis hash keys - string keys

Here’s how to.

Import

Click “Import From File” at task dialog.

Batch import Json file into Redis hash keys - task window

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

Batch import Json file into Redis hash keys - task window

1. Select source file folder.

Batch import Json file into Redis hash keys - source folder

2. Config first source JSON file.

Batch import Json file into Redis hash keys - config first source JSON file

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

Batch import Json file into Redis hash keys - config destination hash key

4. Map JSON files to hash keys.

Batch import Json file into Redis hash keys - Map Json files to hash keys

5. Summary.

Batch import Json file into Redis hash keys - summary

6. Import JSON files into Redis hash keys..

Batch import Json file into Redis hash keys - import file

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

Batch import Json file into Redis hash keys - view hash 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 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.