Importing recipient accounts

Explanation

You import one or multiple recipient accounts from a CSV file. The CSV file must be structured according to a specific schema. Optional fields need not be filled. However, the columns and the column header in the CSV file must exist for optional fields also.

Make sure that the import data is ISO encoded. Otherwise, special characters in the account data will not be imported correctly.

Procedure for saving a file in MS Excel with ISO encoding

1.	Open the file in MS Excel.
2.	Click on File ➔ Save as, button Tools.
3.	Click on Web Options, tab Encoding.
4.	From the list Save this document as: select the entry Western European (ISO).

File structure

The first line contains the following column titles. The second and subsequent lines contain the account data.

Column	Max. field length	Description
RECIPIENT_NAME	70	Name of the recipient
RECIPIENT_ID	50	Optional: ID of the recipient
RECIPIENT_STREET	140	Optional: street and house number of the recipient
RECIPIENT_CITY	140	Optional: city of the recipient
RECIPIENT_COUNTRY_CODE_ISO	2	ISO country code of the recipient
RECIPIENT_PHONE	50	Optional: phone number of the recipient
RECIPIENT_EMAIL	50	Optional: e-mail address of the recipient
ACCOUNT_COUNTRY_CODE_ISO	2	Optional: ISO country code of the recipient account
IBAN	34	Optional: IBAN of the recipient account
BIC	11	Optional for German accounts: BIC of the recipient account
NATIONAL_ACCOUNT_NUMBER	35	Optional for German accounts, if IBAN specified: national account number
NATIONAL_BANK_CODE	11	Optional for German accounts, if IBAN specified: national bank code
ESR_NUMBER_CH	11	Optional, only for Swiss accounts: reference number of the inpayment slip
BANK_NAME	50	Optional: name of the recipient bank
BANK_STREET	50	Optional: street and house number of the recipient bank
BANK_CITY	50	Optional: city of the recipient bank
POSTAL_ACCOUNT_NUMBER_CH	50	Optional, only for Swiss accounts: postal account number of the recipient bank
CORRESPONDING_ACCOUNT	140	Optional, correspondent account
CLEARING_SYSTEM_CODE	2	Optional, national clearing system code
DESCRIPTION	140	Optional, account name

You can easily create an import file by exporting existing recipient accounts from the application.

Proceed as follows:

1.	In the menu Settings ➔ Customer settings, select the tab Recipient accounts.
2.	In the mask area CSV file, click on Export.
3.	Save the export file.

The export file contains an additional meta data area (lines 1-3) which is, however, optional for an import file.

Procedure

Create the import file with a suitable editor or programme, for example MS Excel.

In the application, select Settings ➔ Customer settings and the tab Recipient accounts.

Procedure via the button Import:

In the mask area CSV file, click on Import.

Drag and drop the import file onto the corresponding mask area.

Note:

Alternatively, click on Select file and navigate to the import file using the file explorer.

Drag and drop the import file directly into the list view of the tab Recipient accounts.

From the selection list Import mode, select how the data shall be imported. The import modes have the following meaning:



Create

New accounts from the import file are created, while existing accounts are not changed.



Update

New accounts from the import file are created and existing accounts are adapted.



Replace

All existing accounts are deleted and accounts from the import file are created.

Click on Import.

The following mask displays the result of the import.

If the application detects errors in the import file, an error file with the erroneous data records is offered for download.

You can edit the data records in the error file and restart the import. The error file contains the correct import format.

After confirmation, the imported data is displayed on the tab Recipient accounts.