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.
