Path: Admin > Universal Interface > Universal Interface Setup
Select the Work Order Export Transaction Type to export records using the Universal Interface framework. You have a choice of three export Connection Types: Comma Delimited Text File, Tab Delimited Text File, or Microsoft SQL Server.
The Export Query is used only to determine the records to be exported. Select an existing Browse Query to serve as the Export Query. The selected Export Query has no impact on the data columns that are used in the export process.
ALERT: Each work order can be exported only once. Even if you use a new WebTMA Universal Interface setup, when a work order has been exported previously using the Universal Interface function, it will not export a second time.
Once a record has been exported, the xx_uiExport Boolean field is updated with a value of 'true'. Records with a true xx_uiExport value are excluded from the export query to prevent duplicate data from being exported.
Be sure to select a folder so an error log can be generated.
The WebTMA Integration Client Service Configuration (Stand-alone windows application) Service includes fields to support exporting records.
Remember to add at least one Repair Center to the Repair Center Tab.
When lines are exported, WebTMA marks the read-only Universal Interface Export check box found on the Modification History popup when you click the Last Modified link on the Action Menu of the related record. The Universal Interface Export field is available in the Report Writer.
How to Link Fields for Work Order Export
In order to export your work order records, you must link WebTMA fields with fields within your Universal Interface table. By default, all required fields should already have line entries. Edit those records and then add elective fields.
From your Universal Interface Setup window in Add/Edit mode:
- Complete the Required Setup fields defined above.
- Click the Add Column link on the grid to open the Column Mapping popup window.
- Choose your WebTMA Column.
- Select the Remote Column.
- Click Save & Add (or Save & Close).
- Repeat until all fields in your Universal Interface table have been matched up.
- Add the applicable Repair Center(s) to the Repair Center
- Click Save on the WebTMA toolbar.
Work Order Export Columns
In logical sequence, the following table lists the Work Order fields available for export.
| ColumnName | DataType | MaxLength | DecinalPlaces | IsRequired | AllowDefault | AllowAutoCreate |
| Primary Key | int | 4 | No | No | No | |
| Work Order # | nvarchar | 20 | No | No | No | |
| Facility Code | NULL | NULL | NULL | No | No | No |
| Building Code | NULL | NULL | NULL | No | No | No |
| Building Name | NULL | NULL | NULL | No | No | No |
| Floor Code | NULL | NULL | NULL | No | No | No |
| Location ID | NULL | NULL | NULL | No | No | No |
| WebTMA Item Type | int | 4 | No | No | No | |
| Item Code | NULL | NULL | NULL | No | No | No |
| Priority Code | NULL | NULL | NULL | No | No | No |
| Repair Center Code | NULL | NULL | NULL | No | No | No |
| WO Type Code | NULL | NULL | NULL | No | No | No |
| Chargeable? | bit | 1 | No | No | No | |
| Charge Account # | NULL | NULL | NULL | No | No | No |
| Department Code | NULL | NULL | NULL | No | No | No |
| Request # | NULL | NULL | NULL | No | No | No |
| Status | nvarchar | 255 | No | No | No | |
| Requestor | nvarchar | 75 | No | No | No | |
| Requestor Phone | nvarchar | 25 | No | No | No | |
| Requestor Email | nvarchar | 200 | No | No | No | |
| Request Date | datetime | 8 | No | No | No | |
| Estimated Start Date | datetime | 8 | No | No | No | |
| Estimated End Date | datetime | 8 | No | No | No | |
| Finish Date | datetime | 8 | No | No | No | |
| Completion Date | datetime | 8 | No | No | No | |
| Print Date | datetime | 8 | No | No | No | |
| Action Requested | nvarchar | 4000 | No | No | No | |
| Supervisor | nvarchar | 255 | No | No | No | |
| Reference # | nvarchar | 20 | No | No | No | |
| TQM | bit | 1 | No | No | No | |
| General Comments | ntext | 8 | No | No | No | |
| Out Of Service? | bit | 1 | No | No | No | |
| Warranty Job? | bit | 1 | No | No | No | |
| Service Job | bit | 1 | No | No | No | |
| Operator Name | NULL | NULL | NULL | No | No | No |
| Operator Error? | bit | 1 | No | No | No | |
| Risk to Operator? | bit | 1 | No | No | No | |
| Risk to Patient? | bit | 1 | No | No | No | |
| Action Required by Department | bit | 1 | No | No | No | |
| Building Services Signoff | datetime | 8 | No | No | No | |
| Department Signoff | datetime | 8 | No | No | No | |
| Department Head | nvarchar | 50 | No | No | No | |
| Department Action | ntext | 8 | No | No | No | |
| Created Date | datetime | 8 | No | No | No | |
| Modified Date | datetime | 8 | No | No | No | |
| Creator | NULL | NULL | NULL | No | No | No |
| Modifier Name | NULL | NULL | NULL | No | No | No |
| Project # | NULL | NULL | NULL | No | No | No |
| Notify Me? | bit | 1 | No | No | No | |
| Overage Account # | NULL | NULL | NULL | No | No | No |
| Fixed Cost | bit | 1 | No | No | No | |
| Estimated Hours | decimal | 9 | 4 | No | No | No |
| Estimated Cost | decimal | 9 | 2 | No | No | No |
| From Device? | bit | 1 | No | No | No | |
| From Med Tester? | bit | 1 | No | No | No | |
| Skip Zone Auto Assign? | bit | 1 | No | No | No | |
| Auto Print? | bit | 1 | No | No | No | |
| From Service? | bit | 1 | No | No | No | |
| Start Creation Date | datetime | 8 | No | No | No | |
| Tax Name | NULL | NULL | NULL | No | No | No |
| Tax Rate 1 | decimal | 9 | 4 | No | No | No |
| Tax Rate 2 | decimal | 9 | 4 | No | No | No |
| Tax Compound? | bit | 1 | No | No | No | |
| Work Not Done? | bit | 1 | No | No | No | |
| Exclude From Requestor? | bit | 1 | No | No | No | |
| Fiscal Start | datetime | 8 | No | No | No | |
| X Coordinate | nvarchar | 30 | No | No | No | |
| Y Coordinate | nvarchar | 30 | No | No | No | |
| Additional Reference | nvarchar | 20 | No | No | No | |
| Account Program Code | NULL | NULL | NULL | No | No | No |
| Is Ticket? | bit | 1 | No | No | No | |
| Is Template? | bit | 1 | No | No | No | |
| Template Name | nvarchar | 150 | No | No | No | |
| 1st Failure Code | NULL | NULL | NULL | No | No | No |
| 1st Failure Sub-Code | NULL | NULL | NULL | No | No | No |
| 1st Contractor Code | NULL | NULL | NULL | No | No | No |
| 1st Contractor Name | NULL | NULL | NULL | No | No | No |
| 1st Scheduled Tech Name | NULL | NULL | NULL | No | No | No |
| UDF Date 1 | datetime | 8 | No | No | No | |
| UDF Date 2 | datetime | 8 | 4 | No | No | No |
| UDF Date 3 | datetime | 8 | 4 | No | No | No |
| UDF Date 4 | datetime | 8 | No | No | No | |
| UDF Date 5 | datetime | 8 | No | No | No | |
| UDF Date 6 | datetime | 8 | No | No | No | |
| UDF Int 1 | bigint | 8 | No | No | No | |
| UDF Int 2 | bigint | 8 | No | No | No | |
| UDF 2 DP Num 1 | decimal | 9 | 2 | No | No | No |
| UDF 2 DP Num 2 | decimal | 9 | 2 | No | No | No |
| UDF 2 DP Num 3 | decimal | 9 | 2 | No | No | No |
| UDF 2 DP Num 4 | decimal | 9 | 2 | No | No | No |
| UDF 4 DP Num 1 | decimal | 9 | 4 | No | No | No |
| UDF 4 DP Num 2 | decimal | 9 | 4 | No | No | No |
| UDF 4 DP Num 3 | decimal | 9 | 4 | No | No | No |
| UDF 4 DP Num 4 | decimal | 9 | 4 | No | No | No |
| UDF 4 DP Num 5 | decimal | 9 | 4 | No | No | No |
| UDF 4 DP Num 6 | decimal | 9 | 4 | No | No | No |
| UDF Bool 1 | bit | 1 | No | No | No | |
| UDF Bool 2 | bit | 1 | No | No | No | |
| UDF Bool 3 | bit | 1 | No | No | No | |
| UDF Bool 4 | bit | 1 | No | No | No | |
| UDF Bool 5 | bit | 1 | No | No | No | |
| UDF Bool 6 | bit | 1 | No | No | No | |
| UDF 255 Char 1 | nvarchar | 1000 | No | No | No | |
| UDF 255 Char 2 | nvarchar | 1000 | No | No | No | |
| UDF 255 Char 3 | nvarchar | 1000 | No | No | No | |
| UDF 255 Char 4 | nvarchar | 1000 | No | No | No | |
| UDF 255 Char 5 | nvarchar | 1000 | No | No | No | |
| UDF 255 Char 6 | nvarchar | 1000 | No | No | No | |
| UDF 255 Char 7 | nvarchar | 1000 | No | No | No | |
| UDF 30 Char 1 | nvarchar | 30 | No | No | No | |
| UDF 30 Char 2 | nvarchar | 30 | No | No | No | |
| UDF 30 Char 3 | nvarchar | 30 | No | No | No | |
| UDF 30 Char 4 | nvarchar | 30 | No | No | No | |
| UDF 60 Char 1 | nvarchar | 60 | No | No | No | |
| UDF 60 Char 2 | nvarchar | 60 | No | No | No |