Overview

AAIR backlog item board

https://dev.azure.com/transport-canada/DSD-CIVAV Support/_boards/board/t/AAIR/Backlog items

Backups of development and acceptance code deployed to servers

As agreed by the maintenance team in August 2023 backups are stored on level up from the application folder rather than inside those folders.

See
External: CAWIS Ext - SWIMN Ext - BSD - Civil Aviation - Confluence (atlassian.net)

Internal: CAWIS Int - SWIMN Int - BSD - Civil Aviation - Confluence (atlassian.net)

...

Publishing to acceptance and production

CAWIS External: use the Staging profile to publish to acceptance and production. It does not contain the admin modules. Using the incorrect profile will expose protected B info.

CAWIS Internal: use the Acc profile to publish to acceptance and production

Refer to the following document:
CAWIS EXT - VS - CAWIS INT - BSD - Civil Aviation - Confluence (atlassian.net)

AAIR Accounts on development and acceptance:

SCENARIO	USER ID	Mark (tailmark)
Password for all accounts is Clark2005! for development and acceptance
	005256
Single Aircraft	005197
Owner not reported in years	596873
Regular user	014885
Fleet	558885	FALE
Fleet	003530	One of them is GDCL
Goes directly to Modify mode without having to press a Modify button.	004084
	007278

AAIR – Updating the AAIR Password template:

Task: 306111 Message when user did not initiate a password change
Parent PBI is: 314412 Update messaging in long form
AAIR Backlog items Board - Boards (azure.com)

...

The script below was used to update the template in development. Note: it is important to ensure that the correct URLs are set for dev, acc and prod, in the English and French texts.

Code Block

SET DEFINE OFF;

update CAWIS.A42_EMAIL_CONTENT
set 

EMAIL_CONTENT_NAME_NM = 'AAIR_ACCESS_CODE_REQUEST',
EMAIL_FROM_TXT = 'AAIR/RAINA(TC)<tc.aair-raina.tc@tc.gc.ca>',
EMAIL_SUBJECT_ETXT = 'AAIR Notification - Forgotten User ID or Password',
EMAIL_SUBJECT_FTXT = 'Notification du RAINA - ID utilisateur ou mot de passe oublié',
LAST_MOD_BY_USER_ID ='ADMIN',
IS_IMPORTANT_IND = 'N',
LAST_MOD_TIMESTAMP_DTE = SYSDATE,
DATE_CURRENT_DTE = SYSDATE,

EMAIL_EBODY_LOB = 

'<pre>

Good<!DOCTYPE html>
<html lang="en">
<head><title>AAIR Notification - Forgotten User ID or Password</title>
<meta name="viewport" content="width=device-width,initial-scale=1" /><meta name="dc.title" content="CAWIS V3.0" /><meta name="dc.language" content="eng" /><meta name="dc.subject" content="CAWIS V3.0" /><meta name="dc.creator" content="Application Development and Technology Management" /><meta name="dcterms.modified" content="2014-03-01" /><meta name="dcterms.issued" content="2014-03-01" />
<script src="src/common.js"></script>
    <link href="Styles/cawis.css" rel="stylesheet" type="text/css" />
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>
    <script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>
        <link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/themes/smoothness/jquery-ui.css" />
</head>

<body>
<p>Good day, [%1%],</p>

Your<p>Your User ID is [%6%]. Please record this User ID as it will remain the same each year.</p> 

Please click the link to log into the AAIR portal:<br />
https://catcappsx.tc.gc.ca/Saf-Sec-Sur/2/cawis-swimn/a_l.aspx?a=&lang=eng<br />

Forgotten<br password?/>
If you forgot have forgotten your password, are a newly registered aircraft owner or wantare new to changethis yourAAIR passwordportal, please click create a new password by clicking the link below:<br />
https://catcappsx.tc.gc.ca/Saf-Sec-Sur/2/CAWIS-SWIMN/ForPss.aspx?m=A&lang=eng&hsh=[%2%]<br />

