ois wrote:Is it possible to have the workpad contents go into mysql in a report generating kind of way?
Not directly but it would be possible to jury-rig something up.
For example, 2.4.2 introduced the ability to run a command after a report has been generated so you could write a template that exported the workpad contents to, say, XML, then write a script that imported that XML content into MySQL.
It would even be possible to use the MySQL channel hook to do this. When it calls channel hooks, Awasu generates an INI file with all the relevant information and then runs the channel hook with the path to that INI file as its argument. So, you write a template that exported the workpad content to an INI file, then configure the report to run the hook after it has been generated. The hook won't know that it is being called because a report has been generated rather than the usual "new content has arrived" event and will do its usual thing of importing the content into the database.
Alternatively, 2.4.2 also introduced HTTP calls that allow workpad content to be retrieved so you could set up a cron job that called that and imported the content into the database.