Need help importing CSVs in Retool Database

Queries and Resources
1

Hi all!

So I'm trying to load data into the Retool database.

I had a .csv file that was > 3MB so I split it in two parts; first 2332 lines into part 1, the rest into part 2.

I load part 1 as CSV into a table, works fine.
When I try to import part2 as CSV into the same table I get:
"Failed to insert rows from CSV
Invalid input syntax for type integer: "".

cf picture:
image

So I assume there's some input problem but I can't locate in which row or in which column.

Also, what I find weird is that, if I try to import part2 in another table in Retool, it works just fine.

I double-checked, columns are of the same type.

Any hint on how I could solve this?

Baptiste

1 Like
2

Hey there @Baptiste_LC,

So there are several posts on this topic, and this thread makes reference to many solutions out there.

The patchy workaround I usually go for when I have clients with the retool DB is to use a bulk update via primary key via an app. I create a query, select my table, copy and paste my csv data into this page that creates a Json and use the output as the items to be updated. This way null values will be updated properly.

Hope this helps!

1 Like
3

Many thanks Miguel,

This worked!

Baptiste

1 Like