View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - UTF8 export problem - ProjeQtOr
 

UTF8 export problem

More
18 Nov 2015 08:55 #1 by Salaty
UTF8 export problem was created by Salaty
Hi
I'm using ProjeQtOr v5.1.1 in Persian and enforceUTF8 is enabled. When I export every forms to excel or pdf, Persian fields are converted to some question marks.
Please inform me how to get rid of this problem.

Please Log in or Create an account to join the conversation.

More
18 Nov 2015 19:27 #2 by babynus
Replied by babynus on topic UTF8 export problem
Export with PDF : did it work better before V5.1 ?

Export to Excel : there is no export to Excel. Export is to CSV.
Could you try and open exported file (CSV) with text editor such as Notedpad++. It should b e correct.
I'm afraid Excel does not correctly import UTF-8 non ansi characters.
Maybe some conversion may be required before.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
18 Nov 2015 21:18 #3 by Salaty
Replied by Salaty on topic UTF8 export problem
I have not tried older versions.
Any editor shows some question marks.
Here are some sample generated files.
Attachments:

Please Log in or Create an account to join the conversation.

More
19 Nov 2015 07:45 #4 by Salaty
Replied by Salaty on topic UTF8 export problem
I found the problem for CSV files.
There was some extra utf8_decode functions in jsQuery.php.
But the problem for PDF files already exists and I cannot follow the problem, so please advise.
I suggest that you consider enabling enforceUtf8 by default for the next version, since it is more common.

Please Log in or Create an account to join the conversation.

More
19 Nov 2015 10:45 - 19 Nov 2015 10:49 #5 by babynus
Replied by babynus on topic UTF8 export problem
You're right.
utf8_decode was used to correctly display accentuated characters in Excel.
But this is valid only for western europe charsets.
Ticket #1870 recorded to try and parameter whever utf8_decode must be used on CSV export.

But the problem for PDF files already exists and I cannot follow the problem, so please advise.

This is a real problem, as non ansi characters are not correctly exported in pdf format.
If may be due to font used.
Ticket #1871 recorded to investigate.
NB : as a workaround, you can use a pdf printer, such as PDF Creator to generate PDF form printable report.

I suggest that you consider enabling enforceUtf8 by default for the next version, since it is more common.

It is, but only for new installs. It is not for existing installs as it will generate issues if MySql server in not cerrectly configured as UTF8.

Babynus
Administrator of ProjeQtOr web site
Last edit: 19 Nov 2015 10:49 by babynus.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.068 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.