Transport Canada
Continuing Airworthiness Web Information System (CAWIS)
...
Data Extract Procedure
Kurt Martin - 2021-08-03
PBI #112722 - produce monthly report
PBI #172651 - add this report to the CAWIS menu
######################
Overview
A data extract provided to the Aircraft Certification publications section on or about the first business day of each month.
Step 1
go to
\\ncrfs345\GROUPS\AARD\AARD Public\CAWIS-REPORTS\AAIR-REPORTS\02-MONTHLY-REVISIONS
...
Execute this code – SEE ATTACHMENT
Please note : this code will always extract Y05 log data for the PREVIOUS month, for the Current reporting year (where reporting-year = current-year -1)
Step 4 –
Export the data to a text file. Import that text file to the new spreadsheet, save a copy to the archive (where you got the original xlsx) and email this month's report to Eric Lanthier .notify the requestor via DevOps
Note : its it is perfectly normal that much less data appears in this report as the year progresses, as more operators have already reported
...
2 access to the the server location \\ncrfs345\GROUPS\AARD\AARD Public\CAWIS-REPORTS
...