Select the Fuel & Oil Import Transaction Type to import records using the Universal Interface framework. You have a choice of four export Connection Types: Comma Delimited Text File, Microsoft SQL Server, Oracle, or Tab Delimited Text File.
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. Since Fuel & Oil tickets can be written for either Equipment or Vehicle records, an Item Type column is required. Enter 0 (zero) for Equipment and 1 for Vehicle in the Default Value field on the Entry flyout.
WebTMA filters the column field selection to prevent duplicate selection. For example, Item Code is not available for selection when you click the Add Column link because it is 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.
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 Fuel & Oil Import
In order to import your Fuel & Oil records, you must link WebTMA fields with fields within your Universal Interface table. By default, most required fields should already have line entries.
From your Universal Interface Setup window in Add/Edit mode:
- Complete the required fields.
- Click the Add Column link on the grid to open the Entry flyout.
- Choose your 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.
The Item Type column is required to indicate whether this is for Equipment or Vehicle. Enter 0 (zero) for Equipment and 1 for Vehicle in the Default Value field on the Entry flyout.
The Repair Center Code column offers the option of designating a Repair Center as the Default Value. In addition, a Default 1st Record option is available. If the box is checked and data is passed in that field that does not match WebTMA, the service sets the Processed field to True but provides an error indicating the mismatch.
Fuel & Oil Import Required Fields
The following fields must be present in your outside database to accomplish a successful import of Fuel & Oil costs to WebTMA. When you add a new Universal Interface template, these 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 elective fields.
- Item Code – Validated field (text field)
- Item Type – Validated field (text field) either Vehicle or Equipment
- Repair Center Code – Validated field (text field)
- Ticket Date – Validated field (text field)
-
Want to Learn More?
Visit the WebTMA Help Page