Skip to Main Content
Search

Using Import Tools FAQ

What is the correct import file format for address books?

File Format for personal and Corporate Address Books

Review this table for the format for your Personal or Corporate Address Book import file. All files must be saved with a .csv extension with the comma as the field delimiter. The import file must include the comma delimiter even for optional fields.

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

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.

Postcode

Alphanumeric

9

Conditional

Recipient's postcode; will be validated for U.S. and Canada

Country

Alphanumeric

2

Yes

Recipient's country; see Country Code table for valid codes

Telephone

Alphanumeric

15

No

Recipient's telephone number

Extension

Alphanumeric

4

No

Recipient's telephone extension

Email Address

Alphanumeric

50

No

Recipient's email 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

A 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

Format for UPS WorldShip International Address Books

Review this table for the format for Address Book import file if it was created using UPS WorldShip. All files must be saved with a .csv extension with the comma as the field delimiter. The import file must include the comma delimiter even for optional fields.

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, 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.
  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 semicolons 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

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

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 service

Location ID

Alphanumeric

10

No

A unique identifier, created by a Quantum View administrator, to indicate a receiving department in a building with multiple receiving areas.

Email Address

Alphanumeric

50

No

Email address where an email is sent notifying the customer that the shipment has been sent. For Electronic Return Label, this is the email address where UPS sends the label

Back to Top

What are the state codes for the import files?

The following table lists the two-character state codes needed for the Global Address and Location import files. Records with an invalid state code will not be imported.

State Codes and Canadian Province Codes

States

Codes

Alabama

AL

Alaska

AK

Arkansas

AR

Arizona

AZ

California

CA

Colorado

CO

Connecticut

CT

Delaware

DE

District of Columbia

DC

Florida

FL

Georgia

GA

Hawaii

HI

Idaho

ID

Illinois

IL

Indiana

IN

Iowa

IA

Kansas

KS

Kentucky

KY

Louisiana

LA

Maine

ME

Maryland

MD

Massachusetts

MA

Michigan

MI

Minnesota

MN

Mississippi

MS

Missouri

MO

Montana

MT

Nebraska

NE

Nevada

NV

New Hampshire

NH

New Jersey

NJ

New Mexico

NM

New York

NY

North Carolina

NC

North Dakota

ND

Ohio

OH

Oklahoma

OK

Oregon

OR

Pennsylvania

PA

Rhode Island

RI

South Carolina

SC

South Dakota

SD

Tennessee

TN

Texas

TX

Utah

UT

Vermont

VT

Virginia

VA

Washington

WA

West Virginia

WV

Wisconsin

WI

Wyoming

WY

Canadian Provinces

Codes

Alberta

AB

British Columbia

BC

Manitoba

MB

New Brunswick

NB

Newfoundland

NF

Northwest Territory

NT

Nova Scotia

NS

Nunavut

NU

Ontario

ON

Prince Edward Island

PE

Québec

QC

Saskatchewan

SK

Yukon Territory

YT

Back to Top

What are the country codes for the import files?

The following table lists the correct two-character country codes needed for the Global Address and Location import files. Records with an invalid country code will not be imported.

Country Codes

The following table lists country codes.

Country

Code

Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antigua & Barbuda
Argentina
Armenia
Aruba
Australia
Austria
Azerbaijan
Azores

AL
DZ
AS
AD
AO
AI
AG
AR
AM
AW
AU
AT
AZ
PT

Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bonaire
Bosnia and Herzegovina
Botswana
Brazil
British Virgin Islands
Brunei
Bulgaria
Burkina Faso
Burundi

BS
BH
BD
BB
BY
BE
BZ
BJ
BM
BT
BO
BQ
BA
BW
BR
VG
BN
BG
BF
BI

Cambodia
Cameroon
Canada
Canary Islands
Cape Verde
Cayman Islands
Central African Rep
Chad
Chile
Colombia
Congo
Congo, Democratic Rep
Cook Islands
Costa Rica
Côte d'Ivoire
Croatia
Curacao
Cyprus
Czech Republic

KH
CM
CA
IC
CV
KY
CF
TD
CL
CO
CG
CD
CK
CR
CI
HR
CB
CY
CZ

Denmark
Djibouti
Dominica
Dominican Republic

