The Microsoft CRM Email Router service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

by Polat Aydın

When  you  start your email router service and you get an error like this:

The Microsoft CRM Email Router service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

Please delete this file.

C:\Program Files\Microsoft CRM\Email\Service\Microsoft.Crm.Tools.EmailAgent.SystemState.xml

After deleting the file , you can start your emailrouter service and system will create this xml again.

Updating CRM database from external SQL table - Money and Time field update

attribute.Key.ToString()  -- is the CRM attribute name
row[attribute.Value]   -- The External SQL table value

For money
  if (attribute.Key.ToString() == "derivedproposaltotal" )
                               {
                                 
                                   decimal mymoney = Convert.ToDecimal(row[attribute.Value].ToString());
                                   entity[attribute.Key.ToString()] = new Money(mymoney);

                               }


For Time
   if (attribute.Key.ToString() == "derivedawarddate" )
                               {


                                   string mySourceString, myDateString;
                                   mySourceString = row[attribute.Value].ToString();
                                   myDateString = string.Concat(mySourceString.Substring(0, 10), "T", mySourceString.Substring(11, 8));
                                   entity[attribute.Key.ToString()] = DateTime.Parse(myDateString);

                                 
                               }

Bringing data from External System into CRM 2011

I am in the process of bringing data from External System into CRM 2011.
Updating  the CRM database from an external SQL table.
Using CRM SDK.

2014 Convergence in Atlanta

The Convergence 2014 conference was informative and good. Attached find the 2014 Roadmap for Microsoft Dynamics CRM from the Keynote session.

Highlights:

·         Netbreeze or Social Listening in CRM

·         Parature Integrated with CRM

·         Microsoft Dynamics Marketing –MDM module in CRM

Some highlights from the sessions that I had attended:

CRM 2013 results

150,000 concurrent users

2.5 Tera Bytes of data

5110 business units

24,105,600 Business transactions/day

240 micro seconds/read

77 micro seconds/write

http://www.microsoft.com/en-us/download/details.aspx?id=42037

Dynamics CRM 2011 and 2013 useful Tools and Features

http://blogs.msdn.com/b/crminthefield/archive/2014/03/04/dynamics-crm-2011-and-2013-useful-tools-and-features.aspx

No more extension table in 2013 (base and extension table merged together)

http://community.dynamics.com/crm/b/crmvideos/archive/2013/11/05/microsoft-dynamics-crm-2013-setup-and-upgrade-new-features-base-and-extension-table-merge.aspx

I also met with couple of Microsoft Premier support engineers whom I work with.

Shawn Dieken

Sean Mcnellis

This is blog from their team has some good information on it.

http://blogs.msdn.com/crminthefield