View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
12070Bug reportsImport/Exportpublic2017-01-19 14:082017-01-24 10:54
Reporterjelen1 Assigned Toc_schmitz  
PrioritynoneSeverityfeature 
Status closedResolutionno change required 
Product Version2.59.x 
Summary12070: Export problems
Description

I have some problems with data export from latest verions of lime Surwey.

  1. Export of answers to Excel format (page /index.php/admin/export/sa/exportresults/surveyid/....) failed. (Message: Internal Server Error ZipArchive not found An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem. Thank you.)

The same surweys worked in thre past.

  1. Export to .csv format includes CR characters from answers. It is very uncomfortable to import it into excel - it mus be cleaned by hand. Is it possible to add switch for remove CR/LF from strings during export task?

  2. Colon (,) character in .csv file is not full usable in czech languague. Czech Excel use semicolon (;) character as standard. I mus every export file rename to .txt and then set right delimiter in Excel import page (Excel normally imports .csv automatically - one row as one cell). Is it possible to add some switch for selecting of delimiter?

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)Verze 2.59.1+170116
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & version10.0.27-MariaDB-cll-lve
Server OS (if known)linux 3.10.0-427.10.1.lve1.4.7.el7.x86_64
Webserver software & version (if known)Apache/2.4.23 (Unix) OpenSSL/1.0.1e-fips
PHP Version5.5.38

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2017-01-19 16:43

developer   ~42774

CSV standard is , . Czech or not.
Better solution:

  • Open the CSV with LibreOffice Calc
  • If you really need : save it in excel.

About zip : maybe you have a lack of zip package in your php installation : can you send the phpinfo ?
c_schmitz

c_schmitz

2017-01-19 16:59

administrator   ~42776

Don't collect different issues in the same bug report. Also make sure by asking in the forums if your problem is really a bug.

The ZIPManager error hints that you do not have the ZIP extension installed on your server. See http://php.net/manual/de/zip.installation.php
DenisChenu

DenisChenu

2017-01-19 17:30

developer   ~42777

@c_schmitz : then the issue must be 'show excel export only in ZIP extension are availanle) no ?
c_schmitz

c_schmitz

2017-01-19 18:06

administrator   ~42779

We do not check for standard libraries.
To not have the ZIP library available it must be disabled during compliation. I don't see a point checking for that as other functions might be affected too.

For exmaple we also don't check for the PHP session library - it can be also disabled, you know ;).
DenisChenu

DenisChenu

2017-01-19 19:01

developer   ~42781

Right :)
jelen1

jelen1

2017-01-24 10:54

reporter   ~42809

Thanks for help. The problem was between my chair and my keyboard. I asked my server administrator, he started .zip module and everything work well now.

Other problem ("," versus ";" in .csv file) is not serious. I know, that semicolon is not standard, but Microsoft in my languague region has another idea and use it automatically as only option.

CR/LF inside strings in .csv file still mistake, i thing.

Issue History

Date Modified Username Field Change
2017-01-19 14:08 jelen1 New Issue
2017-01-19 16:43 DenisChenu Note Added: 42774
2017-01-19 16:59 c_schmitz Assigned To => c_schmitz
2017-01-19 16:59 c_schmitz Status new => closed
2017-01-19 16:59 c_schmitz Resolution open => no change required
2017-01-19 16:59 c_schmitz Note Added: 42776
2017-01-19 17:00 c_schmitz Product Version 2.06+ => 2.59.x
2017-01-19 17:30 DenisChenu Note Added: 42777
2017-01-19 18:06 c_schmitz Note Added: 42779
2017-01-19 19:01 DenisChenu Note Added: 42781
2017-01-24 10:54 jelen1 Note Added: 42809