Detecting csv files in newly sub-folder in PowerShell

Question

I have a folder called C:\2014-15 and new sub folders are created every month which contain csv files i.e

C:\2014-15\Month 1\LTC
C:\2014-15\Month 2\LTC
C:\2014-15\Month 3\LTC

How to write a script which would detect when a LTC sub folder is created for every month and move the csv files to N:\Test?

UPDATED:

$folder = 'C:\2014-15'
$filter = '*.*'
$destination = 'N:Test\'
$fsw = New-Object IO.FileSystemWatcher $folder, $filter -Property @{
IncludeSubdirectories = $true 
NotifyFilter = [IO.NotifyFilters]'FileName, LastWrite'
}
$onCreated = Register-ObjectEvent $fsw Created -SourceIdentifier FileCreated -Action {
$path = $Event.SourceEventArgs.FullPath
$name = $Event.SourceEventArgs.Name
$changeType = $Event.SourceEventArgs.ChangeType
$timeStamp = $Event.TimeGenerated
Write-Host
Copy-Item -Path $path -Destination $destination 
}

The error I get is:

Register-ObjectEvent : Cannot subscribe to event. A subscriber with source identifier 'FileCreated' already exists. At line:8 char:34 + $onCreated = Register-ObjectEvent <<<< $fsw Created -SourceIdentifier FileCreated -Action { + CategoryInfo : InvalidArgument: (System.IO.FileSystemWatcher:FileSystemWatcher) [Register-ObjectEvent], ArgumentException + FullyQualifiedErrorId : SUBSCRIBER_EXISTS,Microsoft.PowerShell.Commands.RegisterObjectEventCommand

Hi. I don't have any code which works at all. I have used FileSystemWatcher and move-item. — Djbril
Please explain what you've tried and why it doesn't work (error messages?) If the folders are moved elsewhere then it seems you move a folder as soon as it exists, as the folder should usually be empty. — Nick.McDermaid
The error has occurred because you are testing, having already run Register-ObjectEvent. Would it be easier if your script was run monthly, and creates the /Month x/LTC directories as well as moving the log files? — xXhRQ8sD2L7Z

xXhRQ8sD2L7Z xXhRQ8sD2L7Z · Accepted Answer · 2014-12-08T04:13:01

Credit to this post.

Notify on a different event: [IO.NotifyFilters]'DirectoryName'. This removes the need for $filter since filename events are not relevant.

You should also notify for renamed folders and created folders, making your final script something like this

$folder = 'C:\2014-15'
$destination = 'N:\Test'

$fsw = New-Object System.IO.FileSystemWatcher $folder -Property @{
   IncludeSubdirectories = $true
   NotifyFilter = [IO.NotifyFilters]'DirectoryName'
}

$created = Register-ObjectEvent $fsw -EventName Created -Action {
   $item = Get-Item $eventArgs.FullPath
   If ($item.Name -ilike "LTC") {
      # do stuff:
      Copy-Item -Path $folder -Destination $destination
   }
}

$renamed = Register-ObjectEvent $fsw -EventName Renamed -Action {
   $item = Get-Item $eventArgs.FullPath
   If ($item.Name -ilike "LTC") {
      # do stuff:
      Copy-Item -Path $folder -Destination $destination 
   }
}

From the same console you can unregister since that console knows about $created and $renamed:

Unregister-Event $created.Id
Unregister-Event $renamed.Id

Otherwise you need to use this which is bit uglier:

Unregister-Event -SourceIdentifier Created -Force
Unregister-Event -SourceIdentifier Renamed -Force

Also, thanks for the question. I didn't realise these event captures existed in powershell until now...

Detecting csv files in newly sub-folder in PowerShell

1 Answers