Updating a List's "Modified By/Created By" Properties

Here is a piece of code that can be used in Powershell to update the Modified By and Created By properities on a list. This is helpful if you move content using Sushi or other tool and they don't get updated. We tried to use Sushi to update this information, but found that you couldn't do it.

[Reflection.Assembly]::Load("Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")

# Change the URL to your site
$SPSite = New-Object Microsoft.SharePoint.SPSite("http://source/presidentscorner/")
$SPWeb = $SPSite.OpenWeb()

$SPList = $SPWeb.Lists["Comments"]
$SPListItemCollection = $SPList.Items

foreach ($ListItem in $SPListItemCollection)
{
# Make sure you are updating the correct item in the list
if ($ListItem.ID -eq 4)
{
# Change the User ID and Name to who you want shown.
# If the user doesn't exist in the Web collection then added them as a visitor and get their ID. You can then delete them
# from the group and everything will still work
$SPFieldUserValue = New-Object Microsoft.SharePoint.SPFieldUserValue($SPWeb,131, "Shields, Lance")
$ListItem["Author"] = $SPFieldUserValue
$ListItem["Editor"] = $SPFieldUserValue
$ListItem.Update()
}
if ($ListItem.ID -eq 5)
{
$SPFieldUserValue = New-Object Microsoft.SharePoint.SPFieldUserValue($SPWeb,179, "Martin, Ryan")
$ListItem["Author"] = $SPFieldUserValue
$ListItem["Editor"] = $SPFieldUserValue
$ListItem.Update()
}
}

$SPWeb.Update()

Comments

Unknown said…
Nice Article..
But the user id is not the same for each site.
So one can use the
SPUser user=web.Ensureuser(loginName or aliasName);

and use

spfielduservalue value=new spuserfieldvalue(wed,user.ID,user.LoginName);


Hope it Helps!!

Bharath
October 13, 2009 at 9:30 AM
Post a Comment

Popular posts from this blog

SharePoint SP2 - Beware! (Update)

Here is some more fun stuff to know about installing SP2 on your SharePoint server. Microsoft just posted some info on the SharePoint team blog ( http://blogs.msdn.com/sharepoint/archive/2009/05/21/attention-important-information-on-service-pack-2.aspx ) that talks about how after installing SP2 your SharePoint license key will expire and your product will revert back to evaluation mode. Everything should still function normally, but after 180 days it will stop working unless you fix the problem. To do this you just need to reenter your product key in Central Admin. MS is working on a hotfix that should be out soon. Hopefully they push out a new install for SP2 as well so no one else has to go through this.
Read more

Thumbnail View of Slides

One thing you lose when you create a data view of a slide library is the ability to just show a thumbnail without some custom work. It's not difficult, just a pain. Here's the code so you don't have to waste time thinking about something that should be built in. Note: This works for ppt and pptx files. You'll have to think to make the rest work! <td class="ms-vb"> <xsl:variable name="fileExt" select="concat('_pp',substring-after(@FileLeafRef, '.pp'))" /> <xsl:variable name="fileName" select="substring-before(@FileLeafRef, '.pp')" /> <img border="0" src="/{@FileDirRef}/_t/{$fileName}{$fileExt}.jpg" /> </td>
Read more

Breaking Permissions and Web Part Access

Here is a tip about how to prevent your site owner or other users who have access to add web pages from getting an access denied message when they try to edit a page. Background You have a site collection with a top level site that you don't want anyone to access so you remove the permissions from it. Then on your sub-sites you break inheritance so you can get the security set up the way you want. The Issue When users go to edit a page to do something like add a web part they are given an access denied error. You can see this even if you have "Full Control" access on the sub-site. The Resolution Go to the top level site and create a new Group (ex: WebPartViewers), but don't give it any access. Next, add the users or groups that you want to be able to add and remove web parts from a page. You could add "Authenticated Users", but that is probably not a good idea since you will be opening up the web part library with this change. Now go to the Web Part Gall...
Read more