The Dsco Data Mapper Tool is a great option for suppliers who have their own CSV or TAB delimited files that they work with. The Dsco Data Mapper tool walks you through the process of mapping your data to the Dsco specifications so that you don’t have to build a custom file on your end. Once the mapping has been completed you can upload your file through the Dsco portal or you can configure an automated job to use the mapping.
Follow the instructions below to set up a data map using the Dsco Data Mapper tool (the example below uses the Inventory object but it is the same process for all objects):
Step 1: Select the AUTOMATION link at the top of the page after logging in.
Step 2: Select the DATA MAPPER link.
Step 3: Select Create Map.
Step 4: On step 1 of the Create Map wizard:
1. Enter a name for this mapping in the Map Name box.
2. Select the appropriate Process using the drop-down options. For this example, use Product - In.
3. Select the Browse... button to find and select the file you wish to use with the map.
4. If your header row is found on anything other then the first row, set the appropriate header row in that box.
Select Next Step to go to the next step.
Step 5: On Step 2, make sure the system has detected your file properly by ensuring that the data looks correct within the Data Preview section. If everything looks good, select the Next Step button.
If anything looks wrong you can change the various options. Move your mouse over the question marks next to each option to find out more about what each option does and how each works.
Step 6: In step 3, select into each drop-down for each field to map the column within your file to the appropriate Dsco field.
If your column name matches our column name, Dsco automatically maps it for you.
Step 7: Step 4 is a confirmation that you have mapped your data correctly. You can see the column headers along with your mapped data underneath. If everything looks good, select Finish to save the mapping.