CAWIS EDM - SWIMN MDE

System Profile

Technology Assessment

Environment Access Information

System Overview

Open

Good To Know

<--->

How-To and Fixes

Doing a run of EDM (Notice or overdue)

1. PRIOR TO EXECUTION - ask the client if the AAIR-fleets are up to date. Fleet reporters are not to be included in the EDM. The FLEET report is available from the CAWIS reports menu.

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

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

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

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

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

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

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

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

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

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

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

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

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.

CAWIS_EDM [-FLAG=VALUE]

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.

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

1. Login into CAWIS using credentials that have the AU role (administrative privilege).

2. Go to “Code Table Admin”, then “General” and then “CAWIS Attachments”.

3. Click on the template to edit and save it.

4. Rename the file extension from “.txt” to “.htm”.

Editing the HTML template

1. Open the file in a text editor.

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

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

4. Save the file.

5. [Optional] Refresh the browser page previously opened and check for any problem.

Upload the HTML template

1. Go back to the “CAWIS Attachments” page.

2. Select the template to edit and click on “Upload”.

3. Upload the file using the “Browse” button. DO NOT check the “Update filename” checkbox.

4. Click on “Save”.

Validate the HTML template

1. Submit a ticket to the CAWIS development team to execute a test run for email or fax templates.

2. Wait for the test run to be complete. You will receive an email with placeholders replaced by test values.

POST EDM - Parsing the data

A week or so, after an EDM run, we want to identify any email addresses where we received bounce-backs, so that the Publications unit can eliminate these from CAWIS. To accomplish this, we run the -PARSEMAIL function.

Note :  A query like this, will let you know if the data has been parsed properly

Basically, we're searching AA003 for failures ( notification status = 3 )  where the client had a legitimate looking email.  This success/fail info will be available to CAWIS admin, on the AAIRDATA report, next day

Yes, it is possible that there were NO bad emails in the EDM run, but this would be a very rare occurrence.

SELECT * FROM AA003_NOTIFICATION_ATTEMPT

WHERE PROCESS_YEAR_MONTH_NUM = 'YYYYMM'

AND NOTIFICATION_TARGET_LBL NOT IN ('Blank Email Address',

'Failure due to notification preference' ,

'failure due to SMTP Error' )

AND NOTIFICATION_STATUS_CD = '3' ;