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.
Creating a data map
Follow the instructions below to set up a data map using the Dsco Data Mapper tool (the example below uses an inventory example, but it is the same process for all objects):
Step 1: After logging into your Dsco account, click the Navigation menu and select Automation & Reporting > Automation > Data Mapper.
Step 2: Click the 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 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, click the NEXT STEP button.
Step 5: Next, click 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 and you can leave the None Selected value.
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, click FINISH to save the mapping.
Creating a job to use your map
Now that your data map has been set up, you can now create an automated job that will use the data map you just created:
Step 1: Click the Navigation men and select Automation & Reporting > Automation > Jobs.
Step 2: Click the CREATE JOB button in the top right-hand corner of the screen.
Step 3: On page 1 of the job wizard:
- Enter an appropriate Job Title.
- Select the appropriate Process from the list. This must match the type of process you used when setting up the data map. For example, if the data map was a Product - Import you must choose the same on this page in order to use that data map.
- From the Standard drop-down, select Custom Map.
- Select the appropriate data map from the Map Name drop-down menu.
- Click Next Step.
Step 4: Review the following options:
- Import Source: Select from where you will import your document. The default option is a Dsco-hosted SFTP site. If you choose to use that option, the Username, Password,and Location fields will be automatically populated.
- Specific to an EDI import job, choose whether or not you want to receive a 997 acknowledgement back for documents sent to Dsco.
- Be sure to include an email address so Dsco can notify you of any job failures.
Click the NEXT STEP to continue.
Step 5: Set the job schedule:
If you wish to run the job manually, meaning that the system will not run the job automatically, choose Manually and click the Save Job button.
If you wish to have the system run the job on a schedule, change the Run this Job drop-down to the appropriate option. You can choose between Hourly, Daily or Weekly. If you choose Daily or Weekly, then you will also see other options allowing you to specify the time of day to run the job. Once you have set the schedule according to your needs, select Save Job.
Your new job will be displayed within the JOBS page. From here, you can run the job or come back at any time to view it's history.