Tag Archives: PowerShell

SharePoint: My Fav Tool Set

09 Wednesday Oct 2013

Posted by in Sharepoint

≈ Leave a comment

Tags

, ,

Planning | Deployment | Administration, Operations and Troubleshooting | Development

Planning

Deployment

Administration, Operations and Troubleshooting

Development

Advertisements

Install and Configure the Office 365 PowerShell Cmdlets:

23 Monday Sep 2013

Posted by in Ofice365, PowerShell, Sharepoint

≈ Leave a comment

Tags

, ,

You need either Windows 7 or Windows Server 2008 R2 with Windows PowerShell and .NET Framework 3.5.1 or higher installed. You’ll also need to download and install the Office 365 Sign-in Assistant. Here’s the links to either the 32 or 64 bit version:
Microsoft Online Services Sign-In Assistant (IDCRL7) – 32 bit version
Microsoft Online Services Sign-In Assistant (IDCRL7) – 64 bit version

Next you will download and install the cmdlets. After you download the appropriate file, double-click the “AdministrationConfig.msi” file.
Microsoft Online Services Module for Windows PowerShell (32-bit version)
Microsoft Online Services Module for Windows PowerShell (64-bit version)

If you got the following error message (although Microsoft Online Services Sign-In assistant version 7.0 is installed)

“In order to install Windows Azure Active Directory Module for Windows PowerShell, you must have Microsoft Online Services Sign-In Assistant version 7.0 or greater installed on this computer”

The workaround solution is to install instead the Microsoft Online Services Sign-In Assistant for IT Professionals BETA:

http://www.microsoft.com/en-us/download/details.aspx?id=39267

The installation adds the shortcut titled “Microsoft Online Services Module for Windows PowerShell” to your desktop and the Start Menu. Once the module is installed you can try connecting to Office 365 by following the directions in the previous blog.

If you are facing any problems you may have to enable PowerShell scripts to run on your computer. Type the following command after opening PowerShell as an Administrator:

Get-ExecutionPolicy

If the results say anything other than RemoteSigned then run this command:

Set-ExecutionPolicy RemoteSigned

That should enable your computer to connect PowerShell to Office 365. If it doesn’t then go through this TechNet article for further troubleshooting:
http://technet.microsoft.com/en-us/library/cc952756%28EXCHSRVCS.149%29.aspx

Scripting your connection

Once you have finished the above you’re ready to actually connect to your Office365 domain. Here is the syntax that you will need to run:

Import-Module MSOnline
$O365Cred = Get-Credential
$O365Session = New-PSSession –ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell -Credential $O365Cred -Authentication Basic -AllowRedirection
Import-PSSession $O365Session -AllowClobber
Connect-MsolService –Credential $O365Cred

The file at the right contains the code above. If you download it and run it from within Powershell it will get you connected. Otherwise you can use the above to create your own or copy line by line into Powershell.

I Deleted A Site Collection in Production Sever

28 Thursday Jul 2011

Posted by in Sharepoint

≈ Leave a comment

Tags

, ,

In one early morning, I am doing multi tasks. I think I am in the sub site but actually I am in the top level. When I deleted that site, some calls coming in.

Fortunately, there is PowerShell cmd you can restore deleted site collection.This cmdlet was introduced in Microsoft SharePoint Server 2010 with Service Pack 1 (SP1) and Microsoft SharePoint Foundation 2010 with Service Pack 1 (SP1).

  • Get-SPDeletedSite
  • Restore-SPDeletedSite
  • Remove-SPDeletedSite

Run Use Get-SPDeletedSite to find Identity (GUID) then

Restore-SPDeletedSite -Identity 610857cb-8414-4a89-8bf3-ad3628f6c86c

All deleted sub site can be retrieved from Site Recycle Bin!

Click the Site Collection Recycle Bin (Site Actions > Site Settings > Recycle Bin) under Site Collection Administration:

Select “Deleted from end user Recycle Bin”

Select the checkbox next to the site to restore and click “Restore Selection” from the menu above. Once completed, navigate to the newly restore site:

 

Thanks Microsoft for saving my job!

Import-SPWeb : Cannot import site.

28 Tuesday Jun 2011

Posted by in PowerShell, Sharepoint

≈ 1 Comment

Tags

, ,

Error:
FatalError: Cannot import site. The exported site is based on the template STS#0 but the destination site is based on the template SPS#0. You can import sites only into sites that are based on same template as the exported site.

Import-SPWeb : Cannot import site. The exported site is based on the template STS#0 but the destination site is based on the template STS#1. You can import sites only into sites that are based on same template as the exported site.

Issue:-
In SharePoint 2010 when we use Powershell Commands to Export / Import site collections we get Site Template mismatch errors as now SP 2010 needs to have the same template for the site while importing which was used on the site exported.
In such scenarios when you have migrated from SPS 2003 -> MOSS 2007 -> SP 2010 there will be many old Site templates which are now Obsolete in SP 2010 and not available, due to which it will be very difficult to Import the site.

Resolution / Workaround:-
1. Central Admin -> Application Management -> Create Site Collection
2. During Template selection go to ‘Custom’ Tab -> Select Template Later…..
3. Run the Import-SpWeb command now and it should import the site collection without any issues.
As we are not selecting any template while creating a Site Collection, it automatically pics up the template which is using while importing the Site Collection.

The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered

02 Thursday Jun 2011

Posted by in PowerShell, Sharepoint

≈ Leave a comment

