Subscribe: SharePoint 2010, SharePoint, C-sharp, ASP.Net, JQuery, SQL Server Solutions
Added By: Feedage Forager Feedage Grade B rated
Language: English
app  code  download  list  microsoft  new  office  online  page  server  sharepoint online  sharepoint  site  web  windows 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: SharePoint 2010, SharePoint, C-sharp, ASP.Net, JQuery, SQL Server Solutions

SharePoint, ASP.Net, JQuery, SQL Solutions

Updated: 2018-04-21T15:14:18.496+05:30


New SharePoint CSOM update for Office 365


Wow. This is such a great build. Loving the new additions added in the new SharePoint CSOM for Office 365. Since a year, was submitting the feedback and waiting for some features has to be included in the CSOM API and here they are. You can do even more with the new API methods and classed added. The package will be available via Nuget.

Version: 16.1.3912.1204.

The major feature I really impressed are:
  • Manage regional settings of a site
  • Manage language settings of a site
  • Manage auditing settings of a site
  • Support for upcoming enhanced migration APIs
  • Secondary contact in site collection level
  • Sharing settings
  • Tenant
The auditing settings API is a major help for me along with the Sharing settings. There are over 50 methods added across and the major ones which might help you are:
  • Accessing document set properties, documents
  • Added classes related to Search PushTenant
  • Additional properties for Publishing classes
  • Accessing AppCatalog
  • Audit information
  • File, Folder methods and properties
  • Many Web and Site properties and methods. 
If you are feeling like you are unable to implement just because of product limitation then it's for you. Go and have a look at the new update and start building the examples. 

Get more details about complete CSOM methods and properties here.

Show user profile pictures in SharePoint Hosted Apps


This is the issue which killed more than a week of my time. Many users are facing it too and I see the same question in almost all the forums. Proud to tell that the solution which I have found is the most usable one for SharePoint Hosted App world.

In SharePoint Hosted Apps the cross-domain calls are limited. The issue I am facing in SharePoint Online Hosted Apps was:

I have created a SharePoint hosted app which has the code to show the user profile picture. I have tried below options for it:

  1. Queried the REST API user profile and then 
    1. used the "PictureUrl" from user profile metadata. But, no luck with this. Then,
    2. used the "UserProfileProperties -> PictureURL attribute in the results. Still, there is no luck. 
  2. Used the Outlook Office 365 profile picture link: 
    1. But, the url is an external site link the picture failed to load.
  3.  Used the UserPhoto.aspx page in the _layouts folder: /_layouts/15/userphoto.aspx?size=L&accountname=encodeduseraccountname.
    1. I have tried with both hosted web url and app web url. But, no luck. 
    2. But, if I create a App Part and in the app part the same image path shows perfectly. So, the issue is only in the App landing page. 
Published the issue in all social networking sites, forums for help, but no luck. Many people come up with different ideas, but nothing worked. 

After spending the good amount of time in analyzing the UserPhoto.aspx, and how it works, I was able to find a way to download the image. 

UserPhoto.aspx accepts many parameters. We always use the AccountName querystring to download the image of the user. But, it also accepts other paramters like "url". 

So, the solution I used here is: 

Note: You must query the User profile REST API for the user to get the user profile picture url and then encode that picture url and then replace the string {encodeduserprofilepictureurl} with that.

This one given me the output I wanted. Now, the pictures are showing everywhere, inside the app and also in app part... 

Download Visual Studio 2015 Technical Preview


Visual Studio 2015 has plenty of UI improvements and UI debugging features. It has a great Javascript editor and Visual Studio emulator for Android. Many more other features which I also need to dig into.

Go and get it here: Download Visual Studio 2015 CTP 6

See the Visual Studio Features Timeline here:

C# is allowed in Office 365 API's Sandbox


So far in Office 365 API Sandbox we have written only javascript to call the API's and deploy the changes. It is very limited in terms of achieving the goals and against some complex requirements. So, after some additional good work from Office 365 team, there is a release of C# code support in API sandbox. This is a brilliant idea and good help for developers to quickly write code and check on the fly. I will update you more findings on it soon.

Read more details here Office 365 API Sandbox now allowing C# Code

Office 365 roadmap


Dear technology enthusiast, how many of you are actually updated with the new technologies / implementations around? Are you one of the person who first get to know and learn things and keep up to date yourself in this technology world? I follow the blogs and roadmap to know everything what's happening around to me.

If you also like me, then you must bookmark the link

Get your OneNote for free


OneNote is my best and preferred application to take notes since years. I personally recommend to everyone of my readers. It's now available for free with plenty of options and it has the apps in every device Desktop, Mobile, Tablets. So, get one and sync all your notes everywhere.

Get your free download copy at Download.

SharePoint Product updates are now part of Windows updates


Uhh.. I am not liking it. Why SharePoint product should be a part of Windows Updates? Windows is Operating System, SharePoint is a product from Microsoft. I am not sure how they merge the updates into one. I think this way because, consider below scenarios:

  1. I have enabled the auto updates on my server and enabled the scheduled updates installed at some specific time. Now, along with Windows updates, all my SharePoint Patches also installed. But, if I am on FARM then I have to make sure the patches are installed in all servers in the FARM.. It's a big dependency. 
  2. Now, if all servers installed the SharePoint updates/patches then we have to make sure the PSConfig should be run in all SharePoint Servers. 
The only advantage I see is, the updates install automatically and my SharePoint server is upto date. But, this will not impress me anywhere. If needed I can download and install on servers I needed as a Product upgrade. 

I am not a fan for this new decision they have made. Make sure to turn off Windows updates automatically option on Windows Servers where SharePoint installed and run the updates when only you really need to. 

And starting this February 2015 CU they are part of Windows Updates. So, you might already got the updates. Please check once your Windows Updates. 

OneDrive delivers unlimited cloud storage for Office 365 subscribers


