Ticket #63 (closed enhancement: fixed)

Opened 6 years ago

Last modified 6 years ago

importing subjects twice does not add information to existing subjects but creates new subjects

Reported by: leny.vanwijk@… Owned by: t.w.abma@…
Priority: critical Milestone: 0.6
Component: Import wizards Version:
Keywords: Cc:
Hardware: Operating system:
Product: URL:


If you import subjects two times to the same study the second time the data from the first time ar not changed but an entire serie of new subjects show up. So it is not possible to add some new information to subjects by using the importer an it would be very nice if that would be possible.

Change History

comment:1 Changed 6 years ago by business@…

  • Owner set to t.w.abma@…
  • Status changed from new to assigned
  • Milestone set to 0.6

comment:2 Changed 6 years ago by business@…

On Skype (16:18 today), you (Tjeerd) also reported this error: Violation of unique constraint SYS_CT_199: duplicate value(s) for column(s) PARENT_ID,SUBJECTNAME in statement [insert into subject (id, version, subjectname, species_id, template_id, parent_id, subjects_idx) values (null, ?, ?, ?, ?, ?, ?)]

This basically says that within 1 study (parent_id) the subject name (subject name) should be unique, so this is probably an error message related to the problem described in this ticket.

Instead of trying to add the subjects again, it should merge them with the subjects that are already present in the database. Use the identifier field to check whether an imported entity already exists.

comment:3 Changed 6 years ago by t.w.abma@…

  • Status changed from assigned to closed
  • Resolution set to fixed

This should be fixed by now. There is being checked whether the entity already exists (by the identifying field).

Note: See TracTickets for help on using tickets.