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 Help > Code lists in Unifaun Online to find carrier codes.

  • Select Services in the scroll bar Lists and click Show.

  • 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