Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SharePoint Import and Export

Posted on 2012-04-10
5
Medium Priority
?
852 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 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

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…
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .

926 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