February 2011 - SharePoint Tips

  • Set the maximum storage size of a Site Collection

    Niklas Goude -Expert in Residence You can control the maximum storage size of a Site Collection by using the Set-SPSiteAdministration cmdlet. You can type if you want to limit the Site storage to 500MB: PS > Set-SPSiteAdministration -Identity http: // SP01 ` >> -MaxSize 500MB ReTweet this Tip!
  • Create A SharePoint List From A Microsoft Excel Spreadsheet

    Mattias Karlsson -Expert in Residence With the “Import Spreadsheet” feature in SharePoint, you can take an existing Microsoft Excel spreadsheet and convert it into a SharePoint list. This is particularly useful when you have a lot of data in a spreadsheet that you want to import into SharePoint, or if you need to create a new list that should contain a lot of columns. This makes it easier to use the first row in your spreadsheet and type...
  • Set The LockState Of A Site Collection

    Niklas Goude -Expert in Residence You can control the lock state of a Site Collection by using the Set-SPSiteAdministration cmdlet. There are four levels of LockState available: • Unlock - Sets the site collection to unlock • NoAdditions - No new content can be added as only updates and deletions are allowed • Readonly - Sets the site collection to read-only • Noaccess - Sets the site collection to unavailable to all users You...
  • Display The Left Navigation Menu

    Anjali Sharma -Expert in Residence The left navigation menu is available out of the box and can also be customized by the navigation settings in the site settings menu. By default, the left navigation does not appear in a web part page. To show the left navigation, customize the page in SharePoint Designer via these simple steps – Delete or comment out these tags : <SharePoint:UIVersionedContent ID="WebPartPageHideQLStyles" UIVersion...
  • Failover Database Servers

    Mattias Karlsson -Expert in Residence A new feature in SharePoint 2010 is that SharePoint is now “mirroring-aware.” As you may have seen when creating a new content database in SharePoint 2010, you have the option to specify the failover server. This property can be used when you have set up a mirroring of the SQL-layer, allowing SharePoint to add the failover server to the connection string. In case of a SQL-Server time-out, this allows...
  • Integrate Active Directory Fields Into SharePoint Via The User Profile Import Service

    Anjali Sharma -Expert in Residence One common business requirement is to direct various tasks to a user’s supervisor(s) for approval, feedback or review. For most organizations, the supervisor’s or manager’s information is stored in Active Directory. The Active Directory fields can be integrated into SharePoint via the user profile import service. With SharePoint 2010 Designer, a new out-of-the-box feature is the ability to query...
  • Find A Site Owners User Name And Email Address

    Niklas Goude -Expert in Residence You can find a Site Owners User Name and Email Address in a Site Collection by using the Get-SPSiteAdministration cmdlet and then selecting the OwnerLoginName and OwnerEmail properties. PS > Get-SPSiteAdministration -Identity http: // sp01 | >> Select-Object OwnerLoginName, OwnerEmail OwnerLoginName OwnerEmail -------------- ---------- POWERSHELL\owner owner@powershell.nu ReTweet this Tip!
  • Make Documents Available From Everywhere Using Office Web Apps

    Mattias Karlsson -Expert in Residence A much anticipated new feature in SharePoint 2010 is the Office Web Apps, which is an online version of Excel, PowerPoint, Word, and OneNote. This will enable you to view and edit these documents without an Office client application. While the features available when editing documents are limited, you are able to view documents from anywhere. Installed as a separate installation, Office Web Apps is activated through...
  • Create A New Search Center Site That Can Be Easily Customized

    Anjali Sharma -Expert in Residence The out-of-the-box search results page renders a physical page on the SharePoint Server 14 hive. This page is not easily customized. Instead, create a new search center site which generates the search results page in the pages library that can be easily customized by adding or removing web parts. The search settings should be modified to direct the search results to this page. ReTweet this Tip!
  • Find Out The Number Of Users In A Site Collection

    Niklas Goude -Expert in Residence You can find out how many users there are in a Site Collection by using the Get-SPSiteAdministration cmdlet and selecting the UsersCount Property. PS > Get-SPSiteAdministration -Identity http: // sp01 | >> Select-Object Url,UsersCount Url UsersCount --- -------- http://sp01 12 ReTweet this Tip!
  • Site Columns

    Mattias Karlsson -Expert in Residence It would sometimes be useful to reuse a specific column and its content in lists or document libraries. For example, you may want to have a column containing a security classification in your document libraries. This can easily be achieved by using Site Columns, which are columns located at the site level that can be reused throughout your site. Site columns are created from Site Actions -> Site settings ->...
  • Customize Any SharePoint List Using An InfoPath Form

    Anjali Sharma -Expert in Residence Easily customize any SharePoint list using an InfoPath form. The SharePoint 2010 ribbon menu gives a ‘customize form’ option that opens the list in InfoPath if installed on the client machine. This allows for applying a new and easy look and feel for any SharePoint List as well as adding custom controls to achieve business needs. ReTweet this Tip!
  • Find Out How Much Disk Space A Site Collection Uses

    Niklas Goude -Expert in Residence You can use the Get-SPSiteAdministration cmdlet and select the DiskUsed Property if you want to find out the amount of disk space a Site Collection uses. PS > Get-SPSiteAdministration -Identity http://sp01 | >> Select-Object Url, DiskUsed Url DiskUsed --- -------- http://sp01 3908682 ReTweet this Tip!
  • Manage Content Using Content Types

    Mattias Karlsson -Expert in Residence Content types were introduced in SharePoint v.3 and are a powerful way to manage content. You could easily describe content types as a collection of metadata, which can then be reused throughout your SharePoint farm. Examples could include sales reports or invoices that you always wanted to contain in your set or collection of metadata. You can even connect templates, such as Word or PowerPoint documents to your...
  • Using SharePoint 2010 Themes

    Anjali Sharma -Expert in Residence SharePoint 2010 themes are very powerful for end users, as users can easily change colors for various content areas on a SharePoint site without the need for custom development. For simple custom branding that does not require changing the placement of controls on the page or drastic re-alignment, this approach offers a simple yet powerful way to give a new look and feel to a website. Additionally, custom themes...
1 2 Next >
Idera SharePoint Reviews SMBology, Inc. Rackspace Hosting Sponsored by Idera and SharePoint Reviews and SMBology and EPCGroup.net
Copyright 2011 SecretsOfSharePoint.com. All rights reserved.