You can now begin to populate the CSV template that you downloaded with the data that you want to upload.
To populate the dimension columns such as branches and products, you will need to refer to the master data lists. These lists will contain references for each dimension and can be downloaded from the master data section. You can then use the relevant references to populate the CSV file. The Master data will be different for each trading partner based on their DealTrack configuration.
Please avoid trailing spaces and spaces before column entries, as these can prevent the upload of data.
The Upload page looks very similar to the Download page and similarly, you must click the central area to begin the upload. You will then be able to select the populated CSV file to import.
For a file to be uploaded successfully, the following verification steps must be passed:
- The file must be in CSV format
- The column headings must match the headings that were downloaded.
- Each value must match the expected data type for that column and be non-empty since all are mandatory, as explained in the article 'Downloading the template'.
Selecting the relevant file will then progress you to stage 4 - Validation.