Bug #93691 Enable multi-table export in Table Data Export Wizard
Submitted: 19 Dec 2018 22:08 Modified: 21 Jun 2019 23:07
Reporter: B Towne Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Workbench Severity:S4 (Feature request)
Version:8 OS:Any
Assigned to: CPU Architecture:Any

[19 Dec 2018 22:08] B Towne
In the MySQL Workbench, in the left column there is a "Navigator" pane.  Within that is a list of Schemas.  Within each Schema there is a list of tables.  
You can right-click on any table and choose the Table Data Export Wizard.  On the second screen of this you can choose to export in CSV or JSON.  

If you instead right-click on the word "Tables" or the schema name, you have a drop-down including the Table Data Import Wizard, but not the Table Data Export Wizard.  This feature request would add such an option there.

If choosing it, the Table Data Export window that comes up currently has a dropdown "Select source table for export" that allows only a single selection.  Below that you can select the columns from that table which you would like to export.  In the improved version, the drop-down would go away and in the "select columns" there would be a 2-level nested list of tables and columns.  

Checking an empty box next to a table would cause all its columns (in subsequent rows, and indented) to be selected; the user can subsequently remove some. 
Checking a checked box next to a table would cause it and all its columns to be unselected. 
Checking an empty box next to a column would cause it to be checked as well as the box next to the table it is part of.  

The user would then click Next.

If only one table is selected, the next page remains as-is, with CSV and JSON export options.  If multiple tables are selected, JSON is the only option and there is a note instructing the user to select only one table on the previous page if they want CSV export (OR we figure out a creative solution for CSV).  The previous page may also note that "For CSV export, only one table may be selected." 

The exported JSON then wraps each table (status quo single-table export) as the value of an entry whose key is the name of the table.  There may be multiple of these key-table pairs in the same top-level exported object.

If the Table Data Export wizard was opened by right-clicking on a particular table, by default only that table and all its columns are selected. 

How to repeat:
Open MySQL Workbench.  
Open a connection to a server with a database with data.
Right click on a table in the Schemas list notice the presence of the Table Data Export wizard.  Open and explore if desired.  Note that you can only export from one table. 
Right click on the schema name, or the word Tables, and notice the Table Data Export wizard isn't an option.
[21 May 2019 23:07] MySQL Verification Team
Please try version 8.0.16.
[22 Jun 2019 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[12 Dec 2019 20:49] Ben Towne
I am still observing this in the latest version, 8.0.18 build 15329599 CE (64 bit).
[12 Dec 2019 20:50] Ben Towne
Also, I am unable to change the status on the bug back to Open.  The same reproduction steps above still reproduce the bug though.