Hi,

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

I don't use a lot participant DB.

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?

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

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

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

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

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

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?

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

Maybe some problem with excel/CSV or something other.

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.

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

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 ?

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

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

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

Participant_DB is constructed like this actually.

Need complete rewrite to be really fixed.

Ouch!

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

Again : Need complete rewrite to be really fixed.

Move it to Feature, sorry.

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

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

tested on a Postgres 9.1 database also

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