topic Re: Send filtered data to different users in Qlik NPrinting

Send filtered data to different users

Alisher_ — Wed, 17 Nov 2021 12:26:45 GMT

I have a report with a lot of data for different merchants,

I'd like to send a separate email with filtered data for every merchant separately

There are about 1000 different merchants in a report

Could someone help me how to do that via Nprinting

Many thanks in advance

Re: Send filtered data to different users

Lech_Miszkiewicz — Wed, 17 Nov 2021 12:38:58 GMT

Use recipient import from excel: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm
With that import bring in all your merchants as users and associate filters with them
add them all to one group
add group to task and run report

this topic was discussed so many times on community that i only give you high level info as details are already there-just use search or simply google.
cheers

Re: Send filtered data to different users

Frank_S — Wed, 17 Nov 2021 22:51:33 GMT

Further to Lech's point, you may wish to manually add user filters one by one as a test bed before implementing the User Import to import users.

creating user filters: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Recipients&Users/Create-users-filters-groups.htm#anchor-7
creating user groups: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Recipients&Users/Create-users-filters-groups.htm#anchor-6
configuring publish tasks: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/AdministeringQVNprinting/Tasks/Creating-tasks.htm

So I'd suggest

getting comfortable with applying user filters to a few merchants (NPrinting recipients: Recipients can be people, places and/or things)
adding users/recipients to NPrinting distribution groups (not required but helps you to manage report distribution)
Adding your groups to a publish task and complete your task configuration

For more information about NPrinting Report Design, Distribution and Administration, please have a look the following:

https://community.qlik.com/t5/Knowledge/Qlik-NPrinting-Training-and-Information-Resources-Step-by-Step/ta-p/1595197

Kind regards...

Re: Send filtered data to different users

Alisher_ — Mon, 22 Nov 2021 06:30:17 GMT

@Frank_S Thank you,

One more question - because merchants do not have a domain address how we can skip it

Is there a special dummy domain that I can create for all such merchants?

If I leave that filed empty I've got an error - @Unable to relay recipient in non-accepted domain

Many thanks in advance

Re: Send filtered data to different users

Ruggero_Piccoli — Mon, 22 Nov 2021 11:05:18 GMT

Hi,

Each user mush have a different main email address but the domain user is not mandatory. You can simply let the domain user field empty.

Best Regards,

Ruggero

Re: Send filtered data to different users

Alisher_ — Mon, 22 Nov 2021 11:14:08 GMT

Hi,

Yes user has a unique email and I left the domain user field empty

But when publishing a task I'm getting t an error

Failed to send email for user .... ERROR: 5.7.54 SMTP; Unable to relay recipient in non-accepted domain

Does anyone know where and how to fix this?

Many thanks in advance

Re: Send filtered data to different users

Ruggero_Piccoli — Mon, 22 Nov 2021 11:33:30 GMT

Hi,

This is an error of the SMTP server, not of Qlik NPrinting. The SMTP server is refusing to deliver emails that come from Qlik NPrinting because it is not trusting in it. It is an anti-spam setting that need to be modified in the SMTP server, for example by adding the Qlik NPrinting default sender email in the SMTP server white list.

I suggest you to contact the SMTP server administrator.

Best Regards,

Ruggero