Import from CSV general

It is possible to import FX Deals, and Guarantees from a CSV file.

Open Autopilot / Integrations and add a new CsvFxDealImporter, CsvGuaranteeDealImporter:

The order of the COLUMN MAPPINGSs in the Settings tab is important if the imported file does not contain headings. If there are headings in the file, the order does not matter.

Import file WITH headers

Make sure the CONTAINS HEADERS checkbox is checked.

Add Column mappings and enter the header names in column File Header and map to relevant field from the drop down list in the System Field column.

Import file WITHOUT headers

Make sure the CONTAINS HEADERS checkbox is NOT checked.

Add Column mappings. Headers can be, but does not have to be, entered.

CULTURE determines how numbers are represented.

DELIMITER specifies the delimiter used in the CSV file. Most common is semicolon. 

In TAB Mappings you MUST map different legal entities and counterparties that are included in the import file. If other TAGs are included in the file, they must also be mapped.

For example, in the view above, all Deals will have TAG VALUE "Treasury" as a legal entity.

You need to map both Legal entity and Counterpart even if they have the same value in the import file.

Details on importing Guarantees are described in article Import of guarantees

Details on importing FX is found in the article Import of FX.