Creating a CIM Input File

To create a data input file, first determine the program to be used and fields to be updated. The basic steps are as follows:

a In the character interface, use the Ctrl+F key combination to display the program context, including name.

c In the Desktop interface, click the i (information) icon to display program details.

d In the .NET UI, right-click on the option in the menus and choose Properties to display program details.

2 Determine the program’s key fields. These are typically the first fields, and always let you advance to the next field by pressing Go.

A good test is to position the cursor in a field, and press Go. Note where the cursor goes. Reposition the cursor in the field, and press Return. If the cursor moves to the same place as it did when using Go, embed Go (Carriage Return) in your CIM file. If the cursor went elsewhere, embed a Return. You could still embed Go if this new cursor position did not lead to any field you want to populate.

An input file must contain values for key fields, each on a line by itself. This allows the Go command to apply to the appropriate field.

Note which fields are validated or secured. Do this by typing any character (for example, x) and pressing Enter. If a warning displays, the field is validated or otherwise constrained. Your input file must conform to valid choices for the field. Use the look-up browse for a list of valid entries.

3 Choose non-key fields you want to populate and in what sequence. Note whether Go or Return is required after each entry.

Not all fields have labels. For example, a two-line description can consist of two separate fields. To determine which lines correspond to which fields, place the cursor in each line and press Ctrl+F to display their field names. You must populate each field with a separate entry in a CIM file.

The following is an example template for Item Master Maintenance (1.4.1):

Remember, all CIM files start with @@BATCHLOAD <Program Name>. The Item Number (10-10000) is a key field and is required. It must be on its own line. The second line represents the next three fields in the entry group.

Follow Item Number with Go. The next line fills in the UM and Description fields. Note that Description is shown as two entries, one populating the first line, one populating the second.

Note: There are a few cases where CIM load does not work, such as costing data in Item Master Maintenance (1.4.1). In this case, costing data has to be CIM loaded through Item Element Cost Batch Load (1.4.15).

“1000” “5/28/1992” “Config” “AC” “DISCRETE” “10-10000” “AB”