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

Forums | Webyog

Tools to manage and monitor MySQL databases

CSV Import

This topic is empty.

Viewing 4 reply threads

Author

Posts
- July 1, 2003 at 2:25 pm #14619
  
  Shadow
  Member
  
  Fields terminated by: ,
  
  Fields OPTIONALLY enclosed by: “
  
  Lines terminated by: n
  
  Escaped by: \
  
  This is it. The problem is that certain applications use different EOL characters, so the import may handle the line breaks incorrectly.
- July 1, 2003 at 10:09 pm #14620
  
  David L Morris
  Member
  
  Sorry Shadow, I tried your suggestion, but when I select:-
  
  Fields OPTIONALLY enclosed by: “
  
  I import one record which still has quotes. Here is the display after the import and F5:-
  
  3006 “Boots Healthcare Australia P/L” 3007,”Advanced H
  
  Using XTREE to display the csv file in Hex, I can see the EOL is the normal hex 0D0A
  
  I have over 70K records to import from a larger CSV and I would dearly like to get the import to work
  
  as the speed of import is great. I have attached a similar CSV file if it would help.
- July 2, 2003 at 5:22 am #14621
  
  Ritesh
  Member
  
  Seems there is some problem with the attachment.
  
  Can you mail us the table structure and a sample CSV file so that we can work on it.
  
  You can mail them to [email protected]
- July 2, 2003 at 9:58 am #14622
  
  David L Morris
  Member
  
  Thanks for the offer Ritesh, however, after scanning the MySQL Manual in the nine pages covering LOAD DATA INFILE Syntax, I changed my LINES TERMINATED BY 'n' to 'rn', set the fileds enclosed by ” Optionally and the imports of all my csv files worked perfectly.
  
  I have about 28 days to go on my trial, but I think you can count on a sale.
  
  Regards
  
  David
- July 2, 2003 at 1:18 pm #14623
  
  Ritesh
  Member
  
  Great 😀
Author

Posts

Viewing 4 reply threads

You must be logged in to reply to this topic.