ZR
DK
DJ
DM
DO

Ecuador
East Timor
Egypt
El Salvador
England
Equatorial Guinea
Eritrea
Estonia
Ethiopia

EC
TL
EG
SV
EN
GQ
ER
EE
ET

Faroe Islands
Fiji
Finland
France
French Guiana
French Polynesia

FO
FJ
FI
FR
GF
PF

Gabon
Gambia
Georgia
Germany
Ghana
Gibraltar
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guernsey
Guinea
Guinea-Bissau
Guyana

GA
GM
GE
DE
GH
GI
GR
GL
GD
GP
GU
GT
GG
GN
GW
GY

Haiti
Holland
Honduras
Hong Kong
Hungary

HT
NL
HN
HK
HU

Iceland
India
Indonesia
Iraq
Israel
Italy

IS
IN
ID
IQ
IL
IT

Jamaica
Japan
Jersey
Jordan

JM
JP
JE
JO

Kazakhstan
Kenya
Kiribati
Kosrae
Kuwait
Kyrgyzstan

KZ
KE
KI
FM
KW
KG

Laos
Latvia
Lebanon
Lesotho
Liberia
Liechtenstein
Lithuania
Luxemburg

LA
LV
LB
LS
LR
LI
LT
LU

Macau
Macedonia
Madagascar
Madeira
Malawi
Malaysia
Maldives
Mali
Malta
Marshall Islands
Martinique
Mauritania
Mauritius
Mexico
Micronesia
Moldova
Monaco
Mongolia
Montenegro
Montserrat
Morocco
Mozambique

MO
MK
MG
PT
MW
MY
MV
ML
MT
MH
MQ
MR
MU
MX
FM
MD
MC
MN
ME
MS
MA
MZ

Namibia
Nepal
Netherlands
Netherlands Antilles
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
Norfolk Island
Northern Ireland
Northern Mariana Islands
Norway

NA
NP
NL
AN
NC
NZ
NI
NE
NG
NF
NB
MP
NO

Oman

OM

Pakistan
Palau
Panama
Papua New Guinea
Paraguay
People's Republic of China
Peru
Philippines
Poland
Ponape
Portugal
Puerto Rico

PK
PW
PA
PG
PY
CN
PE
PH
PL
FM
PT
PR

Qatar

QA

Republic of Congo
Republic of Ireland
Republic of Yemen
Réunion
Romania
Rota
Russia
Rwanda

CG
IE
YE
RE
RO
MP
RU
RW

Saba
Saipan
Samoa
San Marino
Saudi Arabia
Scotland
Senegal
Serbia
Seychelles
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
South Africa
South Korea
Spain
Sri Lanka
St. Barthelemy
St. Christopher
St. Croix
St. Eustatius
St. John
St. Kitts & Nevis
St. Lucia
St. Maarten
St. Martin
St. Thomas
St Vincent/Grenadine
Suriname
Swaziland
Sweden
Switzerland
Syria

AN
MP
WS
SM
SA
GB
SN
RS
SC
SL
SG
SK
SI
SB
ZA
KR
ES
LK
AN
KN
VI
AN
VI
KN
LC
AN
GP
VI
VC
SR
SZ
SE
CH
SY

Tahiti
Taiwan
Tajikistan
Tanzania
Thailand
Tinian
Togo
Tonga
Tortola
Trinidad & Tobago
Truk
Tunisia
Turkey
Turkmenistan
Turks & Caicos Islands
Tuvalu

PF
TW
TJ
TZ
TH
MP
TG
TO
VG
TT
FM
TN
TR
TM
TC
TV

Uganda
Ukraine
Union Island
United Arab Emirates
United Kingdom
United States
Uruguay
US Virgin Islands
Uzbekistan

UG
UA
VC
AE
GB
US
UY
VI
UZ

Vanuatu
Vatican City State
Venezuela
Vietnam
Virgin Gorda

VU
VA
VE
VN
VG

Wales
Wallis & Futuna Islands

GB
WF

Yap

FM

Zambia
Zimbabwe

ZM
ZW

Back to Top

What is the correct import file format for users?

Review the Import File Format table for the Users import file. All files must be saved with a .csv extension with the comma as the field delimiter. The import file must include the comma delimiter even for optional fields.

