[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Sharepoint 2007 - Move List to different site

Posted on 2016-08-25
11
Medium Priority
?
45 Views
Last Modified: 2016-09-18
Hello, need to move a list to different site within the same server. Usually would save as template with content and create a new one from that template.
This list is big (about 10k entries) and Sharepoint would not allow me to save it as template w/content.
Any workarounds? Is there better way to move the list?
Thank you.
0
Comment
Question by:IvanY
[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
11 Comments
 
LVL 20

Expert Comment

by:Serena Hsi
ID: 41770896
Do you have design rights to the List Template Gallery? Contributor role is not enough privileges. If not, you should enable that for the user (you?) who is trying to save the template.  Design roles can be granted on the List Template Gallery, Site Template Gallery, and also at the top level site.
0
 

Author Comment

by:IvanY
ID: 41770928
I'm logged in as an Administrator. I'm assuming Administrator has all permissions? Or should I add Design Rights to an Administrator's account?
0
 
LVL 15

Expert Comment

by:Ajit Singh
ID: 41771492
Yes, user should have design rights to save the template in template gallery. Look into this thread for more information.

- Create new Permission level with ‘Manage Lists’ and ‘View Items’ options checked under ‘List Permissions’. Also, check the ‘View Pages’ and ‘Open’ permissions under ‘Site Permissions’.
- Go back to Site Settings > Site Permissions and create a new custom group. Leave the group empty.
- Go back to the Site/List Template Gallery > library permissions and click ‘Grant Permissions’.
- Bring up the directory window and type the name of the custom group you created in the previous step.
- Select the ‘Grant users permissions directly’ radio button and check the new Permission level created above.

Hope this helps!
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 20

Accepted Solution

by:
Walter Curtis earned 2000 total points (awarded by participants)
ID: 41771712
There is a data size limit for saving lists as a template. These two links are some information about how to modify (increase) that limit.

http://www.sharepointconfig.com/2007/05/increasing-the-maximum-size-of-list-templates/

https://www.wicservices.nl/increase-the-maximum-list-template-size-in-sharepoint-2010-using-powershell/ 

Hope that helps...
1
 

Author Comment

by:IvanY
ID: 41772173
Thank you! I thought that was it! I ran
stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 520288000,
which would increase the size limit to ~498Mb. I had "Operation Successful" message at the end.
But when I go to "Save List as a Template" I still have "Include Content" greyed out. Just on this list.
I kind of doubt that this list is over 500Mb - is there way to check the size?

It's not permissions - I have no issues saving other lists with content under the same credentials.
0
 

Author Comment

by:IvanY
ID: 41775002
Anyone?
0
 
LVL 20

Expert Comment

by:Walter Curtis
ID: 41775012
It is possible that the list is over 500mb, if you double the limit it may work for you.

Alternatively, what type of data is this. Would it be possible to export the data to excel, then save the template without data, create a new list in the new SharePoint using the template and import the data back in to the list from the excel dump.

Just an idea...
0
 
LVL 20

Expert Comment

by:Walter Curtis
ID: 41777087
Any luck?
0
 

Author Comment

by:IvanY
ID: 41777103
Nope. Excel dump was messy. Some fields didn't go  where they should have.

I tried the template thing again. I ran: STSADM.EXE -o setproperty -property name max-template-document-size -propertyvalue 920288000

and got : "The specified value for maximum template document size is not valid. Please specify a positive number less than 524288000."

I think there is a hard limit to 500Mb. Still don't know to to check the size of that list to see if it's above 500Mb.

Any other ideas? There's gotta be a better way to move the list with content
0
 
LVL 20

Expert Comment

by:Walter Curtis
ID: 41777140
Not sure about 2007, but in 2010 and above you can view storage usage from Site Actions --> Site Settings --> Storage Metrics

This will give you a breakdown of the contents of the site collection. I am sure 2007 has something similar.

You may also be able to back up the list via SPBackup and restore in a different location. The size limit there would be 20gb. Stsadm would be the tool to use for that.

As a last resort, Sharegate is a third tool for migraitons and moving lists and such. It has a 14 day almost fully functional trial version. It will copy the list to a different locations fine, but will only randomly copy about %98 of the data. (Purchased versions does it all of course.)

Hope that helps...
0
 
LVL 20

Expert Comment

by:Walter Curtis
ID: 41803566
Solution was accurate and valid.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

650 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