MySQL Bugs: #90945: MySQL Workbench's Table Data Import Wizard reports error

Bug #90945	MySQL Workbench's Table Data Import Wizard reports error
Submitted:	20 May 2018 17:48	Modified:	20 Jun 2018 18:15
Reporter:	David Snow	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S3 (Non-critical)
Version:	8.0.11 rc	OS:	MacOS (10.13.4)
Assigned to:	Assigned Account	CPU Architecture:	x86

Description:
With MySQL Wordbench 8.0 I create a table with

CREATE TABLE IF NOT EXISTS citys  (
    city_id bigint  NOT NULL AUTO_INCREMENT PRIMARY KEY,
    tgt_City varchar(128) NOT NULL,
    county varchar(128),
    state varchar(128) NOT NULL DEFAULT 'WA',
    isOnDList boolean NOT NULL DEFAULT 0,
    isOnWList boolean NOT NULL DEFAULT 0,
    population bigint,
    tgt_Lat  float NOT NULL DEFAULT 0,
    tgt_Longitude  float NOT NULL DEFAULT 0,
    tgt_xAxis  float NOT NULL DEFAULT 0,
    tgt_yAxis  float NOT NULL DEFAULT 0,
    tgt_zAxis  float NOT NULL DEFAULT 0,
    close_cities varchar(256)
);
CREATE  INDEX idx_vacid ON cities (city_id);

Then try to import the data from the attached cities.cvs file using the 
Table Data Import Wizard. After associating a few source to destinations
I finish and get the following error:
“   - Prepare Import
      ERROR: Import data file: ("Unknown column 'None' in 'field list'", 1054)
       Failed

NOTE: There are no columns in either the table or the csv file with the name of “None”

How to repeat:
see above

I don't see where to atttach the csv file, it is only 28kb. Glad to email it to you, nothing confidential in it.  But I have a  Web app using Ms SQL that I am migrating and updating to mYSQL and Wordpress and this tool would be a help in migration.

To attach the file use the Files tab. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

nvcadb

Attachment: Fisheries DB outline (2).xlsx (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, text), 31.06 KiB.

Please check your table in which you are want to import data. The number of column of your table and the csv file column number is different. And also check your column data type. Hope it helps.