07919: Uploading duplicate participants erases data - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

07919	Bug reports	Central participant database	public	2013-06-12 02:13	2013-10-09 18:05

Reporter	stevage	Assigned To	c_schmitz
Priority	normal	Severity	partial_block
Status	closed	Resolution	fixed
Product Version	2.00+
Fixed in Version	2.00+

Summary	07919: Uploading duplicate participants erases data
Description	When we import a CSV containing participants, some or all of whom exist in the database already, existing data in extended attributes gets wiped.
Steps To Reproduce	I can reproduce reliably with this sequence of steps on LimeService. Create extended attributes: PatientID,Notes,Start date,DOB,Mobile phone,Known as (all text box except DOB and Start date are dates) Import the attached CSV file. Leave the default settings (separator etc), map the fields over. "Name" maps to "Known as", "DOB" doesn't map to anything. 10 participants will be created. (there are some blank records in the file, and one participant without email address) Verify that extended attributes have been populated. Repeat the process, making sure that "Overwrite existing token attribute values if a duplicate participant is found?" is checked. Result: either "processing" stage hangs, or completes with warnings about duplicate participants. However, all extended attribute values have been deleted.
Additional Information	Verified that this is not survey-specific or account-specific: I carried out this action in a different survey under a different limeservice account. (I don't know if the build number is actually 130514. It's a compulsory field.)
Tags	No tags attached.
Attached Files	Mergedforupload_June11_anon.csv (1,280 bytes) PatientID,Notes,Name,startdate,Email,Mobile phone,firstname,lastname 10111,Left total knee replacement,Smith1 A,11/01/2011,z@gmail.us,0111 111 111,A,Smith1 10112,Left knee arthroscopy,Smith2 B,11/01/2011,a1@gmail.com.au,0111 151 511,B,Smith2 10113,Left knee arthroscopy,Smith3 C,11/01/2011,a2@gmail.gov.au,0111 511 501,C,Smith3 1111,Left knee arthroscopy,Smith4 D,11/01/2011,a3@hotmail.com,0111 111 111,D,Smith4 11014,Left knee arthroscopy,Smith5 E,11/01/2011,a4@gmail.com,0101 115 111,E,Smith5 11115,Right knee arthroscopy,Smith6 F,11/01/2011,a5@gmail.com.au,0101 111 111,F,Smith6 10116,Right knee arthroscopy,Smith7 G,11/01/2011,a6@gmail.com,0100 111 115,G,Smith7 10117,"Right knee ACL reconstruction, hamstring tendon graft",Smith8 H,11/01/2011,,0101 111 151,H,Smith8 10118,"Right knee ACL reconstruction, hamstring tendon graft",Smith9 I,11/01/2011,a7@gmail.com,0111 115 101,I,Smith9 11119,"Right knee ACL reconstruction, hamstring tendon graft",Smith10 J,11/01/2011,a8@gmail.com.au,0111 115 115,J,Smith10 10115,Left knee revision ACL reconstruction (H/S from RIGHT knee),Smith11 K,11/01/2011,a9@gmail.com,0111 001 005,K,Smith11 ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,,,,,,, Mergedforupload_June11_anon.csv (1,280 bytes)

Bug heat	6
Complete LimeSurvey version number (& build)	130514
I will donate to the project if issue is resolved	No
Browser
Database type & version	Limeservice
Server OS (if known)	Limeservice
Webserver software & version (if known)	Limeservice
PHP Version	Limeservice

User List	There are no users monitoring this issue.

DenisChenu 2013-06-26 18:35 developer ~25667	Hello stevage: I test to import 2 times your files. Following what you say (it's VERY difficult to manage "association" of attribute). Hev 500 error ... <p>Undefined index: Name (/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/controllers/admin/participantsaction.php:1321) This attribute map screen is AWFULL to use ..... Don't take it actually. But try to have a look ....

c_schmitz 2013-10-07 15:38 administrator ~26588	This will be fixed on LimeService today.

c_schmitz 2013-10-07 15:39 administrator ~26589	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13159

DenisChenu 2013-10-07 15:53 developer ~26590	It's just a stringtolower .... snif .... :)

diego_576 2013-10-08 21:14 reporter ~26634 Last edited: 2013-10-08 21:15	I have the same or similar problem. When I import the FIRST CSV file to my empty central participants database panel it imports data to the mandatory fields, it creates the additional fields, and it uploads the data to the additional fields. If I try to do this again with the same fields just different data it just uploads the data to the MANDATORY fields, and NO DATA to the additional fields. I don't get any errors, just after the first time that I have uploaded data, the data for additional fields is never uploaded, just the data for mandatory fields. Can this be fixed?

c_schmitz 2013-10-09 11:22 administrator ~26655	2.00+ Build 121009 released

c_schmitz 2013-10-09 18:05 administrator ~26680	Fix committed to 2.05 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13212

LimeSurvey: master c92bd22b 2013-10-07 13:38:07 c_schmitz Details Diff	Fixed issue 07919: Uploading duplicate participants erases data	Affected Issues 07919
	mod - application/controllers/admin/participantsaction.php	Diff File
LimeSurvey: 2.05 853bacd2 2013-10-09 16:02:18 c_schmitz Details Diff	Fixed issue 07919: Uploading duplicate participants erases data	Affected Issues 07919
	mod - application/controllers/admin/participantsaction.php	Diff File

Date Modified	Username	Field	Change
2013-06-12 02:13	stevage	New Issue
2013-06-12 02:13	stevage	File Added: Mergedforupload_June11_anon.csv
2013-06-24 18:15	DenisChenu	Assigned To	=> DenisChenu
2013-06-24 18:15	DenisChenu	Status	new => assigned
2013-06-26 11:50	DenisChenu	Assigned To	DenisChenu =>
2013-06-26 16:19	DenisChenu	Assigned To	=> DenisChenu
2013-06-26 16:19	DenisChenu	Status	assigned => new
2013-06-26 16:19	DenisChenu	Assigned To	DenisChenu =>
2013-06-26 18:35	DenisChenu	Note Added: 25667
2013-09-24 14:57	c_schmitz	Assigned To	=> c_schmitz
2013-09-24 14:57	c_schmitz	Status	new => assigned
2013-10-07 15:38	c_schmitz	Note Added: 26588
2013-10-07 15:38	c_schmitz	Status	assigned => resolved
2013-10-07 15:38	c_schmitz	Fixed in Version	=> 2.00+
2013-10-07 15:38	c_schmitz	Resolution	open => fixed
2013-10-07 15:39	c_schmitz	Changeset attached	=> LimeSurvey master c92bd22b
2013-10-07 15:39	c_schmitz	Note Added: 26589
2013-10-07 15:53	DenisChenu	Note Added: 26590
2013-10-08 21:14	diego_576	Note Added: 26634
2013-10-08 21:15	diego_576	Note Edited: 26634
2013-10-09 11:22	c_schmitz	Note Added: 26655
2013-10-09 11:22	c_schmitz	Status	resolved => closed
2013-10-09 18:05	c_schmitz	Changeset attached	=> LimeSurvey 2.05 853bacd2
2013-10-09 18:05	c_schmitz	Note Added: 26680

View Issue Details

Users monitoring this issue

Activities

Related Changesets

Issue History