File Replication

  • ljramos
  • Newbie
  • Newbie
  • ljramos
  • Posts: 7
  • Loc: Dover ,DE

Post 3+ Months Ago

Hi all ....

I have this issue to resolve and looking for suggestions.
I have an app. that stores files in a pre-defined directory structure. Files can be .pdf, .tiff etc. I need to copy all the latest files from all the pre-defined directories into a single common directory. Example

Dir1/folder1/files *.*
Dir1/folder2/files *.*
etc ...

copy all the files *.* which stamp date is > than sysdate
into
Dir2/ files *.*

Also this needs to be schedule on a regular pattern
  • Ragnar78
  • Proficient
  • Proficient
  • Ragnar78
  • Posts: 279

Post 3+ Months Ago

It can be done with an Excel macro....
But how would you have files with time stamps > then the sysdate?

As for Excel...you can then use the Scheduled Task on your PC, to launch the Excel file, and will automaticly copy all the files that have a certain date to another folder...
  • ljramos
  • Newbie
  • Newbie
  • ljramos
  • Posts: 7
  • Loc: Dover ,DE

Post 3+ Months Ago

Ok This is the deal.
I will have two or more users creating docs, either by scanning or creating the docs. Tha 3rd party app wil store the resulting files in a network shared drive using its own dierctory schema that cannot be modified. I then need to copy all the files i.e. taht were created since the last replication to a common directory on the same server so the users from a remote location can retrieve the files w/o the need to look in all the directories/subdirectories for new files. The remote location will ftp into the server and just sort the root directory by date and pull the latest files from the server.

Dont understand how excel will help me acomplish this so let see?
  • Ragnar78
  • Proficient
  • Proficient
  • Ragnar78
  • Posts: 279

Post 3+ Months Ago

Well actually its the VBA in excel that can do it.
What you have to do is set the correc API to retreive (through EXCEL VBA) all the files that have been recently accessed and then copy them directly to the location over the net
And you can customize excel in a way that it becomes a user intreface...for example set in a cell the name of the directory where file should be retreived (and the macro will check their all the accessed files) and another directry were the files will be copied to....
  • ljramos
  • Newbie
  • Newbie
  • ljramos
  • Posts: 7
  • Loc: Dover ,DE

Post 3+ Months Ago

I have never worked with excels macro. Can you give an exmaple?

Post Information

  • Total Posts in this topic: 5 posts
  • Users browsing this forum: No registered users and 67 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.