Bug #100074 MySQL Excel - Changes to Mapping
Submitted: 2 Jul 2020 6:23 Modified: 22 Jul 2020 12:45
Reporter: Sam Benson Email Updates:
Status: Won't fix Impact on me:
Category:MySQL for Windows: MySQL for Excel Severity:S3 (Non-critical)
Version:1.3.8 OS:Microsoft Windows (10)
Assigned to: CPU Architecture:x86
Tags: Excel, MySQL

[2 Jul 2020 6:23] Sam Benson
If a mapping has been stored by MySQL for Excel and the underlying database table structure is adjusted (in this example columns were removed), the addin complains about not being able to find a column and additional data cannot be appended.

How to repeat:
1. Create a table in MySQL with a number of columns
2. Append data via Excel addin and ensure a mapping is created/saved
3. Delete a number of columns from the table at 1.
4. Attempt to append data from Excel (ensuring new format)

Suggested fix:
Move the mapping table button as part of the error message to amend/delete a mapping.
[2 Jul 2020 6:24] Sam Benson
Update versions of addin and Windows
[22 Jul 2020 12:45] MySQL Verification Team
Hello Sam Benson,

Thank you for the feature request.

Ashwini Patil
[21 Sep 2020 18:18] Omer Barnir
Product under sustaining support