Error csv: expected a number

Hi, i’m having this issue with my csv upload. On the upcoming photos you can see the error and the csv.

He’s expecting a number, but it’s already a number on the google drive .csv; and yes the colunm is formated as a number.

Bubble probably doesn’t expect a number to have a comma as it is built by American engineers.

I know there was an issue related to decimal versus comma for different countries as it relates to number formatting, and can not remember the exact situation that Bubble rectified it for, but it could be that it was not rectified for CSV uploads.

Maybe try formatting the CSV to use decimals instead of commas as I can see in the screen shot of the error the row 1 of the CSV you uploaded was a value of 2,50 and not 2.50

2 Likes

Yeah, the problem is that the clients are brazillians and we will receive .CSV’s with thousands of lines formatted like: R$ 1.054,25 . Do you have knowledge of any backend workflow that can make a change, in the csv file, before its “uploaded” to morph these commas into dots?

With code, i could simply just make a “string.replace (”,", “.”) " on the csv file and it would work.

I don’t know of how to do that in Bubble, but would expect it is simple to do in the document itself prior to upload.

It is also worth contacting Bubble support regarding the issue to see if perhaps it is a Bug that this doesn’t work since I do recall them working on issues in the past related to the use of different currency/number formatting.

This topic was automatically closed after 70 days. New replies are no longer allowed.