How do I catalog hundreds of documents for searching and reporting? [closed]
1
I handle document control for my mechanical engineering company and need a better method to keep track of submitted drawings & business documents. Right now I just use an Excel sheet with about 20 columns and recording each individual file's associated project, vendor, customer, drawing title (different than file name sometimes), revision, etc. This has become very monotonous when I submit up to 50 drawings at one time - I have already hand-typed about 1000 lines on my spreadsheet in the last 6 months. All of that work, and I still do not have built-in file hyperlinks or report-generation which are huge problems now. Not to mention Excel's search capability is comparable to manually scanning a column for the string I'm looking for. I have toyed with a few open-source doc control options, fil...