CRM 4 ScaleGroup Job Editor

As we are facing some DELETIONSTATECODE issues regarding Contacts and Leads we have been googling for a solution. Marco found this useful CRM 4 ScaleGroup Job Editor utility.

"This utility is used to 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. " as you can red here.

This utility works but it didn't solve our issues... And the search for a solution continues as we also try to better frame the issue.

Marketing Campaign Offer Limitation Workaround

In my previous post I told you about the Marketing Campaign OFFER (objective) limitation of 2000 characters. That's a very short amount of characters specially if you want to send HTML e-mail materials! This system attribute/field can't be changed like regular (non-system) attributes/fields. But Jim Wang found a way to change it! Thank you Jim Wang for this precious yet simple workaround:

1. Export the Campaign Activity entity;


2. Edit the "customization.xml" file (look for attribute/field "objective" and change length to up 100.000 characters);


3. Import the "customization.xml" to your CRM;


4. Publish your customization (just to make sure!).

This workaround may be unsupported but according to Jim Wang it's pretty safe. I hope Microsoft reviews this 2000 characters limitation and/or the ability to change it.

Virtualization Support for Microsoft Dynamics CRM 4.0

Menno te Koppele's blog called my attention to this: "Microsoft Dynamics CRM 4.0 is officially supported to run on a computer that is running Microsoft Virtual Server 2005 in production systems.". You can read Menno's post here and Microsoft's related KB here.

This is great because I'm actually deploying my MS CRM Dynamics 4.0 development environment on a Virtual Server 2005 and I want to follow this approach for my production environment.

However be aware of the following "Microsoft does not test or support Microsoft software on a computer that is running non-Microsoft hardware virtualization software. ".

Marketing Campaign Offer Limited to 2000 characters

On a previous post I explained How to send HTML marketing e-mails. What I didn't know at the time was that the OFFER field is limited to 2000 characters! First I didn't panic because I thought I could change it... But now I'm very worried because I can't change this system attribute/field!



If your HTML exceeds 2000 characters it will be truncated!

It isn't very difficult to write HTML pages with more than 2000 characters, specially if you have to include a lot of long links as I have to.

Suggestions how to hack this 2000 characters limit?

MS Dynamics CRM 4.0 Implementation Guide Refreshed

Miscrosoft released a new version (4.1.0) of the Implementation Guide (IG). You should get it here. The IG consists of the Planning Guide, Planning Tools, Installation Guide and Operating and Maintaining Guide. I'm printing it as we speak.

Travel Distribution Summit Europe'08 here I go!

It's official: I'm going to the Travel Distribution Summit Europe'08! I finally got the green light and I already booked hotel and flight. I will be attending mainly the CRM and Loyalty Strategies Conference. The conference/summit will take place at London's Business Design Centre between May 20-21 2008. If you are also attending this conference drop me a line.

How to hide buttons in MS CRM 4.0 in runtime

I googled about hiding buttons in MS CRM 4.0 and I was sent to this brilliant post from David Fronk from Dynamic Methods Inc.. Applying his script to the entity's form through the onLoad event I was able to hide permanently a button. However I was looking for more!

I wanted to hide a button only if a specific field was filled. And how did I pull this one off? Simple! Just added the piece of code to the field's onChange event! It's important to keep the code in the onLoad event if you want to keep the button hidden when you save and close your entity and then reopen it.

How to send HTML marketing e-mails

If you don't know exactly how to send HTML marketing e-mails I must warn you that it's really easy if you have basic HTML knowledge. Forget about MS CRM for a minute, write your own HTML code as you would if you were developing a webpage.

Then just copy and paste your HTML code into the field OFFER (Campaign) and then create a new campaign activity, select E-mail as your CHANNEL and then hit Distribute Campaign Activity. You should get something similar to this.

If you feel comfortable with HTML you can write your HTML code directly into the OFFER field as I did. If you want to include images don't forget to make them available through a public web folder. In this example I used the Google logo.

As you may also have noticed I hard coded the UNSUBSCRIBE e-mail address link. There is an explanation for that. Normally one would simply write a regular unsubscribe text and then select that text and hit the UNSUBSCRIBE button available when seting up the new e-mail activity. However if you set the FROM field to a Queue (as I did) your unsubscribe e-mail link will be broken to "mailto:[Run_Time_Address]?subject=[Run_Time_Subject]". After a lot of testing I gave up of this feature and decided to hard code the unsubscribe text/link. Doing this I'm also sure to include the unsubscribe text/link. I should warn you that the unsubscribe e-mail To should be the Queue's e-mail and the subject should be "UNSUBSCRIBE: E-mail Activity Subject". It's very important to match the UNSUBSCRIBE subject with the e-mail activity subject or the CRM won't be able to connect the unsubscribe request with the campaign in order to automatically create a campaign response and set sender's Send Marketing Materials = NO.

I will write a specific post about How to send e-mail campaigns from queues because I have some useful tips and tricks for you.

How to Send E-mails from Queues

It's really very simple, just hit the lookup button after creating a new e-mail and change LOOK FOR "User" to "Queue". Then hit send and off you go. Don't forget you need the right CRM permissions for this (queues and send e-mail on behalf of).

Duplicate Detection Rule Detects Phantom Contacts

I'm running a simple duplicate detection rule for contacs with the same e-mail address. I'm getting phantom duplicates: I get a duplicate (top list) but no potential duplicate record (bottom list). Instead of the bottom list I get this warning "Potential duplicate records: None". The image below shows a phantom duplicate: the selected active record has "Potential duplicate records: None".

After some investigation I realized that there was a previously deleted record (2 days ago) with the same e-mail. The deleted record exists only in the MS CRM DB and its DeletionStateCode equals 2! However my duplicate detection rule still sees him. I believe it shouldn't!

MSCRMAsyncService which as I read is supposed to handle the deletion of records ir running but doesn't delete anything... Very very strange!

I made a post about it at Microsoft Dynamics' Forums.

MS Dynamics CRM 4.0 Diagnostic Tool

Benjamin Lecoq has released the CrmDiagTool for CRM 4.0. You should read his post about it and download it from the link he provides.

By the way if you wish to enable tracing for MS Dynamics CRM 4.0 you should check the following KB article: http://support.microsoft.com/kb/907490.

Facility/Equipment Import Wizard Issue

Whenever I try to import facility/equipment entities using the import wizard I get an error related with a missing column/attribute: "unmapped required columns: 1" (image below).



The missing column/attribute name is Calendar and the Reason states the following: "Error: unmapped mandatory column" (imagem below).

The "Calendar" attribute (image below) is a system required attribute of the Facility/Equipment entity and its description is the following: "Fiscal calendar associated with the facility/equipment.".

I haven't set my Fiscal Calendar yet because I read at the Implementation Guide that one can do it only once and in order to work with Sales Quota. I'm guessing I don't need to set it for now because when I mannually create a Facility/Equipment I don't get any kind of Fiscal calendar related error. I'm guessing I have to bypass this issue some how... I will post this at Dynamics Forums, perhaps someone already has been over this.

Travel Distribution Summit Europe'08

If you're in the travel/hospitality industry this is perhaps THE EVENT you can't miss. This event is composed by the Online Travel Strategies Conference, Revenue and Pricing Strategies Conference and CRM and Loyalty Strategies Conference. Click here to get an overview of the event and here toget and overview of the CRM and Loyalty Strategies Conference. Although all the conferences are appealing this last one is the one I'd like to attend. I'm waiting for clearance...

c360 Import Manager for Microsoft Dynamics CRM 4.0

I have tried c360 Import Manager for Microsoft Dynamics CRM 4.0 and my feedback is positive. It works as it should and enables me to import, update and delete data in all standard and customized entities from my operational systems. It's quite simple to set up and use and I think it's worth the money if you're not comfortable regarding the use of CrmService or if you do not wish to develop code to perform imports, updates and deletes.

c360 has a more interesting products for MS CRM 4.0 such as c360 Event Management, c360 Field Level Security or even c360 Customer Portal but I haven't had the chance to test them.

Fix Date and Birthdate/Birthday (for MS CRM 4.0 CrmService)

If you are using CrmService's Create or Update methods perhaps you already noticed that when you send a date in the DD-MM-YYYY HH:MM:SS format CrmService will read this date as MM-DD-YYYY HH:MM:SS and that's what he'll write to your MSCRM db.

