You could try something like this:
$in = "C:\test\in\"
$out = "C:\test\out\"
$ffc_hf = "C:\test\hf\"
$filter = "*.pdf"
$fsw = New-Object IO.FileSystemWatcher $in, $filter -Property @{IncludeSubdirectories = $false}
$onCreated = Register-ObjectEvent $fsw Created -SourceIdentifier Created -Action {
$files = Get-ChildItem -Path $in -Recurse -File
$regex = '(\d+)'
foreach ($file in $files)
{
$ordernumber = ($file.Name -split $regex)[1]
$path = Test-Path "C:\test\out\$ordernumber.txt" -PathType Leaf
if (-not $path) {
Set-Content -Path "C:\test\out\$ordernumber.txt" -value "C:\test\out\$file;$ordernumber;1"
} else {
Add-Content -Path "C:\test\out\$ordernumber.txt" -value "C:\test\out\$file;$ordernumber;1"
}
Get-ChildItem -Path $in -Recurse -File | Move-Item -Destination $out
if ($file -like '*FINAL*') { Copy-Item -Path "C:\test\out\$ordernumber.txt" -Destination $ffc_hf}
}
}
Here is the idea:
A watched folder $in for pdf files is created. When a pdf arrives in the $in folder, a textfile for a specific order number is created (Set-Content) in the out folder if it is the first pdf with a specific order number. The text file will contain a link to the pdf, the order number and an id=1 (that could be used as GroupKey). If not (i.e. if a pdf file with a specific order number has already arrived) then a new line will be added (Add-Content) to the existing text file. The pdf files are then moved to the folder $out and if the pdf arriving contains "FINAL" then the textfile will be copied to the folder $ffc_hf. You would here need to change the $ffc_hf path to your FFCore hotfolder.
The result for your example copied to $ffc_hf would using your example would be three text files named by order number:
109051167.txt will contain:
C:\test\out\BOL_109051167_FINAL.pdf;109051167;1
109051168.txt will contain:
C:\test\out\BOL_109051168.pdf;109051168;1
C:\test\out\CTE_109051168_FINAL.pdf;109051168;1
109051169.txt will contain:
C:\test\out\CTE_109051169.pdf;109051169;1
C:\test\out\NFE_109051169.pdf;109051169;1
C:\test\out\BOL_109051169_FINAL.pdf;109051169;1
You then need to map the fields for the text files in the MAX Setup on the hotfolder in FFCore:
A=File name
B=OrderID
C=GroupKey
To run the attached script you can right click it and select Run with PowerShell, but the folder $in will only be watched as long as PowerShell stays open. To make the script run in the background you can for instance use Windows Task Scheduler and create a new basic task and in Actions select Start a program:
Program/script: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
For Arguments use something like:
NoExit -WindowStyle Hidden -noprofile -executionpolicy bypass -file C:\scripts\watchfolder_wait_create_max.ps1
