Looking for ideas. PDF form data to offline database.
Posted on 2012-03-20
I have a small client that just landed a Federal government (US) contract.
They need to collect information from application via a fill out PDF form into a database that for security reasons MUST be offline. Adding to the complexity, the applicants need to have their supervisor vouch for them. I'm looking for ideas of how to get this information into a disconnected database. The database doesn't exist yet, so there's lots of options. We're likely looking at MySQL due to cost.
I was thinking that an email might be able to be sent with the information (not confidential info) in a specific format. Then that info could be imported into the database after insuring that it's valid. There will be tens of thousands of applicants.
The tricky part is how we can have the supervisor vouch for a person. If there's no online accessible database, I'm having a hard time coming up with a method for the supervisor's paperwork to be matched to the applicant.
I know this is really a high level description, but throw some ideas out if you can...