CAWIS RESOURCE MONITOR - SYSTEM MESSAGING AND LABELING
- kurt.martin
Related: PBI-172152 - Resource monitor report ; PBI-172153 Documentation required
CAWIS version 1.0 used a table called Z930_COLUMNS to administrate the text of all input fields and error messages.
This was replaced by the DA005_RESOURCE table when CAWIS was made WCAG compliant in 2018.
A copy of the Resource Monitor report can be found in the attachments section of this article. Its simply a dump of the DA005 table. The advantage of the report, is that it allows the system administrator to “globally” review the contents of the resource table when determining required changes.
Currently contains - 22487 records
ER - The resource monitor report needs to be added to the CAWIS reports menu
( Select * from DA005_RESOURCE )
A significant example of this would be in 2021 when the former generic email addresses for Continuing Airworthiness
needed to be located and altered to meet the new departmental standards in all onscreen messaging
1 TC.CAWWEBFEEDBACK-RETROACTIONWEBMDLN.TC@TC.GC.CA
though the original email addresses (circulated on CAW publications and forms for 20+ years) have auto-forwards placed on them.
Notes:
Revisions made to the resource table in the CAWIS test regions (DEV/ACC) are not migrated to production during a release. Any revisions made in the test regions need to be copied and pasted into production manually after the release -or- a script would need to be included in the release which updates DA005 accordingly
NOT ALL screen labels are actually found in the DA005 table. Example : the report titles under NEW on the reports menu
Revisions to the Resource table can only be performed by a CAWIS admin user on the INTERNAL site.
Maintenance
To access the Resource table admin facility
CAWIS-MAIN-MENU → CODE-TABLE-ADMIN → RESOURCE
Fig 1 CAWIS Code table Admin menu
Fig 2 The Resource Monitor page
Options
1.Reset CACHE - clear browser Cache
2.Reset APPLICATION DOMAIN - reset all CAWIS Login values (field labels, etc) This need to be done to invoke and review any changes made to the DA005 table using this facility
3.DAPLS - reset/renew DAPLS password. This taken care of by CAWIS admin.
NOTE the actual link to DAPLS is found under AAIR maintenance shown here
AAIR TC USER SUBMISSIONS INTERNAL - AAIR PAGE
under “STEP 5 APPLICANT LOOKUP“
unsure why this option is included here, it is unrelated to the function of the resource table. DAPLS info is occasionally used in the AAIR subsystem to acquire contact info for Owner individuals, who also have pilot licenses, when CAWIS contact data is found to be incomplete.
4.Resource Statistics - ?? The Value of this feature is questionable. Client does not understand this.
5.Select a page / enter a value - perform update operations on messages within specified subsystem of CAWIS
Fig 3 - Select a page - Identify the page where you need to make updates . In this instance, the 5008 advanced query page
(described here: CAWIS 5008 FILE MAINTENANCE )
Fig 4 - Select a page -
1- In “value”, enter freeform text of the messages you’d like to review (example : weight - returns all messages/labels related to aircraft weights found on that page )
2- in “select a key” we select the actual label to be updated - in this example, lblACWeight.Text
Fig 5 - Resource Editor
In this instance we make any desired update to the screen label in the VALUE box, then punch SAVE, Reset CACHE, Reset APPLICATION Domain - then go to the 5008 advanced search page and review our change on a sample aircraft down in the Weight section
Fig 6 Make a change, save & Reset Application Domain
Fig 7 Label change is successfully reflected on the 5008 advanced search
REPORT REQUIRED - CAWIS MESSAGES
###################################################
select
PATH_NM || ' ' ,
KEY_CD || ' ' ,
CULTURE_NM || ' ' ,
GLOBAL_IND || ' ' ,
VALUE_TXT || ' ' ,
VIRTUAL_KEY_NUM || ' ' ,
to_char(DATE_CREATED_DTE,'YYYY-MM-DD') || ' ',
TO_CHAR(DATE_DELETED_DTE,'YYYY-MM-DD') || ' ',
TO_CHAR(DATE_LAST_UPDATE_DTE,'YYYY-MM-DD') || ' ',
USER_LAST_UPDATE_ID || ' ',
TO_CHAR(SYSDATE,'YYYY-MM-DD') || ' ' AS RUNDATE
from DA005_RESOURCE ;
####################################################