CODEWITHSUNDEEP
javascriptnode.jsreactjscsv
bruh
bruh

Reputation: 2305

Parse CSV without download / saving

I am creating an application that allows users to upload a CSV. The CSV is just a comma separated file.

On the frontend, I send the file to my backend with a PUT request:

Reactjs | fileupload_frontend.js

sendFile = () => {
  const data = new FormData();
  data.append('file', this.myCSV_file);

  axios.post('/parse-csv', data)
  .then(response => console.log('File sent to server for parsing')
  .catch(error => console.log(error);
}

The above code successfully sends the uploaded CSV (info) to my server, which is listening at the /parse-csv endpoint.

I am using the csv-parser npm package to help with this.

Nodejs | fileupload_backend.js

const csv = require('csv-parser');
const fs  = require('fs');
const results = [];

app.post('/parse-csv', (request, response) => {

  fs.createReadStream(request.files.file.data) { // this is a buffer on the req obj
    .pipe(csv())
    .on('data', results.push())
    .on('end', (results) => {
      console.log(results);
    }
  }

}

For reference, the request object from the frontend to the backend looks like:

Request from upload { name: 'data.csv',
data: <Buffer 22 89 56 24 5y 86 k9 22 . ... >,
encoding: '7bit',
truncated: false,
mimetype: 'text/csv',
md5: [Function: md5],
mv: [Function: mv] }

It is error-ing out on each request with a message that seems to be related to my header rows (first row in the csv file), with a message that reads:

Error: ENOENT: no such file or directory, open 'my,header,row,is,referenced,here'

...then the data is shown below.

Do I have to save the CSV file in some directory, then parse it first? I am just looking for a way to parse the CSV into json, so I can insert each row as an entry into my database.

Upvotes: 9

Views: 8042

Answers (3)

Oleksandr Hrin
Oleksandr Hrin

Reputation: 886

this is my solution, it works with buffer dirrectly and doesn't need to save file, just install module "csv-parse" first.

 const { parse } = require('csv-parse/sync');

 const data = await parse(request.files.file.data);

and callback version

const csv = require('csv-parse');
   
csv.parse(request.files.file.data, function (err, data) {
           console.log('my_data', data);
         )}

Upvotes: 3

Oluwafemi Sule
Oluwafemi Sule

Reputation: 38962

fs.createReadStream accepts a path as its argument which can be a string, Buffer or URL.

Since you pass a Buffer, it tries to open the Buffer as a path so it errors with

Error: ENOENT: no such file or directory, open 'my,header,row,is,referenced,here'

You need to create a stream from the Buffer before piping it to the CSV parser. There a various ways to go about this; implementing a Readable stream that uses the buffer is one. e.g. 

const { Readable } = require('stream');

class BufferStream extends Readable {
  constructor(opts) {
    super(opts);
    this.buf = opts.buf;
  }
  _read(size) {
    this.push(this.buf);
    this.push(null); // signal end of stream
  }
}

Now implement the request handler to use this class.

app.post('/parse-csv', (request, response) => {
    const results = [];
    const bufStream = new BufferStream(request.files.file.data);

    bufStream.pipe(csv())
    .on('data', (data) => results.push(data))
    .on('end', (results) => {
      console.log(JSON.stringify(results));
      response.sendStatus(200);
    }
  }

}

Upvotes: 8

Keegan Ferrett
Keegan Ferrett

Reputation: 384

Take a look at the following package, https://www.npmjs.com/package/xlsx. It will allow you to parse csv and most spreadsheet file formats interchangeably.

You can use it in the following way:

const XLSX = require('xlsx')
const workbook = XLSX.readFile(source_file_path)
const sheetName = workbook.SheetNames[0]
const sheet = workbook.Sheets[sheetName]
const obj = XLSX.utils.sheet_to_json(sheet)

This should work for any spread sheet format supported by the library.

This does mean that the file must be saved somewhere in your directory structure in for the XLSX.readFile to work.

Upvotes: 3

Related Questions