Import Labor Data

Use the Labor Import (LEI) program to import hours worked from an ASCII file and validate imported data. See Background and Road Map for more information.

The program prompts Do you want to receive a new import, maintain, or delete an existing one?

  1. Choose the appropriate options:

To

Do This

Import a new batch of records

Click New.

Review a previously imported batch

Click Maintain. Select the batch you want to review or change and press Enter. See step 4.

Delete a previously imported batch

Select the batch you want to delete press Enter. The program prompts for you to confirm you want to erase the files associated with the selected batch. Click Yes to delete the batch or click No to leave the batch intact. The program returns to the menu.

Exit the program

Click Cancel.

  1. Enter data in these fields:

Field Name

Type / Max Length

Action / Description

Name of file to import

Required
45 alphanumeric

Enter the name of the file (up to 8-characters) if it resides on a native disc or enter the full path name including the file extension (e.g., C:\My documents\CMX.XML or U:\IMPORT\VMX.XML where U: is a mapped network drive) if the file is on your PC or network.

If the PC file is not found or if the file resides on a native disc, the program prompts to check for a sequential file. Click Yes if you entered the file name correctly or click No to re-enter the name of the file to import.

By default, the name of the last file imported is displayed. To exit to the menu, clear the field and press Enter or Tab.

Name of batch file

Required
5 alphanumeric

Enter a batch name for this file. This name will be associated with this file until import is complete.

D=Delimited or F=Fixed length

Required
1 alphanumeric

Enter D if the file uses a delimiter or enter F if fields are a fixed length. If you import data from an ASCII file generated from Microsoft Excel, fields are a fixed length.

Field delimiter

Conditional
1 alphanumeric

If you entered D for D=Delimited or F=Fixed length, enter the field delimiter used; for example, enter T for tab, a ; (semicolon), or a , (comma).

Mfg branch

Required
4 alphanumeric

Select the manufacturing branch for your login branch.

Erase import file when done?

Optional

Select to erase the import file when you have finished working with it or leave blank to retain the file.

  1. When you complete all fields click OK.

    When the import completes, the program displays the imported records:

Field Name

Displays

Validated

Blank: Validation has not been done.
Error: This record did not pass validation.
Good: This record is good.

Mfg br

The manufacturing branch for this labor

Worked

The date the work was performed

Badge ID

The employee or machine that performed the work

Mfg order no

The manufacturing order worked on

Oper seq

The operation sequence worked on

Lbr cd

The labor code for this work:
D: Direct
H: Holiday
I: Indirect
O: Other
R: Rework
S: Sick
U: Setup
V: Vacation

Seq

The sequence for this labor for this employee and manufacturing order

Reg hrs

The regular shift hours worked on this sequence

Lvl 1 OT

Level 1 overtime hours

Lvl 2 OT

Level 2 overtime hours

  1. Choose the appropriate options:

To

Do This

Add a record

Click Add. See Enter Employee Hours.

Delete a record

Highlight the line and click Delete. See Delete.

Copy a record

Highlight the line and click Copy. See Copy.

Display a record

Highlight the line and click Select. See Enter Employee Hours for field descriptions.

Print the listing

Click Print. See Labor Import Listing.

Validate records

Click Import validation. The program displays a confirmation prompt. Click OK to validate or Cancel to end this action.

If you click OK, the program a validation message. If there are errors, the Labor Import Exception Report is printed to your default output device. For each record in the import file, the Validated indicates Good or Error.

Update labor files

Click Labor update. If there are exceptions that have not been resolved, the program prompts for confirmation to continue with the update. Click OK to update the labor or click Cancel to end this action.

When you acknowledge that the update is complete, a log is printed. See Print the Labor Import Transfer Log.

Exit the program

Click Exit.