Welcome to MSDN Blogs Sign in | Join | Help

The Pesky Name Field on Custom Entities

When you create a new custom entity by default, it creates a field called Name that is used on lookups, etc. If you don't use the field, it can cause some headaches.  I have been using this as an area to store some information that would make searching on it much easier and automatically fill in the field. (So I don't have to type any more than necessary.)

Shad from Illinois who is a customer who contacted my about some other issues and after pointing him in the right direction for this, he shared back his code for us. :-) Thanks Shad! So in his case he has both the contact and the account linked to the custom entity.  In the OnSave area he put this code. You could put it in On Save or OnLoad or an OnChange.

var lookupItem = new Array;

var contactName = new Array;

// This will get the lookup for the attribute primarycontactid on the Account form.

lookupItem = crmForm.all.new_companynameid.DataValue;

contactName = crmForm.all.new_contactnameid.DataValue;

// If there is data in the field, show it in a series of alerts.

if (lookupItem != null)

{

   // The text value of the lookup.

   crmForm.all.new_name.DataValue = lookupItem[0].name + " - " + contactName[0].name;

crmForm.all.new_name.ForceSubmit = true;

}

else

{

crmForm.all.new_name.DataValue = contactName[0].name;

crmForm.all.new_name.ForceSubmit = true;

}

Posted by Ben Vollmer | 1 Comments

Field Events: FireOnChange

Almost two years ago, there was a tip published here about auto saving forms from a JScript OnChange event.  While poking around the SDK tonight looking for something, I found a cool nugget. You can force the OnChange event to occur for a field from the Microsoft Dynamics CRM form OnLoad event or from the OnChange event of some other field. To do this, use the FireOnChange method.

For example, you may use the following sample script:

crmForm.all.YourFieldID.FireOnChange();

You should take a peek at the SDK for some cool nuggets like this. :-)

Happy Demo'ing!

Field Events: OnChange

Posted by Ben Vollmer | 2 Comments
Filed under:

Business Data Catalog - Follow-up from Convergence

So I know that this way overdue. Way. After Convergence, I came back and went on vacation and then Beth was in the hospital for an unexpected week. There is a decent summation of the event from Brian Willson of the Microsoft Chemicals Team. http://blogs.msdn.com/chemicals/archive/2008/03/13/a-good-dynamics-crm-blog.aspx

I have since seen that Simon has posted some code on creation of MOSS Sites using Workflow. http://blogs.msdn.com/ukcrm/archive/2008/04/27/creating-sharepoint-sites-with-crm-workflow.aspx so I am not going to spend any time on that as he did a killer job documenting it.

One of the biggest areas I got a ton of questions on was the Business Data Catalog, which is a new feature introduced in Microsoft Office SharePoint Server 2007, provides an easy way to integrate business data from back-end server applications, such as Microsoft, within Office SharePoint Server 2007 without writing any code. This link contains overview information and step-by-step, how-to procedures for programming with the Business Data Catalog.

SharePoint Server 2007 ships with four out-of-the-box Business Data Web Parts: Business Data List, Business Data Items, Business Data Related List, and Business Data Actions. These Web Parts rely on the Business Data Catalog, and their main purpose is to display business data in a portal application without the need for any programming. Moreover, these Web Parts are generic and can show any type of data (entity) registered in the Business Data Catalog.

These Web Parts support Web Part Connections, which enable Master-Detail types of data display – again, without any programming. For example, you can display customers and their details using the BusinessDataList and BusinessDataItems Web Parts. (An Awesome overview of BDC can be found here.)

Hand writing the BDC Definitions can mentally taxing. A cool tool to do this for you is: BDC Meta Man. http://www.bdcmetaman.com/Pages/microsoftpage.aspx

If you want to practice your skills before trying them on a client, you may want to check out the Virtual Labs, where  you will learn how to build the metadata file that will connect SharePoint Server 2007 to the SQL Server 2005 AdventureWorksDW database. You will also learn how to register the AdventureWorksDW metadata file with SharePoint Server 2007. http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032331910&EventCategory=3&culture=en-US&CountryCode=US

