Posts tagged trick SharePoint 2013 Hosting

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Create & Configure Machine Translation Service

Sep 20th

Posted by Peter in European SharePoint 2013 Hosting

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

Posted by Peter in European SharePoint Server 2013 Hosting

No comments

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.

{  
  "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",  
                    ""  
                  ]  
                }  
              ]  
            }  
          ]  
        }  
      ]  
    }  
  }  
}

{

"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

Posted by Peter in European SharePoint 2013 Hosting

No comments

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′

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′

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,

Accept: application/json;odata.metadata=minimal  
OData-Version: 4.0

1 2	Accept: application/json;odata.metadata=minimal OData-Version: 4.0

If the same headers are used in SharePoint Search API in Search site then we will end up with the below error,

{  
    "error": {  
        "code": "-1,  
        Microsoft.SharePoint.Client.UnknownError ",  
        "message": "Unknown Error"  
    }  
}

{

"error": {

"code": "-1,

Microsoft.SharePoint.Client.UnknownError ",

"message": "Unknown 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

let spOpts = {  
    headers: {  
        'odata-version': '3.0',  
        'Content-Type': 'application/json; odata=verbose'  
    }  
};  
this.context.spHttpClient.get(requestUrl, SPHttpClient.configurations.v1, spOpts).then((response: SPHttpClientResponse) => {  
    if (response.ok) {  
        response.json().then((responseJSON) => {  
            if (responseJSON != null) {  
                let searchResult: any = responseJSON;  
            }  
        });  
    }  
});

let spOpts = {

headers: {

'odata-version': '3.0',

'Content-Type': 'application/json; odata=verbose'

}

};

this.context.spHttpClient.get(requestUrl, SPHttpClient.configurations.v1, spOpts).then((response: SPHttpClientResponse) => {

if (response.ok) {

response.json().then((responseJSON) => {

if (responseJSON != null) {

let searchResult: any = responseJSON;

}

});

}

});

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?

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,

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’

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

Posted by Peter in European SharePoint 2013 Hosting

No comments

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.

    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  
      }

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.

    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  
        }  
    }

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.

Function RemoveUserFromServerAdminGroup([String]$AdminMember, [String]$ServerName)  
{  
    $ans = read-host "Do you want to remove user $AdminMember from server $ServerName (y/n)? "  
    if($ans -eq 'y')  
    {  
        write-host "Removing user " $AdminMember " from administrator group on server " $ServerName -       fore yellow  
        $AdminMember1 = $AdminMember.split("\")  
        $AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]  
        $GroupObj = [ADSI]"WinNT://$ServerName/Administrators"  
        $GroupObj.Remove("WinNT://$AdminMember2")  
        write-host $AdminMember " removed from the local administrator group on the server "        $ServerName -fore green  
    }  
    else  
    {  
    write-host "User choose not to remove user " $AdminMember " from the server " $ServerName "     administrator group" -fore cyan  
    }  
}

Function RemoveUserFromServerAdminGroup([String]$AdminMember, [String]$ServerName)

{

$ans = read-host "Do you want to remove user $AdminMember from server $ServerName (y/n)? "

if($ans -eq 'y')

{

write-host "Removing user " $AdminMember " from administrator group on server " $ServerName - fore yellow

$AdminMember1 = $AdminMember.split("\")

$AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]

$GroupObj = [ADSI]"WinNT://$ServerName/Administrators"

$GroupObj.Remove("WinNT://$AdminMember2")

write-host $AdminMember " removed from the local administrator group on the server " $ServerName -fore green

}

else

{

write-host "User choose not to remove user " $AdminMember " from the server " $ServerName " administrator group" -fore cyan

}

Complete Code

$LogTime = Get-Date -Format yyyy-MM-dd_hh-mm  
$LogFile = ".\GetServerAdministratorsPatch-$LogTime.rtf"  

# Add SharePoint PowerShell Snapin  
  
  
if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) {  
    Add-PSSnapin Microsoft.SharePoint.Powershell  
}  
import-module WebAdministration  
  
$scriptBase = split-path $SCRIPT:MyInvocation.MyCommand.Path -parent  
Set-Location $scriptBase  
  
write-host "TESTING FOR LOG FOLDER EXISTENCE" -fore yellow  
$TestLogFolder = test-path -path $scriptbase\Logs  
if($TestLogFolder)  
{  
    write-host "The log folder already exist in the script location" -fore yellow  
    $clearlogfolder = read-host "Do you want to clear the log folder (y/n)"  
    if($clearlogfolder -eq 'y')  
    {  
        write-host "The user choosen to clear the log folder" -fore yellow  
        write-host "Clearing the log folder" -fore yellow  
        remove-item $scriptbase\Logs\* -recurse -confirm:$false  
        write-host "Log folder cleared" -fore yellow  
    }  
    else  
    {  
        write-host "The user choosen not to clear the log files" -fore yellow  
    }  
}  
else  
{  
    write-host "Log folder does not exist" -fore yellow  
    write-host "Creating a log folder" -fore yellow  
    New-Item $Scriptbase\Logs -type directory  
    write-host "Log folder created" -fore yellow  
}         

