European Sharepoint 2013 Hosting Blog
Articles about European Sharepoint Hosting Service
SharePoint 2013 Hosting – HostForLIFE.eu :: [SharePoint] Get Social Comments From SharePoint 2013 OnPrem Using PowerShell CSOM
Oct 10th
I had a requirement to get all the social comments from a news board web part for a specific page. Though this can be achieved using “Server Side Object Model,” it is restricted for some of the companies to run their “SSOM” code on production environment. Thus, we came up with an idea of creating PowerShell script using CSOM to retrieve social comments using “Social Data Web Service”.
Here you will be seeing how to get all the social comments in SharePoint 2013 using the PowerShell + CSOM for a specific page using “Social Data WebService” (SocialDataService.asmx)
The below code retrieves all the comments for the specified page URL and exports the resulting data to Excel.
Code Usage
Scenario 2
To iterate all the page URL’s from excel and to retrieve all the social comments from social data web service based on page URL.
Note
All the Page URL’s are stored under “PageUrl” column in excel sheet.
Note
All the Page URL’s are stored under “PageUrl” column in excel sheet.
|
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 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 |
#Path to the CSV output path file. $CSVOutputfilepath = "D:\Madhu\GetSocialComments.csv" #Path to the log file. $outputfilepath = "D:\Madhu\GetMySocialCommentsLogs.txt" #Excel File path. $FilePath = "D:\Madhu\pagelist.xls" #Create an Object Excel.Application using Com interface $objExcel = New-Object -ComObject Excel.Application # Disable the 'visible' property so the document won't open in excel $objExcel.Visible = $False # Open the Excel file and save it in $WorkBook $WorkBook = $objExcel.Workbooks.Open($FilePath) # Load First sheet $sheet = $WorkBook.Worksheets.Item(1) #Find PageUrl and get the column position $pageurlcolumns = $sheet.UsedRange.Columns.Find('PageUrl').Column #Get all the Rows within Excel $rows = $sheet.UsedRange.Rows.Count ## Get number of user in excel $rowCount = $rows - 1 "-"*80 | Write-Host Write-Host -ForegroundColor Green "Total number of the pages initiated : " $rowCount Write-Host -ForegroundColor Green "Started at : $((Get-Date).ToString())" "-"*80 | Write-Host "-"*80 | Out-File -Encoding Ascii -append $outputfilepath "Total number of the pages initiated : " + $rowCount | Out-File -Encoding Ascii -append $outputfilepath "Started at :" + $((Get-Date).ToString()) | Out-File -Encoding Ascii -append $outputfilepath "-"*80 | Out-File -Encoding Ascii -append $outputfilepath ## Get Page Number Count $count = 1; # loop for each row of the excel file for ($i=2; $i -le $rows; $i++) { try{ #Get PageUrl column values $filePath = $sheet.Cells.Item($i, $pageurlcolumns).text #Log the result to log file Write-Host -ForegroundColor Green "$count : " $filePath "$count : " + $filePath | Out-File -Encoding Ascii -append $outputfilepath ## $url is a string that contains the URL from where we need to count the social comments ## list contains the pages from pages library and hence we got a substring by spliting the url. $url=$filePath.Substring(0,$filePath.IndexOf('/Pages')) ## Get path of socail comments webservice file $uri = $url + "/_vti_bin/SocialDataService.asmx" ## Web Service Reference - http://Site/_vti_bin/SocialDataService.asmx $socialDataServiceWebServiceReference = New-WebServiceProxy -Uri $uri -UseDefaultCredential ##Retrieve number of comments for a specific page. [int]$CountCommentsOnUrl=$socialDataServiceWebServiceReference.CountCommentsOnUrl($filePath) Write-Host -ForegroundColor yellow "Number of comments for the specified URL : " $CountCommentsOnUrl "Number of comments for the specified URL : " + $CountCommentsOnUrl | Out-File -Encoding Ascii -append $outputfilepath ##Retrieve comments for a specific page. $CommentsOnUrl = $socialDataServiceWebServiceReference.GetCommentsOnUrl($filePath,$null,$null,$null) foreach($item in $CommentsOnUrl) { $PageNoteBoardComments += New-Object PsObject -property @{ 'Comments' = $item.Comment 'URL' = [string]$item.Url 'Last Modified Time' = $item.LastModifiedTime 'Owner' = [string]$item.Owner } ##Add comments for a specific page. #$WriteCommentsOnUrl = $socialDataServiceWebServiceReference.AddComment($url,$item.Comment,0,"TestMultiline") } $count++ } catch{ Write-Host -ForegroundColor Green "$accountID : " $_.Exception.Message "$accountID : " + $_.Exception.Message | Out-File -Encoding Ascii -append $outputfilepath } } #Finally, use Export-Csv to export the data to a csv file $PageNoteBoardComments | Export-Csv -NoTypeInformation -Path $$CSVOutputfilepath "-"*80 | Write-Host "-"*80 | Out-File -Encoding Ascii -append $outputfilepath Write-Host -ForegroundColor Green "Completed at : $((Get-Date).ToString())" "Completed at : " + $((Get-Date).ToString()) | Out-File -Encoding Ascii -append $outputfilepath Write-Host -ForegroundColor Green "Total Comments Found : " $PageNoteBoardComments.Count "Total Comments Found : " + $PageNoteBoardComments.Count | Out-File -Encoding Ascii -append $outputfilepath "-"*80 | Write-Host "-"*80 | Out-File -Encoding Ascii -append $outputfilepath #Close the workbook object $WorkBook.close() #close the excel object $objexcel.quit() |
SharePoint 2013 Hosting Recommendation
HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options.
SharePoint 2013 Hosting – HostForLIFE.eu :: [SharePoint] Retrieve, Add, Remove Fields From A SharePoint List Using PnP PowerShell
Oct 3rd
In this blog, we are going to retrieve all the fields from a list and will add/remove a field from a SharePoint list using PnP PowerShell. For that, first, we need to connect to the site.
To establish the connection, add this command.
$SiteUrl = Read-Host “Provide Site URL”
Connect-PnPOnline -Url $SiteUrl
#Executing this line will ask for credentials. Provide a username and password to connect.
To retrieve all fields, add the below command.
$Fields = Get-PnPField -List “Test”
To add a field to a list, add this command.
Add-PnPField -List “Test” -DisplayName “Designation” -InternalName “Designation” -Type MultiChoice -AddToDefaultView -Choices “HR”,”CEO”, “DEVELOPER”,”TESTER”
To remove a field from list, execute this command.
Remove-PnPField -List “Test” -Identity “Designation”
Executing this command opens a popup window for confirmation of the field to be deleted.
Clicking on YES will remove the field from the list.
SharePoint 2013 Hosting Recommendation
HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options.
SharePoint 2013 Hosting – HostForLIFE.eu :: Toggling SharePoint Modern Site Header Using SharePoint Framework (SPFx) Application Customizer
Sep 27th
Why Site Header Toggler?
In SharePoint Modern Sites, the Suite Bar and the Site Header often occupy a lot of the viewport, and the actual content for a user to read is not immediately visible. Also as the Site Header is always positioned at the top, even though users scroll through the content, the viewport is much less. The Site Header occupies a significant amount in the viewport which really doesn’t show any content of the intranet.
A Site Header Toggler would allow the users to hide the Site Header and gives more space to content which is easily readable. And users can always see the Site Header by toggling it again. Here is a sample of how it would work.
The Solution
This needs 2 buttons, one to close the header and one to open the header. And some CSS to hide/show the Site Header. The tricky part here is to define the CSS class to hide the Site Header section. The Site Header section on the modern pages doesn’t have a CSS class name which we can override, and it is recommended to not change the DOM elements of a SharePoint Modern page. Here is a modern CSS construct which allows us to create a CSS definition based on the HTML element’s custom attributes.
|
1 2 |
// Sample HTML of the outer element of a Site Header <div class="mainHeader-48" data-automationid="SiteHeader"> |
Css class definition using the custom attribute,
|
1 2 3 |
div[data-automationid=SiteHeader]{ display: none; } |
The toggle buttons when clicked will add/remove a CSS class to the body element of the page, using which we can define CSS to show/hide the header.
Developing the SPFx Application Customizer
An Application Customizer of type of SPFx Extension adds some custom HTML in the top placeholder, where the HTML for showing toggling buttons can be added to every modern page on a SharePoint site.
STEP 1 – CREATE THE PROJECT
- Create a project with the name – ‘js-application-header-toggler’
- Open a command prompt in the new folder
- Run ‘yo @microsoft/sharepoint’
- Provide the necessary values for the yeoman generator as shown below,
What is your solution name? js-application-header-toggler- Which baseline packages do you want to target for your component(s)? SharePoint Online only (latest)
- Where do you want to place the files? Use the current folder
- Do you want to allow the tenant admin the choice of being able to deploy the solution to all sites immediately without running any feature deployment or adding apps in sites? No
- Will the components in the solution require permissions to access web APIs that are unique and not shared with other components in the tenant? No
- Which type of client-side component to create? Extension
- Which type of client-side extension to create? Application Customizer
- What is your Application Customizer name? HeaderToggler
- What is your Application Customizer description? Adds a toggle button to the Site Header
STEP 2 – DEVELOP THE APPLICATION CUSTOMIZER
Open the ‘ js-application-header-toggler/src/extensions/headerToggler/HeaderTogglerApplicationCustomizer.ts’ file and make sure you have the following code.
|
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 |
import { override } from '@microsoft/decorators'; import { Log } from '@microsoft/sp-core-library'; import { BaseApplicationCustomizer, ApplicationCustomizerContext, PlaceholderContent, PlaceholderName } from '@microsoft/sp-application-base'; import * as strings from 'HeaderTogglerApplicationCustomizerStrings'; require('./HeaderTogglerStyles.css'); const LOG_SOURCE: string = 'HeaderTogglerApplicationCustomizer'; /** * If your command set uses the ClientSideComponentProperties JSON input, * it will be deserialized into the BaseExtension.properties object. * You can define an interface to describe it. */ export interface IHeaderTogglerApplicationCustomizerProperties { // This is an example; replace with your own property testMessage: string; } /** A Custom Action which can be run during execution of a Client Side Application */ export default class HeaderTogglerApplicationCustomizer extends BaseApplicationCustomizer<IHeaderTogglerApplicationCustomizerProperties> { private topPlaceHolder: PlaceholderContent | undefined; private appContext: ApplicationCustomizerContext = null; @override public onInit(): Promise<void> { Log.info(LOG_SOURCE, `Initialized ${strings.Title}`); this.appContext = this.context; this.context.placeholderProvider.changedEvent.add(this, this.renderPlaceholders); this.registerClickHandlers(); return Promise.resolve(); } private renderPlaceholders(){ if (!this.topPlaceHolder) { this.topPlaceHolder = this.appContext.placeholderProvider.tryCreateContent(PlaceholderName.Top, { onDispose: this.onDispose }); } if (this.topPlaceHolder.domElement) { let html: string = `<div class="toggleButton o365cs-base"> <a class='toggleButtonClose' href='javascript:void(0);'> <span class="ms-Icon--ChevronUpMed _2e1Nb05SSaoOLYsNgNyvkr" role="presentation" style="display: inline-block;font-size: 20px;color: #fff;font-weight: bold;line-height: 30px;"></span> </a> <a class='toggleButtonOpen' href='javascript:void(0);'> <span class="ms-Icon--ChevronDownMed _2e1Nb05SSaoOLYsNgNyvkr" role="presentation" style="display: inline-block;font-size: 20px;color: #fff;font-weight: bold;line-height: 30px;"></span> </a> </div>`; this.topPlaceHolder.domElement.innerHTML = html; } } private registerClickHandlers(){ let btnClose = document.getElementsByClassName("toggleButtonClose")[0]; let btnOpen = document.getElementsByClassName("toggleButtonOpen")[0]; btnClose.addEventListener('click', (e) => { document.body.classList.add("menuClosed"); }); btnOpen.addEventListener('click', (e) => { document.body.classList.remove("menuClosed"); }); } } |
Add a CSS file named HeaderTogglerStyles.css in the folder js-application-header-toggler/src/extensions/headerToggler/. Copy the following content to this file.
|
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 |
toggleButton{ background: #666; position: absolute; z-index: 9999; width: 30px; height: 30px; right: 0px; font-size: 0px; text-align: center; } a.toggleButtonOpen{ display:none; } body.menuClosed a.toggleButtonOpen{ display:inline-block !important; } body.menuClosed a.toggleButtonClose{ display:none !important; } body.menuClosed div[data-automationid='SiteHeader']{ display:none !important; } |
STEP 3 – BUILD, TEST AND DEPLOY
- Update the SharePoint site URL in the ‘js-application-header-toggler/config/serve.json’ file
- In the command prompt run ‘gulp serve’. This should open your SharePoint site with the SPFx extension from your local workbench
Follow the below steps to publish and deploy the SPFx solution,
- In the comment prompt run the following command,
- npm run build
- npm run bundle –ship
- npm run package-solution –ship
- Upload the generated sppkg file to your App Catalog
- Add the app to your SharePoint modern site.
Conclusion
By providing a Site Header Toggler users can hide the header to create more reading space on the SharePoint modern pages and toggle the header anytime to make it visible again. It’s a simple solution which would be very useful for creating a better viewport for the main content on the modern intranet pages.
This SPFx project is also available on GitHub.
SharePoint 2013 Hosting – HostForLIFE.eu :: Send Email from SharePoint using JSOM
Sep 19th
To send emails from SharePoint, we use SharePoint workflow or SharePoint Utility Email using C#. But what if you want to send emails from your client-side code. So, recently I faced a situation where I have to send emails from my client-side code where I was using JSOM as CEWP mythology. So, I was looking for a way where I found “SP.Utilities.Utility.SendEmail” in my searches. And it is really a very simple way to send email. But there is only one catch on which we have to be concerned as the email recipient(s) have to be the users who have visited the site. Any email accounts that have not been authenticated to SharePoint will throw an error.
Here is the code given bellow:
|
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 |
var sendEmail=()=>{ const emailProps= { To: [], CC:[], Subject: "<Email Subject>", Body: "<Email Body>" }; var siteUrl = "www.tahmid.sharepoint.com/sites/RnD"; //Provide your SharePoint site address var urlTemplate = siteUrl + "/_api/SP.Utilities.Utility.SendEmail"; getFormDigest(siteUrl).then((data)=> { $.ajax({ contentType: 'application/json', url: urlTemplate, type: "POST", data: JSON.stringify({ 'properties': { '__metadata': { 'type': 'SP.Utilities.EmailProperties' }, 'To': { 'results': emailProps.To }, 'Body': emailProps.Body, 'Subject': emailProps.Subject, 'CC': { 'results': emailProps.CC }, } }), headers: { "Accept": "application/json;odata=verbose", "content-type": "application/json;odata=verbose", "X-RequestDigest": data.d.GetContextWebInformation.FormDigestValue }, success: function(data) { console.log("Email Sent"); }, error: function(err) { console.log("Got Error"); } }); }); } var getFormDigest=(webUrl)=>{ return $.ajax({ url: webUrl + "/_api/contextinfo", method: "POST", headers: { "Accept": "application/json; odata=verbose" } }); } |
Here is the way to call the function sendEmail().
|
1 2 3 |
$(document).ready(()=>{ sendEmail(); }); |
In the real-time use, you can send the emailProps when you call the function as parameter. So, before ending the article, just a note that if you get a 403 Forbidden error, following two things could be happened in most cases. You are not getting the context as in you should check that you are getting the digest. If that’s not the case, then upgrading to a newer version of jQuery may solve the issue.
SharePoint 2013 Hosting Recommendation
HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options.
SharePoint 2013 Hosting – HostForLIFE.eu :: Reason For Request Timed Out Error In SharePoint Search
Sep 12th
Sometimes while we work on SharePoint search, we may see the “Request timed out” error in the browser even though the search application topology (all search databases) status is fine. As an example, the status shows as below.
Background of the issue (description)
Let’s say we have a multi servers farm where all web applications hosted in WFE and all SharePoint service are running in App server. The server topology is as below:
- App Server with Search and
- WFE server.
We have configured the search service application in the application server and all components of search crawl are happening fine without any errors. However, if we try to search any item from SharePoint web application, the search box will try to continue to search the item but after a long time we will see the error “search query time out error timed”.
If we look at the uls log, we can see the below entry.
:SearchServiceApplicationProxy::GetQueryHealthMonitoringSettingsForComponents–Error occured: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening to thttp://appserver:32843/db4796fcfe375bd791f98ec5e485999c/SearchService.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. —> System.Net.WebException: Unable to connect to the remote server —> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond :32843 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
Solution
This is the port connectivity issue between WFE and APP server. Ask your system/network admin team to configure the 808,32843,32844 port in WFE and APP server.
Summary
Thus, in this article, we learned the exact causes of the “Request timed out” error with respect to the SharePoint search and the solution.
SharePoint 2013 Hosting Recommendation
HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options.
SharePoint 2013 Hosting – HostForLIFE.eu :: Resolving Wrong Tenant Credentials Error Even Though We Pass The Correct Credential
Sep 5th
Sometimes, while we work with PowerShell and SharePoint online, we may come across the above error. I will explain in which scenario we’ll get wrong tenant credential error while connecting to SharePoint online thru the PowerShell even though we pass the correct credential and how to fix it.
Issue Description
Recently, I was working on how to configure the hybrid environment for our tenant. In order to do that I had picked up the Hybrid Picker Wizard, followed the instructions, and started the configuration. At the initial steps, this will validate your on-premises SharePoint credential and SharePoint online credential. I was using the same account for both on-premise and online wherein on-premise SharePoint authentication was successful but authentication in SharePoint Online was failing – the error message was saying that “Wrong tenant credential.” like below.
It was strange!!! I had tried to log in to SharePoint online site using the same credential and it was successful, and tried to connect SharePoint online site through the ShareGate migration tool using the same credential, and it was successful. It became ever more strange.
In order to do the hybrid configuration as an alternative approach, Microsoft has provided two inbuilt PowerShell Script. I tried to execute those scripts there also but faced the same authentication issue.
Solution
- If your account has MFA (multi-factor authentication) enabled in Azure AD, you cannot connect to SharePoint online using PowerShell or Hybrid Picker Wizard as a temporary solution for time being disable the MFA in Azure AD, then after getting your work done enable it back – after MFA disabling you will not face the above issue.
- Have a dedicated service kind of admin account without MFA enabled and use this account for all sorts of PowerShell execution with respect to SharePoint online and Hybrid Picker configuration – as per me this is recommended or good choice over the previous one.
SharePoint 2013 Hosting Recommendation
HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options.
