Bug #94871 Cannot Perform Clean Uninstall/Install of MySQL for Excel
Submitted: 2 Apr 15:21
Reporter: Kent Bjorklund Email Updates:
Status: Open Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S3 (Non-critical)
Version:1.3.7 OS:Microsoft Windows
Assigned to: CPU Architecture:x86
Tags: MySQL for Excel, uninstall mysql for excel

[2 Apr 15:21] Kent Bjorklund
Description:
MySQL for Excel is generating a mapping error when I try in append new rows from Excel.  

Exception message:
Value '[column]' is not suitable to be converted to a DateTime data type.

Exception thrown by:
MySqlDataTable.CopyTableData

Stack trace:
   at MySQL.ForExcel.Classes.MySqlDataType.GetValueAsDateTime(Object rawValue)
   at MySQL.ForExcel.Classes.MySqlDataTable.PrepareCopyingItemArray(Object[]& itemArray, Boolean escapeFormulaTexts)
   at MySQL.ForExcel.Classes.MySqlDataTable.CopyTableData(DataTable fromSourceTable, Boolean preserveChanges)

Trying a new file makes not difference; trying to import throws the same error with the same column name even though it is a new file; Edit MySQL Data generates the same error.  

When the error OK is clicked, a second error appears: "Cannot find column 12".

When the second error is clicked, the window disappears and the mapping windows fails to launch.  

How to repeat:
Cannot duplicate on my other computer.  I suspect it has to do with errors in auto mapping which is stored somewhere.

Suggested fix:
Reinstalling the plugin does not reset the user defined settings for the plugin so the errors persist.  

Please provide a method for either:

1. Locate the user settings for the plugin so that one can change the auto load defaults.
2. Provide a way to do a clean uninstall so that all user settings for this plugin are wiped out whereby a fresh installation of the plugin potentially eliminates the errors.

Thank you.