So if you're writing a contact's birthdate/birthday like "24-07-1980 00:00:00" CRM will throw an exception because he's using "24" as MM and "07" as DD when he shouldn't. You need a workaround such as your own fixDate() method. The following fixDate() method was created by Marco Silva, member of my MS CRM Dynamics 4.0 project team of two (me and him). This method gets something like "24-07-1980 00:00:00" and returns it in a CRM friendly format "07-24-1980 21:00:00". If you check your MS CRM db you will see the correct date but perhaps not the correct time "24-07-1980 20:00:00".

private static string fixDate(String date)
{
string day = data.Substring(0, 2);
string month = data.Substring(3, 2);
string year = data.Substring(6, 4);
string hour = "21";
string min = "00";
string sec = "00";
return month + "-" + day + "-" + year + " " + hour + ":" + min + ":" + sec;
}

You may notice that we're forcing the hour, minutes and seconds and there's a pretty good explanation for that. The explanation is related with Time Zone handling issues that affect MS CRM 4 (and 3). My time zone settings (MS CRM server, SQL server, desktop) are all GMT (...Lisbon). Some specific datetimes (not all) are written to MS CRM DB with less an hour and that makes them go back one day.

If you send "24-07-1980 00:00:00" or "07-24-1980 00:00:00" to be more accurate to your CrmService it will write "23-07-1990 23:00:00" to MS CRM db! Ooops! Wrong birthdate! However if you check your contact's file you will see "24-07-1980". However the MS CRM db birthdate datetime is wrong ("23-07-1990 23:00:00") and you can't export it to an external db such as a datawarehouse. The workaround for this one requires two different approaches: a CrmService approach and an onSave approach (to fix typed birthdates).

Both of these workarounds require you to change birthdate's time to something bigger than "01:00:00" because if the CrmService "steals" you one hour it won't "steal" you a whole day! I chose to set "21:00:00" as my "fake" time. So, if I send this CrmService friendly "fake" date "07-24-1980 21:00:00" to CrmService he will write "24-07-1980 20:00:00" to MS CRM db! And that works for me as the birthdate time isn't important (or visible). So my first workaround also is solved by the fixDate() method above. The second workaround has to be properly included inside the onSave event which you have to enable.


This workaround was provided by Pedro Pereira who helped me fix this issue for MS CRM 3.0 but it works fine with MS CRM 4.0.

Unwanted headache due to data type mismatch

First of all let me explain how my MS CRM Dynamics 4.0 system gets it's data.

Like any other company we have one big ERP/PMS that is our main data source and other small ERP/PMS systems. Most of this systems rely on MS SQL Server technology (2000 and 2005) for their database needs. This is great because it allows us to use SQL Server 2005 Integration Services (SSIS) to pump the data from each system's database and consolidate it to a single database. In the BI (Business Intelligence) world this process is called ETL or Extraction, Transformation and Loading. Although here we rely on the SSIS for the Extraction and Transformation phases and then we use CrmService webservice to send data to the CRM (create, update). Doing this we make sure our CRM and our ERP/PMS systems are automatically synched. Although this sounds very simple and you can learn it by yourself it really speeds up the process if you can get help from someone more experienced.

We are now developing the console application that will run in the background. This app will be responsible for retrieving data from the ETL databse and push it to the CRM using the CrmService webservice. For instance, we retrieve one contact (transformed) from our ETL database and then we push it to the CRM but first we need to know if the contact already exists there. Why's that? If the contact exists we use the Update method, if it doesn't we use the Create method. How to determine if he exists? Simple, choose a key field such as ERP/PMS customer number. This ERP/PMS primary key (PK) will act as a foreign key (FK) for our contact. If the contact is found we return the GUID and then call the Update method.

For more details about CrmService and it's methods I would advise you to take a look at Working with Microsoft Dynamics CRM 4.0 and Microsoft Dynamics CRM 4.0 Unleashed. This books are good starting points for learning how to use the CrmService. They are better used together as one has more details but fewer examples and the other has more examples and fewer details.

After some initial coding and successfull testing (retrieve data, push data) using the new much appreciated Visual Studio 2008 our problems began. Our last build of the console application crashed again and again and we didn't know why. Through debbuging we realized that it was a problem related with our RetrieveMultiple method call. After a couple of ours of nonsense coding we caught the bug: earlier we had changed an entity attribute from picklist to string (delete attribute, new attribute, save and publish), however our webreference (Visual Studio 2008) didn't reflect that change and we had to remove the web reference and add it again in order to "squish" the bug! This picture saved the day!

