Skip to Main Content

CampusShip Support - Initial Log On

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)

Town/City

Alphanumeric

30

Yes

Recipient's city

County

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.

Postcode

Alphanumeric

9

Conditional

Recipient's postcode; 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 the Recipient's address is residential
Enter 0 for a 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 the address is consignee-billable
Enter 0 if the address is not consignee-billable

Receiver's UPS Account

Alphanumeric

10

No

Third-party billing account number
Receiver's UPS Account Postcode

Alphanumeric

9

Conditional

If the Receiver's UPS Account number is supplied and if the Receiver's country requires a postcode
PO Box Indicator Numeric 1

Conditional

Enter 1 only if the 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:

  1. On the export file portion of WorldShip International, select Receivers as the export information.
  2. Select 'comma' as the only delimiter.
  3. Select 'overwrite', not append.
  4. Select only the following fields in the specific order listed as follows.

    Company or Name, Contact, Address 1, Address 2, Address 3, City Country, Postcode, County/Region, Residential Address, Telephone, Location ID, Email Address

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

  5. Export the file.
  6. Open up the .txt file that is created and confirm that the layout looks correct. Only commas should be present. Quotation marks or semi-colons should not appear.
  7. Close the file and do not save any changes.
  8. Change the file extension from .txt to .csv.
  9. 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

Town/City

Alphanumeric

30

Yes

Receiver's city or town

Country

Alphanumeric

2

Yes

Receiver's Country/Territory

Postcode

Alphanumeric or Numeric

9

Conditional

Receiver's postcode

County

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

Next Steps

View codes for U.S. States, Canadian Provinces, and countries or territories worldwide.

View State and Province CodesOpen the link in a new window

View Country or Territory CodesOpen the link in a new window