Support » Plugin: Gwolle Guestbook » Errors importing data

  • Resolved Emer

    (@emcgal)


    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 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

    (@mpol)

    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

    I can prepare the CSV file for you, if you want (without the dates). You can email it to marcel@timelord.nl

    Thanks Marcel,
    Sending you an email now.

    Plugin Author Marcel Pol

    (@mpol)

    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 5 months, 1 week ago by Marcel Pol.
Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.