A new version (1.1) of the Database Query plugin is now available. The new functionality and changes are: - Corrected Composer/Conductor roles which were switch in Artists query - Added "Number of" column to all "Inconsistency/Problems" queries - Added possibility to show years and artists in "Albums" query. - Added support for clickable queries, as an example this makes it possible to click an a problem in the "Inconsistency/Problems" query and see exactly which tracks/artists the problem is related to. - Added "Structured XML" export module which allows you to export a hierarchical XML document. For example a XML document that lists all artists and for each artist lists its albums and for each album its tracks. - Added "Free form query" which makes it simple to write a custom query using a SQL statement of your choice - Added Edit link on top of result page to make it easy to adjust query after you have viewed the result. - Added Execute button in bottom of page when editing the attributes of a query, very usable in the new "Free form query".
If someone is good at writing XSL transformations, please try to use the new "Structured XML" export together with a XSL transformation to create nice graphical reports of the SlimServer database contents. The "Artists" query is probably a good query to do the export from since the XML document then will contain all artists, albums and tracks in the SlimServer database. NOTE! - It only works on slimserver 6.5.* - I've only tested it on Linux, but I'm pretty sure it should work on Windows too. - At the moment my intention is not to develop this plugin any more besides bug fixes and my own needs. So, if anyone finds it useful for something, please let me know and I will reconsider if I should enhance it with more features. You will find the plugin at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming Multi Library releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-databasequery If anyone tests this plugin I would appreciate some feedback about how it works and wishes for new features and improvement of existing features. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and RandomPlayList plugins' (http://wiki.erland.homeip.net/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=37633 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