Field Name

Field Type

Maximum Field Length

Required

Valid Values

Name

Alphanumeric

35

Yes

User's first and last name

Log-On Name

Alphanumeric

16

Yes

User's log-on name. Must be unique across system

Location

Alphanumeric

35

Yes

User's location name. Location must be created prior to user import

Email Address

Alphanumeric

50

Yes

User's email address; example jdoe@somecompany.com

Telephone

Numeric

15

No

User's telephone number

Extension

Numeric

4

No

User's telephone extension

User Shipping Privilege Set Name

Alphanumeric

50

Yes

User's Shipping Privilege. Shipping Privilege must be created prior to user import

Default Reference 1

Alphanumeric

35

No

Default Reference 1

Default Service Level

Alphanumeric

3

No

Default Service Level. See codes below

Travelling User

Alphanumeric

1

No

Enter 1 if the user should be a travelling user.
Enter 0 if the user should be a non-travelling user

Supply Ordering

Numeric

1

No

Enter 1 if user has the authority to order UPS supplies
Enter 0 if the user does not have the authority to order UPS supplies

Fax Number

Alphanumeric

15

No

User's Fax Number

Location Administrator Indicator

Alphanumeric

1

No

Enter 1 if the user is a location administrator
Enter 0 if the user is not a location administrator

Do not allow the user to edit Reference No. 1 value

Alphanumeric

1

No

Enter 1 for selected to not allow the user to change the Reference No. 1 value. Enter 0 for did not select to allow the user to change the Reference No. 1 value.

The Import User File format contains a field named Default Service Level. This is a 3 character field. The codes are used to identify UPS domestic and International services. The valid codes for this field are:

UPS Domestic Services

UPS International Services

014=UPS Next Day Air Early A.M.

054=UPS Express Plus

001=UPS Next Day Air

007=UPS Express

013=UPS Next Day Air Saver

065=UPS Express Saver

059=UPS 2nd Day Air A.M.

008=UPS Expedited

002=UPS 2nd Day Air

011=UPS Standard

012=UPS 3 Day Select

003=UPS Ground Service

Back to Top

What is the correct import file format for reference numbers?

Review the Import File Format table for the Reference Number import file. All files must be saved with a .csv extension with the comma as the field delimiter. The import file must include the comma delimiter even for optional fields.

Note: The maximum file size for a single reference number import is 4 MB. The combined number of records stored in the three reference number fields cannot exceed 900,000.

Field Name

Field Type

Maximum Field Length

Required

Valid Values

Reference Value

Alphanumeric

35

Yes

Reference value unique per company

Reference Description

Alphanumeric

50

No

Description used to identify reference value

Back to Top

What is the correct import file format for locations?

Please review the Import File Format table for the Location import file. All files must be saved with a .csv extension with the comma as the field delimiter. The import file must include the comma delimiter even for optional fields.

Import File Format For Locations

Please refer to the following guide for the correct file formats:

Field Name

Field Type

Max Field Length

Required

Valid Values

Location Name

Alphanumeric

35

Yes

Name for location which must be unique per company

Location Contact Name

Alphanumeric

35

Yes

Location's primary contact person

Address 1

Alphanumeric

35

Yes

Location'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

Location's city

State/Province

Alphanumeric

5

Conditional

Location's state or province. See State/Province table for valid codes (required for U.S. and Canada)

Postcode

Alphanumeric

9

Conditional

Location's postcode

Country

Alphanumeric

2

Yes

Location's country

Telephone

Alphanumeric

15

Yes

Location's phone number

Extension

Alphanumeric

4

No

Location's phone extension

Email Address

Alphanumeric

50

No

Location's email address; example: jdoe@somecompany.com

Fax Number

Alphanumeric

15

No

Location's fax number

UPS Account Number

Alphanumeric

10

Yes

Location's UPS account number

Support Telephone

Alphanumeric

15

No

Location's support telephone number

Support Email

Alphanumeric

50

No

Location's support email address

Rate Type Setting

Alphanumeric

1

No

P = published rates, A = negotiated rates. If this value is not given, it will default to published rates (P)

Associated Address Group

Alphanumeric

35

No

Location's Associated Address Group

Back to Top

