Need to append this powershell script, not sure what to do

Question

I need some help expanding on this script. Basically, I need to add when the $inputFileName = 'Report.txt' is not in its default dir when the script runs every morning the job spits out an e-mail saying no file to process, and then the job stops. What I am seeing is when there is no file in the source dir every now and then, the job runs attaching a blank .xls file that is of no use. I appreciate ANY help in advance!

$ErrorActionPreference="SilentlyContinue"
Stop-Transcript | out-null
$ErrorActionPreference = "Continue"
Start-Transcript -path C:\PATH\Logoutput.txt -append


$emailFilePath = 'C:\PATH\PATH\'
$inputFilePath = 'C:\PATH\PATH\Upload'
$inputFileName = 'Report.txt'
$inputFile = Join-Path $inputFilePath $inputFileName
$outputFileName = 'Report.csv'
$outputFilePath = 'C:\PATH\PATH\Send' 
$OutputFile = Join-Path $outputFilePath $outputFileName 

$folder = 'C:\PATH\PATH\Upload'
$filter = 'Report.txt'                            
$destination = $outputFilePath

$dateTime1 = Get-Date -Format s

Write-Host "The file was received: $dateTime1"
Import-CSV $inputFile -Delimiter "`t" -Header "Value 1" , "Value 2" , "Value 3" , "Value 4" , "Value 5" | Tee-Object -Variable Report.txt | Export-CSV $OutputFile  -Delimiter "," -NoTypeInformation

$xl = new-object -comobject excel.application
$xl.visible = $false
$Workbook = $xl.workbooks.open("$OutputFile")
$Worksheets = $Workbooks.worksheets
$Workbook.SaveAs("$outputFilePath\Report.xls",1)
$Workbook.Saved = $True
$xl.Quit()

$objExcel = new-object -comobject excel.application  
$objExcel.Visible = $false
$objWorkbook = $objExcel.Workbooks.open("$outputFilePath\Report.xls")  
$objWorksheet = $objWorkbook.Worksheets.Item(1)  
$objRange = $objWorksheet.UsedRange 
[void] $objRange.EntireColumn.Autofit() 
$objWorkbook.SaveAs("$outputFilePath\Report.xlsx",51)
$objWorkbook.Saved = $True
$objExcel.Quit()



$fromaddress = "[email protected]" 
$toaddress = "[email protected]" 
$bccaddress = "" 
$CCaddress = "[email protected]"  
$Subject = "Here Is The Report" 
$body = get-content $emailFilePath\content.htm 
$attachment = "$outputFilePath\Report.xlsx"
$smtpserver = "smtpdomain" 
 

$message = new-object System.Net.Mail.MailMessage 
$message.From = $fromaddress 
$message.To.Add($toaddress) 
$message.CC.Add($CCaddress) 
#$message.Bcc.Add($bccaddress) 
$message.IsBodyHtml = $True 
$message.Subject = $Subject 
$attach = new-object Net.Mail.Attachment($attachment) 
$message.Attachments.Add($attach) 
$message.body = $body 
$smtp = new-object Net.Mail.SmtpClient($smtpserver) 
$smtp.Send($message) 
 
$dateTime2 = Get-Date -Format s
Write-Host "The file was parsed and emailed at $dateTime2"
Start-Sleep -Seconds 60
$message.Dispose()
Start-Sleep -Seconds 60
kill -processname Excel
Start-Sleep -Seconds 60
Remove-Item "C:\PATH\PATH\Send\*.*"
$filenameFormat = "Report" + "" + (Get-Date -Format "yyyy-MM-dd") + ".txt"
$updatedFile = "C:\PATH\PATH\Upload\" + $filenameFormat
Rename-Item -Path "C:\PATH\PATH\Upload\Report.txt" -NewName $filenameFormat
Move-Item -Path $updatedFile -Destination C:\PATH\PATH\ArchivedReportData

Stop-Transcript
exit

Test-Path should do the trick for you

Abraham Zinala
– Abraham Zinala

2021-01-20 23:22:13 +00:00
Commented Jan 20, 2021 at 23:22 — Abraham Zinala
– Abraham Zinala, Commented Jan 20, 2021 at 23:22

RetiredGeek · Accepted Answer · 2021-01-20 19:42:25Z

1

You need to test for the file before processing as follows:

If ( -not (Test-Path -Path "inputFile")) {

  #Write your file not found logic/messages here
  
  Exit 

}

Import-CSV $inputFile -Delimiter "`t" -Header "Value 1" , "Value 2" , "Value 3" , "Value 4" , "Value 5" | Tee-Object -Variable Report.txt | Export-CSV $OutputFile  -Delimiter "," -NoTypeInformation

$dateTime1 = Get-Date -Format s
Write-Host "The file was received: $dateTime1"
...

HTH

answered Jan 20, 2021 at 19:42

RetiredGeek

3,1881 gold badge11 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Need to append this powershell script, not sure what to do

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related