topic Re: NPrinting 17 Excel Import Template in Qlik NPrinting

NPrinting 17 Excel Import Template

pover — Wed, 16 Mar 2016 19:31:19 GMT

Hello everyone,

I've been testing the user, filter and group import in NPrinting 17 and I thought I'd share the Excel that I using to do that. I created it based on the information available in the help documentation (Importing users with filters and groups ‒ QlikView NPrinting)‌.

Hopefully it'll save you some time if you are doing the same.

BTW everything seems to import properly except of the Locale. Also, if you want to update the filters that are assigned to a user, you have to delete the user first.

Feel free to add your own comments and improvements to the file.

Best, Karl

Re: NPrinting 17 Excel Import Template

Wed, 20 Apr 2016 01:27:24 GMT

Hi Karl,

Thanks for the template. I've been testing NP 17 using this template and here are my findings:

1. filters are not associated to user automatically, I had to manually assign the filter to the user

2. Every time the import task is run, the manually assigned filters are removed. Hence, had to reassign all over again.

3. When I update the field name in the 'Values' column, the import task will create a new field for that filter, instead of replacing it.

Are these normal behaviour or am I doing something wrong.

Regards,

Bernard

Re: NPrinting 17 Excel Import Template

Anonymous — Thu, 05 May 2016 13:43:59 GMT

Hi KarlPover,

I observed almost same thing. Below is what is my requirement and the solution that I tried.

My requirement was to send a PDF report each for department to the department's manager to his/her email. To do so, I create three tables each for Filters, Users and Groups in my QV App, Created an excel report task to export an excel to a folder in a format that Nprinting understands to import users.

I then, create an Import task to import Filters, Users and Groups using the file created as an output of the above task. But as mentioned, the only thing that didn't work was Filters with Users. When the user is not already available, user is imported fine with proper filter. However, once the user is added, its not just that filters are not being modified or updated, but the existing filters on that user too are removed. Please suggest if any one has fix to this !

On Locale, Nprinting needs two character code for the Locale, e.g. Es, En, Fr, De etc.Using this way, it worked for me. Hope that helps !

Best,

Hardik

Re: NPrinting 17 Excel Import Template

pover — Wed, 18 May 2016 22:36:10 GMT

Hi Bernard,

