MySQL Bugs: #84033: Importing data into MySQL workbench

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:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.8	OS:	Windows (Microsoft Windows 7 Enterprise Service Pack 1)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[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.

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?

Thanks,
Chiranjeevi.

Screenshot

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

Screenshot

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

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)

screenshot

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

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

Thanks,
Chiranjeevi.

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.