4 Replies Latest reply: Apr 26, 2017 4:32 AM by Imrich Antal RSS

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

    Imrich Antal

      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?
          Wallo Atkinson

          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?
              Imrich Antal

              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?
                  Wallo Atkinson

                  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] & '}'

                   

                   

                  FolderProjectIDGroupFilter
                  ProjectID1ProjectID1ProjectIDRecGroupProjectID={ProjectID1}
                  ProjectID2ProjectID2ProjectIDRecGroupProjectID={ProjectID2}
                  ProjectID3ProjectID3ProjectIDRecGroupProjectID={ProjectID3}
                  ProjectID4ProjectID4ProjectIDRecGroupProjectID={ProjectID4}
                  ProjectID5ProjectID5ProjectIDRecGroupProjectID={ProjectID5}
                  ProjectID6ProjectID6ProjectIDRecGroupProjectID={ProjectID6}
                  ProjectID7ProjectID7ProjectIDRecGroupProjectID={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.