Changing the author field in SharePoint

An action nobody should do, but in some cases necessary: changing the author of an item.

What do you need?
  • a farm account
  • PoweShell
And this script:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA 0

#specify new user
$newuser = "i:0#.w|DOMAIN\username"

#specify the web 
$site = get-SPWeb "https://yoursite/"
$site.AllowUnsafeUpdates = $true

#specify the list name and item
$list = $site.Lists["Listname"]
$listitem = $list.GetItemById(1)

#get the user and prepare the userfield value
$user = get-SPuser -Web $site -Identity $newuser
$userString = "{0};#{1}" -f $user.ID, $user.UserLogin.Tostring()

#set new author
$listitem["Author"] = $userString
$listitem.UpdateOverwriteVersion()

write-host $listitem["Title"] "has been updated. The author has been set to $user"

$site.Update()
$site.Dispose()

Be aware!
This script should be used wisely.

Comments

Post a Comment

Popular posts from this blog

SharePoint Framework Field Customizer project with multiple columns

Image
SharePoint Framework is growing fast and is doing well. With Field Customizer you can build an own rendering for columns in views like you used to build in CSR with JSLink. So there is an guide by Microsoft how to migrating your CSR applications into SPFx applications. It makes sense using this guide, because the Modern UI does not support CSR. The only struggle I had: Some CSR applications are rendering more than one column. So here is the topic of this post: How to build a SPFx Field Customizer Solution with multiple columns.
More »

First click in SharePoint List WebPart on wiki pages

Lets say you have a SharePoint wiki page with some content and you added a list WebPart underneath the text. You open the page and want to go into the list settings or add an item or do another operation you can do inside the ribbon. You will realize the ribbon is not there. First of all you need to click into the list to make the ribbon visible. There is a simple JavaScript solution.
More »

Get the mail address from a FieldUserValue Client Side vs Server Side

In SharePoint are two ways to code by using an object model. The one way is the Client-Side Object Modell (CSOM) and the other side is the Server-Side Object Model (SSOM). At the first look they both look the same the only difference is how the objects are looking for example the is the 'Site'-object (client side) is called 'SPSite' on server side. A good way to demonstrate the difference is to get the mailaddress of a userfield. That sounds easy, but needs more lines that I thought at first. So let's say you got a SharePoint 2013 and want to read the mailaddress on client side. That would look like this: 1 2 3 4 5 6 7 8 9 // get the userfield of the item e.q. Author FieldUserValue Author = (FieldUserValue)currentItem[ "Author" ]; // ask the web to find a user with the id in the field (only works if the user visited the site) var user = web.SiteUsers.GetById(Author.LookupId); // load the data with the context context.Load(user); context.ExecuteQue...
More »