Bug #80472 can not import csv file
Submitted: 23 Feb 2016 9:40 Modified: 20 Jan 2017 22:08
Reporter: Marcel Beerli Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:6.3, 6.3.6 OS:Any
Assigned to: CPU Architecture:Any

[23 Feb 2016 9:40] Marcel Beerli 
Description:
one of 2 errors.
either can not read file, error 2
or UTF-8 error
Feature does not work.

How to repeat:
Excel, save a csv, use notepad, safe as utf-8 , try to import
[24 Feb 2016 8:03] MySQL Verification Team 
Hello Marcel,

Thank you for the report.
Observed this with WB 6.3.6 on Win7.

Thanks,
Umesh
[24 Feb 2016 8:05] MySQL Verification Team 
-- Create Schema

CREATE TABLE `bug` (
  `id` int(11) NOT NULL,
  `address` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- As reported suggested, create excel file, save as csv..open csv file in textpad or anyeditor which allows to change encoding.. save it as utf8

-- try to import csv file
[24 Feb 2016 8:05] MySQL Verification Team 
test csv file for import

Attachment: bug.csv (application/vnd.ms-excel, text), 7 bytes.
[20 Jan 2017 22:08] Christine Cole 
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.9 release, and here's the changelog entry:

The import operation failed to import valid CSV files.

Thank you for the bug report.