Bug #104806 Date Import format not specified

• Submitted: 2 Sep 2021 9:00
• Modified: 29 Sep 2021 12:40
• Reporter: John King
• Status: Won't Fix
• Category: MySQL Workbench
• Severity: S7 (Test Cases)
• Version: 8.0.23
• OS: Windows (Microsoft Windows 10 Pro)
• CPU Architecture: Any
• Tags: WBBugReporter

[2 Sep 2021 9:00] John King

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Johannes\AppData\Roaming\MySQL\Workbench\log\wb.log]

During import it is not possible to set the date format. Only when a new table is created the datetime format can be specified.

How to repeat:
Create a table with datetime fields

attempt to import a text file (csv) with a different date format (dd.mm.yyyy)

Suggested fix:
Allow selection of the datemask just like the one creating a new table.

[2 Sep 2021 9:01] John King

wb.log

Attachment: wb.log (application/octet-stream, text), 55.34 KiB.

[29 Sep 2021 12:40] MySQL Verification Team

Hello John King,

Thank you for the reasonable feature request!

Regards,
Ashwini Patil

[14 Sep 18:06] Omer Barnir

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.