Import/Export Date Problem

  • Resolved urlolibero2016

    (@urlolibero2016)


    7 years, 4 months ago

    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

    (@urlolibero2016)

    7 years, 4 months ago

    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

    • This reply was modified 7 years, 4 months ago by urlolibero2016. Reason: Analized problem
    Plugin Author Marcel Pol

    (@mpol)

    7 years, 4 months ago

    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 7 years, 4 months ago by Marcel Pol.
    Thread Starter urlolibero2016

    (@urlolibero2016)

    7 years, 4 months ago

    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.