CRM 2011: Migrating from Salesforce to CRM 2011 RRS feed

  • Question

  • We are having a little issue on importing the Products and the Price list from Salesforce to CRM 2011. My coworker is using SSIS to import the data. What is the easiest way to do this?

    She is getting an error right now entering in the Products.

    Error Code: -2147206390, Detail Message: The unit schedule id is missing, she is thinking she needs to pass default unit for each product.

    We are also having a hard time importing cases as well.

    Monday, March 16, 2015 3:52 PM

All replies

  • CRM has some weird restrictions and required fields for the Product entity.  

    In your instance, you'll have to set the defaults for 'Unit Group' and 'Default Unit' on the Product as you are importing it.  I believe there are records created for each of these out of the box, but you'll have to get the ID's for them so you can import the products.  Check in Settings, Product Catalog and you should see Unit Groups there.

    Hope this helps!

    Tuesday, March 17, 2015 1:52 PM