[Koha] Academic users: Integration with Banner (2nd try)

I didn't get any responses to my question about Banner a few weeks ago, so I'm trying one more time. Has anyone out there successfully integrated patron records from their Koha system with the college's Banner system? If your library has found a way to interface with Banner, how do you do it? Are

Re: [Koha] Report for holds count by bib record & branch

Do you need the item type just so you can tell AV from print, etc? If so, you might be able to get it via an ExtractValue: ExtractValue(biblioitems.marcxml, '//datafield[@tag=“942"]/subfield[@code=“c"]')) AS “item type” It would be different for 17.05 and newer, which may require some fiddling.

Re: [Koha] Report for holds count by bib record & branch

Hi, all -- Did some more testing & it appears that Item Type information is not available when holds are placed for the Next Available item. Can't think of an easy work-around as it's entirely possible to have items attached to the same bib with different item types. Cheers, Cab Vinton Plaistow

[Koha] Report for holds count by bib record & branch

Hi, All -- I'm trying to create a report that will give me hold counts broken down by bib record and the patron's branch. I believe what I have is pretty close, but some of the output omits the item type information. This is what I have: SELECT count(borrowers.branchcode) AS Holds, borrowers.br