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

sqlyog can not export csv file properly

forums › forums › SQLyog › Using SQLyog › sqlyog can not export csv file properly

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • May 19, 2003 at 11:51 pm #7949
      jazz
      Member

      I made a fairly simple database just to test out sqlyog, when exporting csv, the column headers are lined up properly, but all the values are stuffed in the first column.

      I am running xp, sqlyog crashed twice in two hours usage time.

      But, overall, it is a good tool to start with.

      You guys did a good job.

    • May 19, 2003 at 11:55 pm #14315
      CalEvans
      Member
      Quote:
      I made a fairly simple database just to test out sqlyog, when exporting csv, the column headers are lined up properly, but all the values are stuffed in the first column.

      What settings did you use?

      What version fo SQLyog ?

      Code:
      I am running xp, sqlyog crashed twice in two hours usage time.

      Gotta be external influences. SQLyog is one of only 3 programs I have open 24×7. (Homesite and DBDesigern4 in case you are interested.) I shut down my email client more than I shut down SQLyog. 🙂

      What kind of erros are you getting when it crashes OR what are you doing when it crashes?

      =C=

    • May 20, 2003 at 4:35 pm #14316
      Ritesh
      Member

      Hello

      Will it be possible to attach the following three things –

      • .SQL backup of the test database you created

      • .CSV file that was created using SQLyog

      • The settings you used to export the data in CSV

      We are in the process of releasing SQLyog 3.5 that will be completely MySQL 4.1 compatible. If there any bugs with our Export functionality, we can fix it in SQLyog 3.5.

    • May 20, 2003 at 6:13 pm #14317
      jazz
      Member
      Ritesh wrote on May 20 2003, 04:35 PM:
      Will it be possible to attach the following three things –

      • .SQL backup of the test database you created

      • .CSV file that was created using SQLyog

      • The settings you used to export the data in CSV

      The attached zip file contains the

      1. snapshot of sqlyog when I did the export,

      2. The scrambled csv export file

      3. The good html export file

      4. The backup of the test database.

      I will be happy to provide more info to get this bug(if it turns out to be) fixed.

    • May 21, 2003 at 6:40 am #14318
      Ritesh
      Member

      Hello

      The exported CSV looks fine. It seems that you are not providing the correct escaping characters.

      To solve the problem, click Change… button in Export As CSV… dialog and use the settings which I have provided in the screenshot

      Quote:
      use rn in as the Line Escaping character

      HTH

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