Page tree
Skip to end of metadata
Go to start of metadata

Introduction

Exchanges rates can be imported from a CSV file.

Description

Import CSV Data 

Exchanges rates can be imported from a CSV file. Each type of rate must be imported separately. 

Exchange rate type

Select from the drop down list the type of rates that will be imported.

Data file

The location of the data file. The can be used to open a file browser to navigate to the file location.

OK

Starts the import and closes the pop-up window.

Cancel

Closes the pop-up window and cancels the importation of the file.

File Format 

The import file must have the following format:

  • CSV-Format (Semi-colon delimited file)
  • with column headings according to the following description

Column

Column heading

Description

1

baseCurrency

The tree didgit alpha-numeric currency code

2

rate

Exchange rate with a decimal place.

3

unit

Unit size

4

directQuotation

Indirect Quotation = 0 / Direct Quotation = 1

5

validFrom

valid date in the format DD.MM.YYYY

Example:

baseCurrency;rate;unit;directQuotation;validFrom
USD;1,2370;1;0;15.11.2010