csv-2-redis v0.0.10

csv-2-redis

- A simple module to upload data from CSV files to Redis Server running locally / remotely.

- Uses 'csv-parse' module for CSV parsing. 

###Installation

npm install csv-2-redis

Current version is tested with Node v0.10.21 and above.

###CLI

* csv-2-redis "myData.csv" "127.0.0.1" "6379" 12

* csv-2-redis "myData.csv" localhost default default
   
* csv-2-redis "myData.csv" local default  3

* csv-2-redis "myData.csv" localhost default-port 10
   
* csv-2-redis "myData.csv" local default-port 0

* csv-2-redis "myData.csv" "some-server-name.com" "some-port-number" "select-db" auth-key"

###Options

• -g, --group : Specify this option to group values by first column entries
• -t, --test : Specify this option to test a random data, after successful data upload to Redis

###Example

1. '-g' / '--group' option specified - Values will be grouped as an array based on first column entries Consider the following entries to be our sample.csv

   ####Input CSV:

            | globalDispatchId |  productName  |  productCategory |
            | ---------------- |  ------------ | -----------------|
            |      13123       |    product11  |         Gx       |
            |      65345       |    product22  |         Bx       |
            |      34234       |    product33  |         Rx       | 
            |      13123       |    product55  |         Zx       |
            |      65345       |    product66  |         Jx       |
          

   ####Output format stored in Redis:

          "13123" : [
          {
             "globalDispatchId" : "13123",
             "productName"      : "product11",
             "productCategory"  : "Gx"           
          },
          {
              "globalDispatchId" : "13123",
              "productName"      : "product55",
              "productCategory"  : "Zx" 
          }],
          "65345" : [
          {
             "globalDispatchId" : "65345",
             "productName"      : "product22",
             "productCategory"  : "Bx"           
          },
          {
              "globalDispatchId" : "65345",
              "productName"      : "product66",
              "productCategory"  : "Jx" 
          }],
          "34234" : [
          {
             "globalDispatchId" : "34234",
             "productName"      : "product33",
             "productCategory"  : "Rx"           
          }]
          

2. without '-g' or '--group' option specified, simple insert as key-value pairs. For repeating entries, values will be overwritten for the same key.Consider the following entries to be our sample.csv

   ####Input CSV:

             |globalDispatchId |  productName  |   productCategory |
             |---------------- |  ------------ |  -----------------|
             |     13123       |    product11  |        Gx         |
             |     65345       |    product22  |        Bx         |
             |     34234       |    product33  |        Rx         |
      

   ####Output format stored in Redis:

          "13123" : {
              "globalDispatchId" : "13123",
              "productName"      : "product11",
              "productCategory"  : "Gx"           
          },
          "65345" : {
              "globalDispatchId" : "65345",
              "productName"      : "product22",
              "productCategory"  : "Bx"           
          },
          "34234" : {
              "globalDispatchId" : "34234",
              "productName"      : "product33",
              "productCategory"  : "Rx"           
          }           

###Todo's

- Write tests
- Add code comments
- Rethink optimizations

###License

Free to use and modify. Report any issues you encountered.

###P.S

Just drop me a mail anytime and share me your experience & feedbacks. just a curious kid, to know people who download..!! :)