Hi,
If you’d navigate to the dashboard -> GEO my WP -> Tools -> Import/Export tab -> Post Types Location tab you will see a section called “Import Posts Types Locations Using Custom post_meta”. Using this importer you can import posts if their location fields saved via custom field.
So what you could do ( if you haven’t already ) is import the posts from the CSV file while importing each post’s location field into its own custom field. When done you can then import the locations from the custom field to GEO my WP table using the tools page.
I hope that helps. Let me know if you have any questions.
I did an import to the table “places_locator” with the Street, City, State, Zipcode, Country Long, Lat and Long fields.
When viewing the custom posts types, the Location Column with a green check mark says, “Location found but the address is missing”. If I open the edit post screen it shows the address fields and geo cords and says address is ready in the Location box.
Will doing what you listed above keep me from having to open each posts edit screen, clicking the Get Lat/Long button, then updating the post? Trying to avoid having to do that to 2000+ posts.
Appreciate your feedback and help. Thank you!
My suggestion above should work.
It is not possible to import locations directly to places_locator table because each location is connected to its post via the post ID. So when importing locations directly to places_locator table the post ID is missing.
My suggestion above will import each posts location from its custom fields to places_locator table together with the post ID.
I exported the table my PODS custom post type creates from the database. That file contains the POST ID and the other info (ex Address, city, state, zip). PODS doesn’t save the extra fields info in a Custom Field, at least not one that is recognized by other plugins.
I think I’ve got a modified version of your suggestion to work. Going to try it one more time on my test site before I make it live.
Love the plugin!
I noticed that when you use the “Get Lat/Long” button to get your Geo Cords, then update the post, it switches some of the info in the database table. You might want to take a look.
It will put the street number (ex. 4) in the ‘street_name’ database field and the street name (ex. Privet Drive) in the ‘street_number’ database field. But If you update the page without using the “Get Lat/Long” button, it saves it correctly = The street number (ex. 4) in the ‘street_number’ database field and the street name (ex. Privet Drive) in the ‘street_name’ database field.
Hope that make sense.
