MySQL Bugs: #115754: MySQL for Excel

Bug #115754	MySQL for Excel - Page Not Found
Submitted:	2 Aug 2024 17:31	Modified:	23 Apr 12:32
Reporter:	Jagan Lat	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Accessing the below link, we are getting page not error:
https://www.mysql.com/why-mysql/windows/excel/
or
https://dev.mysql.com/doc/mysql-for-excel/en/

How to repeat:
Issue: Connecting the mySQL Workbench (Ver 8.0.38) via excel add-in (Ver 1.3.8), we receive an exception "Connection attempt failed. The given key was not present in the dictionary."

In an intention of finding a solution, We found the source code of the mySQL workbench mySQL Workbench excel add-in, we found the below content in the Read me file present in "mysql-for-excel-1.3.8-src.zip" file.

For more information on MySQL for Excel visit
https://www.mysql.com/why-mysql/windows/excel/
or
https://dev.mysql.com/doc/mysql-for-excel/en/

Accessing above page, we are getting page not found error. It would be helpful if you provide the mySQL Workbench excel plug in documentation, we may try to resolve the issue we face.

Hi,

Have you tried to see whether it is on this link:

https://dev.mysql.com/downloads/windows/installer/8.0.html

It should be there ......

Thanks for reply. Link you have doesn't have the required documentation info.
Kindly understand that we need a documentation on the existing mySQL workbench for excel from a developer/debugging perspecitve. It looks like it existed in the past.

We have the details about how to use the mySQL workbench excel add-in as per below link.
https://downloads.mysql.com/docs/mysql-for-excel-en.pdf

Background: As stated in the original bug, we are unable to connect the mySQL Workbench via mySQL excel plug-in. We found out the source code being exposed in the portal. We started to open the code, we have seen huge error messages listed below:

1) "MySQLForExcel.sln" exception:

Severity Code Description Project File Line Suppression State

Error Couldn't process file Panels\WelcomePanel.resx due to its being in the Internet or Restricted zone or having the mark of the web on the file. Remove the mark of the web if you want to process these files. MySQL.ForExcel

Error Couldn't process file Forms\ManageConnectionInfosDialog.resx due to its being in the Internet or Restricted zone or having the mark of the web on the file. Remove the mark of the web if you want to process these files. MySQL.ForExcel

Error Couldn't process file Forms\AppendDataForm.resx due to its being in the Internet or Restricted zone or having the mark of the web on the file. Remove the mark of the web if you want to process these files. MySQL.ForExcel

Error Couldn't process file Panels\DbObjectSelectionPanel.resx due to its being in the Internet or Restricted zone or having the mark of the web on the file. Remove the mark of the web if you want to process these files. MySQL.ForExcel

Error Couldn't process file Forms\ImportMultipleDialog.resx due to its being in the Internet or Restricted zone or having the mark of the web on the file. Remove the mark of the web if you want to process these files. MySQL.ForExcel

Error Couldn't process file Panels\SchemaSelectionPanel.resx due to its being in the Internet or Restricted zone or having the mark of the web on the file. Remove the mark of the web if you want to process these files. MySQL.ForExcel

Error Couldn't process file Controls\ExcelAddInPane.resx due to its being in the Internet or Restricted zone or having the mark of the web on the file. Remove the mark of the web if you want to process these files. MySQL.ForExcel

Error Couldn't process file Forms\ImportTableViewForm.resx due to its being in the Internet or Restricted zone or having the mark of the web on the file. Remove the mark of the web if you want to process these files. MySQL.ForExcel

2) "ExcelCustomAction.sln" Exception: mysql-for-excel-1.3.8-src\ExcelCustomAction\ExcelCustomAction.csproj : error : The imported project "C:\Program Files\Microsoft Visual Studio\2022\Community\MSBuild\Microsoft\WiX\v3.x\Wix.CA.targets" was not found. Confirm that the expression in the Import declaration "C:\Program Files\Microsoft Visual Studio\2022\Community\MSBuild\Microsoft\WiX\v3.x\Wix.CA.targets" is correct, and that the file exists on disk. ...\mysql-for-excel-1.3.8-src\ExcelCustomAction\ExcelCustomAction.csproj

3) Installer.sln - not loading as it displays "Setup incompatible"

What we actually look for is that, a complete documentation on the features which will help us to solve the on-going connectivity error message. We thought of fixing the error message in the source code could be easy but it is bit complicated than what we perceive. I am not if there is going to be an updated fixed version for mySQL Worbench for excel is going be available soon, for years together we haven't found such.

If my above explanation of my issue and requirement is not clear, kindly let me know so that it helps many who face this issue.

Hi,

Have you tried this URL:

https://dev.mysql.com/doc/workbench/en/

With reference to the solution provided on 05th August 20204, we went to the page link https://dev.mysql.com/doc/workbench/en/, which contained only the high level information about the mySQL Workbench installation and so on. If there is any team which had developed the mySQL Workbench excel add-in, it would be helpful to reach accordingly. 

Again to re-iterate the issue, we want the content which was available then mentioned in the below link present in the README file within the source code.

https://www.mysql.com/why-mysql/windows/excel/

Can you please help us to fix this?

Hello Jagan,

Thank you for the details.
Imho this is duplicate of Bug #111698, please see Bug #111698.

Regards,
Ashwini Patil