Hi,
Does anybody get same error in currencyconv.csv file since 17th August?
It seems like the new data is not sorted according to previous column separators and it is causing the errors.
I have not changed anything in script files.
Thankful for any help.
Best Regards
Dino
CurrencyConv.csv. Each row should have exactly three column separators (' ') - ERROR. Bad records bellow:
2023-08-17 0.7394
CAD USD
2023-08-18 0.7379
CAD USD
2023-08-21 0.7384
CAD USD
CurrencyConv.csv. All rows should have 'Date' column in format YYYY-MM-DD - ERROR. Bad records bellow:
,CAD,USD,
,CAD,USD,
,CAD,USD,
CurrencyConv.csv. Minimum date in file should be configured MinDate - ERROR. Actual minimum date in file
CurrencyConv.csv. Maximum date in file should be today or before - ERROR. Actual maximum date in file 2023-08-21
CurrencyConv.csv. Date+CurrencyFrom+CurrencyTo should be unique - ERROR. Duplicate records:
,CAD,USD,
,CAD,USD,
2023-08-17,0.7394,,
2023-08-18,0.7379,,
2023-08-21,0.7384,,
Comments
In the screenshot below GetExchRates-ECB.ps1 is used and other Exchange rate extract scripts are commented out (line starts with REM).
If you are using BoC script, could you please try comment it out and enable (remove REM from the string start) ECB script and see if that works?
Also, are you using latest scripts that were released 2023-Feb?
Best Regards