Import error: The source data is not in the required format (decimal number)

(0) Share

Report

Posted on by NielsL

262

Hi,

I am getting an error when I'm trying to import records to CRM.

"The source data is not in the required format"

This is the case for all decimal fields. if I change the decimal symbol from , (comma) to . (period) in the source file the import is succesful. However, i would rather not have to do that for multiple columns.

Which settings are taken into account when importing records? Both the System Format and my Personal Format has , (commas) as the Decimal Symbol.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

miguelbeja on at

Like (0)

Report

RE: Import error: The source data is not in the required format (decimal number)

Hi,

Just testing on an environment where I have my personal options formats with Decimal Symbol: , and Digit Grouping Symbol: . and the other way around on the System Settings, when exporting the records, the Decimal Symbol is: .

So it seems that what is taking into account when exporting is the System Settings formats.

When importing records that contains . as decimal but the System Settings has , as decimal, it was converted to ,

Was this reply helpful? Yes No