Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Join us for live office hours! Q&A with Qlik on Dec 14 at 10am EST: Refining Reports and Visualizations
cancel
Showing results for 
Search instead for 
Did you mean: 
Lech_Miszkiewicz

NPrinting 17.1 - export HTML to destination (folder) issue

Hello everyone.

I am facing silly issue with NPrinting 17.1 when trying to export HTML report to specific folder destination. It sort of works. Report is distributed to destination (ZIPPED FOLDER, folder name is is the report name, but HTML file inside has scrambled name and is referencing to other files sitting in "Documents" location.

What i want to achieve is:

  • export to particular folder HTML report which will not be zipped, and html file will have always the same name
  • also if possible i would like to have all related files (images etc) in subfolder there

Is that possible?

Any help will be much appreciated

kind regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
2 Solutions

Accepted Solutions
Daniel_Jenkins
Support
Support

Hi Lech,

Yes, NPrinting 17.x generates zip files that contain the HTML file. In my testing so far, this is a single HTML file that has all images etc. embedded

One workaround could be to use a tool like 7-zip. You can create a batch file and schedule it to periodically check for zipped files in your NPrinting destination folder and unzip them into a temporary holding folder from where the MOVE command can be used to move & rename the extracted HTML file to your final destination folder.

Let's say you want the html file to always have the name Result.html. Here is my sample batch file which is self explanatory:

 

@ECHO OFF

SET "srcdir=C:\Temp\FromDir" REM Source folder (NPrinting destination folder)

SET "tgtdir=C:\Temp\ToDir" REM Target folder (Final destination folder)

SET "tmpdir=C:\Temp\extracted-tmp" REM Temporary holding folder

REM empties the temporary holding folder

DEL /q "%tmpdir%\*"

REM although the temporary holding folder should have only one .zip file

REM I still use a loop as I don't know the name of the .zip file

REM You could remove the loop and hard code the name in place of "%%Z"

REM We will never know the name of the extracted HTML file hence the second

REM FOR loop

FOR %%Z IN ("%srcdir%\*.zip") DO (

  "C:\Program Files\7-Zip\7z.exe" e "%%Z" -o"%tmpdir%

    FOR %%I IN ("%tmpdir%\*") DO MOVE "%%I" "%tgtdir%\Result.html"

  )

HTH - Daniel.

View solution in original post

Lech_Miszkiewicz
Author

Hi Jan,

this is a bug in documentation - reported and getting fixed.

The entity report is not supported with Qlik Sense - that is official statement.

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

7 Replies
Daniel_Jenkins
Support
Support

Hi Lech,

Yes, NPrinting 17.x generates zip files that contain the HTML file. In my testing so far, this is a single HTML file that has all images etc. embedded

One workaround could be to use a tool like 7-zip. You can create a batch file and schedule it to periodically check for zipped files in your NPrinting destination folder and unzip them into a temporary holding folder from where the MOVE command can be used to move & rename the extracted HTML file to your final destination folder.

Let's say you want the html file to always have the name Result.html. Here is my sample batch file which is self explanatory:

 

@ECHO OFF

SET "srcdir=C:\Temp\FromDir" REM Source folder (NPrinting destination folder)

SET "tgtdir=C:\Temp\ToDir" REM Target folder (Final destination folder)

SET "tmpdir=C:\Temp\extracted-tmp" REM Temporary holding folder

REM empties the temporary holding folder

DEL /q "%tmpdir%\*"

REM although the temporary holding folder should have only one .zip file

REM I still use a loop as I don't know the name of the .zip file

REM You could remove the loop and hard code the name in place of "%%Z"

REM We will never know the name of the extracted HTML file hence the second

REM FOR loop

FOR %%Z IN ("%srcdir%\*.zip") DO (

  "C:\Program Files\7-Zip\7z.exe" e "%%Z" -o"%tmpdir%

    FOR %%I IN ("%tmpdir%\*") DO MOVE "%%I" "%tgtdir%\Result.html"

  )

HTH - Daniel.

Lech_Miszkiewicz
Author

Hi Daniel, Thank you for this workaround.

This can solve the problem, however it is not possible to create what i wanted to straight from NPrinting.

There is also another thing i noticed. In NPrinting Help:

Creating entity reports ‒ Qlik NPrinting

it says that Qlik Entity report can be created from QlikView & Qlik Sense documents. I wanted to check with you whether this is true as i was not able to create Entity report from Qlik Sense. I am using ver 17.1.2.0. When i try to create such a report qlik sense connection is not available.

could you please comment on that?

thanks

Lech

2016-09-21_9-36-04.jpg

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
jan_lance
Partner
Partner

Hi Lech,

did you find any solution to this?

We are facing the same problem.

We are not able to choose a connection when we select QlikEntity.

Regards

Jan

Lech_Miszkiewicz
Author

Hi Jan,

this is a bug in documentation - reported and getting fixed.

The entity report is not supported with Qlik Sense - that is official statement.

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
priyan_pa
Contributor III
Contributor III

Hi,

Is the situation the same in NP17.3.1.

Also is there a way to override the HTML files created in the folder.

Lech_Miszkiewicz
Author

I am not sure - dropped subject as client was not willing to build bunch of workarounds (which is fully understandable).

I do not undersant your second question - html file are having each time new GUID id and are zipped in folder. You can overwrite zip folders.

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
priyan_pa
Contributor III
Contributor III

Thanks for the reply. Will take up with Qlik support.