Title: Import/Export Date Problem
Last modified: December 24, 2016

---

# Import/Export Date Problem

 *  Resolved [urlolibero2016](https://wordpress.org/support/users/urlolibero2016/)
 * (@urlolibero2016)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/importexport-date-problem/)
 * Hi!
    I tried to export a test message from guestbook and i have one problem: 
   the date format. This the sequence: 1) I write a message for test into guestbook
   2) I see and confirm the message from dashboard 3) I export the message in csv
   format from your export option
 * Note: i have a lot of message to import but i don’k know the headers fro put 
   right words in right places to import to Gwolle
 * 4) I prepare a empty csv with your headers
    5) When i open your exported CSV 
   the date format is: 1482568454 6) What kind of format i must use to convert this?
   The date of inserted message was 24/12/2016 at 08:34 AM
 * I must import in a Yours Formatted CSV but i don’t know how recalculate date 
   to prepare the import csv
    Please help me!

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

 *  Thread Starter [urlolibero2016](https://wordpress.org/support/users/urlolibero2016/)
 * (@urlolibero2016)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/importexport-date-problem/#post-8587447)
 * I tried to prepare a CSV file to import but the importer tell me “Seems your 
   CVS filecoming from a not compatible export version of Gwolle-GB.
    I opened your
   exported file: i find you use the comma separated format. To use this, i changed
   settings to have a comma separator to export from excel, but to import , the 
   same error message appear. Normally for CSV, now, a lot of people use a point-
   comma ” ; ” separator. For a simple reason: in the message people write some 
   commass to separate periods, In the old format, message with some commas in text
   are surrounded as this: “text, sample” to avoid errors in fields. Some times 
   people export also with a Tab separator character to avoid other errorrs. I hope
   in future the integration for other kind (as Excel or Office kinds of format)
   If there are only 2-3 message to put in the guestbook ok but whn the message 
   are 80-100 bettter convert to wordpress comments and use another plugin.. Sincererly
   Dave Zegna [http://www.davidezegna.it](http://www.davidezegna.it)
    -  This reply was modified 9 years, 5 months ago by [urlolibero2016](https://wordpress.org/support/users/urlolibero2016/).
      Reason: Analized problem
 *  Plugin Author [Marcel Pol](https://wordpress.org/support/users/mpol/)
 * (@mpol)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/importexport-date-problem/#post-8587729)
 * Hi, the date is a UNIX timestamp.
    On importing it will try to convert a formatted
   date by using sme standard PHP functions. If it fails, it will use todays date.
 * About the format… Excell is hell.
    There is an example file in the zipfile under/
   docs. There are some gotcha’s… – Use commas and quotes like expected. Excell 
   will make a mess, and in each locale the mess is a different one. – Make sure
   the file is UTF-8 without BOM. – Make sure the line-endings are UNIX formatted.
   Any decent text-editor can set that correctly for you.
 * I had somewhat good experiences with LibreOffice Calc, it seems you can set more
   options for exporting to CSV.
    -  This reply was modified 9 years, 5 months ago by [Marcel Pol](https://wordpress.org/support/users/mpol/).
 *  Thread Starter [urlolibero2016](https://wordpress.org/support/users/urlolibero2016/)
 * (@urlolibero2016)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/importexport-date-problem/#post-8587794)
 * HI!
    ok Thanks! The difference is Calc not use the separate list character used
   on windows Start/ControlPanel/Internationaloptions Better next time…

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

The topic ‘Import/Export Date Problem’ 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/)

 * 3 replies
 * 2 participants
 * Last reply from: [urlolibero2016](https://wordpress.org/support/users/urlolibero2016/)
 * Last activity: [9 years, 5 months ago](https://wordpress.org/support/topic/importexport-date-problem/#post-8587794)
 * Status: resolved