European Sharepoint 2013 Hosting Blog
Articles about European Sharepoint Hosting Service
SharePoint 2013 Hosting France – Client Side People Picker In SharePoint 2013
Nov 23rd
In this post, I will tell you about how to use client side people picker in SharePoint 2013. The SharePoint people picker is already available in SharePoint as a server control, but now a days all are moving to client side based code since office 365 supports only client side. So we need to know how to be use people picker in client side.
Required JavaScript Library
The client side people works depends on multiples SharePoint JavaScript library,
|
1 2 3 4 5 6 7 8 |
<script src="/_layouts/15/sp.runtime.js"></script> <script src="/_layouts/15/sp.js"></script> <script src="/_layouts/15/1033/strings.js"></script> <script src="/_layouts/15/clienttemplates.js"></script> <script src="/_layouts/15/clientforms.js"></script> <script src="/_layouts/15/clientpeoplepicker.js"></script> <script src="/_layouts/15/autofill.js"></script> <script src="_layouts/15/sp.core.js"></script> |
Steps to Implement People Picker
Step 1
Refer the above JavaScript files in your page.
Step 2
Create a div tag in your page.
|
1 |
<div id=’peoplepicker’ /></div> |
Step 3
Initialize the people picker on page load
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
$(document).ready(function() { initializePeoplePicker(’peoplepicker’, false, ‘People Only’, 44); function initializePeoplePicker(peoplePickerElementId, AllowMultipleValues, PeopleorGroup, GroupID) { // Create a schema to store picker properties, and set the properties. var schema = {}; schema['SearchPrincipalSource'] = 15; schema['ResolvePrincipalSource'] = 15; schema['MaximumEntitySuggestions'] = 50; schema['Width'] = '280px'; schema['AllowMultipleValues'] = AllowMultipleValues; if (PeopleorGroup == 'PeopleOnly') schema['PrincipalAccountType'] = 'User'; else schema['PrincipalAccountType'] = 'User,DL,SecGroup,SPGroup'; if (GroupID > 0) { schema['SharePointGroupID'] = GroupID } // Render and initialize the picker. // Pass the ID of the DOM element that contains the picker, an array of initial // PickerEntity objects to set the picker value, and a schema that defines // picker properties. this.SPClientPeoplePicker_InitStandaloneControlWrapper(peoplePickerElementId, null, schema); } }); |
Note – Usage of the parameters values
peoplePickerElementId(Text) – Id of the control.
AllowMultipleValues – Its used to define whether the control can allow multiple user or not.Possbile values are True or False.
True – will allow to add multiple Users.
False – will only allow single user.
PeopleorGroup(Text) – It’s used to define whether the control can allow users and groups are only user. Possible values are ‘PeopleOnly’or ‘PeopleAndGroups’
PeopleOnly – will allow only user to add.
PeopleAndGroups – will allow to add users and groups also.
GroupID(Int) : it’s used to define the users can add only from the specified group id. The possible values are
0 or any Group ID of the group
0 – its allows to get users from any groups to add.
Group Id – its allow to get users from specified group.
Get User values from the Control
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
// Query the picker for user information. // PeoplepickerId = Id of the people picker function getUserInfo(PeoplepickerId) { // Get the people picker object from the page. var peoplePicker = this.SPClientPeoplePicker.SPClientPeoplePickerDict[PeoplepickerId + "_TopSpan"]; if (!peoplePicker.IsEmpty()) { if (peoplePicker.HasInputError) return false; // if any error else if (!peoplePicker.HasResolvedUsers()) return false; // if any invalid users else if (peoplePicker.TotalUserCount > 0) { // Get information about all users. var users = peoplePicker.GetAllUserInfo(); var userInfo = ''; var promise = ''; for (var i = 0; i < users.length; i++) { UsersID += GetUserID(users[i].Key); } return UsersID; } } else { return UsersID; } } // Get the user ID. function GetUserID(logonName) { var item = { 'logonName': logonName }; var UserId = $.ajax({ url: _spPageContextInfo.siteAbsoluteUrl + "/_api/web/ensureuser", type: "POST", async: false, contentType: "application/json;odata=verbose", data: JSON.stringify(item), headers: { "Accept": "application/json;odata=verbose", "X-RequestDigest": $("#__REQUESTDIGEST").val() }, success: function(data) { return data.Id + ';#' + data.Title + ';#'; }, error: function(data) { failure(data); } }); return UserId.responseJSON.d.Id + ';#' + UserId.responseJSON.d.Title + ';#'; } |
The results will be after calling the methods: 40;#hmg\naveen.kumar;#30;#hmg\username;#
SharePoint 2013 Hosting – HostForLIFE.eu :: Excel Services Application New Excel DataConnection Library In SharePoint 2013 Using PowerShell
Nov 16th
This course will help you learn the basics or refresh your knowledge and then provide a deeper understanding of advanced features to anyone interested in learning SharePoint 2013 from beginners to advanced users.
In this blog we will learn about how to add a new data connection library to Excel Services Application using PowerShell cmdlets.
SharePoint 2013 is a collaboration environment that organizations of all sizes can use to increase the efficiency of business processes.
Excel Service Application
Excel Services is a business intelligence tool that allows you to share data-connected workbooks across an organization.
Excel Services in SharePoint Server 2013 is a shared service that you can use to publish Excel 2013 workbooks on SharePoint Server.
Why we are using these commands?
Excel Services Application loads only workbooks that are stored in a trusted file location.
Steps
Open your SharePoint Management Shell.
Copy the below code.
Run this one.
|
1 |
onLibrary -Address <String> -ExcelServiceApplication <SPExcelServiceApplicationPipeBind> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-Description <String>] [-WhatIf [<SwitchParameter>]] |
Example
|
1 |
Get-SPExcelServiceApplication -Identity "ExcelServiceApplication" | New-SPExcelDataConnectionLibrary -address "http://gowtham/site/demo" -description "This is Demo" |
SharePoint 2013 Hosting UK – HostForLIFE.eu :: How to Find The Installed SharePoint 2016 Edition Via C#
Nov 9th
You can easily get the SharePoint Build Number via C# as shown below.
|
1 2 3 4 5 6 7 |
public string Get_SPVersion() { try { return SPFarm.Local.BuildVersion.ToString(); } catch (Exception) { throw; } } |
But, have you ever tried to detect the SharePoint Edition via C#? Well, regardless of the answer, detecting the SharePoint Edition via C# is not just a line of code as Build Number. To detect the SharePoint 2016 Edition, it will require knowing the corresponding SKU. Stock Keeping Unit (SKU) is a unique set of characters’ identification code for a particular product/service. Read more at SKU.
Get SharePoint 2016 Edition via C#
Based on the installed product SKU, you can detect the corresponding SharePoint 2016 Edition programmatically, as the following.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
public string Get_SPEdition() { try { string edition = ""; SPSecurity.RunWithElevatedPrivileges(delegate() { var editionguid = SPFarm.Local.Products; foreach(var item in editionguid) { switch (item.ToString().ToUpper()) { // SharePoint 2016 case "5DB351B8-C548-4C3C-BFD1-82308C9A519B": edition = "SharePoint Server 2016 Trail."; break; case "4F593424-7178-467A-B612-D02D85C56940": edition = "SharePoint Server 2016 Standard."; break; case "716578D2-2029-4FF2-8053-637391A7E683": edition = "SharePoint Server 2016 Enterprise."; break; default: edition = "The SharePoint Edition can't be determined."; break; } } }); return edition; } catch (Exception) { return "An error occurred! Make sure that\r\n- The SharePoint is installed"; } } |
In case, it’s
|
1 2 3 |
5DB351B8-C548-4C3C-BFD1-82308C9A519B, the installed SharePoint Edition is SharePoint 2016 Trial. 4F593424-7178-467A-B612-D02D85C56940, the installed SharePoint Edition is SharePoint 2016 Standard. 716578D2-2029-4FF2-8053-637391A7E683, the installed SharePoint Edition is SharePoint 2016 Enterprise. |
Output
(Test1) You have SharePoint 2016 installed. The result should look like –
(Test2) You don’t have SharePoint 2016 installed but you have other SharePoint version, the result should look like –
(Test3) You don’t have any SharePoint version installed, the result should look like –
SharePoint 2013 Hosting UK – HostForLIFE.eu :: How to Creating Custom Gulp Tasks In SPFx Solutions?
Nov 2nd
Let us see how to create and test the Gulp tasks in SharePoint Framework solutions. In my previous article, you can get the basic understanding of Gulp tasks in the SharePoint framework solutions. As we already know, Gulp tasks and commands help in automating the manual tasks required for solutions. These tasks are defined in the gulpfile.js. By default, some of the tasks or methods are loaded in the Gulp files. These tasks are required for building, bundling, or packaging the solutions. You could see each of these tasks in the previous article.
Let us take a basic example of creating a task for incrementing the version of SPFx solution. This is the manual task required before updating or deploying the SPFx solution onto the SharePoint sites. Here, we will try to automate the same using Gulp task.
The basic syntax for defining the task will be as follows.
build.task(taskname, custommethod());
The custom method will contain the steps for updating the version of the solution. The arguments can be passed to the method using the commands. So, for example, to call or execute the above task, the command used will be –
|
1 |
gulp taskname --argument1 |
Likewise, any number of arguments can be passed.
The below code sample shows gulpfile.js file which has the steps required for updating the version number using Gulp task. The task name is “update-spfx-solution”. The argument passed will be –updateVersion. This argument is to execute and validate the version updating steps only.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
'use strict'; const gulp = require('gulp'); const build = require('@microsoft/sp-build-web'); const fs = require('fs'); build.task('update-spfx-solution', { execute: (config) => { return new Promise((resolve, reject) => { // Code snippet for updating version if(config.args['updateVersion']){ let json = JSON.parse(fs.readFileSync('./config/package-solution.json')); var majorVersion = parseInt(json.solution.version.split('.')[0]); majorVersion++; json.solution.version = majorVersion + '.0.0.0'; fs.writeFileSync('./config/package-solution.json', JSON.stringify(json)); resolve(); } ///// Other code/functions to be continued here }); } }); build.initialize(gulp); |
In the above sample,
Argument is validated. (Command should contain the updateVersion flag)
Package-solution.json file is read using fs package.
The file is parsed as JSON and the version number is retrieved.
Version number is incremented and the same is updated by stringifying the JSON.
The following snapshot shows the package-solution.json file before executing the command.
The following snapshot shows the command executed.
The following snapshot shows the package-solution.json file after executing the command
Summary
Thus, you have learned to create custom Gulp tasks which help in automating the manual tasks in SharePoint framework solutions.
SharePoint 2013 Hosting UK – HostForLIFE.eu :: How to Get Group Users From SharePoint Site Using PnP Powershell
Oct 26th
In this blog, we are going to see how to get the list of available groups and users from SharePoint site using PnP PowerShell.
The below PowerShell command retrieves all the SharePoint Groups from the SharePoint site and its users with users count for the group.
Get-PnPGroup PnP PowerShell cmdlet gets the SharePoint Groups from the SharePoint site collection.
|
1 2 3 4 |
PS:> $cred = Get-Credential PS:> Connect-PnPOnline -Url https://<tenant>.sharepoint.com/sites/dev -Credential $cred PS:> $groups = Get-PnPGroup | Select-Object Title,Users PS:> $groups | format-table @{Expression = {$_.Title};Label='Group'},@{Expression = {$_.Users.Title};Label='Users'},@{Expression = {$_.Users.Count};Label='UsersCount'} |
And here is the output:
SharePoint 2013 Hosting UK – HostForLIFE.eu :: How to Add User To SharePoint Database Admin Using PowerShell Script?
Oct 12th
This course will help you learn the basics or refresh your knowledge and then provide a deeper understanding of advanced features of SharePoint 2013 from beginners to advanced users.
SharePoint 2013 is a collaboration environment that organizations of all sizes can use to increase the efficiency of business processes.
PowerShell is essentially the same, but with a lot more power. You can type your commands there and see the results just like before.
However, the benefit is that you can add your own “Shells” or set commands to enable the person using it to do more.
Steps
Use the Add-SPShellAdmin cmdlet to add a user to the SharePoint_Shell_Access role.
Syntax
|
1 |
Add-SPShellAdmin [-UserName] <String> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-database <SPDatabasePipeBind>] [-WhatIf [<SwitchParameter>]] |
Specifies the GUID of the database or the Database object that includes the SharePoint_Shell_Access role to which you want to add the user.
The Database parameter is not specified, the configuration database is used by default.
The farm configuration database is always included- if you specify another database.
Example
This will add a new user to the SharePoint_Shell_Access role in the farm configuration database.
|
1 |
Add-SPShellAdmin -UserName SPDEV\gowtham |
This will add a new user to the SharePoint_Shell_Access role in both, the specified content database and the configuration database, by passing a database GUID to the cmdlet.
|
1 |
Add-SPShellAdmin -UserName SPDEV\gowtham -database 4hty1d844-3d45-4501-8dd1-98f960359fa6 |
Conclusion
Was my blog helpful? If yes, please let me know and if not, please explain what was confusing or missing. I’ll use your feedback to double-check the facts, add info and update this blog.
