DTW import of exchange rates ORTT Table fails with decimal values

[Former Member]

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

[kothandaraman_nagarajan · Accepted solution]

Please check SAP note 2214046 for workaround.

[Former Member · Accepted solution]

how can i access note 2214046 ?

thx

[kothandaraman_nagarajan · Accepted solution]

You can access from SAP Business one customer and its requires valid S-user ID and password.

[Former Member · Accepted solution]

Thanks Nagarajan for your help.

Whenever I copy paste your note number, it brings me back to to our current conversation.. which isn't of any further help.

Could you please briefly explain what was the workaround solution about ?

Kind Regards,

Olivier

[kothandaraman_nagarajan · Accepted solution]

workaround

If your  Operation system format is French(France), then change the operation system format to English(UK or US) through Control Panel -> Region and Language -> Formats Tab.

[Former Member · Accepted solution]

Thanks for your kind support.

Actually, the issue is not related to the way my regional settings generate my comma separated csv file or tab separated txt file. When I open the file with a notepad, the data is clean.

My real issue is that wherever I put a number with a digit -  (.) dot in France - the import fails. I have even tried to use tabulated separated txt file with (,) comma as digit symbol : fails too which makes sense as my sap b1 settings use the (.) dot as the digit symbol.

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please check with SAP support. The above workaround was provided by SAP.

[Former Member · Accepted solution]

Thanks all for your help.

After few unsuccessful attempts, I have finally managed to execute the import.

That is the format of the file that was successful :

Date               Currency               Value

Date               Currency               Value

09.02.2016     USD                      0,896

Basically

• the formats that works for the date are : dd.mm.yyyy OR dd-mm-yyyy (instead of the usual yyyymmdd format used in most dtw templates)
• the format that work for the decimal separator of the value is the comma (,) (despite the fact that the dot (.) is specified as the decimal separator in the general settings)

I hope this can help anyone willing to import the exchange rates with the DTW.

Regards,

Olivier

[kothandaraman_nagarajan · Accepted solution]

Hi,

Thanks for sharing your solution with us.

Best Regards,

Nagarajan

[frank_wang6]

try Tab separated file.

Frank

[Former Member]

Thanks for your answer Frank.

I had already tried Tab separated text file ; does not work neither....

Olivier

[frank_wang6]

change the date format to 06-02-2016

[Former Member]

Thanks again for your message Frank.

Unfortunately, I have just tried your advice, but i have the same problem with '06-02-2016' format : it works if value is a number with no decimal BUT does not work with a number with a decimal (object 65171 error).

Got any other clue ?

Thanks in advance for your help.

[kothandaraman_nagarajan]

Hi,

The date format should be YYYYMMDD.

Thanks

[Former Member]

Thanks for your answer Nagarajan !

Unfortunately, date YYYYMMDD format does not work at all.

My problem is not the the date format. My problem is the value format that does not seem to accept a value with decimal... It works just fine with values with no decimal (integers) but does not work with values with decimal. I really have no clue of the issue...

Any help most welcomed.

Olivier