The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Belmontes's avatar
Belmontes
New Contributor
2 years ago

Data load input string format

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...
Data Sources
Import
Workflow
MikeG's avatar
MikeG
Contributor III
2 years ago

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,