Time Capsule 2006 to 2009 - The Technologies of a technical consultant

I was sitting on the train today, thinking about the technologies I have worked with in the last three years. And you know what? I have to say web technologies have developed extremely quickly (Well of course it is!). Being a consultant allows me to indulge myself into the latest technologies, and most of the time, take the latest technologies for granted.

Sometimes I think it is actually quiet an effort to keep up (yet I have to for my passion and profession). What I mean for example is say, you install an SDK for Silverlight 2.0, work with it a little while, then you will find yourself installing the SDK for Silverlight 3.0 (And of course with that Visual Studio 2010)! It is hard work to keep up, but it is worth it!

I've worked with SharePoint 2003, I'm working with SharePoint 2007 technologies and now with the sneak peak at the exciting SharePoint 2010, I have to say being a techy guy is the best job in the world! It is very rewarding to see Microsoft listening to customers, giving them what they want. I dig the new BCS, I dig the new ribbon within the web browser, I dig multi-item checkouts, I dig the new developer tools, I dig the new backup and restore tools, I dig the new central admin.....I dig it, I dig it, I dig it! Then again, it is hard work to keep up, but it is worth it!

Anyways, the purpose of this is to keep a time capsule of the (non beta) technologies I have played within the 3 yr period. Who knows how many of these technologies will stay in my list? Here goes...

2006-2009:
Microsoft Technologies

• C#/VB
• ASP.NET
  
• .NET 1.0, 1.1, 2.0, 3.0, 3.5
• SQL 2000, SQL 2005, SQL 2008
• Windows 2000, Windows 2003, Windows 2008, Windows XP, Windows Vista, Windows 7
  
• Microsoft CRM 3.0
• Microsoft CRM 4.0
• WSS 2
• SharePoint Portal 2003
• WSS 3
• MOSS 2007
• MS Office 2003/2007
  
• Microsoft Search Server 2008 and FAST
  
• Silverlight 1.0
• Silverlight 2.0
• Internet Explorer 6.0/7.0/8.0
  

Third Party

• Javascript and AJAX
  
• JQuery
• Flash
  
• DotNetNuke
• SugarCRM
• Meridio
• HP Trim
  
  

Microsoft CRM 4.0 - Browsing documents more effectively in Microsoft CRM 4.0

Ever thought browsing thru attachments in Microsoft CRM 4.0 was painful? You had to open the Entity window (ie. Contact/Account/Quotes...) and then go to the Notes tab, then scroll down to the attachment you need. Seems like alot of clicks to me.



Luckily, the guys at mscrm-addons.com released a tool a tool called "Document Summary". The "Document Summary" is available in the "Documents Core Pack for MS CRM 4.0", which includes a range of other tools such as WordMailMerge, SharePoint Integration, Send to PDF, and more.

I haven't used it myself yet, but I've seen the demo video. Here's how it looks like:


So far it looks pretty good. Point, click and browse. Simple, and very nicely done.

I don't work for mscrm-addons.com, so I'm not trying to sell their products.

For more information:
http://www.mscrm-addons.com/Products/AddonsforMSCRM40/DocumentsCorePack/tabid/130/Default.aspx

Microsoft SharePoint 2007 and Microsoft CRM 4.0 - Custom Field Types for MS CRM 4.0

I came across a great article by Karine Bosch and Patrick Tisseghem about creating custom field types in SharePoint that exposes CRM 4.0 data via BDC. The first article includes a link to download the sample.

Here are the links:
Overview - http://www.u2u.info/Blogs/Patrick/Lists/Posts/Post.aspx?ID=1789
Detailed How To - http://www.u2u.be/Res/Article.aspx?ART=CRMSharePointCustomField

The highlight here is the ability for the user to search for a CRM record (whilst checking details on the record) to attach to a SharePoint list item.

Microsoft CRM 3.0 - Call-Outs in CRM to create new SharePoint Sites

This article was kept in my draft stash for quite some time now, and I found it really useful and relevant to another post, which I published not long ago.

This article is a technical tutorial on developing call-outs for Microsoft CRM to create new SharePoint sites. Call-outs are custom "logic" that is executed as a result of a CRM workflow reponse.

The article is listed below:
The purpose of the integration is to create collaboration sites on SharePoint 2007 as new accounts or opportunities are created in Microsoft CRM
http://www.codeproject.com/useritems/MOSS_2007-CRM_Integration.asp

Microsoft SharePoint 2007 - SharePoint Configured as a CRM Tool?

When SharePoint was first released I recall having a conversation with a fellow colleague about the possibility of customising SharePoint as a CRM application.

A company called "BPA" did exactly just that, and named the product "Easy CRM SharePoint" (Easy CRM software solution for Microsoft SharePoint). They have flash demonstrations for this CRM application, and it proves to be very interesting indeed! Click on this link to see it: http://software.crm-sharepoint.com/default.aspx.

So how did they do it? Does it integrate core CRM functionality into Outlook? Would it be better than Microsoft CRM 3.0 itself? Well, having a bit of a look into it, it appears they've used a series of lists, calendars and custom web parts to contribute to CRM functionality. They've even got lists of reports, offline access, an Outlook connector (to attach emails to items) and more. However, as compared to Microsoft CRM 3.0, it does seem like a little child, but I'll leave that to you to judge.

Microsoft CRM 3.0 and MOSS 2007 - CRM and SharePoint Integration

I've recently been looking at the integration of Microsoft CRM 3.0 and Microsoft Office SharePoint Server (MOSS) 2007 and my findings were pretty promising!

Of my findings, ways to integrate Sharepoint 2007 and Microsoft CRM include:

* Presenting CRM data in Microsoft's CRM list web part (More Info)
* Exposing basic lookup/view functionality from the CRM list web part
* Presenting KPIs, Reports, and CRM data with MOSS 2007 Excel Web Access Service
* Presenting CRM data, KPIs and more using MOSS 2007's Business Data Catalog (BDC) and BDC web parts (More Info)
* Exposing CRM data through MOSS 2007 Enterprise Search functionality using BDC
* Presenting CRM records in a SharePoint 2007 RSS feeder web part using the RSS adaptor from Microsoft (More Info)
* Storing CRM documents in a Sharepoint Document Library to leverage versioning control and better management (More Info)
* Integrating SharePoint 2007 document library with CRM information using a third party tool (c360 Word Mail Merge or MSCRM-Addons WordMailMerge)
* Integrating a SharePoint 2007 page into the Microsoft CRM interface as a sub application or as part of a tab using iFrame
* Using a CRM workflow and a CRM call-out assembly to create a Sharepoint workspace for a CRM record
* Using MOSS 2007's workflow (or an event handler) and Windows Workflow Foundation (WWF) to create a CRM record when a subsite or list item is created.
* Presenting CRM Reports in Sharepoint using SQL Reporting Services web parts (Report Explorer and Report Viewer)

And more...
* Remembering the fact that Microsoft CRM is built on SQL, other applications can be created pulling data from filtered views (It is best practice to only use filtered views created by CRM.)
* Remembering that Microsoft CRM offers web services, other applications can be created to leverage off CRM's web services. Data security of the CRM data provided by the web service is inherited from Microsoft CRM when the you authenticate whilst connecting.
* Remembering that Microsoft SharePoint also offers web services, and hence call-outs can leverage off SharePoint functionality!

A small number of Blogs/Articles which I've read as a part of my research:
* Sharepoint Integration Approaches http://mscrm.spaces.live.com/blog/cns!534230C9D7A90B1B!390.entry
* Sharepoint with MS CRM 3.0 http://microsoftcrm3.blogspot.com/2007/01/sharepoint-with-ms-crm-30.html
* Microsoft Dynamics CRM Official Site http://www.microsoft.com/dynamics/crm/default.mspx
* Microsoft CRM Integration & Customization: SharePoint Document Gateway http://www.albaspectrum.com/Customizations_Whitepapers/Microsoft-CRM-Integration-Customization-Sharepoint.htm
* Microsoft CRM Integration & Customization: SharePoint Document Gateway http://ezinearticles.com/?Microsoft-CRM-Integration-and-Customization:-SharePoint-Document-Gateway&id=26933
* Microsoft CRM 3.0 SDK http://msdn2.microsoft.com/en-us/library/aa682866.aspx
* Reporting Services WebParts - Walkthrough http://blogs.sqlxml.org/bryantlikes/articles/628.aspx
* SQL Server Reporting Services Web Parts Review http://weblogs.asp.net/jan/archive/2005/01/21/358073.aspx
* Questions I asked on the CRM Community Site http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.crm.deployment&tid=d6f67d53-fe75-4d6f-8bf8-d4fe79b15e5f&cat=〈=en&cr=US&sloc=en-us&m=1&p=1
* Microsoft Office Sharepoint Server 2007(MOSS 2007) And Microsoft CRM Integration http://www.codeproject.com/useritems/MOSS_2007-CRM_Integration.asp