This is a total hack! I mean please do a little more research before Production deployment J ….
Well we all know about this one http://wellytonian.com/2011/05/sharepoint-2010-and-crm-2011-integration/ Integrating SharePoint document library within CRM.
But we had a new requirement to get CRM Lists to be displayed as web part within SharePoint 2010. I knew there was a fix for CRM 4.0 list web parts to work within MOSS 2007 and WSS 3.0.
You can download that web part here http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=20651
Whoop get to go home early today. #fail.
The installer just wouldn’t recognize the SharePoint 2010 install. Here are the screenshots
What? But on the download page
Weird. That means the web part file is within that exe. So I decided to try and extract whatever is within the listwebpart.exe
And we have a winner
PowerShell the bad boy into the farm
Have the solution deploy to all your web applications and now try and add the following web part
References and Credits:
http://www.ryanonrails.com/2011/02/25/hooking-crm-2011-and-share-point-2010-together/ and follow him on Twitter http://twitter.com/#!/ryanonrails
Download the CRM 2011 List component for SharePoint 2010 solution from here
Extraction of the folder will reveal the following items
Open Central Administration and click on Application Management. Then Browse to Web Applications and this will open the web applications currently installed on SharePoint. Highlight the web application that will host the Site Collection to be integrated with CRM as shown below. On the ribbon the icon for General Settings will no longer be greyed out as shown below
Under the Web Applications general settings window that has now opened, browse to the end of the window to the section containing Browser File Handling permissions and click on “Permissive”.
Open your site collection and under site actions, click on Site Settings.
Select Solutions from the Gallery and the following window called Solutions gallery will pop open. Choose upload and browse to the folder that contains the extracted files from step 2
Press upload and the following box will pop up. “CLICK CLOSE”
At this stage, the solution has been uploaded onto the Site Collection properly. The CRM list component requires Microsoft SharePoint Foundation Code Service to be running before you can activate the solution.
For the sake of example, I used Search Server Express 2010 with a SQL 2008 R2 DB server.
The following services were started in order during the installation of SharePoint,
- State Service
- Usage and Health Service
- Search Foundation Search
- Search Service
- Sandbox Solution Service – Foundation Code Service
- Web Analytics Service
So to continue with the CRM integration post,
Before activating the solution, verify that the appropriate service is running
Open either PowerShell or SharePoint Management Shell and browse to the folder that contains the extracted files. Within this folder is a PowerShell file called AllowHtcExtn.ps1. The execution of this file is only necessary if SharePoint is installed on a Domain Controller, for example in a development environment. But I have also found if the VM that has SharePoint installed on it, was previously a domain controller and was “dcpromed” , then run the script. There is no harm in running the script even if you are not sure.
Remember to add the URL – http://servername at the end as shown
Head back to the site collection and open Solution Gallery under Site Settings again. Click Activate this time , to activate the solution,
Within a few seconds, the solution will display activated as shown
Open CRM and under Settings , click on Document Management,
- Solution not activating :-
- Installation of SharePoint has been corrupted for some reason.
- Running of the AllowHtcExtn.ps1 Script wasn’t done with the proper arguments.
- Didn’t add the Brower File Handling permission for the Web Application.
- CRM keeps complaining the List Component is not activated even though the site is valid URL