...
We need to update the Directory Path to reflect the relative location where the CSV file for our Product Extension table will be located, it should appear as shown below:10. Click Next button.
| Info |
|---|
NOTE: The directory path for the CSV file will be appended to the path defined for our SFTP connection. Thus, here we add the products folder that we created. For the purposes of our tutorial, we don’t need to make any updates or changes to these properties and can accept the default settings. |
Update the directory path to point to our PX folder on the SFTP server and click Next button.
...
11. Next, the Data Upload and Mapping panel will appear. On this panel we need to drag and drop our CSV file for the upload:
...
12. Drag and drop CustomerMasterProductCosts.csv onto the page.
13. The default parsing will appear for the first three rows:
...
14. Next, we need to select the Entity Type of Customer Product Extension:
...
...
Then choose the Entity Name of Product Costs.
15. Now we need to perform the data mapping to link our CSV columns to Product Master Extension in our partition:.
...
| Info |
|---|
The mapping process within the integration template will attempt to map the CSV columns to master table metadata attribute values. If it can’t find a match, then it will leave the Output column blank. |
NOTE: The Customer Id and Customer Name are considered mandatory fields. If the partition is empty and contains definition of Customer Master as “out-of-the-box”, then no automatic mapping is created.
16. You will notice that some of the CSV columns are automatically mapped to our Customer master table (all of the names that are singular are already done). Thus, we need to map the remainder: .
...
17. Next, we will assign the remaining CSV columns to attribute(s) column(s) in our Customer Master:
Customer Group to attribute1(“CustomerGroup”)
Customer Type to attribute2(“CustomerType”)
Product Category to attribute3(“ProductCategory”)
Customer Class to attribute3(“CustomerClass”)
Sub-Region to attribute12(“SubRegion”)
18. The next mapping is for Last Update, we don’t need this mapping so you can delete it using the trashcan icon for this mapping.
...
19. The last two column mappings (User Group Edit and User Group View) are not needed and the mappings can be deleted.
20. Click Continue button. The data mapping and loading of the Customer master will now be accomplished:
...
23.
18. Click Finish button.
| Info |
|---|
NOTE: These steps have defined the file mapping and the location of where the CSV file will be loaded. As soon as the CSV file appears, then the it will be mapped and loaded into the partition. |
...