40% OFF EVERYTHING
BLACK FRIDAY SALE
Buy Now

CSV Upload with WP All Import

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

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

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • April 17, 2015 at 4:43 pm #37407

    Marilyn Wo
    Free User
    Post count: 2

    Hi, as with those with a problem uploading CSV files, same here, I have no idea how the lang and long can be auto generated, it doesn’t make sense for us to search one by one through the thousands of listings to import in. This defeats the purpose of a CSV import function.

    Hence, I am trying out WP All Import to achieve this objective. But I would like to find out how to match the address of listings to the “address” field in the custom post. Within WP All Import, I’ve tried to add all fields to custom fields with GeoDirectory’s custom post types, but that didn’t work.

    Hope you can help, thanks!

    April 17, 2015 at 4:52 pm #37408

    Simone
    Expired Member
    Post count: 3515

    hello, if your “issue” is the lat and lon, you can use this website to convert addresses in batch
    http://stevemorse.org/jcal/latlonbatch.html

    April 17, 2015 at 5:34 pm #37414

    Marilyn Wo
    Free User
    Post count: 2

    Cool! Thanks Simone, shall try this out first.
    Just to do a quick check, if I can’t complete all the fields does it still matter? Do I have to include all the columns? Thks!

    April 17, 2015 at 5:45 pm #37415

    Simone
    Expired Member
    Post count: 3515

    Hi, mandatory fields are:
    post_title
    post_author
    post_content
    post_category
    post_type
    post_address
    post_city
    post_region
    post_country
    post_zip
    post_latitude
    post_longitude

    More info here
    http://docs.wpgeodirectory.com/core-general/#csv

    April 17, 2015 at 6:31 pm #37416

    Paolo
    Site Admin
    Post count: 31206

    Just FYI WP all import is not compatible with GeoDirectory.
    We use some custo DB tables and provide our own CSV import tool for this reason.
    Thanks

    April 18, 2015 at 5:37 am #37463

    Marilyn Wo
    Free User
    Post count: 2

    Ok, thanks Paolo, with try the inbuilt csv again, but somehow this link doesn’t work http://stevemorse.org/jcal/latlonbatch.html

    Will probably have to find another site for lat and long.

    April 18, 2015 at 10:15 am #37482

    Simone
    Expired Member
    Post count: 3515

    Hello, the website is working fine, just tried now

    April 18, 2015 at 4:37 pm #37495

    Paolo
    Site Admin
    Post count: 31206

    Just tested and works for me too. This is an alternative just in case.

    http://www.findlatitudeandlongitude.com/batch-geocode/

    Thanks

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 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