System Profile
System Full Name | CAWIS Electronic Distribution Module |
Business Administrator | Sylvie Blais |
Business Owner | Marc Caouette |
Director | David Turnbull |
Subject Matter Expert | Alexandre Bédard |
Division | National Aircraft Certification |
NTARS Code | CA60(?) |
Source Location | |
Source Code Location | |
Migration to DevOps | |
New Source Code Location (DevOps) | https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/CAWIS-EDM |
Technology Assessment
Platform Type | Console |
|---|---|
Database Platform and Version | Oracle 18c |
Development Language and Framework | VB.NET |
Operating System and Version | Windows Server 2016 |
Additional Dependencies | TC Mailer, Mailbee, RightFax |
Authentication | None |
Environment Access Information
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV | \\ncrws514\d$\Scripts\CivAv\CAWIS-EDM (Dev) | CAWISD | ||
PREACC | PREACC_CA | |||
ACC | CAWISA | |||
PROD | CAWISP | |||
TRAINING |
System Overview
| View file | ||
|---|---|---|
|
...
Using Toad or SQL Developer, on the CAWISP database, download the template by looking at the “ATTACHMENT_NAME_NM” column in the table “CAWIS.A33_CAWIS_ATTACHMENTS”. The notice template is named “AAIR_NOTICE-1-en.txt” and the overdue template, “AAIR_OVERDUE-1-en.txt”. The data is located in ATTACHMENT_RAW.
Note: even if the attachment name says .txt, this is actually an HTML file.Open the file in an HTML editor, such as Notepad++.
Update the template using the client provided template.
Replace any wildcard value with the placeholders below.
Save the template and upload it to the same location as step 1.
Open CAWIS_EDM.exe.config and make sure that your email is in the “SmokeTestEmailInternal” setting.
Execute CAWIS-EDM using the following command using either the command prompt or Powershell: .\CAWIS_EDM.exe -TESTMODE
Select the option “1 – Internal Email Test” and wait for the email to arrive in your inbox.
Check the received email for any discrepancies with the client provided template.
Send the received email to the client for approval.
Keyword | Description |
%AAIR_YEAR% | Last Year (From EDM run date) |
%TAIL_MARK% | Aircraft tailmark |
%LAST_YEAR% | Last Year (From today) |
%TODAY_PLUS1_MONTH% | One month from today |
%CAWIS_URL% | CAWIS homepage URL |
%HELP_URL% | CAWIS help URL |
%HELP_URL_FRA% | CAWIS french help URL |
%SENT_MONTH_ENG% | Month on which the AAIR notice was issued (Fullname) |
%SENT_MONTH_FRA% | French month on which the AAIR notice was issued (Fullname) |
%DUE_DATE% | AAIR due date (Calculated from EDM run date) |
Updating the notice or overdue fax template
Using Toad or SQL Developer, on the CAWISP database, download the template by looking at the “ATTACHMENT_NAME_NM” column in the table “CAWIS.A33_CAWIS_ATTACHMENTS”. The notice template is named “AAIR_NOTICE-2-en.txt” and the overdue template, “AAIR_OVERDUE-2-en.txt”. The data is located in ATTACHMENT_RAW.
Note: even if the attachment name says .txt, this is actually an HTML file.Open the file in an HTML editor, such as Notepad++.
Update the template using the client provided template.
Replace any wildcard value with the placeholders below.
Save the template and upload it to the same location as step 1.
Open CAWIS_EDM.exe.config and make sure that your fax number is in the “SmokeTestFax” setting.
Execute CAWIS-EDM using the following command using either the command prompt or Powershell: .\CAWIS_EDM.exe -TESTMODE
Select the option “3 - Fax Test” and wait for the fax to arrive.
Check the received fax for any discrepancies with the client provided template.
Either re-run the fax test using the client fax number or send a scan of the received fax to the client for approval.
Keyword | Description |
@@AAIR_ACCESS_CODE | Aircraft access code (Confidential information) |
@@CAWIS_URL | CAWIS homepage URL |
@@AAIR_ISSUE_DATE | AAIR issue date |
@@AAIR_DUE_DATE | AAIR due date |
@@TAILMARK | Aircraft tailmark |
@@AIRCRAFT_TATC | Aircraft TACT code |
@@AUTHORITY | Aircraft type of authority |
@@PURPOSE | Aircraft purpose |
@@BASE_COUNTRY | Aircraft country |
@@BASE_PROVINCE | Aircraft province |
@@BASE_MUNICIPALITY | Aircraft municipality |
@@BASE_AIRPORT | Aircraft airport |
@@BASE_OTHER | Aircraft other location |
@@BASE_REGION | Aircraft region |
@@REPORTING_YEAR | Year before issue date (Format: JAN 1 TO DEC 31, {REPORTING_YEAR}) |
@@OWNER_NAME | Owner name |
@@ADDRESS_1 | Owner primary address |
@@CITY_PROV | Owner city and province |
@@POSTAL_CODE | Owner postal code |
@@AIRCRAFT_MAKE | Aircraft manufacturer |
@@AIRCRAFT_MODEL | Aircraft model |
@@AIRCRAFT_SERIAL | Aircraft serial number |
@@ENGINE_MAKE | Engine(s) manufacturer |
@@ENGINE1_MODEL | First engine model |
@@ENGINE1_SERIAL | First engine serial number |
@@ENGINE2_MODEL | Second engine model |
@@ENGINE2_SERIAL | Second engine serial number |
@@ENGINE3_MODEL | Third engine model |
@@ENGINE3_SERIAL | Third engine serial number |
@@ENGINE4_MODEL | Fourth engine model |
@@ENGINE4_SERIAL | Fourth engine serial number |
@@PROP_MAKE | Propeller(s) manufacturer |
@@PROP1_MODEL | First propeller model |
@@PROP1_SERIAL | First propeller serial number |
@@PROP2_MODEL | Second propeller model |
@@PROP2_SERIAL | Second propeller serial number |
@@PROP3_MODEL | Third propeller model |
@@PROP3_SERIAL | Third propeller serial number |
@@PROP4_MODEL | Fourth propeller model |
@@PROP4_SERIAL | Fourth propeller serial number |
@@SKI_MAKE | Ski manufacturer |
@@SKI_MODEL | Ski model |
@@FLOAT_MAKE | Float manufacturer |
@@FLOAT_MODEL | Float model |
@@TC_LINE1 | Formatted tailmark (Format: TRANSPORT CANADA {Tailmark}) |
@@TC_LINE2 | TC address (First line) |
@@TC_LINE3 | TC address (Second line) |
@@TC_LINE4 | TC city and province (Format: {City} {Province}) |
@@TC_LINE5 | TC postal code |
@@EMPTY_ACTUAL | Aircraft actual empty weight |
@@EMPTY_AMENDED | Aircraft amended empty weight |
@@MAX_WEIGHT | Aitcraft maximum takeoff weight |
@@ACTUAL_DATE | Last updated date of aircraft actual weight |
@@AMENDED_DATE | Last updated date of aircraft amended weight |
@@EMAIL_ADDRESS | Aircraft email address |
@@FAX_NPA | Numbering plan area of the owner fax number |
@@FAX_NXX | Central office code of the owner fax number |
@@FAX_NUM | Line number of the owner fax number |
@@AW | Checked if actual landing configuration is 'WHEELS' (Format: X) |
@@AF | Checked if actual landing configuration is 'FLOATS' (Format: X) |
@@AS | Checked if actual landing configuration is 'SKIS' (Format: X) |
@@AMW | Checked if amended landing configuration is 'WHEELS' (Format: X) |
@@AMF | Checked if amended landing configuration is 'FLOATS' (Format: X) |
@@AMS | Checked if amended landing configuration is 'SKIS' (Format: X) |
@@TKOFFW | Checked if takeoff configuration is 'WHEELS' (Format: X) |
@@TKOFFF | Checked if takeoff configuration is 'FLOATS' (Format: X) |
@@TKOFFS | Checked if takeoff configuration is 'SKIS' (Format: X) |
EDM General Help
Sends notice to aircraft owners about upcoming AAIR due date.
CAWIS_EDM [-FLAG=VALUE]
Flag Name | Description [Possible Values] |
|---|---|
-TYPE= | [AAIR_NOTICE | AAIR_OVERDUE] |
-STEP= | [EMAIL | 1 | FAX | 2 | FTP | SNAILMAIL | 3 | REPORT | 4 | CLEANUP | 99] Outdated (missing parsing steps) |
-DATE= | Date to use (YYYY-MM-DD format) |
-WAIT | Wait for user input when execution is finished |
-TESTMODE | Enter in test mode. Allow individual testing of each modules. |
-FINDMAIL | Allow searching the mailbox using a message ID |
-PARSEMAIL | Parse email without adding entry in the database |
-DIAGNOSTIC | Check flag for this month entries. Output to current folder. |
-SMOKETEST | Send test email and fax and test the FTP and mailbox connection. |
-SIMULATION | Emails and faxes aren't being sent, but still logs the operations. |
-?, -USAGE | Show this help. |
Example: CAWIS_EDM -TYPE=AAIR_NOTICE -STEP=EMAIL -DATE=2010-01-01
...