35% OFF EVERYTHING
HALLOWEEN 2024 SALE
Buy Now

Importing data

This topic contains 3 replies, has 2 voices, and was last updated by  Guust 7 years, 2 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • August 20, 2017 at 12:00 am #392011

    Qianyun Huang
    Expired Member
    Post count: 18

    I have read the overview for importing data. https://wpgeodirectory.com/docs/core-export/

    It states that post_latitude and longitude are required. However, it is impossible to manually search for these two field with a large database. There are automatically generated when a listing is added manually. Is there anyway to have the system automatically generally these two field with address when using importing option? thank you!

    post_latitude: latitude in signed degrees format, for example -20.97625669
    post_longitude: longitude in signed degrees format, for example 162.45444

    August 20, 2017 at 12:31 am #392019

    Guust
    Moderator
    Post count: 29970

    Lat and ng can only be auto-created if adding a listing from the frontend or admin area of your site.
    If preparing a CSV for import, have a look at https://wpgeodirectory.com/docs/core-export/#resources

    Thanks

    August 20, 2017 at 3:13 am #392025

    Qianyun Huang
    Expired Member
    Post count: 18

    Thank you! I was able to generate those. By the way, I used http://geoservices.tamu.edu/ to do geocoding. it is great! they give 2500 transaction for free if anyone want to use it.

    August 20, 2017 at 3:20 am #392028

    Guust
    Moderator
    Post count: 29970

    Added at https://wpgeodirectory.com/docs/core-export/#resources

    Thanks for sharing

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount