MOSS 2007 Site Content and Structure: Copy vs Move

Monday, September 28, 2009 7:01 PMacgSP

0
Sign In to Vote
When using Site Content and Structure to copy/move list items to a new list within the same site, which method is best. Will I receive different results if I select copy vs move?

Background and Previous Steps:
The customer would like to move items from a custom list to a Task list to receive alerts when tasks are assigned.
I create a new task list, created new columns based on the custom list. Then used Site Content and Structure to copy items to the target list. As a result, the target (Task list) had duplicate column names, missing data and no views where copied over.
- Reply
- Quote

Answers

Friday, October 09, 2009 2:36 AMvksampath

0
Sign In to Vote
Certain field types (eg., richtext, custom fields...) will put your datasheet view in read-only mode. You can try SharePoint content deployment wizard or Gary's stsadm extensions to do an export/import of your list. Saving the list as a template will not retain all the necessary information (eg., modified by, created by, file versions etc. will be lost).
http://vksampath.blogspot.com/
- Marked As Answer byXue-Mei Chang-MSFTMSFT, ModeratorWednesday, October 14, 2009 3:07 AM
- Reply
- Quote

All Replies

Tuesday, September 29, 2009 2:26 AMEric LegaultMVP

0
Sign In to Vote
Are moving these list items part of a one time operation or necessary in their business process? Moving or copying will be problematic if the columns differ in any way. Instead, you may want to create Views in both Lists that contain only the columns you need, then copy and paste using the datasheet view. This way the columns can have different names, but you probably want to ensure that the data types match.

You could also look at saving the source list as a List Template (saving the content with the field definition) and creating a new List based on that template. Other options that work great are linking the lists in Excel or Access for easier data manipulation.
Eric Legault: MVP (Outlook), MCTS (SharePoint) -- Owner, Collaborative Innovations (http://www.collaborativeinnovations.ca)
- Reply
- Quote
Tuesday, September 29, 2009 3:58 PMacgSP

0
Sign In to Vote
I tried all of your solutions

1. Copied content items using datasheet view. Error received - The selected cells are read-only. How do I copy content using datasheet without receiving the read-only error message?

2. Saved the source list as a template, however source list is not a Task List. Therefore, I created a content type with the same columns and added the columns from existing site. Used Site Content and Structure to copy the content. It moved some content but dropped the other like Primary Contact. The column has the same data type and pulling from People Only groups.
- Reply
- Quote
Wednesday, September 30, 2009 2:27 AMEric LegaultMVP

0
Sign In to Vote
What's the data type for those fields that are giving the read-only error?

I would strongly suggest you do your data manipulation in Excel or Access.
Eric Legault: MVP (Outlook), MCTS (SharePoint) -- Owner, Collaborative Innovations (http://www.collaborativeinnovations.ca)
- Reply
- Quote
Friday, October 09, 2009 2:36 AMvksampath

0
Sign In to Vote
Certain field types (eg., richtext, custom fields...) will put your datasheet view in read-only mode. You can try SharePoint content deployment wizard or Gary's stsadm extensions to do an export/import of your list. Saving the list as a template will not retain all the necessary information (eg., modified by, created by, file versions etc. will be lost).
http://vksampath.blogspot.com/
- Marked As Answer byXue-Mei Chang-MSFTMSFT, ModeratorWednesday, October 14, 2009 3:07 AM
- Reply
- Quote
Thursday, October 22, 2009 12:03 AMPANoone

0
Sign In to Vote
@acgSP What is it that you're trying to achieve? Why would you copy list items from a custom list to a task list in order to receive alerts? Seems all you require is a basic workflow. Is this because the client used the wrong kind of list to start with?
If at first you don't succeed, ask an MVP. Or find someone who really knows. ;)
- Reply
- Quote
Friday, October 23, 2009 9:52 AMspmigrator

0
Sign In to Vote


SharePoint Migration-------- Just like Air!

SharePoint Migration has become so easy by using Xavor’s SharePoint Migrator. I have used that personally by free downloading from Xavor’s website. The software can migrate tons of terra bytes of data from WSS 3.0 to MOSS 2007. Besides that, I have found another useful tool in their website named as SharePoint Admin Tool that allows site administrator one click access to a set of useful administrative tools like check access of security principle and add web part options. Both Softwares can be downloaded from the following link for absolutely free.

http://www.xavor.com/whatwedo/solutions/OneClickSharepoint.aspx

Here are the links for further details of both software products.

http://www.xavor.com/whatwedo/solutions/sharepointmigrationtool.aspx

http://www.xavor.com/whatwedo/solutions/xavorsharepointadmintools.aspx
- Reply
- Quote