Importing Listings Error

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

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

Open Support Ticket
  • Author
    Posts
  • September 10, 2015 at 10:38 am #52661

    Martin Omaga
    Expired Member
    Post count: 121

    Hi.

    We are trying to use the import listings, but its not working.

    even with the SAMPLE CSV that you provide, it gets this error:

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

    Any clue?

    Thanks,

    Martin.

    September 11, 2015 at 1:47 pm #52794

    Guust
    Moderator
    Post count: 29970

    Does your settings allow listings to be imported in any location?
    Have the categories already been created?
    https://wpgeodirectory.com/docs/core-export/#import

    Can you post your admin details and URL in a private reply please.

    September 11, 2015 at 2:08 pm #52797

    Martin Omaga
    Expired Member
    Post count: 121

    Meanwhile I made it. But it didnt recognize the special characters… and they are a lot 🙁

    September 11, 2015 at 4:42 pm #52840

    Paolo
    Site Admin
    Post count: 31211

    Have you tried saving the CSV in a format that recognize the special characters like UTF8.

    Let us know how you went,

    Thanks

    September 14, 2015 at 8:31 am #53066

    Martin Omaga
    Expired Member
    Post count: 121

    Yep, I saved as UTF8, but when I import to Geodirectory, they get totally screw up. Now we have to change one by one.

    September 14, 2015 at 2:57 pm #53120

    Paolo
    Site Admin
    Post count: 31211

    Is your database collation the same as the CSV file?

    If you provide url, wp admin, ft, phpmyadmin details and a copy of the CSV with the special character we will have a look for you.

    Let us know,

    Thanks

  • 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