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: MySQL Verification Team CPU Architecture:x86

[20 May 2018 17:48] David Snow
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.
[20 May 2018 18:15] MySQL Verification Team
To attach the file use the Files tab. Thanks.
[21 Jun 2018 1:00] Bugs System
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".
[1 Mar 2021 2:36] Taiwo Obalola
nvcadb

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

[23 Nov 2021 15:38] Sougata Roy
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.