Tuesday, August 23, 2011

Uploading Multiple Files with Drag and Drop

 

A nice enhancement in SharePoint 2010 is the multiple document upload functionality. Now you may drag and drop files directly into a newer Internet Explorer browser (IE 8+) and have these files uploaded to your SharePoint list. When you are cranking away with 50 applications open, this little trick will save you some time!

Remove a list in SharePoint 2010 from the Quick Launch toolbar

 

You can use Windows PowerShell to remove a list in SharePoint 2010 from the Quick Launch toolbar. Simply store an instance of an SPList Object, set the OnQuickLaunch property to $false, and update the SPList object.

PS > $spWeb = Get-SPWeb http://sp01/site

PS > $spList = $spWeb.GetList("http://sp01/site/Lists/MyList")

PS > $spList.OnQuickLaunch = $false

PS > $spList.Update()

Related Lists

 

In SharePoint 2010, there is an easy way to create Relational Lists, which will help make a connection between two Web Parts that display data from SharePoint lists. The Relational List feature will automatically make a Web Part connection between the Web Parts and set the connection to use the look-up fields on the two lists. You can go to a page where you have one or more Web Parts displaying content from a list to set up Relational Lists. You should turn on the page’s edit mode and then click on the Web Part Tools’ tab found on the Ribbon.

Use Thesaurus Files to create synonyms or replacements in Search Queries

 

Thesaurus Files are a way for administrators to improve search results by creating synonyms or replacement words used in their queries. For example, you can create a synonym for the word SharePoint so when a user is making a search for the word WSS, you would also get results with the word SharePoint.

The Thesaurus Files are located on the SharePoint server in the folder: %ProgramFiles%\Microsoft Office Servers\14.0\Data\Applications\[GUID]\Config where the [GUID] is the GUID of your Search Service Application.

Hide a list in SharePoint 2010

 

You can use Windows PowerShell to hide a list in SharePoint 2010. Simply store an instance of an SPList Object, set the Hidden property to $true and update the SPList object.

PS > $spWeb = Get-SPWeb http://sp01/site

PS > $spList = $spWeb.GetList("http://sp01/site/Lists/MyList")

PS > $spList.Hidden = $true

PS > $spList.Update()

Understand database mirroring requirements for disaster recovery purposes

 

SharePoint 2010 is mirroring aware and utilizes the FailoverPartner keyword in its database connection strings to identify a SQL Server instance that is used for mirroring purposes. Upon learning this, it might be tempting to jump right in and start mirroring SharePoint databases for redundancy. Before doing so, though, you should be aware that the following requirements apply:

  • Less than 1ms latency between principal and mirror SQL Server instances
  • 1GB/s bandwidth or greater between principal and mirror SQL Server instances
  • Principal and mirror instances must be running the same version and edition of SQL Server
  • Mirrored databases must use the Full recovery model
  • High safety with automatic failover (that is, synchronous mirroring with witness server) is recommended

Mirroring is certainly useful, but as the aforementioned list demonstrates: it shouldn’t be implemented without careful planning and infrastructure design.

Find information about your SharePoint databases

 

You can use the Get-SPDatabase cmdlet to display information about the SharePoint databases.

PS > Get-SPDatabase

The example above displays all SharePoint databases. If you want to display a specific Database, use the identity parameter followed by the database ID.

PS > Get-SPDatabase -Identity f9213ca2-3604-42e5-b6cf-92740fbed83a

Directly Sending Files Stored in SharePoint

 

The single best way to share documents with your peers is using the “E-mail a Link” function that is built right in the Ribbon. Occasionally, your recipients do not have access to your SharePoint environment, and you need to resort to the old-fashioned route by emailing these email attachments.
Below is a two-step process that lets you sends documents that are stored in SharePoint directly via Microsoft Outlook.

  1. Navigate to the designated Document Library. Click on Library > Connect to Outlook.
  2. After a series of prompts, the documents will be added to the “SharePoint Lists” in Outlook. You can now preview and forward these documents as attachments without first having to download them.

Add a new service application pool

 

You can use the New-SPServiceApplicationPool cmdlet to create new Web service application pools in IIS.

PS > New-SPServiceApplicationPool -Name “AppPool” `

>> -account (Get-SPManagedAccount domain\account)

Access to XMLHttpRequest at 'from origin has been blocked by CORS policy: Cross origin requests are only supported for protocol schemes: http, data, chrome, chrome-extension, https. .net core angular

Issue: The angular application was getting error from API that the origin has been blocked by CORS policy. Solution: Make sure that the...