If you are a Office 365 subscriber then you must feel great about it. I feel great and very happy news for me. They already started rolling out and soon I am gaining unlimited storage to keep all my personal, organization related stuff there. So, wherever I go I don't feel like I lost something.

Thanks Microsoft for the wonderful thinking at low cost. We know you understand us well. Here you go OneDrive for everyone. Read more at: OneDrive and unlimited storage

Free eBooks from Microsoft on Azure, Windows Server, Sql Server and Windows


Microsoft is giving many ebooks for free. If you are on below technical stack then please use the links below and download them for free.
  • Windows Azure
  • Sql Server 2014
  • Windows
  • Azure
  • App Development
  • Microsoft System Center
Enjoy reading and gain the extra knowledge for better career. :)

Download CAML Query Designer


Recently I had some free time and implemented an utility for generating CAML query. It's implemented through Technovert with the great UX design ideas. This tool is not only just for generating the CAML Query but also to extract as much of information  related to a list or library which will help developers and administrators. This tool is using the technology stack:
  • WPF (Windows Presentation Foundation)
  • .NET Framework 4.5
  • SharePoint Managed Client Object Model.

This utility has the below features available:
  1. Supports SharePoint 2010/2013/Online. 
  2. Site Manager which remembers your settings and sites information, so you can use them for later time. (All the information is encrypted.). You can save as many connections as you want.
  3. This utility shows the all lists and libraries from the site you requested and also it will show all the subsites and lists in the site as well.
  4. Better UX design which will help users to better use the tool. Below are the modules available to configure and generate your query. 
    1. View Fields: To select what fields to show in the query results. 
    2. Order By: used for sorting the results. 
    3. Filters: To add where clauses. (Right now grouping support not available.)
    4. Query Options: To select any additional options for generating CAML Query.
  5. This tool also gives the below advantages other than simply generating query. 
    1. Gives CAML Query output
    2. Generates Server Side Object Model Code. So, you can simply hook the piece of code  directly. 
    3. Generates Managed Client Object Model Code. 
    4. Generates Java script (ECMAScript) Client Object Model Code. 
    5. Generates Webservices Code.
    6. Generates Powershell script code. 
  6. Export the query to text file. So, you can share it with others. 
  7. Export all languages generated syntax to text file. 
  8. Execute and see the results. So, you make sure your query is correct. 
  9. Export the results to Excel. 
  10. Along with the query generation, this tool also has the support of showing all list information. 
    1. List Metadata
    2. Export the list schema to xml file. 
    3. All fields in the list. 
    4. Export fields to the Excel. 
    5. Show all Content Types attached to the list. 
    6. Export content types to Excel. 
    7. See all workflows on the list. 
    8. Export workflow details to Excel. 
    9. See all Event Receivers on the list. 
    10. Export all event receiver details to Excel. 
  11. Log viewer is also available. So, users can see if anything is wrong in using the tool. 
  12. You can open the list, site, library or any other entity directly from tool. You will see "open in window" icon everywhere next to them.
Please let me know the feedback by going to Technovert / Contact Us or you can leave comments here.
Download CAML Query

Download Office 2016 Technical Preview


So far Windows 10 is looking good and I am really enjoying with new UI and options available around. Especially the way Cortana implemented, the neat look of the new icons and text rendering is impressive. I recommend you to download the technical preview and use it. I didn't find any major issues so far in the past 2 weeks.

Now, it's the time to use Office 2016. After seen some videos and read some articles wanted to try new Office. But, the invitation link is not working currently. Even if you join in Microsoft Insider program or you registered in Microsoft Connect, you can't be able to download the new version as it is down currently.

If you want to try out the new office, the only way I found is through Windows 10 OS. The OS has the "Store (Beta)" app. Through this app you can download the new office for MS Word, Paint and Excel.

  1. Go to Store (Beta) in your Windows 10 OS. 
  2. Search for "Office Preview" and then download the 3 preview apps available. 
Enjoy the new office. it looks cool. 

Updates to SharePoint Online Limits


This must be one of the most loving post for SharePoint Audience. The updates to the limits of SharePoint Online are unbelievable and it's the great thinking by SharePoint Online team.

With the new announcement a site collection can grow up to 1TB in size. This will be a huge benefit to the tenants who has huge data and would like to go cloud with publishing/enterprise/social features.

Get all details here:

Microsoft stop supporting Windows XP on April 8, 2014


If your organization still having PC's running Windows XP then it's the call to you that Microsoft stops supporting Windows XP on April 8, 2014. Which means you won't receive any updates or support from Microsoft after April 8th, 2014.

* Up-gradation process may involve changing of your current hardware (as old hardware may not support running Windows 8). 

Finding SharePoint page is in edit mode using javascript


Recently in my project I got a requirement where I have to switch views of web parts based on the page mode (browsing mode and edit mode). When user is in edit mode I have to show some styles which will give option to user to add the data easily, but when user save the changes and publish the page, the styles will go away and they see normal page. So, I have to identify whether the page is in Edit mode or Browse mode in javascript.I have a set of styles already written and based on the page mode I need to add those styles to some divisions on html. To find the edit mode of the page using javascript we have to use below logic:var IsPageInEditMode = document.forms[MSOWebPartPageFormName].MSOLayout_InDesignMode.value; if (IsPageInEditMode == "1") { alert("web part page is in edit mode."); } else { alert("web part page is in browse mode."); }But, this is not it all. To make it a common solution we must do more. :) The above logic works only for the Publishing pages. Which means if you have team pages (/sitepages/) or wiki pages then the above solution fails to return the correct value. For this, we should use below logic.var IsPageInEditMode = document.forms[MSOWebPartPageFormName]._wikiPageMode.value; if (IsPageInEditMode == "Edit") { alert("wiki page is in edit mode"); } else { alert("wiki page is not in edit mode"); }These SharePoint hidden variables are handy most of the times. Let's take a closer look at how we did it.SharePoint uses the form variable for all its operations. This is a global variable added by SharePoint Framework to javascript. See the below image:If you see the above image, there are many variables available for you in javascript. The first one is what we have used to get the form name. And the same way, we have many hidden variables available in javascript. These all can be visible by doing "View Source" on your browser. :)From one of my friend, I got to know that in SharePoint 2010, 2013 we have a method available to get the Page State. var IsPageInEditMode = SP.Ribbon.PageState.Handlers.isInEditMode();That's all for now. Enjoy the new findings. I know it's old finding but learning is always fun![...]

