Create D/B records that are entered from files saved in directories
Posted on 2011-09-24
I have files which are delivered through DropBox to my file server, what I'd like to do it when a file is 'dropped', something scans the directories, finds the latest saved file, enters a record in the DB which points to this file.
Is this possible? The naming convention of all the files is the same so the format won't change, the directory it resides in though is the differentiator.
So, the filename is like this:
the length of each part won't change, so the first part IMG00001 will always be IMG003432 for example, the format will never change.
The directories are similar:
the second and third part of the structure will never change from a 2 digit/5 digit structure, the last part could be 2-4 alphanumerics.
I know this is probably impossible but thought I'd ask the question anyway!!
Any help would be much appreciated.