11-07-2023 10:41 AM
Hello everyone,
We are trying to upload data to OS through a csv but I'm getting the following error
I checked the file both with excel and directly with a text editor and it seems the amount is correctly formatted
Do you guys have any idea why OS is giving us this error?
11-07-2023 02:23 PM
Hi @Belmontes that is a big number. This is the view from Table Data Manager on the target Stage table the Import process hits: RawAmount has a precision of 28 (or 30 for converted amount).
This is what that means: (thanks Google)
I think the RawAmount shown here is the "Am" target you identify in the Data Source definition. So, you should be able to load that amount. 1375000000000000000 (15 zeroes).
Check your file and make sure that that column with those numbers is not formatted as 'Generic' and indeed is formatted as 'Number' and see if that makes a difference.
Hope this helps,
11-08-2023 03:37 AM
Can you post the Numeric Settings on the Amount field in your DataSource please ? I suspect something is not right there.