Import from a csv giving 1048 error

Sheryl Posthumus's profile image Sheryl Posthumus posted 3 weeks ago in Import/Export Permalink

I am trying to import data into a table from a csv file, but am getting the following error:

SQL Error (1048): Column 'enabled' cannot be null

The data type for the 'enabled' column is TINYINT and my csv file has a 1 in this column. Please can you advise what I am doing wrong?

Description

ansgar's profile image ansgar posted 3 weeks ago Permalink

Multiple things may be the cause here. Screenshot is missing the lower part of the dialog, so I cannot really tell.

Suggestions:

  • prefer "Server parses file". It's more reliably.
  • double check if the control characters ; " \r\n match to the contents of your CSV file
Sheryl Posthumus's profile image Sheryl Posthumus posted 3 weeks ago Permalink

Thank you very much. I have amended my control characters and the import was successful

Please login to leave a reply, or register at first.