Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Set CreatedBy during data import

Posted on by 3,070

Hi all,

I have a requirement to set the CreatedBy and CreatedOn of some records during a data import.  We have data in an old system that we'd like to import to CRM, but we'd like to maintain the CreatedBy and CreatedOn of those records. 

Is there an easy way to achieve this that doesn't involve plugins?

Thanks,

Ryan

*This post is locked for comments

  • Verified answer
    Ryan Maclean Profile Picture
    Ryan Maclean 3,070 on at
    RE: Set CreatedBy during data import

    Hi Alex,

    I did see that solution, but I didn't manage to test it because it is only for v8.2 or greater

    I only had 15 records to import, so I imported them, then created a workflow to copy them in the context of the workflow owner, and set the owner to be the intended owner of each record in turn.

    This was an incredibly inefficient process, but for my purposes it worked.  It's so frustrating that there are no simple options available to set this information on creation/import of a record.  

    Cheers,

    Ryan

  • Verified answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: Set CreatedBy during data import

    This is something I'm never 100% sure about.. It seems it was done here:

    community.dynamics.com/.../migrating-importing-data-and-maintaining-created-by-modified-by-and-modified-on

    The idea is that you need to set another user lookup (custom field) to the correct createdby, and, then, use a pre-create plugin to copy the value from that custom field to the out of the box createdby (directly in the target, without calling any additional updates from that plugin)

  • Suggested answer
    Michel Gueli Profile Picture
    Michel Gueli 982 on at
    RE: Set CreatedBy during data import

    It's not possible to set the created by field through code.

  • Ryan Maclean Profile Picture
    Ryan Maclean 3,070 on at
    RE: Set CreatedBy during data import

    Hi Michel,

    I've seen both of these in my searching, but neither of them explain how to set the Created By field

  • Michel Gueli Profile Picture
    Michel Gueli 982 on at

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans