How to Import Exchange Rates

Exchange rates fluctuate on a regular basis and the value of the exchange rate can vary depending on the source of the exchange rates. There could be many exchange rates that are required to be updated on a regular basis and you are able to import this data from a csv file into the exchange rate table.

The file should be a comma separated variable (.CSV) format and file structure has a fixed definition described below.

Exchange Rate Import File Format
Header Row
Field	Description	Rules	Mandatory	Format
The header row contains column name.		Row 1 within the import file will be ignored when importing. The row is for information purposes only and can contain any text for the column name.	Y	Alpha numeric
Body
Field	Description	Rules	Mandatory	Format
Effective date	Start date of the currency	The effective date must be greater than the maximum effective date for the specified From Currency Code and To Currency Code. If the effective date already exists for the currency code combination and error will be output. Any data that passes validation will be inserted into the exchange rate table. In other words, you are not able to update existing exchange rates. The date format must be YYYY-MM-DD	Y	Date
From Currency Code	This is the currency that you are converting from	The currency code must be the standard 3 character code issued by ISO 4217.	Y	Alpha numeric (3)
To Currency Code	This is the currency that you are converting to	The To Currency Code cannot be the same as From Currency code. The currency code must be the standard 3 character code issued by ISO 4217.	Y	Alpha numeric (3)
Forward Rate	Value of currency converting to	A value must be provided. It cannot be negative.	Y	Numeric
Reverse Rate	Value of the currency when converting back to from currency rate	This is calculated by the system automatically upon import. This is calculated as 1/forward rate. This is an optional field. If not supplied, the value will be calculated.	N	Numeric

A sample file layout would be:

Effective Date	From Currency	To Currency	Forward Rate
2018-06-22	GBP	HKD	10.4235
2018-06-22	GBP	EUR	1.1258
2018-06-22	GBP	USD	1.2812

Where rows did not pass validation an error report will be output listing the rows that did not import and the reason that caused the exception. All successful rows will be imported.

How to Import Exchange Rates

1.	Navigate to Maintenance > Currency > Exchange Rates
2.	Click Import. A Windows dialog box opens
3.	Locate the import file and click on in the Windows dialog box. The import will commence.
4.	Once the import has completed, a confirmation message will display in the Exchange Rates Search screen confirming successful import.
5.	Any errors will be output in an error report and will be indicated in the Exchange Rates Search screen if errors exist. If no errors exist, skip this step.
6.	To review the imported rates, click Search after completing the required search criteria.