Display Upload Format for Super-CSV Files |
|
The Comma Separated Value (.CSV) file that you are uploading into Tradeflow's database must be in Tradeflow's Display Upload Format. The format displays the mapped Field IDs of every field available in the TPC, the fields that the Super-CSV should contain, the order in which the field values should appear in each row/record, and the number of characters that should be used for each field. For fields that are populated by drop-down lists or pop-ups (for example, Country code), the field value in the .CSV file should be the code and not the description/value. You can use these IDs to indicate which fields you want to upload.
The Upload feature can be used to Add, Modify, or Delete records in Tradeflow. This is controlled by the first field that contains the action code.
To view the Display Upload Format for Super-CSV files:
1 In the TPC Home Page, under the Upload File section, there are the Display Upload Format links for CSV, Super CSV, and XML. You can also access the Display Upload Format link by clicking Upload Trade Partners from the left navigation panel.
2 Click the link for Super CSV. An Excel file will open showing the Display Upload Format for Super-CSV files. See the Rules and Guidelines for Super-CSV Display Upload Format below.
Figure 1: Display Upload Format for Super-CSV Files
A list of the columns that appear in the Display Upload Format for Super-CSV Files file:
Column |
Description |
|---|---|
| File Signature | Displays data type. Specify this in your .CSV file in cell A1. |
| Field ID | Field identification number |
| Name | Field names of all the fields that are available in the Trade Partner Centre. Also displays reference values for the fields. |
| Field Length | Total field length allowed. |
Figure 2: Database Values Corresponding to the Field IDs
Rules and Guidelines for Super-CSV Display Upload Format
Use the table below to ensure that your Trade Partner data is formatted correctly.
Field |
Super-CSV Section Code & Field ID |
Rule/Guideline |
|---|---|---|
Trade Partner ID |
A, 1 |
Always Required |
Name |
A, 2 |
Always Required |
Trade Partner Type |
B |
At least one Trade Partner Type is Always Required, unless using Upload Defaults to fill in this field. See To Upload Trade Partner Data Using Upload Defaults for more information. |
Manufacturer ID, Country of Origin, & State/Province of Origin |
A, 5 A, 8 A, 9 |
These fields are enabled for the following Trade Partner Types (B):
|
Manufacturer ID, FDA Registration Number, FDA Exempt, FDA Type, & DDTC Registration Number |
A, 5 A, 15 A, 16 A, 17 A, 23 |
These fields only apply to users doing business with the United States |
Carrier Code & Carrier Contract Number |
A, 6 A, 7 |
These fields are enabled for the following Trade Partner Types (B):
|
Security Assessment Indicator |
A, 13 |
Can be used to track Supply Chain Security programs such as C-TPAT (United States) or PIP (Canada) |
FDA Registration Number |
A, 15 |
This field is enabled for the following Trade Partner Types (B):
|
FDA Exempt & FDA Type |
A, 16 A, 17 |
These fields are enabled for the following Trade Partner Type (B):
|
Military Indicator & EPCI Screening |
A, 18 A, 19-22 |
These fields are enabled for the following Trade Partner Type (B):
|
EPCI (Enhanced Proliferation Control Initiative) Screening |
A, 19-22 |
Applies to those countries who are party to this initiative |
DDTC Registration Number |
A, 23 |
This field is enabled for the following Trade Partner Types (B):
|
Addresses |
C |
It is recommended to provide as much information as possible to create a valid address for the country of the Trade Partner. No country-specific rules are enforced (for example, no Postal Code or State/Province required) |
Alternate Addresses |
C |
An alternate address may be provided after the Address Type (C, 1) Primary address (PRIM) has been provided for the Trade Partner (either in the current or previous upload/data entry) |
Address Name |
C, 2 |
This is used to distinguish the address on the user interface (not shown or visible outside the TPC) |
Address Line 1, City, & Country |
C, 3 C, 5 C 7 |
These fields are required if supplying an address. |
Contacts |
D |
If supplying a contact, First Name (D, 3) and Last Name (D, 4) are required and Contact Type (D, 1) Primary contact (PRIM) must be provided first before providing alternate contacts.
The contact will be associated to the Primary address unless otherwise specified via Associate contact to an address (D, 12)
Especially if the contact will be used in conjunction with the Shipment Management Centre, the following fields are recommended: Preferred Language (D, 5), Preferred Paper Size (D, 6), & Email Address (D, 7) |
|
Related
© 2021 Property of Expeditors International of Washington, Inc. and its subsidiaries.
Business Confidential and Proprietary. Reproduction by written authorization only.
- Created by: Expeditors Technical Communications Department -