Skip to main content

Posts

Showing posts from December, 2017

Create a SharePoint Online Site - Office 365 using Powershell

Create a SharePoint  Online Site - Office 365 using Powershell # Usage #       .\create-site-csom.ps1 -siteTitle "new site2" -siteUrl "newsite2" -cred $false -parent "https://pravahaminfo.sharepoint.com/teams/appdev1/" # #       .\create-site-csom.ps1 -siteTitle "new site2" -siteUrl "newsite2" -cred $true -parent "https://pravahaminfo.sharepoint.com/teams/appdev1/" #               Will ask for Credentials Param(     [Parameter(Mandatory=$true)]  [string] $parent,  [Parameter(Mandatory=$true)]  [string] $siteTitle, [Parameter(Mandatory=$true)] [string] $siteUrl, [string] $siteDescription,     [string] $template = "STS#0",     [bool] $cred #Use custom Credentials ) #Clear-Host Write-Host "Initializing..." $resources = split-path $script:MyInvocation.MyCommand.Definition if(-not $(Test-Path "$resources\bin")) ...

Get List of Site owners from all web applications in SharePoint using Powershell

List of Site owners from all web applications in SharePoint using Powershell Add-PSSnapin "Microsoft.SharePoint.Powershell" function CreateReportObject($url = $null, $title = $null, $desc = $null, $IsRoot = $null, $groupname = $null, $loginname = $null, $dg = $null, $email = $null, $ucount = $null, $created = $null, $farm = $null,$isreadonly = $null)  {  $newreportobj = new-object psobject          $newreportobj | add-member noteproperty -name "URL" -value $url  $newreportobj | add-member noteproperty -name "Title" -value $title  $newreportobj | add-member noteproperty -name "Description" -value $desc  $newreportobj | add-member noteproperty -name "IsRootWeb" -value $IsRoot          $newreportobj | add-member noteproperty -name "Groups" -value $groupname         $newreportobj | add-member noteproperty -name "Owners" -value $loginname $newreportobj | add-member notepr...

Get List of Site collection owners from all web applications in SharePoint using Powershell

List of Site collection owners from all web applications in SharePoint using Powershell Add-PSSnapin "Microsoft.SharePoint.Powershell" function CreateReportObject($url = $null, $title = $null, $loginname = $null, $dg = $null, $created = $null, $isreadonly = $null, $email = $null) { $newreportobj = new-object psobject          $newreportobj | add-member noteproperty -name "URL" -value $url  $newreportobj | add-member noteproperty -name "Title" -value $title         $newreportobj | add-member noteproperty -name "Owners" -value $loginname $newreportobj | add-member noteproperty -name "DomainGroups" -value $dg         $newreportobj | add-member noteproperty -name "Email" -value $email $newreportobj | add-member noteproperty -name "Created" -value $created  $newreportobj | add-member noteproperty -name "Is Read-Only" -value $isreadonly         return ($newreportobj)...

Error message : The file name or path does not exist; The file is being used by another program; The workbook you are trying to save has the same name as currently open workbook". While opening Excel file in SharePoint

Issue : Trying to download files from SharePoint through either IE or Chrome, however, getting this message: " The file name or path does not exist; The file is being used by another program; The workbook you are trying to save has the same name as currently open workbook " this happens to any file I try to download  Solution : Local office cache was the root cause of the problem only regular users who kept accessing the same files on SharePoint were the ones experiencing this issue. Excel and Word would refer to the office cache files and wouldn't find the documents. Below are the steps to resolve this issue. Follow steps from 1 to 4 if you need to unhide folders. 1.Right-Click on Start and choose 'Open Windows Explorer' 2.Tools > Folder Options. Choose the View tab. 3.In 'Hidden Files and folders ' select 'Show hidden files, folders and drives. 4.Uncheck 'Hide protected operating system files(Recommended)' 5.Go to ...