#moving any .rtf files in the scriptbase location  
$FindRTFFile = Get-ChildItem $scriptBase\*.* -include *.rtf  
if($FindRTFFile)  
{  
    write-host "Some old log files are found in the script location" -fore yellow  
    write-host "Moving old log files into the Logs folder" -fore yellow  
    foreach($file in $FindRTFFile)  
        {  
            move-item -path $file -destination $scriptbase\logs  
        }  
    write-host "Old log files moved successfully" -fore yellow  
}  
  
start-transcript $logfile  
  
$global:timerServiceName = "SharePoint 2010 Timer"  
$global:timerServiceInstanceName = "Microsoft SharePoint Foundation Timer"  

# Get the local farm instance  
[Microsoft.SharePoint.Administration.SPFarm]$farm = [Microsoft.SharePoint.Administration.SPFarm]::get_Local()  
  
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  
  
}  
  
  
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  
    }  
  
}  
  
  
Function RemoveUserFromServerAdminGroup([String]$AdminMember, [String]$ServerName)  
{  
  
    $ans = read-host "Do you want to remove user $AdminMember from server $ServerName (y/n)? "  
    if($ans -eq 'y')  
    {  
        write-host "Removing user " $AdminMember " from administrator group on server " $ServerName -fore yellow  
          
        $AdminMember1 = $AdminMember.split("\")  
        $AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]  
          
        $GroupObj = [ADSI]"WinNT://$ServerName/Administrators"  
        $GroupObj.Remove("WinNT://$AdminMember2")  
        write-host $AdminMember " removed from the local administrator group on the server " $ServerName -fore green  
    }  
    else  
    {  
        write-host "User choose not to remove user " $AdminMember " from the server " $ServerName " administrator group" -fore cyan  
    }  
  
}  
  
write-host "########################################################################################################" -fore cyan  
write-host "Enter 1 to get the SP server administrator details" -fore green  
write-host "Enter 2 to add users to local administrator group" -fore green  
write-host "Enter 3 to remove users from local administrator group" -fore green  
write-host "########################################################################################################" -fore cyan  
  
  
$option = read-host "Enter the option "  
  
switch($option)  
  
{  
  
    1{  
        GetServerAdministrators $farm  
      }  
  
    2{  
        write-host "Preparing to add users to the server administrator group" -fore magenta  
        $csvfile = $scriptbase + "\" + "AddUsers.csv"  
        import-csv $csvfile | where {  
        AddUserToServerAdminGroup $_.AdminMember $_.ServerName  
        }  
        write-host "Users has been added to local administrators group" -fore green  
      }  
  
    3{  
        write-host "Preparing to remove users from the server administrator group" -fore magenta  
        $csvfile1 = $scriptbase + "\" + "RemoveUsers.csv"  
        import-csv $csvfile1 | where {  
        RemoveUserFromServerAdminGroup $_.AdminMember $_.ServerName  
        }  
        write-host "Users has been removed from local administrators group" -fore green       
      }  
  
}  
  
stop-transcript

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

$LogTime = Get-Date -Format yyyy-MM-dd_hh-mm

$LogFile = ".\GetServerAdministratorsPatch-$LogTime.rtf"

# Add SharePoint PowerShell Snapin

if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) {

Add-PSSnapin Microsoft.SharePoint.Powershell

}

import-module WebAdministration

$scriptBase = split-path $SCRIPT:MyInvocation.MyCommand.Path -parent

Set-Location $scriptBase

write-host "TESTING FOR LOG FOLDER EXISTENCE" -fore yellow

$TestLogFolder = test-path -path $scriptbase\Logs

if($TestLogFolder)

{

write-host "The log folder already exist in the script location" -fore yellow

$clearlogfolder = read-host "Do you want to clear the log folder (y/n)"

if($clearlogfolder -eq 'y')

{

write-host "The user choosen to clear the log folder" -fore yellow

write-host "Clearing the log folder" -fore yellow

remove-item $scriptbase\Logs\* -recurse -confirm:$false

write-host "Log folder cleared" -fore yellow

}

else

{

write-host "The user choosen not to clear the log files" -fore yellow

}

else

{

write-host "Log folder does not exist" -fore yellow

write-host "Creating a log folder" -fore yellow

New-Item $Scriptbase\Logs -type directory

write-host "Log folder created" -fore yellow

}

#moving any .rtf files in the scriptbase location

$FindRTFFile = Get-ChildItem $scriptBase\*.* -include *.rtf

if($FindRTFFile)

{

write-host "Some old log files are found in the script location" -fore yellow

write-host "Moving old log files into the Logs folder" -fore yellow

foreach($file in $FindRTFFile)

{

move-item -path $file -destination $scriptbase\logs

}

write-host "Old log files moved successfully" -fore yellow

}

start-transcript $logfile

$global:timerServiceName = "SharePoint 2010 Timer"

$global:timerServiceInstanceName = "Microsoft SharePoint Foundation Timer"

# Get the local farm instance

[Microsoft.SharePoint.Administration.SPFarm]$farm = [Microsoft.SharePoint.Administration.SPFarm]::get_Local()

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

}

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

}

