Monday, December 30, 2013

Creating site column declaratively

Hi All,

Please find below site columns type normally helpful while creating site columns declaratively.

Type of field
Field Type
Single line of text
Multiple lines of text
Choice (menu to choose from)
Single Choice (dropdown or radio buttons):

Multiple choices (check boxes):
Date and Time
Hyperlink or Picture
Person or Group
Single User or Group

Multiple Users or Groups

Sachin K.

Friday, December 27, 2013

SharePoint Site Columns and Site Content Type Customization Best Practices

Hello All,

While creating Site Columns and Content Types we may came across a scenario that which option to go with.

1. Browser Based Custom Development
2. Feature Based Custom Development
3. Object Model-Based Custom Development

Please refer to this post  to see the best practices and pros and Cons of each approach while creating Site Columns and Content Types.

Sachin K.

Friday, December 6, 2013

Deciding between apps for SharePoint and SharePoint solutions

Hi All,

Please find below higher level decision table to go with apps for SharePoint and SharePoint solutions-

Apps for SharePoint
SharePoint Solution
If you are building for Office 365, the choice is pretty clear that apps are the way to go.
If you are building a customization for the Central Admin, then a full-trust solution is the way to go.
Apps do not require you to do this at the same scale as full-trust code due to their loosely coupled nature.
Typically full-trust code must be reevaluated when you are upgrading SharePoint to ensure that the customizations will not negatively impact the upgrade to the next version.
Apps require you to just understand the object model you are using because an app will not impact the performance or stability of the SharePoint environment.
Full-trust code requires a deep understanding of the internal workings of SharePoint to build stable and scalable solutions.

Application lifecycle
Due to the isolated nature of apps, apps, in most cases, will not require that your application lifecycle processes test the SharePoint environment and other customizations along with your app.
Full trust code requires extensive lifecycle management processes and procedures to not only make sure the app itself works as expected, but to insure that the SharePoint environment including any other full trust customizations is also stable.

Sachin K.

Monday, December 2, 2013

Save (Not Permitted) Dialog Box

Hi All,

Some times you may get following error when modifying any SQL table 

"Saving Changes is not permitted. The changes you have made require the following tables to be dropped and re-created...."

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.



Sachin K.

Friday, November 8, 2013

SharePoint Online: software boundaries and limits

Hello All, 

Please refer to below mentioned article describes some important limitations that you might need to know for different SharePoint Online plans in Office 365. 

For example, it provides information about number of supported users, storage quotas, and file-size limits. This article covers a range of plans: SharePoint Online in Office 365 Small Business and in Office 365 Enterprise, plus standalone plans. 

Click HERE to read full article. 


 Sachin K.

Thursday, October 10, 2013

View MS Access table data in to Excel SharePoint 2013

Hi All,

Please find below excellent article on how to visualize Access data to excel.

Click here to view the article.



Tuesday, October 1, 2013

Sorry, apps are turned off. SharePoint 2013 App installation

Hi All,

If you are trying to install APP from SharePoint App store and getting following error

"Sorry, apps are turned off. If you know who runs the server, tell them to enable apps."

Then Please follow approach mention Here


Monday, September 30, 2013

SharePoint 2013 Online Document set missing columns on edit and view property page

Hi All,

If you ever came across a scenario where you are missing some columns on to Edit item or view property page for a SharePoint 2013 online site then please refer to following post.

Here bill Burke has explained, the resolution he found and it works fine for me as well.

Thanks bill for the wonderful post.


Tuesday, September 24, 2013

Get first day of previous month on JavaScript

Hi All,

Please find below javascript code to get the first day of the previous month

var ourDate = new Date();
//roll it back to the last day of last month
//now that we’re in the proper month, let’s go back to the first day…
// and now we have it


Sachin K.

Friday, August 9, 2013

SharePoint 2013 Limits And Boundries

Hi All,

Please find below information to help you understand the capacity limits of SharePoint Server 2013.

Web Application limits

Maximum Value
Web Application
20 per farm
5 per web application
Managed path for path-based site collections
20 per web application

List and library limits

Maximum Value
List row size
8,000 bytes per row
File size
2 GB
30,000,000 per library
Major versions
400,000 (If you exceed this limit, basic file operations—such as file open or save, delete, and viewing the version history— may not succeed)
Minor versions
30,000,000 per list
Bulk operations
100 items per bulk operation
List view threshold
Coauthoring in Word and PowerPoint for .docx, .pptx and .ppsx files
10 concurrent editors per document
Security scope
50,000 per list

Thanks & Regards,
Sachin K.

Tuesday, May 14, 2013

This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator

Hi All,

