Tag Archive SharePoint Architecture

AvatarByRashid Aziz

Build a Modern SharePoint Intranet using Communication Template

SharePoint is a new, modern platform for seamless collaboration, interaction and content management. SharePoint intranet allows members to set up a secure space for the document, data and information sharing, social activities, news, and events. For maximum efficiency of communication and team productivity, SharePoint communication site is the real thing. Communication sites are out-of-the-box sites where each team member can stay aware of what’s going on, up-coming events contribute to discussion and company announcements.
Communication sites are elegant, not only because of dazzling layouts, but it is genuinely responsive and mobile friendly. The communication site templates allow sharing a large amount of data and information like contents, news and events.

It’s straightforward and super fast to create communication sites. Follow the following steps to build a cool-looking site.

Create a Communication site

1. Sign in to your Office 365 portal.
2. Select the app launcher icon from the top left corner of the page and then select the SharePoint icon.
3. From the SharePoint home page, click + Create site and choose the Communication site template option.

4. You can select one of the following three site designs:
• Topic site to share information such as news, events, and other content.
• Showcase site to use photos or images to showcase a product, team, or event.
• Blank site to create your design.

5. Enter the name for the new communication site and description box.
6. Click Finish. Your site will be created and will appear on the sites you are following. Note: (Your site will not inherit the permission settings or navigation of any other sites).

Setup the Layout for Communication Site

The new layout section offers you to change the page layout to accommodate any site design with contents effectively.

As you can see In above Image, you can now use new modern site templates to make a digital workplace and leverage Communication sites for a global SharePoint Intranet. You can still request the developers to build custom web parts (using new SharePoint Framework) if you have any intranet requirements if they are not covered in the communication site template.

KeaPoint is a SharePoint & Office 365 consultancy based in the UK, dedicated to empowering users through smart solutions. Our experience and skill set continues to expand in many areas. We develop solutions according to the best business practices in the industry.
If your organisation needs assistance with SharePoint & Office 365 and would like to see how KeaPoint can help, please get in touch.

AvatarByRashid Aziz

Create Managed Property from Crawl Property in SharePoint 2013 Search via PowerShell

I have some custom properties in User Profile. I needed to create managed properties in SharePoint 2013 from custom user profile Crawl properties. I really don’t like doing things manually using SharePoint 2013 central administration site because then I have to recreate these properties on all different environments manually. So here is the script which will do the magic

User profile property name: City 

Crawl property display name: People:City

Crawl property full name: urn:schemas-microsoft-com:sharepoint:portal:profile:City 

You can get the crawl property full name from central admin UI

(Click on “search schema” link from search administration page 

Click “Crawled Properties” link

Search for your property, once it appear in result, click on it.

Crawl property detail page will open and will display the “Property Name” something like “urn:schemas-microsoft-com:sharepoint:portal:profile:City”) 

// Get the search service application

$searchapp = Get-SPEnterpriseSearchServiceApplication

// create base managed property 

$managedProperty_City= New-SPEnterpriseSearchMetadataManagedProperty -Name "City" -SearchApplication $searchapp -Type 1 -Queryable $true -Retrievable $true -FullTextQueriable $true

//Set “Refineable” and “Sortable” properties to true for this newly created managed property, by default these values will be set to false. You can skip this step if you don’t want to set the values to true




//Get the crawl property which already exist and map it to the newly created managed property

$crawlProperty_City= Get-SPEnterpriseSearchMetadataCrawledProperty -SearchApplication $searchapp -Limit 1 -Name "urn:schemas-microsoft-com:sharepoint:portal:profile:City"

New-SPEnterpriseSearchMetadataMapping -SearchApplication $searchapp -ManagedProperty $managedProperty_City -CrawledProperty $crawlProperty_City

Once you run these command, go to search schema page and search for the new managed property “City”. You should see the following result


Reference to get parameters detail: https://technet.microsoft.com/en-us/library/ff608089.aspx 


AvatarByRashid Aziz

How to setup auto site deletion feature of SharePoint 2010

Step by step procedure to set SharePoint up to automatically cleans out unused sites:

Step # 1:

Central admin   navigates to    Application Management —–> Site Collections ——> Confirm site use and deletion 

Step # 2:

Choose Web Application  to be used for setup auto site deletion.

For Example: Use My Site Web Application. Then you have to check some of the given choices. Further changes can be made by choosing either Check for unused site collections, and send notices Daily/Weekly/ Monthly.

a).An e-mail notification will be send to owners of unused site collections. Send notifications 90 days after site collection creation, or use is confirmed.

b).Automatically delete the site collection if use is not confirmed delete the site collection after sending 28 notices you can change the 28 notification.


Also set up previously mail flow between SharePoint and your end users.

AvatarByRashid Aziz

