If you have your address book in another system you can import it to nShift Delivery. You can add the entries as senders, receivers or both. The prerequisites are that you can export the name and address information, edit the data and create a tab-delimited text file.
Sections in this article:
Import the file
- Go to Maintenance > Senders or Maintenance > Receivers and click Import.
- After adding the file, select ”Standard, address (Tab separated)” as Import type and, in most cases, "ISO-8859-1" as Character encoding.
- Check the Also import as receiver/Also import as sender box if the address party should act as both sender and receiver.
- Check the Replace matching quick ID box if you want existing information to be replaced by information from the file for address parties with the same unique quick ID. (It is recommended to select this setting to avoid duplicates).
- Click Import. If you get an error message saying that the file is incorrect, check the file structure and contents. Make the necessary changes and try to import the file again.
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 should not be used, it is important to remove it, not just delete the content.
Download an example file here.
Overview of fields
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, for example, A1 |
string |
|
|
[category2text] |
Used for categorizing entries, for example, VIP2019 |
string |
|
|
[category3text] |
Used for categorizing entries, for example, Import date 20190624 |
string |
|
|
[category1no] |
Used for categorizing entries, for example, 1234 |
integer |
|
|
[category2no] |
Used for categorizing entries, for example, 2019 |
integer |
|
|
[category3no] |
Used for categorizing entries, 20190624 |
integer |
|
|
[category4no] |
Used for categorizing entries, for example, 1234 |
integer |
|
|
[category5no] |
Used for categorizing entries, for example, 2019 |
integer |
|
|
[category6no] |
Used for categorizing entries, for example, 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
|
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
- To find carrier codes, go to Help > Code lists in nShift Delivery.
- 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 |
Download example file
Download the example file and open it in a text editor or Microsoft Excel to see what it should look like.