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: 
lmonincx
Creator II
Creator II

How to import 1 recipient with 3 filters for 3 different connections

Hi,

I am trying to use the import wizard to upload one recipient ,

in my report i am using 3 different qlikview documents with in each Customername,as a filter field

I want in my import wizard to add to this one recipient filter Customername=X for connection 1 and filter Customername=X for connection 2 and filter Customername= X for connection 3.

It works when i do it manualy but i rather have it in an automated proces.

I can't imagine this is not facilitated,  I just need to know how to do this.

Not using a connection results ( although filterfieldname and content are all over the same) that the filter is only applied on the first connection.

Many thanks!

Linda Monincx

1 Solution

Accepted Solutions
Not applicable

Linda,

There's a tutorial which outlines the syntax you need to use here:

Advanced Filters Syntax on Recipients Import

The syntax is here:

[connectionName].[field] = {value1<isnumeric,evaluate>,value2<isnumeric,evaluate>,...}<drop,unlock,lock,verify,excluded>


You could also use a linked field to build the filter:


How to Create Linked Field Based Filters During Recipients Import

View solution in original post

3 Replies
Not applicable

not sure I understand

correct me if I am wrong - you hae 1 customer that you send 3 reports to but based on the connection the filter for the customer is different

How are you setting up the customer and filter manually

Is there a reson you need to have the recipient load done automatically once the 1 customer is set up or does this need to be done for multiple customers in the long term

Not applicable

Linda,

There's a tutorial which outlines the syntax you need to use here:

Advanced Filters Syntax on Recipients Import

The syntax is here:

[connectionName].[field] = {value1<isnumeric,evaluate>,value2<isnumeric,evaluate>,...}<drop,unlock,lock,verify,excluded>


You could also use a linked field to build the filter:


How to Create Linked Field Based Filters During Recipients Import

Not applicable

knowing what you did manually will determine how to import the recipient and which specific syntax to use (per Aran's response)