Function RemoveUserFromServerAdminGroup([String]$AdminMember, [String]$ServerName)

{

$ans = read-host "Do you want to remove user $AdminMember from server $ServerName (y/n)? "

if($ans -eq 'y')

{

write-host "Removing user " $AdminMember " from administrator group on server " $ServerName -fore yellow

$AdminMember1 = $AdminMember.split("\")

$AdminMember2 = $AdminMember1[0] + "/" + $AdminMember1[1]

$GroupObj = [ADSI]"WinNT://$ServerName/Administrators"

$GroupObj.Remove("WinNT://$AdminMember2")

write-host $AdminMember " removed from the local administrator group on the server " $ServerName -fore green

}

else

{

write-host "User choose not to remove user " $AdminMember " from the server " $ServerName " administrator group" -fore cyan

}

write-host "########################################################################################################" -fore cyan

write-host "Enter 1 to get the SP server administrator details" -fore green

write-host "Enter 2 to add users to local administrator group" -fore green

write-host "Enter 3 to remove users from local administrator group" -fore green

write-host "########################################################################################################" -fore cyan

$option = read-host "Enter the option "

switch($option)

{

GetServerAdministrators $farm

}

write-host "Preparing to add users to the server administrator group" -fore magenta

$csvfile = $scriptbase + "\" + "AddUsers.csv"

import-csv $csvfile | where {

AddUserToServerAdminGroup $_.AdminMember $_.ServerName

}

write-host "Users has been added to local administrators group" -fore green

}

write-host "Preparing to remove users from the server administrator group" -fore magenta

$csvfile1 = $scriptbase + "\" + "RemoveUsers.csv"

import-csv $csvfile1 | where {

RemoveUserFromServerAdminGroup $_.AdminMember $_.ServerName

}

write-host "Users has been removed from local administrators group" -fore green

}

stop-transcript

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

Posted by Peter in European SharePoint 2013 Hosting

No comments

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.

    #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  
    $userId = "xxxx@msdcloud.onmicrosoft.com"  
    $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  
            }  
        }  
    }

#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

$userId = "[email protected]"

$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

Posted by Peter in European SharePoint 2013 Hosting

No comments

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.

# Install Microsoft Teams Module  
Install-Module MicrosoftTeams

1 2	# Install Microsoft Teams Module Install-Module MicrosoftTeams

Run the following command to add Teams module to the current session.

# Add MicrosoftTeams Module to the current session  
Import-Module MicrosoftTeams

1 2	# Add MicrosoftTeams Module to the current session Import-Module MicrosoftTeams

Run the following command to connect to Microsoft Teams.

# Get the credentials    
$credentials=Get-Credential   
    
# Connect to Microsoft Teams  
Connect-MicrosoftTeams -Credential $credentials

# Get the credentials

$credentials=Get-Credential

# Connect to Microsoft Teams

Connect-MicrosoftTeams -Credential $credentials

Run the following command to get all the teams.

# Get all the teams   
Get-Team

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.

Posts tagged trick SharePoint 2013 Hosting

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Create & Configure Machine Translation Service

Create Machine Translation Service

Step 1

Step 2

Step 3

Step 4

Configure Machine Translation Service

Step 1

Step 2

Step 3

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Color Formatting Of A SharePoint Online List Using JSON

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Reading The SharePoint News Using Rest API In SPFx

SharePoint 2013 Hosting UK – HostForLIFE.eu :: PowerShell to Get/Add/Remove Users of Local Administrator Group

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Find Default Page And Approve It Using Powershell In SPO

SharePoint 2013 Hosting UK – HostForLIFE.eu :: How To Connect To Microsoft Teams Using PowerShell?

BLOGROLL

Featured On

Posts tagged trick SharePoint 2013 Hosting

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Create & Configure Machine Translation Service

Create Machine Translation Service

Step 1

Step 2

Step 3

Step 4

Configure Machine Translation Service

Step 1

Step 2

Step 3

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Color Formatting Of A SharePoint Online List Using JSON

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Reading The SharePoint News Using Rest API In SPFx

SharePoint 2013 Hosting UK – HostForLIFE.eu :: PowerShell to Get/Add/Remove Users of Local Administrator Group

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Find Default Page And Approve It Using Powershell In SPO

SharePoint 2013 Hosting UK – HostForLIFE.eu :: How To Connect To Microsoft Teams Using PowerShell?

BLOGROLL

Featured On

Tags