Dear bubble community, it would be great if you could help me with this:
I uploaded a csv. file, mapped the fields and validated the data, all fine. When I finally uploaded the data it failed with the error: undefined
I don’t know what to do now. I attached screenshots of the upload, failure and csv. file here.
That’s a useful error message isn’t it…
Not sure whether Bubble validates all the CSV before upload or just the first few rows but are there any empty values or unique IDs that don’t exist in the DB (perhaps they exist in dev mode and you’re trying to upload to live)? Just throwing some ideas out.
This happens when there is a problem in a particular row of the CSV.
Check your email, it will tell you the row number where error occured and most likely it will be some malformed data or non-mapped data type data in that row.
For anyone experiencing this issue, it’s best to lock all data types to text. If there’s a single cell with a different detected type, it can cause an entire import to fail. Better to lock everything to text and then to run a loop (recursive backend workflow) over the rows after everything is properly imported.
