Microsoft CRM speak!

April 11, 2007

Unable to select view columns

Filed under: MSCRM — niths @ 4:26 am

Have you experienced being unable to select columns while trying to customize a view? The solution is quite simple. Add ‘about:blank’ to Trusted Sites in Internet Explorer -> Tools -> Options -> Security ->Trusted Sites, Refresh and Voila!

HTH,
Niths

April 4, 2007

Microsoft Dynamics CRM 3.0 List Web Part

Filed under: MSCRM — niths @ 6:29 am

Here is the link to the newly released MSCRM 3.0 List web part. You can use this to display CRM data in a SharePoint dashboard.

For details visit : http://www.microsoft.com/downloads/details.aspx?FamilyId=BC9B3526-DECF-4057-A530-91840C0D5401&displaylang=en

March 22, 2007

Updating several records simultaneously

Filed under: MSCRM — niths @ 11:34 pm

There have been several questions about changing one or more values in a set of records simultaneously without having to go through the cumbersome task of opening each record and updating the value.

 There are different ways of doing this some better than the others; one of them being the best and easiest. Take your pick!

 1. Write a Javascript snippet in the form onSave to check if the current record has a particular value and if so, set it to the new value.

Simple way of doing things but the downside is that the value of the record will not be changed until it is opened and saved.

2. Write and run a simple SQL query - whilst this is an easy way of doing it, it surely isnt supported! If you do decide to go ahead with this approach, remember to take a backup of the database before running the query.

3.  Write a small program in C# or VB to update the required records. This requires you to be comfortable writing code.

 4. Save the best for last! You can use MSCRM 3.0’s very own bulk edit functionality. Run an Advanced find to look for the records that need to be updated. Select Edit from the Actions menu of the query results page. A dialog containing all the fields of the entity pops up and you can make you update here. Cool, ain’t it?!!

bulkedit.JPG

If you have any other approaches/suggestions, please leave me a comment!

Take care,
Niths

March 1, 2007

My first post!

Filed under: MSCRM — niths @ 10:54 am

Hello People! I have been thinking about getting started with my own MSCRM blog for a really long time now. And I’ve been busy doing just that – thinking about it!  

So decided to get started with it finally today. I hope to share all that i ‘know’ and my perspectives about Microsoft CRM 3.0 (and later!) through this blog. Would love to hear from you and your take on MS CRM – past, present and future!

Here’s a bit on how to set the value of a lookup:

var theentity_code = 1055;
var lookupval = crmForm.all.lookupfieldid;
var somevalues = new Array();
somevalues[0] = new
LookupControlItem(“{N248281B-0238-SV14-7K92-2451WEKK4U12}”, theentity_code,
“Somename”);

For more info, refer to : http://msdn2.microsoft.com/en-us/library/aa682067.aspx

HTH,

Niths

« Newer Posts

Blog at WordPress.com.