Import of listings fails despite usage of sample file

This topic contains 6 replies, has 2 voices, and was last updated by  Guust 6 years, 11 months ago.

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

Open Support Ticket

Tagged: , ,

  • Author
    Posts
  • #413685

    Birgit Wilde
    Expired Member
    Post count: 236

    Hi there,
    for some time now I am trying to import my csv-file with listings.

    Therefore I have exportet the sample file from GD.
    Testwise I have then importet the sample file without having made any changes and it worked fine.

    After that I have opened the sample file (with Open Office) and copied the data of my listings in the respective columns of the sample file (each listing incl. title, post type, categorie, full address details, latitude and longitude). Then I re-imported the new sample file including my data.

    As a result only 7 of 19 listings where imported. However, each of these imported listings only constists of a permalink in the frontend – no title, no address, no nothing.

    The rest of the listings where not imported, some of them due to missing post type, category or title (although each one has a title, category and post type in the csv) or unvalid address (although all these addresses worked fine when drawing the latitude and longitude from gpsvisualizer).

    My next try was to create a listing with the frontend form “add listing”, exported that in a csv file and used that as a sample. – Same miserable result.

    1) What is the problem with my import?
    2) the GD sample csv file does not have a column for “claimed”. When using the sample to import data without the column “claimed”, will then all listings be claimed or not claimed by default?

    Looking forward to hearing from you.

    #413690

    Guust
    Moderator
    Post count: 29970

    The sample file is only a sample to get started. The best idea is to export your listings to get the correct file setup if you added custom fields and other GD addons.

    Categories are required and have to be existing.

    If we need to review anything, post URL and WP admin details in a private reply, and also a copy of the CSV file [you may have to ZIP it].

    Thanks

    #413691

    Birgit Wilde
    Expired Member
    Post count: 236
    This reply has been marked as private.
    #413694

    Guust
    Moderator
    Post count: 29970

    See image for a number of errors, it looks like you copied “illegal” characters from somewhere else.
    If we need to review anything else , post URL and WP admin details in a private reply.
    Thanks

    #413697

    Birgit Wilde
    Expired Member
    Post count: 236
    This reply has been marked as private.
    #413699

    Birgit Wilde
    Expired Member
    Post count: 236

    Anyway, so I will replace the special letters by normal letters (not pretty but working ;-)).
    Now everything works perfectly well.

    Thanks Guust for your help! And as well to the entire support team – you are just great!

    #413727

    Guust
    Moderator
    Post count: 29970

    Try adding listings from the front end of your site, using the Google suggested address after you set your map to German.
    Then export your listings to see how the German characters are used.
    I am guessing you copied from a non-text based file into your CSV file.

    Thanks

Viewing 7 posts - 1 through 7 (of 7 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