I ended up pausing my test of NPrinting 17 until the new SR comes out. An reported error that prevented me from sending updated reports (NPrinting 17: scheduler doesn't pick up qvw update‌), so I'm sorry to say that I don't have the test environment to test what you are seeing. What you're seeing also sounds like some quirks or missing functionality in this initial release. I would definitely report it to Qlik support if you haven't done so already.

I like where NPrinting is going so I'm anxiously waiting for the next SR to get back to testing it.

Karl

Re: NPrinting 17 Excel Import Template

pover — Wed, 18 May 2016 22:38:38 GMT

Thanks for the info on the Locale. If you have any update on the users and filters, I would be glad to hear about it. Otherwise, when the new SR comes out and I get to testing it again, if I see a way to fix it, I'll share it.

Karl

Re: NPrinting 17 Excel Import Template

Frank_S — Wed, 18 May 2016 22:44:37 GMT

NP 17 SR 1 is now available

NPrinting 17.0 Service Release available now!

Re: NPrinting 17 Excel Import Template

Fri, 17 Jun 2016 12:24:12 GMT

Did you ever figure out why this was happening Hardik? I am running into the same issue, which is causing me to completely give up on NPrinting 17 currently...

Thanks!

Re: NPrinting 17 Excel Import Template

Mon, 27 Jun 2016 17:26:39 GMT

There is any template to import users to 17 SR1?

Re: NPrinting 17 Excel Import Template

Stephen_Jasionowski — Mon, 27 Jun 2016 18:01:47 GMT

There is an example in a zip file on the help site. See the bottom of this page: http://help.qlik.com/en-US/nprinting/17.0/Content/Recipients&Users/ImportUsersFiltersGroups/Import-Users-Filters.htm

Re: NPrinting 17 Excel Import Template

jacob_hoffmann — Tue, 08 Nov 2016 13:33:32 GMT

Qlik NPrinting 17.2 has been available for some time, but I do not see any improvements in this area of the product.

My conclusions are:

Filters will only associate with users if the user is new. This must be a bug in the import batch. I don't know a solution, but I do use a work-a-round with care:

Delete all users which need filters refreshed. You need to do it manually in the Admin menu.
Beware that this will empty the NewsStand repository for selected users!!!
(I have tried to create an "Import task" which only contained the system administrators, and where I selected "Remove recipients if not present in import file". This should clean your user repository - BUT IT DIDN'T)
Secondly create or use the "Import task" where you import Filters, Users, and Groups. This will build the repository the way you intended, and users and filters will again be associated.

I hope it helps or gives you an idea that you're not alone in the dark, while we wait for a proper solution from Qlik. I would expect more from a solution which is branded with words like "Enterprise"

@Qlik where do you want the bug reports? If I do this directly with you, no one else will learn.

Re: NPrinting 17 Excel Import Template

Thu, 10 Nov 2016 15:26:59 GMT

The import bug will be resolved in the next NPrinting release due out later this month

Re: NPrinting 17 Excel Import Template

silvacarlos — Fri, 23 Dec 2016 12:56:33 GMT

This bug was resolved?

Re: NPrinting 17 Excel Import Template

jacob_hoffmann — Fri, 23 Dec 2016 14:36:28 GMT

Yes the bug was resolved from version 17.2.1 and 17.2.2 didn't roll it back

Though I have I still have the problem, that Import Task doesn't "Remove recipients if not present in import file".

But do proceed with your upgrade. 17.2.1 is the first stable version of NP 17 - such a relief to work with!

Re: NPrinting 17 Excel Import Template

woutermak — Thu, 29 Dec 2016 09:42:16 GMT

I have the same issue. Is the problem in the newest version solved. So I can update without any problems my users and the filters will still be activated?

Re: NPrinting 17 Excel Import Template

jacob_hoffmann — Thu, 29 Dec 2016 18:51:32 GMT

Yes it is and yes you can!

I have testet intensively on two separate installations at different customers: One which has been upgraded from 17.1 to 17.2 to 17.2.1 to 17.2.2 and one brand new installation. Both works as intended with that little bug, that I cannot make it remove recipients, who are not on the list I import from.

Enjoy - I haven't restarted a NP service yet !!!!! (December 1st.)

Re: NPrinting 17 Excel Import Template

jacob_hoffmann — Wed, 04 Jan 2017 11:09:01 GMT

FYI: I just reported another limitation to Qlik Support:

The "Update filters if modified" doesn't work 100 %. I needed to move a filter from the column "Values" to "Numeric Values". It should be simple to move in Excel and it was. But Qlik NPrinting 17.2.2 didn't get the change.

PS: A little learning: If you have a filter which is a dual - remember to select "Numerical Values"

BR Jacob

Re: NPrinting 17 Excel Import Template

jampierre — Wed, 22 Mar 2017 09:36:20 GMT

Hi guys,

I'm using NP 17.3 and I'm still have the same problem as Bernard has mentioned.

Filters are not associated to user automatically, I had to manually assign the filter to the user

Do you have any idea about it?

Thanks in advance

Best regards

Re: NPrinting 17 Excel Import Template

ergustafsson — Fri, 31 Mar 2017 08:16:24 GMT

I have created a PowerShell script for this, which might simplicate things even further.

It imports the users automatically from the AD and outputs them to an Excel file, which then Nprinting can import:

Import Nprinting Users from Active Directory automatically

Re: NPrinting 17 Excel Import Template

jampierre — Fri, 31 Mar 2017 09:07:10 GMT

Thank you so much Erick.

I'll see your work.

I think nothing changed about filter association on NP17 by Import task.

Thanks again

Re: NPrinting 17 Excel Import Template

Tue, 16 May 2017 16:25:20 GMT

In the Enabled column, which value set? YES, TRUE ?? what's the difference