"Period, comma" gets changed to "Comma, period" in Export

Technical Help
, ,
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

If you are self-hosting, what version of Baserow are you running?

2.2.0

If you are self-hosting, which installation method do you use to run Baserow?

I don’t know.

What are the exact steps to reproduce this issue?

Hi!
We have some fields for measurements. These fields have the type “number”, the “Decimal places” “1 (1.0)” and the “Thousand and decimal separator” “Period, comma (1.000.000,00)”. But when I export the data via API with a Python script to a json file the measurements will show with the “Thousand and decimal separator” “Comma, period (1,000,000.00)”. So in the data base will be the measurement “123,4 cm” but in the json file is “123.4 cm”. I know this is the standard in USA and other countries, but for our data we need the “Period, comma” separator.
Is there a way to fix this while exporting or do I have to do it “manually” in a data control after the export?
Thank you!

Edit: In the export numbers above 1000 are shown as “1000.0” not “1,000.0”. In Baserow these are written like “1.000,0”.

2

Hi @rensinghoff,

You’re right, the API sends the raw decimal value, so 1000.0 is the correct output, not a formatted number.

Unfortunately at the moment it’s not possible to change the behavior, so you have to format it in your export script, with something like:

from decimal import Decimal

field_prefix + format(Decimal(api_value), ',.1f').replace(',', 'X').replace('.', ',').replace('X', '.') + field_suffix