What are the minimum required fields for a Job Import CSV?

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.