How to upgrade SharePoint 2007 site to SharePoint 2010

Upgrade SharePoint 2007 Site to SharePoint 2010

There are lot of people out there who are really excited about the SharePoint 2010 release. Today I will be providing you with a guide to upgrading your SharePoint 2007 content databases to SharePoint 2010 using database attach upgrade method.
To complete this operation, you need to complete the following steps

1.       Pre Upgrade Check

This will be our primary analysis and reporting tool  which will provide information regarding your SharePoint 2007 farm and actions that may be required to take prior to upgrading to SharePoint 2010 
Launch a Windows command prompt on your SharePoint 2007 Server and go the the stsadm directory path which is given below.
C:\PROGRAM FILES \COMMON FILES\Microsoft Shared\Web Server Extensions\12\bin
Run the following command
stsadm.exe –o preupgradecheck
When the pre-upgrade process completes, you will receive the following message “Operation completed successfully” .It will then launch your web browser displaying the results in HTML format, titled “SharePoint Products and Technologies Pre-Upgrade Check Report”.  These results can also be located under the following location
C:\PROGRAM FILES \COMMON FILES\Microsoft Shared\Web Server Extensions\12\Logs

2.       Backup database using PowerShell

Below is the PowerShell script to do database backup. You need to change SQL server name, database name and location where you want to save backup file. You can also do database backup using SQL management studio.
$s = New-Object (‘Microsoft.SqlServer.Management.Smo.Server’) “localhost”
$dbBackup = new-object (“Microsoft.SqlServer.Management.Smo.Backup”)
$dbBackup.Database = “WSS_Content_Intranet”
$dbBackup.Devices.AddDevice(“C:\Test\WSS_Content_Intranet.bak”, “File”)
Copy the database backup file to your SharePoint 2010 machine.

3.       Restore database using PowerShell

Below is the PowerShell script to do database restore. You need to change SQL server name, database name and location of the database you want to restore. You can also restore database using SQL management studio.
[System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.SMO’) | out-null
[System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.SMOExtended’) | out-null
$s = New-Object (‘Microsoft.SqlServer.Management.Smo.Server’) “localhost”
$dbRestore = new-object (“Microsoft.SqlServer.Management.Smo.Restore”)
$dbRestore.Database= “WSS_Content_Intranet”
$dbRestore.Devices.AddDevice(“C:\Test\WSS_Content_Intranet.bak”, “File”)
$dbRestore.NoRecovery = $false
$dbRestore.ReplaceDatabase = $true

4.       Create your SharePoint 2010 Web Application and Site Collection

Go to SharePoint 2010 central admin and under “Application Management” click “Manage Web Applications”
Click “New” under “Web Applications” tab
Fill new web application form and click “Ok”
Fill the required fields and click “Ok” to create site collection

5.       Verifying the Content database

The Test-SPContentDatabase is a great reporting tool that will list any missing setup files, web parts and provide you with information on how to remedy any errors.  It will also specify whether these missing features will block the upgrade from succeeding. 
Test-SPContentDatabase –Name <database name> -WebApplication <URL>
Launch the SharePoint 2010 Management Shell and type the above command, ensuring you have entered your Database Name and URL. e.g. below
Test-SPContentDatabase –Name WSS_Content_Intranet -WebApplication http://testsite

6.       Remove Database from Web Application

Ensure that there are currently no databases connected to the web application that we will be attaching to.  You can check this via Central Administration / Application Management / Manage content databases. 
Go to SharePoint 2010 central admin and click “Manage Content Database” under “Application Management”
Select your newly created web application “testsite” and click on the database which is attached to it.
Check “Remove Content database” and click “Ok” to remove content dataset from web application.

7.       Attach database to SharePoint 2010 web Application

We can now proceed and attach our restored SharePoint 2007 database via the following stsadm command line 
stsadm -o addcontentdb -url <URL> -databasename <database name>
In my instance, the command looked as follows;
Stsadm –o addcontentdb –url http://testsite –databasename WSS_Content_Intranet
We can now verify that the upgrade was completed successfully by first navigating back to Central Administration / Application Management / Manage content databases, which now displays the upgraded database under my designated Web Application.
We can also view the upgrade status page which is located within Central Administration / Upgrade and Migration / Check upgrade status.

8.       Visual Upgrade

To perform the Visual upgrade, navigate to Site Actions / Visual Upgrade. You can also user PowerShell script to perform visual upgrade to all sites and sub sites in site collection. Script is given below. You need to change the database in the given script name according to your environment.
$db = Get-SPContentDatabase WSS_Content_Intranet
$db.Sites | Get-SPWeb -limit all | ForEach-Object {
$_.UIversion = 4; $_.UIVersionConfigurationEnabled = $false;
Go to SharePoint 2010 central admin and click “Create Site Collections” under “Application Management”