Page Comparison

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

AlphaNum

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

AlphaNum

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

AlphaNum

Alpha numeric (3)
Forward Rate	Value of currency converting to	A value must be provided. It cannot be negative.	Y

Num

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

Num

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

How to Import Exchange Rates

...

1.
Go
Navigate to
Portal
Maintenance > Currency > Exchange Rates
2.
Click
on
Import.
A Windows dialog box opens
Image Added
3.
Locate the import file and click on in the Windows dialog box.
The import will commence.
Image Added
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.
Image Added

Versions Compared

Old Version 1

New Version Current

Key

How to Import Exchange Rates

Import. A Windows dialog box opens	Image Added
3.	Locate the import file and click on in the Windows dialog box. The import will commence.	Image Added
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