DEV Community

NardjesBen
NardjesBen

Posted on

Ignore headers of csv files with papaparse

#node #papaparse #csv #sequelize

I have a csv file that I need to parse and store in a database. I use sequelize for this

Here is how I defined the model of my table in sequelize :

    const Person= sequelize.define(
      'person',
      {
        id: {
          type: DataTypes.UUID,
          primaryKey: true,
          defaultValue: uuidv4(),
          allowNull: false
        },
        name: {
          type: DataTypes.STRING,
        },
        age: {
          type: DataTypes.INTEGER,
        }
        }, {
            createdAt: false,
            updatedAt: false,        
            tableName: 'person'
         }
    )
    return Person
  }
Enter fullscreen mode Exit fullscreen mode

then I have a csv file "test.csv":

he ,dd
liza, 23
sarah, 22
Enter fullscreen mode Exit fullscreen mode

basically I can't change the headers in my csv file and I have to keep the same structure defined in the db, I use papaparse to parse this file :

        const papa = require('papaparse');
        const fs = require('fs')

        const file = fs.createReadStream(__basedir + "/test.csv");


        papa.parse(file, {
          header: true,
          step: async function(results, parser) {
            console.log("Row data:", results.data);
            try{
              await Person.create(results.data)

            }catch(e){
              console.log(e)
            }

          }
      });
Enter fullscreen mode Exit fullscreen mode

in output I get the following error :

SequelizeUniqueConstraintError: Validation error
Enter fullscreen mode Exit fullscreen mode

the name, surname and age fields are null in the database

I am looking for a solution to ignore the headers of the csv file, how can I do that?

Top comments (1)

Collapse
 
ganeshmani profile image
GaneshMani •

try setting header: false while parsing.

Read next

leemeganj profile image

Node.js performance hooks and measurement APIs

Megan Lee -

khalifalmahmud0 profile image

Setting Up Node.js and Yarn on Debian-based Distributions

Khalif AL Mahmud -

wallacefreitas profile image

How to Prepare Your Application to Handle Multiple Requests on Black Friday

Wallace Freitas -

akintolastephen profile image

Session Management In Node JS

AKINTOLA STEPHEN IYANU -