DWC import csv change number notation

[rphss]

Hi all,

I came across that while importing decimals into a new table (first time import), you have to define the column

notation like 1.234,56 .

Seems we missed that once and while uploading the second time, numbers like above were uploaded as 1,23456 even the preview of the upload shows correct information 1.234,56. But after importing number was wrong.

Importing the same csn again was not helping (overwrite table). Only creating new table considering the correct column format was solving it.

So does someone now where to change the column notation (as it must be set somewhere) in any table o DB which can be change.

PS. I am not talking about the field definintion decimal 15 2 . This is not helping eihter.

Ralf

[former_member12523]

Hi Ralf-Peter,

we had the same issue with the Timestamp Data Type. Do you have any solution except for creating a new table?

Nick