5

Is it possible for Google Fusion Tables to read my Wordpress database? If so, how?

I have custom wordpress fields which contain addresses for several hundred companies. Ideally I want Google Fusion Tables to read the database.

Hopefully this will overcome two major problems 1. Avoid the geocode limit (currently done using a time delay, which isn't ideal). 2. Obfuscate my data so it's protected.

Really need someone's help with this.

Bryce
6061 gold badge5 silver badges18 bronze badges
asked Oct 31, 2011 at 15:52
9
  • 1
    Google Fusion Tables are a database - so you want to COPY from your wordpress database to your fusion table? Commented Oct 31, 2011 at 16:09
  • @Mapperz Yes, I want to copy specific data from my wordpress db to the fusion db. If it can be done automatically then even better. Commented Oct 31, 2011 at 16:11
  • 1
    Interesting. Now, I have no idea if this will work, as I have never worked with Fusion Tables, but I think it's worth looking into. What about using PHP to push your database content out to XML, as in this Google Maps API article? Basically it queries the table and pushes the result out to a XML file, then Google Maps reads it. Can this also be done for Fusion Tables - have it read the dynamic XML file? Commented Oct 31, 2011 at 16:16
  • 3
    Not sure this is GIS SE question but Yes Export your Wordpress DB en.support.wordpress.com/export csv format - load in csv into fusion tables comma-separated text (.csv) 100mb limit - Commented Oct 31, 2011 at 16:28
  • 1
    Sorta. The link to the Google Maps API example explains it better, but it uses PHP to query your database (in your case your WP table), push the query results to a XML file, then maybe somehow have your Fusion Table slurp in that XML with every map request...maybe? Commented Oct 31, 2011 at 16:37

2 Answers 2

2
  1. You have to export your table to csv
  2. Maybe use google refine to improve the data of your articles csv
  3. Import csv in a Fusion Table
  4. Geocode the table, its a feature in the user interface, you Geocode by the column "Article text" where the addresses are
  5. Click on the map view, and you could view the points, some of them will be missing because of an unsuccessful geocoding

If only want to know if it is possible the answer is yes, the limit is the geocoding capacity of google to get addresses inside your text.

  1. You can geocode by yourself using geonames or another Geocoding API
answered Apr 2, 2012 at 22:56
0

There's no point and click way to do this. But hiring someone to write the script you need is not hard. The script must read your WordPress database, then write to fusion tables using the Fusion Tables SQL API. Maybe a 100ドル-200ドル job. Then you need a way to run the script every so often (nightly?). Your web host may have "cron" jobs available for this purpose.

answered Feb 5, 2012 at 5:53

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.