View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
07919Bug reportsCentral participant databasepublic2013-06-12 02:132013-10-09 18:05
Reporterstevage Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07919: 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.

  1. Create extended attributes: PatientID,Notes,Start date,DOB,Mobile phone,Known as (all text box except DOB and Start date are dates)
  2. 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.
  3. 10 participants will be created. (there are some blank records in the file, and one participant without email address)
  4. Verify that extended attributes have been populated.
  5. 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.)

TagsNo 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 heat6
Complete LimeSurvey version number (& build)130514
I will donate to the project if issue is resolvedNo
Browser
Database type & versionLimeservice
Server OS (if known)Limeservice
Webserver software & version (if known)Limeservice
PHP VersionLimeservice

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

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 ...

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

c_schmitz

2013-10-07 15:38

administrator   ~26588

This will be fixed on LimeService today.
c_schmitz

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

DenisChenu

2013-10-07 15:53

developer   ~26590

It's just a stringtolower .... snif .... :)
diego_576

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

c_schmitz

2013-10-09 11:22

administrator   ~26655

2.00+ Build 121009 released
c_schmitz

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

Related Changesets

LimeSurvey: master c92bd22b

2013-10-07 15:38

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 18:02

c_schmitz


Details Diff		 Fixed issue 07919: Uploading duplicate participants erases data Affected Issues
07919
mod - application/controllers/admin/participantsaction.php Diff File

Issue History

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