Greetings all. I work for a non-profit that has about 700 branches across the world. We're looking at using the Elegant Themes theme "Explorable" (located here) to create an interactive map of our branches.
We maintain the information for each of our branches in a database that can be queried via SQL, and I'm thinking that instead of independently maintaining each of what would be 700+ entries anytime something changes, we could handle it via the database.
Basically what I'm interesting in learning (as I'm a front-end kind of guy, not a back end kind of guy) is if it would be possible to basically query and export a spreadsheet of data from the database, then use that data to form the post information on WordPress.
Anyone have experience with this? Any tips or tutorials you could provide?