[Solved] Importing notes

[PhilippeS]

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

[JonGold]

Phillippe,

I think you might have better luck importing the notes separately through the API, perhaps with the API csv Import GUI extension?  https://civicrm.org/extensions/api-csv-import-gui

I'm not saying it's the way it SHOULD be - I think that importing notes should be better supported at a few levels in CiviCRM - but it's better to have an answer than curse the lack of them!

[PhilippeS]

Thank you.

I have installed this extension. I will test tomorrow.

[PhilippeS]

This extension does not work in my case.

I do not have the "Entity ID" value in the dropdown list : Matching CiviCRM Field. And necessarily, the import fails with the error: "Missing required field (s): entity_id"
Also, in my CSV, I don't have the civirm ID of the contact, only an extrenal ID.

[PhilippeS]

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:

Code: [Select]

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.