How can we help?

Part Number and Ideal Time Import

You are here:
< All Topics

Overview

The Data Import form makes it possible to import your current part, ideal times, and work orders into DataXchange without having to manually enter in each value by hand. 

The Data Import interface can be broken down into three different functions.

The Blank Template is a downloadable sample of each data format DataXchange expects when performing imports.

The Populated Template button is used to browse and select the Excel Workbook to be uploaded for processing. Once clicked a window will open allowing the user to browse to the location of the completed Data Import worksheet.

The Email Address is a field that is auto populated with the current users email address however it is possible to change the address if needed. The email address is used to notify the user when the import has completed and if there was any issues or errors during this process.

Click Upload once a template is completed and ready to be imported. Keep in mind you must save and close the populated template locally before selecting Upload or an error will occur.

The Template

The downloaded template has three tabs, PART NUMBERS, IDEAL TIMES, and WORK ORDERS. Fields with a * are required.

The Part Numbers tab has three columns:

  • Part Number**
  • Description
  • Overwrite?

**Part number must be imported here or already exist in the system to be used with the ideal times or work orders tab, otherwise an error will appear.

The Ideal Times tab has six columns:

  • Equipment Name*
  • Part Number*
  • Setup Time (min)
  • Cycle Time (min)
  • Operation Time (PPH)
  • Overwrite?

The Equipment Name, Part Number, and at least one of the three Ideal Time fields are required.    

The Work Orders tab has eleven columns

  • Work Order*
  • Description
  • Part Number*
  • Start Date*
  • Due Date
  • Build Quantity
  • Operation
  • Equipment Name
  • Part Counts Per Cycle
  • Ideal Time (PPH)
  • Overwrite?

It is possible to overwrite and update existing information.  

Once the import is started it may take some time depending on how much data you are importing. Once completed an email will be sent to the email address specified and a modified version of the template will be included as an attachment. The returned template will have an additional column on the right which will identify any rows that were unsuccessfully imported along with the reason why the information in the row failed. If all of the rows were successful then the Excel file will show that all of the data uploaded successfully. See below for more information on specific errors.

Note: Any blank row within the form will cause the system to stop processing the data.

If an Import is Completed Successfully

If the Data Import is successful an email will be sent to the email address specified when uploaded that includes the original template file with the information regarding the result of processing the worksheet. Below is an example of the email:

SubjectThe Scytec DataXchange import was successful
BodyThe Scytec DataXchange import has completed successfully.
1 Part Number has been processed successfully. 1 Ideal Time has been processed successfully.

If an Error is Found During the Import Process

If there is an error while processing the import, an email will be sent to the user that includes the original template file with the information regarding the result of processing the workbook. Below is an example of the email:

SubjectThe Scytec DataXchange import had one or more issues
BodyThe Scytec DataXchange import encountered one or more problems while being processed. The rows that encountered problems are identified in the attached document.

1 Part Numbers have been processed successfully. 2 Part Numbers encountered a problem and were not processed.
1 Ideal Times have been processed successfully. 2 Ideal Times encountered a problem and were not processed.

Error Messages Created for the Import Process (Part Counts)

Example errors that will cause the import to failDescription of the error
The Scytec DataXchange part number and ideal time template has a wrong format.The user will get an email and within the body it will show an error message that is generated when the template has a wrong name on the worksheet other than the provided template format.
Part Number Format FailedA part number did pass the validation for the part number format.
Part Number maximum length is 50 charactersA part number value exceeds 50 characters.
Part Number Description maximum length is 100 charactersA part number description exceeds 100 characters.
Part Number is RequiredA part number must be in the system before it can be assigned.
Equipment Name does not exists or is InactiveThe equipment doesn't exist or is inactive.
Equipment Name maximum length is 50 charactersThe equipment name exceeds 50 characters.
Equipment Name is RequiredThe equipment name is empty.
Setup Time has invalid valueThe value for setup time is invalid.
Cycle Time has invalid valueThe value for cycle time is invalid.

Warning Messages Created for the Import Process (Ideal Times)

Example messages  Description of the message
Duplicate Part Number has been skippedA part number already exists that will be skipped.
Duplicate Ideal Setup Time has been skippedThe ideal time was already found for the equipment and the Overwrite? field was not set to Y.
Duplicate Ideal Cycle Time has been skippedThe Cycle Time was already found for the equipment and the Overwrite? field was not set to Y.
Reached a blank row therefore finished processingThe last line in the import has been processed. (This applies for Part Numbers and Idea Times).

Error Messages Created for the Import Process (Work Orders)

Example errors that will cause the import to failDescription of the error
Work Order Number does not exists or is closedThe system is unable to overwrite a closed or non-existing work order.
Work Order Format FailedThe format is incorrect for the work order field. Specific formats can be specified in Work Order Formats.
Work Order maximum length is 50 charactersThe Length of the work order exceeds the maximum amount of characters.
Work Order Description maximum length is 100 charactersThe Length of the work order description exceeds the maximum amount of characters.
Work Order is RequiredWork Order is a required field.
Start/Stop Date is RequiredA date must be entered in the Start/Stop fields.
Start/Stop Date format is InvalidThe format of the date is incorrect. (2/13/2018).
Work Order Operation is RequiredAn operation must be entered for a work order.
Work Order Operation maximum length is 50 charactersThe work order operation characters exceeds the limit of 50 characters.
Start/ Stop Date has an invalid valueThe value is outside a normal date range.
Due Date has an invalid valueThe value is outside a normal date range.
Build Quantity has an invalid valueA numerical value must be entered.
Part Counts Per Cycle has invalid valueA numerical value must be entered.
Duplicated Work Order has been skippedWork orders are duplicated on the imported spreadsheet.
Duplicated Operation Work Order has been skippedThe system has not processed the work order due to a duplicate machine and operation.
Work Order Operation Duplicated for multiple equipmentOnly one operation can be used per machine.
Work Order(s) encountered a problem and were not processedGeneral error returned in the body of an email. 
Work Order can't switch Part NumbersPart numbers cannot be changed after an operation has been confirmed by the user.
Table of Contents