This topic contains 0 replies, has 1 voice, and was last updated by gautamndsl 8 years, 4 months ago.
- Topic
Hi,
I have been trying to import magento customer over api. connection has been established and i can import order info.i am using console to import customer
$php app/console oro:cron:integration:sync –integration-id=2 -vRun sync for “apps.ndsl” integration.
Start processing “website_dictionary” connector
Stats: read [2], processed [2], updated [2], added [0], deleted [0], invalid entities: [0]
Start processing “store_dictionary” connector
[Warning] Attempt number 1 with 5 sec delay.
Stats: read [2], processed [2], updated [2], added [0], deleted [0], invalid entities: [0]
Start processing “customer_group_dictionary” connector
Stats: read [5], processed [5], updated [5], added [0], deleted [0], invalid entities: [0]
Start processing “region_dictionary” connector
Regions are up to date, last sync date is Mon, 07 Dec 2015 11:30:52 +0000, interval is 1 day
Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
Scheduling initial synchronization
Start processing “customer” connector
Looking for batch
found 1 entities
Loading Customer by id:: 7
Looking for batch
found 0 entities
An exception occurred while executing ‘INSERT INTO orocrm_magento_customer (name_prefix, first_name, middle_name, last_name, name_suffix, gender, birthday, email, created_at, updated_at, created_in, is_confirmed, is_guest, is_active, vat, lifetime, currency, sync_state, password, origin_id, rfm_recency, rfm_frequency, rfm_monetary, website_id, store_id, customer_group_id, contact_id, account_id, user_owner_id, organization_id, channel_id, data_channel_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“Mr”, “lala”, null, “mahadev”, null, null, null, “rajmalvi@hmail.com”, “2015-12-02 05:38:14”, “2015-12-02 11:08:14”, “Default Store View”, 1, 0, 0, null, 0, “INR”, null, null, 7, null, null, null, 4, 4, 6, null, null, 1, 1, 2, 2]:SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘7-2’ for key ‘magecustomer_oid_cid_unq’
Following customers were not imported: 7
Loading Customer info by id: 7
Stats: read [1], processed [2], updated [0], added [2], deleted [0], invalid entities: [1]
Errors were occurred:
Post processing job “mage_customer_load_customer_info_2015_12_07_17_10_20_566570240fd680_18101391” failed. Job id “2171”. Errors: An exception occurred while executing ‘INSERT INTO orocrm_magento_customer (name_prefix, first_name, middle_name, last_name, name_suffix, gender, birthday, email, created_at, updated_at, created_in, is_confirmed, is_guest, is_active, vat, lifetime, currency, sync_state, password, origin_id, rfm_recency, rfm_frequency, rfm_monetary, website_id, store_id, customer_group_id, contact_id, account_id, user_owner_id, organization_id, channel_id, data_channel_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“Mr”, “lala”, null, “mahadev”, null, null, null, “rajmalvi@hmail.com”, “2015-12-02 05:38:14”, “2015-12-02 11:08:14”, “Default Store View”, 1, 0, 0, null, 0, “INR”, null, null, 7, null, null, null, 4, 4, 6, null, null, 1, 1, 2, 2]:SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘7-2’ for key ‘magecustomer_oid_cid_unq’
Start processing “order” connector
Looking for batch
found 1 entities
Loading Order by id: 88
Looking for batch
[Warning] Attempt number 1 with 5 sec delay.
found 0 entities
Loading Order info by incrementId: 100000078
[Warning] Attempt number 1 with 5 sec delay.
Stats: read [1], processed [2], updated [2], added [0], deleted [0], invalid entities: [0]
CompletedRegards
Gautam
The forum ‘OroCRM – Programming Questions’ is closed to new topics and replies.