topic Re: Nprinting Excel report for specified users in Qlik NPrinting

Nprinting Excel report for specified users

a0693051 — Fri, 01 Jun 2018 13:05:37 GMT

Hi Everyone,

Please help me to send mail (with excel report) to specified user for Nprinting.

Please refer the attached sample.xlsx, I have the table with 14 records. I have below requirement:

Send the report to users in column "Email" for their corresponding records only. Example: Send the buyer 'Swiss Auto Company' details only to user: Joseph123@email.com

Note: Users might be vary every day and report having the following fields only: Buyer Name, Policy Number, Previous Date, Previous Buyer Rating, Current Date, Current Buyer Rating and Agent Name.

Thanks in Advance.

Regards

Jhanaarthanan

Re: Nprinting Excel report for specified users

glacoste — Fri, 01 Jun 2018 18:17:28 GMT

You can create a Import task with a trigger daily. In the import task link the xlsx with the users using the follow template:

https://help.qlik.com/en-US/nprinting/April2018/Content/DeployingQVNprinting/Import-Users-Filters.htm

Create a filter for the user Joseph123@email.com declaring the possibles values for the field Buyer Name and Policy Number. Add the filter to the user.

Create a Publish task and add the report. Nprinting use the use filter for each recipient.

Re: Nprinting Excel report for specified users

Ruggero_Piccoli — Mon, 04 Jun 2018 09:47:12 GMT

Hi,

For more details refer to the help site https://help.qlik.com/en-US/nprinting/April2018/Content/Introduction/Introduction.htm.

Creating Excel templates, filters, importing users etc are all well explained there.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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: Nprinting Excel report for specified users

a0693051 — Mon, 04 Jun 2018 13:34:57 GMT

Hi Gastavo,

Thanks for your information.

But my Nprinting version is 16.7.0.0, is it your solution will support this version?! the link (https://help.qlik.com/en-US/nprinting/April2018/Content/DeployingQVNprinting/Import-Users-Filters.htm) mentioned that it will support only Nprinting Version 17 and above.

Please clarify.

Thanks & Regards

Jhanaarthanan

Re: Nprinting Excel report for specified users

a0693051 — Mon, 04 Jun 2018 13:35:35 GMT

Thanks Ruggero!