Thursday, 29 November 2012

Hide a SharePoint List using SharePoint Designer 2010




With SharePoint Designer 2010 it is possible to hide a list.

Just select the list an enable hidden

 




If you want to hide a list please uncheck "Display this ilist on the Quick Launch" otherwise you can not hide the list
After saving this works realy fine. You also would not see the list in SharePoint Designer again.
You can if you know the URL browse to the list and work with this list, but you can not configure it in SharePoint Designer.
There is a way to make the hidden list available again.
Select in SharePoint Designer in "All Files"/Lists with a right click the hidden list.
 



Then choose Properties
Now you can change all settings in SharePoint Designer and also change the hidden attribute



Create an Enterprise wiki (SharePoint Server 2010)

You can create an Enterprise wiki by two ways:


  •     Create an Enterprise wiki by using Central Administration
  •     Create an Enterprise wiki by using Windows PowerShell

    To create an Enterprise wiki by using Central Administration

    1. Verify that you have the following administrative credentials:
      • To use Central Administration, the user account that is performing this procedure must be a member of the Farm Administrators group.
    2. On the Central Administration Web site, in the Application Management section, click Create site collection.
      note Note:
      You can also create an Enterprise wiki as a sub-site of another site by clicking New Site on the Site Actions menu.

    3. In the Web Application section, click the Web Application drop-down list to select the Web application where you want to create the Enterprise wiki.
    4. In the Title and Description section, type a title in the Title box and, optionally, type a description in the Description box.
    5. In the Web Site Address section, select / to create the Enterprise wiki at the root of the Web application, or select /sites/ to create the Enterprise wiki site at a specific path. If you select /sites/, you must also type the site name.
    6. In the Template Selection section, click the Publishing tab, and then click Enterprise Wiki.
    7. In the Primary Site Collection Administrator section, type the user name for the user who will be the site collection administrator.
    8. In the Secondary Site Collection Administrator section, type the user name for the secondary administrator of the site collection.
      Designating a secondary site collection administrator is a best practice to ensure that someone can manage the site collection when a primary site collection administrator is not present.
    9. If you are using quotas to manage storage for site collections, in the Quota Template section, click a template in the Select a quota template list.
    10. Click OK.

      Create an Enterprise wiki by using Windows PowerShell

      You typically use Windows PowerShell to create an Enterprise wiki when you want to automate the task, which is common in enterprises.

      Create an Enterprise wiki by using Windows PowerShell

      Verify that you meet the following minimum requirements: 
      1. On the Start menu, click All Programs.
      2. Click Microsoft SharePoint 2010 Products.
      3. Click SharePoint 2010 Management Shell.
      4. From the Windows PowerShell command prompt window (that is, PS C:\>), type the following commands:
        1. To display all the site templates, type the following command:
          Get-SPWebTemplate
          
        2. To create a variable that contains the name of the Enterprise wiki template, type the following command:
          $wikitemp = Get-SPWebTemplate "ENTERWIKI#0"
          
        3. To create an Enterprise wiki site, type the following command:
          New-SPSite http://contoso.com/CWiki -OwnerAlias <domain\user> -Template $wikitemp
          
          Where <domain\user> is the user name of the site owner.

      A very good article by Bernd Kemmler on Wiki's in SharePoint 2010 . Have a look. I am sure it will resolve your query.

How to import a macro files in Microsoft Word file



      Open a new work document



·         Now Press “Alt + F11” to import the .bas file.





Wednesday, 28 November 2012

2 simple steps to restrict users to view and edit SharePoint 2010 list items created by them


Many times user has to be restricted to view and edit list items which are created by them.

One way to do this to edit the view and add filter on Created By to [Me], we might have to do this on each view and what if we’ve to allow some users to view and edit items created by others then we’ll have to replicate the same view with different filters to users who can view and edit all.

Now there is another simpler way by which we can apply the same restriction to all views and also allow certain users to view and edit all items by simply giving them full control permission on the list.

To apply this restriction, simple go to List settings and then Advance Settings, change item-level permissions as below screen shot and yep it’s done.

Change_Item_Level_Permissions

SharePoint View to automatically show list data only the current month?


Create a CC "NextMonth" that adds one month to your date =DATE(YEAR(Modified),MONTH(Modified)+1,"1")
create a view "ThisMonth" with this filter
"NextMonth" is greater than [Today]
this will always return the current month. can also be allpied to Year, to return current year
Create a CC "NextYear" that adds one year to your date =DATE(YEAR(Modified)+1,MONTH(Modified),"1")
create a view "ThisYear" with this filter
"NextYear" is greater than [Today]

If you want to show list data for last 2 months, then you have to just modify the formula as below:
 =DATE(YEAR(Modified),MONTH(Modified)+2,"1")

Enjoy !