Page Comparison

System Profile

Technology Assessment

Environment Access Information

System Overview

Good To Know

<--->

How-To and Fixes

Doing a run of EDM (Notice or overdue)

1. [Optional] Ask the client if they have new templates (see below for more details on how to update them).

2. When the scheduled time for the run approaches (10 minutes), go to the EDM folder (See Dev UNC in table above).

3. 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.

4. In the “Scripts” folder, open the file “LaunchEDM.bat” file.

5. Remove the “rem” at the start of the file. This will un-comment the actual execution of EDM.

6. Depending of which type of run, some settings will need to be changed.

   1. For “-TYPE”, if the run is for notices, put “AAIR_NOTICE” after the equal sign. For overdues, put “AAIR_OVERDUE” instead.

   2. 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”.

7. [Optional] You may want to change the name of the log file. Any name is fine.

8. 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)

9. When the step is finished, put back the “rem” at the beginning to the batch file.

10. Send the confirmation email received from EDM to the client.

11. 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.

12. 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

1. 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.

2. Open the file in an HTML editor, such as Notepad++.

3. Update the template using the client provided template.

4. Replace any wildcard value with the placeholders below.

5. Save the template and upload it to the same location as step 1.

6. Open CAWIS_EDM.exe.config and make sure that your email is in the “SmokeTestEmailInternal” setting.

7. Execute CAWIS-EDM using the following command using either the command prompt or Powershell: .\CAWIS_EDM.exe -TESTMODE

8. Select the option “1 – Internal Email Test” and wait for the email to arrive in your inbox.

9. Check the received email for any discrepancies with the client provided template.

10. Send the received email to the client for approval.

 Updating the notice or overdue fax template

1. 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.

2. Open the file in an HTML editor, such as Notepad++.

3. Update the template using the client provided template.

4. Replace any wildcard value with the placeholders below.

5. Save the template and upload it to the same location as step 1.

6. Open CAWIS_EDM.exe.config and make sure that your fax number is in the “SmokeTestFax” setting.

7. Execute CAWIS-EDM using the following command using either the command prompt or Powershell: .\CAWIS_EDM.exe -TESTMODE

8. Select the option “3 - Fax Test” and wait for the fax to arrive.

9. Check the received fax for any discrepancies with the client provided template.

10. Either re-run the fax test using the client fax number or send a scan of the received fax to the client for approval.

EDM General Help

Sends notice to aircraft owners about upcoming AAIR due date.

...