topic Re: Printing Unicode characters to PDF not working in Qlik NPrinting

Printing Unicode characters to PDF not working

javiersassen — Thu, 26 Aug 2021 11:57:49 GMT

I'm facing an issue when using Unicode characters in my reports. I use indicators (red, orange/yellow, green) in my table. When printing the report to Word, everything works out fine. I can save the Word file to PDF and still, the unicode characters (for instance https://emojipedia.org/large-green-circle/) look fine. The issue arises when generating the report as a PDF file. The characters appear as a rectangle with a question mark in it. The only indicator that does show as a cirle is the red one (this character belongs to Unicode since Unicode 6.0 while orange, yellow and green only have been added in Unicode 12.0). Is anyone familiar with this issue and is there a workaround to fix this? I've tried updating the driver of the Qlik print to pdf printer or changing it to another driver but this isn't allowed.

Any help is appreciated, thanks in advance;)
Javier

Re: Printing Unicode characters to PDF not working

Ruggero_Piccoli — Thu, 26 Aug 2021 12:53:00 GMT

Hi,

The Qlik NPrinting PDF printer is not used when creating PDFs from Microsoft Office templates; they are generated by a library so it could be a problem of that library. I suggest you to try to upgrade Qlik NPrinting to latest version (now May 2021 SR1) and test with it. If you are using a custom font be also sure that you installed it in all the computers where you are running Qlik NPrinting Engine services.

If it still doesn't work please open a support ticket with everything we need to investigate (the Qlik Sense app and the template, etc).

Best Regards,

Ruggero

Re: Printing Unicode characters to PDF not working

javiersassen — Thu, 02 Sep 2021 07:23:59 GMT

Thanks for your response Ruggero but it still isn't working. Segoe UI Emoji is not a custom font, it's included within windows. I've already opened a support ticket to address this issue;)

regards,
Javier

Re: Printing Unicode characters to PDF not working

mikaelsc — Thu, 02 Sep 2021 07:57:30 GMT

install the Segoe font on your nprinting server (copy it from your computer or so)... it will work like a charm after that

(not sure if i had to do it on qlik server as well...)

Re: Printing Unicode characters to PDF not working

javiersassen — Thu, 02 Sep 2021 08:00:47 GMT

This doesn't seem to work. As Ruggero stated before, PDF reports are generated by a library and I don't think this library uses the fonts installed on the server. Printing the report as a word file works perfect, it's the printing to pdf that doesn't work. Currently having v1.31 of the Segoe UI Emoji font installed on both the Qlik Sense and Qlik NPrinting VM.

Re: Printing Unicode characters to PDF not working

mikaelsc — Thu, 02 Sep 2021 08:18:47 GMT

with the pixel perfect stuff?

Re: Printing Unicode characters to PDF not working

javiersassen — Thu, 02 Sep 2021 08:24:16 GMT

No I'm using a Word template and printing it directly to PDF

Re: Printing Unicode characters to PDF not working

Ruggero_Piccoli — Thu, 02 Sep 2021 09:34:05 GMT

Hi,

The library uses the font installed on the Engines computer not Server (you can have one Engine on the same computer of the server but it is not mandatory or you can have a multi-engines installation).

In any case thanks for the support ticket, it lets us to investigate in details and understand what is happening.

Best Regards,

Ruggero

Re: Printing Unicode characters to PDF not working

javiersassen — Thu, 02 Sep 2021 09:36:58 GMT

Thanks again;) We are using a single server setup so Engine and Server are on the same VM. Hope you can figure this one out soon!

Re: Printing Unicode characters to PDF not working

mikaelsc — Wed, 22 Sep 2021 10:51:06 GMT

in addition, extra fonts (for example a font for barcodes) are not printed as such when creating a pdf report:

but the same report to excel is not an issue:

Re: Printing Unicode characters to PDF not working

Ruggero_Piccoli — Wed, 22 Sep 2021 13:07:42 GMT

Hi,

I did some tests on my installation and I confirm that you can create correct barcodes by using PixelPerfect templates exported as PDF and Excel templates exported in .xlsx. Instead Excel templates exported in PDF are not working as expected. I suggest you to open a support ticket with a link to this conversation so it will be sent directly to the developers.

Best Regards,

Ruggero