@cgadvisors/imp NPM

IMP

An easy to use node.js CLI program that allows you to convert comma delimited (CSV) data file into a JSON data file.

How it works

Basic use: Convert a CSV file to a JSON file

Let's say you have a data file office.csv containing a list of offices in CSV format and you want to convert the data in that file into JSON format.

Simply run the command

$ node imp.ts -s office.csv

IPM converts the data from CSV to JSON and stores the data in a file called output.json

You can also define a target file using the -t flag.

$ node imp.ts -s office.csv -t office.json

Intermediate use: eliminate and/or rename some of the fields

Continuing our example, let's say you are only interested in three of the fields from the CSV: the org_id, physical_address_city, and the physical_address_state. Furthermore, you want the JSON field names to be: orgID, city, and state.

All we have to do is create data mapping that conforms to this convention, store the mapping it in a file called mapping.json:

{
  "list": "rows",
  "item": {
    "orgID": "org_id",
    "city": "physical_address_city",
    "state": "physical_address_state"
  }
}

and then run the command:

$ node imp.ts -s office.csv -m mapping.json

the data is converted from CSV to JSON. The output file contains only the fields we wanted!

Advanced use: transform the data values or anything else you can dream up

IMP is extensible. If you need to change the data values, you can create a mapping file that allows you to call your own javascript functions! Refer to node-json-transform project for more info!

Pre-requisites

You must have node.js installed

Much Props

This project is built on top of the work of others. Many thanks to:

csv json convert transform node cli

@infinitebrahmanuniverse/nolb-_cg @everything-registry/sub-chunk-163

1.0.1

5 years ago

1.0.0

5 years ago