Batch create folders based upon spreadsheet then move/copy associated files to folders, how?
Posted on 2003-11-21
Its amazing to us that no basic tool exists to create folders and copy files to folders based upon an association db. Administration of document and image files seems still be in the "paper filing age" as we have no batch admin to create folders, and copy files to folders based upon a known list containing all of the needed data. Up until now its been a manual process... and it sucks.
We need to batch create folders based upon list in spreadsheet columns b-n, no dups and then move files associated in column A to those folders. Thousands of files added daily to folders. New spreadsheets provided everyday. Corrections discovered as files(images) reviewed over time... need for backout by date and re-apply to put in corrections. Master spreadsheet to track needed corrections to folder file associations.
We find ourselves creating 1000 to 2500 folders per week in windows. Looking at a spreadsheet that has the numerical sequence of images 2000 - 10,000 images in column A looking at the participants the images were taken of in columns B-N and copying manually all of the images manually to their specific folders. This is a ton of work(hours) and in our opinion absolutely insane to not have automated the create and move process as well as apply corrections in batch.
The human error in doing this manually increases as the days and weeks go on. We need to automate this badly. We've found nothing that does this. Only commands, Jscript that addresses a single create or move.
More detail and rehash: I have a spreadsheet I get from a photographer in column A is his alpha/numeric image range could be 2-10 thousand images... in columns b-n are the numbers of the participants in the photos (who he has taken the images of)... this could be a single individual (most of the time) but it could also be a pair or a group of people. Note all images are always in sequence... Creating Column A is a no brainer, entering in all of the participants is data entry that has to be done. Say the photographer is taking pics knows he is starting with image 2130 identifies the participant number as 1767 puts that in colmn b next to image # 2130 in column a and takes 12 images he has the next available starting image as 2142 enters the next participant in column B next to 2142 and so on. We see then that we can assume the range of images belonging to each rider is from the starting image in sequence until the next participant appears in Column B which is the next associated range.
Folders would be created for each participant as needed... the range of images contained in an "all" images folder belonging to a specific participant(s) would then be copied to a specific participant folder.
The photographers helpers supply the list/spreadsheet at the end of each day then we create the folders and copy the photos to those folders as quickly as we can get them there so we can lookup and display images for the participants to buy. Galleries are greated based upon images in each folder. Images are added daily as the event goes on for usually a week.
As we get corrections we make those in the spreadsheet (images in the wrong folder or wrong participant numbers) It would be good know which images were for what day and be able to back out the batch job for that date and apply the corrections in batch at the end of each day as needed. ( Its prohibative to review images individually at the end of each day to minimize errors, manually applying ther corrections is also time consuming so being able to back out the folder create and file copy and then to reapply the corrected associations so image and participant match is correct is preffered.
We are also adding cameras so there may be more than one image range and participants may appear later in a single days shoot in the same image range or in another cameras range. Image numbers(file names) would always be unique for the entire week.
All images are put in a specific image folder.
This seems straight forward enough and have bits and pieces of jscript etc for folder create file move etc. But frankly to get this done "right" we are looking for a best approach and someone to assist us with this. Our thoughts are to use Access as the database give the simplicity of the app with simple forms to log the coreections in and an administrative "console" to launch jobs from.
Assistance on this would be greatly appreciated. I'm not a programmer and think tackling this myself might be an effort in futility but I may have to try if I cant find coding assistance. Thanks for reading.
Specific detaild questions or inquiry welcome.