How to get location data from outside database into WordPress? WordPress
- SOLVED
I hate mixing 2 databases. I hate having to call data from 2 sources to create a webpage. Does WordPress offer anything to make this easy?
I'm working with a client who has a site. They listed about 100,000 locations (hotels, restaurants, etc). They have user reviews and articles.
On each page, they have a Google map. They pull data about nearby locations and feed it into the Google map. So if you look up a restaurant in downtown San Francisco, it shows other restaurants nearby.
Now they want to convert the whole site to WordPress. I'm trying to think of the best way to manage this location data. Any thoughts?
Answers (2)
Marko Nikolic answers:
Try following the answer tips and links from [[LINK href="http://stackoverflow.com/questions/5875365/how-do-i-structure-a-wordpress-plugin-to-pull-data-from-a-custom-database-to-disp"]]here[[/LINK]], maybe not full answer, but could be good starting point.
Also, if that site is based on some of these platforms, check [[LINK href="http://codex.wordpress.org/Importing_Content"]]this post[[/LINK]] from Codex.
Edit:
also check [[LINK href="http://yoast.com/importing-from-another-mysql-into-wordpress/"]]this tip[[/LINK]]
Cheers
Dylan Kuhn answers:
I would try to import the latitude, longitude, and address as post_meta fields in this format:
[[LINK href="http://codex.wordpress.org/Geodata"]]http://codex.wordpress.org/Geodata[[/LINK]]
That will work with a number of WordPress mapping plugins, including the beta version of mine - [[LINK href="http://code.google.com/p/wordpress-geo-mashup"]]Geo Mashup[[/LINK]].
Pretty much all import tools, including the built-in import, will give you a way to do that.