Joomla SQL 2 Excel Replacement
Some months ago, almost a year I think there used to be a really ripping piece of software called SQL2Excel that was provided by Joomla R Us. It appears that this site has been down for a while, so I decided I would try to come up with a replacement that gets around some of the limitations.
SQL2Excel, allthough a great product, lacked the ability to handle large datasets. I am sure that some readers may be familiar with issues opening the generated excel files because of a hard truncation of the data due to processing limits exceeded on the server, or timeout by the browser, or server or some combination.
What is actually happening here is that the server is actually killing the connection, or if the server process lifetime is increased, the browser is killing the connection. This is to aid in keeping responsive systems and to prevent the ability of malicious users to open connections and hold them open for an indiscriminate amount of time to perform a DOS attack. The specific details of this are not necessarily 100% accurate, but one could see the potential issue if there were no limit, especially if there was a runaway process that doesn’t come back.
I have devised a way to break up the calls to excel and format them into a json style formatting that is easily parsed and still protected via password. The technique is actually programmed into an excel addin, that when installed adds an additional ribbon which when clicked allows the user to log in, and peruse the database tables, and export the tables to excel. At this point, there is no joining or direct sql, and there is hope that I will be able to add syncing to the mix. Also, there is a joomla component to install, or things simply won’t work.
If you are interested in this technology, since this is pretty much alpha software at this point with no necessarily big chance at Beta or Release unless there is interest.
email: ttessier at swhistlesoft.com if you are interested in this project.
Copy the excel files into:
Create xml file Settings.xml:
<?xml version="1.0" encoding="utf-8"?><root><host>example.com</host><base></base></root>
Swhistle Soft Downloads: SQL2Excel Sync