NDWL-Emailer - LWND-Emailer
- Alexandre Bédard
- Alain Asgill
- Samy Touabi (Unlicensed)
System Profile
System Full Name | NAPA Delegate Web Link - Emailer |
System Full Name (French) | Système national d'approbation de produits aéronautiques (SNAPA) - Lien Web du délégué (LWND) - EMailer |
Business Administrator | Greg Oucharek |
Business Owner | John Deruchie |
Director | Philippe Ngassam |
Subject Matter Expert (Maintenance Team) | Team Avro Arrows |
Division | National Aircraft Certification |
NTARS Code | CA33 |
Source Location |
|
Source Code Location | http://tfsprod:8080/tfs/civav/NDWL_Emailer_Application/_dashboards |
Migration to DevOps | |
New Source Code Location (DevOps) |
Technology Assessment
Platform Type | Client/Server |
|---|---|
Database Platform and Version |
|
Development Language and Framework | PowerBuilder 2021 |
Operating System and Version | Windows Server 2016 |
Additional Dependencies |
|
Authentication |
|
Environment Access Information
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV |
|
|
|
|
PREACC |
|
|
|
|
ACC |
|
|
|
|
PROD |
|
|
|
|
TRAINING |
|
|
|
|
System Overview
THE NDWL Emailer generates the MS Word documents for the delegates, emails it to them and then they can upload them back into the system. Once a project is approved and issued, it converts the MS Word files to .PDF and it is viewable in NICO.
The NDWL emailer application was created because when NDWL was built in 2004, this was the only way that documents could be generated for the application/delegates as classic ASP did not support this type of functionality. I'm sure there are better ways to do this but the time to analyze and investigate was never done.
The two Production servers work on a staggered start (1 at 0 seconds and the other starts at 30 seconds) to stop the two from working on the same row of data. This can be changed in the SETTINGS.INI that comes with the application and link to NAPA_SETTINGS_LKP in the database.
Also, within the SETTINGS.INI are the database names, User IDs, and passwords for the emailer to connect if using the database radial buttons.
The workstation must have Oracle, and MS Office installed (MS Outlook and MS Word)
The main uses for the NDWL Emailer are:
1. Delegate User control/Access
A. When a user is created in NDWL, an email is sent to external delegate with instructions (possibly a NDWL user guide) and a link to the NDWL application (including password).
B. When a user has password reset, they are sent an email.
2. Client Notification.
A. When an external Delegate creates a project, the TC Person OPI and Back up OPI are notified.
B. When the delegates request approval or approve, Request Issue or Issue the certificate the TC Person OPI and Back up OPI are notified.
C Notify Select users that the emailers are running every day at 3:05
3. Document Merging/Creating
A. Delegates cannot create/merge the documents themselves through NDWL. They request a certificate and the emailer
. Writes the temporary files, Downloads the template from the database, merges the files.
. Sends a copy of the certificate to the delegates and updates the database with the blob.
. Deletes the local temporary files.
4. When a project is Approved and Issued (In NDWL or NAPA). In addition to the document creation above.
The Emailer also saves the word document as a PDF to the database. (MOD_APRV_CERT_PDF, TA_DATASHEET_PDF)
This PDF Data is then Viewable in NICO (Only Issued projects are in NICO).
5 Notify SCRAM that a project has been completed/issued. (No longer required)
P.S. All of the requests above are stored in the table NAPA_WEB_ACTIONS, which is in the NAPA_NACIS database.
Good To Know
The NDWL Emailer opens an MS Word document containing a Type Certificate or MOD Certificate.
After, MS Word saves the Type Certificate as a PDF version, (instead of printing to the PDF Creator which is no longer required).
Then the NDWL Emailer uploads the PDF document to the database.
The PDF versions of the Type Certificates can be viewed in the NICO application (external website).
How-To and Fixes
<Sub-sections should describe how to address known support request, including any scripts, instructions / steps, etc… >
Document | RDIMS # or Link |
|---|---|
NDWL Emailer Application Workflow | |
|
|
NDWL Emailer Servers Location
The NDWL Emailers (three workstations) are located in the secure cabinet (can only be accessed by someone knowing the combination) at the TC office on the 11th Floor, Enterprise Building at 427 Laurier Avenue West.
There are three servers:
Production (NCRWKIT102446)
Production (NCRWKIT102448)
Development (NCRWKIT102447)