I started this series to show how to copy different kinds of lists in SharePoint. Each type of list has its own challenges. In this article I will also demonstrate how to copy custom fields and keep the same internal name. It’s kind of annoying that you can’t create a field with the internal name you specify, but I found a pretty easy workaround. You create the field using AddFieldAsXml on the list Fields collection, and you use the internal name as the display name. This creates the field with the...

• Share This Post:
• 
• 
• 

The fantastic 40 templates from Microsoft can cause issues with content deployment. The following error prevents content deployment with the templates installed: 1. The content type name cannot contain: \ / : * ? " # % < > { } | ~ &, two consecutive periods (..), or special characters such as a tab. at Microsoft.SharePoint.SPCont... name) at Microsoft.SharePoint.SPCont... strVal, String& strLocalized) at Microsoft.SharePoint.SPCont...

• Share This Post:
• 
• 
• 

The following error can occur during content deployment: The changeToken refers to a time before the start of the current change log. The changeToken refers to a time before the start of the current change log. at Microsoft.SharePoint.Deploy... minChangeTime, Int32 minChangeNumber) at Microsoft.SharePoint.Deploy... at Microsoft.SharePoint.Deploy... at Microsoft.SharePoint.Deploy...

• Share This Post:
• 
• 
• 

When I needed to read an Excel spreadsheet from a SharePoint site, it seemed like a simple enough request. Previously, whenever I needed to open an Excel file, I used an OleDb connection with the following connection string: string connectionString = @"Provider=Microsoft.ACE.OL... Data Source={0};Persist Security Info=False; Extended Properties=""Excel 12.0;HDR=YES"""; connectionString = string.Format(connectionStr... filePath); Of course, you can't open the file from the SharePoint site this...

• Share This Post:
• 
• 
• 

I've been working with the SharePoint API lately. One of my tasks is to copy SharePoint lists from one site to another site. This can be done in code as long as the two sites are on the same machine. It's OK if they are in different web applications, but it can't be from one server to another. If you need to copy from one server to another, you either need to do an export/import, or find a way to save the settings and import them on the new machine. I believe you can use the SharePoint Web Services...

• Share This Post:
• 
• 
•