Solved

SharePoint Import and Export

Posted on 2012-04-10
5
761 Views
Last Modified: 2012-05-09
Hi Experts,

I am trying to move a site's document library to another location and hence am using the stsadm utility. However, export and import does not seem complete because after importing, I am finding that not all the content are transferred. There were 2 warnings and 1 error but I am missing like a few thousand records.

2 warnings was for web part, which is ok. And the error for 1 record, I am not sure.

I am suspecting that the export did not even export everything. Could these be a privilege issue or what is the problem?

Could some experts help to point me in the correct direction. Thx.

rgds,
Nickson
P.S. I am Sharepoint 2007 Enterprise SP2 and the document library is abt 600GB.
0
Comment
Question by:NicksonKoh
  • 3
  • 2
5 Comments
 
LVL 10

Expert Comment

by:ImaCircularSaw
ID: 37831534
Which STSADM command are you using?

It's been a while since I tried this but when I last did there was no list level exporting available without extending the functionality of STSADM.
0
 
LVL 17

Author Comment

by:NicksonKoh
ID: 37835468
I am simply exporting the entire site because the whole site only contain document libraries with

Stsadm -export - URL...

My apologies I guess I should say I am doing a site migration.

I also realized my problems are because there are some files with very long file names and it could not be imported.

I have also tried saving each doc lib as a template with error and seemingly also due to the long file name.

Pls advise. Thx.
0
 
LVL 10

Accepted Solution

by:
ImaCircularSaw earned 500 total points
ID: 37836560
Hi there,

If you have URLs which are over the acceptable length then you're going to have to shorten the list item names.  There is not a lot else you can do about that one.

You'll probably find that large lists cannot be saved as a template with content as there is a small limit on the size of a list.  I think it's around 10MB.  To change this follow these instructions:

http://www.sharepointconfig.com/2007/05/increasing-the-maximum-size-of-list-templates/


If you're still having issues I would recommend extending STSADM and copying across lists individually.  Here are some instructions I've previously written for this:

------------------------------------------------

SharePoint does not, out of the box, offer the ability to backup individual lists.  Someone has written their own STSADM extensions that support importing/exporting/copying of lists.
 
You can find the download here:  http://stsadm.blogspot.com/2009/02/downloads.html
Please use the appropriate one –  The instructions for installing them are under each link.
 
Once the extensions are installed you will have to use STSADM to run them.
 
1.      Log onto the source server using remote desktop and open a command prompt.

2.      Browse to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN (note:  If STSADM is registered in your environment variables, ignore this step.

3.      Use the following command to export a list:

 

C:\>stsadm -o gl-exportlist -url "http://<siteRoute>/<site name>/Lists/<list name>/AllItems.aspx" -filename "c:\listbackup"

 

4.      Move the file that was created to the target server.

5.      Login to target server using remote desktop and open a command prompt.

6.      Browse to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN (note:  If STSADM is registered in your environment variables, ignore this step.

7.      Use the following command to import a list:

 
C:\>stsadm -o gl-importlist -url "http://<siteRoute>/<site name>/Lists/<list name>/AllItems.aspx" -filename "c:\listbackup"

 
I have used these steps and managed to take a backup of all list items from one list and imported them to an identical list (situated on a different site).  To see a list of all the switches/parameters you can use simply type STSADM –o gl-importlist or STSADM –o gl-exportlist – the –updateversions parameter looks useful as you can use 1/2/3 to add new version/overwrite versions/ignore duplicate version respectively.
 
Here is the full documentation of the extensions as provided by the developer:  http://stsadm.blogspot.com/2007/09/importexportcopy-lists.html
0
 
LVL 17

Author Comment

by:NicksonKoh
ID: 37837749
Hi ImaCircularSaw,

Looks very useful. By list do you also refer to document library?
0
 
LVL 10

Expert Comment

by:ImaCircularSaw
ID: 37843374
Yes...kind of.

A Document Library is just a list template that comes with SharePoint.

I think you would find one of my previous answers really useful in understanding the core of what SharePoint is:  http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_26863493.html
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now