How to Import Data Into DataXchange

How to Import Data Into DataXchange

Overview

Scytec DataXchange allows the import of part numbers, ideal times, and work orders. This eliminates the need to manual enter the data. Typically, customers will export the data from their existing ERP/MRP system and transpose to the DataXchange Data Import worksheet. 
While you can technically upload data with any license, all uploaded data is used exclusively with Gold level features. Contact your Account Executive for upgrade information.  

Requirements

  1. DataXchange Desktop Application
  2. DataXchange User Account with Administrator Permissions
  3. Microsoft Excel

Download Blank Template

  1. In the DataXchange Application, go to Manage > Metrics > Part Number And Ideal Time Import

  2. Click Download, then select a location on your computer to save the worksheet

  3. Fill out the template, additional information can be found at Scytec University (link)

Upload Populated Template

  1. In the DataXchange Application, Go to Manage > Metrics > Part Number And Ideal Time Import
  2. Click Browse and open the populated template
  3. Enter your address to receive a notification when the import is complete
  4. Click Upload
  5. Depending on how much data is being imported, process typically takes a couple of minutes

Troubleshooting

  1. If the email notification presents with errors, review Scytec University (link) for more information