topic Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load in Qlik NPrinting

Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

sam_1919 — Wed, 25 Sep 2019 18:40:54 GMT

Hi All,

1. How to trigger a Qlik NPrinting task automatically as soon as

the Qlik Sense application is loaded with the data.

2. Also there is a UserID in one of the fields of Qlik Sense.

How to Specifically send the data associated to that user id to the respective mails to the user with that User ID?

Currently we are having

NPrinting February 2018

and

Qlik Sense Server February 2018.

It would be helpful if i get the information at the earliest.

Thanks and Regards

Saiprasad Ashok More

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

escayolaj — Thu, 01 Mar 2018 19:21:48 GMT

1. I am not sure if it's possible, I would say no. Maybe using the QlikSense API and Nprinting API but no idea exactly how.

2. For that you need to apply section access: Nprinting will automatically split the data and reports based on the section access you set up in the source QlikSense application. Make sure to check the box "Apply Section Access" when creating the connection to your app. Also remember to add the service account of the Nprinting server to the section access.

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

sam_1919 — Fri, 02 Mar 2018 03:58:54 GMT

Hi Jose,

Thank you for responding.

1. So is there any NPrinting API which can help me achieve this?

2. Is there any other way of doing it rather than applying section access?

I have their Mail IDs, User ID can be a filter right? So when the Qlik Sense application is loaded with the data, Nprinting will send the data to their respective Mail IDs, this might be the flow i guess(Not Sure).

Let me know if anything i have missed or needed.

Thanks

Saiprasad Ashok More

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

escayolaj — Fri, 02 Mar 2018 10:49:31 GMT

1. https://help.qlik.com/en-US/nprinting/September2017/Content/Extending/NPrinting-APIs-Reference-Redirect.htm

This is the API reference for Nprinting. It is still an experimental version according to Qlik but it looks like it has the method POST for Taks executions that can be useful for your use case.

2. You don't need to apply a filter on User ID in Nprinting. If you apply section access in the source app, Nprinting will automatically distribute the reports to the Nprinting users as set up in the section access. I believe this is the best option given your requirements.

If you don't want to apply section access, you will have to create a cycle on UserID, so each report contains the data for each user ID. However, the ALL reports will be sent to ALL users. If you need to send to each user only its corresponding report, I don't think this is possible with this approach.

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

Ruggero_Piccoli — Fri, 02 Mar 2018 10:49:42 GMT

Check this community post Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

sam_1919 — Sat, 03 Mar 2018 15:32:10 GMT

Hi Jose and rpc‌‌, Thank you so much for the help, appreciate it.

1. I have been using a Post Method in Qlik sense and it is throwing error saying 404 Not Found. Let me know how to tackle the situation.

I have used Url: https://ServerName:4993/#/api/v1/login/ntlm‌ , Windows NTLM and Credentials. Skipped certificate validation. Query Header: Origin and The Qlik Sense Login Url.

let me know what's the next step you suggest.

2. Want to do a Recipient Import. tried Import Task with the excel consisting Filters, Users and Groups worksheet in a single Excel.

Kept it in the server folder.

Getting the error:

Importing filters and recipients for file with path C:\ProgramData\NPrinting\Imports\NP_Web_Imports.xlsx

Error parsing import data: Could not find file 'C:\ProgramData\NPrinting\Imports\NP_Web_Imports.xlsx'.

Please check file path and file structure: all 3 required worksheets must be present in file.

Apologies for bringing all the issues in the same thread, since i have to address these issues ASAP.

djk‌, Sir It will be helpful if you look into this.

Hoping to get a solution.

You guys are awesome.

Thanks and Regards

Saiprasad Ashok More

djk‌ rpc‌ jose.pullaguari‌

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

Ruggero_Piccoli — Mon, 05 Mar 2018 10:02:50 GMT

Hi,

The error "Please check file path and file structure: all 3 required worksheets must be present in file." means that you changed the structure of the Excel file you are trying to import.

In Qlik NPrinting 17 you can import users and filters from an Excel file but it must have the structure of the file that you can find in the page https://help.qlik.com/en-US/nprinting/February2018/Content/DeployingQVNprinting/Import-Users-Filters.htm. Don't chenge nothing. The file must have all the worksheets with the names in the example, all the columns in the order and with names of the example etc.

