Pre-Defined XML File - Asendia USA



Parcels Excel Data Import Specifications

Version 2.11

Table of Contents

1. Excel (XLS) File Structure………………………….............................................................................3

1. File Naming Convention

2. File Structure / Content / Formatting Rules

1. Categories

2. Worksheets

2. Package Worksheet…………………………………………………………………………………………..4

3. Item Worksheet…………………………………………………………………………….………………....5

4. ISO Country Codes………………………………………………………………………………..………….6

5. Contact Information………………………………………………………………………………….………11

Excel (XLS) File Structure

1.1 File Naming Convention

a. The mailer’s company name or abbreviation. Underscore between spaces and after name

b. The date the file was created. A dash is to be used between year, month and day.

Format: YYYY-MM-DD ( Example: _2011-02-20_ )

c. Sequence number indicating the number of files created for that day. Underscore after date and before sequence number. (Example: 3rd file created for the day _3 )

d. An extension of .xls after sequence number

Syntax: Your_Company_Name_ YYYY-MM-DD_3.xls

Sample File Name: Asendia_USA_2013-02-20_1.xls

2. File Structure / Content / Formatting Rules

a. Categories

R = Required. This field value must appear in the file.

O = Optional. The field value may be omitted from the file. Field tag is still required.

C = Client Specific. May be required depending on the specifications per client.

b. Worksheets - There are two worksheets required for this format which are as follows:

a. Package – This worksheet will contain package level information. The worksheet name is Package.

b. Item – This worksheet will contain item level information. The worksheet name is Item.

PACKAGE WORKSHEET

|No |Name |Category |Description |Type |Max Length |

|03 |LastName |R |Recipient Last Name |String |20 |

|04 |FirstName |R |Recipient First name |String |14 |

|05 |MiddleInitial |O |Recipient Middle |String |1 |

|06 |BusinessName |O |Business Name. Note that this field will not display on an|String |35 |

| | | |address label at this time. | | |

|07 |AddressLine1 |R |First line of recipient’s street address |String |35 |

|08 |AddressLine2 |O |Second line of recipient’s street address if needed |String |35 |

|09 |AddressLine3 |O |Third line of recipient’s street address if needed |String |35 |

|10 |City |C |The city of the recipient’s street address. May be |String |35 |

| | | |required for some services. | | |

|11 |Province |C |Recipient’s state or province if it applies. * This may be|String |35 |

| | | |required for some services | | |

|12 |PostalCode |C |Recipient’s postal code. |String |20 |

| | | |*This may be required for certain services. | | |

|13 |CountryCode |R |The 2 char ISO country code for the recipient’s address. |String |2 |

|14 |Phone |C |Recipient’s phone number. |String |25 |

| | | |* This may be required for some services | | |

|15 |Email |O |Recipient’s email address |String |50 |

|16 |PckWeight |R |Weight for package if known (pounds). Default value to |Decimal |00.XX |

| | | |zero if no weight is being given. | | |

|17 |PckType |R |Indicates if package is a gift, sample, or merchandise |String |1 |

| | | |S = sample, G = Gift, M = Merchandise, D=Documents | | |

| | | |Default is M | | |

|18 |ServiceType |R |“EXP” for express service, |String |3 |

| | | |“OSP” for oversized pck’s | | |

| | | |“PAR” for all other pck’s | | |

| | | |This field should be defaulted to “PAR” unless otherwise | | |

| | | |specified to customer | | |

|19 |PckDescription |C |Summary description of pck contents. |String |35 |

| | | |* This may be required for specific services | | |

|20 |ShippingCost |C |This is the shipping charge that your customer paid. *This|Decimal |00.XX |

| | | |may be required for specific services | | |

|21 |DutyTaxHandling |C |Duties & Taxes paid for the package. *This may be required|Decimal |00.XX |

| | | |for specific services | | |

|22 |CustomsBarCode |O |Customs Bar code value or tracking number. This normally |String |34 |

| | | |will be the USPS CN22 or 2976A number if shipper needs | | |

| | | |this to be recorded. | | |

ITEM WORKSHEET

|No |Name |Category |Description |Type |Max Length |

|02 |ItemId |R |Product code or SKU for item |String |20 |

| | | |ItemId must be unique per each package | | |

|03 |ItemDescription |R |Description of item |String |32 |

|04 |CustomsDescription |C |Description of the item by Customs |String |32 |

| | | |requirement, containing information | | |

| | | |about the content of the item. May be required for some | | |

| | | |services. | | |

|05 |UnitPrice |R |Resale value of the item (USD) |Decimal |0.00 |

|06 |Quantity |R |Quantity of the item(s) with the same ItemId within the |Integer |X |

| | | |same package. Cannot be zero | | |

|07 |CountryOfOrigin |R |ISO 2 char country code representing the country of |String |2 |

| | | |manufacture of the item | | |

|08 |HTSNumber |C |Harmonized number that is associated |String |20 |

| | | |with the item. If the harmonization number is known, it | | |

| | | |should be placed in | | |

| | | |this field. | | |