Importing Excel Data to SharePoint


Recently for my company I have implemented a nice tool for importing data to SharePoint. The initial implementation started with Importing Excel Data to SharePoint List. Few years back me and my colleague implemented the same solution for 32 and 64 bit SharPoint 2007 servers. But, this new tool is targeted for SharePoint 2010, SharePoint 2013 and SharePoint Online. For more details visit the company blog. And also take a look at the codeplex project.

Its officially moved to my company utilities page. Please get it here.

API Tutorial for Office


I am so excited about the Microsoft new announcements and their implementation approaches going forward. Just got to know today the great implementation "Javascript API for Office". Isn't it exciting to read? It's the new way to work with Office online. The tutorial app will provide us 6 examples on how we can use the Javascript API for Office. You can use "Napa for Office 365 Development Tool" to open the app files to write code.

To run the tutorial online you must be using IE 9, Safari 5.0.6, Firefox 5, Chrome 13 or later versions of these browsers.

API Tutorial for Office

Download Visual Studio 2013 RC and Windows 8.1 RTM


It's great day to start with new releases. If you didn't try VS 2013 yet then it's the right time to try it out as it improves the productivity by >30%. Windows 8.1 RTM is ready to download via MSDN or Technet subscriptions.

Read more complete article at:

SharePoint Conference 2012 Sessions free streaming


If you missed the SP Conference 2012 keynotes and the sessions then it's a good news for you that more than 100 videos are available for you free here. Enjoy the videos and learn SharePoint for better applications.

SharePoint Conference 2012 Sessions

SharePoint Online improvements


