topic Re: NPrinting - CSV export limitiation? in Qlik NPrinting

NPrinting - CSV export limitiation?

hermanli — Wed, 06 May 2015 02:36:48 GMT

Hi All,

I would like to know if there is any limitation of the exporting rows in CSV format when using NPrinting?

I have a table with 73007 rows but after I export it to a CSV using Nprinting job, the output only gives me 72929 rows.

If I export it by right-click on the table, it has no problem to give me a full 73007 rows file.

Any idea? Or this is a bug for Nprinting?

I am using NPrinting v16.0.0.0

Thanks

Re: NPrinting - CSV export limitiation?

thomasjenn — Thu, 21 May 2015 13:56:08 GMT

Hello,

If your template file is a .xls file, I recommand you to try a .xlsx file.

Confirm me if it works.

Best regards,

Re: NPrinting - CSV export limitiation?

ngulliver — Tue, 09 Jun 2015 15:58:39 GMT

Hi, Herman.

Version 16 is a fairly new release. Try Thomas' suggestion. If that doesn't work, I would recommend contacting Qlik to see if there are any patches for this version.

regards,

Neil

Re: NPrinting - CSV export limitiation?

hermanli — Wed, 10 Jun 2015 01:58:24 GMT

Hi Thomas,

Thanks for your suggestion. But I would like to export the file in CSV format and just directly output from a particular table object.

Besides, I don't see any output format is xlsx.. Do you mean to create an Excel Reports?

I am currently using QlikView Entity Reports.

Thanks

Re: NPrinting - CSV export limitiation?

hermanli — Wed, 10 Jun 2015 02:00:47 GMT

Hi Neil,

I used a work around to solve this issue already. But I am sure that this should be a bug as there should be no line limitation for CSV format file.

Thanks

Re: NPrinting - CSV export limitiation?

Natalija — Tue, 12 Jan 2016 16:31:37 GMT

Hi Herman,

How did you solve your issue? I have exactly the same issue with my excel report in Nprinting, it cuts on row 65537.

P.S. Using .xlsx extention for Excel template.

Thanks,

Natalija

Re: NPrinting - CSV export limitiation?

hermanli — Tue, 19 Jan 2016 09:21:10 GMT

Hi Natalija,

The method is write an Macro to export CSV and add this action to the "OnPostReload" Trigger. Then distribute a copy to the NPrinting server by schedule.

In NPrinting, schedule another job to have a dummy reload. So, after the reload is done, Macro triggered and CSV will be exported to your specified location.