CiviCRM Community Forums (archive)

I have a problem for importing multiple notes for contacts.
In a csv file, I have 2 notes column for each contact. If I map the 2 fields for importing. Only the first column is imported. Ok why not.
But if I launch a second batch to import the second note, CiviCRM import the second note 2 times.
In import form, I have tried options : Update or  Fill in the field For Duplicate Contacts. The result is the same. Notes are imported 2 times.

In conclusion, how can I import contacts with 2 notes ?

Thanks,
Philippe

Thank you.

I have installed this extension. I will test tomorrow.

I found a solution. It's base on a reply of aberverley : http://forum.civicrm.org/index.php/topic,21469.msg105353.html#msg105353

I import contacts with the first note. And then I updated records with the second note. So this second note is now 2 times in the database, I deleted the duplicated note with some SQL queries:

create table tempnotes (id int);

INSERT INTO tempnotes( id )
SELECT max( id )
FROM `civicrm_note`
WHERE `entity_table` = 'civicrm_contact'
AND entity_id >=21798
GROUP BY entity_id
HAVING count( id ) >1

DELETE FROM civicrm_note WHERE id IN (
  SELECT id FROM tempnotes
)

drop table tempnotes;
This only works for 2 notes, beyond it is impossible to delete notes in doubles with this method.


If someone can explain to me why the notes are imported twice. I'm interested in the technical explanation.