Table Data Import Wizard 'Could not determine delimiter'

Question

I'm trying to import into my database a csv file using Table Data Import Wizard tool, to a table that just has one attribute (it's id VARCHAR(10)), the import is failing showing me this error: error I've checked the csv file in order to find any wierd characters or newline characters but everything is fine. Im using version 8.0.25 and the logs are showing this:

16:00:09 [ERR][       pymforms]: Unhandled exception in Python code: 
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_page_widget.py", line 97, in go_next
    self.main.go_next_page()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_form.py", line 76, in go_next_page
    self.pages[index].page_activated(True)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 185, in page_activated
    self.call_create_preview_table()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 343, in call_create_preview_table
    self.create_preview_table(self.call_analyze())
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 352, in call_analyze
    if not self.active_module.analyze_file():
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_export_be.py", line 511, in analyze_file
    self.dialect = csv.Sniffer().sniff(csvsample)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\Python\Lib\csv.py", line 188, in sniff
    raise Error("Could not determine delimiter")
_csv.Error: Could not determine delimiter

And here is how my csv file looks:

id_tren
56X0O
12X0Y
91X0F
13X0P
92X0U

user_5193536 · Answer

A csv are Comma-separated values.

so you have to give the importer some commas

like

id_tren,
56X0O,
12X0Y,
91X0F,
13X0P,
92X0U,

then you get

and select the column you want

Table Data Import Wizard 'Could not determine delimiter'

1 Answers