NDWL-Emailer - LWND-Emailer

System Profile

Technology Assessment

Environment Access Information

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

NDWL Emailer Servers Location

The NDWL Emailers (three servers) 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.

There are three servers:

• Production (NCRWKIT102446)

• Production (NCRWKIT102448)

• Development (NCRWKIT102447)