Bug #73268 Append Data - Datetime columns are not automatically mapped
Submitted: 11 Jul 2014 2:08 Modified: 9 Oct 2014 5:09
Reporter: Javier Treviño Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S3 (Non-critical)
Version:1.3.0 OS:Any
Assigned to: CPU Architecture:Any

[11 Jul 2014 2:08] Javier Treviño 
Description:
Datetime columns that should automatically map (because column names are the same or because columns are in the same position and have the same data type) are not automatically mapped when the Append Data dialog is opened.

How to repeat:
1. Open MySQL for Excel
2. Select any schema and a table that contains datetime columns
3. Import some rows from the selected table into a worksheet
4. Change the values on the columns of the primary key, select the imported data range
5. Click on Append Excel Data to Table
6. The datetime columns are not automatically mapped like the rest of the columns
[27 Aug 2014 23:19] Javier Treviño 
Posted by developer:
 
Fixed with the code changes done for bug 73541 / 19423952.
[9 Oct 2014 5:09] Philip Olson 
Posted by developer:
 
Fixed as of the upcoming MySQL for Excel 1.3.3 release, and here's the changelog entry:

"DATETIME" columns were not automatically mapped when an "Append Data" action was executed.

Thank you for the bug report.