I have recently had reason to update the PictureURL property value via PowerShell in SharePoint 2010 for all users in the system.
As a result, I wrote the following PowerShell script to update the property value using string replace.
Although not generic code, I shall be using this again as a starting base to update any property in future.
You will ideally need to run this on the server with an account with the appropriate permissions to update all user profiles.
1 #Set up default variables
2
3 #My Site URL
4 $mySiteUrl = "http://mysite/"
5
6 #The part of the picture URL you are trying to find
7 $currentURLValue = "http://mypersonalsite"
8
9 #The value that will replace the above
10 $newURLValue = "http://mysite:80"
11
12 #The internal name for PictureURL
13 $upPictureURLAttribute = "PictureURL"
14
15 #Get site objects and connect to User Profile Manager service
16 $site = Get-SPSite $mySiteUrl
17 $context = Get-SPServiceContext $site
18 $profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)
19 $profiles = $profileManager.GetEnumerator()
20
21 foreach ($userProfile in $profiles) {
22
23 if ($userProfile[$upPictureURLAttribute] -ne '') {
24
25 $newPictureURL = $userProfile[$upPictureURLAttribute].toString()
26 $newPictureURL = $newPictureURL.Replace($currentURLValue, $newURLValue)
27
28 write-host "Before: " $userProfile[$upPictureURLAttribute].toString() " | After: " $newPictureURL
29
30 #Get user profile and change the value - uncomment the lines below to commit the changes
31 #$userProfile[$upPictureURLAttribute].Value = $newPictureURL
32 #$userProfile.Commit()
33
34 }
35
36 }
37
Like this:
Like Loading...
Great post! Regrettably, I keep running into:
New-Object : Exception calling “.ctor” with “1″ argument(s): “Object reference not set to an instance of an object.”
At line:1 char:29
+ $profileManager = New-Object <<<< Microsoft.Office.Server.UserProfiles.UserProfileManager($context)
+ CategoryInfo : InvalidOperation: (:) [New-Object], MethodInvocationException
+ FullyQualifiedErrorId : ConstructorInvokedThrowException,Microsoft.PowerShell.Commands.NewObjectCommand
… and yes I load the assemblies.
Any ideas?
Blaalyn, this article was helpful for me:
http://blogs.technet.com/b/speschka/archive/2010/02/22/no-user-profile-application-available-mystery-in-sharepoint-2010.aspx
if you encounter the issue above, i believe it means that your account doesn’t have the right permissions (maybe on the User Profile DB?). Try running as the farm account.