Office 365 is going to be better and better. As many people are started using Office 365 I see Microsoft is planning to invest more on this domain. Lets see what they have improved. Below improvements are not applicable to Office 365 dedicated subscribers.

  1. The complete Office 365 environment for all users are updated to SharePoint 2013.
  2. Skydrive Pro will solve many problems regarding storage for Online users. Now, its been increased from 7GB to 25GB. This is free. 
  3. The improvements which are rolling out in coming weeks are:
    • Now SharePoint Online supports many file types: This is one of the great features I like. They extended the support for broad range of file types including .EXE and .DLL.
    • File upload limit increased: Now, users can upload files up to 2 GB size. Earlier it was just 250 MB limitation.   
    • Number of site collections: With latest improvements a tenant can create 10000 site collections. Earlier it was limited to 3000. 
    • Improvements to Look up fields: Each list can support 12 lookup fields. 
    • Self-restoration: Increasing recycle bin retention duration (now it is 90 days, earlier it was just 30 days) and versioning is turning on by default for the Skydrive Pro libraries.
    • IE 10 now supports opening Explorer view. Yes, it is back...
    1. Other than these there are many improvements. 
    Below are the reference links to get more details. These are really important points to know before you planning to migrate to Office 365/SharePoint Online.


    SharePoint 2013 tutorials and e-books free download


    This is the important collection of e-books I have studied to understand the new concepts of SharePoint 2013. I believe they will be very useful to all my readers as well. Enjoy all the collection of books and leave me comment if you find any e-book which is good for learning easy SharePoint 2013 and all it's new concepts. Good luck.

    1. SharePoint 2013 for Dummies
    2. Beginning SharePoint 2013
    3. Beginning SharePoint 2013 Development
    4. Professional SharePoint 2013 Development
    5. Explore SharePoint 2013 (What's new in SharePoint 2013) 
    6. Deployment guide for SharePoint 2013
    7. SharePoint 2013 Technical Library in Compiled Help
    8. No code solutions using SharePoint 2013 Composites
    9. SharePoint 2010 Vs SharePoint 2013 Feature Comparision for Business Users 
    10. Software boundaries and limits for SharePoint 2013 (For architecture)
    I hope you get time to read all these to gain plenty of knowledge on SharePoint 2013 and keep rocking!

    Download Service Pack 2 for SharePoint 2010


    Here is the download link for SP2 for SharePoint 2010. *The Service Pack is a roll-up of all previously released updates.*

    Service Pack 2 for Microsoft SharePoint 2010 (KB2687453)

    More detailed list of packages / CU's included in this SP2 are mentioned here.

    Error occurred in deployment step Recycle IIS Application Pool


    This is the most annoying error in deploying a solution to SharePoint via Visual Studio. There are many reasons behind this error. It could be permissions, server configuration. So, I am planning to write all solutions here. :)

    Complete Error Details:
    Error occurred in deployment step 'Recycle IIS Application Pool': 0x80070005Access denied.


    1. Visual Studio should be running as Administrator. (As the solution is deploying to the server and which requires the admin privileges we must run as Administrator)
    2. User must be a local administrator on the server and should be a member of WSS_Admin_WPG. (Should need access to control IIS and App pool recycling operations)
    3. User must have owner (db_owner) access to the SharePoint Content database. (To deploy the package and activate feature at site collection level) 
    4. User must be a part of Farm Administrators group. (Adding solution package to FARM)
    5. Finally, check the current user is a site collection administrator on the site which the solution is deploying to. (This is very important!)
    Hope you are good to go after following all the above instructions. Happy deploying!

    Adding inline styles in SharePoint 2013 page layout


    This is another tip which will help you in branding the SharePoint 2013 sites. In SharePoint 2013 when we create a page layout from design manager module then in SharePoint Designer we observe one html file and one aspx page got created for page layout. This is the implementation in SharePoint 2013 for master pages and page layouts. The customization we have to do it in HTML page. SharePoint framework will convert from HTML to ASPX automatically.

    For example, if we like to hide the left navigation from the current page layout pages then we will add simple below style to PlaceHolderAdditionalPageHead placeholder.
    Once you save the html file then you observe that the style is not applied to page. I have applied simple styles to the page and still they are not applied to any element on the page. After checked the ASPX converted file in Designer I found that the Style is converted as
    Which means browsers will ignore executing these CDATA styles. So, these styles will not be applied. After long research and reading many articles found the helpful information from MSDN article. I see there are new implementations in SharePoint 2013 branding. Below is the correct implementation we have to use to write style to the page.
    Hope you bookmark another new tip into your mind.:)

    SharePoint 2013 Best Practices


    Best post ever on SharePoint 2013. :) Go through from top to bottom without missing any line of link, code, tools etc. But, it will take days to complete the article. LOL

    SharePoint 2013 Best Practices

    MVC support for Apps in SharePoint 2013


    Interesting? Yes, it is the most interesting and surprising news in VS2013 preview release. With Visual Studio 2013 preview now you can create Apps in MVC as well. When you are creating a new APP you can select between ASP.NET web forms and ASP.NET MVC.

    These options can be available when you choose Auto-Hosted or Provider-Hosted app for SharePoint. We all know the SharePoint-hosted apps won't allow server side programming. :) When you created an app using ASP.NET MVC model then you see the same folders and structure as in mvc web site. Complete model is same as regular MVC implementation. The new things for you might be are the SharePoint filter and context files. The project provides a set of APIs, defined in the Filters\SharePointContextFilterAttribute.cs and Filters\SharePointContextFilterAttribute.vb, and SharePointContext.cs and SharePointContext.vb files for C# and Visual Basic projects respectively...

    SharePointContextFilter: Filters can be useful for switching back and forth between SharePoint and remote web application. Mostly when the SharePoint site need authentication etc.

    SharePointContext: This is for communicating the App with SharePoint objects.

    To test the new implementation you should download the VS 2013 preview now and start doing the innovation things. :) Enjoy the new learning day to day. 

    Windows 8.1 Preview Download


    Yes, Start button is back. You hear it right. :)

    Download the Windows new release version 8.1 PREVIEW here. But, please make sure that this is the preview version and not recommended to install on the existing environment as it deletes, corrupts or even screw up your complete machine. So, just try it only for evaluation and testing the new features. 

    June CU updates for SharePoint Products


    SharePoint Product Team released the JUNE CU updates for all versions of SharePoint. Please find the complete list below:Something interesting article on re-release of the CU's....SharePoint 2013SharePoint 2013 server June CU is delayed. And for now, the CU available are KB 2817346 - SharePoint Foundation 2013 June 2013 CUKB 2817350 - Office Web Apps Server 2013 June 2013 CUPackages:Download SharePoint Foundation 2013 June 2013 CUDownload Office Web Apps Server 2013 June 2013 CUSharePoint 2010SharePoint 2010 June CU should be applied on servers where SP1 is installed. KB 2817392 - SharePoint Foundation 2010KB 2817363 - SharePoint Server 2010KB 2817368 - SharePoint Server 2010 with Project ServerPackages:Download SharePoint Foundation 2010 June 2013 CUDownload SharePoint Server 2010 June 2013 CUDownload SharePoint Server 2010 with Project Server June 2013 CU SharePoint 2007SharePoint 2007 June CU is the hotfix after SP3. So, you must run this on servers which have SP3 installed.KB Articles:WSS 3.0: KB 2817329MOSS: KB 2817328Packages:Download WSS 3.0 June CUDownload Moss June CUNOTE:SharePoint Server 2010 CU contains the SharePoint Foundation CU. And the SharePoint Server 2010 with Project Server CU contains Project Server CU, SharePoint Server CU and SharePoint Foundation CU.That means only one package has to be installed for the SharePoint 2010 product family.[...]

    SharePoint 2013 Features GUID


    This is a very good post to all SharePoint techies. We encounter many issues as SharePoint display only GUID's many scenarios like logs, information etc. Here is the complete list of the existing feature names with guids. And the scope of each feature. Bookmark this.Display NameIdScopeAbuseReportsListc6a92dbf-6441-4b8b-882f-8d97cb12c83aWebAccessRequestsa0f12ee4-9b60-4ba4-81f6-75724f4ca973WebAccSrvApplication1cc4b32c-299b-41aa-9770-67715ea05f25FarmAccSrvMSysAso29ea7495-fca1-4dc6-8ac1-500c247a036eWebAccSrvRestrictedLista4d4ee2c-a6cb-4191-ab0a-21bb5bde92fbWebAccSrvShellbcf89eb7-bca1-4468-bdb4-ca27f61a2292WebAccSrvSolutionGallery744b5fd3-3b09-4da6-9bd1-de18315b045dSiteAccSrvSolutionGalleryStaplerd5ff2d2c-8571-4c3c-87bc-779111979811FarmAccSrvUserTemplate1a8251a0-47ab-453d-95d4-07d7ca4f8166WebAccSrvUSysAppLog28101b19-b896-44f4-9264-db028f307a62WebAccSvcAddAccessAppd2b9ec23-526b-42c5-87b6-852bd83e0364WebAccSvcAddAccessAppStapling3d7415e4-61ba-4669-8d78-213d374d9825FarmAccSvcApplication5094e988-524b-446c-b2f6-040b5be46297FarmAccSvcShell7ffd6d57-4b10-4edb-ac26-c2cfbf8173abWebAddDashboardd250636f-0a26-4019-8425-a5232d592c09WebAdminLinksfead7313-ae6d-45dd-8260-13b563cb4c71WebAdminReportCoreb8f36433-367d-49f3-ae11-f7d76b51d251SiteAdminReportCorePushdown55312854-855b-4088-b09d-c5efe0fbf9d2FarmAnnouncementsList00bfea71-d1ce-42de-9c63-a44004ce0104WebAppLockdown23330bdb-b83e-4e09-8770-8155aa5e87fdWebAppRegistrationfdc6383e-3f1d-4599-8b7c-c515e99cbf18SiteAppRequestsList334dfc83-8655-48a1-b79d-68b7f6c63222WebAssetLibrary4bcccd62-dcaf-46dc-a7d4-e38277ef33f4SiteAutohostedAppLicensingfa7cefd8-5595-4d68-84fa-fe2d9e693de7SiteAutohostedAppLicensingStapling013a0db9-1607-4c42-8f71-08d821d395c2FarmBaseSiteb21b090c-c796-4b0f-ac0f-7ef1659c20aeSiteBaseSiteStapling97a2485f-ef4b-401f-9167-fa4fe177c6f6FarmBaseWeb99fe402e-89a0-45aa-9163-85342e865dc8WebBaseWebApplication4f56f9fa-51a0-420c-b707-63ecbb494db1WebApplicationBasicWebParts00bfea71-1c5e-4a24-b310-ba51c3eb7a57SiteBcsEvents60c8481d-4b54-4853-ab9f-ed7e1c21d7e4WebBDR3f59333f-4ce1-406d-8a97-9ecb0ff0337fWebBICenterDashboardsLibf979e4dc-1852-4f26-ab92-d1b2a190afc9WebBICenterDataConnections3d8210e9-1e89-4f12-98ef-643995339ed4WebBICenterDataconnectionsLib26676156-91a0-49f7-87aa-37b1d5f0c4d0WebBICenterDataConnectionsListInstancea64c4402-7037-4476-a290-84cfd56ca01dWebBICenterFeatureStapler3a027b18-36e4-4005-9473-dd73e6756a73WebApplicationBICenterPPSContentPagesa354e6b3-6015-4744-bdc2-2fc1e4769e65WebBICenterPPSNavigationLinkfaf31b50-880a-4e4f-a21b-597f6b4d6478WebBICenterPPSWorkspaceListInstancef9c216ad-35c7-4538-abb8-8ec631a5dff7WebBICenterSampleData3992d4ab-fa9e-4791-9158-5ee32178e88aWebBizAppsCTypes43f41342-1a37-4372-8ca0-b44d881e4434SiteBizAppsFields5a979115-6b71-45a5-9881-cdc872051a69SiteBizAppsListTemplates065c78be-5231-477e-a972-14177cc5b3c7WebBizAppsSiteTemplates4248e21f-a816-4c88-8cab-79d82201da7bSiteBlogContent0d1c50f7-0309-431c-adfb-b777d5473a65WebBlogHomePagee4639bb7-6e95-4e2f-b562-03b832dd4793WebBlogSiteTemplatefaf00902-6bab-4583-bd02-84db191801d8WebBulkWorkflowaeef8777-70c0-429f-8a13-f12db47a6d47FarmBulkWorkflowTimerJobd992aeca-3802-483a-ab40-6c9376300b61WebApplicationCallTrackList239650e3-ee0b-44a0-a22a-48292402b8d8WebCategoriesListd32700c7-9ec5-45e6-9c89-ea703efca1dfWebCirculationLista568770a-50ba-4052-ab48-37d8029b3f47WebCmisProducer1fce0577-[...]

    SQL Server 2014 - TechEd announcement


    Yesterday at TeachEd Microsoft announced their new version of data platform - SQL Server 2014. Many improvements over 2012 edition with upgraded architecture including the cloud principles. Read the post at SQL Server blog.

    Visual Studio 2013 and Team Foundation Server 2013 announcement - TechEd


    You must like this post! Enjoy the new features of the both versions and read the complete article at MSDN Blog.

    Download SkyDrive Pro Client as standalone download


    Woo hoo! Isn't it a great news? Earlier SkyDrive Pro was coming with the Office 2013 and that was a big problem to most of the clients as all not migrated to 2013 environment yet. This week Microsoft released the news that SkyDrive Pro is now available as a standalone download. :)

    Now, with SkyDrive Pro you can sync your data from SharePoint 2013 site or Office 365 sites to your local machine both on and offline. SkyDrive Pro can be installed side by side with previous versions Office 2007 and Office 2010. I have to test the tool by syncing data with SharePoint 2010. I believe it supports SharePoint 2010 environment too! Bookmark this post for latest updates on further information.

    This will save money to lot of organizations as the sync tool is now ready! You can take a look at it for more details at : SkyDrive Pro Download for Windows

    Change the SharePoint list url


    This is a very old tip. But still I see many people don't know about this. In SharePoint we have a concept of display names and internal names. The same way when we created a list in SharePoint it has display name where it used to show the list name and internal name where it used in the list url. The internal names cannot be changed from browser once the list was created. But, what if we have a requirement where we need to change the list url???

    The only way to achieve this is using SharePoint Designer. Open SharePoint Designer and change the name of the list/library which will change the name of the library as well as the list url.

    If you don't have option to open the site in SharePoint Designer then you must save the list as site template and create a new list with that template. But, make sure dependencies like lookup columns, workflows, event receivers etc.

    Data View Web Parts and SharePoint Designer issues


    This is a strange issue which was happened recently to me when working with Data view web parts in SharePoint Designer.

    I have created a page in SharePoint Designer which has the data view web part in it. And I got another requirement where I need to create the same page as the first page with slight change in caml query. So, I have created another ASPX page in designer and copy and pasted the data view web part code from page1 to page2. I saved the page and browsed the page2 and all looks good. Now I browsed page1 and it started showing me empty content (data view web part is not visible anymore on the page.) I have opened the page1 in designer, added the data view web part back on page1 and opened in browser. Now page1 is looking good and page2 is showing empty content. Which means they started working mutually exclusive.

    After worked for couple of hours I have learnt that the issue happened was because of the data view web parts sharing the same id. You might think it's a shit reason as the data view web parts are in different pages how that could be the problem. But, yes that is the problem. Believe me. :)

    Two data view web parts should not be sharing the same ID whether they are on a single page or in different pages (site pages or pages library).

    Once changed the ID and __WebPartId properties of the data view web parts to the new values I started seeing both pages are showing content correct! So, save this tip to your memory for saving hours and hours of time. 

    SharePoint global variables in Javascript


    This is very useful information to know by all SharePoint developers. Recently I have reviewed a code from one of the SharePoint developer who written good ECMAScript for loading list data. All is good except the logic to get the site relative url. He has written a function which is 10 lines of code to get the site relative url. But, the code will not work in all the scenarios. If you think, SharePoint site can be like /spsite or /sites/spsite or /sites/something/something etc.. So, please don't write your custom logic and know the OOB features available around you. Below are the global variables available in Javascript for SharePoint Developers.

    L_Menu_BaseUrl: To read the current site relative url you are in. This will be very useful in almost all the code we work with SharePoint data through javascript.

    Example: If you are writing code to generate anchor links dynamically to take users to lists, views and pages   then this is the most useful variable.

    you can set the href like L_Menu_BaseUrl + "/lists/Tasks". This will results the path to the tasks list. No matter in which site you are in, it always take the user to the correct lists location.

    L_Menu_SiteTheme: To get the name of the current site theme.

    L_Menu_LCID: To get the current site LCID. It will be useful in knowing the language details of the site. To understand these ID number you must check the other post here.

    _spUserId: To know the current login user ID. By using this variable we can query to SharePoint to get more details of the user like profile, email, name etc.. 

    Language Local ID's (LCID) numbers in SharePoint


    Language - Country/RegionLCID HexLCID DecAfrikaans - South Africa04361078Albanian - Albania041c1052Alsatian04841156Amharic - Ethiopia045e1118Arabic - Saudi Arabia04011025Arabic - Algeria14015121Arabic - Bahrain3c0115361Arabic - Egypt0c013073Arabic - Iraq08012049Arabic - Jordan2c0111265Arabic - Kuwait340113313Arabic - Lebanon300112289Arabic - Libya10014097Arabic - Morocco18016145Arabic - Oman20018193Arabic - Qatar400116385Arabic - Syria280110241Arabic - Tunisia1c017169Arabic - U.A.E.380114337Arabic - Yemen24019217Armenian - Armenia042b1067Assamese044d1101Azeri (Cyrillic)082c2092Azeri (Latin)042c1068Bashkir046d1133Basque042d1069Belarusian04231059Bengali (India)04451093Bengali (Bangladesh)08452117Bosnian (Bosnia/Herzegovina)141A5146Breton047e1150Bulgarian04021026Burmese04551109Catalan04031027Cherokee - United States045c1116Chinese - People's Republic of China08042052Chinese - Singapore10044100Chinese - Taiwan04041028Chinese - Hong Kong SAR0c043076Chinese - Macao SAR14045124Corsican04831155Croatian041a1050Croatian (Bosnia/Herzegovina)101a4122Czech04051029Danish04061030Dari048c1164Divehi04651125Dutch - Netherlands04131043Dutch - Belgium08132067Edo04661126English - United States04091033English - United Kingdom08092057English - Australia0c093081English - Belize280910249English - Canada10094105English - Caribbean24099225English - Hong Kong SAR3c0915369English - India400916393English - Indonesia380914345English - Ireland18096153English - Jamaica20098201English - Malaysia440917417English - New Zealand14095129English - Philippines340913321English - Singapore480918441English - South Africa1c097177English - Trinidad2c0911273English - Zimbabwe300912297Estonian04251061Faroese04381080Farsi04291065Filipino04641124Finnish040b1035French - France040c1036French - Belgium080c2060French - Cameroon2c0c11276French - Canada0c0c3084French - Democratic Rep. of Congo240c9228French - Cote d'Ivoire300c12300French - Haiti3c0c15372French - Luxembourg140c5132French - Mali340c13324French - Monaco180c6156French - Morocco380c14348French - North Africae40c58380French - Reunion200c8204French - Senegal280c10252French - Switzerland100c4108French - West Indies1c0c7180Frisian - Netherlands04621122Fulfulde - Nigeria04671127FYRO Macedonian042f1071Galician04561110Georgian04371079German - Germany04071031German - Austria0c073079German - Liechtenstein14075127German - Luxembourg10074103German - Switzerland08072055Greek04081032Greenlandic046f1135Guarani - Paraguay04741140Gujarati04471095Hausa - Nigeria04681128Hawaiian - United States04751141Hebrew040d1037Hindi04391081Hungarian040e1038Ibibio - Nigeria04691129Icelandic040f1039Igbo - Nigeria04701136Indonesian04211057Inuktitut045d1117Irish083c2108Italian - Italy04101040Italian - Switzerland08102064Japanese04111041K'iche04861158Kannada044b1099Kanuri - Nigeria04711137Kashmiri08602144Kashmiri (Arabic)04601120Kazakh043f1087Khmer04531107Kinyarwanda04871159Konkani04571111Korean04121042Kyrgyz (Cyrillic)04401088Lao04541108Latin04761142Latvian04261062Lithuanian04271063Luxembourgish046e1134Malay - Malaysia043e1086Malay - Brunei Darussalam083e2110Malayalam044c1100Maltese043a1082Manipuri04581112Maor[...]

    Access 2013 - Office Web Apps


    Good that the new tool Office Web Apps - Access 2013 might be a solution for the users who is looking to save the data in lists which are highly relational. But, before you considering to go or not to go to Office Web Apps - Access 2013 below are the observations you should check. Online I didn't find any limitations document/articles from Microsoft to give you the stats, boundaries etc, but below are the observations from my expertise.


    1. Access 2013 has the capability of creating them and publish to Office 365. (It's available in Access 2010 as well but I see there are new templates with additional built-in features.)
    2. The backend server they use is SQL Server 2012 and it has good capabilities compared to previous versions. 
    3. You can package your App to publish to Microsoft App market place. 
    4. Security can be added to the access database with the help of SharePoint groups. 
    5. Of course, they support relational data. 
    1. We can't use the SharePoint workflows in Access Web Apps. 
    2. If you have existing database then you can't use Access Web App as a front-end to host the UI for existing database. 
    3. You can't define the permission levels in Access Web Apps like who can only add records or who can only edit records on a particular table. If a user can edit records in one table which means they can edit all tables in the app. 
    As my understanding there are some issues in using Access Web Apps. The recommendation from my side is if you have a requirement where you need to provide a form to user, collect data and show small reports then this solution works good, (which means for very simple databases). But, if you have complex design/tables with business data then this is not be the right solution (medium or large databases). 

    SharePoint 2013 Vs SharePoint 2010 Boundaries and Limits comparison


    Great post on Boundaries and Limits comparison between SharePoint 2013 and SharePoint 2010 versions. This should help to understand the improvements/additions better. A good helpful post for Architects and Developers.

    Download SharePoint Designer 2013 RTM


    For those who are waiting for SharePoint Designer 2013 RTM, here is the link to download from MSDN.

    Download SharePoint Designer 2013 RTM

    Side Loading of apps is not enabled on this site error while installing app


    If you are trying to install an app to SharePoint 2013 RTM environment or to Office 365 then you might see the below error if you are trying to deploy the app to the site which is not developer site.

    Error occurred in deployment step 'Install App for SharePoint': Side Loading of apps is not enabled on this site.

    Always the app should be published/deployed to the developer site (A site collection with the Developer Site Template). And from this developer site you can add the App to your SharePoint site. 

    SharePoint 2013 Cloud or no Cloud - What is your choice?


    SharePoint 2013 come up with fantastic features with new UI, new architectures like App Model, Search Crawling and Shredded Storage etc. This new release is impressive and it's support very large and multi-server FARM support. Below are my views on whether to go for Cloud environment or to no go for it.

    Why to go for Cloud (SharePoint Online)?

    • Platform: As we already know SharePoint online for 2013 Preview build is available. RTM will be available soon.
    • UI: The new UI is very easy to use, customize and add more functionality through CMS improvements compared to earlier versions.
    • Tools: The Napa tools help us to quickly write the code (Client Side code) and publish them from browser in no time. Very quick development tools. 
    • App Model: The new app model will give us the opportunity to extend our SharePoint system with custom coding. Earlier models supports Sandbox solutions and in 2013 we have both Sandbox and App models. 
    • Design & Customization: It's as easy as uploading a background image and change colors to design a new theme for SharePoint site in 2013, until unless you want to change the master page for full extent. You can customize the master pages with tools like SharePoint Designer and deploy them to SharePoint Online. Themes are very easy to apply and customization is very simple. 
    • Cost: If you like to maintain a FARM on-premises it will be more expensive to maintain the hardware and software. SharePoint online is too cheap compared to on-premises and will save thousands of $. 
    Why to not go for Cloud (SharePoint Online)?
    • There are no big new reasons why we need on-premises environment. :) If yours is big organization where many services are running like finance services, corporation intranet, file share and search crawling then we must need on-premises environment. SharePoint Online will not give control to run all these as there is  no authorization to Central Administration. 
    • If an organization has big repository for the documents on file share and you like to crawl them to show results in Search then we must need on-premises.
    • Multi-server FARM is only possible in On-premises and Farm level solutions are possible only in On-premises.
    It's completely based on our requirements to decide whether to go for Cloud or not. Above mentioned are the possible reasons according to my view. SharePoint online (build in 2013) is a great product for CMS, small scale intranets. With new templates available in SharePoint 2013, you can build product catalog web sites etc. I believe SharePoint Online will grow fast in near future. 

    Download SharePoint 2013 and Office 2013 RTM


    Just last week we discussed about 2013 versions are reaching RTM and thought they will be released in mid-November. But, you know what the RTM are available to download in MSDN. Mine is in progress why are you waiting? Download yours too!


    Download SharePoint Server 2013

    Geolocation field in SharePoint 2013


    Today I have played with this field and really fantastic to have this feature in SharePoint. It's going to be very useful in our applications. I have wasted around 30 minutes of time to find where is the Geolocation field to manually add from browser. I searched in the Site Columns list and didn't find it. Thought I have to activate any features and searched Site collection features and site features.... But no luck.After did some research and found that we have to add the Geolocation field through programming. Is it? really? Why? So many questions and started doing research more time and everyone given the examples in C# (Server side coding) to add Geolocation field to a list. OK. now what? Below is what I have did to check the Geolocation functionality.Things you have to know:The Geolocation field is available in SharePoint 2013 out of the box. But it will not be available through browser to add to a list. (I am not sure this will be changed in RTM.)You must install the component "SQLSysClrTypes.msi" on all WFE to get this functionality working. Add the Geolocation field through programming. I prefer to use client object model ECMAScript.Please follow steps below to test the Geolocation functionality. Create a new page in your site. Add Script Editor web part to the page.From "Edit this web part" option -> click on EDIT SNIPPET button.In the snippet box add below code.
    List name:
    After you pasted the above code the snippet shows the preview and click OK.Now save your changes and check the page. It should look like below.Enter the list name and click the button to add the Geolocation field to the list given.Now, when you try to add a new item in the list you will see the options below.Another nice addition t[...]

    Sorry there was something wrong with the download. Try adding it again error in SharePoint 2013 Apps


    **Update: The issues is resolved in RTM release. The issues was coming only in the preview version.

    I know everyone should get this error when they try to add an app from the SharePoint Store. Yes, it is a bug and whatever App you want to add to the SharePoint 2013 site you will see the below error.

    Sorry, there was something wrong with the download. Try adding it again
    I have gone through the logs of SharePoint and I found different errors logged for different apps I am adding. Below are the errors I found…
    1. The market web service is not configured. Return null
    2. App does not exists in market place web service
    3. The specified application identifier is invalid or does not exist.
    All the above errors not given any right information on what's failing. I believe the noderunner.exe is running out of memory or any request is failing because of the out of memory exception. For now I don't have any clue why it is failing. I will update the post when I find the solution for this issue.

    When I search on net and from forums the only suggestion I found was "check the app management service is running". Yes, it is running and it should not be the issue.

    SharePoint and Office 2013 RTM announced


    Wow. It's too early than expected. Great! The Office 2013 and SharePoint 2013 RTM are announced and it will available from mid-November.
    Office team says they provide Business customer with early access for testing, piloting and adopting office within their organizations and give feedback to improve their products.
    • We will begin rolling out new capabilities to Office 365 Enterprise customers in our next service update, starting in November through general availability.
    • Volume Licensing customers with Software Assurance will be able to download the Office 2013 applications as well as other Office products including SharePoint 2013, Lync 2013 and Exchange 2013 through the Volume Licensing Service Center by mid-November. These products will be available on the Volume Licensing price list on December 1.
    • IT professionals and developers will be able to download the final version via their TechNet or MSDN subscriptions by mid-November.
    You can stay tuned my blog for more information and news about the new products related to SharePoint and Office. Awaiting for RTM versions.

    Limits and Boundaries of SharePoint 2013


    As we all know boundaries are absolute limits that cannot be exceeded by design. When we are planning to design a farm we should keep all these limits to avoid future issues. Perfect example of boundary is document size limit: 2GB. It’s by design and the absolute limit and cannot be exceeded by design.
    Thresholds are those have a default value that can be change in certain circumstances. Default the document size is 50MB and you can increase up to 2GB.

    Main limitations:

    • Allows 2,50,000 site collection per web application.
    • 300 Content Databases per web application. Earlier in 2010 it supports up to 200 content databases.
    • 5 zones per web application.
    • 200GB content database size general usage, 4TB in all usage scenarios (didn’t change from earlier version.) and no limit on document archive scenario.
    • Each content database supports till 60 million items including list, library, app etc. items.
    • Per content database default limit is 2000 maximum and 5000 is boundary.
    • Total web sites (sub sites) are 2,50,000 per site collection
    • 30 million documents/items per library or list
    • Max security groups per a user can belongs to are 5000
    • Each site collection can contain 2 million users
    • Each site collection can supports till 10000 SharePoint groups.
    • Each farm can contain up to 20 search service applications
    • Each search service application can have up to 50 content sources
    To check all the boundaries and limits please go through the Technet article.

    How to create tiles for SharePoint


    Syncfusion tool is excellent to create the tiles. They have plenty of icons to create our custom tiles to use them in the new windows platform. I am using this software to create tiles for my SharePoint 2013 site. Really cool and strongly suggest you to use it.

    Download it here.

    SharePoint Designer 2013 design view?


    I know the designer fans are not happy when they hear the news about it. The design view is completely removed by Microsoft with no reason. The only mode available is Code view. For each change you are doing, you have to preview it by running the Preview in Browser option. Not good right?

    But, the good news is that SharePoint 2013 sites can be opened through SharePoint Designer 2010. I know it's not recommended by Microsoft, but we can use it for now to get the design and code view for our implementations. If you need to implement pages, web parts requires design view then go for SharePoint designer 2010. Otherwise you can use improved designer 2013 for workflows, styles etc..

    Event receivers for Users, Roles, Groups, Inheritance SharePoint 2013


    Wow. This is excellent news for me, no for all of us. The question we have discussed almost 15-20 times since SharePoint 2007 was released is "Site Permissions, People and Groups are also SharePoint lists, are there any event receivers bound to them?". This is needed for us to track the security for specific sites. For example, when someone is trying to add/edit/delete a user we like to track all of them we don't have any way in 2007, 2010 versions. Now, with these new event receivers we can track the security and can have full control over the complete SharePoint security by implementing the custom solutions. Really it's a great thought to have event receivers on these. The new event receiver class is "SPSecurityEventReceiver".

    Below is the list by category the new event receivers.

    SharePoint User, Role Events
    1. GroupUserAdded
    2. GroupUserAdding
    3. GroupUserDeleted
    4. GroupUserDeleting
    5. RoleAssignmentAdded
    6. RoleAssignmentAdding
    7. RoleAssignmentDeleted
    8. RoleAssignmentDeleting
    9. RoleDefinitionAdded
    10. RoleDefinitionAdding
    11. RoleDefinitionDeleted
    12. RoleDefinitionDeleting
    13. RoleDefinitionUpdated
    14. RoleDefinitionUpdating
    SharePoint Group Events
    1. GroupAdded
    2. GroupAdding
    3. GroupDeleted
    4. GroupDeleting
    5. GroupUpdated
    6. GroupUpdating
    Permissions Inheritance Events: Great, this is really wonderful.
    1. InheritanceBreaking
    2. InheritanceBroken
    3. InheritanceReset
    4. InheritanceResetting
    This is wonderful addition and it can be the answer for plenty of security issues in SharePoint. Great, great, great.

    Download SharePoint 2013 tutorials and eBooks


    SharePoint 2013 is now a hot product from Microsoft with new UI and completely new features, we should learn them to keep ourselves up to date. Below are the links for documents and eBooks to know more about them.

    For all content on SharePoint 2013 in MSDN site found here.

    You can see the complete details on all kind of downloads related to SharePoint 2013 here.