Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Cyrillic on export still not work ??

More
9 years 10 months ago #128098 by bobssy
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
The topic has been locked.
More
9 years 10 months ago - 9 years 10 months ago #128107 by DenisChenu
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 support - Plugins, theme and development .
I don't answer to private message.
Last edit: 9 years 10 months ago by DenisChenu.
The following user(s) said Thank You: bobssy
The topic has been locked.
More
9 years 10 months ago #128113 by bobssy
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
The topic has been locked.
More
9 years 10 months ago #128118 by DenisChenu
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 support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
More
9 years 10 months ago #128119 by bobssy
Roger :)
10x a million
The topic has been locked.
More
9 years 10 months ago - 9 years 10 months ago #128138 by bobssy
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)
Last edit: 9 years 10 months ago by bobssy.
The topic has been locked.
More
9 years 10 months ago #128152 by holch
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.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
More
9 years 10 months ago #128153 by holch
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.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose