CAWIS / WSDRS - FEEDBACK DATA EXTRACT REQUESTS

SEE PBI#115128 - CAWIS WSDRS - Feedback Magazine Datasets time frames for extractions needs to be more flexible

https://tc.canada.ca/en/aviation/aircraft-airworthiness/continuing-airworthiness/feedback-canadian-aviation-service-difficulty-reports

Feedback magazine is to be published quarterly by the Continuing Airworthiness publications group. Unfortunately when it is published late, the hard coded time parameters in the application will not permit the client to extract the required data for the required time frame.

The code to do this is available in the attachments here :

FEEDBACK-DATA-EXTRACT.TXT

Simply run the queries, drop the data into an Excel spreadsheet, attach the spreadsheet to the PBI, and notify the requestor.

A future CAWIS enhancement should be to remove these time frame restrictions on the data extract, and let the user select their own start and end dates.