Text File Import Employees
 		Previous Topic  Next Topic 

Employees are an optional entry used when reporting time against a job in Job Status Updating.  To access import employees, select Import | Text Import | Import Employees via Text File from the main Calendar menu.


The following screen will appear:



The following tabs and commands are available from the Manufacturing Order screen:


File


  1. Text Import  Select File | Text Import to enter the import information to the prompts.
  2. Delete All will delete ALL employees currently in the employee file that are not used in history.  The following window will appear asking you to confirm the delete:



Select OK to delete all employees not used in history, or select Cancel to ignore the delete. 


  1. View File  Select File | View File to view a file.  The following window appears enabling you to select the file you want to view:



The following are explanations of the prompts: 


  1. Import filename Enter the import filename.  The import file must already exist and be in the correct format.  You can click on the open folder icon at the end of the prompt to browse for the import file.
  2. Report status filename Enter a filename where the report status will be written or press enter to take the default filename of ImportEmployeeStatus.TXT.  DMS writes the status of the import to the file entered to this prompt. Import errors with the offending import line are written to this file. 
  3. Click OK to start the import, or click Cancel.


The Employee record consists of one record type (EMP).  During the import, if an employee number already exists in the table, the employee is updated with the new imported data.  Duplicate employee numbers are not allowed.

Field

Type

Comment

EMP

String 3

Record identifier.  Required filed

Employee Number

String 20

Required unique field.  Employee number of the employee record to add or update.

Employee Name

String 50

Employee name.  The name any format such as "Last Name, First name" or "First Name Last Name", etc.

Available

Boolean

True if the employee is available for use.  False if the employee is not available (i.e. left the company).

Notes

Memo

Optional text about the employee.