Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

export to xlsx noth...
 
Notifications
Clear all

export to xlsx nothing appears only unintelligible characters

8 Posts
3 Users
0 Reactions
2,941 Views
Yahya Nehmi
(@ymn76ymn)
Posts: 17
Active Member
Topic starter
 
[#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

 


 
Posted : 26 Jan 2024 2H00
Maxca
(@maxime)
Posts: 274
Active Member Admin
 

Hello,

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

Maxca


 
Posted : 26 Jan 2024 10H56
Yahya Nehmi
(@ymn76ymn)
Posts: 17
Active Member
Topic starter
 

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.


 
Posted : 26 Jan 2024 22H59
Maxca
(@maxime)
Posts: 274
Active Member 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


 
Posted : 29 Jan 2024 10H59
Yahya Nehmi
(@ymn76ymn)
Posts: 17
Active Member
Topic starter
 

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.


 
Posted : 30 Jan 2024 22H22
Maxca
(@maxime)
Posts: 274
Active Member Admin
 

Helo,

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

Maxca


 
Posted : 31 Jan 2024 15H59
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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


 
Posted : 01 Feb 2024 13H48
Yahya Nehmi
(@ymn76ymn)
Posts: 17
Active Member
Topic starter
 

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


 
Posted : 01 Feb 2024 23H28
Share:

Scroll to Top