CRM 2011 – Entities filter out null attributes

I was looking at the CRM 2011 entity today.  I was having to search the entity attributes to find a the value of a variable/field.

Initially when I did this the entity variable is ent


I was getting nothing

I then did a count on the number of attributes in the entity


it returned 51 but the entity had 83 attributes.  Which meant I was missing 32 variables.

I found out that it only lists the attributes that don’t have a null value.  I worked this out because I went and gave one of the missing fields a value and then it appeared in the list of attributes.

This makes sense really because why bother including lots of variables which haven’t been set and don’t have a value but it can be quite confusing if you aren’t expecting it and have put some logic in based on the variable



Will we see Google Enter the CRM Market

I have read a few articles recently wondering if Google will enter the CRM market.  In fact I expect to see more articles on the subject, mainly because some people would like to see it happen and others are concerned about it.

If you want to read a couple of good articles on the subject click on the links below

Personally I don’t think Google are heading in this direction but people think because they have created email, calendars and office applications (word, excel etc) the next logical step is to move towards CRM.

I don’t really see this is of interest for google.  The reason Google made the office applications is because all users would use this and calendars etc.  I think the everyday home user is Google’s target market.

To create a CRM product you need a piece of software to link everything together like sales, marketing, orders, invoices.   This takes a lot of time and development, even Microsoft who entered the CRM market quite late had to spend a lot of years of developing CRM to get it to the standard it is today.

I could be proved wrong of course but I don’t think Google will enter the CRM market, instead they will aim towards creating an operating system and concentrate on cloud storage and maybe a cloud pc, allowing people to have a simple computer to access it.

CRM 2011 – Importing/exporting data between organisations

Today the Microsoft team blog had a really useful blog post.  It gave instructions on how to transfer information between organisations using exports and imports.  This is very useful for transferring data between test systems.  It is also useful to export the data to an excel file and then you can always import the data when ever you need it.

Click here to read the article.

This is also similar to the way you can export data, change it and then reimport the changes