Help moving files from many folders into just one folder

Page may contain affiliate links. Please see terms for details.

mapleleaf

MB Enthusiast
Joined
Dec 4, 2002
Messages
1,719
Location
Hinckley, Leicestershire
Car
2022 GLC 300 estate- replaced 2018 Gle 43 AMG Night - replaced previous 2015 E63 AMG
Hi all

I am looking for some help please with the following with my windows system- I'm looking to export data to a new database with a different file structure. Filed mapping is fairly straightforward but handling attached documents is giving me a headache...

many thanks in advance .....

My database (sybase) stores documents outside the database and links to them. The database links to 5 category folders ( eg Clients, suppliers, events etc ) and each contains many sub folders that are numbered such that the last folder in the group contains documents. Each document ( word, pdf etc) has a unique reference number generated by the database and is prefixed by the client number so all documents for the same client are grouped together. The file structure is related to the client number, so for example document files relating to client 0110667 are found in this folder structure :-

CLIENT\01\10\66 and in the 66 folder are 10 sets of client documents for the following client ref numbers.. 0110660 to 0110669.

So in my example above I have 2 uniquely named documents .. 1 word and 1 pdf ( in the prefix the leading zero is dropped)

110667.134721.doc
110667.137775.pdf

What I am trying to do is extract all of these unique document files from the dozens of subfolders into one large master folder. There are too many folders to do this manually and I wondered if there was some batch file code or other script that some one could help me write to automate the process that would systematically work its way through each folder until it found files ( not every folder has files in them) and copy what it finds into One master folder. There are only document files in the last folder of the structure that drills down to each group of 10 client numbers in question

The whole structure is as follows - I hope what I'm trying to put across is clear :confused:

CLIENT\
01\
02\
.
.
.
99\

CLIENT\01\00\
01\
02 \ to 11

CLIENT\01\00\01\
02\ to 99


cheers.
 
Which operating system are you using to attempt this?

If it's windows I have a script that should do it for you
 
Last edited:
If I understood your requirements right, I would have thought you could use Search and search from the top level without specifying anything - this would then find all files underneath.

You could then copy them all from within the results and paste them where you want them in your master folder file...
 
thanks JohnEboy
I'm not to familiar with running scripts. to be honest your suggestion does seem more user friendly and I hadn't thought of that .. just tried & it does give me the result I needed cheers :)
 

Users who are viewing this thread

Back
Top Bottom