A Nice Step by Step as published by Rehman Gul is located here.

Attached is a sample BDC you can use to Demo.

Posted by Ben Vollmer | 1 Comments
Attachment(s): bds-crmdb.zip

Creating Phone Calls from Cases

One of the most often complaints I have heard is that CRM is sometimes too "Window" happy. In 4.0 the product team made some huge strides to make it less clicky. And they gave us some REALLY cool tools to do some of it ourselves.  The new Workflow as a part of 4.0 is pretty cool. One of my partners, IBIS, did a demo last month were we used the Lead Record for everything and then used Workflow to create Contacts, Accounts and Opportunities as well as some additional activities. And then based upon the outcome of the activities, the parent entities were updated.

But today we are going to do this on a little easier scale. :-) One of the things most customer service managers want is for their folks to be heads down typing in notes and not having two windows up with the information in it. So we designed a workflow that allows them to put their notes into one field and then when they save the case, it automatically creates and closes a phone call record. It could be more complicated, but this is for demos, remember? :-)

So the first thing I do is create a Attribute called Case Notes

image

Drop that on the main form:

image

Now we save and close the form and publish our customizations. Now we head down to the Workflow area:

I created a Workflow called Case Notes and selected that it fire when the Case notes Field Changes.

image

Now I created a Phone Call Entity

image

Using Dynamic Values, we updated all of the fields to reflect the changes necessary.

image

You now add a step called Change Record Status. And Select the phone call you just entered. Now when you Save and Close a Case, it will automatically update.

image

So for a CSR, all the have to do is type in their notes on the Case Notes Area.

image

You can see it automatically dropped off my notes in an activity:

image

image

There is still a little clean up necessary to make this ready for production. I would want to go out and clean out the notes area at the end of every cycle, etc. But this should give you a good idea of how to leverage the power of CRM's workflow to make the application meet your client's requirements.

Special thanks to Randal and Bill over at CRMOntarget.com for the demo environment. We are sharing CRM Online instances for now and I wanted to play in a stand alone SandBox. And these guys hooked me up with a place to play without hurting any one. :-)

Happy Demo'ing!

Posted by Ben Vollmer | 1 Comments
Attachment(s): PhoneCallWF.zip

Upgrading from 90 Day Trial to Production Keys and having issues?

My basic rule of thumb is that if I get emailed twice about an issue, I blog about it. :-) So here is the blog post. :-)

The basic scenario is this. The customer or partner downloads Microsoft CRM 90 Day Trail Keys from here. And then they select the Enterprise Keys, because it is a trial.  The part that they forget to read is here:

Important: Please be aware that you can apply a license key only for a similar or a more advanced version of Microsoft Dynamics CRM 4.0. You cannot downgrade a full or trial version of the product. For example, if you apply the Microsoft Dynamics CRM 4.0 Professional trial license key, you can later upgrade to either the full Professional or the full Enterprise version by applying the appropriate license key. However, you cannot downgrade the installation by applying a Microsoft Dynamics CRM 4.0 Workgroup Server license key. Similarly, if you apply the Microsoft Dynamics CRM 4.0 Enterprise trial license key, you can later upgrade to only the full Enterprise version.

And then when the go to apply a Professional Key to an Enterprise Trail version, they get this error message.

Invalid License Key

There is no magic potion to fix this.  But our friends in support have created a great KB article on how to fix it easily. :-) http://support.microsoft.com/kb/947272/en-us

While I realize everybody may want to just drop the key in and run, this solution beats redoing everything from scratch. And you won't lose any data from using this KB article.

An even better solution would be installing just the Professional Edition unless you MUST use Enterprise. :)

Posted by Ben Vollmer | 1 Comments
Filed under:

Demo Tips: Patch Tuesday!

So this should be a Demo 101 tip. If you are running your demos in a virtual environment like I do, make sure that your host machine gets all of it's patches BEFORE you launch your virtual machine in full screen. (What is Patch Tuesday?)

