Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Moving big lists

  Asked By: Dana    Date: Jul 23    Category: Sharepoint    Views: 949

In the next days I'll need to move some big lists (6000+ items) with
attachments to a different WSS (all 2003) site.
What is the best way to do this?

Copying and pasting does not work...
Saving the list as a template does not work either (list is too big).



13 Answers Found

Answer #1    Answered By: Jennifer Jones     Answered On: Jul 23

If this is something you will do regularly, you may find DocAve from www.avepoint.com a useful solution. While it is designed for backup/restore, it supports close to drag-n-drop for lists, libraries, etc.

Answer #2    Answered By: Annie Norris     Answered On: Jul 23

No, this is a one time issue and I was thinking in some low-level,
easy, free-as-possible solution.

Answer #3    Answered By: Chadd Hahn     Answered On: Jul 23

Exporting the list to Spreadsheet should get you over your hurdle.

Answer #4    Answered By: Laura Walker     Answered On: Jul 23

How that handles the documents attached?

Answer #5    Answered By: Titus Sweet     Answered On: Jul 23

You should be able to do it with an application using the SPPS Object Model. Look at the wss SDK. since you arre moving  the lists  you may want to rethink your architecture and try to keep the number of list items in one list under 2000.

Answer #6    Answered By: Jagdish Joshi     Answered On: Jul 23

I was thinking on going that route too, time to flex my programming
Is there any "starter kit" (beyond the sdk) or sample that may propel
me into the right direction or save me some time?

The number of list items is beyond my control,I appreciate your
advice. Is 2000 items a limit to respect in 2007 too?

Answer #7    Answered By: Christop Mcfadden     Answered On: Jul 23

Don't know nutin' about 2007 yet. The 2000 limnit is based on SQL performance AFAIK

Answer #8    Answered By: Victoria Bell     Answered On: Jul 23

No database limits in 07 as I recall, but think about the rendering efforts.

Answer #9    Answered By: Cassidy Sharpe     Answered On: Jul 23

You can try using this:

Answer #10    Answered By: Linda Mason     Answered On: Jul 23

It works very well with Doc libs.
With lists  I'm getting an error: "Value does not fall within the
expected range".
I'm checking now the values on some of the choice fields I have there.
I'll post my findings.

Answer #11    Answered By: Hans Weiss     Answered On: Jul 23

I found the problem.
I have a field called "Priority/Risk" and the slash was causing
I changed the code a bit and now it's working well, I'll continue
testing now for the import:

public SerializableListItem(SPListItem item)
ID = item.ID;
foreach (SPField field in item.Fields)
string fieldName = field.InternalName.Replace
("_x0020_", " ").Replace("_x002f_", "/");
if (fieldName.Equals("Attachments") ||
_fields.Add(fieldName, item
catch (Exception exc)

Answer #12    Answered By: Jaime Weaver     Answered On: Jul 23

I got another error when importing.
I modified, the code again, and this works well in all cases (that I

public SerializableListItem(SPListItem item)
ID = item.ID;
foreach (SPField field in item.Fields)
// 10/19/2006 Max, no need for this
//string fieldName = field.InternalName.Replace
("_x0020_", " ").Replace("_x002f_", "/");
if (field.Title.Equals("Attachments") || field.ReadOnlyField)
// 10/19/2006 Max, use "Title" for the name of the field and
// "InternalName" for field content:
//_fields.Add(fieldName, item[field.InternalName]);
_fields.Add(field.Title, item[field.InternalName]);
catch (Exception exc)

Answer #13    Answered By: Anibal Baird     Answered On: Jul 23

Tried and worked well, I had to write a small modification to it (see
my answers on this thread.
The problem still is, the tools does not copy file attachments to
list items.

Didn't find what you were looking for? Find more on Moving big lists Or get search suggestion and latest updates.