NPrinting 17 - how to import filters with fields using different connections

[Anonymous]

Hi everybody,

We are using NPrinting 17.2.3, and we are trying to import users and filters, based on the example spreadsheet provided by Qlik.

I can only create filters with values based on one connection per filter. However we have apps using more than one connection, and we wish to keep it simple and have an unique user filter per app.

I am attaching an import spreadsheet that works with the filter named 'User1 filter' created with the field [Field 1] from the connection 'Connection1' filtered on the value 'Value 1'. How can I add to the same 'User1 filter' a filter on the field [Field 2] with the value 'Value 2' from the connection 'Connection2' ?

Thank you.

Bruno

[Lech_Miszkiewicz]

Hi Bruno,

Bad news is you have to create 2 filters with 2 different names. Then you have to list both filters...

This is because NPrinting has to specificly connect right filter to right connection without guessing which connection is used in report as you can have 2 connections in 1 report!

cheers

Lech

---------------------------------------------

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

[Anonymous]

Hi Lech,

From the admin interface, it is possible to create a filter that is applied on fields from different connections. I can specify which connection is used for each field. This is what I would like to do during the import.

And in the previous version of NPrinting, it was possible to import user filters from different connections using the syntax:

[Connection].[Field]={....}

I tried this in the value column, but it doesn't work.

The only workaround that seems to be working is to create multiple import tasks, against the same filters, with the update filter setting for the task selected. It is quite cumbersome and harder to maintain, therefore I am seeking a more efficient way I may have missed.

Cheers,

Bruno

[Lech_Miszkiewicz]

Hi Bruno - I see your point!

rpc‌ - Ruggerro - what do you think? any ideas how we could help Bruno. I think this is quite important topic to discus how it meant to work. For nice & neat NPrinting Apps the way he wants to maintain filters seems to work great! Looking forward to hear from you.

cheers

Lech

[Ruggero_Piccoli]

Hi All,

Right now (June 2017) importing user and filter feature in Qlik NPrinting 17 is limited compared with the same feature in the 16.* serie. So what you told is correct and developing this feature is in the to do list but not yet plan right now.

Cheers

Ruggero

[Lech_Miszkiewicz · Accepted solution]

Understand - Thank you!

Bruno - I guess you have 2 choices: Apply my solution or have multiple import tasks.

regards

Lech

[Anonymous]

Thanks Lech and Ruggero for your answers.

I will have multiple import tasks for the time being.

[SindyMeri]

Hi Lech and @Ruggero_Piccoli 

Has this feature been implemented yet? I am struggling to find information about it.

I am sitting with the same problem as Bruno had in 2017. I am working with NPrinting Feb2021

Kind regards

Sindy

[Ruggero_Piccoli]

Hi,

The 16 syntax [Connection].[Field]={....} is not yet supported in NP17+ (latest is February 2021). The connection name must be in the column "Connection" and you can specify only one for each row of the Excel file. 

You can create one filter for each row and add to the user as many filters as you want. 

Best Regards,

Ruggero

[Lauri]

Hi, has the status of this changed as of May 2022 or later? Thank you.