CAWIS-EDM

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	http://tfsprod:8080/tfs/civav/CAWIS-WAAU/_dashboards
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				CAWISD
PREACC				PREACC_CA
ACC				CAWISA
PROD				CAWISP
TRAINING

System Overview

Good To Know

<--->

How-To and Fixes

Updating the notice or overdue email 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-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. WARNING: You must remove the logs before doing the next run as they will interfere with the normal process.
-?, -USAGE	Show this help.

Example: CAWIS_EDM -TYPE=AAIR_NOTICE -STEP=EMAIL -DATE=2010-01-01

The program should be run 3 times (Step 1, 2, 3) per month with 3 days between to allow for bounces for each notice type (Regular notices, Overdue notices).

If you don't provide a date parameter today's date will be used. The resulting date used is always set to the first day of the given month

If you run with no parameters the program will send a test email, fax and test the FTP file access

Step 99 can be run in order to clear out previous inbox entries, database log entries and sent faxes

In case of program failure the program is designed to allow a re-run of a step any number of times.