How to upload counterparties to Isabel 6?

Views:

XML Structure

All fields are mandatory but do not necessarily requre a value. Mandatory values are marked in bold.
The field delimiter is ; . This requires that the delimiter character ; is not used inside the data fields.

A line has minimum two parts:

And at most three parts:

The <Selection field> value decides if there is a third block on the line and if there is, which kind of block.
This <Selection field> has an integer value ‘0' or '2’:

0 - this line will not contain a Beneficiary Account.
2 - this field will be followed by a <BeneficiaryAccount block>

Counterparty without Beneficiary Account

XC1;XC2;XC3;XC4;XC5;XC6;XC7;XC8;XC9;XC10;XC11;XC12;XC13;XC14;XC15;XC16;XC17;0

Counterparty + BeneficiaryAccount

XC1;XC2;XC3;XC4;XC5;XC6;XC7;XC8;XC9;XC10;XC11;XC12;XC13;XC14;XC15;XC16;XC17;2;XCA1;XCA2;XCA3;XCA4

Referring to the examples below we can identify the following parts in the Flat File line

Counterparty	XC1	AccountCountry
	XC2	Alias
	XC3	Name
	XC4	Department
	XC5	SubDepartment
	XC6	StreetName
	XC7	BuildingNumber
	XC8	Room
	XC9	BuildingName
	XC10	Floor
	XC11	PostalBox
	XC12	PostCode
	XC13	TownName
	XC14	TownLocationName
	XC15	DistrictName
	XC16	CountrySubDivision
	XC17	Country
Selection field		‘0' - empty block (end of line) '2’ - beneficiary account block
BeneficiaryAccount	XCA1	Account_IBAN
	XCA2	Account_Local
	XCA3	Account_Free
	XCA4	BankSwift

XCA1 XCA2 XCA3 are different representation formats for the same account. If a same Counterparty has multiple (different) accounts, repeat the Counterparty line as many times as there are different accounts for this Counterparty.

Isabel 6 stores either a local either a free account, but not both. If a value is provided for XCA2, the value for XCA3 is ignored.

Example TXT File

right click + "Save as" to download

Importing your file into Isabel 6

To import your created XML file, sign in to Isabel 6 and navigate to the tab Transactions > Counterparties (in the left menu) > Upload of counterparties.
In step 1 "Upload of counterparties", select your XML file using the Browse button. Choose Next to continue.
A list of found counterparties will be displayed. Depending on the amount of counterparties this might take some time.
Use the first column to select the counterparties that you want to import or use the checkbox in the header to select all counterparties. The column Shared is only displayed if you have the module MultiSign.
In the next step you will be asked to validate the import:
- If no errors occured, you can click on Finish to exit the wizard.
- If errors did occur, they will be listed. In the column "Error report" more information will be displayed about the error (ex. duplicates, invalid account number,...). Please review them to prevent issues is the future.