MySQL Bugs: #83801: MySQL for Excel - Ignore duplicates option

Bug #83801	MySQL for Excel - Ignore duplicates option
Submitted:	14 Nov 2016 7:23	Modified:	3 May 2017 23:52
Reporter:	Rommel Asibal	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S4 (Feature request)
Version:	1.3	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	Excel

Description:
Please add an option to ignore any duplicates (existing rows) from data you might have already imported into mysql from excel.

Would also be great if the said duplicate rows would be noted in a log file.

This would most probably be put in the "Append Data to Excel" advanced options.

If you have to import alot of excel data this would be very useful as when you cut up the excel files there is a tendency to have duplicates in excel through careless user mistakes.  Debugging excel files removing duplicates is a big load of unhappiness.

How to repeat:
Append Data to Excel using data you have already imported.
You will get an error message.

Suggested fix:
Skip over duplicate data and create a log file with the row numbers or PK values of those rows.

This is indeed a very good enhancement request.
Thanks for the submission, this will be in the next version.

Posted by developer:
 
Added new options to the Advanced Append Data Options dialog to choose the behavior for rows containing unique key values that are duplicates of the ones in the rows in the database.
The options are "Error out and abort the append operation", which behaves as previous versions of MySQL for Excel where the server returns an error if any duplicate unique key values are found; the second option is "Ignore rows with duplicate unique key values", which causes rows containing duplicate values for unique keys to be ignored or skipped, and only the rows without duplicate values are inserted to the database; the third option is "Replace the values in the old rows with the ones in new rows", which causes rows containing duplicate values for unique keys replace the values of the corresponding rows in the database.

Posted by developer:
 
Fixed on 1.3.7 build 2

Posted by developer:
 
Fixed as of the upcoming MySQL for Excel 1.3.7 release, and here's the changelog entry:

The Append Excel Data to Table operation was updated with new advanced
options to manage the behavior of rows containing unique key values that
are duplicates of those in the database.

Thank you for the bug report.