WordPress.org

1. ChubbyEatsNY
   Member
   Posted 3 months ago #
   

   Hi,
   I have my list of all my addresses in 'wp_postmeta', using metatag 'address'. Is there a way for me to copy all the addresses over?
   Below is an record in the database table.

   meta_id post_id meta_key meta_value
   20046 7882 address 300 W 22nd St, New York, NY 10011

   Thanks

   http://wordpress.org/extend/plugins/geo-mashup/

2. Dylan Kuhn
   Member
   Plugin Author
   Posted 3 months ago #
   

   Setting the Geocode Custom Field setting to 'address' will work for newly added fields, but not existing ones. Doing bulk geocoding is tricky because most services will limit the speed and number of requests you can make. There is an open feature request for it here:

   https://code.google.com/p/wordpress-geo-mashup/issues/detail?id=597

   There may be other batch geocoding solutions that would allow you to import geo_latitude and geo_longitude fields.

3. ChubbyEatsNY
   Member
   Posted 3 months ago #
   

   I couldn't find any other solution to import. Do you have the SQL script that copies the custom field to the geo table when an update is performed? I think if I use the postID, I can quickly update the post and populate the geo mashup tables?

4. Dylan Kuhn
   Member
   Plugin Author
   Posted 3 months ago #
   

   There isn't a SQL script - the GeoMashupDB::copy_from_geodata() function uses the WordPress API to do it. If you already have latitude and longitude, though, enabling Geo Mashup's "Copy Geodata Meta Fields" setting and then using another plugin to bulk load geo_latitude and geo_longitude should work.

Reply

You must log in to post.