Text File Import Employees

 

Employees are an optional entry used when reporting time against a job in Job Status Updating. 

 

To access Import Employees, select Interface | 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. 

3.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.