40% OFF EVERYTHING
BLACK FRIDAY SALE
Buy Now

.csv Import Error

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

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • December 27, 2016 at 8:28 pm #331213

    Israel Medel
    Buyer
    Post count: 21

    Hi, I have this error, but my import data is correct.

    2 / 2 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).

    How can fix this?

    .csv attached

    December 28, 2016 at 12:35 am #331295

    Guust
    Moderator
    Post count: 29970

    Is that your default location?
    Are the categories already created?
    Are your permalinks setup correctly? https://wpgeodirectory.com/docs/basic-installation/#postnames

    Add a listing and then export to see what is different with your files.

    If we need to check anything else, add your URL and WP admin details in a private reply.

    December 28, 2016 at 3:45 am #331374

    Israel Medel
    Buyer
    Post count: 21

    Hi, your plugin don’t accept the file but, another plugins don’t have problem with the same file.

    I found how to make it work.
    If I export from your plugin the .csv file and I import that .csv file without modifications, it works.
    If I modify the file with Excel, your plugin rejects the file, but if I use Google Docs or LibreOffice to modify the .csv file, your plugin don’t rejects the file.

    The problem is that your plugin don’t allow me to use Excel to modify the .csv file as everything else does, but I can handle it with LibreOffice.

    If later you find the solution for Excel would be useful for me.

    Thank you

    (solved)

    December 28, 2016 at 4:20 am #331378

    Guust
    Moderator
    Post count: 29970

    Excel will never work because it adds hidden things to the geo coordinates for example, that break the import.
    https://wpgeodirectory.com/docs/core-export/#important

    December 28, 2016 at 4:32 am #331382

    Israel Medel
    Buyer
    Post count: 21

    Ok, I see now.

    Thank you so much.

    (Solved)

    December 28, 2016 at 4:35 am #331384

    Guust
    Moderator
    Post count: 29970

    You’re welcome 🙂

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