How to upload counterparties to Isabel 6?

Document ID: 1176
Modified: 14/08/2023
XML Structure

XSD Scheme

Example XML

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

TXT 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:

<Counterparty>;<Selection Field>

And at most three parts: 

<Counterparty>;<Selection Field>;<BenificiaryAccount block>

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

Importing your file into Isabel 6

  1. To import your file, sign in to Isabel 6 and navigate to the tab Transactions > Counterparties (in the left menu) > Upload of counterparties.
  2. In step 1 "Upload of counterparties", select your file using the Browse button. Choose Next to continue.
  3. A list of found counterparties will be displayed. Depending on the amount of counterparties this might take some time.
  4. 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. )

  5. Click Next. 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.
How to upload counterparties to Isabel 6?
1176
14/08/2023