Import errors

This topic contains 7 replies, has 3 voices, and was last updated by  Belinda van Niekerk 8 years, 10 months ago.

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

Open Support Ticket
  • Author
    Posts
  • October 26, 2016 at 1:23 pm #292148

    Belinda van Niekerk
    Expired Member
    Post count: 8

    Getting some errors trying to import CSV. Can’t seem to find the issue as it imports most of the list just fine. The error messages are not of any help in narrowing down the problems.

    “Total 238 item(s) found.
    161 / 238 item(s) added.
    2 / 238 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).
    75 / 238 item(s) could not be added due to blank title/invalid post type/invalid characters used in data.
    Please trasfer all images in ‘/wp_content/uploads /2016/10 ‘ folder.”

    Please see attached CVS. Would greatly appreciate some assistance.

    GD Version 1.6.8
    WordPress 4.6.1

    October 26, 2016 at 1:33 pm #292152

    Guust
    Moderator
    Post count: 29970

    “Unknown” is not a valid latitude or longitude.
    See https://wpgeodirectory.com/docs/core-export/#mandatory

    Not valid either: 34�10’4.21″S

    You should not enter post_IDs unless you are updating existing listings.

    October 26, 2016 at 1:46 pm #292160

    Belinda van Niekerk
    Expired Member
    Post count: 8

    Thank you, can the “unknown” fields be left blank instead?

    October 26, 2016 at 6:48 pm #292352

    Paolo
    Site Admin
    Post count: 31211

    Hi,

    no lat and lon are mandatory fields. The maps will not work without them.

    You can find them with services like this if need:

    http://mygeoposition.com/
    http://www.findlatitudeandlongitude.com/

    Thanks

    October 27, 2016 at 8:37 am #292681

    Belinda van Niekerk
    Expired Member
    Post count: 8

    Thanks, I have made the suggested amendments, but continue to have problems importing all of the data.

    “Total 186 item(s) found.
    129 / 186 item(s) added.
    57 / 186 item(s) could not be added due to blank title/invalid post type/invalid characters used in data.”

    I can’t identify those 57 entries that won’t import or what they all have in common? Please see attached CSV.

    Many thanks

    October 27, 2016 at 8:59 am #292692

    Belinda van Niekerk
    Expired Member
    Post count: 8

    Please note this is not resolved.

    October 27, 2016 at 10:10 am #292713

    Guust
    Moderator
    Post count: 29970

    You seem to have pasted some records from other programs, for example Schr�der Guesthouse
    I suggest you export whatever you have been able to import, so you can work out the ones that did not import. Then you might get a better idea what the error is.

    is_featured should be left empty or 1 for yes

    post_date should be in this format or left empty: 2016-03-10 13:39:31

    All columns with image references should have IMAGE in the header column

    Always the best idea to add a few listings manually and then export them, then you can see the correct formatting required.

    October 27, 2016 at 10:37 am #292729

    Belinda van Niekerk
    Expired Member
    Post count: 8

    Hi that is what I did, added listings and used that as a template. Yes we are importing data that I pulled and parsed from another system.

    What worked was, I opened the CSV in Open Office, selected UTF-8 and overwrote the original CSV. I guess the Char type was the issue. It seems to ave imported everything now.

  • 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