Help creating a program to copy data from last 24 hours

[lopiop]

Hi all, newbie here, I need help to create a batch file that will copy data (log files) from one folder to another from the last 24 hours to the current time the batch file was run/open.

Previously, I have used this code and it worked, however this code is deficient as it only copy the log files based on the current date.
Lets say if somebody is seeking for data from the last 24 hours, and he/she runs the program on 24 Jan, 12.01 am, thus all the data from the previous day wont be copied.

Below is the code I have used previously.

Code: Select all

for /F "tokens=1* delims= " %%A in ('DATE/T') do set SYSDATE=%%B
set DATE_YYYY=%SYSDATE:~6,4%
set DATE_MM=%SYSDATE:~3,2%
set DATE_DD=%SYSDATE:~0,2%
set DATE_MM_DD_YYYY=%DATE_MM%-%DATE_DD%-%DATE_YYYY%
echo %DATE_MM_DD_YYYY%
xcopy "w:\documents\*.doc" c:\dest /E /Y /D:%DATE_MM_DD_YYYY%

[Squashman]

If you can use third party programs, XXcopy has relative time options. You can do minutes and hours with it.

[foxidrive]

I played with Powershell a while back - here's a script that will list the files from the last 24 hours.

Some configuration of Powershell may be needed if it complains.

Code: Select all

@echo off
:: lists files in the last 24 hours

set "file=%temp%\psdaterange.ps1"

cd /d "d:\folder\logs"

(
echo( $date1 = Get-Date
echo( $date2 = $date1.addhours(-24^)
echo( 
echo( foreach( $item in (Get-ChildItem -file ^) ^)
echo( {
echo( if( $item.LastWriteTime -ge $date2 -and $item.LastWriteTime -le $date1 ^) {Write-Host $item}
echo( }
) >"%file%"

for /f "delims=" %%a in ('powershell "%file%"') do echo "%cd%\%%a"
del "%file%"

pause

[lopiop]

@foxidrive what should I do after listing the files?
does this work with xp?
sorry really a noob in this

[foxidrive]

Does your XP have Powershell installed?
Test this change to see if it works.

Tell me if there is an error message


Change this:

Code: Select all

) do echo "%cd%\%%a"

to this

Code: Select all

) do echo "%cd%\%%a" & xcopy "%cd%\%%a" "d:\dest\"

[lopiop]

@foxidrive hi, thx for the reply, i tried the script on my laptop, not on my company pc, and the script didnt work, at the first line it said
C:\Test\data\Get child item: A parameter cannot be found that matches parameter name 'file'

Code: Select all

@echo off
:: lists files in the last 24 hours

set "file=%temp%\psdaterange.ps1"

cd /d "C:\Test\data"

(
echo( $date1 = Get-Date
echo( $date2 = $date1.addhours(-24^)
echo( 
echo( foreach( $item in (Get-ChildItem -file ^) ^)
echo( {
echo( if( $item.LastWriteTime -ge $date2 -and $item.LastWriteTime -le $date1 ^) {Write-Host $item}
echo( }
) >"%file%"

for /f "delims=" %%a in ('powershell "%file%"') do echo "%cd%\%%a" & xcopy "%cd%\%%a" "C:\Test\transfer"
del "%file%"

pause

[foxidrive]

It fails in XP powershell here too.

Which OS does your company machine use?

[lopiop]

It fails in XP powershell here too.

Which OS does your company machine use?

windows xp, im trying it out on my windows 7 laptop right now, any idea how to fix this?

[Squashman]

If you can use third party programs, XXcopy has relative time options. You can do minutes and hours with it.

Since you did not comment about my suggestion I assume this means no?

[lopiop]

If you can use third party programs, XXcopy has relative time options. You can do minutes and hours with it.

Since you did not comment about my suggestion I assume this means no?

Hi, thx for the suggestion, preferably i would want to use a batch file, as I cant access the web through the company pc. could you elaborate on how to use the program? thx

[Squashman]

XXcopy is no different then using xcopy in a batch file.
Read the section about relative time specifiers. Shows a perfect example for you.
http://www.xxcopy.com/xxcopy17.htm

[foxidrive]

It fails in XP powershell here too.

Which OS does your company machine use?

windows xp, im trying it out on my windows 7 laptop right now, any idea how to fix this?

No, I'm not very experienced in Powershell, and the differences as it was upgraded.

[Samir]

I like xxcopy for things like this. Being able to use it on various OSs without modification of the batch is nice too.

[Squashman]

I like xxcopy for things like this. Being able to use it on various OSs without modification of the batch is nice too.

Well you could do this without any third party utilities but in this case it is the perfect tool for the job.

You could use a function to convert the current date and the files last modified time to the number of hours since a specified date then do the subtraction. There are all kinds of native batch functions for date and time conversions.

Dave's hybrid GetTimeStamp.bat could easily do the conversion to hours as well.