Thursday started with a demo of Web Reporter from Phil Coles – here’s my notes from the session:
- 140 reports supplied as standard
- reports processed on the Web Reporter server, using live data from the Horizon database (i.e. no data mining)
- reports can be scheduled to run overnight
- reports can be exported as PDF, Excel, CSV, etc
- new reports can be created from scratch, or you can use one of the existing templates
- current version of Web Reporter is not Unicode compliant, however the Horizon 8 version will
- no knowledge of SQL required
- handles non-January financial years
- SQL can be imported from ReportSmith
This was followed by a presentation from Eric Keith (VP Operations, SirsiDynix US) about the company’s current and future developments – my notes from the session are available here.
Finishing off the morning sessions, Polly Dawes (Bradford), and Ian Haydock & Jan Broad (Staffordshire) ran a session about Telecirc – including a live demo via mobile phone! We’re hoping to finally get Telecirc running live at Huddersfield by the start of the new term.
Starting off the afternoon, Phil Coles gave a short presentation about HIP 4 and Horizon 8 before attempting a live demo – unfortunately technical gremlins caused one or two problems with the demo. Here’s my notes about HIP 4:
- works with Java v1.4.2, although Dynix are currently testing it with more recent releases of Java
- allows pickup locations, search types, limits & sorts, and search location defaults to be set
- built in spell checker and thesaurus
- borrower history display
- list of new and/or top circulating items
- tighter integration for consolidated searching
- Lucene indexing/search engine
…and about Horizon 8.0:
- FRBR support
- MFHD (MARC Format for Holdings Data) support
- e-commerce integration
- Electronic Resource Management (ERM) module
- one-click sorting of colums
- more integration between Horizon 8.0 and Web Reporter
- new acquisitions workflows available
- notes fields are all 1,500 characters (although Phil thought this can easily be increased if required)
- EDI functionality built into Horizon (i.e. no need to use separate FTP software)
- graphical serials prediction
This was followed by “Moving to MARC21”, with Ray Delahunty (Dynix UK), Polly Dawes (Bradford) and Ian Jennings (Huddersfield). It highlighted the two extremes of converting to MARC21 – Bradford had very few problems running the conversion under Dynix ILS, but the Huddersfield conversion (under Horizon) was a long and fairly painful process! Hopefully future conversions under Horizon will be much smoother.
The last session of the day was “My Favourite SQL” with Tim Fletcher (Birkbeck) and myself. I’ve uploaded my presentation (“Using SQL to Create Web Based Reports & Applications”) here. I’ll upload the advance notices Perl script as soon as I’ve finished debugging and documenting it.
Towards the end of the session, Anders Fåk (Linköping University) gave a quick demonstration of their web based reports (which uses Microsoft .Net and Crystal Reports) – very impressive stuff!