Fabio,
não, não consigo mover o arquivo quando o powershell é executado pelo prompt do DOS e está no loop de "false"
Segue o principal do codigo, pois é meio grande devido aos tratamentos dos dados da planilha.
Function Process-Files
{
$items = dir $location -filter $filter
if($items -eq $null) {
Write-Log "No items to process at the time"
$script:dbConn.close()
exit
}
# clear stage tables
foreach($it in $script:stageTable) {
Clear-Stage-Table $it
}
$backupFile = $true
$backupItens = $true
foreach($it in $items)
{
$script:filexl = $location + "\" + $it
Write-Log $(Get-Date) + " ------------------------------------------------------------------------"
Write-Log "Processing file $script:filexl"
try
{
# Loop for spreadsheets
$stg = 0
foreach($sheet in $spreadsheets)
{
if($sheet -eq $null) {
break;
}
# Retrieve data
try {
$data = Get-ACEData -FilePath $script:filexl -Worksheet $($sheet+ "$")
} catch {
Write-Host "It was not possible to retrieve the data from Excel spreadsheet. Impossible to continue."
Write-Log "It was not possible to retrieve the data from Excel spreadsheet. Impossible to continue."
Write-Log $_
#exit
# entra aqui devido a aba da planilha estar com nome diferente do definido
$backupItens = $false
}
if ($backupItens -eq $true)
{
........
} else {
$backupItens = $true
$backupFile = $false
continue
}
#apos o continue entra neste ponto
# Moves the file
$filename = Backup-Excel $script:filexl
Esta é a função que move o arquivo Excel
function Backup-Error-Excel
{
param($file)
$filename = $(split-path -leaf $file).split(".")[0]
$extension = $(split-path -leaf $file).split(".")[1]
$newFile = $script:ErrorLocation + "\" + $filename + "-" + $(get-date -f "yyyyMMddhhmm") + "." + $extension
if(test-path $newFile) {
Remove-Item -Force $newFile
}
$fileStatus = $false
while ($fileStatus -eq $false)
{
$fileStatus = checkFileStatus $file
$fileStatus
}
Move-Item $file $newFile -force
#Return
$newFile
}
E esta é a função que verifica se o arquivo esta aberto:
function checkFileStatus($filePath)
{
try {
$sw = new-object system.io.streamwriter $filePath
$sw.close()
return $true
}
catch
{
Write-Host "teste false"
return $false
}
}
Obrigado