Please<p>Please be aware that:</p>
<ul>
<li> The password link is valid for the next 24 hours from the receipt of this email;</li>
<li> The password link can only be used once;</li>
<li> This request nullifies any previous request; </li>
<li> If you''re having trouble with the link, copy and paste it into your web browser.</li>
</ul>

For<p>For security reasons, this request was received at [%5%]. If you did not initiate this request,
please notify the AAIR team in writing at <a href="mailto:tc.aair-raina.tc@tc.gc.ca">tc.aair-raina.tc@tc.gc.ca</a>.</p>

Thank<p>Thank you,</p>

The<p>The AAIR team team</p>

</body>

</pre>html>',


EMAIL_FBODY_LOB = 
'<pre>

Bonjour<!DOCTYPE html>
<html lang="fr">
<head><title>Notification du RAINA - ID utilisateur ou mot de passe oublié</title>
<meta name="viewport" content="width=device-width,initial-scale=1" /><meta name="dc.title" content="CAWIS V3.0" /><meta name="dc.language" content="eng" /><meta name="dc.subject" content="CAWIS V3.0" /><meta name="dc.creator" content="Application Development and Technology Management" /><meta name="dcterms.modified" content="2014-03-01" /><meta name="dcterms.issued" content="2014-03-01" />
<script src="src/common.js"></script>
    <link href="Styles/cawis.css" rel="stylesheet" type="text/css" />
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>
    <script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>
        <link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/themes/smoothness/jquery-ui.css" />
</head>

<body>

<p>Bonjour, [%1%],</p>

Votre<p>Votre identifiant d’utilisateur est [%6%]. Veuillez noter votre identifiant d’utilisateur car il restera le même chaque année.</p>

Cliquez sur le lien suivant pour vous connecter au portail RAINA :<br http/>
https://catcappsx.tc.gc.ca/Saf-Sec-Sur/2/CAWIScawis-SWIMNswimn/a_l.aspx?a=&lang=frafra<br />
Mot
de<br passe/>
oublié? Si vous avez oublié votre mot de passe, si vous êtes un propriétaire d''aéronef nouvellement enregistré ou si vous souhaitez changer votre êtes nouveau sur ce portail RAINA, veuillez créer un nouveau mot de passe, veuillezen cliquercliquant sur le lien ci-dessous :<br />
https://catcappsx.tc.gc.ca/Saf-Sec-Sur/2/CAWIS-SWIMN/ForPss.aspx?m=A&lang=fra&hsh=[%2%]<br />
Sachez
<p>Sachez que:</p>
<ul>
<li> Le lien vers le mot de passe est valable pendant les 24 heures qui suivent la réception de ce courriel;</li>
<li> Ce lien vers le mot de passe ne peut être utilisé qu''une seule fois;</li>
<li> Cette requête annule toute requête précédente;</li>
<li> Si vous rencontrez des problèmes avec le lien, copiez-le et collez-le dans votre navigateur Web.</li>
</ul>

Pour<p>Pour des raisons de sécurité, cette requête a été reçue à [%5%]. Si vous n''êtes pas à l''origine de la demande,
veuillez en informer l''équipe RAINA par écrit à l''adresse suivante :  <a href="mailto:tc.aair-raina.tc@tc.gc.ca">tc.aair-raina.tc@tc.gc.ca</a>.</p>

Merci<p>Merci,</p>



L<p>L''équipe RAINA RAINA</p>
 
    
</body>
</pre>html>'

where EMAIL_CONTENT_ID = '44';

commit;

Configuration:

See: CAWIS - configuration settings for Dev and Acc (TR47_CAWIS_GENERAL_PROPS and web.config)

Info
The setting COPY EMAIL ADDRESSES should be set to the current product owner on Acceptance and Production. See the script provided below.

Code Block

language	sql

--Acceptance and Production
--Update the EMAIL COPY ADDRESSES (an AAIR setting) to current product owner.
UPDATE TR47_CAWIS_GENERAL_PROPS
SET PROPERTY_VALUE = 'GENEVIEVE.BOURGEOIS@TC.GC.CA',
LAST_MOD_TIMESTAMP_DTE = SYSDATE,
LAST_MOD_BY_USER_ID = 'ADMIN'
WHERE      UPPER(PROPERTY_NAME) = UPPER('EMAIL COPY ADDRESSES');

