Bug #100074 MySQL Excel - Changes to Mapping

• Submitted: 2 Jul 2020 6:23
• Modified: 22 Jul 2020 12:45
• Reporter: Sam Benson
• Status: Won't fix
• Category: MySQL for Windows: MySQL for Excel
• Severity: S3 (Non-critical)
• Version: 1.3.8
• OS: Microsoft Windows (10)
• CPU Architecture: x86
• Tags: Excel, MySQL

[2 Jul 2020 6:23] Sam Benson

Description:
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.

Regards,
Ashwini Patil

[21 Sep 2020 18:18] Omer Barnir

Product under sustaining support