Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


The Curious Case of the Import Data Wizard

Post Author: Joe D365 |

In Microsoft Dynamics CRM 3.0 there existed an option to update records when using the built-in Import Data Wizard. This was an extremely useful feature; we could export thousands of rows to Excel directly from CRM, update the information using Excel tools (such as Find and Replace), and then import this enriched data back into CRM. This would update our existing records rather than creating entirely new records.

This feature was in the beta versions of CRM 4.0, but when final release came around, this feature was nowhere to be found; a victim of the final cut. It was a perplexing ommision, as all documentation and help files related to the Import Data Wizard mentioned the ability to update rather than create new. The Data Import Wizard could now only be used to create new records, which made any type of bulk update a near impossible task. Sure, there were some 3rd party products available for purchase that could handle this task, but who would want to pay for something that was a free feature in previous versions? Needless to say, there were some folks who were a bit upset at the omission of this great feature.

Microsoft had a surprise in store for Joe and Jane CRMs across the world when a recent CRM 4.0 product update included the return of the 'enrich data by updating records rather than creating new records' option within the Data Import Wizard!

Need assistance with a data import project? Want to bring focus to your Dynamics CRM? Contact Us Today and find out what PowerObjects can do for you!

 

 

Welcome to the #1 Dynamics CRM Partner in the World

Proud winner of the 2015 Microsoft Partner of the Year for Cloud Customer Relationship Management, PowerObjects is the preferred partner for implementing, supporting, and growing CRM solutions. Through unparalleled offerings of service, support, education, and add-ons, PowerObjects can help tailor custom solutions for your business.

How Can We Help You Today?

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

4 comments on “The Curious Case of the Import Data Wizard”

  1. I read your article "The Curious Case of the Import Data Wizard".

    What was the recent CRM 4.0 product update? I have searched on PartnerSource for Microsoft Dynamics CRM 4.0 updates and hotfixes and do not find anything related.

    Thanks

PowerObjects Recommends