Delete files in destination that are not in source

[lgt]

I have the following batch file that works. What I'm trying to do now is to delete files in the Documents folder that are not in the source folder. I can't seem to be able to do it. I tried robocopy with the mir option but it is not working. I'm hoping somebody will be able to help. Thanks.

Code: Select all

@echo

For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%c-%%a-%%b)
For /f "tokens=1-2 delims=/:" %%a in ('time /t') do (set mytime=%%a%%b)

set logfile=C:\backup_log_file_"%mydate%_%mytime%".txt

set DevPotableWaterProjects=C:\Public Services New\DevPotable Water Projects

echo %Date% %Time% # # # Moving files >> %logfile%

for /r "%DevPotableWaterProjects%" %%a in ("*MTR*","*SWR*","*Plan Review*") do (
   for %%b in ("%%~dpa\.") do (
      echo processing "%%a" >> %logfile%
      md "C:\Developer\%%~nxb\Documents" >> %logfile%
      md "C:\Developer\%%~nxb\Attachments" >> %logfile%
xcopy "%%a" "C:\Developer\%%~nxb\Documents" /s /d /y
)
)

echo %Date% %Time% # # Moving Complete! >> %logfile%

[ShadowThief]

I haven't tried running this yet, but just at an initial glance, you should try changing the line

Code: Select all

set DevPotableWaterProjects=C:\Public Services New\DevPotable Water Projects

to

Code: Select all

set "DevPotableWaterProjects=C:\Public Services New\DevPotable Water Projects"

because the spaces in the target path name are breaking things.

[foxidrive]

I tried robocopy with the mir option but it is not working.

Is a mirror backup what you wanted in the first place?
Robocopy is the best tool for that... it only copies/removes what is necessary.

Try this on two test folders - it also nuls the retry and timeout features, which is suitable for a plain data backup on local drives.

Code: Select all

@echo off
set "datafolder=c:\files"
set "backupfolder=d:\archive\backup"

set switches=/r:0 /w:0 /mir

robocopy %switches% "%datafolder%" "%backupfolder%"
pause

[lgt]

Your code worked when run as is but the problem I'm having is incorporating robocopy into my batch file, it's not working for me. I need a way to delete files that are no longer in the source folder while keeping the logic of my current script. I managed a workaround by first deleting the folder and then copying the files again but I was hoping for a cleaner way to do it. Thank you!

[foxidrive]

Your code worked when run as is but the problem I'm having is incorporating robocopy into my batch file, it's not working for me.

Can you explain which part you are having trouble with, the error messages, what is failing, etc?
There may be easy modifications to make it suit your code.

[lgt]

This is my folder structure:

Project Folder
-Documents
-Attachments

I have many project folders in the same directory. I need to be able to go through each folder and delete anything in the "Documents" folder that is not in the source folder. I only need to do this for the "Documents" folder and not for the "Attachments" folder. I'm having trouble using robocopy to loop through each folder and do this.

I hope this makes sense.

[foxidrive]

This is my folder structure:

Project Folder
-Documents
-Attachments

I have many project folders in the same directory. I need to be able to go through each folder and delete anything in the "Documents" folder that is not in the source folder. I only need to do this for the "Documents" folder and not for the "Attachments" folder. I'm having trouble using robocopy to loop through each folder and do this.

I hope this makes sense.

You can exclude the attachments folder using this in robocopy /xd "attachments"

[lgt]

I'm trying to run this but I'm getting Error 267, "The directory name is invalid".

Code: Select all

set "DevPotableWaterProjects=\\owd-fp1\facilitybook\Projects\Leonel\infraMAP\Inspection\Public Services New\DevPotable Water Projects"

for /r "%DevPotableWaterProjects%" %%a in ("*MTR*","*SWR*","*Plan Review*") do (
   for %%b in ("%%~dpa\.") do (
echo processing "%%a
robocopy /mir "%%a" "\\owd-fp1\facilitybook\Projects\Leonel\infraMAP\Inspection\Temp\iWater Inspection Attachments\Developer\%%~nxb\Documents" >> %logfile%
)
)

[foxidrive]

Place echo on the same line before the robocopy command and you will see what is being used in the command line.

Didn't you like the idea of excluding the attachments folder?

[lgt]

It's not that I didn't like your idea of excluding the attachments folder it's that I'm not sure how to incorporate it into my current batch file.