Hi - I have a client with a database of unresolved murders in Colorado from 1876 - Present. Unfortunately, this is an extensive list.
There are about 8 tables, all keying off victimID, and all containing possibly relevant information about the victim, the case, legislators and jurisdictions, investigative notes, concerned family members, victim photos.
I originally had the idea of using a CSV-to-Pages plugin so convert each Victim record into a page object in Wordpress, but now that I see the extensive structure of the original database, the data purist in me would hate for this process to forever break this structure.
However, the client is hoping for the ability of family members to login, modify records, add new records, upload photos - all things WordPress and maybe Buddypress could handle very well for us. Ultimately though, I'd love to be able to let people use this data in WordPress, but somehow keep an export option intact that would still maintain the table structure already in place.
I guess I'm just asking for suggestions on the best way to do this. Should I create custom fields for every database field so our pages all have this sprawling list of fields that can be edited? A bit clunky in WordPress, but likely possible to export as intact tables still? Or would it be easier to simply mimic the WordPress page function to render this table data, but keep it all as separate table fields for editing?
Advice, specific approaches, and any other suggestions would be much appreciated.