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 |
...
[Optional] Ask the client if they have new templates (see below for more details on how to update them).
When the scheduled time for the run approaches (10 minutes), go to the EDM folder (See Dev UNC in table above).
Open the “CAWIS_EDM.exe.config“ file. Make sure that the configuration “ClientEmailAddress” has your email address to receive the reports at the end of each steps.
In the “Scripts” folder, open the file “LaunchEDM.bat” file.
Remove the “rem” at the start of the file. This will un-comment the actual execution of EDM.
Depending of which type of run, some settings will need to be changed.
For “-TYPE”, if the run is for notices, put “AAIR_NOTICE” after the equal sign. For overdues, put “AAIR_OVERDUE” instead.
For “-STEP”, put the following value after the equal sign depending on which part of the run you are at (listed in the normal order): “EMAIL”, “EMAIL_PARSING”, “FAX”, “FAX_PARSING”, “FTP”.
[Optional] You may want to change the name of the log file. Any name is fine.
Note: To monitor the execution, you can open the log file in a text editor and reload it whenever you want an update. (I suggest Notepad++ since it makes reloading the file easier)
When the step is finished, put back the “rem” at the beginning to the batch file.
Send the confirmation email received from EDM to the client.
Return to step 4 until all the steps have been done (usually the FTP step). The recommended time between the steps is at least 3 days.
Important: Make sure that “rem” is at the beginning of the batch file to avoid that the program execute itself on other months.
Updating the notice or overdue email template (For developers)
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.
...
In case of program failure the program is designed to allow a re-run of a step any number of times.
Editing CAWIS EDM Template for notice and overdue notification (for CAWIS user)
Requires: Basic knowledge of HTML, CAWIS administrator account, Access to the internal version of CAWIS
Retrieving the HTML template
Login into CAWIS using credentials that have the AU role (administrative privilege).
Go to “Code Table Admin”, then “General” and then “CAWIS Attachments”.
Click on the template to edit and save it.
Rename the file extension from “.txt” to “.htm”.
Editing the HTML template
Open the file in a text editor.
[Optional] Open the file in a browser. This will let you see the changes you make when you save them and refresh the page in the browser.
Edit the file with the needed changes. All valid placeholders are located in “Code Table Admin” > “EDM” > “EDM Keywords”.
Note: Everything must resides within the HTML file. No external resource (such as images) are to be included, except for hyperlinks. Images can be included if encoded using Base64 directly into the HTML code.Save the file.
[Optional] Refresh the browser page previously opened and check for any problem.
Upload the HTML template
Go back to the “CAWIS Attachments” page.
Select the template to edit and click on “Upload”.
Upload the file using the “Browse” button. DO NOT check the “Update filename” checkbox.
Click on “Save”.
Validate the HTML template
Submit a ticket to the CAWIS development team to execute a test run for email or fax templates.
Wait for the test run to be complete. You will receive an email with placeholders replaced by test values.