We have a list in sharepoint 2007 that we need to move to another site which is based on sharepoint 2010.
what's the best and fastest method?
thanks in advance
If you read this article by Thao Nguyen at Bamboo Solutions you will find 4 different methods for migrating a list from SharePoint 2007 to SharePoint 2010. My preferred method is number 1:
Method 1 - Migrate a single list from SharePoint 2007 to 2010 using a list template
This works well for me becacuse I can write a bit of powershell to automate most of the process.
the best way is to export the list to a spreadsheet in 2007 and then import that xslx file in 2010. I found this article very useful:
by the way, I faced a problem when exporting to excel if the site is using forms based authentication with the error message: "Excel Cannot access sharepoint list"
one more thing, Make sure you have the fields visible in the view before you export to spreadsheet since non-visible fields will NOT be included.
I just had good success using Microsoft Access to move a list from a SharePoint 2007 site to a SharePoint 2010 site.
I opened Access 2010, and created a blank database.
Under the External Data tab on the ribbon, under the More drop down, I selected Import or link to a SharePoint list.
In the Get External Data pop-up, I entered the URL of the SP 2007 site that held the list and selected the "Import the source data into a new table in the current database" and pressed Next.
On the next screen I selected my list, and selected "All Columns" for Items to import.
Now the list is in a table in the database. The table has the same title as the list.
Right-click on the new table, select Export, select SharePoint list, and enter the destination site (SP 2010)
For upgrading the list templates (being migrated from MOSS 2007 to SharePoint 2010) either you have to manually upgrade them by hand or using some PowerShell to upgrade them. Even if you upgrade them using PowerShell, there is no way to automatically upload (the upgraded template) them back to the site collections where they belong to:
I have done the PowerShell which performs the following 4 tasks:
Full code can be downloaded from CodePlex: https://upgradelisttemplates.codeplex.com/
Technet Gallery: http://gallery.technet.microsoft.com/Upgrade-List-Templates-0b86f443