Category Archives: Content Deployment
Content Deployment was failing with the following error in the logs:
Title: Field name already exists. The name used for this field is already used by another field in the list. Select another name and try again.
Object: User Information List
We had a publishing site that was upgraded from SharePoint 2007 to SharePoint 2010 that was using content deployent from a staging site to a deployed site.
We could see using SharePoint Manager 2010 that we had duplicates in the destination site that were not in the source site.
We opened a job with Microsoft and we found someone with a similar issue on the msdn forums
Microsoft gave us an executable ‘RemoveDuplicateColumn64‘ to remove the duplicates, we ran it for each duplicate.
The exe prompts you for all the required parameters, one of which is the duplicate internal name which in our case was FirstName0, again we used SharePoint Manager to find the internal name.
We have no idea how these duplicates got there but since removing them a couple of months ago there have been no problems with the content deployment.
This problem could likely be avoided by using the new snapshot content deployment available in SharePoint 2010.
My client had the requirement to bulk approve or reject items in a document library or list. Using document sets wasn’t the solution as the only thing they had in common was that they all need to be approved at the same time.
I found this excellent solution from Sohel’s blog which was almost perfect…
It handles workflow if they are running which other solutions I found didn’t. One limitation was that it only worked for document libraries, not lists.
All I needed to do was update the elements file to below and I had it on both document libraries and lists.
Description=“Uses the notification area to display a message.“
Alt=“Approve multiple items“
ScriptSrc =“/_layouts/SharePoint.ApproveRejectTest/Scripts/ApproveReject.js” />
If you are migrating your SharePoint site to a new domain or if you have parallel environments in another domain (e.g. for testing, development etc.) You may wish to move a content database and all its permissions to the new domain.
Here is an easy way to do it.
- Create a SQL backup of the source content database
- Stop the SharePoint services on the destination server
- In SQL Management Studio restore the content database back over the destination content database
- Start the SharePoint services on the server
- Run the user migration script by SharePoint Voodoo. WARNING:- Users need to exist in both the old and new domain.
- You may need to go into SharePoint designer and resave and republish your workflow, if you don’t you may get a ‘user not found’ when starting a workflow or accessing workflow settings
P.S. I doubt if this is the Microsoft recommended method! You could also run a content deployment from the source to destination server.
To perform a successful initial content deployment from a publishing site the destination has to be an empty site.
This is not to be confused with the <blank> site template.
I have had some success when picking the <choose template later> option in the site creation page in Central Admin but sometimes even this fails.
The only sure way of creating a blank site is to use the following stsadm command
STSADM.EXE -o createsite -url <site-collection-url> -ownerlogin <domain\username> -owneremail <email@address>