Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

System Profile

System Full Name

CAWIS Electronic Distribution Module

Business Administrator

Sylvie Blais

Business Owner

Marc Caouette

Director

Philippe Ngassam (Acting)

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

...

  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

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' ;