How to Load Past 90-days of Rates in the Exchange Rate Import Tool

Subject:

The steps here explain how to load the past 90-days of rates in the Exchange Rate Import tool if you use the European Central Bank as your data source.

Resolution:

1. Open the Exchange Rate Import tool on the server.
2. On the menu bar, click Configuration and select the Configuration ID.
3. Click Service tab.
4. Replace the URL to the Exchange Rate Service with the following.

http://www.ecb.europa.eu/stats/eurofxref-daily.xml

5. Click the Save button.
6. Click the Get Rates button.  This loads rates for the last 90-days.

7. When finished, click Configuration and select the configuration ID again.
8. Select the Service tab.
9. Click the Default button to reset the URL back to normal.
10. Click the Save button and close the Exchange Rate Import window.