Cyrillic on export still not work ??

More
2 years 8 months ago #128098 by bobssy
bobssy created the topic: Cyrillic on export still not work ??
Hi , Export on Cyrillic dos not work,
files on site can't be downloaded ...

Can anyone send me link to correct Cyrillic export,
i don't wont to find hot water :)

10x
Bojidar
Attachments:

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

More
2 years 8 months ago - 2 years 8 months ago #128107 by DenisChenu
DenisChenu replied the topic: Cyrillic on export still not work ??
This fonts is used only in PDF export (and thinks is not needed since we use dejavusans for PDF export)

Here : use a real tools to read CSV.

The CSV file is in UTF8 : then force UTF8 when open it. ANd use comma (comma seperated value).
Best is to directly use LibreOffice Calc .... libreoffice.org/

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .
Last Edit: 2 years 8 months ago by DenisChenu.
The following user(s) said Thank You: bobssy

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

More
2 years 8 months ago #128113 by bobssy
bobssy replied the topic: Cyrillic on export still not work ??
Thanks Denis...
I use notepad++ and its work for me also, but i want to close this bug for feature release
i already start look in export_helper.php and look where can be a problem

If you can help me with advice and knowledge will be great.
Now we avoid problem using different piece of software that encoding file correctly i what so solve csv file to be working without using others encoding tools

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

More
2 years 8 months ago #128118 by DenisChenu
DenisChenu replied the topic: Cyrillic on export still not work ??
Hi,

LimeSurvey produce clean UTF8 CSV file.
MS Excel have a bug. I don't fix bug on MS-Excel ;)

If you export at xls : excel open it.
You can try xlsx export format, but this format is very complicated ...

And please : don't try to fix csv export : else i can not import it directly in LibreOffice CAlc and other CSV editor.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

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

More
2 years 8 months ago #128119 by bobssy
bobssy replied the topic: Cyrillic on export still not work ??
Roger :)
10x a million

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

More
2 years 8 months ago - 2 years 8 months ago #128138 by bobssy
bobssy replied the topic: Cyrillic on export still not work ??
Any info what i shuld change to get this excel working...
i change java script to unblock selection , now seems that it dont get all data bechause of somewhere in php has limit...
i don whant to spend hours looking file by file....if anyone can help will be great...

I what to use excel without any external manipulations...and will do it to be working i just whant to save time , java script changed:

exportresults.js
on line 4 : if ($(this).val().length > 22255 && $('#xls').prop('checked')) {
on line 17: if (selectedCount> 22255)
Attachments:
Last Edit: 2 years 8 months ago by bobssy.

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

More
2 years 8 months ago #128152 by holch
holch replied the topic: Cyrillic on export still not work ??
As far as I know, the export library that creates the excel does only create the old excel format and this format is limited to 255 columns. So far no one really was willing to put the effort in to implement a new library that can create xlsx files which would be able to cope with a lot more columns.

Most will just export to CSV and then import into excel I guess.

However, I am sure that the team is happy if someone is willing to work on a implementation for the newer Excel format that supports more columns.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

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

More
2 years 8 months ago #128153 by holch
holch replied the topic: Cyrillic on export still not work ??
As far as I know, the export library that creates the excel does only create the old excel format and this format is limited to 255 columns. So far no one really was willing to put the effort in to implement a new library that can create xlsx files which would be able to cope with a lot more columns.

Most will just export to CSV and then import into excel I guess.

However, I am sure that the team is happy if someone is willing to work on a implementation for the newer Excel format that supports more columns.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

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

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!