Gmail or Google Apps and MS CRM Dynamics 4.0

I was wondering what kind of scenario one could build using Gmail/Google Apps e-mail and MS CRM Dynamics 4.0. After watching Michael Lu's video about POP3 (Gmail) and CRM queues I was sure that it would work for POP3 enabled Gmail/Google Apps e-mail accounts. However Gmail/Google Apps also offer support for IMAP connection and that's what I would like to test!

I setp up a Google Apps dummy e-mail and enabled IMAP connection under Settings > Forwarding and POP/IMAP.

Then I added the e-mail to a dummy AD user account. Great! Then I created a new CRM user for that user's AD account and I gave him a role (don't forget about the role!).

The next move was quite simple: logged in using the dummy AD user account and ran Outlook. I had to configure my e-mail IMAP account and for that I found this nice article explaining it all. It was quite interesting to watch my labels being displayed as folders in my IMAP folder.

I run a few tests: wrote an e-mail, sent an e-mail and everything worked as it should.

Next major step: configuring MS Dynamics CRM 4.0 Client for Outlook. I run the configuration wizard and I was done in no time.

Let's track an e-mail I thought! As I hit the Track in CRM button I got this familiar message: "Only items in the default Microsoft Outlook store can be promoted to Microsoft Dynamics CRM.". I had forgotten about this feature/issue. Workaround: move the e-mail to the default MS Outlook store and the promote it to MS and then promote it to MS Dynamics CRM 4.0. If your users can live with that... Mine can't! There is another workaround scenario that would imply the use of the MS CRM 4.0 E-mail Router (POP3) but that's what I was trying to avoid.

My advice for now is to forget about Google Apps/Gmail IMAP and MS CRM Dynamics 4.0 Outlook Client integration.

Missing System Fields 2

Another missing sytem field that I don't understand why isn't there: Preferred Language. Any CRM should include that, specially if it wants to grow in Europe! Microsoft listen this: add a Preferred Language field to Contacts and Accounts. A picklist would be nice! Thank you!

POP3 and MS CRM 4.0 Queues

Michael Lu made this excellent video about using MS CRM Dynamics 4.0 E-mail Router with POP3 account. He used a Gmail account as an example. I recommend you to watch the video.

I myself conducted a similar test and I will write about it soon. I used a regular Gmail account as the user's mailbox.

More Report Wizard Videos

This time the publisher of the videos is a company called IMG.

Part 1



Part 2

Microsoft Dynamics CRM 4.0 : Report Wizard with John O'Donnell

Watch and listen John O'Donnell about the new Report Wizard here. Very interesting! This feature allows CRM users to develop some basic reports by their own! Power to the users! Free the developers!

Using Data Maps to Import Data

I would advise you to use the Auto Mapping feature first because the Data Maps feature has a small but annoying issue that I will tell you now. However using data maps to import data can be done if you are aware of that small but annoying issue.

Scenario: I want to upload some data to my CRM but I want to map the address fields in my file to the Adress 2 fields in CRM. I can change the name of the fields in the file or I can create a specific data map. I will choose this last option.

So I have a regular *.xls file with my data called "data map dummy.xls" with the fields Account Name, Street 1, Street 2, ZIP, State and Country. (image below)

I will save this file choosing CSV (comma separated values) format and I will call it "data map dummy.csv". What happens now is that due to my regional settings (guess!) the CSV file is actually a semicomma (;) separated values file. I used good old notepad to check that (image below).

Then you go to the New Data page option and press "Load Sample Data" button. You pick the file, in my case "data map dummy.csv".

After the file is loaded you need to check the Column Headings in order to see if everything went well and... it didn't! Why? The "Load sample data" action doesn't recognize semicomma (;) separated values. Boring! Boring! (image below)

The solution as I found out by myself is to replace the semicommas (;) by commas (,) using the find and replace feature of notepad. Be careful using this feature because if you have data like street addresses separated by commas or semicommas you can get yourself in big trouble. (image below).

The best thing to do is NEVER use a data file to create a data map but a dummy file with simple data (no commas or semicommas data). Using the modified "data map dummy.csv" the Load Sample Data works fine and then you'll only need to map the Column Headings to the Mapped Target Attributes. (image below)

