Microsoft CRM - Bulk Edit Made Easy

I was recently reading the Microsoft CRM Development Team blog when I saw a post by Ilana Smith called "Feature Spotlight: Bulk Edit".  I have to admit - I was confused when CRM 3.0 RTM code was released because I "thought" the bulk edit feature was a part of earlier builds of CRM 3.0 and it appeared to have disappeared.  Even though I have spent thousands of hours (literally) with CRM 3.0 I had not stumbled upon the bulk edit feature discussed in this blog (shame on me).

We had been using CRM Workflow to create manual rules to bulk update records.  This process works well but it does require that you have access to the CRM Workflow Manager (not usually granted to typical CRM users).  The Bulk Edit feature of CRM 3.0 is very simple to use yet very functional. 

Example: Update Contact Profile Information using Contact Views

Select appropriate records and choose "More Actions - Edit"

Update the appropriate attributes and click "Save"

 

Example: Update Contact Profile using Advanced Find

 

If there was one wish I would like to see come true it would be to have the ability to perform in-line edits with CRM.  I could see this working within the data view grids.  Maybe it would be a feature that is turned off by default but you could click a button to allow in-line editing.  This would allow a user to quickly update many records (with different data) while not having to open each record independently.  Maybe CRM 5.0 will include this feature.  :-)

Thanks to Ilana Smith of the Microsoft CRM Development Team for pointing out this feature of CRM 3.0!  This is one of those features that seems pretty basic but yet provides a lot of business value.

:: Ryan ::

Published Friday, July 28, 2006 6:31 AM by Ryan Toenies

Comments

# re: Microsoft CRM - Bulk Edit Made Easy

Hey Ryan

It's embarrassing for me that people don't find Bulk Edit - I certainly screwed up there.  I think it's a combination of bad naming ("Edit" doesn't immediately make one think of "bulk edit") and undiscoverability on the More Actions menu.  Definitely some lessons to learn there.  (It reminds me that in 1.x, many users didn't find the Actions menu at all, which certainly hampered the ability to use the product.)

Ironically, in-line edits was a feature we had in early builds on 3.0 and took out later.  It's actually a really tough thing to do well.  Maybe some other release...

It was great to see you at WPC,
Ilana.

Friday, July 28, 2006 1:12 PM by IlanaSmith

# re: Microsoft CRM - Bulk Edit Made Easy

Ilana,

Don't beat yourself up too bad - the feature is indeed part of 3.0 and works very well.  Now that we know it's there we are singing the praises to all of our customers (not to mention how much we use it internally).  :-)

Great to hear from you!

:: Ryan ::

Saturday, July 29, 2006 8:08 AM by Ryan Toenies

# re: Microsoft CRM - Bulk Edit Made Easy

Would be nice to do the bulk edit for products.  I have a huge list of products provided by a particular vendor that I can get from advanced find, but can't bulk edit :-(

Wednesday, April 09, 2008 3:49 PM by Katie Warner

# re: Microsoft CRM - Bulk Edit Made Easy

Hi,

Why can't I edit the Company (parentcustomerid) field in Contacts, which is a Lookup field.

Why can't I edit any lookup fields using bulk edit?

These fields are grey out

Tuesday, April 22, 2008 1:30 PM by bahram aziz

# re: Microsoft CRM - Bulk Edit Made Easy

Any way to "bulk edit" the owner of prospects? The owner field is disabled on the bulk edit form....

..We are looking to import prospects in bulk and then re-assign them to various individuals. Any other known way to do this?

Hmm...

Tuesday, April 22, 2008 4:08 PM by gc

Leave a Comment

(required) 
(required) 
(optional)
(required)