Bug #73453 Append not working when +1 column is selected
Submitted: 1 Aug 2014 17:10 Modified: 18 Aug 2014 21:25
Reporter: Javier Treviño Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S2 (Serious)
Version:1.2.1 OS:Any
Assigned to: CPU Architecture:Any

[1 Aug 2014 17:10] Javier Treviño 
Description:
Append not working when +1 column is selected, even when the mapping is correct.
No error message no indication for the user of what is wrong.

Verified in:
Windows 7x64
Excel 2007
mysql-for-excel-1.3.2.msi Job232
Windows 8.1x64
Excel 2010
mysql-for-excel-commercial-1.3.2.msi Job232

How to repeat:
1. Open excel and the MySQL for Excel plugin.
2. Open a valid connection->Schema->table.
3. Import some rows (10).
4. Add a new column to the imported data.
5. Add some data to the new column.
6. Select all the data, click on the original table and click on the "Append Excel Data to Table" option.
7. Do the mapping and press the "Append" button.

Actual results:
Nothing happens.

Expected results:
The append of the data should be applied because you are mapping the data that you want to append.
[1 Aug 2014 17:22] Javier Treviño 
Posted by developer:
 
Fixed the logic that calculates the resulting mapped data to be appended to an existing MySQL table, this was failing in scenarios where the selected Excel data has more columns than the mapped columns to be inserted to the MySQL table.
[18 Aug 2014 21:25] Philip Olson 
Fixed as of the upcoming MySQL for Excel 1.3.2 release, and here's the changelog entry:

The "Append Excel Data to Table" operation failed when the number of
columns did not match, even when the data was manually mapped.

Thank you for the bug report.