Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
hermanli
Contributor II
Contributor II

NPrinting - CSV export limitiation?

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

7 Replies
thomasjenn
Partner - Contributor III
Partner - Contributor III

Hello,

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

Confirm me if it works.

Best regards,

ngulliver
Partner - Specialist III
Partner - Specialist III

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

hermanli
Contributor II
Contributor II
Author

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

hermanli
Contributor II
Contributor II
Author

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

Natalija
Partner - Creator
Partner - Creator

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

hermanli
Contributor II
Contributor II
Author

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.

Hope this help.

Natalija
Partner - Creator
Partner - Creator

Thanks for reply, Herman!

Regards