Importing CSV file without latitude and longitude

This topic contains 12 replies, has 4 voices, and was last updated by  Guust 8 years, 8 months ago.

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

Open Support Ticket
  • Author
    Posts
  • September 1, 2015 at 10:21 pm #51632

    jderrick
    Expired Member
    Post count: 23

    Hello,

    I’m right in the middle of trying to rebuild a website using GeoDirectory and so far I’m quite impressed.

    The task I’m currently struggling with is importing several thousand records from the old site in to GeoDirectory.

    I do not have latitude and longitude fields in the original site as I integrated with Google maps using postcodes along – which for UK locations (all my record are in the UK) works fine.

    So I’m a bit stumped as to how to import all my records. I can’t manually input the longitude and latitude fields for every single record.

    What would you recommend please?

    Regards,

    Jamie

    September 1, 2015 at 10:26 pm #51637

    Guust
    Moderator
    Post count: 29970

    This will show you have to get lat and lng in bulk:
    https://wpgeodirectory.com/docs/core-export/#batch

    Let us know how you went.

    September 3, 2015 at 5:16 am #51765

    MC1171611
    Full Member
    Post count: 180

    Here’s the tool I use, since I work with Google Docs all the time when preparing files for import:

    http://gmaps-samples.googlecode.com/svn/trunk/spreadsheetsgeocoder/geocodespreadsheet.htm

    September 3, 2015 at 12:44 pm #51791

    jderrick
    Expired Member
    Post count: 23

    Thanks guys, just going to try this now.

    September 3, 2015 at 2:11 pm #51802

    jderrick
    Expired Member
    Post count: 23

    I can’t get this working as Google Sheets doesn’t seem to have an option to publish as an ATOM file.

    September 3, 2015 at 2:56 pm #51808

    jderrick
    Expired Member
    Post count: 23

    The batch lat/long tool mentioned in the documentation is working, however it’s taking a very long time! Guess I’ll just have to leave it for an hour or 5.

    September 3, 2015 at 10:02 pm #51848

    Guust
    Moderator
    Post count: 29970

    Don’t know how many you are doing at once, but the instructions say “up to a few hundred addresses” at the time.

    PS: no idea why you’d want an ATOM file …
    You will need to copy the lat and lng into your CSV file.

    September 5, 2015 at 6:53 pm #52112

    jderrick
    Expired Member
    Post count: 23

    Sorry for the confusion regarding the ATOM file, I was referring to the suggestion by mc1171611 to use the Google sheets tool.

    I have now successfully retrieved all the lats and longs by using the batch tool recommended in the documentation. Just had to do them 300 at a time! It seems to run ok to start but then slows down to a snails pace.

    September 6, 2015 at 12:15 am #52118

    Guust
    Moderator
    Post count: 29970

    Ok, let us know if you need any more help.

    October 23, 2015 at 10:18 pm #57870

    realist
    Buyer
    Post count: 18

    what if i have tens of thousands of business without lat/long?

    October 23, 2015 at 11:35 pm #57887

    Guust
    Moderator
    Post count: 29970

    @realist
    Then you just will have to spend some more time at http://www.findlatitudeandlongitude.com/batch-geocode/ 🙂 What else do you expect us to say?

    October 24, 2015 at 5:28 pm #57959

    realist
    Buyer
    Post count: 18

    I don’t know how it works. i thought address alone could be enough

    October 25, 2015 at 1:39 am #57977

    Guust
    Moderator
    Post count: 29970

    Address is enough if you add them one by one in the backend or frontend of your site but not if you upload them by CSV.
    Have a read of this: https://wpgeodirectory.com/docs/core-export/#batch

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

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

Open Support Ticket