MySQL Bugs: #73247: Import data - empty columns created incorrectly for columns not in selection

Bug #73247	Import data - empty columns created incorrectly for columns not in selection
Submitted:	9 Jul 2014 18:20	Modified:	4 Sep 2014 21:18
Reporter:	Javier Treviño	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S3 (Non-critical)
Version:	1.2.1	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The Import Data operation allows the selection of a subset of columns to be imported to Excel, when doing so the imported table contains the non-selected columns without data.
The non-selected columns should not be brought back from the database.

How to repeat:
1. Open MySQL for Excel
2. Select any schema and any table or view
3. Click on Import MySQL Data
4. On the Import Data dialog click on any column shown in the preview data grid, holding the <CTRL> key click on another column to include it in the selection
5. Click on Import
6. Note the imported Excel table or Excel range (depending on the advanced setting) contains the headers of columns not in the original selection but without any data.

Fixed as of the upcoming MySQL for Excel 1.3.2 release, and here's the changelog entry:

The table schema initialization procedure was fixed to only import the
selected columns into Excel, instead of always importing all of them.

Thank you for the bug report.