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

[Bug] Import External Data Scientific Notation

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › [Bug] Import External Data Scientific Notation

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • June 28, 2011 at 2:24 am #12367
      premixedpie
      Member

      When importing data from CSV files with a row that has a negative number with scientific notation the importer seems to fail and the log shows that it the number is not in the query and is simply left blank. If it is not a negative number then the everything works fine as far as I can tell.

      I have attached a zip file containing 2 simple CSV files with numbers with scientific notation. bug_test.csv has no negative numbers with scientific notation and imports fine, in bug_test2.csv the first entry has a negative number with scientific notation and throws an error when trying to import. The log shows the field that should have the negative number as simply blank but shows the second row with the correct number. I've spent a decent amount of time trying to narrow down what was the problem when trying to import some files and this looks to be the cause.

      [attachment=1590:bug_test.zip]

    • June 28, 2011 at 9:58 am #32370
      ashwin
      Member

      Hi,

      We have reproduced the issue and is fixed now. It will be available in the next public release(probably tomorrow). If you need the fix urgently we can provide you a special not-release build to you.

      Thanks for reporting,

      Ashwin

    • June 28, 2011 at 8:14 pm #32371
      premixedpie
      Member

      I can wait till the next release if it is within a few days. Thanks for getting this fixed!

    • June 30, 2011 at 9:07 am #32372
      ashwin
      Member

      Hi,

      We have released SQLyog 9.2 beta 1 with this fix.

      Please refer to:

      http://www.webyog.com/blog/2011/06/30/sqlyog-mysql-gui-9-2-beta-1-released/

      Thanks for reporting this issue to us.

      Regards,

      Ashwin A

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.