Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SharePoint Import and Export

Posted on 2012-04-10
5
Medium Priority
?
841 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1500 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

722 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