| | | |* This may be required for specific services | | |

|09 |HTSNumberUS |C | |String |20 |

ISO COUNTRY CODES

International Organization for Standardization



| |Country Name |2 Char Code |

| |AFGHANISTAN |AF |

| |ALAND ISLANDS |AX |

| |ALBANIA |AL |

| |ALGERIA |DZ |

| |AMERICAN SAMOA |AS |

| |ANDORRA |AD |

| |ANGOLA |AO |

| |ANGUILLA |AI |

| |ANTARCTICA |AQ |

| |ANTIGUA AND BARBUDA |AG |

| |ARGENTINA |AR |

| |ARMENIA |AM |

| |ARUBA |AW |

| |AUSTRALIA |AU |

| |AUSTRIA |AT |

| |AZERBAIJAN |AZ |

| |BAHAMAS |BS |

| |BAHRAIN |BH |

| |BANGLADESH |BD |

| |BARBADOS |BB |

| |BELARUS |BY |

| |BELGIUM |BE |

| |BELIZE |BZ |

| |BENIN |BJ |

| |BERMUDA |BM |

| |BHUTAN |BT |

| |BOLIVIA |BO |

| |BOSNIA AND HERZEGOVINA |BA |

| |BOTSWANA |BW |

| |BOUVET ISLAND |BV |

| |BRAZIL |BR |

| |BRITISH INDIAN OCEAN TERRITORY |IO |

| |BRUNEI DARUSSALAM |BN |

| |BULGARIA |BG |

| |BURKINA FASO |BF |

| |BURUNDI |BI |

| |CAMBODIA |KH |

| |CAMEROON |CM |

| |CANADA |CA |

| |CAPE VERDE |CV |

| |CAYMAN ISLANDS |KY |

| |CENTRAL AFRICAN REPUBLIC |CF |

| |CHAD |TD |

| |CHILE |CL |

| |CHINA |CN |

| |CHRISTMAS ISLAND |CX |

| |COCOS (KEELING) ISLANDS |CC |

| |COLOMBIA |CO |

| |COMOROS |KM |

| |CONGO |CG |

| |CONGO, THE DEMOCRATIC REPUBLIC OF THE |CD |

| |COOK ISLANDS |CK |

| |COSTA RICA |CR |

| |COTE D'IVOIRE |CI |

| |CROATIA |HR |

| |CUBA |CU |

| |CYPRUS |CY |

| |CZECH REPUBLIC |CZ |

| |DENMARK |DK |

| |DJIBOUTI |DJ |

| |DOMINICA |DM |

| |DOMINICAN REPUBLIC |DO |

| |ECUADOR |EC |

| |EGYPT |EG |

| |EL SALVADOR |SV |

| |EQUATORIAL GUINEA |GQ |

| |ERITREA |ER |

| |ESTONIA |EE |

| |ETHIOPIA |ET |

| |FALKLAND ISLANDS (MALVINAS) |FK |

| |FAROE ISLANDS |FO |

| |FIJI |FJ |

| |FINLAND |FI |

| |FRANCE |FR |

| |FRENCH GUIANA |GF |

| |FRENCH POLYNESIA |PF |

| |FRENCH SOUTHERN TERRITORIES |TF |

| |GABON |GA |

| |GAMBIA |GM |

| |GEORGIA |GE |

| |GERMANY |DE |

| |GHANA |GH |

| |GIBRALTAR |GI |

| |GREECE |GR |

| |GREENLAND |GL |

| |GRENADA |GD |

| |GUADELOUPE |GP |

| |GUAM |GU |

| |GUATEMALA |GT |

| |GUERNSEY |GG |

| |GUINEA |GN |

| |GUINEA-BISSAU |GW |

| |GUYANA |GY |

| |HAITI |HT |

| |HEARD ISLAND AND MCDONALD ISLANDS |HM |

| |HOLY SEE (VATICAN CITY STATE) |VA |

| |HONDURAS |HN |

| |HONG KONG |HK |

| |HUNGARY |HU |

| |ICELAND |IS |

| |INDIA |IN |

| |INDONESIA |ID |

| |IRAN, ISLAMIC REPUBLIC OF |IR |

| |IRAQ |IQ |

| |IRELAND |IE |

| |ISLE OF MAN |IM |

| |ISRAEL |IL |

| |ITALY |IT |

| |JAMAICA |JM |

| |JAPAN |JP |

| |JERSEY |JE |

| |JORDAN |JO |

| |KAZAKHSTAN |KZ |

| |KENYA |KE |

| |KIRIBATI |KI |

| |KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF |KP |

| |KOREA, REPUBLIC OF |KR |

| |KUWAIT |KW |

| |KYRGYZSTAN |KG |

| |LAO PEOPLE'S DEMOCRATIC REPUBLIC |LA |

| |LATVIA |LV |

| |LEBANON |LB |

| |LESOTHO |LS |

| |LIBERIA |LR |

| |LIBYAN ARAB JAMAHIRIYA |LY |

| |LIECHTENSTEIN |LI |

| |LITHUANIA |LT |

