Post-action task problems

Dylan,

At present, we only have a mechanism to run a batch file as a post task action, not as a task itself.

When you say it doesn't work, what happens?

How are you specifying the folder for where the batch file lives? (a UNC path? or a mapped drive? The BAT file is executed by the web service, which has no access to user-mapped drives).

I would recommend using batch tools to write information out to a log file from your BATCH file, so that you can see what is going on (does it get to the first step in your BAT file? or not even?).

#Set Error Action to Silently Continue
$ErrorActionPreference = "SilentlyContinue"

#Dot Source required Function Libraries
. "\\in-nas-n2\Software\Dylan\Scripts\ps1\loggingFunctions.ps1"

#----------------------------------------------------------[Declarations]----------------------------------------------------------

#Script Version
$sScriptVersion = "1.0"

#Log File Info
$sLogPath = "\\in-nas-n2\Software\Dylan\Scripts"
$sLogName = "logTest.log"
$sLogFile = Join-Path -Path $sLogPath -ChildPath $sLogName

#-----------------------------------------------------------[Functions]------------------------------------------------------------


Function revitDistribByJobNum{
  param([string] $jobNum = "")
  
  Begin{
    Log-Write -LogPath $sLogFile -LineValue "<description of what is going on>..."
  }
  
  Process{
    Try{
                #NOTHING needs changed at any point, even when the current year changes

                $currentYear = (get-date).year

                #job year is "20" plus first 2 digits of jobNum
                $jobYear = "20" + $jobNum.substring(0,2)

                #find correspoding folder and append it to path (this is a LOT quicker than searching through all files)
                $path = "P:\" + $jobYear
                $folder = get-childitem -path $path -name -include ($jobNum + "*")
                $path = $path + "\" + $folder + "\Transfers\Info Exchange Folders\Current RVT Files" #adding path by text instead of searching through everything, very efficient

                # Remove all folders ending in "_backup"
                get-childitem -path $path | where-object {$_.fullname -like "*_backup"} | %{remove-item -path $_.fullname -recurse -force -erroraction silentlycontinue}

                #check for newer "ARCH" or "FURN" files before run (so single older file isn't deleted)
                $newArchFile = get-childitem -path $path | where-object  {($_.fullname -like "*ARCH*") -and ($_.fullname -like "*-" + $currentYear + "*")}
                $newFurnFile = get-childitem -path $path | where-object  {($_.fullname -like "*FURN*") -and ($_.fullname -like "*-" + $currentYear + "*")}
                <#
                this checks if there's a newer file that needs the name changed, and doesn't run unless there is.
                this is a safeguard if one of the job numbers in the batch file didn't get a newer file or was accidentally left in.
                this way, if there's only one "ARCH" or "FURN" rvt file, it won't be deleted
                #>
                if(!($newArchFile -eq $null) -or !($newFurnFile -eq $null))
                {
                        #get all files in path
                        $files =  get-childitem -path $path
                        
                        #checks for new ARCH file
                        if(!($newArchFile -eq $null))
                        {
                                #delete all old files with "ARCH" (only if there's a newer file)
                                $files | % {
                                        $_ | where-object {($_.fullname -like "*ARCH*") -and ($_.fullname -notlike "*-" + $currentYear + "*")} | %{remove-item -path $_.fullName -Force -errorAction silentlyContinue}
                                }
                        }
                        if(!($newFurnFile -eq $null))
                        {
                                #delete all old files with "FURN" (only if there's a newer file)
                                $files | % {
                                        $_ | where-object {($_.fullname -like "*FURN*") -and ($_.fullname -notlike "*-" + $currentYear + "*")} | %{remove-item -path $_.fullName -Force -errorAction silentlyContinue}
                                }
                        }
                        #Rename all remaining files that include "ARCH" or "FURN", cutting off last 11 characters '-YYYY_MM_DD'
                        $files | where-object {($_.fullname -like "*ARCH*") -or ($_.fullname -like "*FURN*") -and ($_.fullname -like "*-" + $currentYear + "*")} | %{rename-item $_.fullname -newname ($_.fullname -replace "-$currentYear.*\.rvt", ".rvt")}
                }
    }
    
    Catch{
      Log-Error -LogPath $sLogFile -ErrorDesc $_.Exception -ExitGracefully $True
      Break
    }
  }
  
  End{
    If($?){
      Log-Write -LogPath $sLogFile -LineValue "Completed Successfully."
      Log-Write -LogPath $sLogFile -LineValue " "
    }
  }
}


#-----------------------------------------------------------[Execution]------------------------------------------------------------

Log-Start -LogPath $sLogPath -LogName $sLogName -ScriptVersion $sScriptVersion
revitDistribByJobNum -jobNum "18125"
Log-Finish -LogPath $sLogFile

Dylan, that looks like Powershell. Is Powershell installed on the host server? (That’s where it executes).

How do I install Powershell on the host server? I've been attempting to google it to figure it out for a while now and haven't gotten much luck

Solved the problem. Thanks for all your help Matt