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: After logging into your Dsco account, click the Dashboard icon and click AUTOMATION & REPORTING. Next, click AUTOMATION and then click DATA MAPPER.
Step 2: Select the grey and white CREATE MAP button towards the top righthand corner of the screen.
Step 3: On step 1 of 3 within the Create Map wizard:
1. Enter a name for this mapping in the Map Name box so you can easily refer to it later.
2. Select the appropriate Process using the drop-down options. For this example, we use Inventory - In.
3. Select the Choose File button to find and select the file you wish to use to create the map.
4. If your header row is found on anything other than the first row, set the appropriate header row in the Heads found on row box.
Select the teal NEXT STEP button to go to the next step.
Step 4: Now that you've uploaded your file, 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 teal NEXT STEP button.
Step 5: Next, 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 6: Step 4 in the Create Map wizard is a final 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.