Title: Errors importing data
Last modified: January 23, 2020

---

# Errors importing data

 *  Resolved [Emer](https://wordpress.org/support/users/emcgal/)
 * (@emcgal)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/errors-importing-data/)
 * I have tried using both LibreOffice Calc and Excel (both latest versions) to 
   convert CSV and both are giving errors.
 * It seems your CSV file is from an export that is not compatible with this version
   of Gwolle-GB.
 * Also, I entered a few manually to get the file format plus I saw your reply to
   this [link](https://plugins.trac.wordpress.org/browser/gwolle-gb/trunk/docs/import_example?order=name)
   I can’t make out in either, how to enter the dates?
 * Lastly, can you update at a later stage with the star rating if I go for the 
   pro.
 * Thanks in advance.

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

 *  Plugin Author [Marcel Pol](https://wordpress.org/support/users/mpol/)
 * (@mpol)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/errors-importing-data/#post-12364089)
 * The dates are a UNIX timestamp, which is just a number in microseconds. There
   is a link to a timestamp genrator in the docs.
 * Also, you can use certain date formats, which are considered valid dateformats
   in PHP code. Formats are explained here with examples: [https://www.php.net/manual/en/datetime.formats.date.php](https://www.php.net/manual/en/datetime.formats.date.php)
 * I can prepare the CSV file for you, if you want (without the dates). You can 
   email it to [marcel@timelord.nl](https://wordpress.org/support/topic/errors-importing-data/marcel@timelord.nl?output_format=md)
 *  Thread Starter [Emer](https://wordpress.org/support/users/emcgal/)
 * (@emcgal)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/errors-importing-data/#post-12370098)
 * Thanks Marcel,
    Sending you an email now.
 *  Plugin Author [Marcel Pol](https://wordpress.org/support/users/mpol/)
 * (@mpol)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/errors-importing-data/#post-12388147)
 * Hi,
    The question was really about the date format? It imports fine, so the CSV
   is correct.
 * The date is “wrong”, it is not an accepted date format. “27/01/2020” is not what
   it should be. The American date format is required when you do it this way: “
   01/27/2020”, so “month/day/year”.
 * The meta fields are exported and imported as serialized data, which is more difficult
   to do in a CSV. It looks like this:
    `"a:1:{i:0;a:4:s:7:""meta_id"";s:4:""6738"";
   s:8:""entry_id"";s:4:""6286"";s:8:""meta_key"";s:10:""starrating"";s:10:""meta_value"";
   s:1:""5"";}}"` The meta_value is what you want, it should be between 0 and 5.
   The “s” field is the number of characters in a field. The 5 in this example is
   really the value of the starrating. Does this help?
    -  This reply was modified 6 years, 4 months ago by [Marcel Pol](https://wordpress.org/support/users/mpol/).

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

The topic ‘Errors importing data’ 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: [Marcel Pol](https://wordpress.org/support/users/mpol/)
 * Last activity: [6 years, 4 months ago](https://wordpress.org/support/topic/errors-importing-data/#post-12388147)
 * Status: resolved