File structure
The import file must have the following structure and content:
ISO -8859-1 (Windows ANSI) or UTF-8 encoding.
Records that are separated by a line break.
Headers (top row) must be spelled correctly and appear in square brackets, for example, [quickid]. You only need to include headers that you want to import. If a header shouldn't be used, it's important to remove it, not just delete the content.
Open an example file in a text editor or Microsoft Excel to see what it should look like.
Customer and address information
Header | Description | Type | Value |
---|---|---|---|
[quickid] | Quick ID for the address party. Often the customer number or similar in the system you retrieve the information from. | string | |
[sender] | Indicates if it is a sender. When you import senders, the value must be "Y" and you must check the Sender box in the GUI. If the field does not exist in the file the address will be entered as sender if the box is checked in the GUI. | boolean | Y, N |
[receiver] | Indicates if it is a receiver. When you import receivers, the value must be "Y" and you must check the Receiver box in the GUI. If the field does not exist in the file the address will be entered as receiver if the box is checked in the GUI. | boolean | Y, N |
[orgno] | Organization registration number | string | |
[vatno] | VAT number | string | |
[category1text] | Used for categorizing entries, e.g. A1 | string | |
[category2text] | Used for categorizing entries, e.g. VIP2019 | string | |
[category3text] | Used for categorizing entries, e.g. Import date 20190624 | string | |
[category1no] | Used for categorizing entries, e.g. 1234 | integer | |
[category2no] | Used for categorizing entries, e.g. 2019 | integer | |
[category3no] | Used for categorizing entries, 20190624 | integer | |
[category4no] | Used for categorizing entries, e.g. 1234 | integer | |
[category5no] | Used for categorizing entries, e.g. 2019 | integer | |
[category6no] | Used for categorizing entries, e.g. 20190624 | integer | |
[name] | Name of the address party (organization or private person) | string | |
[address1] | Delivery address, line 1 (street address, unit or department) | string | |
[address2] | Delivery address, line 2 (street address, if unit or department has been entered in line 1) | string | |
[zipcode] | Delivery zip code, without country code | string | |
[city] | Delivery city | string | |
[state] | Delivery code for state in certain countries | string | |
[country] | Delivery country code in ISO 1366-2 format | string | SE, DK, NO, FI, etc. |
[contact] | Contact person for address party | string | |
[email] | Email address | string | |
[phone] | Phone number | string | |
[fax] | Fax number | string | |
[sms] | SMS number | string | |
[doorcode] | Door code | string | |
[postaladdress1] | Postal address, line 1 (street, PO box, unit or department, if different from delivery address) | string | |
[postaladdress2] | Postal address, line 2 (street, PO box, if unit or department has been entered in line 2 and if different from delivery address) | string | |
[postalzipcode] | Postal zip code, without country code (if different from delivery zip code) | string | |
[postalcity] | Postal city (if different from delivery city) | string | |
[postalstate] | Postal code for state (if different from delivery state) | string | |
[postalcountry] | Postal country code in ISO 1366-2 format | string | SE, DK, NO, FI, etc.) |
[deliv1] | Delivery instructions, line 1 | string | |
[deliv2] | Delivery instructions, line 2 | string | |
[deliv3] | Delivery instructions, line 3 | string | |
[deliv4] | Delivery instructions, line 4 | string | |
[receiverref] | Receiver reference | string | |
[senderref] | Sender reference | string | |
[codref] | Payment reference for COD/Efterkrav | string | |
[profilegroup] | Name of the profile group that the sender/receiver should be stored in. If the field is left blank the sender/receiver will be stored in the default profile group. | string |
Account for COD/Efterkrav
Header | Description | Type | Value |
---|---|---|---|
[account_1_type] | Type of account (some accounts can be in text or OCR) | string | PGTXT, PGOCR, BGTXT, BGOCR, IBAN |
[account_1_number] | Account number | string | |
[account_1_bic] | BIC code (only used if the account type is IBAN) | string | |
[account_2_type] | Type of account (some accounts can be in text or OCR) | string | PGTXT, PGOCR, BGTXT, BGOCR, IBAN |
[account_2_number] | Account number | string | |
[account_2_bic] | BIC code (only used if the account type is IBAN) | string | |
[account_3_type] | Type of account (some accounts can be in text or OCR) | string | PGTXT, PGOCR, BGTXT, BGOCR, IBAN |
[account_3_number] | Account number | string | |
[account_3_bic] | BIC code Only used if the account type is IBAN | string | |
[account_4_type] | Type of account (some accounts can be in text or OCR) | string | PGTXT, PGOCR, BGTXT, BGOCR, IBAN |
[account_4_number] | Account number | string | |
[account_4_bic] | Type of account (some accounts can be in text or OCR) | string | |
[account_5_type] | Type of account (some accounts can be in text or OCR) | string | PGTXT, PGOCR, BGTXT, BGOCR, IBAN |
[account_5_number] | Account number | string | |
[account_5_bic] | Type of account (some accounts can be in text or OCR) | string |
Carrier information
Go to Unifaun Online to find carrier codes.
> inSelect Services in the scroll bar Lists and click .
Use the code that is to the left of the carrier's name (bold text).
In the field names below "xxx" should be replaced with the carrier code.
Header | Description | Type | Value |
---|---|---|---|
[partner_xxx_custno] | Customer number | string | |
[partner_xxx_palletregno] | Pallet registration number | string | |
[partner_xxx_retailerid] | Retailer ID | string | |
[partner_xxx_sortpos] | Code for sorting position | string | |
[partner_xxx_destcode] | Sorting code | string | |
[partner_xxx_paymentmethod] | Code for payment method for letters | string | |
[partner_xxx_ediaddress] | EDI address | string | |
[partner_xxx_deliveryaddressref] | Delivery address reference | string | |
[partner_xxx_bookingid] | Booking number | string | |
[partner_xxx_bookingoffice] | Booking office | string | |
[partner_xxx_senderid] | Customer number as prefix to shipment id | string | |
[partner_free_<name>_custno] | Customer number for neutral carrier Example: [partner_free_joanjet_custno] | string | |
[partner_free_<name>_palletregno] | Pallet registration number for neutral carrier Example: [partner_free_joanjet_palletregno] | string |
Other
Header | Description | Type | Value |
---|---|---|---|
[system_integration] | Indicates if the address party is used for system integration. | boolean | Y, N |