Tags

Problem

When you run powershell on your server you get the following error:

The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.

clip_image001

Solution

Make sure the logged in user has rights to the SharePoint_Configuration database

    • SharePoint_Shell_Access
    • DB_owner (try reducing the privileges after you get it working in order to support “least privileges”

clip_image002

Power Shell Script to Check HREF ULR in InfoPath form

08 Wednesday Dec 2010

Posted by in PowerShell

≈ Leave a comment

Tags

,

We have a system which contains thousands of InfoPath forms, the template files are in the SharePoint site. And some forms cannot be opened after some users editing because of the wrong InfoPath Cache. So I wrote the little scrip to loop all the forms and get HREF string to check if the url is valid.

Param($Path = "D:\Temp",[switch]$verbose)

Write-Host

$fc = new-object -com scripting.filesystemobject
$folder = $fc.getfolder($path)
$strFinder = "http.*xsn"
$logfile = "D:\Temp\NPILog.txt"

function ProcessFiles([string]$folderpath) {

Write-host " + Processing all Forms from: $folderpath"
$Forms = dir $folderpath "*.xml"

		Write-host "  + $($Forms.count) Forms found"
		Write-host " + Processing all $($Forms.count) Forms located at: $folderpath" -fore White

			foreach($Form in $Forms)
			{
				Write-Host "  + +	Processing Form: $($Form.Name)" -fore White
				Find-String  $strFinder $Form.FullName
			}	
	
}

function Find-String($find, $path)
{
    $url_values = New-Object System.Collections.ArrayList
	$i = 0
	echo "Finding string `"$find`" in file contents and file names of path: $path"
	ls $path | select-string $find -list |% { echo "Processing contents of $($_.Path)"; (get-content $_.Path) |% { [regex]::matches($_, $find) |%{$url_values.Add($_.value); $i++}} }
    echo $url_values[0]
	if(Check-URL $url_values[0])
	{
		Write-Host "$($path) href is fine"
	}
	else
	{
		Write-Host "$($path) href is wrong" -foregroundcolor red -backgroundcolor yellow
		Add-Content $logfile "$($path) href is wrong, checked at $(Get-Date)"

	}
}

function Check-URL($url)
{
	$urlIsValid = $false
	try
	{
		$request = [System.Net.WebRequest]::Create($url)
		$request.Credentials = [System.Net.CredentialCache]::DefaultCredentials;
		$request.Method = 'HEAD'
		$response = $request.GetResponse()
		$httpStatus = $response.StatusCode
		$urlIsValid = ($httpStatus -eq 'OK')
		$tryError = $null
		$response.Close()
	}
	catch [System.Exception] {
		$httpStatus = $null
		$tryError = $_.Exception
		$urlIsValid = $false;
	}
    
	return $urlIsValid
}

Write-Host "$($folder.ShortName) "
Write-Host "  + Total Folders: $($folder.SubFolders.Count)"
foreach ($i in $folder.SubFolders) {
	Write-Host "  + Folder Name: $($i.ShortName)"
	ProcessFiles($i.Path)
}

PowerShell Replace Script

17 Wednesday Nov 2010

Posted by in PowerShell

≈ Leave a comment

Tags

Below is the script that loop folder to replace the string in all XML files.

The string I need to place is the href link in InfoPath form. So it look like 

href="http://ppp/ppp/template.xsn"

 

So I use the way to replace string in between the characters

'bleeeh' -replace '(bl).+(h)','$1cc$2'

 

This will print out: blcch

The whole script is look like:

Param($Path = "D:\Temp",[switch]$verbose)

Write-Host

$fc = new-object -com scripting.filesystemobject
$folder = $fc.getfolder($path)
$strFinder = '(href="http://).+(template.xsn)'

function ProcessFiles([string]$folderpath) {

Write-host " + Processing all Forms from: $folderpath"
$Forms = dir $folderpath "*.xml"

Write-host "  + $($Forms.count) Forms found"
Write-host " + Processing all $($Forms.count) Forms located at: $folderpath" -fore White

	foreach($Form in $Forms)
	{
		$strReplace ="$1XXX$2"
		Write-Host "  + +	Processing Form: $($Form.Name)" -fore White
		if($Form.Name.Contains("IPP")){$strReplace ='$1IPP$2'}
		elseif($Form.Name.Contains("EDP")){$strReplace ='$1EDP$2'}
		Replace-String  $strFinder $strReplace $Form.FullName
	}	
}

function Replace-String($find, $replace, $path)
{
	echo "Replacing string `"$find`" with string `"$replace`" in file contents and file names of path: $path"
	ls $path | select-string $find -list |% { echo "Processing contents of $($_.Path)"; (get-content $_.Path) |% { $_ -replace $find, $replace } | set-content $_.Path -Force }
}

Write-Host "$($folder.ShortName) "
Write-Host "  + Total Folders: $($folder.SubFolders.Count)"
foreach ($i in $folder.SubFolders) {
	Write-Host "  + Folder Name: $($i.ShortName)"
	ProcessFiles($i.Path)
}

 

Love PowerShell

Use PowerShell Script as Schedule Task

08 Friday Oct 2010

Posted by in PowerShell

≈ Leave a comment

Tags

Just create a schedule task as usual and put below command in

C:\windows\system32\WindowsPowerShell\v1.0\powershell.exe –File 
S:\chkzheng\PowerShellLibrary\Get-SPSite.ps1 -url http://chisps71

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }