Bug #105923 csv file import

• Submitted: 16 Dec 2021 18:57
• Modified: 17 Dec 2021 12:56
• Reporter: Bo Liu
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• OS: Windows
• CPU Architecture: Any
• Tags: csv, import

[16 Dec 2021 18:57] Bo Liu

Description:
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
    self.func()
  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)
Failed

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

Hello,

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...

Regards,

[17 Dec 2021 12:49] MySQL Verification Team

Hello,

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.

Regards,
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.