Csv number not loading correctly

  • 31Views
  • Last Post 28 March 2022
0
votes
María Romero posted this 15 March 2022

Hi,

we are using skyvia data integration tool, and we have a problem loading one csv file into a salesforce org. The fields we are having problems with are currency type.

In the csv file we have two fields: net amount, and total amount. Some of the records have only one decimal place (for example 30085.3) and some others have two (19547.05). These with two decimal places are the ones we are having errors with.

When we upload the csv we see in our salesforce org that the number is 1.954.705,00 (instead of 19547.05).

Any help would be appreciated. Best regards.

0
votes
Nataliia Nikulina posted this 28 March 2022

Hello Maria,

 

Thank you for contacting Skyvia Support team.

On my end i was able to successfully update the decimal numbers if they contain comma instead of dot, for example 

19547,05 instead of 19547.05

If this does not help, please send us the package link so we can further investigate the package details.

Please update us about the results.

 

Best regards,

Nataliia,

Customer Support Engineer 

 

New Ticket
Categories
Popular Tags
Close