Import CSV-file not working – despite debug

This topic contains 8 replies, has 3 voices, and was last updated by  Guust 5 years, 7 months ago.

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

Open Support Ticket

Tagged: , ,

  • Author
    Posts
  • #446621

    Birgit Wilde
    Full Member
    Post count: 236

    Hello.
    I am trying to import a csv-file with listings (CPT:Brautmode) the system keeps on telling me that none of the listings could be imported due to
    a) missing title or unvalid CPT
    and
    b) unvalid address (address,city,region …)

    What I have done so far to find the error:
    – I have created listings from the front end
    – then exported these listings into a csv-file and saved it with Open Office -> UTF 8, German language, comma seperated
    – on the basis of this exported csv-file I created the csv-file with all listings to be imported, providing all mandatory data just as provided from the exported csv.
    – made sure the csv-file imported has exactly the same structure as the csv-file I had exported before, including all latitude/longitude information in the required format (55.5453453436, 10.45353534)
    – installed the wp debugging as recommended in the trouble shooting, however the debug.log comes up with exactly the same information as already provided (see above).

    And I just do not see what the problem is, because all address data, title and cpt seem to be correct.

    However, when I export the listings created in the front end, save the csv-file as recommended (Open Office, UTF 8, comma seperated …) and try to import exactly this file without making any changes, this also does not work. Again for the reasons above, even though – as far as I can see – all required information and columns are provided.

    Any idea, what might be the problem?
    Many thanks
    Birgit

    #446623

    Guust
    Moderator
    Post count: 29970

    What happens if you just export and then re-import, without changing any CSV settings?
    So do not “save as” but just use the file as exported.

    Please post URL and WP admin details in a private reply if we need to look at anything.
    You can also add your CSV file you are trying to import.

    Thanks

    #446628

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

    Guust
    Moderator
    Post count: 29970

    You changed the column name of the first column, that should be post_id
    Can you check that and let us know.
    Thanks

    #446640

    Birgit Wilde
    Full Member
    Post count: 236

    Hi Guust,
    hm… well, the name of the first column in the attached csv is post_id
    Or what do you mean what I have changed?

    Many thanks
    Birgit

    #446660

    Guust
    Moderator
    Post count: 29970

    Oops, my mistake, I was looking at the wrong thing.
    I now have downloaded the CSV for that CPT and reimported it without any problem as I downloaded it.
    SO there must be a mistake in the data you enter or the way you save the file.

    I’ll get someone else to have a look too.

    You also have an error in your SSL certificate, see https://www.ssl247.com/kb/ssl-certificates/troubleshooting/apache/ssl-error-rx-record-too-long-firefox-apache-tomcat

    Your site does not open in Chrome or Firefox, only in Internet Explorer.

    Thanks

    #446689

    Kiran
    Moderator
    Post count: 7069
    This reply has been marked as private.
    #446873

    Birgit Wilde
    Full Member
    Post count: 236

    Hi Kiran,
    many thanks, it was a setting in Open Office. Import works now.
    Regarding the SSL Error: I have contacted my host but we could not reproduce this mistake. We will keep our eyes open, thank you for this hint.

    Best regards
    Birgit

    #446896

    Guust
    Moderator
    Post count: 29970
Viewing 9 posts - 1 through 9 (of 9 total)

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

Open Support Ticket