Due to the fact that NPrinting does not give you a nice calendar like overview of scheduled tasks I decided to create a Qlik Sense application that does this for you. Besides the ability to get an overview of scheduled tasks this application also sends out an NPrinting report whenever a task failed to run. 

For this Qlik Sense applcation to work you need to create a connection to the NPrinting Repository Database and two REST API connections (GET and POST) for running an NPrinting report when tasks failed.

The dashboard page gives an overview of scheduled, failed, aborted and completed tasks.

All files and documentation for setting up the application and the connections can be found on Qlik Branch

Installation

1. Download this Qlik Sense app in a zip file using the 'Clone or Download' button
2. Extract the qvf file from the zip
3. Navigate to 'Apps' under the QMC (Qlik Management Console)
4. Import the qvf file

Getting Started

1. Navigate to the Data Load Editor
2. Create a Data Connection to the REST API for GET and POST and to the NPrinting Repository Database
3. Navigate to the Set Variables tab
4. Add the created connection names to the variables for vAPIConnectionNameForGET, vAPIConnectionNameForPOST and vNPRepoConnection
5. Set the correct servers in the vNPrintingServer and vQlikSenseServer
6. Set the NPrinting Publish Task Name in vNPrintingPublishTaskName if you created a NPrinting report and Publish task for Failed reports
7. In the CALL NP API tab there is a check to validate if there are Failed Tasks, if so the report get's send out.

NPrinting Report Template

1. Create a NPrinting app called NPrinting Schedule Monitor
2. Create a connection to the Qlik Sense Schedule Monitor app in Qlik Sense
3. Navigate to Reports in NPrinting and press import report and choose the NPrinting Schedule Monitor App
4. Import the zip file NPrinting Daily Failed Task Report Template.zip by browsing to the zip file
5. Press Next
6. Give the Report a title or use the existing title and press Next
7. Choose connection you created and press Next
8. In the Filters screen press Next
9. In the Summary screen validate the choices made and press Confirm

Reload the app

1. Open Qlik Sense and navigate to the Schedule Monitor app.
2. Run a manual reload to see if everything works
3. Schedule the reload of this app in the QMC Task Scheduler
4. If a NPrinting task has failed the NPrinting Report will be send out

Description-

• Beginning from Nprinting 17.1.1.0, Nprinting can send emails to recipients even when the email server is configured with users with encrypted passwords.
• using gmail account may not work initially because gmail has a security setting which stops nprinting from sending emails to recipients.

Cause-

Gmail security setting

Resolution-

First set up Nprinting email settings.

Navigate to the following page in Nprinting to set up the email server, on Nprinting Management console clock on Admin --> Settings --> Email Settings

• Give a name to the smtp server. i.e email server.
• enter Gmail smtp address smtp.gmail.com.
• Enter the port. Normally it should be 587, but could sometimes be 465 or 25.
• You can be sure that the server can connect to Gmail by a simple telnet test. e.g telnet smtp.gmail.com 587 or smtp.gmail.com 465.
• enable "use TLS (transport layer security)".
• Enter your Gmail email address and password.
• Enter your default sender email (usually same as your Gmail email address).

Configure gmail to allow less secure apps-

For security reasons Gmail restricts sign-in attempts from some applications, at the moment, this affects NPrinting 17.

• For change the setting, go to the https://myaccount.google.com/security and signin.

• Click on Signin button and Log in with your credentials.

• It automatically redirected you to the security page from there click on Turn on access (not recommended).

• After clicking on Turn on access (not recommended), you will enter in Less Secure app access setting. From here ON the Allow less secure apps, Changed to ON.