Forum

export to xlsx noth...
 
Notifications
Retirer tout

export to xlsx nothing appears only unintelligible characters

8 Posts
3 Utilisateurs
0 Reactions
2,916 Vu
Yahya Nehmi
(@ymn76ymn)
Posts: 17
Eminent Member
Début du sujet
 
[#9261]

When I want to export a report with a list of projects or activities with Generate Excel report button in report list screen, the report appear with unclear characters, This problem appears to me only with the Arabic language, 
I tried to change the font for PDF export setting to freeserif (for Arabic Characters) but nothing.

v 11.1.1
Microsoft Edge
goolge chrome

 


 
Posté : 26/01/2024 2:00 am
(@maxime)
Posts: 268
Membre Admin
 

Hello,

Try this: Global parameters > System > Translation data > export CSV to UTF-8 format : YES.

Maxca


 
Posté : 26/01/2024 10:56 am
Yahya Nehmi
(@ymn76ymn)
Posts: 17
Eminent Member
Début du sujet
 

thank you for replying,
I tried changing the setting to UTF-8 format : YES, but nothing happened, the problem was not solved,
And I tried with new version v11.1.3, but the result was the same.


 
Posté : 26/01/2024 10:59 pm
(@maxime)
Posts: 268
Membre Admin
 

Hello,

It's not a problem with projeqtor. You need to open the file in utf-8. Try this: Data > get data > from file> from text/csv  unicode (UTF-8). delimiter ; (see excel options)

Maxca


 
Posté : 29/01/2024 10:59 am
Yahya Nehmi
(@ymn76ymn)
Posts: 17
Eminent Member
Début du sujet
 

thank you for replying,
This method works in a CSV file, but it did not work with XLSX files after changing them to TXT files.


 
Posté : 30/01/2024 10:22 pm
(@maxime)
Posts: 268
Membre Admin
 

Helo,

It's a problem with your config of Excel. Again see excel options...

Maxca


 
Posté : 31/01/2024 3:59 pm
(@babynus)
Posts: 14952
Membre Admin
 

Try and import your file (even if it has xlsx extension) and specify in import options that file is encoded in UTF-8


 
Posté : 01/02/2024 1:48 pm
Yahya Nehmi
(@ymn76ymn)
Posts: 17
Eminent Member
Début du sujet
 

thank you for replying,
I tried importing the file to UTF-8, it changed to other unintelligible characters, the problem was not solved.


 
Posté : 01/02/2024 11:28 pm
Share:
Retour en haut