How do I resolve import errors?

The Import Tools option allows data to be imported from a .csv file into the UPS CampusShip system. If a particular record fails validation during the import, the system will create an error file with the records that the system could not import. Review the following table for possible errors and resolutions. Once the errors have been resolved, try the Import process again.

For more details on file format requirements, refer to the Import File Format FAQ in this section.

Error MessageResolution
Country Not ValidVerify country against correct country codes and try again
Duplicate RecordModify record to a unique value and try again
Duplicate LoginModify Login Name to a unique value and try again
Exceeded Max RecordsUPSCampusShip System unable to register Login Name with the Application Programming Interface (API). Please try again later.
IMS ErrorImport file records exceed system limits; delete some records and try again
Field Length ViolationVerify field length against appropriate file format and try again
Invalid Data TypeVerify data type in appropriate file format and try again ex: alphanumeric
Invalid EmailVerify email format and try again
Note: email address must include @
Invalid Fax NumberVerify fax number format and try again
Invalid LocationLocation name not valid; verify name and try again
Invalid LoginVerify login name and try again
Invalid PhoneVerify phone format and try again
Invalid Postal CodeVerify postal code and try again
Invalid Record Parameter CountVerify import file has all records in file
Note: All fields (including null fields) must be delimited by comma in the import file
Invalid User TypeVerify user type value and try again
Note: Valid entries are values 0 or 1
Missing Required FieldInsert missing field and try again
Province Not ValidVerify province against correct province codes and try again
State Not ValidVerify state against correct state codes and try again

Back to Top

How do I import users?

Select Administration in the area to the left, select Manage Users then Import Users.

To import a new file, follow these steps:

  1. Enter the Path or Location and Name of File, or browse to locate a file to import.
  2. After locating the file, select Open to place the file in the Location and Name of File text box.
  3. To import the users, select Import. The imported users will be added to the current list.

Note: Imported files must have the following three characteristics:

  • It must have a .csv extension
  • It must be in a comma delimited format
  • It must include the comma delimiter, even for optional fields


For more details on file format requirements, refer to the Import File Format for users in this section.

Back to Top

How do I import reference numbers?

Select Administration from the left side of the page, select Manage Reference Numbers, and then select Import Reference Numbers.

To import a new file, follow these steps:

  1. Enter the Path or Location and Name of File, or browse to locate a file to import.
  2. After locating the file, select Open to place the file in the Location and Name of File text box.
  3. Select whether you will add the imported reference numbers to your list or write over the current list. Writing over your current reference numbers will replace your current reference numbers with the ones you are importing.
  4. Select Import.

Note: Imported files must have the following three characteristics:

  • It must have a .csv extension
  • It must be in a comma delimited format
  • It must include the comma delimiter, even for optional fields


For more details on file format requirements, refer to the Import File Format for reference numbers in this section.

Back to Top

How do I import locations?

Select Administration from the left side of the page, select Manage Locations, and then select Import Locations.

To import a new file, follow these steps:

  1. Enter the Path or Location and Name of File, or browse to locate a file to import.
  2. After locating the file, select Open to place the file in the Location and Name of File text box.
  3. Select Import, and the imported locations will be added to your current list.

Note: Imported files must have the following three characteristics:

  • It must have a .csv extension
  • It must be in a comma delimited format
  • It must include the comma delimiter, even for optional fields

For more details on file format requirements, refer to the Import File Format for locations in this section.

Back to Top

How do I import addresses?

  1. Select My Settings from the toolbar, and then select Import Addresses from the desired address book.
  2. To import a new file, enter the Path or Location and Name of File, or browse to locate a file to import. After locating the file, select Open to place the file in the Location and Name of File text box.
  3. Select whether you will add the imported addresses to your list or write over the current list. Writing over your current list will replace your current address books with the ones you are importing. Select Import.

Note: Imported files must have the following three characteristics:

  • It must have a .csv extension.
  • It must be in a comma delimited format
  • It must include the comma delimiter, even for optional fields


For more details on file format requirements, refer to the Import File Format for addresses in this section.

Back to Top

Contact UPS

For questions about UPS CampusShip, contact your UPS CampusShip Administrator. For UPS CampusShip Technical Support, select the link below.

UPS CampusShip Technical Support