Nishant Rana's Weblog

Simple integration between CRM 2011 online and SharePoint 2013 online.

Hi,

I was recently working on a POC that required us to show a kind of integration between CRM 2011 online and SharePoint 2013 online. Basically here based on the case record opened in CRM we wanted to show associated information in the SharePoint 2013 website (could be wiki page, documents, web page etc.) within an iframe of the Case form.

So we first created an Office 365 Preview account for SharePoint 2013.

http://www.microsoft.com/office/preview/en/office-365-enterprise

Added few documents to it and created a custom search result page.

Here the nice thing about SharePoint 2013 is the Document Preview feature. Hover over the search results and user will be able to see the preview of the same.

Here the search term is passed in the query parameter k

https://xxx.sharepoint.com/search/Pages/results.aspx?k=product1

So we simply had to use the same URL in the IFrame inside CRM and in the onload, change the url to add our own value for k query parameter to show respective search results within CRM’s form IFrame.

We already had a CRM 2011 online (trial) instance created in Office 365 online, unfortunately it had SharePoint 2010 online in it and here we specifically wanted to showcase the Document Preview feature which is not in SharePoint 2010.

The issue here was that both CRM 2011 online and SharePoint 2013 online were part of different Office 365 instance. So if we are showing the SharePoint 2013 page within CRM 2010 online it would give the “user not authorized” access.

The solution to this was to give the CRM 2011 online user access to the SharePoint 2013 site.

For this we need to follow the below steps

Select the Sharing option for the selected site collection in the SharePoint administration page

Then

Open the site collection à site settings

Select People and Groups

Add the new user (added the email id of the CRM 2011 online user)

An invitation will be sent to the user’s mail box

CRM 2011 online user can now accept this invitation by logging in with his account. And he would have access to the SharePoint 2013 online site based on the Groups he has added by SharePoint admin. Now the Search Results page of SharePoint 2013 online can be shown inside CRM 2011 without any authentication issue as the user is now member of SharePoint site.

Hope this helps!

Quizlet for CRM 2011 Customization and Application Exam

Hi,

I happen to came across these two good resource for someone preparing for the customization and application exam of CRM 2011.

http://quizlet.com/13812439/crm-app-2011-flash-cards/

http://quizlet.com/13348922/crm-2011-customization-config-flash-cards/

Bye.

Could not find stored procedure ‘sp_dboption’ while installing SharePoint 2010.

Hi,

Got the below error while running the configuration wizard for SharePoint 2010.

Installing Service Pack 1 for SharePoint 2010 resolved the issue.

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

Check out the following link

http://msdn.microsoft.com/en-us/library/hh231665(v=sql.110).aspx

http://simranjindal.wordpress.com/2011/09/09/getting-up-and-running-with-sql-server-denali-for-business-intelligence-crescent-and-powerpivot-in-ctp3-issues/

Bye.

Customizing the results of Search Core Results Web Part in SharePoint

Hi,

I was recently assigned a task to customize the Search Core Results Web Part’s search results to include few additional columns for SharePoint 2010 online.

Came across the following helpful links

http://andynoon.wordpress.com/2010/10/12/configuring-and-customising-sharepoint-2010-search/

http://www.sharepointsharon.com/2012/08/displaying-more-properties-in-search-results/

http://www.mindfiresolutions.com/How-to-customize-the-search-results-of-a-search-core-result-web-part-in-SharePoint–1096.php

http://sharepoint-videos.com/sp10-customize-search-results-using-xslt/

Here the first thing we need to do is to create a new Managed Property. After lot of struggle and searching came to know that this is not possible in case of SharePoint 2010 online.

SharePoint 2010 online administration center :-