How to get the correct date and time in CSV import spreadsheet

  • Resolved Leo

    (@kruijne)


    5 years, 4 months ago

    Marcel, I succeeded to export data from Easy Book Reloaded Joomla guestbook database and import the data by puting the data in CSV spreadsheet. However the datetime column in the GWOLLE table makes no sense. How to get the correct data (date and time) in that column (I should import about 150 rows..) Thanks for your reply

Viewing 1 replies (of 1 total)
  • Plugin Author Marcel Pol

    (@mpol)

    Hi, this plugin uses UNIX timestamps, which is the time in microseconds since 1970. For manually creating a timestamp, look at the timestamp generator. When using a formatted date, the plugin will try to read it correctly. If it fails it will use today’s date.
    https://www.timestampgenerator.com/

Viewing 1 replies (of 1 total)
  • The topic ‘How to get the correct date and time in CSV import spreadsheet’ is closed to new replies.

Tags