Hi,
A local non-profit is going to start cataloging documents (paper copies) by scanning them, using OCR to convert them to PDF, then filing the hard copies away. A buddy approached me (knowing I know a bit about computers) and asked me about a simple database system.
Requirements:
Fairly easy data entry (via a web form, I'd imagine would be easy) - Volunteers would be entering the information
Fairly easy searching by any number of attributes - author, date, type of document, etc.
Sorting by category
A link to the location of the PDF for each entry
Would be nice to have a memo/text field that the contents of the document could be copy/pasted into, so they can search by content if necessary
Now, they're pretty low-cost... so the first idea of getting a small, local server isn't going to fly. I suggested they could talk to their host about a MySQL setup (or rather put me in touch with their host) and run it through that - since the PDFs will be uploaded to their host anyway. That way volunteers could also take a box of documents home and enter data from there.
Any thoughts? Is there any open source software already out there that can handle these needs? I have plenty of experience with SQL database management and PHP, but I've never built anything like this from the ground up. It would have to be very non-tech friendly to enter data and search the database though.
Thanks!
A local non-profit is going to start cataloging documents (paper copies) by scanning them, using OCR to convert them to PDF, then filing the hard copies away. A buddy approached me (knowing I know a bit about computers) and asked me about a simple database system.
Requirements:
Fairly easy data entry (via a web form, I'd imagine would be easy) - Volunteers would be entering the information
Fairly easy searching by any number of attributes - author, date, type of document, etc.
Sorting by category
A link to the location of the PDF for each entry
Would be nice to have a memo/text field that the contents of the document could be copy/pasted into, so they can search by content if necessary
Now, they're pretty low-cost... so the first idea of getting a small, local server isn't going to fly. I suggested they could talk to their host about a MySQL setup (or rather put me in touch with their host) and run it through that - since the PDFs will be uploaded to their host anyway. That way volunteers could also take a box of documents home and enter data from there.
Any thoughts? Is there any open source software already out there that can handle these needs? I have plenty of experience with SQL database management and PHP, but I've never built anything like this from the ground up. It would have to be very non-tech friendly to enter data and search the database though.
Thanks!
Last edited: