KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Export to pdf gives a wrong character set? #406

Open Thom Jones opened this topic on on Aug 2, 2018 - 9 comments

Thom Jones commented on Aug 2, 2018

Hi! Brand new Koolreporter here, so I'm sure I am missing something. But, trying my first export to pdf, the file downloads but is illegible. This is what shows:

Even though copy/pasting that "text" actually pastes correctly to, say, Kate editor. Any ideas?
Thanks!

KoolReport commented on Aug 3, 2018

Could you please tell us more about your environment? os, php version? Also please tell us if our export example going along with koolreport library is working well?

Thom Jones commented on Aug 6, 2018

Hi - Server is running CentOS 7. PHP is version 7.2, but this won't be the eventual production version. Most likely that will stay at 5.6 for the time being. Client (if it matters) is Chrome running on openSuSE Leap 42.3 The export example runs totally fine, actually. Could this be related to the character set in the db? Shouldn't, I wouldn't think, because that is unicode_utf8

Thom Jones commented on Aug 6, 2018

Actually, I was wrong. Just looked at the collation and whoever set up this database initially set the collation for most of the tables as latin1_swedish_ci Still shouldn't matter, though, right?

KoolReport commented on Aug 7, 2018

So if the collation is set to utf-8 then the export is working, isnt it?

Thom Jones commented on Aug 7, 2018

Nope. Changed it out (at least for the tables I am accessing data from) and the db itself is utf8 unicode already. Any other thoughts?

Thom Jones commented on Aug 7, 2018

Actually, got it figured out, I think - installed the root-graf-postscript package (along with all the dependencies) and the font rendering seems to be resolved.

KoolReport commented on Aug 7, 2018

Oh that's nice that problem is resolved but could you please tell us what is the root-graf-postscript package. I have no ideas of this package.

Thom Jones commented on Aug 7, 2018

From the yum info:

Name        : root-graf-postscript
Arch        : x86_64
Version     : 6.14.00
Release     : 2.el7
Size        : 456 k
Repo        : installed
From repo   : epel
Summary     : Postscript/PDF renderer library for ROOT
URL         : https://root.cern/
License     : LGPLv2+
Description : This package contains a library for ROOT, which allows rendering
            : postscript and PDF output.

And the dependencies also installed are:

dwz.x86_64 0:0.11-3.el7                                               gcc-c++.x86_64 0:4.8.5-28.el7_5.1                                 
  gnu-free-fonts-common.noarch 0:20120503-8.el7                         gnu-free-mono-fonts.noarch 0:20120503-8.el7                       
  gnu-free-sans-fonts.noarch 0:20120503-8.el7                           gnu-free-serif-fonts.noarch 0:20120503-8.el7                      
  google-droid-sans-fonts.noarch 0:20120715-12.el7                      libAfterImage.x86_64 0:1.20-9.el7                                 
  libXfont.x86_64 0:1.5.2-1.el7                                         libfontenc.x86_64 0:1.1.3-3.el7                                   
  libstdc++-devel.x86_64 0:4.8.5-28.el7_5.1                             lz4.x86_64 0:1.7.5-2.el7                                          
  perl-srpm-macros.noarch 0:1-8.el7                                     redhat-rpm-config.noarch 0:9.1.0-80.el7.centos                    
  root-cling.x86_64 0:6.14.00-2.el7                                     root-core.x86_64 0:6.14.00-2.el7                                  
  root-fonts.noarch 0:6.14.00-2.el7                                     root-graf.x86_64 0:6.14.00-2.el7                                  
  root-graf-asimage.x86_64 0:6.14.00-2.el7                              root-graf-gpad.x86_64 0:6.14.00-2.el7                             
  root-graf-x11.x86_64 0:6.14.00-2.el7                                  root-graf3d.x86_64 0:6.14.00-2.el7                                
  root-gui.x86_64 0:6.14.00-2.el7                                       root-gui-ged.x86_64 0:6.14.00-2.el7                               
  root-hist.x86_64 0:6.14.00-2.el7                                      root-hist-painter.x86_64 0:6.14.00-2.el7                          
  root-icons.noarch 0:6.14.00-2.el7                                     root-io.x86_64 0:6.14.00-2.el7                                    
  root-mathcore.x86_64 0:6.14.00-2.el7                                  root-matrix.x86_64 0:6.14.00-2.el7                                
  root-minuit.x86_64 0:6.14.00-2.el7                                    root-multiproc.x86_64 0:6.14.00-2.el7                             
  root-net.x86_64 0:6.14.00-2.el7                                       root-physics.x86_64 0:6.14.00-2.el7                               
  root-tree.x86_64 0:6.14.00-2.el7                                      root-tree-dataframe.x86_64 0:6.14.00-2.el7                        
  root-tree-player.x86_64 0:6.14.00-2.el7                               root-vecops.x86_64 0:6.14.00-2.el7                                
  urw-fonts.noarch 0:2.4-16.el7                                         xorg-x11-font-utils.x86_64 1:7.5-20.el7                           
  xorg-x11-fonts-ISO8859-1-75dpi.noarch 0:7.5-9.el7                     xxhash-libs.x86_64 0:0.6.5-1.el7
KoolReport commented on Aug 7, 2018

Thank Thom for your valuable information.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

None