Welcome to the LimeSurvey Community Forum

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

Cyrillic on export still not work ??

  • bobssy
  • bobssy's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 5 months ago #128098 by bobssy
Cyrillic on export still not work ?? was created 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.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 5 months ago - 8 years 5 months ago #128107 by DenisChenu
Replied by DenisChenu on 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 , plugin development .
I don't answer to private message.
Last edit: 8 years 5 months ago by DenisChenu.
The following user(s) said Thank You: bobssy
The topic has been locked.
  • bobssy
  • bobssy's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 5 months ago #128113 by bobssy
Replied by bobssy on 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
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 5 months ago #128118 by DenisChenu
Replied by DenisChenu on 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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • bobssy
  • bobssy's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 5 months ago #128119 by bobssy
Replied by bobssy on topic Cyrillic on export still not work ??
Roger :)
10x a million
The topic has been locked.
  • bobssy
  • bobssy's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 5 months ago - 8 years 5 months ago #128138 by bobssy
Replied by bobssy on 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: 8 years 5 months ago by bobssy.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 5 months ago #128152 by holch
Replied by holch on 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 answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 5 months ago #128153 by holch
Replied by holch on 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 answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose