UPS CampusShip: Import File Format: Address Books

Personal and Corporate Address Book Imports

Review the import file format table for address book entry import files. All files must be saved with a .csv extension with a comma as the field delimiter. Use a comma to separate the information for each field. If a field is empty, a comma is required to "skip" to the next field. Therefore, the format could contain multiple commas in a row without spaces, as shown in the "required fields only" sample below.

Note: Various import files have limitations detailed in Tips for Effective File Importing.

Sample record with all fields:
TestCompany,TestNickname,JoeTester,123 Main Street,4th Floor, Accounting Department,Atlanta,GA,30350,US,770-555-1234,1234,joe@company.com,770-555-4321,1,1234567891,0
Sample record with required fields only:
TestCompany,,,123 Main Street,,,Atlanta,GA,30350,US,,,,,

Note: Column headers should not be included. Also, it is recommended that you save this export file layout for future use.

File Format for Personal and Corporate Address Books
Field Name	Field Type	Max Field Length	Required	Valid Values
Company or Name	Alphanumeric	35	Yes	Company or Name for the address
Nickname	Alphanumeric	35	No	Identifier used to save and recall the address (Address Book description text)
Contact	Alphanumeric	35	No	Contact name of recipient
Address 1	Alphanumeric	35	Yes	Recipient's street address
Address 2	Alphanumeric	35	No	Additional address information (room, floor, apartment)
Address 3	Alphanumeric	35	No	Additional address information (department)
City	Alphanumeric	30	Yes	Recipient's city
State/Province	Alphanumeric	5	Conditional	Recipient's State or Province for U.S. and Canada; see State/Province table for valid codes. Required for U.S. and Canadian addresses.
Postal Code	Alphanumeric	9	Conditional	Recipient's postal code; will be validated for U.S. and Canada
Country	Alphanumeric	2	Yes	Recipient's country; see country or territory code table for valid codes
Telephone	Alphanumeric	15	No	Recipient's telephone number
Extension	Alphanumeric	4	No	Recipient's telephone extension
E-Mail Address	Alphanumeric	50	No	Recipient's e-mail address; example: jdoe@somecompany.com
Fax Number	Numeric	15	No	Recipient's fax number
Residential Address	Numeric	1	Yes	Enter 1 only if Recipient's address is residential Enter 0 for non-residential address
Location ID	Alphanumeric	10	No	Use this unique identifier, created by a Quantum View administrator, to indicate a receiving department in a building with multiple receiving areas.
Consignee Indicator	Numeric	1	No	Enter 1 if address is consignee billable Enter 0 if address is not consignee billable
Receiver's UPS Account	Alphanumeric	10	No	Third party billing account number
Receiver's UPS Account ZIP Code	Alphanumeric	9	Conditional	If Receiver's UPS Account number is supplied and if Receiver's country requires a postal code
PO Box Indicator	Numeric	1	Conditional	Enter 1 only if address is a PO Box; Enter 0 for a non-PO Box address

UPS WorldShip International Address Book Imports

To import a Worldship International Address book into CampusShip, you will need to follow these steps:

On the export file portion of Worldship International, select Receivers as the export information.
Select "comma" as the only delimiter.
Select "overwrite", not append.
Select only the following fields in the specific order listed as follows.

Company or Name, Contact, Address 1, Address 2, Address 3, City Country, Postal Code, State/Province, Residential Address, Telephone, Location ID, E-Mail Address

Note: Column headers should not be included. Also, it is recommended that you save this export file layout for future use.
Export the file.
Open up the .txt file that is created and confirm that the layout looks correct. Only commas should be present. Quotation marks or semicolons should not appear.
Close the file and do not save any changes.
Change the file extension from .txt to .csv.
Import the .csv file into CampusShip.

Note: Remember to select Worldship International as the import file format.

File Format for WorldShip Addresses
Review the import file format table for address books created in UPS WorldShip format. All files must be saved with a .csv extension with a comma as the field delimiter before you can import them.
Field Name	Field Type	Maximum Field Length	Required	Valid Values
Company or Name	Alphanumeric	35	Yes	Receiver's company name
Contact	Alphanumeric	35	No	Name of the contact at the Receiver's address
Address 1	Alphanumeric	35	Yes	First line of the Receiver's address
Address 2	Alphanumeric	35	No	Second line of the Receiver's address
Address 3	Alphanumeric	35	No	Third line of the Receiver's address
City	Alphanumeric	30	Yes	Receiver's city or town
Country	Alphanumeric	2	Yes	Receiver's Country/Territory
Postal Code	Alphanumeric or Numeric	9	Conditional	Receiver's postal code
State/Province	Alphanumeric	5	Conditional	Receiver's state, province, or county
Residential Address	Numeric	1	Yes	To be used if the receiver is located in a personal residence. 1 = Residential 0 = Non-Residential
Telephone	Numeric	15	Conditional	Required for international destinations and UPS Next Day Air Early A.M. service
Location ID	Alphanumeric	10	No	Use this unique identifier, created by a Quantum View administrator, to indicate a receiving department in a building with multiple receiving areas.
E-Mail Address	Alphanumeric	50	No	E-mail address where an e-mail is sent notifying the customer that the shipment has been sent. For Electronic Return Label, this is the e-mail address where UPS sends the label

Address Books
Import File Format: Address Books