topic Re: NPrinting Dynamic Naming & Output Folder/Destination Bug in Qlik NPrinting

NPrinting Dynamic Naming & Output Folder/Destination Bug

yip_walter — Tue, 18 May 2021 06:46:12 GMT

It is found that for the NPrinting Feb 2021, there is a bug that if the dynamic naming are using the same QlikView variable as the Destination Folder, the folder will not be created.

Environment

QlikView Apr 2020 SR2

NPrinting Feb 2021

Step to reproduce:

1. Set the destination folder like this on NPrinting

d:\%%timestamp_YYYYMM%%\

2. Set the report dynamic naming like this on NPrinting

custom: reportname_

Qlik Variable: %%timestamp_YYYYMM%%

Expected result

d:\202104\reportname_202104.xlsx

Currently result

d:\reportname_202104.xlsx

Re: NPrinting Dynamic Naming & Output Folder/Destination Bug

Ruggero_Piccoli — Tue, 18 May 2021 07:17:22 GMT

Hi,

Thanks for sharing, we are aware of the issue. The fix is not included in next version May 2021 and, at the moment, I don't know when it will be released.

Please try to create two different variables with the same content and use one for the folder and one for the file name.

Best Regards,

Ruggero

Re: NPrinting Dynamic Naming & Output Folder/Destination Bug

Ruggero_Piccoli — Thu, 11 Nov 2021 15:26:48 GMT

Hi,

This issue is solved by Qlik NPrinting May 2021 SR1. From the Release Notes:

In some cases, Qlik variables were not resolved on folder destinations
Qlik variables would not resolve when creating folders as destinations, if the same variables were also used in
the dynamic naming of the report in the same folder.

Best Regards,

Ruggero

Re: NPrinting Dynamic Naming & Output Folder/Destination Bug

rajesh9147 — Thu, 27 Jul 2023 20:16:01 GMT

Hi Ruggero,

I have a similar scenario. I am creating reports using cycling fields like County and City. So I would like to copy reports to County/City Folder.

For Example Santa Clara /San Jose / reportname.pdf

Currently, I am using Qlik Variable read the static path. how can I use the same variable to get a dynamic path for each report?

Thanks,

Rajesh

Re: NPrinting Dynamic Naming & Output Folder/Destination Bug

Lech_Miszkiewicz — Thu, 27 Jul 2023 21:58:24 GMT

Hi @rajesh9147

This is very different scenario as you are using cycle functionality. With cycle this will not be possible as cycle is creating single zip file as an output therefore destination of that file can only be one (despite the fact that in zip file you actually have reports for combinations of your dimensions).

The only method/workaround for this would could be use of dummy users and user filter (each dummy user would represent value combinations from your cycle)

cheers

Re: NPrinting Dynamic Naming & Output Folder/Destination Bug

rajesh9147 — Thu, 27 Jul 2023 22:35:26 GMT

Thank you for your response. I have like each county has 50 cities. Do I need to create 50 dummy users?

Re: NPrinting Dynamic Naming & Output Folder/Destination Bug

Lech_Miszkiewicz — Fri, 28 Jul 2023 06:15:34 GMT

As mentioned before - this is not a feature - but workaround. That workaround requires dummy user for each unique folder you want to create.

Obviously such process (of creation of those users can be automated and can be based on recipient import file template and user,filters and groups import process: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm

Re: NPrinting Dynamic Naming & Output Folder/Destination Bug

Ruggero_Piccoli — Fri, 28 Jul 2023 06:28:54 GMT

Hi,

Please create a new conversation for a new question and avoid to comment posts that are years old. Thanks.

The output of a cycle is not ziipped only in the case you select a folder as destination https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/DistributionSchedulesAutomation/Report-output-formats.htm#anchor-4.

As alternative, you can evaluate to add the country and city name in the report file name and develop a custom software or script that read the file names and distribute them in subfolders.

If you select the way of creating dummy users remember that you can import them from an Excel file including filters https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm#anchor-2. It depends on your scenario but maybe it is faster to import users from a file before every publish task execution. The Excel file with users can be created by Qlik NPrinting from the source app or document.

Best Regards,

Ruggero