European Sharepoint 2013 Hosting Blog
Articles about European Sharepoint Hosting Service
SharePoint 2013 Hosting – HostForLIFE.eu :: How to Create & Configure Machine Translation Service
Sep 20th
In this post, I’m going to tell you how to create and configure the machine translation service for SharePoint 2013. To create the multi-language feature of SharePoint 2013 using Machine Translation Service, you need to make the ‘Machine Translation Service’ up and running in your farm.
Create Machine Translation Service
Step 1
Open Central Administration, go to Application Management section, and choose Manage service applications.
Step 2
On the ribbon, choose New, and then choose Machine Translation Service.
Step 3
On the next page type a name for the service application and fill in the details as shown in the screens below.
Step 4
Select the check box near ‘Add this service application’s proxy to the farm’s default proxy list.’ and verify the database name, and click OK.
Configure Machine Translation Service
Step 1
Click on the ‘Machine Translation Service’ we just created, under the ‘Manage Service Applications’ in Central Administration.
Step 2
In the Machine Translation Service Screen, there is a section called ‘Enabled File Extensions’. It depicts the file extension for which the translation is enabled. Uncheck the checkbox for the file extension for which you want to disable translation.
Step 3
In the Item Size Limits section:
- Maximum file size for binary files in KB. Microsoft Word documents are binary files: 51200
- Maximum file size for text files in KB. Plain-text, HTML, and XLIFF documents are text files: 5120
- Maximum character count for Microsoft Word documents: 500000
In the Online Translation Connection:
Under Web proxy server, select the check box for ‘Use default internet settings’ to use the default proxy settings to connect Internet or specify the port in the ‘Use the proxy specified’
In Rest of the section fill the following details:
- Translation processes: 1
- Frequency with which to start translations (minutes): 15
- Number of translations to start (per translation process): 200
- Maximum translation attempts: 2
- Maximum number of synchronous translation requests (per server): 10
- Maximum number of items which can be queued within a 24-hour period: No Limit
- Maximum number of items which can be queued within a 24-hour period per site subscription: No Limit
- Expiration time for completed job history (days): 7 Days
- Recycle threshold: 100
- Disable Office 97-2003 Document scanning? No
Then, click on ‘OK’ Button.
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 UK – HostForLIFE.eu :: Color Formatting Of A SharePoint Online List Using JSON
Sep 18th
Here, we are going to see how to perform conditional formatting using JSON in a SharePoint online list. Nowadays, many people are seeking for a code to format the SharePoint list to make it more attractive to the end users.
In this way, I just tried to format my list items with some color code and here is my code by which the background color will get changed based on the item values.
Here, I have created one list with one column called colors and I have entered some color name, so based on the color name, it will change the background color.
Here is the JSON code to change the background color and text color as well. You can just copy and paste it.
|
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 |
{ "elmType": "div", "txtContent": "@currentField", "style": { "color": "#fff", "padding-left": "14px", "background-color": { "operator": "?", "operands": [ { "operator": "==", "operands": [ "@currentField", "Green" ] }, "#2ECC71", { "operator": "?", "operands": [ { "operator": "==", "operands": [ "@currentField", "Red" ] }, "#E74C3C", { "operator": "?", "operands": [ { "operator": "==", "operands": [ "@currentField", "Yellow" ] }, "#F1C40F", { "operator": "?", "operands": [ { "operator": "==", "operands": [ "@currentField", "Purple" ] }, "#76448A", "" ] } ] } ] } ] } } } |
You can add the JSON code in that particular column in two ways,
- Navigate to list setting -> column -> then add JSON code
- You can click the title of column in list view itself then column setting and format this column and JSON code editor will open on the right of the screen
And the final view of the list would be like below.
SharePoint 2013 Hosting UK – HostForLIFE.eu :: Reading The SharePoint News Using Rest API In SPFx
Sep 6th
Sharing news among employees is a big challenge for any organization. The Intranet is a possible solution. Companies can develop digital intranet as a communication and collaboration tool with all the custom settings they prefer.
But still, we can’t avoid news from SharePoint sites. Let’s see how to read the published SharePoint news through Rest API using SPFx.SharePoint Search
SharePoint is one of the most powerful tools in its search feature. It allows looking for the data across sites/tenants. The same concept is going to help us to read the promoted news from the SharePoint sites.
There are already a lot of REST API URLs available to search data in SharePoint like people search and document search using specific id’s. Let’s jump into the implementation. Here the main key parameter to find the published news is with its promoted state. If the promoted state of a piece of news is set to 2 then that means the news will be published and available for everyone to read.
Below is the URL to get the promoted news from a site.
{SiteUrl}/_api/search/query?querytext=’IsDocument:True AND FileExtension:aspx AND PromotedState:2′
Here you can define the search scope with a slight change in the URL. Let’s say we have a site called Intranet and you want to search the promoted news only within that site, the URL will be like below,
https://tenantName.sharepoint/com/sites/Intranet/_api/search/query?querytext=’IsDocument:True AND FileExtension:aspx AND PromotedState:2′
https://tenantName.sharepoint/com/sites/Intranet/_api/search/query?querytext=’IsDocument:True AND FileExtension:aspx AND PromotedState:2′
If you want to get all the published news from all the sites across the tenant then your site URL in the REST API URL must point to SharePoint search site and the URL will look like below,
https://tenantName.sharepoint/com/search/_api/search/query?querytext=’IsDocument:True AND FileExtension:aspx AND PromotedState:2′
https://tenantName.sharepoint/com/search/_api/search/query?querytext=’IsDocument:True AND FileExtension:aspx AND PromotedState:2′
Don’t worry that you need to authenticate two different sites as SPFx takes care of it internally, that’s the beauty of SharePoint Framework apps. If the current user has permission over the entity he can play around with it, otherwise he can’t.
Error – Microsoft.SharePoint.Client.UnknownError
Before going to the actual code sample, let me show you the expected error and solution for that. We might end up the with weird error Microsoft.SharePoint.Client.UnknownError.
Office 365 API’s use OData v4.0 protocol for exchanging data between the client and the server like below,
If the same headers are used in SharePoint Search API in Search site then we will end up with the below error,
The same protocol will work fine in all other SharePoint API’s except Search API. So, it’s better to use OData v3.0 protocol in SharePoint Search API like the below code snippet.
Code Snippet
How to get the name of the Site in SharePoint Search Result?
As we search the entire tenant for the news, how do we differentiate the news of different sites?
As we search the entire tenant for the news, how do we differentiate the news of different sites?
Yes, we do get the Path/OriginalPath of the news page and we do have the site URL in that, but that’s not the efficient way to do it. In SharePoint, there is a default Managed Metadata property called “SiteTitle”, which will exactly give you the site name from which the news is from.
To get the SiteTitle you need to select it using the selectProperties in the REST Url like below,
|
1 |
https://tenantName.sharepoint/com/search/_api/search/query?querytext='IsDocument:True AND FileExtension:aspx AND PromotedState:2' &selectproperties='Title,Author,PictureThumbnailURL,SiteTitle,SPWebUrl,OriginalPath,LastModifiedTime,ViewsLifeTime,ViewsRecent,LikesCount,PromotedState’ |
I hope you have got to know about SharePoint news, and the search feature to crawl the published news. Follow my next blog to know about handling the SharePoint search result row limit.
If you have any questions/issues about this article, please let me know in the comments.
SharePoint 2013 Hosting UK – HostForLIFE.eu :: PowerShell to Get/Add/Remove Users of Local Administrator Group
Aug 23rd
This article outlines how to get, add and remove users of a local administrator group on SharePoint servers using a PowerShell script.
Local Administrators
The script does the following functionality.
- Gets the local administrators of the machine.
- Adds a user to the local administrator of the machine (the user must enter the user details into the AddUsers.csv file and place it under the folder where the PowerShell script exists).
- Removes a user from the local administrator of the machine (the user must enter the user details into the RemoveUsers.csv file and place it under the folder where the PowerShell script exists).
Get the local administrators of the machine
The following piece of code gets the users under the local administrator group of the machine.
|
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 |
Function GetServerAdministrators([Microsoft.SharePoint.Administration.SPFarm]$farm) { write-host "" write-host "Preparing to collect SP server administrator details" -fore magenta $output = $scriptbase + "\" + "ServerAdminDetails.csv" "ServerName" + "," + "AdminMember" | Out-File -Encoding Default -FilePath $Output; foreach($server in $farm.Servers) { foreach($instance in $server.ServiceInstances) { if($instance.TypeName -eq $timerServiceInstanceName) { [string]$serverName = $server.Name write-host "Collecting administrator details for the server " $servername -fore yellow $admins = invoke-command {net localgroup administrators | where {$_ -AND $_ -notmatch "command completed successfully"} | select -skip 4} -computer $serverName foreach($admin in $admins) { write-host $admin " is member of administrator group in server " $serverName -fore cyan $serverName + "," + $admin | Out-File -Encoding Default -Append -FilePath $Output; } write-host "Administrator details for the server " $serverName " has been collected" -fore green } } } Write-host "Administrator details collected for all the SP servers in the farm" -fore green } |
Add users to the local administrator of the machine
The following piece of code helps to add the users to the local administrator group on the SharePoint servers.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
Function AddUserToServerAdminGroup([String]$AdminMember, [String]$ServerName) { $ans = read-host "Do you want to add user $AdminMember to server $ServerName (y/n)? " if($ans -eq 'y') { write-host "Adding user " $AdminMember " to administrator group on server " $ServerName -fore yellow $AdminMember1 = $AdminMember.split("\") $AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1] $GroupObj = [ADSI]"WinNT://$ServerName/Administrators" $GroupObj.Add("WinNT://$AdminMember2") write-host $AdminMember " added to the local administrator group on the server " $ServerName -fore green } else { write-host "User choose not to add user " $AdminMember " to the server " $ServerName " administrator group" -fore cyan } } |
Remove users from local administrator of the machine
The following piece of code helps to remove the users from the local administrator group on the SharePoint servers.
Complete Code
Execution Procedure
- Download and copy the script folder to the SharePoint server.
- Launch the SharePoint management shell.
- Navigate to the script path and execute the script.
Enter the desired option.
SharePoint 2013 Hosting UK – HostForLIFE.eu :: Find Default Page And Approve It Using Powershell In SPO
Aug 21st
Basically in SPO, default.aspx are discontinued however while migration default pages also get migrated. Here this piece of code finding default pages as it may set up Homepage of sites.
Here, we are finding those default pages across site and subsites and approving it along with the particular user who created or modified.
Here, we are finding those default pages across site and subsites and approving it along with the particular user who created or modified.
|
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 |
#Passing inputs through CSV file # Pass Site URL and Library Name as Inputs. Param( [Parameter(Mandatory = $true)] [string] $Csv) # Pass your DLL 's Add - Type - Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add - Type - Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" Add - Type - Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Publishing.dll" Import - Module Microsoft.Online.SharePoint.PowerShell # Not required for on premise site - Start $pwd = Read - Host - Prompt "Enter password" - AsSecureString $creds = New - Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($userId, $pwd) $root = Import - Csv $Csv foreach($record in $root) { $TargetSite = $record.SharePointUrl $LibraryName = $record.LibraryName $ctx = New - Object Microsoft.SharePoint.Client.ClientContext($TargetSite) # Not required for on premise site - Start $ctx.credentials = $creds # Iterating across subsites and finding default pages. $web = $ctx.Web $ctx.Load($web.Webs) $ctx.ExecuteQuery() if ($web.Webs.Count - gt 0) { foreach($AllWeb in $web.Webs) { try {# Get all files from the Library $List = $AllWeb.Lists.GetByTitle($LibraryName) $q = New - Object Microsoft.SharePoint.Client.CamlQuery $q.ViewXml = "<View Scope='RecursiveAll' />" $Items = $List.GetItems($q) $ctx.Load($Items) $ctx.ExecuteQuery() $FileName = "default.aspx" Foreach($Item in $Items) { $File = $Item["FileRef"].Substring($Item["FileRef"].LastIndexOf("/") + 1) if ($File - eq $FileName) { if ($Item["_ModerationStatus"] - eq "2" - and($Item["Editor"].LookupValue - eq("xxxUserName") - or $Item["Editor"].LookupValue - eq("xxxUserName"))) { $Item["_ModerationStatus"] = "0" $Item.Update() $ctx.ExecuteQuery() write - host "done" } } } } catch { $_ | Out - File errors.txt - Append } } } if ($web.Webs.Count - eq 0) { try { #Get all files from the Library $List = $AllWeb.Lists.GetByTitle($LibraryName) $q = New - Object Microsoft.SharePoint.Client.CamlQuery $q.ViewXml = "<View Scope='RecursiveAll' />" $Items = $List.GetItems($q) $ctx.Load($Items) $ctx.ExecuteQuery() $FileName = "default.aspx" Foreach($Item in $Items) { $File = $Item["FileRef"].Substring($Item["FileRef"].LastIndexOf("/") + 1) if ($File - eq $FileName) { if ($Item["_ModerationStatus"] - eq "2" - and($Item["Editor"].LookupValue - eq("xxxUserName") - or $Item["Editor"].LookupValue - eq("xxxUserName"))) { $Item["_ModerationStatus"] = "0" $Item.Update() $ctx.ExecuteQuery() write - host "done" } } } } catch { $_ | Out - File errors.txt - Append } } } |
Moderation Status is a 4-byte integer indicating the moderation approval status of a list item.
Configurations can require moderation approval to publish a list item or allow automatic approval. A published list item MUST have a Moderation Status of 0. The following are all possible valid values for Moderation Status.
SharePoint 2013 Hosting UK – HostForLIFE.eu :: How To Connect To Microsoft Teams Using PowerShell?
Aug 16th
Microsoft Teams PowerShell cmdlets are currently available in beta version and this would be helpful for Microsoft Teams administration and management.
Open PowerShell window and run the following command to Install Microsoft Teams Module.
|
1 2 |
# Install Microsoft Teams Module Install-Module MicrosoftTeams |
Run the following command to add Teams module to the current session.
|
1 2 |
# Add MicrosoftTeams Module to the current session Import-Module MicrosoftTeams |
Run the following command to connect to Microsoft Teams.
|
1 2 3 4 5 |
# Get the credentials $credentials=Get-Credential # Connect to Microsoft Teams Connect-MicrosoftTeams -Credential $credentials |
Run the following command to get all the teams.
|
1 2 |
# Get all the teams Get-Team |
Reference
https://docs.microsoft.com/en-us/powershell/module/teams/?view=teams-ps
Thus in this blog, you saw how to connect to Microsoft Teams using PowerShell for service administration and management.