Don't forget to Save your data map. All of this could be avoided if one had the option to choose the field delimeters ("," or ";") just like it's possible to do during a regular data import process when you get to choose the data and field delimeters (image below).



Good luck for your imports!

Using the Auto Mapping Feature

As I was about to write a post about Using the Auto Mapping Feature I realized that a similar post was available at the Microsoft Dynamics CRM Team Blog. Their post is very complete so I thought I should add just an important warning.



When you create the CSV file you'll use to import the data to MS Dynamics CRM 4.0 remember that the field names are case sensitive: "E-mail" (correct) is different from "E-Mail" (wrong). I lost a couple of minutes to fix my data files in order to use the Auto Mapping Feature because of incorrect field names. If your pick list values (file) are equal to CRM's picklist values you can also use the Auto Mapping feature.



If you can't get it right or if your data type needs some kind of transformation (for instance pick list value "Done" becomes "Completed") and you prefer not to mess with your data file then you'll have to create your own Data Map. I will write about this tomorrow because although it's simple I had to use a workaround to accomplish it.

Microsoft Dynamics CRM 4.0 Outlook Client Demonstration

Another interesting video, this time about the MS Dynamics CRM 4.0 Outlook Client. This new client represents an huge step forward regarding MS CRM usability. The MS CRM 3.0 client for Outlook gave me too much headaches. I hope the new 4.0 client behaves better. During my early tests it did but I will only make a final statement after I release it to my users desktop.

Microsoft Dynamics CRM 4.0 Sales Demonstration

If you are not familiar with MS Dynamics CRM 4.0 Sales features for starters you should watch this video.

MS CRM 4 Data Migration Manager (DMM) finally working

MS CRM 4 DMM (Data Migration Manager) as I mentioned in previous posts is quite demanding regarding its installation and configuration.

I finally managed to get it working on a client computer but for that I had to let the DMM's installer to also install a local instance of SQL Server Express. Everytime I tried to use a remote SQL Server 2005 instance he gave me troubles with permissions. So I decided to let him create a local database and now it's finally working. Although this is not the configuration that I desired for testing purposes it will have to do.

Microsoft Dynamics CRM 4.0 Connector for SQL Server Reporting Services Issue

This long name component "Microsoft Dynamics CRM 4.0 Connector for SQL Server Reporting Services Issue" gave me a long time trouble to install. I got this error message "Unable to validate SQL Server Reporting Services Report Server installation". As I had followed all the steps and recomendations mentioned on the installation guide I didn't know what was causing that unexpected behavior.

I googled a little and I found this KB article (KB947060) about it. The problem occured because I was trying to install the MS Dynamics CRM Connector for SQL Server 2005 Reporting Services on a named instance of SQL Server 2005 RS and it seems the installer doesn't behave as it should under these conditions.

The KB gave me two possible resolutions but only one applied to my situation: Method 2: Modify the Install-config.xml file. The steps needed to solve this issue are well explained in the KB article. If you're running SQL Server 2005 on a AMD 64 platform don't forget to copy the SrsDataConnector files from the drive:\Server\am64 folder instead of the suggested drive:\Server\i386. I sent a feedback to Microsoft about this tiny detail.

After modifying the install-config.xml file for the SrsDataConnector I finally ran the SetupSrsDataConnector.exe /CONFIG path of the folder that contains the Install-config.xml file\install-config.xml command and managed to finish the installation successfully.

The best new CRM feature: Buit-In Customizable Duplicate Detection

For me this feature is one of the best new features. Only the new MS CRM Client for Outlook compares to it. There are much more new and great features but these two were the ones that gave me headaches while deploying MS CRM 3.0.

The best way to explain you what this Built-In Customizable Duplicate Detection feature is all about it to invite you to watch this video from the ConsultCRM guys.

MS CRM 4.0 Implementation Guide (IG)

You can download the Implementation Guide (IG) here. I read the Planning Guide, the Installing Guide and the Operating and Maintaining Guide in less than 3 hours while I was going from Lisbon to Porto (Oporto) by train. These three guides together with some useful file templates make up the helpful Implementation Guide. The IG is very well written and clear.

