Friday, February 3, 2012

Export and Import a SharePoint List

This was a requirement one of my clients faced few days back. So I thought of writing blog post on it so anybody can refer to it when needed Smile .

Exporting a SharePoint List can be done with the OOB feature given in SharePoint Central Administration.

Central Administration >> Backup and Restore >> Export a site or list

image

In the above image you can see…
1. You can backup a site
2. You can backup a list
3. It supports of exporting with full security
4. Exporting with the item versioning (Major / Minor / Both / Current)

image

OK fine exporting can be done through the UI. How about Importing? Time to move on to PowerShell. Prior to that let’s see how to achieve the Exporting through PowerShell.

Export-SPWeb “http://spdev:4422/netassist/” –ItemUrl “Lists/Students” –Path “C":\SharePoint Backup\StudentsList.cmp”

Now the Importing.. (I’ve used a SubSite “network” for the clarity)

PS C:\Users\SPAdmin> Import-SPWeb “http://spdev4422/netassist/network/” -Path "
C:\SharePoint Backup\StudentsList.cmp"

For more info read the TechNet Articles.
Export
Import

13 comments:

Unknown said...

Hi very nice post and i have gain lot of information from this article and i am also sharing the new information with you people IIEIM The executives of today need to constantly evolve and understand the needs of the international market. An ability to understand, strategic, plan and execute ideas and knowledge is primary for success.Import and Export

Unknown said...

hi this is very nice post.
I am very Glad read about this article. Here I am sharing with you Great information about
Import and Export Courses | IIEIM
The Institution, Indian Institution of Export and Import Management (IIEIM) was founded in December 1990 as a CAUSE GROUP with GLOBAL PERSPECTIVE.
Please Give comments and Reply for this great information.
Thanks

Unknown said...

hi this is very nice post.
I am very Glad read about this article. Here I am sharing with you Great information about
Import and Export | IIEIM
IIEIM Programmes... UNIQUE!!! The Programmes aim at providing a comprehensive coverage incorporating all important subject areas and disciplines relevant to International Marketing / Business activities.
Please Give comments and Reply for this great information.
Thanks

Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.