By Adrian Colquhoun
Photo: niiranen.eu
CRM 2011 online contains out of the box functionality to integrate with SharePoint 2010. This is the perfect way to store and manage documents that relate to your customers, such as quotes, orders, invoices and so on. However, to make full use of this functionality, you need to install a CRM component onto your SharePoint installation. While this is fine for on premise SharePoint deployments, it is not allowed for SharePoint online (Office 365). This is a glaring oversight in Microsoft's cloud vision (fix this soon please!). However, it is still possible (if not obvious) to achieve a workable integration between CRM 2011 online and SharePoint 2010 online. This article shows you how to do it.
Steps Required
• Create a document library in SharePoint
• Add folders for each customer
• Create a custom URL to each customer folder
• Add the custom URL to the account record in CRM
In Detail
1. Create a document library in SharePoint online.
2. Add a folder for each customer.
1. Open a folder. Copy its URL and paste into notepad.
2. Locate the FolderCTID parameter, then find the & after this (this is the end of the folder id).
3. Delete everything after the &
4. Add idDlg=1 to the end of the URL
1. Copy the new URL (you will need to paste this into CRM).
2. Open the corresponding customer record in CRM online
3. Add a new document location. Give this a name and Paste the modified URL.
1. Click the Save button to save the location. Any documents in your folder are now visible in CRM and you can access SharePoint online functionality directly.
How it Works
For each account record, CRM 2011 is simply providing "a window" (IFrame) into your SharePoint online installation. This window points to the SharePoint folder that you have previously created. While the two systems appear to be integrated, they are in fact still separate. You will need to remember this when considering security (i.e. who can see and do what). If you want to control visibility and access to the documents, configure this in SharePoint.
When we copy the URL of our SharePoint 2010 folder, we first remove all the information we don't need (as CRM complains if the URL is greater than 256 characters) and then add the &idDlg=1 parameter to the end. This is simply a switch to tell SharePoint not to show all its navigation headers, as we don't want to show. If we leave this parameter off the integration would look like the screenshot below.
If you want to delete a document location, you will be frustrated to find that there is not obvious way to do this from the account record. However, it is possible by navigating to the Documents management section of the System Settings.
For professional SharePoint Training in Brisbane Australia, visit Intelligent Decisioning SharePoint Training website at http://www.id-live.com.au/Sharepoint-2010-training-brisbane.aspx
Photo: niiranen.eu
CRM 2011 online contains out of the box functionality to integrate with SharePoint 2010. This is the perfect way to store and manage documents that relate to your customers, such as quotes, orders, invoices and so on. However, to make full use of this functionality, you need to install a CRM component onto your SharePoint installation. While this is fine for on premise SharePoint deployments, it is not allowed for SharePoint online (Office 365). This is a glaring oversight in Microsoft's cloud vision (fix this soon please!). However, it is still possible (if not obvious) to achieve a workable integration between CRM 2011 online and SharePoint 2010 online. This article shows you how to do it.
Steps Required
• Create a document library in SharePoint
• Add folders for each customer
• Create a custom URL to each customer folder
• Add the custom URL to the account record in CRM
In Detail
1. Create a document library in SharePoint online.
2. Add a folder for each customer.
1. Open a folder. Copy its URL and paste into notepad.
2. Locate the FolderCTID parameter, then find the & after this (this is the end of the folder id).
3. Delete everything after the &
4. Add idDlg=1 to the end of the URL
1. Copy the new URL (you will need to paste this into CRM).
2. Open the corresponding customer record in CRM online
3. Add a new document location. Give this a name and Paste the modified URL.
1. Click the Save button to save the location. Any documents in your folder are now visible in CRM and you can access SharePoint online functionality directly.
How it Works
For each account record, CRM 2011 is simply providing "a window" (IFrame) into your SharePoint online installation. This window points to the SharePoint folder that you have previously created. While the two systems appear to be integrated, they are in fact still separate. You will need to remember this when considering security (i.e. who can see and do what). If you want to control visibility and access to the documents, configure this in SharePoint.
When we copy the URL of our SharePoint 2010 folder, we first remove all the information we don't need (as CRM complains if the URL is greater than 256 characters) and then add the &idDlg=1 parameter to the end. This is simply a switch to tell SharePoint not to show all its navigation headers, as we don't want to show. If we leave this parameter off the integration would look like the screenshot below.
If you want to delete a document location, you will be frustrated to find that there is not obvious way to do this from the account record. However, it is possible by navigating to the Documents management section of the System Settings.
For professional SharePoint Training in Brisbane Australia, visit Intelligent Decisioning SharePoint Training website at http://www.id-live.com.au/Sharepoint-2010-training-brisbane.aspx
Adrian is a SharePoint Expert with over 14 years enterprise software development experience backed up by excellent business awareness, interpersonal skills, academic qualifications and Microsoft Certifications.
He holds 11 different Microsoft qualifications, including four SharePoint certifications. His educational achievements include postgraduate qualifications in Software engineering, management and environmental sciences.
Adrian relocated to id Brisbane Australia in January 2010 where he is thoroughly enjoying the Australian lifestyle whilst leading and developing the Australian business Intelligent Decisioning - SharePoint, CRM and Workflow at http://www.id-live.com.au
Adrian's latest project is authoring the SharePoint 2010 Power User Cookbook for Packt Publishing - due to be released late 2011.
Article Source: http://EzineArticles.com/?expert=Adrian_Colquhoun He holds 11 different Microsoft qualifications, including four SharePoint certifications. His educational achievements include postgraduate qualifications in Software engineering, management and environmental sciences.
Adrian relocated to id Brisbane Australia in January 2010 where he is thoroughly enjoying the Australian lifestyle whilst leading and developing the Australian business Intelligent Decisioning - SharePoint, CRM and Workflow at http://www.id-live.com.au
Adrian's latest project is authoring the SharePoint 2010 Power User Cookbook for Packt Publishing - due to be released late 2011.
