topic Saving a document in a folder named as a field in Qlik NPrinting

Saving a document in a folder named as a field

Tue, 06 Oct 2015 14:50:47 GMT

Hi all,

I have to save a pdf document in a folder named like a field.

For example:

Table name: Table1

Field name: Field1

Record available:

Field1
Dog1
Cat2
Rat3

I would like to have a folder named:

C:\Dog1\Dog1.pdf

C:\Cat2\Cat2.pdf

C:\Rat3\Rat3.pdf

How do I do?

Thanks everyone.

Bye

Adriano

Re: Saving a document in a folder named as a field

Stephen_Jasionowski — Tue, 06 Oct 2015 15:07:22 GMT

You can create a recipient in NPrinting for each of the Field1 values. Then attach a filter to the recipient for that particular field value, so the PDF for Dog1 will only contain Dog1 data.

How to Create and Import Recipients with Filters and Distribution Groups – Customer Feedback for Vizubi

After you set up the recipients, as part of a report task, you can choose an output path with a recipient subfolder:

This will distribute the PDFs the way you want. Just make sure that all the Field1 recipients are included in the task as well. It may help to create a distribution group for these recipients so it will be easier to automate new recipients in the future.

Re: Saving a document in a folder named as a field

andrespa — Tue, 06 Oct 2015 15:42:48 GMT

Hi Stephen,

Can I do this with a Macro? I know it's not the best way to do it, but in my company we're not gonna have Nprinting at least for now. So, as far as I need to solve certain problems regarding something simliar to this post. Have you any ideas of how to write a macro to do that?

Best regards,

Andrés

Re: Saving a document in a folder named as a field

Tue, 06 Oct 2015 17:18:11 GMT

As stephen pointed out, there are many options under the output folder. The option stephen selected will add the recipeint sub folder value (which needs to be adde for each recipient) to the overall task folder defined in Options

as you can see from the options, you can define a specific folder for each recipient or you can also select from variables, fields, etc (see atached) for your output folder

Re: Saving a document in a folder named as a field

Stephen_Jasionowski — Thu, 08 Oct 2015 16:26:57 GMT

Outside of NPrinting, I wouldn't know how/if this is possible with a macro

Re: Saving a document in a folder named as a field

Mon, 12 Oct 2015 15:53:00 GMT

Thanks, the proposed solution was exactly what I needed

Bye

Adriano

Re: Saving a document in a folder named as a field

adriano_fornoni — Thu, 15 Oct 2015 13:37:46 GMT

How could I maintain the Field variable and the function to updating the Recipient list in the Report Task?

Bye Adriano

Re: Saving a document in a folder named as a field

Thu, 15 Oct 2015 14:44:08 GMT

I would recommend making each recipient part of a group and then assign the group to the task (instead of the individual recipients). You can then schedule an import task the would update your recipient lsit, which also updates the group - this will avoid having to update the individual recipients assigned to the task

Re: Saving a document in a folder named as a field

adriano_fornoni — Thu, 15 Oct 2015 15:58:49 GMT

Sorry but I can't, or rather I don't know how, update the Recipient Group from Imports Recipient

With a Macro? What options in the Task?

Thanks very much and bye

Adriano

Re: Saving a document in a folder named as a field

Thu, 15 Oct 2015 16:11:46 GMT

Adriano,

When you import recipients, they can be put into groups.

If you put a group into a Task as a recipient, this will automatically get updated as new recipients are imported.

Tutorial on groups:

How to Create Recipient Groups – Customer Feedback for Vizubi

Tutorial on recipient imports:

How to Create and Import Recipients with Filters and Distribution Groups – Customer Feedback for Vizubi

Best

Aran

Re: Saving a document in a folder named as a field

adriano_fornoni — Fri, 16 Oct 2015 13:45:33 GMT

The correct way is settings a field in the Recipient Import Files with the Recipient Group Name.

So the recordset seems like this:

FullName|Description|RecipientFolder|Group1

Filter Syntax, Parameters, and Options for Importing Recipients

Bye

Adriano