The Requestor User Import Transaction Type requires at least one Repair Center added to 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, Login ID 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.
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 Requestor User Import
In order to import Requestor User lines, you must link WebTMA fields with fields in your Universal Interface table. By default, all 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.
NOTE: If you want records to be updated, make sure to populate the TMA Column AllowUpdate on the import files. When no value is entered for the AllowUpdate, WebTMA only inserts new records. To inactivate or modify any data on the records on saved records, the value “TRUE” must be entered in the data imported.
Requestor User Import Required Fields
The following fields must be present in your outside database to accomplish a successful import of Requestor Users 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 Requestor User Import Elective Fields.
- Login ID – (text field)
- Group Name – (text field)
Want to Learn More?
Visit the WebTMA Help Page