Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Is that possible?
Any help will be much appreciated
kind regards
Lech
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.
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
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.
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
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
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
Hi,
Is the situation the same in NP17.3.1.
Also is there a way to override the HTML files created in the folder.
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
Thanks for the reply. Will take up with Qlik support.