View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
07842Bug reportsImport/Exportpublic2013-05-16 07:572013-08-04 21:54
Reporterstevage Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07842: Import partipants CSV from Excel Mac 2011 fails
Description
  1. Save a CSV created in Excel 2011 in Mac. (These have ^M line endings)
  2. Import in LimeSurvey
  3. Line endings are missed, so all the data ends up treated as a gigantic header.
Additional Information

I have a test file but it includes confidential data. I don't seem to be able to modify the data without changing the line endings.

Using the version of LimeSurvey currently running on LimeService. 2.00+ I guess. I don't know how to find the build number or the other questions. (Just guessing something to pass the validation here.)

TagsNo tags attached.
Attached Files
import2-anon.csv.zip (756 bytes)
Bug heat4
Complete LimeSurvey version number (& build)130514
I will donate to the project if issue is resolvedNo
Browser
Database type & version???
Server OS (if known)???
Webserver software & version (if known)???
PHP Version???

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-05-17 12:08

administrator   ~25282

Last edited: 2013-05-17 13:14

Where do you import these exactly? In the survey participants or in the global ones?
If it does not work it is most likely a issue with your PHP version or configuration. PHP does automatically detect the line endings.
stevage

stevage

2013-06-11 07:06

reporter   ~25498

In the global participants table.

As noted, this is LimeService - so the PHP version/config is whatever LimeService uses.
c_schmitz

c_schmitz

2013-06-14 16:10

administrator   ~25534

Can you attach a 2-line sample file please?
stevage

stevage

2013-06-17 09:08

reporter   ~25560

OK - I've tried to preserve the line endings in this file.
c_schmitz

c_schmitz

2013-07-30 14:03

administrator   ~25888

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=12784
c_schmitz

c_schmitz

2013-08-04 21:54

administrator   ~25917

2.00+ Build 130802 released

Related Changesets

LimeSurvey: master d60709b7

2013-07-30 12:03:43

c_schmitz

Details Diff 		Fixed issue 07842: Import global partipants CSV from Excel Mac 2011 fails because headers are not correctly identified Affected Issues
07842
mod - application/controllers/admin/participantsaction.php Diff File

Issue History

Date Modified Username Field Change
2013-05-16 07:57 stevage New Issue
2013-05-17 12:08 c_schmitz Note Added: 25282
2013-05-17 12:08 c_schmitz Assigned To => c_schmitz
2013-05-17 12:08 c_schmitz Status new => feedback
2013-05-17 13:14 c_schmitz Note Edited: 25282
2013-06-11 07:06 stevage Note Added: 25498
2013-06-11 07:06 stevage Status feedback => assigned
2013-06-14 16:10 c_schmitz Note Added: 25534
2013-06-14 16:10 c_schmitz Status assigned => feedback
2013-06-17 09:07 stevage File Added: import2-anon.csv.zip
2013-06-17 09:08 stevage Note Added: 25560
2013-06-17 09:08 stevage Status feedback => assigned
2013-07-30 14:02 c_schmitz Status assigned => resolved
2013-07-30 14:02 c_schmitz Fixed in Version => 2.00+
2013-07-30 14:02 c_schmitz Resolution open => fixed
2013-07-30 14:03 c_schmitz Changeset attached => LimeSurvey master d60709b7
2013-07-30 14:03 c_schmitz Note Added: 25888
2013-08-04 21:54 c_schmitz Note Added: 25917
2013-08-04 21:54 c_schmitz Status resolved => closed