Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Highlighted
cbn_timsmith
New Contributor

Duplicate Emails for NPrinting Users

Seems there is a restriction in Nprinting where no two users can have the same email address. The restriction goes as far down as being a constraint on the postgres database level. Does anyone know why this is the case? We have a need to have several different users with different settings/filters etc. but with the same email address. Anyone know a way around it?

I could remove the database level constraint against duplicate emails and manually edit users in the database to reference the same email id but its possible there is another reason for the restraint. and I'm reluctant to bypass the front end to get around it, for obvious reasons.

5 Replies
Partner
Partner

Re: Duplicate Emails for NPrinting Users

May I ask why you think you need different settings / filters?

I can understand your concern if you would like to make use of the user fields (like office, nickname etc).

I would highly disuade / warn to change any of the constraints on the database.

Partner
Partner

Re: Duplicate Emails for NPrinting Users

I actually tried creating a user with +test in the email address and it worked but a test mail didn't arrived so it looks like this is not a way forward

cbn_timsmith
New Contributor

Re: Duplicate Emails for NPrinting Users

Yeah I'll avoid making any changes directly to the database, I think I'm in for a bad time if I went that route.


We have branches of business looked after by 'Regional Managers'. We wants reports filtered by each of these branches to be sent out to each of our Regional Managers.
ie. in table form (RM = Regional Manager)

Branch          RM          $$$

A                    Joe          $20k

B                    Meg         $40k

C                    Joe          $30k

D                    Bob          $15k

So Joe would receive two separate reports, one for A and one for C.

I wanted to go about this by having a separate user for each Branch, called "Branch A Recipient", "Branch B Recipient" etc.with the appropriate Branch filter attached to each Branch User, but the email for both A and C Branch Users being joe@whatever.com. This way, if the RM for a branch changed, eg Branch A is now maintained by Meg, we need only update the email address for Branch A Recipient to be meg@whatever.com.

Benefit of this is I can also append the User Name to the subject of the published task email so the RMs can tell at a glance which email had which Branch report in them, which I cant do if I use filter cycles...

Partner
Partner

Re: Duplicate Emails for NPrinting Users

I solved a similiar case with an import task that updates the managers for the enitity. I then have set-up a level in my excel report so each Entity is placed on its own sheet - so a manager for two entities will get a excel report with two sheets, one for each entity.

I would rather have used the entity as a cycle report instead but I (and the managers) don't like sending the reports inside a zip file.

Going forward i will most likely change from import task to API calls instead - it gives more control and I can only update the important stuff like the filters.

Employee
Employee

Re: Duplicate Emails for NPrinting Users

Hi,

First, for you and all readers of this community, never touch the Qlik NPrinting Repository. There is the high risk to destroy your Qlik NPrinting installation.

An idea to reach your goal could be to add a filter for Branches A and C to the Joe users and set a cycle by branch on the publishing task. Joe will receive an email with two files, one for each branch or will find two reports in the NewsStand. Refer to https://help.qlik.com/en-US/nprinting/April2018/Content/ReportsDevelopment/Cycling-your-reports.htm

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.



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.