Help Importing GEO Info in Bulk CSV File

  • Resolved SJS719

    (@sjs719)


    9 years, 5 months ago

    I am creating a business directory site much like YP and I need to be able to upload my listings’ address and geo information along with the rest of the listing using either the defult WP importer or WP All Import but I cannot find the field names/meta names of the GEO My WP fields in order to populate the correct info.

    If I am using an importer to import the street, city, state, zip, country, address, and formatted address into Geo My WP how do I identify these fields in my CSV file? I have tried using GMWP_city for example, but I haven’t been able to populate the correct fields.

    Anyone?

    https://www.ads-software.com/plugins/geo-my-wp/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Eyal Fitoussi

    (@ninjew)

    Hi,
    GEO my WP saves the location information in a custom database table ( wp_places_locator ) rather than in custom fields.

    There are two ways you can import the locations into GEO my WP but only if the listings that you are importing has coordinates ( latitude and longitude ):

    1) You will need to map the location fields of each listing into the database table when importing. You will usually need to do that using hooks provided by the importer plugin.

    2) probably the easier way:
    A) Import the location fields into any custom fields of your choice using the CSV importer.
    B) when done importing the file use the custom fields importer of GEO my WP -> tools to import the locations from the custom fields into GEO my WP database table.

    Again, the above will work only if the listings that you import has coordinates. Otherwise, you will need to geocode each location when importing and then save it in database.

    I hope that helps.

    Thread Starter SJS719

    (@sjs719)

    Thanks for the reply Eyal. It’s not exactly ideal… but I will give this a shot.

    Thanks.

    Thank you. Great Plugin!

    Plugin Author Eyal Fitoussi

    (@ninjew)

    @jakeaustin,
    For some reason the other topic where you asked me about importing locations was automatically closed and I cannot reply there. That’s why I replied here.

    There is no way to directly import location to GEO my WP from a file. What you can do is use any importer that can import the address fields and coordinates ( must have coordinates ) into custom fields ( you can choose any custom fields that you’d like if the importer gives you the option ). Once the importing is done you can use GEO my WP Tools page to import the locations from the custom field into its database table.

    Navigate to the dashboard -> GEO my WP -> Tools -> Import/Export tab -> Post Types Locations and scroll down to the “Import Posts Types Locations Using Custom post_meta” section. Just follow the instructions.

    Let me know if you have any questions.

    BTW,
    I am more responsive in GEO my WP’s official forum.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Help Importing GEO Info in Bulk CSV File’ is closed to new replies.