Create CSV to JSON converter script

Job ID: 36106135

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
Related categories: PHP Python Linux Software Architecture JSON