Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Export Bugs?

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Export Bugs?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 5, 2007 at 12:05 pm #10165
      pbm
      Member

      I'm trying out the evaluation version 5.22 and I like it a lot. The “HTTP tunnelling” via a PHP script is very ingenious and the answer to my issues with our ISP.

      However I wanted to download some data and noticed these problems with the export functionality:

      1. Selecting the Excel export option and setting the parameters actually exported XML

      2. Exporting CSV gives a problem with timestamp columns in that only the year and month are exported

      BTW the synchronise database structures functionality didn't update the timestamp columns correctly either.

      Are these issues with the evaluation version only or a known bug that's being worked on?

    • February 5, 2007 at 2:00 pm #23366
      peterlaursen
      Participant

      1. We export in the XML based format supported natively by Excel 2003 and 2007.  On Excel 2000 and 2002 you will need to install the Compability Pack provided by Microsoft.  We do not use the .xls-format.  We program for the future not the past 😆

      2  When I export a small table with some Timestamps I giet a file reading like:

      Code:
      2006-11-20 12:00:03
      2006-11-20 12:00:04
      2006-11-20 12:00:04
      2006-11-20 12:00:05
      2007-01-19 10:43:27

      Could you provide a test case to reproduce with?

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.