Solved

SharePoint Import and Export

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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. …
A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

825 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