Solved

Sample batch file to create daily folder folder for archiving (and move file into the archive folder)

Posted on 2010-08-30
5
1,048 Views
Last Modified: 2012-06-27
Everyday our server recieves several files in a inbound folder. The next daythe files are overwritten as they have the same names.

Is there a sample batch file where I can add to a daily 6am scheduled task to create a new daily folder by YYYYMMDD and move al the file into the new folder?

e.g. inbound folder c:\inbound\
location for archive folder - c:\archive\<YYYYMMDD>
Action - (1) create new daily folder YYYYMMDD in c:\archive\ , (2) move c:\inbound\*.* to c:\achive\YYYYMMDD

This batch file / scheuled task will run on a Windows 2008 server.

Thanks.
Joo
0
Comment
Question by:sidartra
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 11

Accepted Solution

by:
slemmesmi earned 250 total points
ID: 33564723
Dear sidarta,

since you will be running this on Windows Server 2008. I propose to use a PowerShell script and run this as a scheduled task.
The script could simply contain:
----
$InboundFiles = "C:\inbound\*.*"
$TodaysDate = get-date -uform "%Y%m%d"
$NewArchiveFolder = "C:\archive\$TodaysDate"
echo $NewArchiveFolder
md $NewArchiveFolder
mv $InboundFiles $NewArchiveFolder
----

Please let me know if you need any further assistance with this.

Kind regards,
Soren
0
 
LVL 1

Assisted Solution

by:finart
finart earned 125 total points
ID: 33564777
Hello,
you could create a file named mytask.cmd containing the following instructions:

@ECHO OFF
FOR /F "usebackq tokens=2,3,4 delims=/ " %%A IN (`date /T`) DO SET X=%%C%%A%%B
echo %X%
mkdir c:\ARCHIVE\%X%
move c:\inbound\*.* to c:\achive\%X% /Y

then, plan a stask with the task scheduler that launches the mytask.cmd
0
 

Assisted Solution

by:jablonovo
jablonovo earned 125 total points
ID: 33564856
In windows there is a task scheduler.

1. Create your script.
2. add the script in task scheduler where you can give the details of when you want to task (script) to run. I suggest you use the task scheduler wizard. After the wizard is completed


Here is how to add a date to a folder

http://dev-notes.com/code.php?q=49 

all your command should be in a text file that you save with .cmd extension

hope this helps
0
 
LVL 11

Assisted Solution

by:slemmesmi
slemmesmi earned 250 total points
ID: 33564940
Dear guys,

please beware that when you rely on the "date" command and delimiters, this is influenced by the "short date" format (regional setting) of the system.
The PowerShell script is not.

Kind regards,
Soren
0
 

Author Closing Comment

by:sidartra
ID: 33564960
Siemmesmi, you are correct, the powershell script is not affected by the short date format. Thanks.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
An article on effective troubleshooting
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question