Windows Forum

Ask something
Discussion Locked

Moving files daily

0 helpful
13 replies

by whatnetever

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi everyone,

I need to move some daily files to its final destination (sorted by dates) every day. Is there any way to do it automatically? Right now I'm doing a batch file for every single day because the folder name is different. It's kind of hard because I have to do a batch file for each day of the month...

Thanks for your help.

Scotch

13 replies

by joseph moore

I should be able to write up a BAT file that will do this, but I need to know a few things first.
You have a folder for each day of the month, right? What are the folders named? 01, 02, 03, 04 etc???

Next, are the files that you are moving namedwith date-sensitive names, or are they static file names?

Please post an example of what you are doing, and I can write up a BAT file to do the whole thing, I hope!!!!

Probably.

by joseph moore

Hello. I am including my BAT file suggestion for you below. I tried it out on my XP machine while on the train last night. Worked just fine. I moved dozens of files into the correct locations all without a hitch. I also changed the date on my laptopto make sure that works also, and it did.
The only thing to keep in mind is that when it tries to make the directories, you will get an error if they already exist. "A subdirectory or file already exist". No biggie. It doesn't stop anything from working. You could just REM out the directory creation after you have all 31 numerical subfolders under the C:\CAMERA directory created, but it does no harm leaving it in. Other then that, it works like a champ.

by joseph moore

@echo off

REM ************************************
REM Camera archiving per date
REM This file will create a folder structure based on the day of the month
REM that this file is run. Under the C:\CAMERA folder there will be one subfolder
REM ranging from 1-31, representing the day of the month the camera images
REM were recorded. After that, folders for each camera are made. Lastly, the images
REM from each camera are moved from the FTP location to the appropriate camera
REM folder under the correct date. Then, during the following month, the previous
REM month's images are deleted before archival of the current day's images is done
REM to prevent keeping old images that are not needed
REM ************************************

cls

REM ************************************
REM Set environment variable to determine the current date
REM Used to create subfolders to organize files for each camera
REM ************************************
for /f "tokens=1-3 delims=/ " %%i in ('date /t') do set today=%%k

REM ************************************
REM Deletes last month's pictures
REM ************************************
del d:\cameras\%today%\cam1\*.* /q
del d:\cameras\%today%\cam2\*.* /q
del d:\cameras\%today%\cam3\*.* /q

REM ************************************
REM Create subfolders under C:\Camera folder for archival storage
REM One folder per camera, all under a 2-digit numbered folder representing the day
REM of the month the pictures were taken
REM ************************************
md d:\cameras\%today%\cam1
md d:\cameras\%today%\cam2
md d:\cameras\%today%\cam3

REM ************************************
REM Move pictures from FTP to the appropriate subfolder per camera
REM ************************************
move /y d:\ftp\cam1\*.* d:\cameras\%today%\cam1
move /y d:\ftp\cam2\*.* d:\cameras\%today%\cam2
move /y d:\ftp\cam3\*.* d:\cameras\%today%\cam3

by joseph moore

REM ************************************
:eof
REM ************************************

REM ************************************
REM File by Joseph Moore 04/02/2003
REM ************************************

EXIT

by whatnetever

Here is an example we did:

del d:\cameras\10\cam1\*.* /q
del d:\cameras\10\cam2\*.* /q
del d:\cameras\10\cam3\*.* /q
move /y d:\ftp\cam1\*.* d:\cameras\10\cam1\
move /y d:\ftp\cam2\*.* d:\cameras\10\cam2\
move /y d:\ftp\cam3\*.* d:\cameras\10\cam3\

The 'del' deletes the previous month's info. Then the 'move' moves the picture files from ftp folder to the permanent folder to keep for a month. These are files from the cameras in the office. The file names are dated like this: '2003040118312201' (I think it's year, month, date, hour, minute, second, and then something... The pictures are taken every 10 seconds). The permanent folders' names are from 1 (not 01) all the way to 31. Currently we're making a new script every day and put it in the scheduled task at the end of the day to move the files... Kind of time consuming.

I hope this helps. Please let me know if more info is needed. Thanks a million!

Scotch

by driv

Scotch,
Please list out what version of Windows you are using to COPY, since I have scripts that vary by version due to great little changes that occur and some programs that don't run in WinNT. I personally use an old 'dedicated' robot computer that runs Win98 (due to all the nice 'old' DOS programs that run still!).

by whatnetever

I modified the permanent folder names to two digits (so now it's 01 instead of 1). Also, the day setting on the computer is US settings, so today's date is: Wednesday, April 02, 2003. Hope this helps.

I am using Windows 2000.

Thanks!

by driv

Scotch,
Grab the below code and copy it into a .bat file and run. Should give the results desired. If you need help modifying the myday to strip off the 0 char let me know. Let me know if it works for you.

rem Adjust as needed, can use var in lines instead of setting to system var
rem below is your code slightly modified; use scheduler and have fun; should work on Win2000 no guarantees on others
rem note: I was assuming that camx was the day
rem note: the day is two digits, so the FTP dir must be two digits
rem note: if not modify the myday var to strip off the 0 char
rem
rem Get the Full Date
set mydate=%date:~-10%
rem Get the Month Only
set mymonth=%mydate:~0,-8%
set myday=%mydate:~3,-5%
rem
md d:\cameras\%mymonth%\cam%myday%
rem
del d:\cameras\%mymonth%\cam%myday%\*.* /q
rem
move /y d:\ftp\cam%myday%\*.* d:\cameras\%mymonth%\cam%myday%\

This discussion is closed to new replies.