Thursday, September 20, 2012

Migration of Office 365 SharePoint Lists to Share Point 2010


Recently I got an opportunity to work with 'Microsoft Office 365'. An important question rises here is 'What is office 365'? Microsoft office 365 is a collection of a office tools such as Microsoft Lync, MS SharePoint, Microsoft Exchange, Offic online etc on a cloud. 
While working on office 365, I realized that I need to create some web-parts and I want the same SharePoint Lists present on Office 365 on my local SharePoint environemnt. But the main hurdel was how to download all those Lists  :(

The following are the of steps that I performed to export lists present in my Office 365 SharePoint environment;

1. Go to your SharePoint Team site of Office 365 and open the SharePoint Designer.
2. Select the 'Lists & Libraries' option and select a particular list that you want to export.
3. After selecting the list, click on 'Save as template' option present in the ribbon.
4. Now SharePoint designer will take you to your SharePoint team site 'Save as template page'.
5. Enter the file name, template name and check 'include content' option and click OK.
6. Now go to the Site Actions->Site Settings->List Template(Under Galleries).
7. Download your list template(.stp file) that you created in step # 4 by clicking it.

The following are the lists of steps I performed to import lists in my local SharePoint 2010 environment;

1. Go to your SharePoint Team site.
2. Click Site Actions->Site Settings->List Template.
3. Click on Documents ribbon and select 'Upload Document'.
4. Select your .stp file and click OK.
5. Now to create list from this List template, go to Site Actions->More Options->List. Select your list template and then name your List and click  'Create'. Now a new list will be created along with content. :)

Notes:

1. Lookup columns may not work properly. Delete the column and create it manually.

2. If your Office 365 Online SharePoint is in other language such as German and the local Share Point environment is in English then follow this link :