Forums

Covering OroCommerce, OroCRM, OroPlatform topics, including community updates and company announcements.

Forums OroCRM OroCRM – Programming Questions orocrm magento customer import

This topic contains 0 replies, has 1 voice, and was last updated by  gautamndsl 2 years, 11 months ago.

  • Creator
    Topic
  • #25068

    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.

You will be redirected to [title]. Would you like to continue?

Yes No
sso for www.magecore.comsso for oroinc.comsso for oroinc.desso for oroinc.frsso for marketplace.orocommerce.comsso for marketplace.orocrm.com