Skip to Content
1
Former Member
Feb 06, 2016 at 04:07 PM

DTW import of exchange rates ORTT Table fails with decimal values

320 Views

Hello,

I encounter a problem when I use DTW to import exchange rates to fill the ORTT table.

Here is the structure of the CSV comma separated file I upload :

Date Currency Value Date Currency Value 06.02.2016 USD 2

Whenever value has no decimal (example here : 2), the import runs smoothly with no problem.

Date Currency Value Date Currency Value 06.02.2016 USD 2.2

However, when the value has a decimal (example : 2.2), the import fails !

As the company is French the dot (.) is set as the decimal symbol.

Any help and thoughts would be much appreciated.

Regard,

Olivier