Create CSV Files

To upload your existing spreadsheet of Trade Partner data to the TPC, you must first format your spreadsheet using Tradeflow's Display Upload Format and then save the spreadsheet as a comma delimited (.CSV) file. The upload format defines a list of Field IDs and provides acceptable database values for each Field ID. By formatting your spreadsheet to include the correct Field IDs and matching database values, you can indicate which fields you want to upload to the TPC.

To format trade partner data using Tradeflow's Display Upload Format for a .CSV file:

1    Open the Trade Partner data spreadsheet you want to upload to the TPC.

Figure 1: Sample Trade Partner Spreadsheet

2    Delete any spreadsheet titles (for example, ACME Co). Click on column A and insert a new column.

3    Type Partner in cell A1.

Figure 2: Type Partner in cell A1

4    Type the Field ID 0 (zero) in cell A2, which is defined as Action. This column is required. Fill in the rest of Column A with the database value that corresponds to the Field ID.  The database value A is defined as Add. To modify/delete an existing product, replace the database value A in the second column by M or D. The prerequisite for modifying or deleting records while uploading is that the same set of records exists in Tradeflow's database. See Display Upload Format for CSV Files for more information.

Figure 3: Fill in the Database Values for Column A

5    Replace the title of Column B with the Field ID. In this example, Field ID 1 is equal to Trade Partner ID. Make sure the database values for the column do not violate the Field Length. See Display Upload Format for CSV Files for more information.

Figure 4: Replace title with the corresponding Field ID and database values for the column.

6    Repeat step 5 for all other columns in the existing spreadsheet:

1. • Change the column title to the corresponding Field ID

   • Fill in the column with the corresponding database values

Figure 5: Replace all Row 2 Titles with Field IDs and all Columns with Database Values