One of our fileservers has been in use for about 10 years now gradually collecting more and more documents and files over the years. We need to have a clear-out!
I've trawled the main hard drive on the server with a script and have produced a .csv file with a complete list of every file on it together with its size, date created and date last accessed. I want to suck this into a Microsoft Access 2003 database with a simple front-end to allow us to quickly browse through the folders (and the files in each folder) to establish whether we want to...
1. Keep the file forever where it is
2. Keep the file where it is until the next review occurs
3. Keep the file for a finite amount of time e.g. 3, 6, 9, 12, 18, 24 months etc
4. Delete the file immediately
5. Keep the file but move it off the server into an Archive Drive (directory structure / file location to be preserved, just moved from say c:\Docs1\January\[login to view URL] to d:\Docs1\January\[login to view URL]
Front-End should be primarily in two parts, one top section to display all the directories, maybe against each directory could be the oldest file, youngest file, size of the largest file within its immediate directory, this would enable us to sort the directories into an order so we could prioritise some of the oldest files, files hardly ever used, largest files we could get rid of etc, i.e those files which would have the biggest impact on the space available on the server (we're looking to archive / delete a lot of stuff to free space). The bottom screen section would display all files in the directory selected in the top section.
For each file we would need to be able set the attribute as per 1-5 above together with a "keep until" date for those attributes where we would keep the file for a finite amount of time. Also required would be a facility to set all the files in the immediate directory with the same attribute e.g. for those directories which contain many hundreds of files, to save setting the attribute for each file individually.
There would be a .csv file containing all the file / directory info. This would need to be sucked into an Access 2003 .mdb file. So we could run the procedure again in the future on a new set of files, we would need a facility to be able to....
1. Append any new files that didn't exist in the previous .mdb file
2. Update any existing files already in the database with new attributes if they have changed, but keeping the pre-assigned designations 1-5 above
I know how to program this myself, however i am looking to outsource for efficiency and to free my time for other projects.