I confess that I started to deploy MS CRM 4.0 whithout reading the IG as I should. I gave it just a quick look speacilly to the new features and then I started the MS CRM 4 installation. One of the questions I had and I made a post here and at the dynamics forums about it was which base language to choose. Well after my last reading of the guide I got it figured it out whithout no doubts. I read at page 3-31 of the Planning Guide the following: "The base language of Windows Server, SQL Server... must be the same language version as Microsoft Dynamics CRM Server. - or- The base language of Windows Server, SQL Server... must be U.S. English". So it's quite clear to me: the safest scneario is allways to deploy MS CRM in english and then add it the language packs available if you have to. End of discussion.

Another important thing I learned from the IG was that the Data Migration Manager or DMM for friends is quite demanding in terms of requirements. At page 5-40 of the Installing Guide one can read that:

• "Important: You cannot run the DMM on the same computer when MS Dynamics CRM for MS Outlook is running. You must close MS CRM for MS Outlook before you run the DMM." Understood!
• "The DMM can only be run by a user with the System Administrator secutiry role.". They are referring to the MS CRM secutiry role! That could be better explained! I will pinpoint that to Microsoft!

I also realized from what I read that the DMM has to be installed on the client machine rather than the server where MS CRM 4 is running. Don't forget the user has to have Local Administrator privileges to install it on her/his machine. I don't know about you but most of my CRM users are women!

I knew I had read it somewhere: at page 3-30 of the Planning Guide another important requirement or recommendation regarding the DMM:

• "Although DMM and MS Dynamics CRM for Outlook can be installed on the same computer they cannot be run at the same time." Thank you!
• "DMM must be installed on a computer that has a connection to the MS DYnamics CRM Server." Well... That's obvious!
• "We do not recommend that you install the DMM on a computer that is running MS Dynamics CRM Server." That's new for me! As I was havint troubles making DMM work I tried to install it on the server side... I won't do it again, promise!

Finally I also learned that I will need to install and run the MS CRM E-mail Router if I want to send and receive e-mails for Queues as I am planning to not deploy it (router) for my users. I will trust the great MS CRM Client for Outlook to do that because I had really bad experiences with the MS CRM 3 e-mail router.

Translations for new fields (attributes) and entities

It's quite simple to transalte CRM fields (attributes) and entities labels. How do you do it? Go to Settings > Customization > Export Labels for Translation.

After translation (I used MS Excel to edit the file) you need to import the XML file back to CRM. Import Labels for translation. Then go to Customize entities and hit More Actions > Publish All Customizations and you should be done. It isn't enough to hit the Publish button you really have to Publish All Customizations. Don't ask me why... Ask Microsoft!

Datetime format issue

One of the first things I changed in the System Settings was the Current Format to Portuguese (Portugal).


However I still had to Set Personal Options Current Format to Portuguese (Portugal). You can do this at your CRM window menu under Tools > Set Personal Options. That may seem odd because if I have the server format configured to Portuguese (Portugal) my Personal Options should reflect that. A bug or a feature? I'm guessing this is a feature because it allows one to work with the format one preferes.

Missing fields!

MS CRM has a great collection of contact fields (attributes) but lacks some basic fields suchas as ID document related (ID type, ID number and ID Country Issuer) and VAT document related (VAT number and VAT Country Issuer). Another request for Microsoft!

Custom attributes that should be system (standard) attributes.

ID related fields go to section Personal Information at Details tab.

And VAT fields go to the Billing Information section at Administration tab.

And let the fun begin: customization!

My first customization was really simple and logical. Being MS CRM 4 a strategic marketing tool I don't get why there isn't a tab called Marketing at the Contact form. Create, Save and Publish! Don't forget to Publish!

I'll just add the Marketing Information fields from the Administration tab here and create my customers preferences using a new bit attribute. It'll be easier for marketeers to create marketing lists if you use bit based preferences rather than creating a new entity called preferences. Now it's even easier to create attributes one after another thanks to the Save and New button for attributes. Another warning: by default the order of the bit values is No and Yes and if you check system attributes the order is Yes and No.

The last finding will only affect the order of the values. Check out Preferences attributes (custom) versus Send Marketig Materials (system attribute). To improve the user experience you should present the new attributes respecting the system order (Yes/No). The worst part of this is that you can't change the order (Move up or Move down) once the attribute is created. You need to unpublish it (remove it from the form then publish) and then you can delete it and create it again (create, add to form, publish). Boring! So be carefull!

