Bug #84033 Importing data into MySQL workbench
Submitted: 1 Dec 2016 22:42 Modified: 5 Dec 2016 14:33
Reporter: Salathiel Vann Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.3.8 OS:Microsoft Windows (Microsoft Windows 7 Enterprise Service Pack 1)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[1 Dec 2016 22:42] Salathiel Vann
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\savann\AppData\Roaming\MySQL\Workbench\log\wb.log]

I am trying to import an excel spreadsheet into an existing table. When I click import and finish, it says the import was completed successfully without errors, etc.  however, it also says that 0 records were imported. 

I would attach e the log file, but not sure what part you will need as it may have other information not pertaining to this...

How to repeat:
Using the import wizard to import an excel spreadsheet, use the import wizard, import a table using semi-colon as a separator (telling windows to use semi colon, by going to the start menu and typing in region/language then advanced settings to set it).  From there, import your spreadsheet and map the appropriate columns to match the spreadsheet and columns in the database table.  Once done, click import and finish.
[2 Dec 2016 6:24] Chiranjeevi Battula
Hello Salathiel,

Thank you for the bug report.
I could not see any issues in  import an excel spreadsheet into an existing table using MySQL workbench 6.3.8 version.
Could you please provide repeatable test case (sample cvs file , create table statements etc. - please make it as private if you prefer) to confirm this issue at our end?

[2 Dec 2016 6:24] Chiranjeevi Battula

Attachment: 84033.JPG (image/jpeg, text), 48.24 KiB.

[2 Dec 2016 6:25] Chiranjeevi Battula

Attachment: 84033_1.JPG (image/jpeg, text), 33.42 KiB.

[2 Dec 2016 14:29] Salathiel Vann
I have attached a screenshot of the 'configure import settings'.  I noticed your view is different from mine.  I don't have the other options like you (ex. line separator...lf and so on)
[2 Dec 2016 14:30] Salathiel Vann

Attachment: testpic.png (image/png, text), 12.22 KiB.

[5 Dec 2016 10:16] Chiranjeevi Battula
Hello Salathiel,

Thank you for your feedback.
I could not see any issues with data importing using an existing table with WB 6.3.8 version.
User manual for data Importing https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html

[5 Dec 2016 14:33] Salathiel Vann
Understood.  However, is there any reason why I don't have the other options like you do on the configuration view ( ex. line  separator. field separator). Just want to make sure that this does not have an effect on my issue.