6

Is there a good free way of exporting a list in SharePoint 2010 and importing it into 2013.

Need to keep structure, data, attachments and other data but revisions, permissions etc not necessary.

I've seen this question which talks about extracting the powershell export file, changing the manifest, re-cabing and then importing but have not tried it yet.

3
  • you can try this one, might work spdeploymentwizard.codeplex.com Feb 27, 2013 at 14:54
  • @TimeToShine - the link you gave is for 2010 content migration. Not applicable for this question
    – Andrey
    Feb 27, 2013 at 21:07
  • @Andrey Thats the reason I said "it might work" :) Feb 27, 2013 at 21:26

4 Answers 4

5

Using Export and Import, you can migrate list from SP 2010 to SP 2013 but you have to make some manual changes.

  1. Export the list from SharePoint 2010 using either the Central Administration or PowerShell (Export-SPWeb). In the Central Administration, go to Backup and Restore > Export a site or list. Choose your list, and click Start Export

  2. Copy the exported list (.cmp file) to your desktop and change the extension to .cab. You can then extract it using a software like WinRar.

  3. Open the SystemData.XML file with an editor like NotePad++ and change the version from 14.0.0.0 to 15.0.0.0 , and the build version from your 14.0.x.x to 15.0.x.x (depending on the build you have on both your farms).

  4. Now we have to repackage it as a .cab file. I used a software called CabPack. Select your Source and Destination. Change the CabinetNameTemplate if you want, and click on OK.

  5. Change the extension from .cab to .cmp

  6. Copy the .cmp file back on the network share or directly on the SharePoint 2013 Server. Open SharePoint 2013 Management Shell as an administrator. Run this command by changing the parameters of course!

Import-SPWeb "SiteCollection Name" path c:\backup\Customers.cmp

  1. Open up your SharePoint Site and your list should be there.
1
  • What if I had multiple .cmp files on a single list of library? The System.Data.xml file lies in the last file. But when I edited it and tried to import I get the following error: "[5/30/2017 2:28:44 PM] [Warning] Import requirement file Requirements.xml was not found no verifications ran. [5/30/2017 2:28:44 PM] [FatalError] [-2147467261] [System.ArgumentNullException] [Value cannot be null. Parameter name: input] "
    – devnation
    May 30, 2017 at 12:50
1

I have used Gary Lapointe's utilities to move content between farms in the past. The GUIDs can change so anything tied to that, like web parts, custom features, etc.. might break. Ironically, I asked Microsoft a few weeks back if they could recommend a full fidelity way to move partial content between farms and they could not. I found that rather frightening but perhaps expected given the possible complexity in SharePoint.

4
  • Between different versions of SharePoint?
    – Ryan
    Feb 28, 2013 at 1:12
  • I have not used it in that capacity directly but it should work as that tool uses its own export/import logic rather than relying on SharePoint. It should be tested in a Dev/QA environment first though.
    – Dave Wise
    Feb 28, 2013 at 16:53
  • I think he must actually use SharePoints built in ones with a few additions looking at the stack trace of some errors.
    – Ryan
    Feb 28, 2013 at 21:19
  • 1
    Couldn't get this to work - complained about differing versions (just as the OOTB Import-SPWeb one does) and tried changing Version and Build in SystemData.xml but still didn't import correctly moss-arvit.blogspot.co.uk/2010/11/…
    – Ryan
    Feb 28, 2013 at 21:20
0

Have you try the Export-SPWeb and Import-SPWeb powershell commands??? I don't really know if that works but it is a posibility.

1
  • 1
    yes - you can't export one version of SP and import to another.
    – Ryan
    Mar 6, 2013 at 14:28
0

Use the Export-SPWeb and Import-SPWeb to copy the list to a new 2010 content database on the source server.

  1. Create a new site collection. (UI or PowerShell)

  2. Export from Source site

  3. Import into destination site (All ID's do stay intact)

  4. Backup the New 2010 Content database with the list in it.

  5. Restore the New 2010 Content database on the SP 2013 SQL server.

  6. Mount the 2010 Content database which will upgrade the content database to 2013.

    Mount-SPContentDatabase -Name 2010ContentDatabase -DatabaseServer SP2013Farm\SharePoint -WebApplication http://sp2013farm/
    
  7. Upgrade the site collection by Navigating and select Upgrade Site.

If you need the list in an existing site collection you can then export the list in 2013 and import it in to the existing site collection.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.