Last week for the CRM Launch in Reston, which was held on a Wednesday, my Laptop grabbed a Wireless network and during my demo it downloaded all of the Windows Vista hot fixes to the host machine while I was running in full screen.

Which meant that about 3/4 the way through my demo, the host machine rebooted. (Because all of the patches downloaded and applied themselves in the background.)

Thankfully Andrew was in the back of the room with a fully functioning CRM Online Demo Machine prepped ready to give demos after the session was over.  Upon asking him nicely, he brought the machine to the front of the room and the demo continued.

To me that shows that A.) I should turn off WiFi before my demos and B.) We have a KILLER platform. Why? It it allowed me to seamlessly jump from On Premise to Hosted within minutes.

But from now on, I will be pay very close attention to what day of the week my demo is on and the current status of my machine's updates. :-)

Posted by Ben Vollmer | 3 Comments

HotFixes Part Deux - During Installation

One of the coolest parts around CRM's setup is the ability for the setup program to automatically update CRM to the latest edition with all of the HotFixes that have been published.

When you install Microsoft Dynamics CRM 4.0, or when you upgrade to Microsoft Dynamics CRM 4.0, you can check for setup updates. If you select the option to check for setup updates, the application downloads any new setup updates and applies them to the installation while the setup process is running.

This article covers the HotFixes and how to get them if you don't have Internet access during setup.

As with this and the other article, the article updates may trail the actual releases of the HotFixes.

Happy Installing!!!

How to obtain the setup updates for Microsoft Dynamics CRM 4.0

Posted by Ben Vollmer | 1 Comments
Filed under: ,

Updating CRM data from Excel.

One of the things my customers LOVE about CRM is the ability to dynamically link CRM to Excel Spreadsheets. The next question is normally if I can update CRM from Excel.

One of my local partners, Prosoft Systems Intl, wrote a cool application based in Excel enables bi-directional updating to CRM.  The preview version is wired to the Opportunities entity only, but in the future I expect them to enable this for all Entities.  Frank would love your feedback on the product and said he will be posting weekly updates until the product is finalized.  Some of the cool things include the ability to work with the CRM data in Excel while not connected to a CRM server.  They will also be announcing a partner program soon. 

 

For more information:  http://www.mscrmexcel.com/products.htm

You can download the preview at: http://www.mscrmexcel.com/downloads.htm

Posted by Ben Vollmer | 3 Comments
Filed under:

Nominate your solution for a Microsoft global award!

Each year, via its Worldwide Partner Conference Awards program, Microsoft recognizes partners who have delivered exemplary solutions built on Microsoft technologies. Awards are presented to winning partners at the Microsoft Worldwide Partner Conference, this year in Houston, Texas, USA July 7-10, 2008.

This is a unique opportunity for you to showcase your solutions. Award winners and finalists benefit from increased press coverage, and market recognition that may drive new business opportunities.

Award categories are aligned with Microsoft Competencies and specializations. Make sure your Competency enrollment is active, then nominate your solution before April 3, 2008. The entry tool and detailed information about the Awards program can be found here.

Posted by Ben Vollmer | 1 Comments
Filed under:

Customer Service Example - AWESOME Job by c360 and MSCRM-Addons.com

So often, all I ever hear about from Partners is horror stories about dealing with other partner. I never seem to hear about the good things that happen. This is a story about something VERY good a partner did for another partner and Microsoft.

I was recently on a customer call with a partner in North Carolina. While prepping for the demo, we looked at the Group Calendar Add-on to meet some of the requirements. It could meet some, but not all of their requirements. One of their largest requirements was to look at a calendar based upon a selected office. (And this was on Wednesday afternoon) (So I could see everybody in the Charlotte Office and figure out who should take this prospect visit.)

Arvind over at c360 coordinated with Christian from mscrm-addons.com and by Monday, we had a fully functioning piece of software that did EXACTLY what our client was looking for and they even updated all of the software and published a KB article on the functionality.

