Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to import createdby, modifiedby, createdon modifiedon to account, contact etc? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi!

    I'm migrating information from an old sales system into Microsoft Dynamics CRM 4.0. I would like to complement almost every entity with some history e.g. created/modified by, created/modified (date). The information from the old system is stored in a Microsoft SQL Server environment.

    My problem is that I can't reach these four fields, and I don't know why. However, the field "overriddencreatedon" is of some help. That fields is accessible externally and overrides the createdon-field which takes me one step closer to a solution - atleast for that field. But for the rest of the fields: createdby, modifiedon, modifiedby, I can't find a way to do this..

    Anybody out there who has any input on how to do this?


    Tuesday, December 2, 2008 10:18 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi again!

    I found myself some useful information over at msdn regarding this issue of mine: http://msdn.microsoft.com/en-us/library/cc150987.aspx
    It says:
    "You cannot migrate data into the modifiedon, createdby, and modifiedby attributes. If you have to store data related to who modified the data and when it was modified, you can create custom attributes in Microsoft Dynamics CRM and map the source columns to the new custom attributes."

    So, I guess that is what I have to do if I want to migrate these fields.
    Tuesday, December 2, 2008 11:49 AM