HOW TO: Change file extension of an existing item in SharePoint document library

This post is a contribution from Aaron Miao, an engineer with the SharePoint Developer Support team. For various reasons, people want to change the file extension of an existing item in a document library.  For example, with SharePoint 2007, files with JSON extension in document library can be opened without problems.  However, once you upgrade…

5

SharePoint 2010: SQL limitations in lookup columns

This post is a contribution from Balaji Sadasivan, an engineer with the SharePoint Developer Support team. As most of you are already aware SharePoint stores both the person/group field and the metadata fields as lookup values internally. SharePoint dynamically creates a stored procedure to store the lookup values in SQL.  The stored procedure accepts a…

1

HOW TO: Access list item in WorkflowStarting event receiver when “Required documents to be checked out” option is set to “Yes”

This post is a contribution from Charls Tom Jacob, an engineer with the SharePoint Developer Support team. Scenario: You have a SharePoint library in which “Require documents to be checked out before they can be edited?” is set to Yes. You have a WorkflowStarting event receiver associated to the list, with the following very basic…

0

HOW TO: Allow anonymous users to add items to SharePoint list using client object model

This post is a contribution from Charls Tom Jacob, an engineer with the SharePoint Developer Support team. This blog is based on a support ticket I handled recently. The requirement was to let anonymous users add items to a SharePoint list/library using client side object model(JavaScript). Here are the steps needed to implement this. 1….

1

Could not establish trust relationship for SSL/TLS secure channel

This post is a contribution from Amy Luu, an engineer with the SharePoint Developer Support team. You can get the following error when SharePoint communicates to an external service via HTTPS either within the same server or a different server. Could not establish trust relationship for the SSL/TLS secure channel, or Remote certificate is invalid…

3

HOW TO: Generate Document IDs for custom content types with Inherits=False

  This blog post is a contribution from Deepak Kumar, an Engineer with the SharePoint Developer Support team. The “Inherits” attribute of the custom content type when set to “False” indicates that the custom content type will only inherit Fields that were in the parent content type when SharePoint Foundation was installed. Fields that were…

1

How To: Make SharePoint Calendar events recurring by default

  This blog post is a contribution from Charls Tom Jacob, an engineer with the SharePoint Developer Support team. By default, new events added to SharePoint calendar list are not set to be recurring. If all the events users create are going to be recurring, it would be convenient to have this checkbox checked by…

6

HOW TO: Delete AD group from SharePoint site collection using web services

This blog post is a contribution from Bharat Rathod, an engineer with the SharePoint Developer Support team. I recently worked on a project where we had to delete an AD group which has permissions on a specific site collection.  Since we had a limitation to not use server object model, I used web services to…

0

HOW TO: Programmatically delete a single instance of a recurring event in a SharePoint calendar

This blog post is a contribution from Kevin Jacob Kurian, an engineer with the SharePoint Developer Support team. When we edit a single instance of a recurring event, it actually creates a new instance of the event and deletes the old one.  The old instance is deleted by setting certain attributes of that particular instance. …

3