European Sharepoint 2013 Hosting Blog
Articles about European Sharepoint Hosting Service
SharePoint 2013 Hosting – HostForLIFE.eu :: Get Content Type Usage Details In SharePoint Using Powershell
Jan 18th
This script will give you the usage details and dependencies of any content type, such as – list URL, Web URL, etc. and wherever that is being used. This might come in handy when you wish to delete the content types and you have to make sure of all its dependencies and references getting cleaned.
The output will be in the form of a CSV file where the above-mentioned content type is used. Input parameters used are:
Name of content type
Web Application URL
To get started, replace Content Type name and Web Application URL below with the one to be searched for,
|
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 47 48 49 50 51 |
$myContentType = "Report Builder Report" $myWebApp = "http://myWebAppURL.com" if ((Get -PSSnapin "Microsoft.SharePoint.PowerShell" - ErrorAction SilentlyContinue) -eq $null) { Add -PSSnapin "Microsoft.SharePoint.PowerShell" } @results = @() $sites = Get -SPSite –Limit All –WebApplication $myWebApp try { foreach($site in $sites) { Write-Host "Looking in site– " $site.Url foreach($web in $site.AllWebs) { Write-Host $web.Url foreach($list in $web.lists) { foreach($ctype in $list.ContentTypes | ? { $_.Name –eq $myContentType}) { foreach($item in $list.Items | ? { $_.ContentType.Name –eq $myContentType }) { $RowDetails = @ { "List" = $list.Title "ListURL" = $list.DefaultView.Url "ContentType" = $item.ContentType.Name "Site" = $site.Url "Web" = $web.Url } $results += New-Object PSObject –Property $RowDetails break } } } $web.Dispose() } $site.Dispose() } } catch { $e = $_.Exception $line = $_.InvocationInfo.ScriptLineNumber $msg = $e.Message Write-Host –ForegroundColor Red "Caught Exception: $e at $line" Write-Host $msg Write-Host "Something went wrong" } $results | Export - CSV– Path C: \ContentTypeUsageReport.csv– NoTypeInformation Write-Host " === === === === === === === Completed! === === === === === === === === == " |
SharePoint 2013 Hosting – HostForLIFE.eu :: Get All Users In A SharePoint 2010/13/16 Farm Using PowerShell Script
Jan 11th
Welcome to an article on how to get all users in a SharePoint 2010/13/16 farm using PowerShell Script. This script is going to run and loop in all the web applications and site collections within them and get individual and group users.
This script will help save us developers a lot of time in getting all the users from an individual or group. So, here is the script.
- Copy the code below to a .ps1 file.
- Run the .ps1 file on the SharePoint PowerShell modules.
- You don’t need to do any update on the script.
Script
|
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 |
#getalluserinthefarm Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue $Currentime = get-date -format "yyyyMMdd_hhmmtt" $filename = "FarmUsers" $datafile = ("{0}{1}.csv" -f $filename, $Currentime) $headerfile = "type,user,group,weburl,webtitle" $headerfile | out-file -FilePath $datafile $iissitedata = get-spwebapplication foreach($farmsite in $iissitedata) { foreach ($SiteCollection in $farmsite.sites) { write-host $SiteCollection -foregroundcolor Blue foreach ($web in $SiteCollection.Allwebs) { write-host " " $web.url $web.name "users:" -foregroundcolor yellow foreach ($usersite in $web.users) { write-host " " $usersite -foregroundcolor white $data = ("RootUser,{0},-,{1},{2}" -f $usersite, $web.url,$web.name) $data | out-file -FilePath $datafile -append } foreach ($group in $web.Groups) { Write-host " " $web.url $group.name: -foregroundcolor green foreach ($user in $group.users) { Write-host " " $user -foregroundcolor white $data = ("GroupUser,{0},{1},{2},{3}" -f $user, $group, $web.url, $web.name) $data | out-file -FilePath $datafile -append } } $web.Dispose() } } } |
Once you initiate the script, it will run through all site collections in all the webs and populate the date and save it in on the same location you are running it from, in a .csv or .txt format.
Just run this script and you will get all the users on the farm.
SharePoint 2013 Hosting – HostForLIFE.eu :: Difference Between Pages And Site Pages Libraries
Dec 21st
Most of us beginners to SharePoint have a question in our minds about the difference between Pages and Site Pages. Basically, Pages and Site Pages both are OOTB libraries provided by SharePoint then what is a difference between these two libraries?
Pages Library
- A Pages library is a document library which contains content pages for a publishing site.
- We can create following pages using Pages Library.
- Page
- Article Page
- Welcome Page
- Error Page
- Please find the below screenshot for Pages Library.
Site Pages
- We can create the below pages using Site Pages.
- Wiki Page
- Web Part Page
- Site Page
- We will discuss these Pages in my next article.
- Please find the below screenshot for Site Pages.
SharePoint 2013 Hosting – HostForLIFE.eu :: Enabling/ Using Content By Search Web Part In Standard Edition Of SharePoint 2013
Dec 14th
In one of our SharePoint 2013 projects, we are using “Content by Search” web part for one of our requirements. In our development environment, we have SharePoint 2013 Enterprise edition, so we don’t have any issue while using “Content by Search” web part.
But in one of our test environments, our support team installed the standard edition of SharePoint 2013 by mistake. When we deployed our solution in the test environment, our “Content by Search” web part stopped working. Initially, we were not aware of SharePoint 2013 standard edition deployed in our test environment. We started investigating why our Content Search web parts were not working. Surprisingly, when we edited the web part, Query Builder was showing the result but when we saved the web part properties and page, web parts were rendering blank, no result. When we tested “Search Result” web part, it is working fine, showing the result. We removed our custom control template and displayed the templates but no luck. So, it seemed that this was not an issue of custom templates as well. When we tried to add OOB “Content by Search” web part on page, this web part was not available to add in “Content Rollup” category as,
Figure 1: Content Search web part is not available in Content Rollup category
After investigating more, we found the following exception.
|
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 |
$create(Srch.ContentBySearch, { "delayLoadTemplateScripts": true, "itemTemplateId": "~sitecollection/_catalogs/masterpage/Display Templates/Item_UserListing.js", "messages": [{ "serverTypeId": "{D3DFEF63-4D44-497D-B936-047135645AD7}", "header": null, "level": 2, "code": -1, "type": null, "messageDetails": "This Web Part is not available for use. Search-Driven content (592CCB4A-9304-49AB-AAB1-66638198BB58) feature needs to be activated to use this Web Part.", "messageDetailsForViewers": "", "stackTrace": "", "correlationID": "968b339e-3e03-b02a-fe18-2568848aa782", "showInEditModeOnly": false, "showForViewerUsers": false, "encodeDetails": true }], "numberOfItems": 50, "queryGroupName": "Default", "renderTemplateId": "~sitecollection/_catalogs/masterpage/Display Templates/Control_List.js", "showBestBets": false, "showDefinitions": false, "showDidYouMean": false, "showPersonalFavorites": false, "states": {} }, null, null, $get("ctl00_ctl53_g_6c4c49b9_7b39_4ad2_ba06_58f0900b858a_csr")); }); |
We googled out the feature “592CCB4A-9304-49AB-AAB1-66638198BB58” and this is “SearchDrivenContent” which is a hidden feature for the standard edition of SharePoint 2013. Here is a good article for the comparison of all features in all editions of SharePoint 2013 “SharePoint 2013 Standard vs. Enterprise vs. Foundation Feature Comparison Matrix”.
Then, we realized that on our test environment, we had standard edition of SharePoint 2013 and not enterprise edition. We have option for reinstalling of SharePoint 2013, but we thought to reactivate the above-mentioned feature and try once.
We check 15 Hive and this feature was available in 15 Hive. So, we installed this feature as
Install-SPFeature -Path “C:\Program Files\Common Files\microsoft shared Web Server Extensions\15\TEMPLATE\FEATURES\SearchDrivenContent”
DisplayName Id CompatibilityLevel
———– — ——-
SearchDrivenContent 592ccb4a-9304-49ab-aab1-66638198bb58 15
And then, activated it.
Enable-SPFeature -Identity SearchDrivenContent -Url <WebApplicationURL>
We refreshed our page and web part started showing results. Also, content search web part became available to add on the page.
Content Search web part available in Standard edition of SharePoint 2013 after enabling feature ” SearchDrivenContent “. In this way, we have enabled the “Content by Search” web part on the Standard Edition of SharePoint 2013.
Here, I would say – anyway, this is not the standard way to do it. This is just a temporary way to work. The best practice is to update the SharePoint 2013 from Standard Edition to Enterprise edition.
SharePoint 2013 Hosting – HostForLIFE.eu :: Saving Multiple Links In A List Column And UI On Custom List Form In Visual Web Part
Dec 7th
In one of our projects, we had a requirement to associate multiple links for items in one of our custom lists. We had our custom form ready to create the items using Visual web part. On our custom form, while creating list item, we needed to give an option to the users to add the custom links (client-side adding and removing feature as well) and show those custom links when a user will see those items. In SharePoint, there is no OOB way to store the custom links. In field of type URL, we can store only one link at a time. So, we took a smart sep and used the Note field to store the multiple links.
Since in SharePoint, we can have a URL field which stores only one link at a time, we have decided to go with Note field with plain text. We stored the links separated by semicolon (“;”) such as –
Google~http://google.com; LinkedIn~http://linkedin.com;
You can see that the above line, link title (Google, LinkedIn) and link URLs (http://google.com;http://linkedin.com) are separated by field sign “~”.
But here, the most important thing is to provide the UI while creating the item through our custom form.
UI
User Interface for manipulating multiple inks from custom list form
Figure 1 – User Interface for manipulating multiple inks from custom list form
In the above figure, “+ Add Link” button adds the new link and renders below as “Google” and “Linked In” added.The “-Delete Link” button removes the link from the UI. We have implemented all this functionality client-side through JavaScript.
I thought this is the reusable feature and can be used very easily in any of our SharePoint applications.
Implementation Steps
We have our custom Visual web part for custom list form, through which, the user adds the values in list fields. We have the following HTML controls in our user control to render the UI, as shown in picture 1.
|
1 2 3 4 5 6 |
<asp:Literal ID="Literal28" runat="server" Text="Urls" /> - Urls label <input name="txtURLTitle" runat="server" type="text" id="txtURLTitle" placeholder="Link Title"> - Text box for Link Title <input name="txtURL" runat="server" type="text" id="txtURL" placeholder="Link URL"> - Text box for Link URL <a runat="server" id="btnAddURL" class="addUrlButton" onclick="addURL();"><i class="fa fa-plus"></i> Add Link</a> - ‘+ Add Link’ link <asp:HiddenField ID="urlLists" runat="server"></asp:HiddenField> - Hidden field to store all the links separated by “~” sign, we access the value of this field to store the links in list field of type note <div id="divUrlLists"></div> - Div to render the added links and “-Delete link” button dynamically |
In the above code snippet, we are using div with ID “divUrlLists” to dynamically render and to show the link title and URL and delete link. As per the above code snippet, we are calling “addURL()” JavaScript method.
Code for “addURL()” method is as,
|
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 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 |
//our custom namespace var myCustomNS = window.myCustomNS || {}; //Creating array myCustomNS.urlArrayList = []; //This method adds the Title and URL to array and renders on div function addURL() { var url = document.getElementById('<%=txtURL.ClientID%>'); var urlTitle = document.getElementById('<%=txtURLTitle.ClientID%>') if(url && urlTitle) { //In array we are pushing link title and URL, separated by "~" myCustomNS.urlArrayList.push(urlTitle.value+"~"+url.value); //Calling renderItems() - to show the title, URL and delete link on UI renderItems(); //Clearing respective controls to add the next links url.value=""; url.focus(); urlTitle.value=""; urlTitle.focus(); } }//addURL renderItems() method code as below, which traverse through array “myCustomNS.urlArrayList” and renders the URL title, URL link and “-Delete Link” link on the UI //renderITems() - This method traverse through array, creates dynamically span to show Title~link and delete link function renderItems() { var urlLists = document.getElementById('<%= urlLists.ClientID %>'); urlLists.value= myCustomNS.urlArrayList.join(";"); var divurllist = document.getElementById("divUrlLists"); divurllist.innerHTML=""; myCustomNS.urlArrayList.forEach(function(item,index){ //split item on '~' //Link Title var itemtitle = item.split('~')[0]; //Link URL var itemurl = item.split('~')[1]; //Creating span element to show Title var span = document.createElement("span"); span.innerText=itemtitle; //adding respective node to the div divurllist.appendChild(span); //Creating "Delete Link" link var deleteButton = document.createElement("a"); deleteButton.innerHTML = "<li class='fa fa-minus'></li> " +"Delete Link"; //Setting array index as ID of the button. Also used for deleting the link deleteButton.id = index; //adding respective item to the div divurllist.appendChild(deleteButton); //calling deleteLink () on clicke of "Delete Link" deleteButton.addEventListener("click",deleteLink); //Creating span element to show link URL span = document.createElement("span"); span.innerText="~"+itemurl; //adding respective node to the div divurllist.appendChild(span); var brElement = document.createElement("br"); divurllist.appendChild(brElement); divurllist.appendChild(brElement); }); }//renderItems deleteLink() code as below – this method just delete the item from the array “myCustomNS.urlArrayList” and call renderItems() again to show updated UI //This method removes the link from the array based on current index function deleteLink() { delete myCustomNS.urlArrayList[this.id]; renderItems(); return false; }//deleteLink |
This is a small code snippet for adding multiple links features to the list items but it’s very useful. It’s reusable as well. It’s simple JavaScript, easy to understand and implement.
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;#
