WEBVTT

1
00:00:00.367 --> 00:00:03.236
This menu provides
a collection of miscellaneous tools

2
00:00:03.236 --> 00:00:06.906
that users may find useful
in very specific circumstances.

3
00:00:07.340 --> 00:00:09.943
Users should consult their BAT administrator

4
00:00:09.943 --> 00:00:13.880
or technical support
for detailed descriptions of these tools,

5
00:00:14.147 --> 00:00:17.984
as they may require more detailed
and in-depth training to utilize.

6
00:00:18.485 --> 00:00:22.922
This includes tools to assist in dealing
with potential data entry errors

7
00:00:23.289 --> 00:00:27.394
that could cause problems
with using the CTS export templates.

8
00:00:28.261 --> 00:00:30.463
Extract, transfer, load tools,

9
00:00:30.463 --> 00:00:33.466
and building archiving tools.

10
00:00:34.501 --> 00:00:38.004
These are lesser used
and often designed for specific users,

11
00:00:38.438 --> 00:00:42.042
so we will provide a high level overview
for each

12
00:00:43.543 --> 00:00:45.845
CTS Data Editor.

13
00:00:45.845 --> 00:00:48.848
Agency Designated Project ID.

14
00:00:49.416 --> 00:00:51.251
This tool is activated by clicking

15
00:00:51.251 --> 00:00:54.254
the agency designated Project ID button.

16
00:00:55.321 --> 00:01:00.060
This form can be used to quickly sort
through all ECMs in the database

17
00:01:00.060 --> 00:01:04.597
and identify which ones do not have an
agency designated Project ID.

18
00:01:06.332 --> 00:01:07.801
Typically, this ID

19
00:01:07.801 --> 00:01:11.805
will be entered into the ECM
implemented information form,

20
00:01:12.572 --> 00:01:14.808
but this form can be used to add

21
00:01:14.808 --> 00:01:17.811
or change such IDs in bulk.

22
00:01:18.511 --> 00:01:23.083
These IDs are important
to the proper population of the CTS

23
00:01:23.083 --> 00:01:27.720
upload templates, and ECMs can be effectively grouped

24
00:01:28.421 --> 00:01:32.158
by assigning the same project
ID to multiple ECMs.

25
00:01:33.693 --> 00:01:37.864
Note that the implemented initiated
CTS upload

26
00:01:37.864 --> 00:01:41.334
template will not work for an ECM
without this ID.

27
00:01:43.036 --> 00:01:45.138
To get back to the other tools tab.

28
00:01:45.138 --> 00:01:49.042
Select administration from the toolbar
at the top and then select

29
00:01:49.042 --> 00:01:52.045
other tools from the sidebar.

30
00:01:52.779 --> 00:01:54.681
CTS Data Editor

31
00:01:54.681 --> 00:01:57.684
Agency designated covered Facility ID.

32
00:01:59.786 --> 00:02:01.321
This tool is activated by clicking

33
00:02:01.321 --> 00:02:04.290
the agency designated covered facility ID.

34
00:02:05.425 --> 00:02:09.662
This form can be used to quickly short
through all buildings in the database

35
00:02:09.929 --> 00:02:13.800
and identify
which ones do not have an agency covered.

36
00:02:13.800 --> 00:02:14.701
Facility ID.

37
00:02:16.269 --> 00:02:16.769
The form

38
00:02:16.769 --> 00:02:19.772
can be used to add or change such IDs.

39
00:02:19.906 --> 00:02:23.009
Note that the evaluated CTS upload
template

40
00:02:23.343 --> 00:02:26.346
will not work for a building
without this ID.

41
00:02:27.714 --> 00:02:31.751
To get back to the other tools tab,
select administration from the toolbar

42
00:02:31.751 --> 00:02:35.588
at the top and then select
other tools from the sidebar.

43
00:02:36.789 --> 00:02:39.425
ETL Export

44
00:02:39.425 --> 00:02:42.462
The Extract Transfer Load tool built into the BAT
is designed

45
00:02:42.462 --> 00:02:46.799
to allow users
to create custom exports of BAT data.

46
00:02:47.534 --> 00:02:50.537
Instructions are provided
in each of the template.

47
00:02:50.870 --> 00:02:53.506
Use of these tools is intended
for advanced users

48
00:02:53.506 --> 00:02:56.509
familiar with ETL tools.

49
00:02:56.509 --> 00:02:59.045
Building Archive.

50
00:02:59.045 --> 00:03:01.047
The BAT does not explicitly

51
00:03:01.047 --> 00:03:04.050
allow buildings to be deleted from the database.

52
00:03:04.250 --> 00:03:09.222
However, buildings may be archived
which remove them from the users

53
00:03:09.222 --> 00:03:13.493
interface, but stores the data
in a special archived system.

54
00:03:14.227 --> 00:03:19.265
To use the tool, select the dropdown and
select any buildings from the dropdown,

55
00:03:20.433 --> 00:03:23.670
then select the archive Selected
Building button.

56
00:03:24.337 --> 00:03:28.908
Note that for users of CAPSIS
this function is not necessary

57
00:03:28.942 --> 00:03:32.145
given the archiving functions
built into that system.