The Universal Interface for Building Automation System (BAS) bundles two types of BAS records. These are:
- BAS Alert Import
- BAS Meter Import
BAS - Alert Import
BAS - Alert Import is part of the Universal Interface BAS bundle. The BAS - Alert Import 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, Requestor Name 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.
If you plan to include the Status field, it must be in your lookup table.
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 BAS - Alert Import
In order to import your BAS Alert files, you must link WebTMA fields with fields within 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.
BAS - Alert Import Required Fields
The following fields must be present in your outside database to accomplish a successful import of BAS Alert information 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.
- Action Requested – Validated field (text field)
- Request Date – Validated field (text field)
- Request Type Code – Validated field (text field)
- Requestor Name – Validated field (text field)
For Validated fields, the data must exist in the WebTMA database in order for the record to import with the field completed.
BAS - Meter Import
BAS - Meter Import is part of the Universal Interface BAS bundle The BAS - Meter Import 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, Meter Tag and New Reading 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.
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 BAS - Meter Import
In order to import your BAS Meter files, 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.
BAS - Meter Import Required Fields
The following fields must be present in your outside database to accomplish a successful import of BAS Meter information 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.
- Date – Validated field (text field)
- Item Code – Validated field (text field)
- Meter Name – Validated field (text field)
- New Reading – Validated field (text field)
- Technician ID – Validated field (text field)
- WebTMA Item Type – Validated field (text field)
For Validated fields, the data must exist in the WebTMA database in order for the record to import with the field completed.
If you do not have the Meter Code number in your BAS, you can mirror the Equipment tag number on the Meter Code number to identify the meter.
BAS - Meter Import Elective Field
You can include the following field for BAS Meter Import: Increment Value – (INT)