| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06113 | Bug reports | Import/Export | public | 2012-05-17 16:50 | 2012-08-03 13:48 |
| Reporter | Fred | Assigned To | jcleeland | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.00RC1 | ||||
| Fixed in Version | 2.00RC5 | ||||
| Summary | 06113: Import participants from CSV does not work | ||||
| Description | After selecting a file for import, it reports that the data values are additional field values and asks me to map them to attributes. See attached screen shot. When I try to continue it says zero participants were imported. I tried it with several csv files, including with and without quotes, different delimiters, etc. In addition, I tried importing attributes but found that the interface for dragging and dropping them to be virtually unusable. You have to pick an attribute and drag it down while scrolling to a small target at the bottom of the page. Tested this on both webkit (chrome/safari) and Firefox. See the attached screen shot (the browser is zoomed out to show 2 pages long) | ||||
| Steps To Reproduce | Sample CSV contents: Go to Participants and select import from CSV | ||||
| Additional Information | Select which fields to import as attributes with your 0 participants. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 00000 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Chrome, Safari, Firefox | ||||
| Database type & version | MySQL 5.5.9 | ||||
| Server OS (if known) | Mac OS Lion | ||||
| Webserver software & version (if known) | Apache 2.2.17 | ||||
| PHP Version | 5.3.6 | ||||
 |
The biggest problem here was the new admin template, which didn't have the style sheets for these pages. I've updated them now and spent quite a bit of time cleaning out and fixing the CPDB files. My tests show a standard import working now, and although there are still some improvements in the UI that need to be made, it's far more usable now! |
 |
Great thanks. Looking forward to checking it out in the next build |
 |
2.00RC6 released. |
|
|
I installed RC7 and tried again. The attribute mapping screen looks far more usable now. I still can't get an import to work. 1) After starting the import a dialog appears with a missing image and an "ok" button but no other feedback. It's looking for this: images/ajax-loader.gif. If I click ok it returns to the participant panel but the records aren't imported 2) When I try an import on a file with new attributes and select one to be created in the attributes list, it DOES create the new attribute but doesn't import any participants |
|
|
Fred, something looks wrong with your CSV file - it appears as though it can't tell that "barack" is the beginning of the second line. Could you attach the file to this report and I'll have a play with it, but I suspect it's to do with Apple and line-endings. |
|
|
Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9179 |
|
|
@Fred, if you get a chance could you apply the attached diff and see if that fixes the problem? It looks like the setting to allow PHP to automatically detect unusual file endings (like MAC ones) was applied AFTER the script read the file, so that could explain the problem! |
|
|
Hi @Jason, the new participantsaction.php file solved the problem. The file I was using was from a Mac, but I was using UTF-8 with LF line endings, which usually works for me. Although as you said, it's a finicky thing. Thanks for resolving this. |
