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


    • Related Articles

    • Log into Scytec DataXchange for the First Time

      Overview This article will demonstrate how to log into Scytec DataXchange for the first time.  Requirements .NET Framework v4.7.2 Internet Access DataXchange Account Number and Account Password (supplied by SFA) Preparation Install Scytec ...

    • How to Add DataXchange Users

      Overview This article will demonstrate how to add Scytec DataXchange users.  Requirements DataXchange Administrator User Add a User Log into DataXchange Go to the Manage > Users > Users Click Add Fill out the following required fields (blue) User ...

    • How to Update DataXchange Timer Constants

      Overview Constants are values used in expressions. They allow you to update a value without touching an expression. They can be used across multiple expressions and will update in real time. The most common use of Constants is with timers.  ...

    • How to Install Scytec DataXchange

      Overview The Scytec DataXchange application is installed from the internet. An already established account and user is required to log in. This article applies to cloud customer only. Requirements .NET Framework v4.7.2 Internet Access DataXchange ...

    • Troubleshooting DataXchange Machine Connection

      Overview There are some things that may be troubleshot in Scytec DataXchange without having to dive too deep into the nitty-gritty of expressions and such. Attempt to Ping the Machine First thing you can try, is to attempt to ping the machine. To ...