Title: CVS import problems Last modified: November 20, 2016 --- # CVS import problems * Resolved [elmar2001](https://wordpress.org/support/users/elmar2001/) * (@elmar2001) * [9 years, 6 months ago](https://wordpress.org/support/topic/cvs-import-problems/) * 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](https://wordpress.org/support/users/elmar2001/) * (@elmar2001) * [9 years, 6 months ago](https://wordpress.org/support/topic/cvs-import-problems/#post-8459613) * 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,elmar2001@gmx. net,Ort,[http://www.webseite.de,46.128.22.222,46.128.22.222.dynamic.cablesurf.de,Gästebucheintrag,1479642849,0,1,0](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](https://wordpress.org/support/users/mpol/) * (@mpol) * [9 years, 6 months ago](https://wordpress.org/support/topic/cvs-import-problems/#post-8459634) * 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 [marcel@timelord.nl](https://wordpress.org/support/topic/cvs-import-problems/marcel@timelord.nl?output_format=md)? 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](https://wordpress.org/support/users/mpol/). * Plugin Author [Marcel Pol](https://wordpress.org/support/users/mpol/) * (@mpol) * [9 years, 6 months ago](https://wordpress.org/support/topic/cvs-import-problems/#post-8459938) * 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](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](https://wordpress.org/support/users/mpol/). * Thread Starter [elmar2001](https://wordpress.org/support/users/elmar2001/) * (@elmar2001) * [9 years, 6 months ago](https://wordpress.org/support/topic/cvs-import-problems/#post-8460190) * 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. * ![](https://ps.w.org/gwolle-gb/assets/icon-256x256.png?rev=1114688) * [Gwolle Guestbook](https://wordpress.org/plugins/gwolle-gb/) * [Frequently Asked Questions](https://wordpress.org/plugins/gwolle-gb/#faq) * [Support Threads](https://wordpress.org/support/plugin/gwolle-gb/) * [Active Topics](https://wordpress.org/support/plugin/gwolle-gb/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/gwolle-gb/unresolved/) * [Reviews](https://wordpress.org/support/plugin/gwolle-gb/reviews/) * 4 replies * 2 participants * Last reply from: [elmar2001](https://wordpress.org/support/users/elmar2001/) * Last activity: [9 years, 6 months ago](https://wordpress.org/support/topic/cvs-import-problems/#post-8460190) * Status: resolved