Below is the list of fields that must be present in the CSV file used to import jobs into MachineMetrics. All of these fields and their values must be present in the CSV file, with no differences in capitalization or spelling, and no additional fields.
IMPORTANT! Do NOT format numbers in your CSV file fields to include commas, dollar signs, and so on, as this will cause the information to be interpreted incorrectly by MachineMetrics.
Required Fields for Tracking by Part Number
If your manufacturing operations only require you to track jobs based on part number, then your job import only requires the following three fields. In this circumstance, the name field should be used as the part number.
- name
- default_expectedcycletime
- default_setuptime
Required Fields for Tracking by Work Order or Job Number
If your manufacturing operations require you to track work orders or job numbers, then your Job Import CSV should include the following four fields. In this circumstance, the work order should be used in the name field, and the part number should be used in the part field.
- name
- part
- default_expectedcycletime
- default_setuptime
Recommended File Fields
While the list of fields below are not required to be present in the CSV file used to import jobs into MachineMetrics, they are still considered 'basic', rather than 'advanced' fields. Most customers include these even when just getting started with job imports, and find them very helpful.
- operation
- description
- quantity
The downloadable CSV Templates at the bottom of this article include a template for the recommended basic fields for part number tracking, and the basic fields for work order/job number tracking. The Advanced Job Import CSV Article provides a CSV Template which include all currently available file fields if you are looking for a complete template.
If you have any remaining questions or run into any problems, please reach out to your Customer Success Manager, or contact support@machinemetrics.com or by phone at +1.413.341.5747x120.
Comments
0 comments
Please sign in to leave a comment.