Versions Compared

Old Version 23

changes.mady.by.user Noreen Dertinger

Saved on

compared with

New Version 24

changes.mady.by.user Noreen Dertinger

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 22

Overview

AAIR backlog item board

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

Related documents regarding AAIR/5008

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)

Backups of Production Environments:

Backups of CAWIS production environments prior to any changes being made for AAIR (2023/2024)

CAWIS External:

\\tctestmaster\wwwappsroot\Saf-Sec-Sur\2\_backups\CAWIS-SWIMN\prod_backup

CAWIS Internal:
\\tctestmaster\tcappsroot\Saf-Sec-Sur\2\backup\CAWIS-SWIMN\CAWIS-Prod-2023

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)

Email templates are in the CAWIS table A42_EMAIL_CONTENT
The template for resetting the AAIR password is:
EMAIL_CONTENT_ID = 44
EMAIL_CONTENT_NAME_NM AAIR_ACCESS_CODE_REQUEST

Send_EMAIL_FUNCTION.fnc

  • The function for sending AAIR emails is handled in the CAWIS database: SEND_FUNCTION.fnc

  • To format the text, see the section -- Message header

  • The HTML formatting was enabled by uncommenting
    utl_smtp.write_data(l_maicon, 'Content-Type: text/html' || utl_tcp.crlf);

PK_AIRCRAFT:

To update the parameters in the email text found in the LOBs (EMAIL_EBODY_LOB, EMAIL_FBODY_LOB), for example, [%5%], see PK_AIRCRAFT.pkb, The relevant stored procedure is SP_SendAccessCodeEmail,  (L_EMAIL_BODY_ETXT and L_EMAIL_BODY_FTXT) of the package body. No changes were made in the package spec code.

Updating the email template:

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 = 

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

<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 />

<br />
If you have forgotten your password, are a newly registered aircraft owner or are new to this AAIR portal, please 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 />

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

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

<p>Thank you,</p>

<p>The AAIR team</p>

</body>

</html>',


EMAIL_FBODY_LOB = 
'<!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>

<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 />
https://catcappsx.tc.gc.ca/Saf-Sec-Sur/2/cawis-swimn/a_l.aspx?a=&lang=fra<br />

<br />
Si vous avez oublié votre mot de passe, si vous êtes un propriétaire d''aéronef nouvellement enregistré ou si vous êtes nouveau sur ce portail RAINA, veuillez créer un nouveau mot de passe en cliquant 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 />

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

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

<p>Merci,</p>

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

where EMAIL_CONTENT_ID = '44';

commit;

Configuration:

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

...