Microsoft if you're listening please change de default bit attribute order! Well, if I don't shout I will never get it so I guess it's better to shout than not to.

MS CRM 4 System Settings

Some quick tips about setting up MS CRM System settings.

Don't forget to change Current Format for you current format which in my case is Portuguese (Portugal).

If you wish to switch off the tracking token you should go to the e-mail tab and uncheck Use Tracking Token. You couldn't do this with MS CRM 3.0. This is a great new feature! Don't worry because you will be able to track your CRM related e-mails using the MS CRM Dynamics Client for Outlook.

I also set the auto-unsubscribe option. This feature was also available at MS CRM 3 release but now you can also set a template e-mail to automatically confirm the unsubscription. Just keeps getting better! The Send Marketing Materials is one of me the most important fields for CRM contacts and accounts because when you launch a campaign you should allways check if your customers wish to receive Marketing Materials or not. You can do that when creating the Marketing List and choosing the right conditions of the filter: Send Marketing Materials = Yes.

Here you can check or uncheck the Application mode. This is also a new and welcomed feature that will let choose if you want your CRM browser window to show the address bar or not. If you have a lot of activities and customers I would advise to open MS Dynamics under the Application mode.

Microsoft Dynamics CRM 4.0 : Data Migration Manager with John O'Donnell

I couldn't resist to share with you this great screencast about the new MS CRM Data Migration Manager (DMM) available at Channel 9. If it works like John O'Donnell shows at the video it will rock for sure!

However... I still need to make it work on my development environment. I'm geting this "Failed to determine the SQL data root path for CRM instance." error. I'm not the only one because there is a thread at Dynamics forums about it.

Should Microsoft Quit CRM? Hell no!

I read this interesting news article at destinationCRM with the title "Should Microsoft Quit CRM? ". It seems that there are quite a few important people who support that Microsoft should quit CRM and even the Dynamics product line. If I would have to comment on that based on my personal experience with MS CRM 3.0 I would say those guys are probably right. However after a short trial period of MS Dynamics CRM 4.0 I am feeling quite positive towards MS CRM! I hope this feeling doesn't fade away!

I chose English as my MS CRM 4 base language

As I was in a hurry to deploy a development environment for CRM 4.0 I chose to deploy MS CRM 4 in English (base language) and then I applied and enabled the Portuguese Language Pack (at server level). Just for testing purposes I went to Tools and changed the language to Portuguese. The page refreshed and in no time I was working with my MS CRM 4 in Portuguese. However I must warn you that some administration features are only available in the base language.

Afterwards I installed the Outlook client for CRM (EN) and after I configured it properly I opened Outlook (PT) again and with great joy I realized that the Outlook plugin was working in my Outlook language (PT). Just like magic! I didn't have to install any language pack on the client side! It's incredible when things work the way they're supposed to! Two or three buttons were in english but that's not a problem for me!

Which base language to choose?

I posted this thread at Microsoft Dynamics Forum.

Which base language to choose?

I am currently running MS CRM Dynamics 3.0 in Portuguese (Portugal). I am also evaluating MS CRM Dynamics 4.0 and I will set up a development environment for it. With the new multi-lingual support I'm not sure what base language should I choose for my MS CRM 4 server. I realized I have the following two scenarios:

Scenario 1 (EN+PT):

• Server: Microsoft Dynamics CRM 4.0 Server (4.0.7333.3) - Language: English; Plus Microsoft Dynamics CRM 4.0 Language Pack (4.0.7333.151) Language: Portuguese (Portugal)
• Client: Microsoft Dynamics CRM for Outlook (4.0.7333.3) - Language: English; Plus Microsoft Dynamics CRM 4.0 Language Pack (4.0.7333.151) Language: Portuguese (Portugal);

Scenario 2 (PT+EN):

• Server: Microsoft Dynamics CRM 4.0 server (4.0.7333.151) - Language: Portuguese; Plus Microsoft Dynamics CRM 4.0 Language Pack (4.0.7333.3) Language: English;
• Client: Microsoft Dynamics CRM for Outlook (4.0.7333.151)) - Language: Portuguese (Portugal);Plus Microsoft Dynamics CRM 4.0 Language Pack (4.0.7333.3) Language: English;

Notes:

