23 May, 2013

Hide Title column in list in SharePoint 2010

Unlike SharePoint’s predefined lists, your custom list has only one column when you first create it — the Title column. Unfortunately, you can’t delete the Title column or change its data type, but you can rename or hide it.

Here are the complete details as how to hide the title column from the list. 

Please check and let me know in case of any queries/questions so that we can discuss and proceed further, Thank you.


-It’s actually a two-step resolution-

First step: Removing from the view
1.    Open the list
2.    List settings
3.    Views Section
4.    Click on ALLITEMS view
5.    Uncheck the title column
6.    Click OK

Second Step: Actual Hiding
1.    Open the list
2.    List settings
3.    Advanced settings
4.    Check the ‘allow management of content types’ option to Yes.
5.    Click OK
6.    Now refer to ‘item’ which is present under the content type section
7.    Click on the item content type
8.    Click on ‘Item’ under the columns
9.    Here you will get the option to hide it completely 

Product Applies To:
·         SharePoint Server 2010
·         SharePoint Foundation 2010
·         SharePoint Server 2013

List View Threshold in SharePoint 2010

One of the major reasons that this List View Threshold (LVT) feature was created is to protect the server from unintentional load that may either bring it down, or at least cause other users higher latency or failures. 

The performance of any SharePoint site, especially one that contains lists and libraries with many items, is directly affected by decisions made when setting up and planning a SharePoint site.



Error Message:
SharePoint list error: lookup and workflow status columns exceed the threshold.

Problem Description:
Users get this error when accessing a SharePoint list:

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.

Resolution:
Follow below steps:
1.    Open the SharePoint Central Administration
2.    Application Management
3.    Manage Web Application
4.    Select Your Web Application
5.    General Settings
6.    Resource Throttling
7.    By default List View Lookup Threshold is 8 change it as per your requirement and
8.    Finally click OK to save it.

If you have any queries/questions then please let me know, thank you.

Product Applies To:
·         SharePoint Server 2010
·         SharePoint Foundation 2010
·         SharePoint Server 2013

22 May, 2013

How to change the site collection administrators in central administration by means of PowerShell

Few days before, one of my user came to our team and requested to have a list of site collection administrators as well as to change the admins for few site collections.

In fact it's quite easy if you do by means of GUI i.e. Central Administration.

Let me brief some steps so that it would be useful to you.
-Open Central Administration
-Application Management
-change site collection administrator
-change the admins as per the requirements



this will be hectic task if you have to implement the same for more site collections i.e. bulk activity.

so that's why I come up with the solution so that it would be beneficial for everybody.

here is the script that i am talking about:
Set-SpSite "http://sharepointdemo.skylark.com" -owneralias "domain\user1" -SecondaryOwnerAlias "<domain\user2>"

If you wanna add a list of users to the site collection administrators group of every site on your SharePoint 2010 farm then please refer this:

If you have any queries/questions regarding the above mentioned information then please let me know, thank you.

Product Applies To:
-SharePoint Server 2010
-SharePoint Foundation 2010

References:
Remove a site collection administrator in SharePoint 2013

To add a primary or secondary site collection administrator by using Windows PowerShell in SharePoint 2013

Change the primary or secondary site collection administrator in SharePoint 2013

add a site collection administrator by using Central Administration

To add a site collection administrator by using Windows PowerShell

Remove a site collection administrator
http://technet.microsoft.com/en-us/library/ff631156(v=office.14).aspx

21 May, 2013

Windows could not start the SharePoint 2010 administration service on local computer.

Infrastructure:
SP Version: Microsoft SharePoint Server 2010-SP1
Server: Windows Server 2008 R2

Problem Description: Not able to start the SharePoint Administration 2010 Service by means of services.msc console.

Error Message: Windows could not start the SharePoint 2010 administration service on local computer.

Issue identified by: Central Administration's Health Analyzer



Troubleshooting done:
- Tried starting the service by means of farm account in the services console with respect to the server where it was failing but got the error message as follows:

Windows could not start the SharePoint 2010 administration service on local computer.

- Tried start the service by means of PowerShell but got the same message as above.

Resolution applied:
Increased the default service time-out

·         Click Start, click Run, type regedit in the Open box, and then click OK.
·         Locate and then select the following registry subkey:
·         HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
·         Right-click Control, point to New, and then click DWORD Value.
·         In the New Value box, type ServicesPipeTimeout, and then press Enter.
·         Right-click ServicesPipeTimeout and then click Modify.
·         Click decimal, type the number of milliseconds that you want to wait until the service times out, and then click OK.

For example, if you want to wait 60 seconds before the service times out, type 60000.

Exit Registry Editor and then restart the computer.

-restarted the server and issue has been resolved.

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.

Product Applies to:
SharePoint Server 2010
SharePoint Foundation 2010

References:



19 May, 2013

Document set in sharepoint 2010


Normally banks will maintain customer’s information. They will provide customers basic info, internet banking, mobile banking, debit card facilities to their customers, they maintain separate documents for each.
We will use the same feature using Document set in SharePoint 2010.
How to enable Document Sets?

Document sets by default won't be enabled in SharePoint 2010. It's a feature and has to be enabled manualy. Then document sets Content type has to be customized (if required). After that it can be attached to Document libraries. First keep all project document templates (BasicInformation document, PhoneBanking document, InternetBanking Document, Debitcard Document) ready.
Create these documents in my documents folder.
 
Login to SharePoint 2010 site -> Site settings -> Site Administration -> Site Collection Features ->

Document Sets -> Activate.

Site Settings -> Galleries -> Site Content types -> Document Set Content Types -> Document Set.

Select Document Set Settings.

Under Default Content section select the templates. Click "Add new default content" to select and upload more template documents.

Now upload the documents that u created earlier as shown below


Now we'll create new document library. If you want to attach to existing document library then skip this step.

Open the document library -> Library (Tab) -> Library Settings.

Under General Settings select Advanced Settings. We need to enable allow management of content types setting.

Under Content types Select Yes for "Allow management of content types?" and save/Click Ok.

Now in the library settings page Content types section will be shown. Select "Add from existing site content types".

Under "Select Content types" section select "Document Set" and Add. Now click Ok.

 







Repeat the same steps and add another