Learn Angular JS

Dear All,

Please find below link where you will find detail understandings on Angular JS its concepts.

http://www.codeproject.com/Articles/891718/AngularJS-Interview-Questions-and-Answers#HowcanweinitializeAngularapplicationdata

Thanks,
Sachin K.

Node JS. MongoDB with Angular and asp.net

Dear All,

Just for curiosity, I was exploring NodeJS, MogoDB and its implementation with visual studio.
I came across excellent article that explain step by step process to setting up your visual studio to integrate node JS plugin, how to set up mongoDB and interacting with it using Angular JS.

http://www.dotnetcurry.com/nodejs/1032/nodejs-apps-in-visual-studio-mean-stack

Hope you will also find this article useful.

Thanks Ravi for the excellent post.

Thanks,
Sachin.

Uncaught TypeError: func is not a function in init.debug.js

Dear All,

I was facing "Uncaught TypeError: func is not a function" issue when browsing my SharePoint 2010 

site and due to this all the functions in my ribbon was not working.

Whenever I am clicking on ribbon items it always show me loading as shown below  

After digging more in to the issue I found that, in my Javascript code I have written 

ExecuteDelayUntilScriptLoaded(init(),"sp.js")

In the above syntax the '()' after init method was creating the problem.

I replace above syntax with 

ExecuteDelayUntilScriptLoaded(init,"sp.js")

and ribbon start working as expected.

Hope this post will save your time.

Thanks,
Sachin K.

Search Sort and Pagination in ng-repeat – AngularJS

Dear All,

Please find below link which explain a simple way to implement sorting, filtering and paging using angular js on your collection object.

Search Sort and Pagination in ng-repeat – AngularJS

Hope this information will save your time.

Thanks,
Sachin K. 

Wiki Page All item view SharePoint 2013

Dear All,

Today, I was surprise as I wanted to navigate to all items view for the wiki page library. 
Normally when use clicks on wiki page library, it redirect you to wiki home page to display the content which is normal behavior.

As a site owner, I wanted to see all the page inside my wiki page. When I am navigating to wiki page SharePoint removes the library tab from the ribbon which normally appears on any document library.

After spending some time I found that, on wiki page if you navigate to page tab from ribbon, you will find an option view all Pages option which will redirect you to all items page.

Hope this information save a little time for you.


Thanks,
Sachin K. 

Sharepoint 2013 App VS Solutions

Hi All,

Please refer to this link to get some useful information on SharePoint 2013 App development Vs Solutions.

Thanks,
Sachin K.

SharePoint 2013 on-line Breadcrumb

Hi All,

By default SharePoint 2013 doesn’t have a breadcrumb (like the 2010 version used to have). This was a very helpful feature to navigate back in your site and some users really miss it.

Actually its not totally removed from SharePoint but its hidden in SharePoint master page.

To restore it back, Open your site master page in SharePoint designer and search for following tag

Delete the CSS attribute style="display:none;"

Save the modified master page, check it in and publish the major version.

Thanks,

Sachin K.

The database could not be exclusively locked to perform the operation.

Hi All,

While renaming sql server database if you get following error 
The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030) that means your database is in multi-user mode.

To resolve this issue, you need to first set database single user mode 

ALTER DATABASE dbName
SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Now, Rename the database using following command

ALTER DATABASE dbName MODIFY NAME = dbName_new

At the end, Set database mode to multi-user 

ALTER DATABASE dbName

SET MULTI_USER WITH ROLLBACK IMMEDIATE

Hope this will resolve your issue.

Thanks & Regards,
Sachin K.

Sideloading of apps is not enabled on this site

Hi All,

When you are deploying solution to SharePoint online environment and if you get the following error while deployment "Install app for SharePoint': Sideloading of apps is not enabled on this site."

This means that you need to enable sideloading first before deploying the app.

Refer to this link to see how to fix this issue.

Thanks,
Sachin K.

Error Skipping the uninstall step because the app for SharePoint is in an invalid state and cannot be uninstalled

Hi All,

Till yesterday, My SharePoint hosted app was working like a charm but today when I did some change in my app and tried to deploy it, visual studio started giving me following error

"Error 1 Skipping the uninstall step because the app for SharePoint is in an invalid state and cannot be uninstalled."

Don't know what happen at the back end but after spending some time I got following power shell command lines which does job for me.

$instances = Get-SPAppInstance -Web
$instance = $instances | where {$_.Title -eq ''}
Uninstall-SPAppInstance -Identity $instance

Hope, this will work for you as well.

Thanks,
Sachin K.

Creating Custom REST Web Service SharePoint 2013

Hi All,

Please follow this link which demonstrate how to create a custom WCF REST service for SharePoint 2013 without a Visual Studio template.

Thanks Mike for this wonderful post.

Thanks,
Sachin K. 

SharePoint 2010 Download all files as zip

Hi All,

Please refer below post if you need functionality to download all library items as a zip.

Its works like a charm for me.

http://junooni.wordpress.com/2011/09/29/download-multiple-file-as-zip-in-sharepoint-2010/

Thanks Shakir for this wonderful post.

Thanks,

Sachin K.

Search Scope on Content Types

Hi All,

Please refer below steps to configure search scope as Content Type

Go to central admin ->  General application settings - > Farm Search administrator->Search service application -> Click on the Metadata Properties

once click on OK wait for the scope to be created.

Once the scope is created then click on Index reset from the left panel and click on full crawl.

Ref

 

Thanks & Regards,

Sachin K. 

SharePoint Javascript get current user security group

Hi All,

Please find below sample script to get SharePoint security group name of current logged in user

Thanks,
Sachin K.

Creating site column declaratively

Hi All,

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

Type of field	Field Type
Yes/No	Type="Boolean"
Single line of text	Type="Text"
Multiple lines of text	Type="Note"
Choice (menu to choose from)	Single Choice (dropdown or radio buttons): Type="Choice" Multiple choices (check boxes): Type="MultiChoice"
Date and Time	Type="DateTime"
Hyperlink or Picture	Type="URL"
Integer	Type="Integer"
Number	Type="Number"
Person or Group	Single User or Group Type="User" Multiple Users or Groups Type="UserMulti"
Currency	Type="Currency"
Calculated	Type="Calculated"

Thanks,

Sachin K.

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.

Thanks,
Sachin K.

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-

Key	Apps for SharePoint	SharePoint Solution
Environment	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.
Code-Reevaluation	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.
Skills	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.

Reference

Thanks,

Sachin K.

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.

Reference

Thanks,

Sachin K.

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. 


 Thanks, 

 Sachin K.

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.

Thanks,

Sachin.