web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to BULK copy one c...
Microsoft Dynamics CRM (Archived)

How to BULK copy one custom field to another field - Same entity

(0) ShareShare
ReportReport
Posted on by Gravelpit 50

We have migrated our data from sales force and we had a plugin that stored a field on every record. approx 1.4m contact records.

We need to copy this field to another field that a plugin installed.

Can anyone help on how we can copy a very simple field on the same entity to another field.

We cannot: edit the managed field and need to do mass update.

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 21 on at
    RE: How to BULK copy one custom field to another field - Same entity

    Although you can export your records to excel and copy the column values before re-importing, for over a million records this isn't practical. The most effective option would be to commission a script that does this using the SDK. It would retrieve the records I batches and update one at a time. See msdn.microsoft.com/.../gg309282.aspx

    Another option would be to use KingswaySofts SSIS toolkit if you have the skills - this is free for a single developer one off update.  See www.kingswaysoft.com/.../ssis-integration-toolkit-for-microsoft-dynamics-crm

    Hope this helps,

    Scott

  • Gravelpit Profile Picture
    Gravelpit 50 on at
    RE: How to BULK copy one custom field to another field - Same entity

    Hi Scott

    My technical experience is limited when it comes to items such as SSIS and scripting will not be possible.

    I have scribe running, but the update is extremely slow. I have a CRM 2013 to CRM 2013 connector that simply copy's the field from one to another.

    But it is processing at an extremely slow rate of about 130k records every 24 hours. i tried batch processing on 2000 records, then lowered to 1000 and then to 500 and it seems to match the same speed. I even did 80 at one point but the same result.

    I think Dynamics is throttling me. Do you have any suggestion on batch process through put? Everywhere online people are getting millions of records through with far more complex inserts, updates etc.

    This task should be a no brainer, thus why i am turning to find a solution within Dynamics itself, such as a workflow. Although that worries me as it might kick off 1.4m workflows!!

    Thanks

  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 21 on at
    RE: How to BULK copy one custom field to another field - Same entity

    Right - I wouldn't use workflows either since this will take even longer than Scribe.

    If you are finding that you have a low throughput with Scribe - check if you have any other workflows or plugins that are registered on the contact entity - try disabling them temporarily to see if that helps. Throughput is throttled yes, but you should be getting much more than 1.5 records a second!

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

#3
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans