how to import a csv file to mysql using node.js?

Question

Right now I am trying with the library fast-csv doing this:

var stream = fs.createReadStream("./google.csv");
  csv
   .fromStream(stream, {headers : ["Name","E-mail 1 - Value"], ignoreEmpty: true})
   .on("data", function(data){
       console.log(data);
   })
   .on("end", function(){
       console.log("done");
   });

But it throws this error: "column header mismatch expected: 2 columns got: 57"

Do you know how can I avoid that? should I use a different library/approach

Another problem I am facing is that I get the result in hexadecimal... how can I parse it correctly?

Remove the headers property from the second argument. That CSV clearly has 57 columns and you only provided the headers for two of them. — idbehold
– idbehold, Commented Oct 29, 2014 at 23:52

T J · Accepted Answer · 2016-02-12 11:02:07Z

7

You can use node module 'csv-parse'.

read the csv file using node 'fs' module
pass the data to csv parser and you will get arry of array, where inner array represents each row.

Take a look at the following code.

var csvParser = require('csv-parse');

fs.readFile(filePath, {
  encoding: 'utf-8'
}, function(err, csvData) {
  if (err) {
    console.log(err);
  }

  csvParser(csvData, {
    delimiter: ','
  }, function(err, data) {
    if (err) {
      console.log(err);
    } else {
      console.log(data);
    }
  });
});

Here filePath is path of the csv file and the delimiter will be as per your file. It is the character that separates fields in csv file(can be ',', '.', etc).

edited Feb 12, 2016 at 11:02

T J

43.2k13 gold badges87 silver badges142 bronze badges

answered Oct 30, 2014 at 7:46

Asis Datta

5733 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ced Over a year ago

Hi Techxxx, this approach worked better, but now I am facing this issue: everything is hexadecimal, how would you deal with that?

Asis Datta Over a year ago

@Cedric Sorry, but I don't understand your problem. If you explain it then I can try to help you.

Collectives™ on Stack Overflow

how to import a csv file to mysql using node.js?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related