Path: Admin > Universal Interface > Universal Interface Setup
The Work Order Labor Import Transaction Type can imports selected information from many HR systems. The Setup requires inclusion of at least one Repair Center on the Repair Center Tab.
When you select the Transaction Type, WebTMA automatically loads the required fields in the mapping grid. These lines display a red icon in the left column until the row is mapped to the remote columns in the third-party database.
WebTMA filters the column field selection to prevent duplicate selection. For example, First Name and Last Name are not available for selection when you click the Add Column link because they are already selected. Reminder: The lines that auto-populate the grid are required.
Remember to add at least one Repair Center to the Repair Center Tab.
General Information Field Definitions
Code – Unique code to identify Setup record (required).
Transaction Type – Select UPI – Purchase Requisition Export (required).
Connection Type – Choose Microsoft SQL Server, Oracle, Comma Delimited Text File, or Tab Delimited Text File.
Description – Describe the Setup record (required).
Export Header Row – If your ERP requires that the first row be the column definition for the file, mark this check box.
- Database Name – The name of your database on your server.
- Port # – Necessary if you connect to Oracle database.
- User Name – The login ID for your database server.
- Password – The password to login to your database server.
- Table Name – The name of the table containing Departments to be imported into WebTMA.
- Key Column Name – Field in your Universal Interface table containing the Unique Identifier for your Departments. This is typically a Primary Key.
- Processed Column Name – Field in your Universal Interface table to indicate if the row has been processed or not. (Must default to FALSE)
- Error Column Name – Field in your Universal Interface table WebTMA will write to if there's a problem importing a record.
- File Path (Folder) – The name of the folder that contains the import files. (Note: This is only used if the Connection Type is Comma Delimited Text File or Tab Delimited Text File.)
The Server fields are auto-populated using the entries made to the Detail window during Universal Interface Client Service Installation.
WARNING: The Server-related fields can be edited in WebTMA; however, this should only be done by highly qualified personnel. Changes saved here overwrite the contents of the Detail setup windows. It is preferable to make changes to the Detail setup window where you can test your connection.
How to Link Universal Interface Fields for work Order Labor Import
In order to import Work Order Labor lines, you must link WebTMA fields with fields within your Universal Interface table. By default, required fields are shown in the grid.
From your Universal Interface Setup window in Add/Edit mode:
- Edit the required fields to select Remote Column.
- Click the Add Column link on the grid to open the Entry flyout.
- Choose your elective WebTMA Column.
- Select the Remote Column.
- Click Save & Add (or Save).
- Repeat until required fields and selected elective fields in your Universal Interface table have been matched up.
- Add the applicable Repair Center(s) to the Repair Center Tab.
- Click Save on the WebTMA toolbar.
Work Order Labor Import Required WebTMA Columns
The following fields must be present in your outside database to accomplish a successful import of Work Order Labor information to WebTMA. When you add a new Universal Interface template, the following required fields are automatically added to the TMA Column. At this point, all you need to do is map them. You can also add any Work Order Labor Import Elective WebTMA Columns listed in the next topic.
- Work Order #
- Technician ID
- Transaction Date
- Workorder Task Code
- Hours
- Time Type Code
- Trade Code
Work Order Labor Import Elective WebTMA Columns
The following elective fields are available to map to your import.
- Account #
- No Charge?
- Taxable?