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

  • Question

  • 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


  • 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 modifiedoncreatedby, 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