Anonymous Login
2016-12-09 01:03 CET

View Issue Details Jump to Notes ] Related Changesets ]
IDProjectCategoryView StatusLast Update
08444Bug reports[All Projects] Import/Exportpublic2014-06-11 18:02
ReporterKitchM 
Assigned ToDenisChenu 
PrioritynormalSeverityfeature 
StatusclosedResolutionfixed 
Product Version2.00+ 
Target VersionFixed in Version2.05+ 
Summary08444: Participant DB : CSV Import Fails To Display All Fields
DescriptionCannot see Email field to import.
Steps To ReproduceI open the program interface on my server and I see the login page. After login, I see the main screen. I select my survey name and select Central Participant Database/Panel. Next I select Import from CSV. When I browse and select the file, I then select to Upload.

The next screen shows all fields but the Email field. It is maddening. No matter what I do, that field will not display in the list.
Additional InformationSee screenshot attached.
TagsNo tags attached.
Complete LimeSurvey version number (& build)Version 2.00+ Build 131206
I will donate to the project if issue is resolvedNo
BrowserFirefox 25.0
Database & DB-VersionMySQL version 5.1.71
Operating System (Server)CentOS Linux 6.4
Webserver software & versionApache version 2.2.15
PHP Version5.3.3-27.el6_5
Attached Files

-Relationships
related to 09078closedDenisChenu CSV export of particiapnt DB can make invalid CSV file 
child of 08447closedMazi Partcipant DB : outdated documentation 
+Relationships

-Notes

~27556

DenisChenu (developer)

Hi,

Think email is allways linked to email ?
When you import, did you have email imported ?

I don't use a lot participant DB.

~27557

KitchM (reporter)

Sorry, I don't understand. Database does contain an email field. Are you suggesting to import the file as it is, even though it does not display an email field?

~27558

DenisChenu (developer)

Last edited: 2013-12-13 08:24

View 2 revisions

Yes,

Because i think email fiels is set automatically to email field.

Look at http://manual.limesurvey.org/Central_participants_database_%28User_panel%29_Development#lime_participants . This documentation is outdated, but you can try and update documentation, please.

Denis

~27562

KitchM (reporter)

Assuming your implecation was correct, I just went ahead and imported the records. However, ther results were less than convincing. Please review the screenshot.

~27563

DenisChenu (developer)

OK,

Seems confirmed there are a real lack of documentation and information from CDB.

Seems mandatory fields was : firstname,lastname,email and participant_id

And check duplicate was done with participant_id
                if ((!in_array('firstname', $firstline) && !in_array('lastname', $firstline) && !in_array('email', $firstline)) && !in_array('participant_id', $firstline))
                {
                    $recordcount = count($tokenlistarray);
                    break;
                }
This must be rewrited, but first documented.

Denis

~27566

KitchM (reporter)

Obviously, it doesn't work the way it is.

~27567

DenisChenu (developer)

Can you upload your CSV file for testing purpose ? With only one line for participant.

~27570

KitchM (reporter)

Sadly, no. I'm dealing with sensitive corporate data, and I cannot let it out.

But please tell me your thoughts on the subject. What are you looking for exactly?

~27571

DenisChenu (developer)

You can remove whole information, just pur an line with some data.

Maybe some problem with excel/CSV or something other.

~27572

KitchM (reporter)

Okay, I'm attaching a sample file created from the original. I only opened it in Excel and deleted 515 records, leaving one that I changed to false information. Then I saved it as CSV again.

~27592

DenisChenu (developer)

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

~27593

DenisChenu (developer)

Hi,

Your CSV file don't have NEEDED header :
firstname,lastname and email

Writing like this (not in capital).

