NDWL - LWND

System Profile

System Full Name	National Aeronautical Product Approval (NAPA) Delegate Web Link (NDWL)
System Full Name (French)	Système national d'approbation de produits aéronautiques (SNAPA) - Lien Web du délégué (LWND)
Business Administrator	Greg Oucharek
Business Owner	John Deruchie
Director	Philippe Ngassam
Subject Matter Expert (Maintenance Team)	Christopher Collins
Division	National Aircraft Certification
NTARS Code	CA33
Source Location
Source Code Location NDWL-LWND	http://tfsprod:8080/tfs/civav/NDWL-LWND/_dashboards
New Source Code Location (DevOps) NDWL-LWND	https://transport-canada@dev.azure.com/transport-canada/DSD-CIVAV Support/_git/NDWL-LWND
Migration to DevOps
Source Code Location NDWL-LWND_ASP	http://tfsprod:8080/tfs/civav/NDWL-LWND_ASP/_dashboards
New Source Code Location (DevOps) NDWL-LWND_ASP	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/NDWL-LWND_ASP/
Migration to DevOps
Source Code Location NDWL-LWND-WAAU	http://tfsprod:8080/tfs/civav/NDWL-LWND-WAAU/_dashboards
New Source Code Location (DevOps) NDWL-LWND-WAAU	https://transport-canada@dev.azure.com/transport-canada/DSD-CIVAV Support/_git/NDWL-LWND-WAAU
Migration to DevOps

Technology Assessment

Platform Type	Web (External)
Database Platform and Version	Oracle 18C
Development Language and Framework	Classic ASP
Operating System and Version	Windows Server 2016
Additional Dependencies
Authentication

Environment Access Information

ENV	URL	DB
DEV		NNDEV
PREACC		NNPROJ
ACC	https://wwwapps2test.tc.gc.ca/saf-sec-sur/2/napa/	NNCLNT
PROD	http://wwwapps2.tc.gc.ca/saf-sec-sur/2/napa/	NNPROD
TRAINING		NNACEP

System Overview

The NAPA Delegate Web Link (NDWL) is a web based application that supports Transport Canada Civil Aviation Delegates in the processing of MOD (Modification of Aircrafts) projects and certificates as a function of the aeronautical product approval process.

Used by delegates to apply for, track, and issue Limited Supplemental Type Certificates, Repair Design Certificates and Parts Design Approvals. It also enables delegates to submit applications for Supplemental Type Certificates Online. NDWL provides a system using email to notify Aircraft Certification personnel of actions on the system by delegates (initiation, changes to projects, etc.).

Utilisé par les délégués pour faire une demande, un suivi, et émettre des certificats de type supplémentaires restreints, des certificats de conception de réparation et des approbations de conception de pièces. Le système permet également aux délégués de soumettre en ligne des demandes de certificats de type supplémentaires. Le LWND fournit un système de courrier électronique pour aviser le personnel de la Certification des aéronefs des mesures prises sur le système par les délégués (nouveaux projets, modifications aux projets en cours, etc.).

Document	Details
NAPA Delegate Web Link 2.0 Help
D'aide 2.0 pour l'application Lien Web du délégué
NAPA Delegate Web Link 2.0 Quick Start Guide
Guide_de_référence_rapide_de_NDWL_version_2.0
NDWL Release 2.6.5 - 2018-06-25 - What’s New
LWND Release 2.6.5 - 2018-06-25 - Quoi de neuf

Good To Know

The “main” branch in NDWL-LWND in TFS does not have any files or folders to be migrated.

Furthermore, the NDWL-LWND and NDWL-LWND-WAAU repositories don't have any release branches.

NDWL uses a very old component COMM+ which is used for uploading and printing of PDF. The COMM+ component is often causing issues and is also used by the Marine applications SIRS and CSPCS.

How-To and Fixes

For NDWL, we need:

Registered aspSmartUpload.dll
```
Regsvr32 "LocalInformationAboutThisDll"
```
Copy aspSmartUpload.dll and aspSmartUploadUtil.dll in C:\Windows\SysWOW64
/wiki/spaces/MAR/pages/2399600703

NOTE: https://coreysalzano.com/how-to/aspsmartupload-dll/