Import not working

This topic contains 3 replies, has 2 voices, and was last updated by  Alex Rollin 6 years ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • April 26, 2018 at 11:37 am #428095

    Marjon Saft
    Free User
    Post count: 3

    Hello, I’m having some trouble with the import function.

    I keep getting the following errors:

    224 / 224 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).
    224 / 224 item(s) could not be added due to blank title/invalid post type/invalid characters used in data.

    I checked the list but can’t find anything wrong with it.

    It also happens when I export the places I already have, change the Post Type and try to import them again to add them to another Post type. (or do you have other options to change the post type?)

    Attached you’ll find the file I’m trying to import.

    Thanks for having a look at it!
    Marjon

    April 26, 2018 at 12:53 pm #428105

    Alex Rollin
    Moderator
    Post count: 27815

    If you export and then re-import to another CPT, then categories must be created first in the new CPT as well as removing the post id.

    When I open your CSV I see problems with the formatting, with semicolons instead of comma separators. Please use LibreOffice for the edit to avoid formatting issues.

    https://wpgeodirectory.com/docs/core-export/

    April 26, 2018 at 2:29 pm #428124

    Marjon Saft
    Free User
    Post count: 3

    Ah thank you so much for your quick reply, you saved my day!

    It worked when I used LibreOffice instead of Microsoft Office. Didn’t know there was such a difference in the use of programs for CSV files. And stupid of me not to find the article in which you explain that… I did check the documentation but couldn’t find it at the time.

    Thanks a lot!

    April 26, 2018 at 2:36 pm #428125

    Alex Rollin
    Moderator
    Post count: 27815

    Glad you got it working!

    https://nl.wikipedia.org/wiki/Kommagescheiden_bestand#Varianten

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

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

Open Support Ticket