asked on
Nightly process produces file name that needs to be moved and renamed. Is this possible?
I have scheduled an export to run daily. The directory to where the export is scheduled to be run is hard coded and cannot be changed. Is it possible to schedule another process to pick up the export and dump it into another folder where I have another program that needs to call it?
The export is running to: \\server1\GVP96\Downloads with a file name of: BER1004_86204_EESETUP_SCHE
The program that needs to pick it up looks in another directory on another server.
The export is running to: \\server1\GVP96\Downloads with a file name of: BER1004_86204_EESETUP_SCHE
The program that needs to pick it up looks in another directory on another server.
Windows Server 2003Active DirectoryNetworking
Last Comment
bergquistcompany
Just schedule a simple one line batch file.
xcopy \\server1\GVP96\Downloads\
This will move all files with that name to the destination folder. Save that one line as a batch file and schedule it to run after the export will finish.
xcopy \\server1\GVP96\Downloads\
This will move all files with that name to the destination folder. Save that one line as a batch file and schedule it to run after the export will finish.
ASKER
@washburnma this will be perfect, but one question is can the file BER1004... be renamed to import.txt on the destination side as that is the file name the software looks for to pick up?
My script above would provide that flexibility with one extra line but it seems you don't want to go that route.
ASKER
@becraig
I'd love to try it, can you help me with the added line for taking the .txt file and renaming to user.csv? Then can I use schedule task to run this script daily?
I'd love to try it, can you help me with the added line for taking the .txt file and renaming to user.csv? Then can I use schedule task to run this script daily?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
awesome
Here is an idea.
$FileList = Get-ChildItem \\server1\GVP96\Downloads -recurse | Where-Object {$_.PSIsContainer -eq $True}
ForEach ($FileObj in $FileList) {
if ($fileobj.Name -like ("*20121227*")
{
$fullpath = $FileObj.FullName
$sourcefolder = "\\server1\GVP96\Downloads
$destFolder = "path you want to copy files to"
$copypath = ($fullpath -replace [regex]::Escape($SourceFol
$destpath = $DestFolder + $copypath
write-host "processing $fullpath" -fore green
Copy-Item $fullpath $destpath
}