System Profile
System Full Name | Master Minimum Equipment List | |
System Full Name (French) | Liste principale d'équipement minimal | |
Business Administrator | Carlos Carreiro/Kenneth Rofe | |
Business Owner | Andreas Hartono | |
Director | Philippe Ngassam | |
Subject Matter Expert | ||
Division | National Aircraft Certification | |
NTARS Code | CA28 | |
Source Location | ||
Source Code Location | ||
Migration to DevOps |
| |
New Source Code Location(DevOps) | https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/MEL-LEM |
Technology Assessment
Platform Type | Web (External) |
|---|---|
Database Platform and Version | MS Access |
Development Language and Framework | .NET |
Operating System and Version | Windows Server 2016 |
Additional Dependencies | |
Authentication |
Environment Access Information
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV | ||||
PREACC | ||||
ACC | \\wwwapps2test\wwwappsroot\Saf-Sec-Sur\2\MEL-LEM - \wwwdatatest\wwwdatabases | Acc URL: https://wwwapps2test.tc.gc.ca/Saf-Sec-Sur/2/MEL-LEM | ||
PROD | ||||
TRAINING |
System Overview
The Master Minimum Equipment List (MMEL) is an application used by Civil Aviation Headquarters, Regional, and Industry personnel. It contains relevant information with respect to the philosophy, development and approval of MMELs along with current approved revision status of MMELs and TC Supplements.
https://tc.canada.ca/en/aviation/general-operating-flight-rules/master-minimum-equipment-list-mmel
Good To Know
<--->
How-To and Fixes
Deletion of outdated doc files from the MMEL website
see PBI 207338 , SM-GS ticket C255102
Production document folders
https://wwwapps2.tc.gc.ca/saf-sec-sur/2/MEL-LEM/tcbbs/mmels/
https://wwwapps2.tc.gc.ca/saf-sec-sur/2/MEL-LEM/tcbbs/TEMPRev
https://wwwapps2.tc.gc.ca/saf-sec-sur/2/MEL-LEM/tcbbs/tcsup
Data Source=\ncrws329\wwwdatabases\MMEL.accdb
Acceptance document folders
https://wwwapps2test.tc.gc.ca/saf-sec-sur/2/MEL-LEM/tcbbs/mmels
https://wwwapps2test.tc.gc.ca/saf-sec-sur/2/MEL-LEM/tcbbs/TEMPrev
https://wwwapps2test.tc.gc.ca/saf-sec-sur/2/MEL-LEM/tcbbs/tcsup
Data Source=\ncrws499\wwwdatabases\MMEL.accdb
In this instance, the client requested removal of ALL .DOC files from the MMEL website, as they now only publish PDF versions. The MDB file does not specify file types, only the file names without extensions, so deleting a file from the web folder is sufficient to remove web links.
All of the DOC files were backed up into the PBI 207338 and the CSSG server and removed from the MMEL website - with the exception of one document, No_Elec.doc
No_Elec.doc is a default document which directs the User to the country of Origin/TCH holder for any given product, when TCCA does not have the requested MMEL info
Currently (Oct-2022) No_Elec.doc is hard coded into the ASP to provide both a DOC link and a PDF link when the filename No_elec is provided into the MDB database for a given make/model entry. The database does NOT specify file types (PDF/DOC)
And so it displays the DOC link regardless of No_Elec.doc not being present in the web folder. For now its been left in the webfolder (https://wwwapps2.tc.gc.ca/saf-sec-sur/2/MEL-LEM/tcbbs/mmels/) as it is fairly static information.
All other MMEL DOCs have been removed - and the corresponding links to those docs, no longer appear on the site.
-
SM-GS ticket C255102 was created to request removal of the outdated DOC files. ( The description on the main ticket page does not match what was ultimately requested (removal of all DOCs) as SMGS management would not allow it to be revised after the initial “2 document deletion” request had been approved.
0 Comments