Problème importation contact

[natinho]

Bonjour à tous,

J'ai installé CiviCRM pour l'association dans laquelle je travaille.

Ce CRM à l'air très puissant et peut faire énormement de choses, même si je n'ai pas encore compris toutes les fonctionnalités.

J'ai cependant un problème. Etant débutant je me tourne vers vous pour m'aider.

Je ne peux pas importer une liste de contact (750 contacts) et c'est très gênant car à la main c'est hyper long.

J'ai trouvé comment activer le debug et je vous retourne le résultat de celui-ci.

Je sais que ce sujet à peut etre déjà été traité par nos confrères utilisateur anglophones, mais je ne suis pas très doué avec la langue de Shakespeare...

Voici le debug :

Code: [Select]

backTrace

#0 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(149): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/wp-content/plugins/civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: constraint violation", -3, 16, (Array:2), "INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_...")
#4 /var/www/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-3, 16, (Array:2), "INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_...")
#5 /var/www/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -3, NULL, NULL, "INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_...", "DB_Error", TRUE)
#6 /var/www/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-3, NULL, NULL, NULL, "1452 ** Cannot add or update a child row: a foreign key constraint fails (`ci...")
#7 /var/www/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /var/www/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_...")
#9 /var/www/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_...")
#10 /var/www/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_...")
#11 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(278): DB_DataObject->insert()
#12 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/Address.php(162): CRM_Core_DAO->save()
#13 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/Address.php(126): CRM_Core_BAO_Address::add((Array:7), TRUE)
#14 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/Location.php(69): CRM_Core_BAO_Address::create((Array:20), TRUE, NULL)
#15 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Contact.php(352): CRM_Core_BAO_Location::create((Array:20), TRUE)
#16 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Contact.php(1775): CRM_Contact_BAO_Contact::create((Array:20))
#17 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/Parser/Contact.php(1672): CRM_Contact_BAO_Contact::createProfileContact((Array:7), (Array:34), NULL, NULL, NULL, "Individual")
#18 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/Parser/Contact.php(680): CRM_Contact_Import_Parser_Contact->createContact((Array:7), (Array:34), "1", NULL, TRUE, "")
#19 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/Parser.php(208): CRM_Contact_Import_Parser_Contact->import("1", (Array:11), NULL)
#20 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/ImportJob.php(276): CRM_Contact_Import_Parser->run("civicrm_import_job_5cc2d02412d8a245140be9de3b68b128", (Array:8), 8, 1, "_id", "_status", "1", "70a4ed26920f64531656cc89f6582b8d", 8, NULL, 30, NULL, "")
#21 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/Form/Preview.php(282): CRM_Contact_Import_ImportJob->runImport(Object(CRM_Contact_Import_Form_Preview))
#22 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(261): CRM_Contact_Import_Form_Preview->postProcess()
#23 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#24 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Contact_Import_Form_Preview), "next", "Next")
#25 /var/www/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contact_Import_Form_Preview), "next")
#26 /var/www/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Import_Form_Preview), "next")
#27 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(339): HTML_QuickForm_Page->handle("next")
#28 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(323): CRM_Core_Controller->run((Array:3), NULL)
#29 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#30 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#31 /var/www/wp-content/plugins/civicrm/civicrm.php(470): CRM_Core_Invoke::invoke((Array:3))
#32 [internal function](): CiviCRM_For_WordPress->invoke("")
#33 /var/www/wp-includes/plugin.php(470): call_user_func_array((Array:2), (Array:1))
#34 /var/www/wp-admin/admin.php(211): do_action("toplevel_page_CiviCRM")
#35 {main}
Et voici la notice :

Code: [Select]

Code d'erreur de la base de données : Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL), 1452
Détails additionnels :
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , manual_geo_code , master_id ) VALUES ( 74 ,  2 ,  1 ,  0 ,  0 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , manual_geo_code , master_id ) VALUES ( 74 ,  2 ,  1 ,  0 ,  0 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , manual_geo_code , master_id ) VALUES ( 74 ,  2 ,  1 ,  0 ,  0 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]"]
)

Est ce que quelqu'un peut m'éclairer et me donner la marche à suivre pour pouvoir importer des contacts.

Merci énormément !

[petednz]

hi - from the land of new zealand - but we understand shakespearean - and apparently i can read French well enough to understand your post ;-)

i suggest you put this through google translate rather than have me write bad French.

Please retest your import with just a small sample of the csv.

And if that fails, can you please upload an anonymised copy of that here, as well as a screenshot of the Step 2 in the Import Wizard showing your field mapping.

hope you can decipher the above

[natinho]

Déjà merci pour votre réponse ami Néo-zélandais.

J'ai déjà essayé de mettre juste une partie de mon csv, ça ne change rien.

J'ai mis mon bout de csv en pièce jointe.

Voici un screenshot de l'étape 2 :

http://hpics.li/88535cd

Merci pour votre aide !

[mathieu]

Salut,

On dirait que l'assistant à l'importation ne valide pas plus qu'il faut, et laisse la base de données valider (avec les messages d'erreurs que l'on voit!), mais selon l'erreur, ce serait à cause du champ "Adresse principale appartient à", qui est en fait le "address_master_id", donc une référence à une autre adresse (je ne suis pas 100% sûr de ce que ça veut dire, mais c'est relié aux adresses partagées entre contacts).

Bref, il faut choisir le bon champ adresse. Ça peut varier selon la traduction, mais je pense que le champ que tu recherches s'appelle tout simplement "Rue".

Mathieu