Notes:
- Not suitable for folder with sub-folders, such as folder of extracted zip file
- Recommended to execute on a test environment first
Steps:
- Change the $files and $targetPath values accordingly
- Copy the modified script and paste into Windows PowerShell
- Wait
The script:
# Get the files which should be moved, without folders
$files = Get-ChildItem 'CHANGE THIS TO ORIGINAL PATH' -Recurse | where {!$_.PsIsContainer}
# List Files which will be moved
$files
# Target folder where files should be moved to. The script will automatically create a folder for the year and month.
$targetPath = 'CHANGE THIS TO TARGET PATH'
foreach ($file in $files)
{
# Get year and Month of the file
# I used LastWriteTime since this are synced files and the creation day will be the date when it was synced
$year = $file.LastWriteTime.Year.ToString()
$month = $file.LastWriteTime.Month.ToString()
# Out FileName, year and month
$file.Name
$year
$month
# Set Directory Path
$Directory = $targetPath + "\" + $year + "\" + $month
# Create directory if it doesn't exsist
if (!(Test-Path $Directory))
{
New-Item $directory -type directory
}
# Move File to new location
$file | Move-Item -Destination $Directory
}
Screenshots:
[caption id="attachment_5100" align="aligncenter" width="646"] Before (what a mess!)[/caption]
[caption id="attachment_5104" align="aligncenter" width="702"] After[/caption]
Source:
http://www.thomasmaurer.ch/2015/03/move-files-to-folder-sorted-by-year-and-month-with-powershell/
No comments:
Post a Comment