Author: Andrew Toh

I work as a SharePoint administrator for an ASX listed company in Perth, Australia. Previously an IT Systems Engineer, I am fairly new to the SharePoint arena having only close to 2 years experience working with the product. As an administrator, it is my responsibility to maintain and continuously improve on our SharePoint architecture. My role also encompasses some non-administrative duties like business analysis and OOTB development work. With such a broad job scope, my learning curve is steep but interesting. The purpose of this blog is to document my thoughts and findings, both technical and non-technical, as I work with the product every day.
Uncategorized

Calculated field to split File Path

on Calculated field to split File Path

Requirement: Created a calculated field in a SharePoint list/library to split a filepath and store the first 3 folder levels in 3 separate metadata fields. For example: C:\Users\Admin\Desktop\test.txt  Level 1 Level 2  Level 3 Users  Admin  Desktop Solution Assuming MigrationSourceURL is the column in SharePoint that stores the file path: Level 1 formula =IF(MigrationSourceURL="","N/A",LEFT(RIGHT(MigrationSourceURL,LEN(MigrationSourceURL)-3),SEARCH("\",RIGHT(MigrationSourceURL,LEN(MigrationSourceURL)-3))-1))=IF(MigrationSourceURL="","N/A",LEFT(RIGHT(MigrationSourceURL,LEN(MigrationSourceURL)-3),SEARCH("\",RIGHT(MigrationSourceURL,LEN(MigrationSourceURL)-3))-1)) Level […]

Continue Reading...
Administration

Get list of Site Collection Admins (SCA) using PowerShell

1 Comment on Get list of Site Collection Admins (SCA) using PowerShell

Requirement Generate a list of SCAs across all your SharePoint site collections. Solution function Get-SCA { param($site) $link = $site+"/_layouts/mngsiteadmin.aspx"   $result = Invoke-WebRequest $link -UseDefaultCredentials   $value = $result.AllElements | Where id -eq "ctl00_PlaceHolderMain_ctl00_PeopleEditorAdmins_OriginalEntities" | Select value $value = $value.value.split(">") | where { $_ -match "displaytext" } $value = $value.split("`"") | where { $_ […]

Continue Reading...
Administration

Automatically download versions of a file in SharePoint to your computer

1 Comment on Automatically download versions of a file in SharePoint to your computer

Requirement Download all versions of a file in SharePoint to a local folder on your computer. Solution Use the PowerShell script below to do this. You can run this script as a normal user as long as you have access to the GetVersions webservice method. Usage: Run the script in PowerShell or PowerShell ISE. Parameters: […]

Continue Reading...
Administration

SharePoint 2010 Service Pack 2 no longer allows unresolvable e-mail addresses

on SharePoint 2010 Service Pack 2 no longer allows unresolvable e-mail addresses

Problem: Before Service Pack 2, you could specify an e-mail address in the cc’ field of a workflow form. After installing Service Pack 2, this is no longer possible and you will get the following error message and will not be able to submit the form: No exact match was found. Click the item(s) that […]

Continue Reading...
Administration, Development

SharePoint 2010 Service Pack 2 breaking scripts using SPServices / jquery

on SharePoint 2010 Service Pack 2 breaking scripts using SPServices / jquery

Problem: We have some scripts that use jQuery Library for SharePoint Web Services. After installing Service Pack 2 for SharePoint 2010, several of the scripts stopped working. Cause: We found that the script renamed the form control titles if the field was a mandatory field. For example: If you have a required /mandatory field called […]

Continue Reading...