Bug #105923 csv file import
Submitted: 16 Dec 2021 18:57 Modified: 17 Dec 2021 12:56
Reporter: Bo Liu Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version: OS:Windows
Assigned to: CPU Architecture:Any
Tags: csv, import

[16 Dec 2021 18:57] Bo Liu
I was trying to import a simple csv file to my table. 

Import data file....
- Prepare Import

Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\wizard_progress_page_widget.py", line 197, in thread_work
  File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_power_import_wizard.py", line 131, in start_import
    retval = self.module.start(self.stop)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_power_import_export_be.py", line 300, in start
    ret = self.start_import()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_power_import_export_be.py", line 430, in start_import
    self._editor.executeManagementCommand(query, 1)
grt.DBError: ("Unknown column 'None' in 'field list'", 1054)
ERROR: Import data file: ("Unknown column 'None' in 'field list'", 1054)

but there is no column called None or extra empty column

How to repeat:
I can't see anywhere I can upload attachment
[16 Dec 2021 18:58] Bo Liu
here is the csv file

Attachment: Employee.csv (application/vnd.ms-excel, text), 186 bytes.

[16 Dec 2021 19:50] Frederic Descamps

I would recommend to use MySQL Shell Parallel Dump and Load Utility to load csv files to MySQL: https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-parallel-table.html

This is the recommended way.

In case you don't know the table definition, it's always possible to guess it: https://lefred.be/content/using-mysql-shell-to-generate-tables-create-statement-from-csv-f...

[17 Dec 2021 12:49] MySQL Verification Team

Thank you for the bug report.
I tried to reproduce your issue on Windows 10 with workbench 8.0.27 using csv file you have shared but I am not seeing any issues at my end.

Ashwini Patil
[17 Dec 2021 12:56] Bo Liu
After I drop the table and recreate it, it works properly using import wizard. Thanks for your help.