Bug #107897 Workbench 8.029 hungs upon importing data
Submitted: 15 Jul 2022 23:15 Modified: 20 Jul 2022 10:39
Reporter: Pablo Rodriguez Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.029 OS:Windows (11)
Assigned to: CPU Architecture:Any (x64)
Tags: CSV File, Import/Export, table

[15 Jul 2022 23:15] Pablo Rodriguez
Description:
There is a new UI and the options for importing are not in the same place, after you create a table you can't import the data to the table, nothing happens upon clicking the import icon on the toolbar of the inserts panel. So, you have to set up the columns first and after you have them it reacts and lets you chose the csv file from which it has to take the information.

Selecting a CSV file gives you a blue circle indication that is working but no progress bar nor indication of actually been working on the data. I opened the file on a notepad 2 times and it does have a similar afterwork it does hang for a little while, about 15 seconds in order to display the information correctly, on the software once it does load the file it should react and show the progress of the import or the issues if it finds any.

After about 5min the screen becomes white with (not responding) sign on the title bar, you have to manually close it.

How to repeat:
You can find the csv file online at www.servel.cl site <a href="https://www.servel.cl/wp-content/uploads/2017/11/PADRON_NACIONAL_2017.zip">here</a>, it does not read how many lines of that the file has, nor the fields by line. So it looks like the import and export functionality is worst than on previus versions.

Suggested fix:
A better import wizard, that lets you import files from the web, and zipped, that reads the number of lines and detect any concerns about it, that can handle creating a table with the data reading the type of content in each field and that has a manual and auto function to detect if the line is terminated with something or just a break line, same for enclosures of fields and column separation. Basic stuff but that are use constantly.
[16 Jul 2022 20:59] Steven Dorsher
I'm having the same problem with MySQL Workbench. The version is 8.0.29 and the platform is Windows 10. I load the data and the progress bar stalls at zero with the two circles filled and no data loaded after a few minutes. I am loading about 136519 rows and 8 columns. I eventually cancel. 

Error message is
Cannot access a disposed object. Object name '_ProgressBar'

I was exploring the use of this software due to difficulties using BigQuery in a Coursera Google certificate course in data analytics. However, it is important to me to have SQL software that allows me to use CSV files whether or not I complete this Google Certificate because I had the long-term intention of doing some science on my own-- I have a background in both programming and physics and with the right software this should be possible. Current workaround is using Kaggle-- I realize this is not exactly a software solution.
[16 Jul 2022 21:19] Steven Dorsher
I was successful in uploading a table with 19 columns and 12 rows. This one uploaded quickly, the progress bar displayed correctly, and I now have a small amount of personal data I would like to analyze in my database. I was not able to use datetime format for dates and times taken from Google Docs and exported to a csv. I used text.
[18 Jul 2022 11:54] MySQL Verification Team
Hello Pablo Rodriguez,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with workbench 8.0.29 using csv file provided by using "Table Data Import Wizard" but I am not seeing any issues at my end.
Could you please provide steps to reproduce this issue at our end?

Regards,
Ashwini Patil
[19 Jul 2022 3:17] Pablo Rodriguez
Thanks for answer, I tried to find the "Table Data Import Wizard" with no luck. The File toolbar -> "Import" only shows Reverse Engineer MySQL Script" and on Database there is another import but for schemas. Using contextual right click on the table section of the schema only shows disabled options cut, copy, paste. That’s why I was only left with the button "Import records from external file" on the insert panel of a new table, that only works if you have previously created the fields. Maybe the Wizard does it ok but I haven’t been able to find it.
[19 Jul 2022 6:49] MySQL Verification Team
Please see the screenshot below to find "Table Data Import Wizard"

Attachment: 107897_test_results.png (image/png, text), 209.21 KiB.

[19 Jul 2022 15:58] Pablo Rodriguez
You are using a different version of the software, on this one that panel is not there anymore, i did find a catalog tree as you show on the Model Diagram (Model Overview -> Catalog Tree) but when you right chick on the Tables it pops a contextual menu without any selectable options, see the <a href="https://photos.app.goo.gl/2WYSMGjtNGetfQiKA">screenshot</a>
[20 Jul 2022 10:39] MySQL Verification Team
Hello Pablo Rodriguez,

Thank you for the detailed feedback.
Verified as described.

Regards,
Ashwini Patil
[20 Jul 2022 10:42] MySQL Verification Team
8.0.29 test results

Attachment: 107897_notresponding.png (image/png, text), 227.62 KiB.