Text File Import Jobs

 

Import Jobs enables you to import jobs via a text file into DMS using a predefined format.  To review the import file format, see Import/Export Job File Format. 

When importing data to DMS, Retain and Merge is used for making changes to existing jobs.  Retain and Merge specifies which fields may be changed during an import and which fields cannot be changed.

 

The Job Import via Test File has the ability to add to and change operations that are being imported by comparing the imported operation to the Import Interface Table.  If the “Apply Import Table” is selected and a new operation is being imported, DMS will look to see if the imported operation has any matching import interface operations.  Note that only new operations that are being added to DMS will have the Import Interface Table applied; existing operation in DMS will not be changed by the Import Interface Table settings.

 

To access Import Jobs, select Interface | Text Import | Import Jobs via Text File from the DMS Monthly 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.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 an explanation 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 file 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 ImportStatus.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.Default job state  The default job state will be applied to any job that does not specify the job state on its import record.  Note that for the old import file formats, all jobs imported will be set to the default job state as the other systems do not have a defined job state.

4.Add Resource if required  Check this prompt if you want to add resources that do not already exist in DMS.  Do not check this prompt if you want DMS to generate an error when adding operations with resources that do not exist in DMS.  If checked, DMS will add any new resources found when reading operations.  The new resources will be setup using a resource profile with the default type of work with 8 hours per shift and 8 hours per operation per shift.  The report status file will record new resources added to DMS so that you can adjust these resources as required after the import.

5.Apply import table  If the “Apply import table” is selected and a new operation is being imported, DMS will look to see if the imported operation has any matching import interface operations.  Note that only new operations that are being added to DMS will have the Import Interface Table applied; existing operations in DMS will not be changed by the Import Interface Table settings.  See Import Interface Table for more information.

6.Check previous complete status  If checked, DMS will check if an operation is using an auto reporting resource, or if an operation is marked as auto reporting, and DMS will automatically adjust the operation's status accordingly.  Unless you are using auto reporting and want Import Jobs to make adjustments to auto reporting operation statuses, uncheck this prompt.

7.Ignore completed jobs/operations  If checked, the import will not add completed jobs and operations.  This feature enables you to filter out completed jobs and operations that may be downloaded from another computer application, thus speeding up the import process.  If you want all jobs and operations in the import file added to DMS, uncheck this prompt.

8.Ignore jobs with release date >=  This prompt enables you to add a date where any job being imported that has a release date greater than or equal to the entered date will not be added to DMS.  This feature enables you to filter out jobs that are to be worked on in the future that have been downloaded from another computer system.  If you do not want to apply a release date filter on the jobs being imported, leave this prompt blank.

9.Ignore job user field records  If checked, the import will ignore any job user fields in the import file.  This setting is typically used when importing from another system and you do not want to import any given job user fields.

10.Ignore operation user fields  If checked, the import will ignore any operation user fields in the import file.  This setting is typically used when importing from another system and you do not want to import any given operation user fields.

11.Click OK to start the import process.  DMS will respond with a confirmation window.  Click OK to start the import or click Cancel to cancel the import. 

 

During the import you can abort the process by clicking the Abort button.  If the Abort button is clicked, DMS will confirm the abort by asking if you want to abort the import.  If you click OK, the import process will be aborted.  If you click Cancel, the abort will be ignored and the import will continue.

 

At the end of the import, DMS will display an information window about the import.  If there were errors or warnings, a message will appear in red and you should click on the View File button to review the messages.  (Note that you can always open the status file, or any text file, by using the command File | View File and selecting the file you would like to view.)
 

Also see Automatic Execution Commands