This menu provides a collection of miscellaneous tools
that users may find useful in very specific circumstances.
Users should consult their BAT administrator
or technical support for detailed descriptions of these tools,
as they may require more detailed and in-depth training to utilize.
This includes tools to assist in dealing with potential data entry errors
that could cause problems with using the CTS export templates.
Extract, transfer, load tools,
and building archiving tools.
These are lesser used and often designed for specific users,
so we will provide a high level overview for each
CTS Data Editor.
Agency Designated Project ID.
This tool is activated by clicking
the agency designated Project ID button.
This form can be used to quickly sort through all ECMs in the database
and identify which ones do not have an agency designated Project ID.
Typically, this ID
will be entered into the ECM implemented information form,
but this form can be used to add
or change such IDs in bulk.
These IDs are important to the proper population of the CTS
upload templates, and ECMs can be effectively grouped
by assigning the same project ID to multiple ECMs.
Note that the implemented initiated CTS upload
template will not work for an ECM without this ID.
To get back to the other tools tab.
Select administration from the toolbar at the top and then select
other tools from the sidebar.
CTS Data Editor
Agency designated covered Facility ID.
This tool is activated by clicking
the agency designated covered facility ID.
This form can be used to quickly short through all buildings in the database
and identify which ones do not have an agency covered.
Facility ID.
The form
can be used to add or change such IDs.
Note that the evaluated CTS upload template
will not work for a building without this ID.
To get back to the other tools tab, select administration from the toolbar
at the top and then select other tools from the sidebar.
ETL Export
The Extract Transfer Load tool built into the BAT is designed
to allow users to create custom exports of BAT data.
Instructions are provided in each of the template.
Use of these tools is intended for advanced users
familiar with ETL tools.
Building Archive.
The BAT does not explicitly
allow buildings to be deleted from the database.
However, buildings may be archived which remove them from the users
interface, but stores the data in a special archived system.
To use the tool, select the dropdown and select any buildings from the dropdown,
then select the archive Selected Building button.
Note that for users of CAPSIS this function is not necessary
given the archiving functions built into that system.