• SQL Server: SQL Server 2005 - Language: English (will suport MS CRM database);
• MS CRM 4 Virtual Server: Windows Server 2003 - Language: English (will support MS CRM applications);
• Clients: Windows XP SP2/Windows Vista - Language: Portuguese (Portugal).

I also read the following in the Language Pack Readme:
"The language of Microsoft Dynamics CRM for Outlook must match the base language for the Microsoft Dynamics CRM implementation.In Microsoft Dynamics CRM, all implementations have a "base language" setting that determines the organization's default formats for numbers, dates, times, and currencies, as well as the default language for the Microsoft Dynamics CRM user interface and Help. The installation language of Microsoft Dynamics CRM 4.0 for Microsoft Office Outlook must match the base language that you have selected for your Microsoft Dynamics CRM implementation.
If you have installed Microsoft Dynamics CRM for Outlook in a language that does not match the base language of your implementation, uninstall both Microsoft Dynamics CRM for Outlook and the local instance of Microsoft SQL Server 2005, and then reinstall Microsoft Dynamics CRM for Outlook using the base language. After you install Microsoft Dynamics CRM for Outlook in the base language, you can install Language Packs on the computer that is running Microsoft Dynamics CRM for Outlook to enable additional languages for the user interface and Help.
Note: Installing a Microsoft Dynamics CRM Language Pack on the computer that is running Microsoft Dynamics CRM for Outlook does not change the language settings for the Office Outlook user interface or Help -- only for labels, controls, and Help unique to Microsoft Dynamics CRM. For more information about how to enable additional languages in Outlook, refer to the Outlook documentation. " which validates my two scenarios.

After giving it more than a thought I arrived to this simple conclusion: I should choose Scenario 1 (EN+PT)) if I would like to manage/develop MS CRM Dynamics 4.0 in English and Scenario 2 (PT+EN) if I would like manage/develop MS CRM Dynamics 4.0 in Portuguese. Either way my end users running XP/Vista in Portuguese will use MS CRM 4 in portuguese through the base language (Scenario 2) or using a language pack (Scenario 1). Am I correct or am I forgetting something?

If I am correct then I would go for Scenario 1 (EN+PT) because it's more universal and it's a lot more easier to find books or support in English than in Portuguese. What do you think about my option and knowing all this, which language would you choose?

Thank you!


Sergio Coelho, IT Project Manager

CR what?

CRM or Customer Relationship Management (CRM) "is a customer-centric business strategy with the goal of maximizing profitability, revenue, and customer satisfaction.[1]

Technologies that support this business purpose include the capture, storage and analysis of customer, vendor, partner, and internal process information. Functions that support this business purpose include sales, marketing, customer service, training, professional development, performance management, human resource development, and compensation.

Technology to support CRM initiatives must be integrated as part of an overall customer-centric strategy.

Many CRM initiatives have failed because implementation was limited to software installation without alignment to a customer-centric strategy.[2]" as one can read at wikipedia.

I wanted to share this piece of information with you because it's one of the best CRM definitions I have read so far. It also states very clearly that CRM is not just another software suite: it's a business strategy supported by technology like Microsoft Dynamics CRM 4 and others (Siebel/Oracle, SAP, Salesforce.com).

Mission Statement

This blog was created with the main purpose of sharing thoughts, problems, solutions, news and links related to Microsoft Dynamics CRM 4 from a dummy to dummy perspective.

Although I don't see myself as a MS CRM dummy I realized that most of the information I find across the internet about MS CRM comes from Microsoft or Microsoft partners. Being so, it's quite easy to find MS CRM propaganda like brochures and demos and MS CRM Knowledge Base articles. What it isn't so easy to find is an unbiased or not so technical source of information regarding Microsoft Dynamics CRM 4 and that's what I would like to offer you with this CRM 4 Dummies blog. The name itself says everything: (MS) CRM 4 (version) Dummies (IT or CRM aware people like you and me). This funny name will probably give me a few extra hits because it's similar to the name of the yet to be released Microsoft Dynamics CRM 4 For Dummies book.

I work as an IT Project Manager in the hospitality and real estate industry and I recently lead a MS CRM 3.0 project implementation. I'm currently setting up my MS CRM 4 development environment in order to evaluate it properly. It has been quite an adventure so I will write you about it very soon!

As this blog will try to be not too technical I will offer you links to more technical and/or official sources. Check out the Useful Links section.