Dashboard keep showing loading for a long time when import data with wrong format

[hieuwu]

Discussed in https://github.com/orgs/supabase/discussions/13528

^{Originally posted by hieuwu April 8, 2023}

⚙️ Summary

Currently, when I import data from CSV file, I notice that if we set the value of a column on Supabase is float4 and the data of this column is a string, the platform will stop working without any response.
For example, my column is price with type is float4. I import a data set with a row containing value at price column is "this is a string". The platform keep showing loading message forever

💡 Suggestion

It would be nice if we have some mechanism to verify the format of data for number before performing any operation.

I imported the file below
product.csv

[vozmi]

Hello, @hieuwu!
I've tried to reproduce your error with simplier data but haven't get infinite loader.
Instead, I got an error: Failed to import data: Failed to run sql query: invalid input syntax for type real: "...".

I created table with three columns:

• id (int8)
• name (text)
• price (float4)

and imported this test.csv file:

id	name	price
1	apple	0.99
2	banana	1.55
3	coconut	4.55
4	tomato	2.35
5	cucumber	0.99
6	potato	test string
7	pepper	1.99

Error that I got during import is:

---

Your csv file is semi-colon separated. So when I tried to import your data I gor another error:

Also found out, that one row in your csv has more columns than needed

TcF68MpGmIGiq5LOvF7u; //productId
Chili, Local Grass-Fed Beef; //name
Chili doesn't get much meatier than this; //description
 this is the kind you dream about for game days and crisp winter nights.; //price
5.8; //image
https://firebasestorage.googleapis.com/v0/b/groceries-store-ad0eb.appspot.com/o/Vegetables%2Fcsm_peppers-plp-desktop_a9c6971df1.jpg?alt=media&token=f986caa0-d65c-4c76-8186-ff75abd6db1e; //category
5igbz6Y8hEfluyhUy3Zp; //nutrition
Chili peppers (Capsicum annuum) are the fruits of Capsicum pepper plants, notable for their hot flavor.  They are members of the nightshade family, related to bell peppers and tomatoes. Many varieties of chili peppers exist, such as cayenne and jalapeño.  Chili peppers are primarily used as a spice and can be cooked or dried and powdered. Powdered, red chili peppers are known as paprika. // !no column!

---

Can you tell if that error is still happens or maybe I should try with another data?