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:
Category:MySQL for Windows: MySQL for Excel Severity:S3 (Non-critical)
Version:1.2.1 OS:Any
Assigned to: CPU Architecture:Any

[9 Jul 2014 18:20] Javier Treviño
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.
[4 Sep 2014 21:18] Philip Olson
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.