You just need to fill the sample file in the help site with you data and it will work.

Best Regards,

Ruggero

---------------------------------------------

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

mirasifali — Fri, 05 Jun 2020 17:25:41 GMT

Hi Jose,

I am getting exactly the same error while using POST. have you got this resolved ?

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

Lech_Miszkiewicz — Sat, 06 Jun 2020 01:17:35 GMT

Hi @mirasifali

please open new conversation for your issue as this one seems too old and version changes in last few years may cause some problems. Describe all steps. You may also need to provide detailed screenshots of each step you do to help investigate...

Also have a detailed read here:

https://nprintingadventures.com/2019/04/08/nprinting-api-qlik-rest-subroutines/

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

rohitk1609 — Mon, 10 Jan 2022 16:44:35 GMT

Hi Ruggero,

is this solution valid for latest release?

Thanks,

Rohit

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

Digvijay_Singh — Mon, 10 Jan 2022 17:11:18 GMT

FYI, We use many of the pieces from this post in May 2021 release. We have around 20 nprinting tasks chained together and they trigger in a sequence after one main task finishes reload. Occasionally I get connection error but I am living with it as of now because it takes more than 3 days to finish all of my 20 tasks.

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

Ruggero_Piccoli — Tue, 11 Jan 2022 10:55:44 GMT

Hi @rohitk1609 ,

Do you mean a native feature to trigger a publish task after the end of a reload task without using Qlik NPrinting public APIs? The answer is no. If you cannot schedule the publish task by estimating the time needed by the reload to be finished, you have to use APIs. After starting the reload you can use https://help.qlik.com/en-US/nprinting/May2021/APIs/NP+API/index.html?page=55 to periodically retrieve its status https://help.qlik.com/en-US/nprinting/May2021/APIs/NP+API/index.html?page=126 and start the next task with https://help.qlik.com/en-US/nprinting/May2021/APIs/NP+API/index.html?page=57.

Best Regards,

Ruggero

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

rohitk1609 — Tue, 11 Jan 2022 14:06:22 GMT

I want to trigger Nprinting task after execution of Qlik Sense app by POST method. Is it possible in latest release?

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

Frank_S — Tue, 11 Jan 2022 20:12:52 GMT

Hi Rohit

First, if using Qlik Sense Ideally you want to be on at least Qlik Sense Sept. 2020 Patch 2 or later versions to mitigate Qlik Sense rest connector issues.

https://community.qlik.com/t5/Knowledge-Base/Qlik-Sense-June-2020-connecting-to-NPrinting-getting-quot-HTTP/ta-p/1759014

Then you can follow Jonny Poole's article (keeping in mind to update the cookie code in the load script as mentioned in the article above and is also conveniently link in Jonny NPrinting document as well)

https://community.qlik.com/t5/Qlik-Sense-Documents/Distribute-NPrinting-reports-after-reloading-a-Qlik-App/ta-p/1479632

Note: (May 2021 SR 3 is the latest version of NPrinting and we suggest upgrading to that version as well since this version fixes a problem with the NP designer you may circumvent via this upgrade. https://community.qlik.com/t5/Knowledge/Qlik-NPrinting-can-t-find-supported-reporting-template-editor/ta-p/1716228)

Kind regards...

Re: Triggering Qlik NPrinting Publish task Automatically after successful Qlik Sense Data Load

Lech_Miszkiewicz — Tue, 11 Jan 2022 22:18:14 GMT

Hi Rohit,

It was possible since 2018 and the same method still works until today and as Ruggero pointed above it is described step by step in the link https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-use-Qlik-NPrinting-APIs-inside-a-Qlik-Sense-load-script/m-p/54445

I posted about it on my blog here - I provided list of reusable subroutines:

https://nprintingadventures.com/2019/04/08/nprinting-api-qlik-rest-subroutines/

That method uses POST method through Qlik Sense load script wit REST connector.

As an alternative you can create your own piece of software or code and use "External Task" property to trigger it:

https://help.qlik.com/en-US/sense-admin/November2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Administer_QSEoW/Managing_QSEoW/create-edit-external-program-tasks.htm

Or if you have had something else in mind please elaborate and provide more details.

cheers

Lech