Listings will not import

This topic contains 10 replies, has 3 voices, and was last updated by  Paolo 7 years, 11 months ago.

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

Open Support Ticket
  • Author
    Posts
  • June 14, 2016 at 3:21 am #208113

    Lynnette Braillard
    Full Member
    Post count: 34

    Hi,
    I’ve been trying for hours to figure out why my listing database won’t import. Can you help please? I attached my CSV file.

    June 14, 2016 at 3:22 am #208115

    Lynnette Braillard
    Full Member
    Post count: 34

    I’m getting this error:

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

    June 14, 2016 at 3:30 am #208116

    Lynnette Braillard
    Full Member
    Post count: 34

    Actually, please review this CSV file instead.

    June 14, 2016 at 9:12 am #208141

    Guust
    Moderator
    Post count: 29970

    The file is not comma delimited, but tab delimited.
    I guess you have all categories already created.

    Try this file, i just changed to comma delimited and UTF-8.

    June 14, 2016 at 7:47 pm #208603

    Lynnette Braillard
    Full Member
    Post count: 34

    Thank you for responding. I imported the revised file and here’s the error I received again — see screenshot … but getting closer! Any thoughts on what’s happening?

    June 14, 2016 at 7:49 pm #208604

    Lynnette Braillard
    Full Member
    Post count: 34

    Let’s try this screenshot that’s a smaller file size…

    June 14, 2016 at 10:12 pm #208638

    Guust
    Moderator
    Post count: 29970

    You are trying to import some listings into 2 post types at the same time, that is not possible.

    For anything else I would need URL and WP admin details in a private reply.
    I would start checking to make sure:
    * all post types exist and are correctly referenced
    * all categories exist and are properly referenced and match the requested post type
    * multilocations addon is active
    * remove unnecessary quotes in some of the post_titles, like ‘Al”s RV Park’ should be Al’s RV Park It seems that is copied from somewhere else and not from a UTF-8 file.

    June 17, 2016 at 12:04 am #210000

    Lynnette Braillard
    Full Member
    Post count: 34
    This reply has been marked as private.
    June 17, 2016 at 12:28 pm #210173

    Guust
    Moderator
    Post count: 29970

    You saved it as a tab delimited again, make sure to check your save settings.
    There are still titles with invalid quote marks.
    I suggest you break the CSV files into chunks of 10 listings (and less if required) so you can work out what errors you are making.

    June 17, 2016 at 5:25 pm #210412

    Lynnette Braillard
    Full Member
    Post count: 34

    Thank you so much for all the help. I finally got it to work because I figured out how to change my SAVE AS settings in OpenOffice. All was imported on this last round. Thank you again!

    June 17, 2016 at 5:57 pm #210442

    Paolo
    Site Admin
    Post count: 31206

    Thank you for letting us know 🙂

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

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

Open Support Ticket