CVS import problems

  • Resolved elmar2001

    (@elmar2001)


    9 years, 6 months ago

    Hi!

    I like your plugin, but I have some problems with importing old guestbook entries.

    I have some guestbook entries from an old SQL database. I exported them to CVS and moved them to Excel.

    Then I generated a gwolle-sample-Export, which was in the following style

    id,author_name,author_email,author_origin,author_website,author_ip,author_host,content,datetime,isspam,ischecked,istrash,admin_reply

    Then I modified the excel-guestbook so that is the same style and exported it to CVS with commas.

    That worked but when trying to import I get the message that this is not compatible.

    Any ideas? Can I send you the excel and CVS file by mail? I do not want to upload it in public.

    It would be rally great if I get help.

    Elmar

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter elmar2001

    (@elmar2001)

    9 years, 6 months ago

    Looks like this:

    id,author_name,author_email,author_origin,author_website,author_ip,author_host,content,datetime,isspam,ischecked,istrash,admin_reply
    1,test,,,www.test.de,,,”WOW! Glückwunsch zur neuen Site! Schaut KLASSE aus!!!!!! Gruß”,03.02.06 19:40,0,1,0,

    This is the gwolle CVS:

    id,author_name,author_email,author_origin,author_website,author_ip,author_host,content,datetime,isspam,ischecked,istrash,admin_reply
    1,Elmar,[email protected],Ort,http://www.webseite.de,46.128.22.222,46.128.22.222.dynamic.cablesurf.de,Gästebucheintrag,1479642849,0,1,0,

    Maybe it has to do with the datum format?

    03.02.06 19:40 vs. 1479642849

    How can I convert this? Or are there other problems?

    Error message: “Die Daten scheinen korrupt zu sein. Speichern und Import fehlgeschlagen.
    Es tut mir leid, aber ich war nicht in der Lage, Einträge aus der CSV-Datei zu importieren.”

    How can I fix it?

    Plugin Author Marcel Pol

    (@mpol)

    9 years, 6 months ago

    There are some usual suspects.

    1. You can load your CSV in a text editor like Notepad++ and make sure it has UNIX line-endings.

    2. Are you sure everything uses comma’s inside quotes? Sometimes there are quotes missing, so the comma will be seen as a new field. When this happens, you will usually see that the CSV is only partially imported.

    If nothing helps, can you send the CSV to [email protected]? I can fix and test it probably.

    /edit:
    Oh, about the date…
    The plugin will just import the date as it recognizes it. If the PHP functions that are called to not recognize it, it will be listed as 1 januari 1970 I think. It should not be a problem.

    • This reply was modified 9 years, 6 months ago by Marcel Pol.
    Plugin Author Marcel Pol

    (@mpol)

    9 years, 6 months ago

    Hi, as said in the mail, the file needs UNIX line-endings and it needs to be encoded as UTF-8.

    About dates, in my test it didn’t import the dates correctly, but I don’t fully understand why.
    Here is the function used:
    http://php.net/manual/en/function.strtotime.php
    There is a link to accepted formats, and yours is listed, like “04.06.06”.
    It might be possible to have Exell make it into a different format, but I don’t know Exell that well.

    /edit:
    Oh, forgot to mention… In entry 15 the content is not encapsulated by quotes, so that one fails.

    • This reply was modified 9 years, 6 months ago by Marcel Pol.
    Thread Starter elmar2001

    (@elmar2001)

    9 years, 6 months ago

    I made it, thanks for your help.

    In about 50 of the 180 entries the dates were imported correctly. All others are 2016, Nov. 20th. I checked and I could not find any differences. I do not know what is the reason. But it is ok for me now.

    Thanks again for your superb help.

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

The topic ‘CVS import problems’ is closed to new replies.