| Bug #94580 | Table Data Import - Destination Table dropdown list is not alphabetical | ||
|---|---|---|---|
| Submitted: | 6 Mar 2019 19:25 | Modified: | 8 Mar 2019 5:35 |
| Reporter: | Bryce Morrison | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 8.0.13, 8.0.15 | OS: | Windows (Microsoft Windows 10 Home) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | destination, dropdown, import, table, workbench | ||
[6 Mar 2019 22:12]
MySQL Verification Team
Thank you for the bug report. Please attach a screenshot of the issue.
[6 Mar 2019 23:17]
Bryce Morrison
Screenshot of the non-alphabetical list of tables
Attachment: 2019-03-06_151602.png (image/png, text), 15.44 KiB.
[6 Mar 2019 23:23]
Bryce Morrison
The 3 files, 149 rows total, which took a total of 15 minutes to import
Attachment: 2019-03-06_152103.png (image/png, text), 6.29 KiB.
[8 Mar 2019 5:35]
MySQL Verification Team
Thank you for the feedback. Observed that destination Table dropdown list is not alphabetical on Win7 with WB 8.0.15. regards, Umesh
Description: There is a problem with the "Use Existing Table" step which is represented by Figure 6.16 ("Table Data Import: Destination Table") of the following tutorial: https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html The dropdown list of tables is not alphabetical. How to repeat: Get to the step represented in Figure 6.16 ("Table Data Import: Destination Table") of the following tutorial: https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html Do a query of a table in Workbench 8.0.13. Click on the Import/Export icon which represents "Import records from an external file." Browse for a csv file matching the destination table you have selected. Change the selected bullet from "Create new table" to the "Use existing table" option. You will only see 5 rows representing tables (technically, 5 and 1/2 rows are visible). Have more than 5 tables in the database with the table you are trying to import data to. I have over 100. This will make it even more difficult for you to scroll down to find the table. I repeat: the list is NOT alphabetical, so it is very time consuming to find the destination table. Scrolling down through the non-alphabetical list AND only being able to see the table names in a seemingly random arrangement is frustrating. Suggested fix: The table which was being used on the previous Workbench query window (prior to the import button being pressed) should be the default table, and it should be selected from an alphabetical list of tables. Another workaround might be to allow for the typing of part of the table name, and reducing the displayed list of available tables to only tables which contain at least the sequence of characters which have been typed so far.