• Resolved tjure83

    (@tjure83)


    Hallöchen,
    ich habe aus einer aktiven WordPress-Installation eine CSV-Datei exportiert mit den Beiträgen aus einem Gästebuch (101 Stk.) – nun habe ich diese Datei in eine neue Installation importieren wollen und nun steht dort “Die Datei scheint korrupt oder zerstört zu sein” und er importiert nur 9 Einträge. Kann sich jemand vorstellen, woran es liegen kann und hat einen Tipp für mich? Ich wäre sehr dankbar!

    Hey,
    I just exported a csv-file out of an active WP-installation and tried to import in a new installation on another server. It has 101 entries. But during the import it says “File seems to be corrupt or broken” and the system imports just 9 entries. Anyone with an idea or may help? Many thanks!

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Marcel Pol

    (@mpol)

    Hi, could you send the file to my email? It is at [email protected]

    I can then easily see what is wrong. If it is simple, I can fix it and send it back. If there are bigger issues, I will send it back as well 😉

    Plugin Author Marcel Pol

    (@mpol)

    Hi,
    I see there are a lot of entries, especially the tenth 🙂 where quotes are missing.

    What you could do is open the CSV file in a decent text editor like Notepad++ or better. Then for every content field that doesn’t already have double quotes, please add standard “double quotes” around it.

    If there is any entry that still fails, please check if the content field itself has quotes in it, those would need to be escaped. Escaping is simple, you would change " to \".

    A CSV file is simple really, every entry starts with a first field with an ID, which is not used. Every field in that entry is separated by a comma. If the field for content contains a comma and there are no quotes around it, the parser thinks it is a new field. Adding quotes around such a field will make sure that the comma is regarded to be part of the content.

    Can you manage?

    Plugin Author Marcel Pol

    (@mpol)

    Hi, I sent an updated CSV file to your email address. Does it work for import?

    Thread Starter tjure83

    (@tjure83)

    Hi Marcel,

    many thanks for your help! It works now with another change of myself. Your changes were important for me, to figure out, whats the other problem: smileys! Those hearts and praying hands are destroying the import-workflow. Now, I have all the 100 entries imported. Thank you and have a nice day!!

    Greetings from germany
    Jens

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Einträge /Entries’ is closed to new replies.