使用 FileSystemWatcher 在目录中拾取 2 个文件扩展名

使用 FileSystemWatcher 在目录中拾取 2 个文件扩展名

我只想获取 pdf 和 rtf 文件,但在回显变量时我得到了“true”的结果

$watcher = New-Object System.IO.FileSystemWatcher 
Write-Host "First line of the script, getting the watcher folder " $watcher -ForegroundColor white
$watcher.Path = "C:\Users\Demo Site"
Write-Host "This is the current path " $watcher.Path -ForegroundColor white
$watcher.Filter = "*.rtf" -or "*.pdf" 
Write-Host "Filtering by: " $watcher.Filter -ForegroundColor white
$watcher.IncludeSubdirectories = $true
Write-Host "Including Subdirectories" -ForegroundColor white
$watcher.EnableRaisingEvents = $true  

$action = {
    $path = $Event.SourceEventArgs.FullPath
    $path2 = $path.replace("C:\Users\", "")
    $path2 = $path2.replace("\","/")
    $changeType = $Event.SourceEventArgs.ChangeType
    $logline = "$(Get-Date -Format F) , File was $changeType in:  $path"
    $logFile = "D:\MoveLog.txt"

    Add-content -Path $logFile -value $logline  
    # moves the file captured by the watcher
    Start-Sleep -s 2
    Move-PnPFile -ServerRelativeUrl "/sites/1/$path2" 
        -TargetUrl "/sites/2" -OverwriteIfAlreadyExists 
        -Force -Confirm:$True 
        -ErrorAction SilentlyContinue -ErrorVariable ProcessError
    # added to make sure that the larger files finish uploading
    If ($ProcessError)
    {
        Write-Warning -Message "File not copied!"
        Write-Warning -Message "Waiting 5 seconds and trying again"
        Start-Sleep -s 5
        $logFile = "D:\MoveLog.txt"
        Add-content -Path $logFile -value " $(Get-Date -Format F),  Error while Copying file - Let's try this again!"
        Move-PnPFile -ServerRelativeUrl "/sites/1/$path2" 
            -TargetUrl "/sites/1/$path2" -Force -Confirm:$False 
            -ErrorAction SilentlyContinue -ErrorVariable ProcessError
        If ($ProcessError)
        {
            Write-Warning -Message "File not copied!"
            Write-Warning -Message $error[0].Exception.Message
            $errorLog = " $(Get-Date -Format F),  $error[0].Exception.Message"
            Write-Host  "12. Writing to Log" -ForegroundColor red
            $logFile = "D:\MoveLog.txt"
            Add-content -Path $logFile -value $errorLog
                $to_mail = ""
                $fr_mail = ""
                $subject = "An error has occured when moving in SharePoint"
                $serverDetails = ""
                $port = 
            Send-MailMessage -To $to_mail -From $fr_mail -Subject $subject -Body $errorLog 
                -Priority High -SmtpServer $serverDetails -Port $port
        }
        else
        {
            Write-Host  "n 8. After 1 error, Succesfully moved newly created file to different sharepoint library" -ForegroundColor green
        }
    }
    else
    {
        Write-Host  "n 8. Successfully moved newly created file to different sharepoint library with no errors" -ForegroundColor green
    }
}
### DECIDE WHICH EVENTS SHOULD BE WATCHED 
Register-ObjectEvent $watcher "Created" -Action $action
# Register-ObjectEvent $watcher "Changed" -Action $action
while($true){
    sleep 5
}

我怎样才能改变$watcher.Filter = "*.rtf" -or "*.pdf",只选择这 2 个文件?

当我选择所有文件扩展名时,.tmp 也会被选择,但是当我对它进行某些操作时,它会被删除,因此会产生 FAIL 消息。

我也尝试过dir .\* -include ('*.xsl', '*.xslt') -recurse

我没有收到错误,但是当我$watcher.Filter使用 2 个扩展回应时,我得到了true

答案1

经过几次错误后,我终于让它工作了,

我创建了这个脚本来在 SharePoint 库之间移动文件,以便文档不会占用服务器上的空间。

基本上:

  1. 文件通过 ERP 写入服务器上同步的 OneDrive 文件夹

  2. 被 FileSystemWatcher 接收

  3. 移至存档库,以便用户可以访问。

你会需要SharePointPnP

Connect-PnpOnline -Url https://site.sharepoint.com/sites/ -UseWebLogin
#disconects from Sharepoint
#disconnect-PnpOnline 

$logFile = "D:\SharePointMoveLog.txt"
#for debugging 
start-transcript

### SET FOLDER TO WATCH + FILES TO WATCH + SUBFOLDERS YES/NO
    $watcher = New-Object System.IO.FileSystemWatcher
Write-Host "First line of the script, getting the watcher folder " $watcher -ForegroundColor white
    $watcher.Path = "C:\Users\Demo Site - Staging"
Write-Host "This is the current path " $watcher.Path -ForegroundColor white
    $watcher.Filter = "*.*" 
Write-Host "Filtering by: " $watcher.Filter -ForegroundColor white
    $watcher.IncludeSubdirectories = $true
Write-Host "Including Subdirectories" -ForegroundColor white
    $watcher.EnableRaisingEvents = $true  

### DEFINE ACTIONS AFTER AN EVENT IS DETECTED

$action = 
    {
    $fileName = Split-Path $Event.SourceEventArgs.FullPath -leaf
Write-Host $fileName
        If ($fileName -like '*.pdf')
            {
                 $path = $Event.SourceEventArgs.FullPath
###PDF
                Write-Host "1. New File has been Created in: " $path -ForegroundColor green
                                $path2 = $path.replace("C:\Users\Demo Site - Staging\", "")
                Write-Host "`n 2. Removing the begining of directory from Path: " $path2 -ForegroundColor green
                                $path2 = $path2.replace("\","/")
                Write-Host "`n 3. Replacing \ with / in order to get file to copy to SP: " $path2 -ForegroundColor green
                                $changeType = $Event.SourceEventArgs.ChangeType
                Write-Host "`n 4. File was changed - Type: " $changeType -ForegroundColor green
                                $logline = "$(Get-Date -Format F) , `r`n File was $changeType in: `r`n $path"
                Write-Host "`n 5. Creating a line for the logs: " $logline -ForegroundColor green
                $logFile = "D:\SharePointMoveLog.txt"
                            Add-content -Path $logFile -value $logline  
                Write-Host "`n New line added to the log ${logline}"  -ForegroundColor green
                                #moves the file captured by the watcher
                Write-Host "`n 6. Waiting 2 seconds before moving to ensure file uploads succesfuly" -ForegroundColor green
                                Start-Sleep -s 2
                                Move-PnPFile -ServerRelativeUrl "/sites/test1/Staging/$path2" `
                                        -TargetUrl "/sites/test1/Archive/$path2" -OverwriteIfAlreadyExists `
                                        -Force -Confirm:$True `
                                        -ErrorAction SilentlyContinue -ErrorVariable ProcessError
                                        #added to make sure that the larger files finish uploading
                                    If ($ProcessError)
                                        {
                                            Write-Warning -Message "File not copied!"
                                            Write-Warning -Message "Waiting 5 seconds and trying again"
                                            Start-Sleep -s 5
                $logFile = "D:\SharePointMoveLog.txt"
                                            Add-content -Path $logFile -value "`r`n $(Get-Date -Format F), `r`n Error while Copying file - Let's try this again!"
                                            Move-PnPFile -ServerRelativeUrl "/sites/test1/Staging/$path2" `
                                        -TargetUrl "/sites/test1/Archive/$path2" -Force -Confirm:$False `
                                        -ErrorAction SilentlyContinue -ErrorVariable ProcessError
                                            If ($ProcessError)
                                                {
                                                    Write-Warning -Message "File not copied!"
                                                    Write-Warning -Message $error[0].Exception.Message
                                                    $errorLog = "`r`n $(Get-Date -Format F), `r`n $error[0].Exception.Message"
                                                    Write-Host  "12. Writing to Log" -ForegroundColor red
                $logFile = "D:\SharePointMoveLog.txt"
                                                    Add-content -Path $logFile -value $errorLog
                                                        $to_mail = ""
                                                        $fr_mail = ""
                                                        $subject = "An error has occured when moving in SharePoint Test Site"
                                                        $serverDetails = ""
                                                        $port = 
                                                    Send-MailMessage -To $to_mail -From $fr_mail -Subject $subject -Body $errorLog `
                                                                        -Priority High -SmtpServer $serverDetails -Port $port
                                                }
                                            else
                                                {
                        Write-Host  "`n 7. After 1 error, Succesfully moved newly created file to different sharepoint library" -ForegroundColor green
                                                    $logFile = "D:\SharePointMoveLog.txt"
                                                    Add-content -Path $logFile -value "`r`n $(Get-Date -Format F), `r`n After 1 error, Succesfully moved newly created file to different sharepoint library"
                                                }
                                        }
                                    else
                                        {
                Write-Host  "`n 7. Succesfully moved newly created file to different sharepoint library with no errors" -ForegroundColor green
                                            $logFile = "D:\SharePointMoveLog.txt"
                                            Add-content -Path $logFile -value "`r`n $(Get-Date -Format F), `r`n Succesfully moved newly created file to different sharepoint library with no errors"
                                        }
            }



        elseif ($fileName -like '*.rtf')
            {
###RTF

                $path = $Event.SourceEventArgs.FullPath
                Write-Host "1. New File has been Created in: " $path -ForegroundColor green
                                $path2 = $path.replace("C:\Users\Demo Site - Staging\", "")
                Write-Host "`n 2. Removing the begining of directory from Path: " $path2 -ForegroundColor green
                                $path2 = $path2.replace("\","/")
                Write-Host "`n 3. Replacing \ with / in order to get file to copy to SP: " $path2 -ForegroundColor green
                                $changeType = $Event.SourceEventArgs.ChangeType
                Write-Host "`n 4. File was changed - Type: " $changeType -ForegroundColor green
                                $logline = "$(Get-Date -Format F) , `r`n File was $changeType in: `r`n $path"
                Write-Host "`n 5. Creating a line for the logs: " $logline -ForegroundColor green
                $logFile = "D:\SharePointMoveLog.txt"
                            Add-content -Path $logFile -value $logline  
                Write-Host "`n New line added to the log ${logline}"  -ForegroundColor green
                                #moves the file captured by the watcher
                Write-Host "`n 6. Waiting 2 seconds before moving to ensure file uploads succesfuly" -ForegroundColor green
                                Start-Sleep -s 2
                                Move-PnPFile -ServerRelativeUrl "/sites/test1/Staging/$path2" `
                                        -TargetUrl "/sites/test1/Archive/$path2" -OverwriteIfAlreadyExists `
                                        -Force -Confirm:$True `
                                        -ErrorAction SilentlyContinue -ErrorVariable ProcessError
                                        #added to make sure that the larger files finish uploading
                                    If ($ProcessError)
                                        {
                                            Write-Warning -Message "File not copied!"
                                            Write-Warning -Message "Waiting 5 seconds and trying again"
                                            Start-Sleep -s 5
                $logFile = "D:\ManagementGateway\SharePointLogs\USA\SharePointMoveLog.txt"
                                            Add-content -Path $logFile -value "`r`n $(Get-Date -Format F), `r`n Error while Copying file - Let's try this again!"
                                            Move-PnPFile -ServerRelativeUrl "/sites/test1/Staging/$path2" `
                                        -TargetUrl "/sites/test1/Archive/$path2" -Force -Confirm:$False `
                                        -ErrorAction SilentlyContinue -ErrorVariable ProcessError
                                            If ($ProcessError)
                                                {
                                                    Write-Warning -Message "File not copied!"
                                                    Write-Warning -Message $error[0].Exception.Message
                                                    $errorLog = "`r`n $(Get-Date -Format F), `r`n $error[0].Exception.Message"
                                                    Write-Host  "12. Writing to Log" -ForegroundColor red
                $logFile = "D:\SharePointMoveLog.txt"
                                                    Add-content -Path $logFile -value $errorLog
                                                        $to_mail = ""
                                                        $fr_mail = ""
                                                        $subject = "An error has occured when moving in SharePoint"
                                                        $serverDetails = ""
                                                        $port = 
                                                    Send-MailMessage -To $to_mail -From $fr_mail -Subject $subject -Body $errorLog `
                                                                        -Priority High -SmtpServer $serverDetails -Port $port
                                                }
                                            else
                                                {
                        Write-Host  "`n 7. After 1 error, Succesfully moved newly created file to different sharepoint library" -ForegroundColor green
                                                    $logFile = "D:\SharePointMoveLog.txt"
                                                    Add-content -Path $logFile -value "`r`n $(Get-Date -Format F), `r`n After 1 error, Succesfully moved newly created file to different sharepoint library"
                                                }
                                        }
                                    else
                                        {
                Write-Host  "`n 7. Succesfully moved newly created file to different sharepoint library with no errors" -ForegroundColor green
                                            $logFile = "D:\SharePointMoveLog.txt"
                                            Add-content -Path $logFile -value "`r`n $(Get-Date -Format F), `r`n Succesfully moved newly created file to different sharepoint library with no errors"
                                        }
            }
    }
### DECIDE WHICH EVENTS SHOULD BE WATCHED 
    Register-ObjectEvent $watcher "Created" -Action $action
#    Register-ObjectEvent $watcher "Changed" -Action $action
    while ($true) {sleep 5}

目前,有一个有时会发生的小错误,我只看到它在 RTF 上失败,出现一个错误:

Server relative urls must start with SPWeb.ServerRelativeUrl Cannot open "Doc12345.rtf": no such file or folder.

我不清楚为什么会发生此错误,因为当我手动放入文件时它就可以正常工作。

我之前遇到过类似的错误,但这是由于 SharePoint 库中的文件夹结构不同造成的,确保它们完全相同就可以解决这个问题。

相关内容