The Counterparty Converter tool (available for Windows) will allow you to convert a structured CSV file containing counterparty information into an XML file that can be imported in Isabel 6.
You will need to have the counterparties that you want to upload to Isabel 6 in CSV (please verify the user manual of your accounting or ERP software) or a spreadsheet application (like Microsoft Office Excel or LibreOffice Calc).
This CSV (Comma Separated Value) file must have the following structure:
Account country;Alias;Name;Streetname & number;ZIP code;City;Country;blank;Phone number;2;IBAN;Local account;Free format;BIC
Please contact your IT for additional support when creating such a file.
|Account Country||Alphabetical ISO country code of the counterparty’s account||2 AN||Yes|
|Alias||Short name or code for internal use in your company||64 AN||No (if blank, original name will be used in Isabel 6)|
|Name||Full name of the counterparty||64 AN||Yes|
|Address||Address of the counterparty||64 AN||No|
|ZIP code||ZIP code of the counterparty||64 AN||No|
|City||City of the counterparty||64 AN||No|
|Country||Alphabetical ISO country code of the counterparty||64 AN||Yes|
|Blank||Should be left blank||/||/|
|Telephone||Telephone number of the counterparty||32 AN||No|
|2||Should have the value 2||1 N||Yes|
|IBAN||IBAN of the counterparty||64 AN||At least one
of these 3
must be encoded
|Local account||Local account number of the counterparty||64 AN|
|Free format||Free format of the counterparty||64 AN|
|BIC||BIC of the account||12 AN||No (recommended for foreign accounts)|
Example (you can copy and paste this to Notepad):
If you are working with a Spreadsheet application keep in mind that leading zeros are sometimes removed. In the example above 000000009797 will become 9797. Make sure this doesn't happen!
The Counterparty Converter tool will allow you to convert the structured CSV file to an XML file that can be imported in Isabel 6.
Please contact Isabel Customer Care