csv2couchbase
Import CSV files in Couchbase
Don't expect to much from this library. If you wish to see any other features - feel free to fork / contribute and push.
Installation
- Install node.js.
- Do
npm install csv2couchbase
.
Usage
csv2couchbase --csv path/to/csv
[--host hostname]
[--password password]
[--bucket bucket]
[--queryhost queryhost]
[--columns "col1,col2,col3"]
[--autocolumns]
[--pick "col1,col3"]
[--omit "col2"]
[--chunksize 1000]
[--doctype doctype]
[--simulate]
Command line options
--csv path/to/csv
- specify path to csv file--host hostname
,--password password
,--bucket bucket
,--queryhost queryhost
- see coachbase documentation--columns "col1,col2,col3"
- specify name of the columns in CSV file, in other case data will be imported as array of values.--autocolumns
- set this flag is columns can be autodiscovered in the first CSV line.--pick "col1,col3"
- specify which columns you want to include.--omit "col2"
- other way of omitting columns which you don't want to import.--chunksize
- default chunk size is 1000, script usesaddMulti
to import data by chunks.--doctype
- specifydoctype
property for each object. Also this value will be used to construct id for rows{doctype}_{index}
.--simulate
- don't import anything to Couchbase, just simulate reading and print output to console.
Example
If you want to import GeoLite Country csv file
csv2couchbase --csv ~/Desktop/GeoIPCountryWhois.csv --bucket default --doctype geoip --columns "ip_from,ip_to,ip_int_from,ip_int_to,country_short,country"