Skip to main content
B
Belmontes
November 7, 2023

Data load input string format

  • November 7, 2023
  • 2 replies
  • 0 views

Hello everyone,

We are trying to upload data to OS through a csv but I'm getting the following error


Belmontes_0-1699371393684.png

I checked the file both with excel and directly with a text editor and it seems the amount is correctly formatted


Belmontes_1-1699371467427.png

Do you guys have any idea why OS is giving us this error?

    2 replies

    M
    MikeG
    November 7, 2023

    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).


    MikeG_0-1699384483592.png

    This is what that means: (thanks Google)


    MikeG_2-1699384978726.png

     

    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.


    MikeG_1-1699384790535.png

    Hope this helps,

     

    J
    JackLacava
    November 8, 2023

    Can you post the Numeric Settings on the Amount field in your DataSource please ? I suspect something is not right there.

    Terms & ConditionsAccessibility statement