title: What could cause missing rows when importing data into Sequelize + Heroku Postgres?
body: <p>I am using Heroku Postgres for a project and am trying to import excel spreadsheets (.xlsx) of data into a Postgres database. I have written a script in Node.js using the &quot;xlsx&quot; package and the &quot;sequelize&quot; packages. Basically, I read the excel file and convert the sheet to JSON, and then I loop through each object (row of data) in the json list and insert it into the database using Sequelize.</p>
  <p>The issue is that after successfully running my script, there is about 800 missing rows of data that was not inserted into the database. 800 missing rows is about 20% of the total number of rows in the excel sheet.</p>
  <p>I have done some extensive googling, but I can't seem to find any information related to missing rows when importing excel sheets into a database. If I had to guess, Sequelize does some &quot;internal magic&quot; to verify the integrity of data such as checking for duplicates or similar things of that nature, which might be eliminating rows. Unfortunately, the logs and print statements from sequelize are quite large and verbose, so it is hard to parse for what might be the issue, if the issue even is with sequelize.</p>
  <p>Any information is appreciated!</p>