System Profile
System Full Name | NAPA Delegate Web Link - Emailer |
Business Administrator | Carol Benoit |
Business Owner | Charles Lanning |
Director | David Turnbull |
Subject Matter Expert | Christopher Collins |
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) | https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/NDWL_Emailer_Application |
Technology Assessment
Platform Type | Client/Server |
|---|---|
Database Platform and Version | |
Development Language and Framework | PowerBuilder 2017R3 |
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 main uses for the NDWL Emailer
1. Delegate User control/Access
A. When a user is created an email is sent to external delegate with instructions (possibly a NDWL user guide) and a link to the NDWL application (also 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.
This PDF Data is then Viewable in NICO (Only Issued projects are in NICO).
5 Notify SCRAM that a project has been completed/issued.
P.S. All of the requests above are stored in the table NAPA_WEB_ACTIONS
Good To Know
The NDWL Emailer opens an MS Word document containing a Type 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… >
Add Comment