topic QlikView app returning incorrect data to NPrinting in Qlik NPrinting

QlikView app returning incorrect data to NPrinting

waterscg — Tue, 03 Sep 2019 16:05:48 GMT

I'm encountering an odd issue with NPrinting June 2019 and QlikView 12.4. I have an NPrinting report that connects to a QlikView app to generate an Excel recipient file, to be imported into the NPrinting user database. (My report's Excel template uses the sheet/column layout specified in Recipients.xlsx -- extracted from Examples.zip, which I downloaded from the NPrinting help page. The QlikView app has a hidden tab containing three tables -- Filters, Users, and Groups -- which expose the data referenced in the Excel template. I'm not using nor exposing the Filters sheet's Advanced Search.) When I run the publish task to run the report to generate the recipients file, the data on the Filters sheet is in the wrong columns; i.e., rather than this:

The data looks like this:

Note that the data in the second through sixth columns is mixed up. (The data on the Users and Groups columns is correct.) Not surprisingly, the data on the Filters sheet being in the wrong columns is causing the corresponding import task to fail!

I worked around the issue by changing the report's template to output each of the second through sixth columns in the 'wrong' location; i.e.,

This results in a correct recipient file which can then be imported.

What steps have I taken to try to resolve this? I deleted and re-pasted the data columns in the Excel template. I deleted and re-imported the three table objects in the Excel template. I reloaded the connection's metadata. I deleted and re-created the report and template. I even deleted and re-created the connection and the app. I created a new report and template. No change. I'm not seeing this issue with any other NPrinting / QlikView apps.

What could be causing this issue?

Re: QlikView app returning incorrect data to NPrinting

Frank_S — Wed, 04 Sep 2019 19:21:56 GMT

Hi @waterscg

Check out the following link.

https://support.qlik.com/articles/000082531

If none of the information in therein assists, please start a new support case in the event that you may have uncovered a software defect since the inclusion of 'advanced search' in the NP recipient import file.

Re: QlikView app returning incorrect data to NPrinting

pwagner — Fri, 20 Sep 2019 11:32:18 GMT

Hello,

I have the same issue (NPrinting June 2019 + Qlikview 12.40).

Have you already found a soluation?

Best regards, Patrick

Re: QlikView app returning incorrect data to NPrinting

Ruggero_Piccoli — Fri, 20 Sep 2019 12:37:38 GMT

Hi,

Try to:

- install QlikView 12.20 or older

- use the table tag instead of column tags

- open a support ticket

Best Regards,

Ruggero

Re: QlikView app returning incorrect data to NPrinting

waterscg — Fri, 20 Sep 2019 12:54:56 GMT

I've not yet found a solution. For this particular app, I'm continuing to work around the issue by changing the report's template to output each of the offending columns to the 'wrong' location. I will open a support ticket.

Re: QlikView app returning incorrect data to NPrinting

waterscg — Fri, 20 Sep 2019 19:16:14 GMT

I've opened support case 01724612 for this issue.

Re: QlikView app returning incorrect data to NPrinting

Ruggero_Piccoli — Mon, 23 Sep 2019 07:15:47 GMT

Hi,

Please try to install QlikView 12.20 or older and let as know if it solves.

Best Regards,

Ruggero