12

So here is my problem.

I have a site collection. In this site I have a list (ListA) that has lots of columns and lots of attachments and lots of items and over the threshold. I would like to create a copy of this list and place it on the same site collection. So basically duplicate ListA with a ListB. However the export and import functions do not give me the ability I need. I can export but the import function does not allow me to create a new list out of it. If I understand correctly it will overwrite the already existing listA. Is there a way to duplicate a list on the same site collection?

As I write this I thought maybe I could write a workflow that could copy data from ListA to an empty ListB but I don't know how easy that will be.

The list is over its threshold and affecting some outlook client calendar views. I would prefer to just archive and start a new list but that would bring downtime and the archived list would have to still be in use for a while. Many people use it and my client is afraid of all the users getting confused with 2 active lists. So my client wants no down time. So my thinking is to just duplicate ListA to ListB and delete old data from ListA and delete new data from ListB, thereby avoiding downtime.

Any ideas? Some one suggested I export to excel and recopy but this list has tons of attachments so it would not work.

EDIT Saving the list as a template with data will not work because SharePoint limits the content data to 10MB. This list is FAR beyond that. I could save the empty template true ... but I would still be stuck in finding an easy way (outside onetime custom code) to copy data across ...

  • Can I just copy one task? That doesn't seem to be an odd request. – captain obvious Aug 9 '17 at 13:48
  • Can I just copy one task? That doesn't seem to be an odd request. – captain obvious Aug 9 '17 at 13:48
  • on prem or online environment ? – Monica Jagani Aug 9 '17 at 14:48
8

You can create a Site Template to create the copy.

  1. Go to the list settings of the list (ListA)
  2. Click save list template on the right list of links
  3. Save the template as something
  4. Click save list content if you want the same content in the new list
  5. Go to the All Site Content page and create a new list based on the saved template (ListB)

This will create an exact copy. If you move to a new subsite some of the connections like lookup columns may be messed up, but within the same site should be fine.

  • This will not work as the list is over the 10MB limit on content saves. The goal is to not only duplicate the list but the data inside. – fraygos Apr 30 '14 at 17:50
  • Well I think your only option is to make a list template then script the data migration. Shouldn't be too difficult and doing a test list will not affect anything. – Sam Sussman Apr 30 '14 at 17:53
  • yea, that seems to be my only course ... frustrating though ... I wish the import command had a way to generate a new list and not overwrite a list with same info on it ... I assume when you mean Site Template, you mean List Template. – fraygos Apr 30 '14 at 17:54
  • Ahh, yeah that is what I meant. – Sam Sussman Apr 30 '14 at 17:57
  • 1
    just a note, in my o365 tenant i have a doc lib with over 5000 docs. it won't let me save the library as a template, even without contents, – russellg Sep 6 '17 at 0:44
5

You can even increase the maximum size of list templates up to 500 MB (I don't know if it is large enough for you) either via stsadm:

stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 524288000

or via PowerShell as well:

$webservice = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$webservice.MaxTemplateDocumentSize = 524288000 #500 MB
$webservice.Update()

See this post for details.

I suggest you to revert the value back to the original one after saving your list as template.

1

You can export list using export command/central admin. Then rename old list(including url). Import the export taken already.

  • 1
    Does anyone know if this central admin technique works to import the exported list into a different site? – Mister_Tom Feb 19 '15 at 18:51
0

Another option is to use a third-party migration tool such as Sharegate. Most tools out there allow you to migrate libraries and lists content along with their structure.

If you are well-versed in PowerShell it is indeed a very viable option. However, if you prefer not going down the PowerShell route using a migration tool is a great alternative.

In addition to a 1:1 list copy, you can also add metadata, granularly move the content and even change content types, etc. It can also help you overcome the 5000 list item view threshold. These tools are especially useful if you have to do this type of migration regularly.

Most companies offer free trials so you can evaluate their software. You can start with Sharegate by visiting http://en.share-gate.com/download

[DISCLAIMER : I work for Sharegate]

0

If you have a list with attachments that you need moved over you can also save in access, then re-upload to the site using a new name. This will bring the attachments over as well. This may not be the best way for a large list as you may timeout on the download or upload part of the process but I have done this with lists up to 1000 items with attachments.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.