Skip to main content

Import data via general importer format files to the system

The general import format is used for importing data to FA via API. The supported options are the same as with the CSV formats explained under Importing, except the order of the columns does not have to be correct, but instead a header row is added with the column codes as provided in the documentation. An example of a simple security import CSV in general importer format:

s.securityCode;s.name;s.type;s.currency;s.status
NOKIA.HE;Nokia Corporation;E;EUR;ACTIVE
Uploading files
  1. Go to ToolsImport fileGeneral importer format files.

    dataAggregation_importGeneralImportFile1.png
  2. Click Choose file, select the file from your computer and click Upload. Finally click Confirm upload.

    dataAggregation_importGeneralImportFile2.png
  3. The file is processed in the background. When it is ready, go to the Tasks view – for example, by filtering with the file name. Make sure you check All tasks and All completed tasks lists.

    dataAggregation_importGeneralImportFile3.png
  4. Review the task details by clicking on the task title to see how many rows were imported or a list of failing rows in case there were any errors along with the reasons for the failures.

    dataAggregation_importGeneralImportFile4.png