To Compress files using gzip utility

[vsmeruga]

Dear gurus

I am new to windows batch scripting and struggling to achieve a task.
I have to create a script - to compress files particular files older than 90 days in its directory and corresponding sub directories
(Note: Compressed file should stay on the same directory or sub directory)

I have written a script with the help of google and this is not solving the purpose now.
It tries to delete all the files older than 90 days first and compresses the remaining later on.
** Now I should not delete them but just compress them . Is it possible to modify the below script

Code: Select all

@setlocal enabledelayedexpansion
@echo off

REM Setting root path and changing the directory to it

set ArPathname=D:\Data
pushd %ArPathname%
echo %ArPathname%

REM Deletes the files older than 90 days which matches the search criteria

forfiles -p %ArPathname% -s -m *2012*.txt -d -90 -c "cmd /c del @path"
forfiles -p %ArPathname% -s -m *201302*.csv -d -90 -c "cmd /c del @path"

echo after 90 days delete 

REM Compresses the files using gzip which are less than 90 days old in the same folder
path=%path%;"D:\Data\Test"
for /f %%a in ('dir /s /b *2012*.txt *201302*.csv') do if not exist %%a.gz echo %%a | gzip %%a
echo after gzip

goto :eof

Can you please help me on this.
Many Thanks
Sheku

[foxidrive]

If your gzip command is correct then this may work for you.

Code: Select all

@echo off
pushd "d:\data" || goto :EOF
for /f "delims=" %%a in ('dir /s /b /a-d *2012*.txt *201302*.csv') do if not exist "%%a.gz" echo "%%a" & gzip "%%a"
popd
pause

[vsmeruga]

Getting the error message as below:

"D:\Data\20120219_file.txt"
'gzip' is not recognized as an internal or external command,

Code: Select all

@echo off
pushd "D:\Data" || goto :EOF
for /f "delims=" %%a in ('dir /s /b /a-d *2012*.txt *201302*.csv') do if not exist "%%a.gz" echo "%%a" & gzip "%%a"
popd
pause

[vsmeruga]

Hi foxidrive

are we not specifying this 90 days criteria in the command?. which is the main issue.
Thanks
VJ

[foxidrive]

If you don't have gzip then you aren't going to .gz anything.

I was confused with your question, you said one thing and then said it changed and the task was different and you should just compress them.

[vsmeruga]

Hi foxidrive
The below piece of code compress the files perfectly. But the issue is I am not able to set the criteria(only to compress files older than 90 days to it.)
I hope my question is clear to you now.
Thanks
VJ

Code: Select all

REM Compresses the files using gzip which are less than 90 days old in the same folder
path=%path%;"D:\Data\Test"
for /f %%a in ('dir /s /b *2012*.txt *201302*.csv') do if not exist %%a.gz echo %%a | gzip %%a
echo after gzip

[foxidrive]

Test this on some sample files: if your gzip command is right then it should work

Code: Select all

@echo off
setlocal enabledelayedexpansion

REM Setting root path and changing the directory to it

set ArPathname=D:\Data
pushd %ArPathname%
echo %ArPathname%

:: get the date 90 days ago
@echo off
set day=-90
echo >"%temp%\%~n0.vbs" s=DateAdd("d",%day%,now) : d=weekday(s)
echo>>"%temp%\%~n0.vbs" WScript.Echo year(s)^& right(100+month(s),2)^& right(100+day(s),2)
for /f %%a in ('cscript /nologo "%temp%\%~n0.vbs"') do set "result=%%a"
del "%temp%\%~n0.vbs"
set "YYYY=%result:~0,4%"
set "MM=%result:~4,2%"
set "DD=%result:~6,2%"
set "data=%dd%/%mm%/%yyyy%"

forfiles -p %ArPathname% -s -m *2012*.txt -d %data%  -c "cmd /c echo @path" >"file.tmp"
forfiles -p %ArPathname% -s -m *201302*.csv -d %data% -c "cmd /c echo @path" >>"file.tmp"

REM Compresses the files using gzip which are less than 90 days old in the same folder
path=%path%;"D:\Data\Test"
for /f "delims=" %%a in (file.tmp) do if not exist "%%~dpnxa.gz" echo "%%~dpnxa"|gzip "%%~dpnxa"
echo after gzip
del file.tmp
goto :eof

[vsmeruga]

Sure Thanks.

[vsmeruga]

Output of the script:
============
days are 07/03/2014
ERROR: No files found with the specified search criteria.
ERROR: No files found with the specified search criteria.
after temp file logic
after gzip
-- output of %data% is coming as date: 07/03/2014

[vsmeruga]

And the actual file modified date in the folder are "2/5/2013 11:00 AM". It means this file is older than 90 days right!

[vsmeruga]

I REPLACED %data% with -90 and seems to be working.

Thanks
VJ

[vsmeruga]

Many Thanks foxidrive - for your time and effort on this issue.
VJ

[foxidrive]

That was my mistake. I had the wrong end of the stick again and was using files that were less than 90 days old.