MySQL Bugs: #72966: Detect upon Import Session restoring if connection does not exist and prompt for

Bug #72966	Detect upon Import Session restoring if connection does not exist and prompt for
Submitted:	11 Jun 2014 23:51	Modified:	30 Jun 2014 21:29
Reporter:	Javier Rivera Zavala	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S3 (Non-critical)
Version:	1.3.0	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
When a Workbook containing ImportSessions is opened the serialized connections are recreated and if not found the sessions are flagged to be deleted automatically.
In order to support cases where a Workbook is opened in a different computer than the one containing the connections file, MySQL for Excel should prompt the user upon finding that a connection does not exist locally that the connection is not found and give him the option to create the connection at that point of time.

Since several ImportSessions may be restored when a Workbook is opened, the code must do the stated above for each connection being restored.

How to repeat:
How To Repeat:
1. Open Excel, click Data Tab in the ribbon and click MySQL for Excel Icon to
open the plugin.
2. Double click a connection and schema.
3. Select any table (click over it) and click the import button on the
current panel.
4. Click import button on the current dialog, change some cells values to
verify the refresh doesn't take place at step 6/7.
5. Save the workbook and close excel.
6. Open workbench and delete the connection the import session was created with.
7. Reopen the workbook.

Suggested fix:
When a Workbook with stored import sessions is reopened, ask to reissue a connection for each import session which connection is missing.

Posted by developer:
 
When the user has created Import Sessions and saved the workbook, the connection these sessions are linked to can be deleted. When the workbook is reopened, these sessions
  had no way to be used any further. Now, a new dialog was created to prompt the user to create a new connection to replace the old one not found and be able to continue working 
  with the same sessions afterwards.

Posted by developer:
 
Fixed, checked using mysql-for-excel-commercial-1.3.1.

Fixed as of the upcoming MySQL for Excel 1.3.1 release, and here's the changelog entry:

A new dialog was added when a saved Excel workbook is opened that contains
saved session (connection) information. This new dialog prompts to either
edit or delete MySQL connections that no longer function. Before, it was
only possible to delete these connections.

Thank you for the bug report.