csv2notion-neo icon indicating copy to clipboard operation
csv2notion-neo copied to clipboard

[Bug]: Fails to import first column for first 5 rows of the CSV file

Open bumper314 opened this issue 1 year ago • 1 comments

CSV2Notion Neo Version?

1.3.1

What OS are you using?

MacOS

OS Version or Linux distribution

macOS 10.14

Bug Description

I have a well formed CSV file where the first column is a unique id for each row. Using csv2notion_neo (or csv2notion) to create a new database fails to import this data correctly, somehow skipping the first column and using the second column for the first 5 rows of the CSV (not including the header). It doesn't matter if I change the content of the CSV, it's always the first 5 rows that get borked.

Screen Shot 2024-09-20 at 21 19 45

Here's the sample data: youtube2csv_espanolconjuan.csv

I'm running csv2notion_neo --verbose --workspace "Workspace" --token "$token" "youtube2csv_espanolconjuan.csv" to create a new database.

However, if I delete the bad data, add --merge, and run again, the content gets imported correctly the second time.

Log excerpt

INFO: CSV2Notion Neo version 1.3.1
INFO: Validating csv & csv2notion_neo.notion DB schema
INFO: Creating new database
INFO: New database URL: https://www.notion.so/XXXXXXXXX
INFO: Uploading youtube2csv_espanolconjuan.csv...
INFO: Done!

bumper314 avatar Sep 21 '24 03:09 bumper314