http://support.mscrm-addons.com/Default.aspx?kb=10626

My hat is off to c360 and mscrm-addons.com for pulling this off. This was by far the most responsive I have EVER seen an ISV be to incorporating changes into their software.

New Tool Available - Change Service Job Times in CRM 4.0

Sean from the support group just let me know that there is a new tool to help customers out. In 3.0, I used to just stop the Deletion Service. With this tool, you can change the DeletionService and Re-Indexing service jobs in CRM 4.0. You can set the next run date/time of a job as well as change the schedule at which the job will continue to run automatically.

There is some issue tracking and more details here at the link!

Thanks Sean!

CRM 4 ScaleGroup Job Editor - Home

Posted by Ben Vollmer | 2 Comments
Filed under:

Hotfixes for Microsoft Dynamics CRM 4.0 - Where are they?

If you're anything like me, you fight an issue for about four hours, throw your keyboard across the server room and finally give in and call Tech Support. And in about three minutes, the tech, says, ohh, yeah, that is a known issue. Have you applied HotFix XXXXX? And then at that point, I generally want to scream again. Why, because I could have saved about four hours of time if I knew a Hot Fix existed.

Well our friends in Tech Support have a SINGLE KB article that lists the currently available HotFixes for CRM 4.0. You can click here to see if your issue is currently resolved by a HotFix. You will need to have a PartnerSource login of course.

NOT Every installation needs to have a hotfix. A hotfix is intended to correct only the problem that is discussed in an associated Microsoft Knowledge Base article. (So if you don't have the problem, you don't need the HotFix.)  To obtain a hotfix, you will need to open a support incident and they will provide the HotFix to you if it is indeed the problem. 

Happy Consulting!

Posted by Ben Vollmer | 11 Comments
Filed under:

Microsoft Dynamics CRM 4.0 Tech Articles Posted...

Thanks Amy for sharing...

Introduction to Plug-in Development for Microsoft Dynamics CRM 4.0

Discover how you can customize and extend Microsoft Dynamics CRM 4.0 through the integration of custom business logic. Read this article to get an overview of the new plug-in capability, see a comparison of plug-ins to callouts, and learn about the new plug-in programming model.

Introduction to Data Management Features in the Microsoft Dynamics CRM 4.0 SDK

Use the Microsoft Dynamics CRM SDK to work with Bulk Delete, Duplicate Detection, and Data Migration/Import. This article introduces these features, new in  Microsoft Dynamics CRM 4, and shows you how they can help you to improve the way you manage and maintain the quality of data in your system.

Extensibility Features Live vs. On-Premise in Microsoft Dynamics CRM 4.0

Are you wondering which extensibility features work across our different products? This article provides the answers!

Posted by Ben Vollmer | 0 Comments
Filed under:

Microsoft CRM Sitemap Surgery Tips

Joel over on the Customer Effective Blog has some great tips on editing the SiteMap. Having cut my teeth on it in 3.0, it is nice to have some of these little tricks.  Of course using the demonstration tool has made much of this easier for me now. ;-) (You can download the tool here.

 

Head on over to Customer Effective's Blog to learn more!

Customer Effective Blog: Microsoft CRM Sitemap Surgery Tips

Posted by Ben Vollmer | 2 Comments
Filed under:

CRM 4.0 - Where do I get those License Keys again?

We have so many great people on the CRM team around the world that I spend a fair amount of time reading their blogs to keep up with all the little issues, details and factoids that affect CRM partners and customers.  One recent issue that has been making the rounds is surrounding where to get your license keys.  Fortunately, Simon Hutson from the UK has recently published a concise and thorough rundown of where to get keys for just about any scenario.  Thanks, Simon!

http://blogs.msdn.com/ukcrm/archive/2008/01/14/where-is-your-crm-4-0-license-key.aspx

Posted by chris.kahl | 3 Comments
More Posts Next page »
 
Page view tracker