Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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.
1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
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

16 Replies
pablomind
Creator
Creator

Im having the same issue as you. Did you find any solution for this?

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

Hi Pablo,


I have spoken to Qlik Support regarding this issue. It is really "help" bug as it should be stated that filter will not be removed.

As they are going through documentation updates they will update filter import description which will behave similar to groups ( can be added/updated but not removed)

hope this helps!

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.
pablomind
Creator
Creator

Thank you for your answer, are you as well were having issue updating the recipients using the Excel import file? If I slightly modified an user name in the template, the NPringint dont detect it as a modification but as a new user and it gives me back the error that cant add two users with the same email. Any help with this?

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

I will be investigating this probably tomorrow.. I wil share mi findings

kind 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.
Daniel_Jenkins
Specialist III
Specialist III

Hi Lech,

Version 17.2.3 is now available on the Qlik download site. I suggest go through the release notes and test on that version.

HTH - Daniel.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

Hi,

I have not tested it yet on 17.2.3 and i do not want to do that on my production setup as this would require an upgrade (i am afraid of upgrading as it is known that it may break a repository and i am not familiar with backup restoration yet)

I will do testing on my priv environment and once i get my result i will share them with you.

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.
Anonymous
Not applicable

Hi lech_miszkiewicz,

I am on nprinting 17.3.1 and I am still seeing that this is the case. I updated the filter associated with the user and triggered the import task. All it did was to add the new filter to the existing filter. I was expecting it to overwrite as per the 'Help'.

How did you address this in your case ?

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

Hi,

can you provide a screenshot of your excel and what actually you are updating? (what you are changing and what do you expect to see)?

So here is the thing:

  • new added value in USER sheet list will be ADDED as a filter and a new user-filter associon will be created
  • now if you go to Excel-> Filter sheet and change only value for existing filter - this should update filters values in filter

Above is an expected result - do you get something else?

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.
Anonymous
Not applicable

Capture.JPG

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.

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)Capture.JPG