The purpose of this threshold is to ensure SharePoint servers can run reliably and not get overwhelmed, so performance is 

not affected.

If you exceed this threshold, the above issues can occur:

Please refer to the link to over come this scenario.

In my case using Key Filters for rapid filtering work

Sachin K

Monday, April 8, 2013

sharepoint 2013 login as a different user

Hello All,

I was testing the application I developed in SP 2013 and I observed that SP2013 is no longer having sign in with diffrent user link.

I found the workaround to overcome this situation:-


append above url to your SharePoint site URL and it will openup the popup which ask you for the credentials.

Sachin K.

Failed to create term set: A default managed metadata service connection hasn't been specified SharePoint 2013

Hi All,

SharePoint 2013 has new feature that allow you to save your custom navigation in the Managed Metadata Service Application. I was playing around it and faced the following issue very first time when I tried to enable the managed navigation.

To resolve this issue navigate to central administration-->Manage Service Applications. In that click on Manage metadata service and select properties option.

Check the box next to “This service application is the default storage location for column specific term sets.” 

Now you should be able to create Term Set when enabling Managed Navigation.

Sachin Katkar.

Friday, March 15, 2013

Sandbox solution FileLoadException An Operation is not legal in the current state.

Hi All,

If you are referring to some external assembly file in to your sandbox solution and getting "FileLoadException - An Operation is not legal in the current state" exception when debugging the code, Then it might be the case 
that your manifest.xml file of your package is missing the reference to the assembly.

To Add reference in manifest.xml file

1. Open Package.Package file from solution explorer.

2. Click on advance button present at the bottom.

3. Add the reference to your external assembly and save it.


You should now able to debug and run your sandbox code.

Sachin K.

Wednesday, March 13, 2013

Error occurred in deployment step 'Install app for Sharepoint': The application identifier is invalid, it must be a valid GUID.

Hi All,

If you tried to create a basic provider-hosted app that is hosted on Office 365, and you got this error message when deploying the app

Error occurred in deployment step 'Install app for Sharepoint': The application identifier is invalid, it must be a valid GUID.

Refer the this link for the solution.

Sachin K.

Wednesday, March 6, 2013

First character SharePoint 2010 internal field name replaced with its hexadecimal code

Hi All,

I have created few site columns and created site content type from that columns and attached it to my SharePoint list.

Now when I was trying to access some column via object model code its was giving me an error saying that column doesn't exists.

By looking at the column internal name I found that the first character of column name was replaced with some hexadecimal code. :(

Spending some hours on that I found that SharePoint requires first 4 characters of the internale name have to be non numeric.

Creating column with first four characters as non numeric resolves the issue.

Sachin K. 

Monday, February 18, 2013

Learning JavaScript Design Patterns

Hi All,

Excellent article on Learning JavaScript Design Patterns.

Thanks Addy Osmani for this wonderful article.

Sachin Katkar.

Tuesday, February 5, 2013

Hide fields from SharePoint NewForm, DispForm and EditForm pages

Hi All,

Please find below Jquery script to hide the fields from NewForm.aspx, DispForm.aspx and EditForm.aspx page of SharePoint list

Hide fields from EditForm and NewForm

<pre class="brush: js">

$(document).ready(function() { 


Hide Fields from DispForm page

<pre class="brush: js">

$(document).ready(function() {

// Method #1: Access by FieldName – All fields have unique FieldNames

// Method #2:  Access by ID – NOTE: Not all fields have unique IDs


Please refer to the link for more detail information.


Sachin K.

Wednesday, January 16, 2013

Clear SharePoint Designer Cache

Hi All,

Sometimes SharePoint Designer shows files checked out even though they ware not.

This is because designer is refering to local web cache.

Clear all the files from following location to resolve this issue.

- %APPDATA%\Microsoft\Web Server Extensions\Cache

- %USERPROFILE%\AppData\Local\Microsoft\WebsiteCache



Sachin K.

Thursday, January 10, 2013

Using Javascript to get all choice values from SharePoint Choice column

Hi all,

Get List of all choice option from SharePoint Choice field with help of Javascript Client Object model

var context = new SP.ClientContext.get_current();

var web = context.get_web();


var studList = web.get_lists().getByTitle("students");

var studbatches = context.castTo(studList.get_fields().getByInternalNameOrTitle("batches"), SP.FieldChoice);

context.executeQueryAsync(Function.createDelegate(this, this.onSuccessMethod),

Function.createDelegate(this, this.onFailureMethod));

function onSuccessMethod(sender, args) {

var choices = studbatches.get_choices();

alert("Choices: (" + choices.length + ") - " + choices.join(", "));


function onFailureMethod(sender, args) {




 Sachin K.