Anyway : i do some fix here.
Can upload a file without firstname,lastname and email (if you don't check Filter blank email addresses: ).

Here: it's an exported file ?

~27594

DenisChenu (developer)

PS: you see : 518 records have EMPTY mandatory fields : the explanation is here.
And if you look at "import file" you see:
 Mandatory fields: firstname, lastname, email

~27596

KitchM (reporter)

Please change the coding so that it will recognize these regardless of case.

~27601

DenisChenu (developer)

Please : it's a feature request, not a bug.

Participant_DB is constructed like this actually.

Need complete rewrite to be really fixed.

~27608

KitchM (reporter)

Ouch!

Why have a section for selection and arrangement of fields if it is so specific? It is counterintuitive from the user's viewpoint.

~27611

DenisChenu (developer)

Again : Need complete rewrite to be really fixed.

Move it to Feature, sorry.

~27614

KitchM (reporter)

Oh well. Can't get back into it anyway. Just give blank screen.

~30054

riqcles (reporter)

I tried several method.
  from the demo site.

  Method 1: Use the format of central database management

  I export a csv file, then I delete the records, except one.
  After I re-import -> not happening.
  I retry deleting the information in the "participant_id" column -> not pass.

  Method 2: Using a "classic" of invitation csv file
  I import with all columns -> not pass
  I import the file with 3 minimum information:
  firstname, lastname, email -> not pass

~30055

riqcles (reporter)

tested on a Postgres 9.1 database also

~30091

DenisChenu (developer)

Not this issue.

2 issue :
http://bugs.limesurvey.org/view.php?id=9078 for the export DB
http://bugs.limesurvey.org/view.php?id=8462 for empty firstname/lastname
+Notes

+Related Changesets

Issue Community Support
This issue is already marked as resolved.
If you feel that is not the case, please reopen it and explain why.
Supporters: No one explicitly supports this issue yet.
Opponents: No one explicitly opposes this issue yet.

-Issue History
Date Modified Username Field Change
2013-12-11 21:59 KitchM New Issue
2013-12-11 21:59 KitchM File Added: Screenshot - 12112013 - 03:19:04 PM - LimeSurvey showing Field Selection page.png
2013-12-12 18:59 DenisChenu Summary CSV Import Fails To Display All Fields => Participant DB : CSV Import Fails To Display All Fields
2013-12-12 19:01 DenisChenu Note Added: 27556
2013-12-12 22:26 KitchM Note Added: 27557
2013-12-13 08:17 DenisChenu Note Added: 27558
2013-12-13 08:23 DenisChenu Relationship added child of 08447
2013-12-13 08:24 DenisChenu Note Edited: 27558 View Revisions
2013-12-13 19:37 KitchM Note Added: 27562
2013-12-13 19:37 KitchM File Added: Screenshot - 12132013 - 01:34:58 PM - LimeSurvey import failure with empty fields.png
2013-12-13 19:39 KitchM File Added: Screenshot - 12132013 - 01:37:52 PM - LimeSurvey shows no participants.png
2013-12-14 14:08 DenisChenu Note Added: 27563
2013-12-16 02:26 KitchM Note Added: 27566
2013-12-16 08:30 DenisChenu Note Added: 27567
2013-12-16 10:33 c_schmitz Assigned To => DenisChenu
2013-12-16 10:33 c_schmitz Status new => feedback
2013-12-16 18:43 KitchM Note Added: 27570
2013-12-16 18:43 KitchM Status feedback => assigned
2013-12-16 19:36 DenisChenu Note Added: 27571
2013-12-16 22:52 KitchM Note Added: 27572
2013-12-16 22:53 KitchM File Added: test.csv
2013-12-17 16:04 DenisChenu Changeset attached => LimeSurvey master 1e23dcce
2013-12-17 16:04 DenisChenu Note Added: 27592
2013-12-17 16:04 DenisChenu Resolution open => fixed
2013-12-17 16:06 DenisChenu Note Added: 27593
2013-12-17 16:06 DenisChenu Status assigned => resolved
2013-12-17 16:06 DenisChenu Fixed in Version => 2.05+
2013-12-17 16:07 DenisChenu Note Added: 27594
2013-12-17 17:43 KitchM Note Added: 27596
2013-12-18 12:08 DenisChenu Note Added: 27601
2013-12-18 16:02 KitchM Note Added: 27608
2013-12-18 16:21 DenisChenu Note Added: 27611
2013-12-18 16:21 DenisChenu Project Bug reports => Feature requests
2013-12-18 16:22 DenisChenu Status resolved => feedback
2013-12-18 16:22 DenisChenu Resolution fixed => reopened
2013-12-18 16:22 DenisChenu Assigned To DenisChenu =>
2013-12-18 16:22 DenisChenu Assigned To => DenisChenu
2013-12-18 16:22 DenisChenu Status feedback => new
2013-12-18 16:22 DenisChenu Assigned To DenisChenu =>
2013-12-18 16:22 DenisChenu Priority high => normal
2013-12-18 16:22 DenisChenu Severity block => feature
2013-12-18 16:45 KitchM Note Added: 27614
2014-06-05 11:11 riqcles File Added: central_1401908650.csv
2014-06-05 11:11 riqcles File Added: limeSurvey_2_invitation.csv
2014-06-05 11:11 riqcles File Added: limeSurvey_2_invitation_modifs.csv
2014-06-05 11:14 riqcles Note Added: 30054
2014-06-05 11:15 riqcles Note Added: 30055
2014-06-06 17:50 DenisChenu Assigned To => DenisChenu
2014-06-06 17:50 DenisChenu Status new => assigned
2014-06-08 20:22 DenisChenu Project Feature requests => Bug reports
2014-06-11 18:01 DenisChenu Relationship added related to 09078
2014-06-11 18:02 DenisChenu Note Added: 30091
2014-06-11 18:02 DenisChenu Status assigned => closed
2014-06-11 18:02 DenisChenu Resolution reopened => fixed
+Issue History