csv import coordinates

This topic contains 17 replies, has 3 voices, and was last updated by  Guust 8 years, 6 months ago.

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

Open Support Ticket
  • Author
    Posts
  • October 26, 2015 at 9:41 am #58023

    Tony
    Expired Member
    Post count: 147

    Hi Guys
    I just imported a bunch of listings after getting the coordinates, but what’s happening is that teh coordinates don’t seem to register unless I go into the listing and click the find on map button, which locates them precisely.

    I uploaded a lot at one time, but I’m not sure if I can just bulk locate them.
    Thoughts?

    import worked with less, so I can always reimport.

    Mark

    October 26, 2015 at 9:57 am #58024

    Guust
    Moderator
    Post count: 29970

    Not quite sure what you mean. Are the listings not showing on the maps on the frontend, without publishing them? Can you post your WP admin details and your URL in a private reply, so we can have a look at your setup. And attach the copy of the CSV file too, if you don’t mind.

    October 26, 2015 at 9:27 pm #58076

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    are you sure you entered the lat and long in the correct format in your CSV file?

    Let us know,

    Thanks

    October 27, 2015 at 1:08 am #58106

    Tony
    Expired Member
    Post count: 147

    HI I’ll check the status, I thought it might just be that the database needs to update to accurately position the coordinates.

    Let me see if it’s just an update issue.
    Mark

    October 27, 2015 at 1:22 am #58107

    Tony
    Expired Member
    Post count: 147

    still doing it, here are some screen shots.
    The only thing I wonder is if there might have been a space before the coordinates in the csv, but I did a few test files and it was fine. I just did a big batch in the end.

    While you guys look, I’ll look at the csv (which was done per spec, with open office calc).

    If I need to refresh it, is it better to download the data and check it, so that the listing number stays good, or should I revise the initial file and re upload that?

    This is very cool though, that I know how to basically create a directory now!!

    Mark

    October 27, 2015 at 1:25 am #58108

    Tony
    Expired Member
    Post count: 147

    screen shots

    October 27, 2015 at 1:29 am #58109

    Tony
    Expired Member
    Post count: 147

    screen shots smaller
    Doing it for most cities, tried Boston, Atlanta, all same.

    Maybe I should download the current listings and see if anything obvious in the CSV.

    Mark

    October 27, 2015 at 1:46 am #58111

    Guust
    Moderator
    Post count: 29970

    It’s best to export and then re-import, that way you don’t create duplicate listings.
    The fact that the new listings are all going in your default location, suggests that the coordinates were wrong.
    Can you post your WP admin details and your URL in a private reply, so we can have a look at your setup. And attach the copy of the CSV file too, if you don’t mind.

    October 27, 2015 at 2:35 am #58113

    Tony
    Expired Member
    Post count: 147
    This reply has been marked as private.
    October 27, 2015 at 3:22 pm #58148

    Paolo
    Site Admin
    Post count: 31206

    Hi,
    please attached the CSV file too.
    Thanks

    October 28, 2015 at 11:59 am #58240

    Tony
    Expired Member
    Post count: 147
    This reply has been marked as private.
    October 28, 2015 at 12:04 pm #58242

    Tony
    Expired Member
    Post count: 147

    guys my csv is too big to attach how should I get it to you?
    Mark

    October 28, 2015 at 12:20 pm #58244

    Guust
    Moderator
    Post count: 29970

    Can you just cut a sample maybe.
    I had a look at your admin area, and I can see that you have used inconsistent references to states, for example, you have used AL, Alabama and AL 36801. The system will treat those as 3 different regions.
    I also see you have thousands of listings now and they seem to work just fine.
    What is exactly the problem still?

    October 28, 2015 at 12:38 pm #58245

    Tony
    Expired Member
    Post count: 147
    This reply has been marked as private.
    October 28, 2015 at 1:31 pm #58249

    Guust
    Moderator
    Post count: 29970

    I would
    1. Export all of them – no need to delete
    2. Check all cities, regions and country in the CSV for consistency; they should be using the full name of the state and country, no abbreviations.
    3. Re-import using the same post IDs
    4. Filter your locations for abbreviations and delete those locations

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

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

Open Support Ticket