Another poster session – some interesting stuff this time from Budapest and Berlin. They are using php and SQL to produce web based reports. They’ve created a structure so that you can easily extend the available reports.
You first define a form for variable input, and then the SQL – using the entered variables where appropriate. This makes for an extendable system, without requiring detailed knowledge of php – and results can be output in html, excel, csv etc.
Perhaps just as interestingly for us is that they’ve used an open source package called ‘ahk’ (auto hotkey), to allow for easy movement between the results of these reports and viewing related information in the Aleph client. We might be able to use something like this to enhance our ‘liaison dashboard’ – which is an application built with MS Access and ODBC to Aleph to allow display of information not easily available in the Aleph client (or at least not on a single screen).
Done by Nagy Elemer Karoly from Budapest and Leo Krauthausen from Berlin (eknagy at omikk.bme.hu, krauthausen at ub.fu-berlin.de)