Hi Guys,
Still struggling with a version of this problem (NPrinting 17.6): one dashboard, one NPrinting App, one connection. Want to distribute 3 emails to same individual over the span of a day that will use Import tasks to create/update/remove users, groups, and filters, then distribute reports based on those filters. My filters are idiosyncratically named by user; examples:
Filter 1: Name = "PM Distro Filter - johnsmith@somedomain.com"; Values = [field1]={"value1","value2"}
Filter 2: Name = "CM Distro Filter - johnsmith@somedomain.com"; Values = [field2]={"value3","value4"}
Filter 3: Name = "Hot Item Filter = johnsmith@somedomain.com"; Values = [field3]={"value5"}
I build these filters dynamically via Qlikview Charts, save them to a network drive, then use Import Task for the create, update, delete. But what ends up happening is that a single NPrinting user ends up with three filters, and all three filters are applied for each task run, and since field1, field2, and field3 all exist I end up with the logical AND mentioned by Daniel Jenkins, so bad report.
This is my workaround, please tell me if there's a better way:
PM Distro at 10 AM:
-Run Publish Task "Delete My Filters" which saves an empty import file X.xlsx to the network.
-Run the Import Task X to ingest this empty file to delete all filters previously created by Import Task X.
-Run a Publish Task from the dashboard (to same file X.xlsx to the network), creating a single filter, idiosyncratically named by user: "Dashboard johnsmith@somedomain.com"; Values = whatever i want.
-Run the Import Task X again, creating the filter.
-Run the Distro Publish Task that sends the emails.
CM Distro at 12 PM:
-[Repeat steps above, wiping and recreating the filter as needed]
Hot Item Distro at 2 PM:
-[same]
I tried to skip the Delete step, but then the values get appended to the filter--which was unexpected. I thought it should just update.
andy
