Analyzing Scanned PDFs for Database Building

[walxer]

Hi there LTT Forum! 

 

I'm looking for some help on the easiest way to tackle a work-related task. I work for an event venue and we're trying to build a searchable database of events over 60 years. We have scanned in (most of) the lists that were kept as records from 1959 - 1990, and then from 1990 onward, we have some form of digital / PDF, etc. for the more recent events. They are generally laid out like "XYZ Event - December 1, 2000 - Venue Space", mercifully. 

 

What would be the best way to tackle getting all of this into a database entry format? I saw the UPDF ad in WAN last night and started wondering if there was an AI / smarter way to handle this than just going through the lists and typing it out by hand. 

 

Looking for recommendations on:

1) How to tackle this issue (what software, etc.) 

2) How to store this data (best database solution to share with 20+ employees). 

 

Happy to answer any questions, just let me know what you want to know!

 

Thanks,

WX

[Mr.Nicen]

Did you already decided on a data structure or is the question still relevant?