Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to insert a external table records into MS CRM 4.0 Entity Table RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have to insert the table data from external table (NOT RELATED with CRM ENTITY)  into crm Entity table.

    requirement:

    We have 1400 Skills in Skill Table of Resource management Entity which is not related to CRM. Now these 1400 Skills to be Updated in attribute that is created in Customized Skill Entity (CRM).  When there is any insertion of new skill Or Modification on existing skill same to be reflected in the Customized SKill Entity.

     

    Regards

    Rasheed.

     

    Monday, August 23, 2010 6:33 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes it can be done for custom entity also. It is just the case of getting the data with a dfferent status (2 updata , 3 delete etc..)

    To update you have to use service.update()

    PS: You will have to sync your Id's from both the db's and where need lookup the contact based on the contactid.


    Have a look at this blog this may be useful

    http://social.microsoft.com/Forums/en-US/crmdevelopment/thread/d1d4d458-18aa-422d-aba3-d22862c00091

    Hope this helps

    Amar

    Tuesday, August 24, 2010 12:25 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Rasheed,

    you can use MS CRM webservice in your custom application to send data in ms crm entity. you can use ms crmwebservice to update existing data in ms crm or create new data.

    refer for more information

    http://msdn.microsoft.com/en-us/library/cc151038.aspx

    Let us know if you required any other inforamtion

    Mahain : http://mahenderpal.wordpress.com
    Monday, August 23, 2010 6:52 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks.. Thru sql Procedure can we able to do that..
    Monday, August 23, 2010 7:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    CRM 4.0 does not support direct database update(not recommended),although it is possible technically but it can result into data inconsistency in your CRM.
    Mahain : http://mahenderpal.wordpress.com
    Monday, August 23, 2010 7:08 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Rasheed ,

    You can also achieve MSCRM Inserts and updates with SSIS, please see the link below

    https://community.dynamics.com/blogs/cscrmblog/comments/3407.aspx

    Hope this helps,

     

    Amar

    Monday, August 23, 2010 10:36 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    HI Amar,

     

    It works fine for Contact. Nowhere we have mentioned it is for Contact Entity. How it Updates the Contact Entity. Secondly it can be done for Custom entity also.

     

    Rasheed

    Tuesday, August 24, 2010 9:58 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes it can be done for custom entity also. It is just the case of getting the data with a dfferent status (2 updata , 3 delete etc..)

    To update you have to use service.update()

    PS: You will have to sync your Id's from both the db's and where need lookup the contact based on the contactid.


    Have a look at this blog this may be useful

    http://social.microsoft.com/Forums/en-US/crmdevelopment/thread/d1d4d458-18aa-422d-aba3-d22862c00091

    Hope this helps

    Amar

    Tuesday, August 24, 2010 12:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    If you just want to insert data into crm why do not you use Data Import functionality.

    Hope this helps.

    Thanks, Ranjitsingh R | http://mscrm-developer.blogspot.com/ | MS CRM Consultant
    Tuesday, August 24, 2010 12:32 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    HI Ranjitsingh R

    We external table is updated frequently.. So we can't go to Data Import.

     

    Rasheed

    Friday, August 27, 2010 3:37 AM