Solved

SharePoint Import and Export

Posted on 2012-04-10
5
824 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 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
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…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

634 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