Create CSV to JSON converter script
Budget: $30 – $250 AUD
There are many basic CSV to JSON conversion tools, but we need one to create a nested JSON syntax with specific structure.
This needs to run on a linux machine - so can be bash, python, etc
The input file is a CSV with these columns:
* title
* login
* password
* login_url
* notes
* Password List
* TreePath
* PasswordID
* Description
* IP Address
* Certificate
* Config
And the output JSON needs to follow the format described at https://docs.keeper.io/user-guides/import-records-1/import-json#creating-a-custom-.json-file-for-import-into-keeper
The first 5 fields in the CSV belong to the "records" section.
The next 2 fields relate to the "folders" and "shared_folder" section - which needs to be included for each record.
The last 5 fields are to be added as "custom fields" for each JSON record.
Note the custom fields need to correctly bring across embedded commas, double quotes, \n and other characters which can sometimes mess up the CSV to JSON conversion.
This needs to support around 10,000 records per CSV file
Some of the custom fields are large text fields, up to 3000 characters each
This needs to run on a linux machine - so can be bash, python, etc
The input file is a CSV with these columns:
* title
* login
* password
* login_url
* notes
* Password List
* TreePath
* PasswordID
* Description
* IP Address
* Certificate
* Config
And the output JSON needs to follow the format described at https://docs.keeper.io/user-guides/import-records-1/import-json#creating-a-custom-.json-file-for-import-into-keeper
The first 5 fields in the CSV belong to the "records" section.
The next 2 fields relate to the "folders" and "shared_folder" section - which needs to be included for each record.
The last 5 fields are to be added as "custom fields" for each JSON record.
Note the custom fields need to correctly bring across embedded commas, double quotes, \n and other characters which can sometimes mess up the CSV to JSON conversion.
This needs to support around 10,000 records per CSV file
Some of the custom fields are large text fields, up to 3000 characters each