csv2ndjson

Convert a CSV file to Elasticsearch Bulk or NDJSON format

Install

$ npm install csv2ndjson

Usage:

todo

Examples:

index: 'employees' type: 'people'

data.csv:

FirstName	LastName	Age	DOB	Organization
Willard	Smith	49	9/25/1968	Salesforce
Dwayne	Johnson	45	5/2/1972	Elasticsearch
Jim	Carrey	56	1/17/1962	Blizzard
Thomas	Hanks	61	7/9/1956	Dropbox
William	Pitt	54	12/18/1963	Uber
Edward	Murphy	57	4/3/1961	Adobe

Elastic Bulk:

{ "index" : { "_index" : "employees", "_type" : "people" } }
{"FirstName":"Willard","LastName":"Smith","Age":"49","DOB":"9/25/1968","Organization":"Salesforce"}
{ "index" : { "_index" : "employees", "_type" : "people" } }
{"FirstName":"Dwayne","LastName":"Johnson","Age":"45","DOB":"5/2/1972","Organization":"Elasticsearch"}
{ "index" : { "_index" : "employees", "_type" : "people" } }
{"FirstName":"Jim","LastName":"Carrey","Age":"56","DOB":"1/17/1962","Organization":"Blizzard"}
{ "index" : { "_index" : "employees", "_type" : "people" } }
{"FirstName":"Thomas","LastName":"Hanks","Age":"61","DOB":"7/9/1956","Organization":"Dropbox"}
{ "index" : { "_index" : "employees", "_type" : "people" } }
{"FirstName":"William","LastName":"Pitt","Age":"54","DOB":"12/18/1963","Organization":"Uber"}
{ "index" : { "_index" : "employees", "_type" : "people" } }
{"FirstName":"Edward","LastName":"Murphy","Age":"57","DOB":"4/3/1961","Organization":"Adobe"}

NDJSON:

{"FirstName":"Willard","LastName":"Smith","Age":"49","DOB":"9/25/1968","Organization":"Salesforce"}
{"FirstName":"Dwayne","LastName":"Johnson","Age":"45","DOB":"5/2/1972","Organization":"Elasticsearch"}
{"FirstName":"Jim","LastName":"Carrey","Age":"56","DOB":"1/17/1962","Organization":"Blizzard"}
{"FirstName":"Thomas","LastName":"Hanks","Age":"61","DOB":"7/9/1956","Organization":"Dropbox"}
{"FirstName":"William","LastName":"Pitt","Age":"54","DOB":"12/18/1963","Organization":"Uber"}
{"FirstName":"Edward","LastName":"Murphy","Age":"57","DOB":"4/3/1961","Organization":"Adobe"}

Todo:

• Add header support
• Testing
• Add usage