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

CSV import

forums › forums › SQLyog › Using SQLyog › CSV import

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 23, 2003 at 9:41 am #14558
      Shadow
      Member

      Perhaps the end-of-line character (/n) is not reconized properly. Convert the CSV file, then retry importing.

    • June 23, 2003 at 10:14 am #14559
      amarone88
      Member

      Even the command line gives me the same problem, it seems not to be a SQLyog bug =___=''

      What do you mean by converting the CSV file? Into what should I convert it? O.O''

      Thanks

      I tried operning the CSV with Microsoft Word and it shows the new line character properly.

      Some other elements: I first had my CSV with every line terminating with n but the last column was not followed by a comma. This way, the command imported only the first line anyway, but the last column was followed by the first column of the second record:

      2/01/2003 – TV – H – LS – 60 – – – – S/AGGIORNAM/RICERCA Articoli vari arretrati – AI””2/01/2003

      (AI””2/01/2003 is the last imported column, as you can see the date should be the first column of the second record. Here I separated columns by -)

    • June 23, 2003 at 10:44 am #14560
      amarone88
      Member

      Ok, problem solved. It was due to a wrong character that Macintosh FileMaker added at the end of the line.

      I deleted it with a text editor and now all works fine.

      Thanks, bye ^____^

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