Tuesday 9 December 2014

How To – Export Import a SharePoint 2010 list (across site collections/farms)


After perfecting a generic custom list (calculated column variables, multiple filters and a few other column specific features) I now needed to export the list to another sit.
This can be done by one of two ways:
Either by SharePoint’s Central admin console, alternatively one can use the PowerShell command to complete this.
After attempting the PowerShell method I found it to more comprehensive and easier to work with than the PowerShell method (basically there’s a decent UI that the SharePoint 2010 dev team have created around this)
So anyway the following steps will get you there:
  1. Navigate to Central Admin
  1. From the Central Admin screen – select ‘Backup and Restore’

http://red1s.files.wordpress.com/2011/09/clip_image0014.png

Form here click ‘Export a site or list’ from the Granular Backup links:

http://red1s.files.wordpress.com/2011/09/clip_image0023.png

Select the relevant Site collection from the drop down
  1. 2 things I’ve noticed here as an upgrade from MOSS is:
    1. The overall ‘readiness’ of whether a component can be exported based on a current export being run or a timer service being completed
    2. nice use of dependant dropdowns

http://red1s.files.wordpress.com/2011/09/clip_image0033.png


Once you’ve selected the Site collection, site and list select a file location (note the .cmp file extension and the fact that it needs to be a network location)

http://red1s.files.wordpress.com/2011/09/clip_image0043.png


  1. Select the type of Security you want the list to have – in my case I didn’t select this as I needed to use the list in different scenarios 9but you might need to)
http://red1s.files.wordpress.com/2011/09/clip_image0052.png
  1. Select the version number: (I didn’t need to as I’m sure that this is the last time I’d modify the list)

http://red1s.files.wordpress.com/2011/09/clip_image0062.png

You’re now good to go and can hit ‘start Export’

http://red1s.files.wordpress.com/2011/09/clip_image0072.png

Once you’ve started the Export, you’ll get a screen notifying you about the status:

 http://red1s.files.wordpress.com/2011/09/clip_image0081.png

 And then an outcome screen: (letting you know whether the job was/wasn’t successful)

http://red1s.files.wordpress.com/2011/09/clip_image0091.png


Once done you’ll notice 2 files:
The actual file
And a log file which is handy in case things don’t go so well:
clip_image010
Now that you have you list as an exported site, unfortunately SharePoint 2010’s Central Admin doesn’t have a UI to facilitate the importing of this (neither did MOSS 2007) so you’ll have to use PowerShell (though I’m pretty sure you can use STSADM as well)
  1. Once you’ve fired up handy ol’ PowerShell plug the following command into the console:
Import-SPWeb –Identity <url> -Path <path> -includeusersecurity –force
  1. After running it, you should get an output message and that a log file was generated:

http://red1s.files.wordpress.com/2011/09/clip_image011.png


  1. Upon navigating back to your SharePoint list you should notice it on the root /homepage of your site which is where it was imported to:
clip_image012
You’re also able to complete the entire process using just PowerShell, which is especially useful for completing a number of these tasks


Reference:

http://red1s.wordpress.com/2011/02/04/how-to-export-import-a-sharepoint-2010-list-across-site-collectionsfarms/

No comments:

Post a Comment