Some problems with currency import

Lapshin · 2017-03-13

Hi, friends!
I have obscure problem with currency import.
So, I wrote report for updating exchange rate from European central bank at it starts every day under NAS as a job queue. It works fine during two weeks, but then it failed. Report works, but exchange rate load wrong, look at screenshot. It is so strange, because I can not catch error with debugger, report works correctly if I start him in manual mode (from development environment).

muca · 2017-03-13

ecb has moved update time http://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html
I think You should synchronize Your NAS Scheduler Job with ECB

Lapshin · 2017-03-13

muca, it not works..

Remco_Reinking · 2017-03-14

Please make sure your regional settings are correct, or make sure you can validate this in your code.
Could be something like this:

  TestDec := 10.23;
  Dec2Txt := FORMAT( TestDec);
  IF Dec2Txt = '10,23' THEN
    EVALUATE( ExchangeRate, CONVERTSTR(XMLAttribs.getNamedItem('rate').text,'.',','))
  ELSE
    EVALUATE( ExchangeRate, XMLAttribs.getNamedItem('rate').text);

Some problems with currency import

Answers

Categories