| |LUXEMBOURG |LU |

| |MACAO |MO |

| |MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF |MK |

| |MADAGASCAR |MG |

| |MALAWI |MW |

| |MALAYSIA |MY |

| |MALDIVES |MV |

| |MALI |ML |

| |MALTA |MT |

| |MARSHALL ISLANDS |MH |

| |MARTINIQUE |MQ |

| |MAURITANIA |MR |

| |MAURITIUS |MU |

| |MAYOTTE |YT |

| |MEXICO |MX |

| |MICRONESIA, FEDERATED STATES OF |FM |

| |MOLDOVA, REPUBLIC OF |MD |

| |MONACO |MC |

| |MONGOLIA |MN |

| |MONTENEGRO |ME |

| |MONTSERRAT |MS |

| |MOROCCO |MA |

| |MOZAMBIQUE |MZ |

| |MYANMAR |MM |

| |NAMIBIA |NA |

| |NAURU |NR |

| |NEPAL |NP |

| |NETHERLANDS |NL |

| |NETHERLANDS ANTILLES |AN |

| |NEW CALEDONIA |NC |

| |NEW ZEALAND |NZ |

| |NICARAGUA |NI |

| |NIGER |NE |

| |NIGERIA |NG |

| |NIUE |NU |

| |NORFOLK ISLAND |NF |

| |NORTHERN MARIANA ISLANDS |MP |

| |NORWAY |NO |

| |OMAN |OM |

| |PAKISTAN |PK |

| |PALAU |PW |

| |PALESTINIAN TERRITORY, OCCUPIED |PS |

| |PANAMA |PA |

| |PAPUA NEW GUINEA |PG |

| |PARAGUAY |PY |

| |PERU |PE |

| |PHILIPPINES |PH |

| |PITCAIRN |PN |

| |POLAND |PL |

| |PORTUGAL |PT |

| |PUERTO RICO |PR |

| |QATAR |QA |

| |REUNION |RE |

| |ROMANIA |RO |

| |RUSSIAN FEDERATION |RU |

| |RWANDA |RW |

| |SAINT HELENA |SH |

| |SAINT KITTS AND NEVIS |KN |

| |SAINT LUCIA |LC |

| |SAINT PIERRE AND MIQUELON |PM |

| |SAINT VINCENT AND THE GRENADINES |VC |

| |SAMOA |WS |

| |SAN MARINO |SM |

| |SAO TOME AND PRINCIPE |ST |

| |SAUDI ARABIA |SA |

| |SENEGAL |SN |

| |SERBIA |RS |

| |SEYCHELLES |SC |

| |SIERRA LEONE |SL |

| |SINGAPORE |SG |

| |SLOVAKIA |SK |

| |SLOVENIA |SI |

| |SOLOMON ISLANDS |SB |

| |SOMALIA |SO |

| |SOUTH AFRICA |ZA |

| |SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS |GS |

| |SPAIN |ES |

| |SRI LANKA |LK |

| |SUDAN |SD |

| |SURINAME |SR |

| |SVALBARD AND JAN MAYEN |SJ |

| |SWAZILAND |SZ |

| |SWEDEN |SE |

| |SWITZERLAND |CH |

| |SYRIAN ARAB REPUBLIC |SY |

| |TAIWAN, PROVINCE OF CHINA |TW |

| |TAJIKISTAN |TJ |

| |TANZANIA, UNITED REPUBLIC OF |TZ |

| |THAILAND |TH |

| |TIMOR-LESTE |TL |

| |TOGO |TG |

| |TOKELAU |TK |

| |TONGA |TO |

| |TRINIDAD AND TOBAGO |TT |

| |TUNISIA |TN |

| |TURKEY |TR |

| |TURKMENISTAN |TM |

| |TURKS AND CAICOS ISLANDS |TC |

| |TUVALU |TV |

| |UGANDA |UG |

| |UKRAINE |UA |

| |UNITED ARAB EMIRATES |AE |

| |UNITED KINGDOM |GB |

| |UNITED STATES |US |

| |UNITED STATES MINOR OUTLYING ISLANDS |UM |

| |URUGUAY |UY |

| |UZBEKISTAN |UZ |

| |VANUATU |VU |

| |VENEZUELA |VE |

| |VIET NAM |VN |

| |VIRGIN ISLANDS, BRITISH |VG |

| |VIRGIN ISLANDS, U.S. |VI |

| |WALLIS AND FUTUNA |WF |

| |WESTERN SAHARA |EH |

| |YEMEN |YE |

| |ZAMBIA |ZM |

| |ZIMBABWE |ZW |

Contact Information

Asendia USA

Corporate Headquarters: Philadelphia, PA

701C Ashland Avenue

Folcroft, PA 19032-2011

Phone: 1.800.MAIL.287

Fax: 610.461.4239

Technical questions or comments about these specifications can be sent to:

Tom Weigel

Software Developer, Asendia USA

Email: tom.weigel@

Work: 610-461-3661 x5352

Cell: 267-257-9677

-----------------------

Page 4 of 11

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download