Developing a file metadata system -Part 3

All went well until ....
Until some file which was originally found and processed, but was no where to be found afterwards, they went missing in action.

How did that happen.
1. I placed the files into a folder called - "Unprocessed"
2. When the file was viewed by an end user they then got moved into another folder called "Processed"
3. After 1 week of work, all files from the processed folder was to be checked against the database data to ensure that end users did not just view files. A clean up process was done on the "processed directory" which delete all the file.
5. We created a new directory for the final files - by manually dropping copies of these files by the year in which they were processed.eg. 1970, 1971.
6. The problem showed up during the verification process.
7. End users accessing the files for review and spot check did not always find a pdf. document.
8. There was a need to find these documents by manually searching and this was no fun, it was like looking for the "needle in the hay stack"  and having to do this for a few hundred document meant... stress.

In part 4 of  I will discuss a better way of managing the file - from the start process to the end. A method that will move the files without loosing a record.

Comments