Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Lech_Miszkiewicz

NPrinting 17.2.1.0 import recipients filters issue

Hi

I am working with NPrinting 17.2.1.0 (the latest) and i am testing import task functionality. I am using XLS templates from help:

https://help.qlik.com/en-US/nprinting/17.2/Content/Recipients&Users/ImportUsersFiltersGroups/Import-...

As far as i noticed everything works OK apart from recipient filters not being updated after they are changed in XLS file.

Filters seem to behave the same way as Roles or Groups as they are added to existing recipients filters instead of being overwritten.

Is this behavior intentional?

regarding roles and groups help says:

Roles: list of roles for a user, separated by commas.

When importing users with groups or roles:

  • if groups or roles added in the row for a user do not exist, they will be automatically created.
  • existing associations with groups and roles will not be removed if not present in the update row. An import can only add associations with roles and groups for a user, but not remove them.

regarding filters such a statement is not written anywhere so i would expect that filters would be removed/replaced with the new one instead of adding associations for new filters.

Nprinting Masters - please share your experience

Thanks

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
16 Replies
ssaddepal
Contributor III
Contributor III

Just so that it is clear - i need to generate multiple reports(based on multiple filters) to a single person. Since i don't see any option to add multiple filters and generate reports for each of those filters in nprinting-my plan was to create multiple excel files carrying the filters for the same guy and on each iteration, run the import task and generate the report so that, each time nprinting picks up a new filter and delivers multiple report as per those filters to the same user. Let me know if you're not clear with my objective.

Lech_Miszkiewicz
Author

Ok

answering this:

"...Am updating the filter value(say filter1) in the blue circle to a new filter value(filter2). After which  I am running the import task."

My answer to that  is that this is not a Filter Value - as it is only association between filter and user.

Filter value is stored under Filter Sheet in Excel (see screenshot in red framed areas)


answersing this:

"I was expecting the filter1 to be overwritten with filter2 in the nprinting console but I see that filter2 is present in addition to filter1, as below. I don't want this as I am planning to generate multiple reports to a single user(by way of importing multiple filters by running import task multiple times)"


You are trying to change association of user ans filter which is not going to work. Nprinting will not remove existing association, but will only add new ones



Suggested solution:

  • You can associate to User X filter A1 and A2 (in Excel import Spreadsheet you just put 2 values in USer Sheet-Column Filter = A1,A2
  • Then you got to Filter Sheet in Excel and you have to create 2 lines for:
    • Filter A1 - using Connectiopn 1 with some filtering to apply to report using Connection 1
    • Filter A2 - using Connection 2 with some filtering to apply to report using Connection 2

summary:

the way you are doing it now will not work as per one of my comments that Filters during update will behave like Roles and Group

  • existing associations with groups and roles (and Filters)will not be removed if not present in the update row. An import can only add associations with roles and groups for a user, but not remove them.

cheers Lech


1.png

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Lech_Miszkiewicz
Author

You can achieve this by creating those reports on different nprinting connections and and creating dedicated recipient filters for each connection. This was described by me in my previous response.

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
ssaddepal
Contributor III
Contributor III

Just so that I understood-

In my case, since its the same qliksense app from which I am generating reports - do you intend to say that I'll be needed to create "n"  connections to implement "n" filters to a single user so that user can get "n" reports ?

Lech_Miszkiewicz
Author

If the same user need to have dedicated but different filter for each n report then yes - you need to create n connections to the same Qlik Sense document

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Daniel_Jenkins
Support
Support

Hi Lech & Sagar,

I cannot find this in the online help but just to be clear, there is a way to remove all values from a filter (effectively 'removing' it) by using an empty list in the import filter syntax. More details with examples here: How to create, modify and remove all values from a filter while running an Import Task

HTH - Daniel.

Lech_Miszkiewicz
Author

Hi Daniel,

Yes - you are right.

Difference is:

  • you are talking about removing all values from filter (which is possible)
  • what i was after and what Sagar tried to do was to "remove" association USER-Filter, which is not possible.

Thanks for highlighting the possibility of removing filters values as it will make some of the things i was after possible as well

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.