topic Re: How to create one subfolder per project in QV Nprinting with one report in it? in QlikView

How to create one subfolder per project in QV Nprinting with one report in it?

saxofonoacn — Fri, 21 Apr 2017 15:16:09 GMT

Hi,

I am trying to create one subfolder in our folder structure per ProjectID where each subfolder would have only applicable PowerPoint (i.e. for the same project). I did find one way which does what I want but it has a couple of manual steps which we can't have (https://www.youtube.com/watch?v=lcYjRCwuqSk) . The idea in the video is to allocate projectid as a filter to each recipient (projectid in this case as I'm not using emals but projects).

Sounds pretty straightforward... yet...

Any suggestions on how to achieve this?

NP version: 16.2.0.0 (SR2)

Thanks

Re: How to create one subfolder per project in QV Nprinting with one report in it?

Anonymous — Fri, 21 Apr 2017 16:15:10 GMT

I'm assuming you're using a Cycle in Nprinting to run for all projects from one report.

I would think you could create a Qlikview variable for Project ID and add it the custom folder path on the task.

Re: How to create one subfolder per project in QV Nprinting with one report in it?

saxofonoacn — Mon, 24 Apr 2017 08:35:17 GMT

Hi Wallo,

yes, that's where I started... I am bringing in ProjectIds as users/ recepients and then looping over the project name. This however only creates multiple reports in the same folder as opposed to one applicable report for the folder. If i remove the cycle, I end up with one folder and one report however, that report has all possible projects in it.

Any other suggestions?

Thanks

Re: How to create one subfolder per project in QV Nprinting with one report in it?

Anonymous — Mon, 24 Apr 2017 22:46:17 GMT

You are right. I guess the variable only works once.

To keep it all automated, you'll need to import recipient groups from your QVW.

Create a straight table in your QVW that looks something like the below.

The Folder column will be an expression =[ProjectID]

The Group column will be whatever you want to make it. It will be your recipient group name. Something like ='ProjectIDRecGroup'

The Filter column will be an expression of ='ProjectID={' & [ProjectID] & '}'

Folder	ProjectID	Group	Filter
ProjectID1	ProjectID1	ProjectIDRecGroup	ProjectID={ProjectID1}
ProjectID2	ProjectID2	ProjectIDRecGroup	ProjectID={ProjectID2}
ProjectID3	ProjectID3	ProjectIDRecGroup	ProjectID={ProjectID3}
ProjectID4	ProjectID4	ProjectIDRecGroup	ProjectID={ProjectID4}
ProjectID5	ProjectID5	ProjectIDRecGroup	ProjectID={ProjectID5}
ProjectID6	ProjectID6	ProjectIDRecGroup	ProjectID={ProjectID6}
ProjectID7	ProjectID7	ProjectIDRecGroup	ProjectID={ProjectID7}

Once you have that, in your NSQ, you'll want to setup an 'Import Recipient Task'.

Click 'Delete old recipients'.

Click 'Recipient Imports'.

Click 'New'

Select 'From Qlikview Entity' radio button next to 'Import Type'.

In the 'Object ID' box, click 3 dots on right. Select the straight table you made earlier. Click Ok.

Click 'From Qlikview Entity' Import button at the top right on the ribbon.

A mapping wizard will come up.

Map Col A to 'SubFolderName'

Col B to 'FullName'

Col C to Group1

Col D to Filter1

Click Next.

Click Execute.

Save and Close back out to main screen.

This has created a task for this import process.

**In your schedule you'll want to make sure you add this import group task before your report generation task.

Now in your Report task go to 'Recipients' and add the recipient GROUP. NOT the individual recipients.

You want to add the group so it will automatically update the recipient list. If you do not add the group it will be manual to maintain.

Then you can select 'Recipient Subfolder' on the General tab of your Report task.

Doing it this way allows you to avoid the manual steps they have in the video. No need to maintain an excel spreadsheet anywhere.

Re: How to create one subfolder per project in QV Nprinting with one report in it?

saxofonoacn — Wed, 26 Apr 2017 08:32:26 GMT

Thank you Wallo! Works like a charm! By the look of it I initially messed up the filters bit but your step-by-step guide helped a lot!

Many thanks!

Imi