Send filtered data to different users

[Alisher_]

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

[Lech_Miszkiewicz · Accepted solution]

• Use recipient import from excel: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/Import-Users-Fi...
• 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

[Frank_S · Accepted solution]

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-filter...
• creating user groups: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Recipients&Users/Create-users-filter...
• configuring publish tasks: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/AdministeringQVNprinting/Tasks/Creat...

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-St...

Kind regards...

[Alisher_]

@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

[Ruggero_Piccoli]

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

[Alisher_]

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

[Ruggero_Piccoli]

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