ssossossosso

Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

This topic contains 0 replies, has 1 voice, and was last updated by  gautamndsl 1 year, 9 months ago.

  • Creator
    Topic
  • #15188

    gautamndsl
    Participant

    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 -v

    Run 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]
    Completed

    Regards
    Gautam

You must be logged in to reply to this topic.