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

Forums | Webyog

Tools to manage and monitor MySQL databases

Data import

This topic is empty.

Viewing 5 reply threads

Author

Posts
- October 30, 2003 at 4:26 pm #8224
  
  geofftv
  Member
  
  I am importing data as a CSV file. The fields are tab delimited and some have ” surrounding them.
  
  On completion of the import I get a dialog that says Import Successful. Records: 33 Deleted: 0 Skipped:0 Warning: 1.
  
  Where can you see what this/these warning(s) is/are?
  
  Also I note that the last field in each row has a graphical box character as the last character in the field or the only character in the field if the field was otherwise empty.
  
  Can you tell me what is causing this and how to stop it?
- October 31, 2003 at 8:13 am #15167
  
  Shadow
  Member
  
  Quote:
  
  Also I note that the last field in each row has a graphical box character as the last character in the field or the only character in the field if the field was otherwise empty.
  
  The CSV file may have a win style rn line termination, but you import the file using only n as line terminating character.
- October 31, 2003 at 10:12 am #15168
  
  geofftv
  Member
  
  Thank you for that. You were right about the rn.
  
  What about where to view the warning(s) referred to?
- November 4, 2003 at 8:18 am #15169
  
  Shadow
  Member
  
  As far as I can recall, warnings should appear in the messages window.
- November 4, 2003 at 9:28 am #15170
  
  geofftv
  Member
  
  I looked there. It seemed the obvious place but warnings associated with data import don't seem to appear there.
- November 4, 2003 at 3:34 pm #15171
  
  Shadow
  Member
  
  Unfortunately, It's been a while since I did CSV import last. I'll do a test import tomorrow and see what I get.
Author

Posts

Viewing 5 reply threads

You must be logged in to reply to this topic.