aarebrot.net Frode's blog on Sharepoint and other stuff

Powershell: Check-in multiple files!

Posted on June 17, 2008
VN:F [1.9.22_1171]
Rating: 1.0/5 (2 votes cast)

I do a lot of CSS styling with my current project, and with that comes a lot of trial and error. I make image files, upload them, see how they look, delete them, upload new ones, take a look again, and so on. Depending on what stage I am in designing the page, I sometimes just stick the images in the Style Library and load them from there inside my CSS.

Luckily there's a "Upload multiple files" option in Sharepoint, but unfortunately there's isn't a quick way of checking in multiple files of a single directory. Well, there sort of is... But I just like Powershell better. Anyway, for the longest time I was clicking on each file individually and checking them in one by one. I figured there has got to be an easier way! Turns out the answer is Powershell.

Actually, there's apparently a way to do it in Site Settings as well, but I haven't tried it because Powershell is just so darned handy.

Anyway, after a whole whackload of research and some trial and error, I finally came up with a script that allows me to check-in and publish all files that are currently checked out. It's pretty nifty if I may say so myself.

This script isbased of another script written by Colin Byrne. If you think my script is the best thing since sliced bread,you really need to thank him, not me. I found a code snippet on his blog to publish pages in a site collection, and worked my way from there. You can view Colin's original script here.

Here is the full code:

# Description
#   Check-in and Publishes all checked-out files in a library
# Syntax
#   ./pubFiles [[-l] <string>] [[-f] <string>]
# Parameters
#   [[-l] <string>]
#       Specify an alternate library to publish files in
#   [[-f] <string>]
#       Filter to use when searching for files to publish
#       Example:
#       ./pubFiles -f file.jpg      - returns exact match
#       ./pubFiles -f ?ile.jpg      - single character wildcard
#       ./pubFiles -f *e.jpg        - multiple character wildcard
# Settings
#   Only change the -value parameter!
set-variable -option constant -name url     -value "http://localhost:31337"     # Site collection
set-variable -option constant -name comment -value "System Approval"            # Publishing comment
set-variable -option constant -name lib     -value "Style Library"              # Library to publish
set-variable -option constant -name dfilter -value "*"                          # Default file filter
# End of settings

# Function: Approve-File
# Description: Approve a single file in a Publishing Web
# Parameters: publishingPage File object
# comment Comment to accompany the check-in/approve/publish
function Approve-File ([Microsoft.SharePoint.SPListItem]$pubFile, [string]$comment) {
    "Processing " + $pubFile.Name
    $listitemfile = $pubFile.File

    # Check item if checked out
    if ($listitemfile.Level -eq [Microsoft.SharePoint.SPFileLevel]::Checkout)
        " Checking in file"
        $listitemfile.CheckIn($comment,[Microsoft.SharePoint.SPCheckInType]::MajorCheckin )

    # If moderation is being used then handle the approval and publishing
    if ($pubFile.ParentList.EnableModeration)
        $modInformation = $pubFile.ModerationInformation
        " Moderation Enabled"

        # Check for pending approval
        if($modInformation.Status -eq [Microsoft.SharePoint.SPModerationStatusType]::Pending)
            " Approving"

        # Publish
        if($modInformation.Status -eq [Microsoft.SharePoint.SPModerationStatusType]::Draft)
            " Publishing"

# Function: Approve-AllPagesInSPWeb
# Description: Loop through all the pages in a Publishing Web and checkin and approve them
# Parameters: web SPWeb object
# comment Comment to accompany the checkin/approve/publish
function Approve-AllPagesInSPWeb([Microsoft.SharePoint.SPWeb]$web, [string]$comment, [string]$destination, [string]$filter)
    # Check this is a publishing web
    if ([Microsoft.SharePoint.Publishing.PublishingWeb]::IsPublishingWeb($web) -eq $true)
        # just a quick loop to space out dashes
        for($c = 0; $c -lt $destination.length; $c++)
            $dshspcr += "-"

        # provide some feedback
        "Checking " + $destination + "..."
        "---------" + $dshspcr + "---"

        # do some stuff
        $list = $web.Lists[$destination]            # Load library we want to check
        [Object[]]$files = $list.get_items() | where { $_.Level -eq [Microsoft.SharePoint.SPFileLevel]::Checkout} | where { $_.Name -like $filter }
        $formatted = $files | ft -Autosize Url, Name, ID, Level, HasPublishedVersion
        if($files.count -gt 0)
            "Found the following files:"
            "Checking in files..."
            for($i=0; $i -lt $files.count; $i++)
                Approve-File $files[$i] $comment
            " - Found no files"

# Handle input parameters
for($c = 0; $c -lt $args.length; $c++)
    if($args[$c] -eq "-f")
        $filter = $args[$c]
    elseif($args[$c] -eq "-l")
        $library =  $args[$c]
        "Invalid parameter(s)"
        $fail = "yes"

if($library.length -lt 1)
    $library = $lib
if($filter.length -lt 0)
    $filter = $dfilter

if($fail -ne "yes")
    # Create site object
    $site = new-object Microsoft.SharePoint.SPSite($url)
    $site.rootweb | foreach {Approve-AllPagesInSPweb $_ $comment $library $filter}

    #Dispose of objects
    "Check-in and publish completed!"

# Changelog
#   v1.1 - June 19th, 2008
#       * Added ability to publish files based on a filename filter
#       * Added ability to publish files in an alternate library
#       * fixed bug preventing more than 2 function parameters to ApprovePagesInSPweb
#   v1.0 - June 18th, 2008
#       * First public release
Powershell: Check-in multiple files!, 1.0 out of 5 based on 2 ratings
Comments (3) Trackbacks (0)
  1. One word: Awesome.
    Thanks very much for this script!

  2. Hi i’m getting thus error:

    New-Object : Cannot find type [Microsoft.SharePoint.SPSite]: make sure the assembly containing this type is loaded.
    At C:\Users\Jeo\check-in-multiple-files.ps1:142 char:23
    + $site = new-object <<<< Microsoft.SharePoint.SPSite($url)
    + CategoryInfo : InvalidType: (:) [New-Object], PSArgumentException
    + FullyQualifiedErrorId : TypeNotFound,Microsoft.PowerShell.Commands.NewObjectCommand

    Unable to find type [Microsoft.SharePoint.SPWeb]: make sure that the assembly containing this type is loaded.
    At C:\Users\Jeo\check-in-multiple-files.ps1:71 char:62
    + function Approve-AllPagesInSPWeb([Microsoft.SharePoint.SPWeb] <<<< $web, [string]$comment, [string]$destination, [str
    + CategoryInfo : InvalidOperation: (Microsoft.SharePoint.SPWeb:String) [], RuntimeException
    + FullyQualifiedErrorId : TypeNotFound

    You cannot call a method on a null-valued expression.
    At C:\Users\Jeo\check-in-multiple-files.ps1:146 char:18
    + $site.Dispose <<<< ()
    + CategoryInfo : InvalidOperation: (Dispose:String) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

Cancel reply


No trackbacks yet.