8

I work at a print shop that has a decent sized archive of old print jobs. Currently, to find a job we have to search the SMB share (on win2000 server), which looks through a few hundred thousand files.

Our job data is organized by: Year>Month>Customer_Name_Job# and then the contents of the job are inside the last folder.

Is there a way to create a database so that we can query a job desc. or job number? Basically just a simple search that is faster than searching with windows search would be great. I tried the windows index service but it only finds .doc file, not folder names or PDFs.

In the future we are planning on making a SQL database where complete info will be entered when the job is created so it is easily queried in the future. I was hoping to throw together something that will make it easier to search older orders.

2 Answers 2

6

I personally wouldn't try to design a database from the ground up for this one -- what you're looking for in the library and archives field would be called a 'digital repository' (one step abstracted from a 'digital library', which usually is only tracking bibliographic items). In the business world, they talk about stuff like Digital Asset Management, but sometimes that's done through registries, not repositories; the different being that in a registry, you only track information about the object, but it only points to the object, rather than storing the authoritative copy of the object.

See if one of these projects could be adapted to fit your needs:

Or, see a larger list of free & open source digital repository software

2
  • WOW.....WOW, that's perfect :) I need to check the others further, but the demo video for Dspace looks amazing! That would even be worth manually re-filing all the old jobs. Thanks!!! Feb 23, 2011 at 13:22
  • @skinny Welcome to the site "If you like this, please vote it up. It's important for the community!" Please see this post for more information. We're glad we could help Feb 23, 2011 at 18:08
8

You could use a Document-oriented database for this. You could then create a program in your preferred language to import the existing documents into the db, parsing the folder structure for the metadata (customer, job#, etc).

1
  • Thanks!, I was having trouble googling what I needed, this gives me a great start! Feb 20, 2011 at 16:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.