Shared Mailboxes

The following shared accounts are applicable on both development and acceptance. All members of the maintenance team have access:
1. On development, the email address for these shared accounts is set to our shared CAWIS development mailbox.
  - On email box address is cawis-dev-swimn@tc.gc.ca
2. On acceptance the address is: cawis-acc-swimn@tc.gc.ca
3. On production the address is: tc.aair-raina.tc@tc.gc.ca

See: Shared Mailbox Mapping Procedure

Updated texts for AAIR Owner form with contact info only (short form)

All new messaging that should appear on various AAIR pages is contained within this document - AAIR - November notification to aircraft owners.docx

Updated contact PDFs are posted to dev and acc, were also deployed to Production

See subtask 311255 Replace existing PDF under Contact List menu with new PDF

Document locations on dev and acc

EXTERNAL DEV - \\ncrws499\cawwwappsx\saf-sec-sur\2\AWD-CN\documents

...

INTERNAL ACC - \\tcapps2test\tcappsroot\saf-sec-sur\2\AWD-CN\documents

Business Rules:

Creating an AAIR Account:

Login to CAWIS Internal as a TC User.
To obtain current tail marks run the following report: 5008 Files by Owner.

...

Select 5008 Files from the left-side menu.
Do a quick search by tail mark:
- type in 2 letters - for example "FE"
Change email address to one that you can access.
Save.
Logout.
On the external website, Login AAIR
Click forgot user id or password.
- It will ask for the tail mark and email address that you changed in the 5008
CAWIS will send you an email with a link and click open link
It will ask to create a password
Save
Take note of the client id in the email.
Login AAIR: client id & password (that you created)

AAIR info from October 2023 discussions onward:

TC login uses the TC login ID but the password is not the same.
For TC Login, the same credential works on both CAWIS internal and external.
I have provided access for the TC Login option on CAWIS development and acceptance to all members of the maintenance team.
Maintenance team have access to CAWIS prod for maintenance purposes only (Only for work related to tasks submitted by the client. No changes can be made without approval from the client)
AAIR does not use our TC Login credentials.
AAIR login is unlocked on CAWIS external for development and acceptance.
- The same AAIR credentials work on both CAWIS external and internal
- AAIR login is currently purposely locked on prod per work that Hiren and I collaborated on in March 2023
- See also https://dev.azure.com/transport-canada/DSD-CIVAV%20Support/_boards/board/t/AAIR/Backlog%20items
AAIR login is locked on all CAWIS internal instances (development, acceptance and production).
- See Subtask 301363 https://dev.azure.com/transport-canada/DSD-CIVAV%20Support/_boards/board/t/AAIR/Backlog%20items
- Should the option for AAIR login be displayed on CAWIS internal?

Versions Compared

Old Version 21

New Version 22

Key

Overview

AAIR backlog item board

Related documents regarding AAIR/5008

Backups of development and acceptance code deployed to servers

AAIR Accounts on development and acceptance:

AAIR – Updating the AAIR Password template:

Configuration:

Shared Mailboxes

Updated texts for AAIR Owner form with contact info only (short form)

Updated contact PDFs are posted to dev and acc, were also deployed to Production

Business Rules:

Creating an AAIR Account:

AAIR info from October 2023 discussions onward:

Page Comparison

Versions Compared

Old Version 21

New Version 22

Key

Overview

AAIR backlog item board

Related documents regarding AAIR/5008

Backups of development and acceptance code deployed to servers

AAIR Accounts on development and acceptance:

AAIR – Updating the AAIR Password template:

Configuration:

Shared Mailboxes

Updated texts for AAIR Owner form with contact info only (short form)

Updated contact PDFs are posted to dev and acc, were also deployed to Production

Business Rules:

Creating an AAIR Account:

AAIR info from October 2023 discussions onward: