The Jobs File

A Jobs File in Control It allows you to push information from your existing database or ERP system into Control It.

Examples of metadata include customer name, alloy and part number.

In Control It, you can define process details that allow you to include additional details (metadata) in your reports.

FILE STRUCTURE

The Jobs File requires a specific structure so that Control It know what to look for and where. That structure is defined with the following rules,

  1. The file is in a CSV (comma separated value) format. Any single value in the file that has a comma, must have that comma removed or replaced, else thce format of the CSV will not work.
  2. The first line of the file are the HEADERS. The first value represents the Work Order values. This header can be anything as Control It discards it. Each subsequent header represents a Process Detail that has been established in Control It . The header value must match the name of the process detail exactly.
    1. The first value of each line is the Work Order. The Work Order value is what the Control It operators will enter before running a rectifier. If possible, this value should be on the job traveler to allow bar scan scanning when populating details.
  3. Subsequent values in each line are the process detail values for the Work Order according to the HEADERS.
  4. If the jobs file contains duplicate Work Orders, only the first one found will be used.
  5. Work Order names should not contain any illegal file name characters:  \ / : * ? " < > | 
     Control It will replace any illegal characters in the work order with an underscore.

An example of a job’s file is as follows:

Work OrderAlloyCustomerPart NumberNumber of RacksNumber of Parts
1116061Acme Widgets111-234543
2222024Ally’s AviationPNR-54312