[Stacy Martin]

I, too, wish sqlyog had this functionality.

[Stacy Martin]

After further searching, I don’t think what I’m looking for is possible…  Perhaps support misunderstood what I’m looking to achieve, but it is exactly as explained in this forum post – which at last touch says it is not possible.

 

http://forums.webyog.com/index.php?showtopic=7519

[Stacy Martin]

Yes – as Sibin mentioned, Support did respond to a ticket created by me.  Outstanding.

 

They noted that SJA does have the option to export the tables to a local file!  Sweet. For notifications, there are XML notification files… so for exporting there is an XML export file.  

 

Unfortunately, It doesn’t appear the reporting wizard assisted in creating an XML export file. And I didn’t notice any sample XML export file in the SJASchemas folder. So I’ve asked for a sample to be provided and/or pointing to some documentation where I can create my own.  Since I have a better idea of what I’m looking for, there may also be some resources here in the forum I have come across yet.

 

Will keep thread updated in case others are interested in accomplishing the same.

[Stacy Martin]

'peterlaursen' wrote on '10:

Do you know if Excel can be started with the file to be loaded as a parameter? That would be a requirement. 

Besides it is not possible for us to know if user wants to:

1) open a new Excel program instance

2) Open a new sheet in an open Excel instance 

3) or paste after cursor position in current open tab in an open Excel instance.

Additionally we have to consider Linux/Wine and use of the file with other programs than Excel (most important Open Office Calc).

Yes – Excel can be loaded with a file loaded as a parameter.

If specific to exporting to Excel, option 2 followed by 1 is the proper behavior. At least on Windows, this would be similar behavior to double-clicking on Excel file. If an existing instance of Excel is already running, the same instance of Excel is used and the selected file is opened. If Excel is not running, it launches excel and opens the selected file. In this case, the excel file is essentially a temporary file of the SQLyog results.

But approaching this more generically to consider Line/Wine and other programs, perhaps the proper solution is a configuration setting for an external viewer. User selects export to external viewer, which launches the configured program and loads the temp file of the result set.

[Stacy Martin]

Hi Peter. I always appreciate the responses you provided here in the forum.

Specific to my report – As you can see from my history snippet, I was connected and performed a show databases by refreshing the Object Browser. I then let the program sit for over an hour before attempting to refresh the Object Browser again. When doing so, the program hung as described before, but I just let it sit there. Happily, it eventually timed out and returned control back to me allowing me to copy the History log info. You can see that after my long break, it took over 929,000 ms to reconnect (15mins?). Normally, I just assumed the process was completely hung and just manually killed the process.

/*[2:02:52 PM][ 16 ms]*/ show databases

/*[3:26:35 PM][929437 ms] SQLyog reconnected */

/*[3:26:35 PM][ 16 ms]*/ show databases

/*[3:46:00 PM][2094 ms]*/ show databases

/*[3:49:41 PM][ 16 ms]*/ show databases

As I mentioned, this happens regularly for me and others in my office. Is this a known issue, and is there anything I can do to resolve it.

Thanks

[Stacy Martin]

Thanks for the response Peter. To follow up on the first point a bit more…

peterlaursen wrote on Jul 12 2008, 11:59 AM:

1)

“I'm blocked from doing anything in the application until the current query returns. Or am I simply missing something.”

Both yes and no! To run multiple queries simultaneously you nned to create two connections (this cannot possible be changed as this is how a MySQL server and client communicate). No matter how many query tabs you open in SQLyog, they will all use the same connection. To open another connection (using same connection details) use the menu .. file .. new connection using current settings (keyboard shotcut: Ctrl + N). To display all connection use menu .. windows .. cascade. QB must be opening a connection for every tab.

You may be correct that QB is opening a connection for every tab, so I do understand that I can achieve a similar thing by opening a new connection.

Couple of issues with this approach, as I see it though

– if a query is currently running, the Keyboard shortcuts do not respond (using the Menu will still works though).

– it's not as easy to switch between your multiple queries quickly. Sure I can use Ctrl + TAB to toggle between the connections, but nothing beats the speed and simplicity of opening and using a new query tab.

– it becomes cumbersome to open a new connection if you are using the included SSH tunneling. Since with the SSH tunnel, you must specify a local port to use and the current implementation does not allow other connections to use this same port. You therefore can't open a new connection with the same settings, but must instead use an entirely new connection.

– This is more of a philosophical comment but – I'd be wary that novice users might be intimidated by the complexity such an approach brings, but is necessary in order to do launch a 2nd query while another one is running. You now have a model where you have multiple connections, each which might have multiple previously run queries, and potentially each query with multiple query result sets. Seems like there is the potential for people to get “lost” in the product.

Nonetheless, I'm finding SQLyog useful for my purposes and LIGHT YEARS better than MYSQL QB and the absolutely horrid SQL Maestro.

Cheers and keep up the good work.

[Author]

Posts