Hi,

We have a requirement to export the BAAN data into a .CSV file and then after doing required modifications in the .CSV file we need to import back the data into BAAN.

When we open the .CSV file for modifications the Leading Zeros are getting suppressed. And this will give error / won’t update the records while trying to import the data back into BAAN.

Could you please let me know how can we have the Leading Zeros UN-suppressed? (Because BAAN can have the ITEM as 000000222 & 222 and these both are different items)

Thanks in advance.

Thanks and Regards,
Sagar

Which application are you using to edit the data ?

If it's Excel step3 of the import wizard allows you to set the column format as text. This will preserve the leading zeros.

Cheers
Neal

Sagar,

This is a limitation of the CSV fileformat. However this is a workaround if you are only working with Excel.

For fields that are of type String, make the following modification. If your output is
Item, Description, Price

="000000222", ="Description of Item 000000222", 100.27
="222", ="222", 6.14

While csv may open directly without text2data wizard and u may need to use " as enclosing character in ur exchange schema , there is 3rd alternative to format the column / cells with number format like "000000" which will save 222 as 000222 in csv and u can use the same.
Beware whenever u open csv again this leading 0s will get suppressed .

U can use whatever alternative convenient to u.

Hi Neal Matthews ,
I am using the EXCEL to edit the data.
If i format the cell as you said it is preserving the data for the first time but the next time when i open it is not preserving it (i mean it is suppressing the leading zeros).

How to avoid it?

regards,
Sagar

Which format are you saving the Excel file as ?

See attached doc. Hope this helps

Cheers
Neal