Import issue

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

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • #426264

    shanker
    Full Member
    Post count: 31

    Hello,

    When i try to do a test import of 5 items, i’m getting the following issue

    ///

    Total 48 item(s) found ???.

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

    48 / 48 item(s) could not be added due to blank title/invalid post type/invalid characters used in data.

    ///

    Find below the csv file i use.

    Thank you for your help

    #426265

    shanker
    Full Member
    Post count: 31
    This reply has been marked as private.
    #426274

    Paolo
    Site Admin
    Post count: 31206

    hi,

    you are saving the file with wrong delimiters.

    If I open the file with the correct settings (comma and double quotes) data is all mixed up. (see image capture.jpg)

    If I open the file with wrong settings (semicolon and double quotes) data is almost correct. (see image capture1.jpg)

    I say almost because there are still wrong characters (letter with accents pasted with wrong collation visible in capture1.jpg).

    To correct delimiters pls see: https://wpgeodirectory.com/support/topic/bulk-csv-importer-now-working/#post-131913

    To correct special characters you can use the search and replace tool.

    Hope this helps.

    Let us know,

    #426277

    Kor
    Moderator
    Post count: 16516
    This reply has been marked as private.
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
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount