My Sharepoint Learnings

The default limit of a single upload file in SharePoint is 50MB. The size limit can be increased upto 2GB, from central admin. To increase the size limit and any issues faced during upload of large files, check the link below http://blogs.technet.com/b/sharepointcomic/archive/2010/02/14/uploading-large-files-to-sharepoint-on-windows-server-2008-and-iis7.aspx As given in the link, it is not recommended to upload large files of size greater than 500MB thru sharepoint. The reason's why large file uploads are not recommended via browser is listed Reliably transferring gigabyte or bigger files without breakages over a protocol like HTTP, which is better suited for tiny transfers like images and text. Not killing your browser because it has to load all that in memory Not killing your web server because All that you upload through HTTP post, first gets streamed into IIS Memory, w3wp.exe memory before the ENTIRE FILE finishes uploading .. before it is stored. Which means, ...

·          In Central Administration, under Application Management, click on the Manage web applications. ·          Select the web application you want to enable anonymous access and click on the Authentication Providers icon in the ribbon ·          On the Authentication Providers pop-up window click on the Default zone ·          Under Edit Authentication, check Enable anonymous access and click Save. ·          Go back to Web Application Management click on the Anonymous Policy icon in the ribbon ·          Under Anonymous Access Restrictions select your Zone and set the Permissions to None – No policy and click Save. ·          Once in web application anonymous access is set, the option would c...

Federated search is a feature in Shareoint 2010, where results from external sites, other sharepoint farms, Local sites in same farm can be queried and results be displayed. On how to configure federated search, refer http://blogs.msdn.com/b/sharepoint__cloud/archive/2012/03/12/configure-federated-search-to-get-results-from-remote-another-sharepoint-2010-farm.aspx Consider a federated search webpart in farm B, where the search results are from Farm A. To know the usage of the federated search, will have to check the reports in source farm (Farm A). Go to central admin - Application Management - Manage Service Application - Click on the search service application On the left pane, Under Reports, click on Web Analytics report The usage report would show the total usage report of the search service application Say the search service application is used by a site collection and also by the federated search So, say it shows 1000 No of queries for the past 30 days. Site coll...

A quick and easy way to display a Thank you message at the end of survey for submitting the form. At the end of last question, insert a page breaker. After the page breaker, add the Thank you message as a question, and select the type Single line of text. Enter the default value as "Internal". Go to the survey form and click on Respond to Survey. Click Next and in the Editform url in the browser, append &ToolPaneView=2 to the end of URL. Add a CEWP to the below of the page and insert the below code, in HTML source or else paste the code in a text file uploaded to sharepoint library and refer to the text file. (referring the text file is preferred) <script> // hide the input textbox for the "thank you " message  var x = document.getElementsByTagName("INPUT");  var i=0;  for (i=0; i<x.length; i++)  {   if (x[i].value=="Internal")   {     x[i].style.display="none";   }  }  </script> Save the page. Respo...

In Sharepoint 2010, in the list ribbon there is an option Export to Excel, to get the list data in excel format. The same option can be given to the end user on click of a button in the page Create a content editor webpart. In the html source enter the following code <button type="button"  <a href="#" onclick="javascript:window.location='../_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List= ListGuid &View= ViewGuid &CacheControl=1'"><img src="/_layouts/images/icxlsx.gif" border="0"/>&nbsp;&nbsp; Export to Excel</a> </button>

Calculated columns is one of the types available in SharePoint. Some important rules and guidelines are as follows: The functions TODAY and ME are not supported in calculated columns but are supported in the default value setting of a column. Arithmetic operators supported include + (addition), - (subtraction), * (multiplication),/ (division), % (percent), and ^ (exponentiation). In Equations parenthesis are allowed. The allowed Comparison operators are  = (equal to), > (greater than), < (less than),>= (greater than or equal to), <= (less than or equal to), and <> (not equal to). & (ampersand) is used to connect 2 values and produce one continuous text value. A value other than the current row cannot be referenced A value in another list or library cannot be referenced. The RAND and NOW functions is not supported in Lists and libraries. Most of the Excel functions are supported in SharePoint calculated columns, but not all.

In SPD workflows, under Actions, there is a set of Utility functions. Using the substring function, a string can be trimmed from the beginning/end/or from a position, with or without specifying the length. An example, to remove the domain part from the user name, e.g. abcdomain/username, follow the below steps 1.        Use “Extract substring from the index of string” 2.        It would insert a step in WF as “Copy from string , starting at 0 (Output to Variable: substring ) 3.        Click on ‘string’ and click fx to get the field to be trimmed. 4.        It would bring the look-up window. 5.        Select the field and click OK. In this e.g., Data Source: Current Item and Field from Source: Created By 6.        To set the index, click on 0 and enter the required number, here it would be 1...