Time  Nick   Message
13:13 kyle   hey all, is anyone versed in Zebra around?
13:18 hdl    hi Kyle?
13:18 hdl    Maybe I can help.
13:22 cm     kyle:  john wants to meet with us at 1:00.
13:24 hdl    kyle: ?
13:39 cm     kyle, paul fixed that $1/$i thing in rel_2_2 about a month ago, so it really is a typo.
13:48 kyle   hdl, you still around?
13:48 hdl    yes
13:48 kyle   do you know much about zebra?
13:49 hdl    Not much but more than the simple newbie.
13:50 kyle   I wrote a script that deletes biblios that have no items, but sometimes when it attempts to delete a biblio I get this message:
13:50 kyle     message: error:  224 ES: immediate execution failed
13:50 hdl    how do you try and delete.
13:50 hdl    There is a special process for delete.
13:51 kyle   using DelBiblio
13:51 hdl    You have to get the record and then delete.
13:51 kyle   check out the file scrub_orphaned_biblios.pl
13:52 hdl    paul : you fixed a problem in Delbiblio didnot you ?
13:52 kyle   I'm passing it the required parameters, and for many biblios it deletes just fine.
13:58 owen   kyle: we get a similar error when we try to delete records which have a corrupted MARC record. kados could supply you more information
13:59 owen   We end up having to manually delete the information from biblio, bibliosubject, biblioitems, etc.
13:59 kyle   that's fun ; \
14:00 cm     i wouldn't be surprised if we have some corrupted records...kyle, can you tell which record it's choking on?
14:01 owen   Yeah, we have a list of about 700 records which are "bad." They're things that will still circulate fine, but they're not searchable.
14:01 cm     probably something is missing from the marc that zebra needs for indexing.
14:02 cm     we've had problems manually adding records if we forget to add indicators to the title and such.
14:02 kyle   cm: run the copy of scrub_orphaned_biblios.pl from cgi-gin, it will give you the biblionumber of the biblio being deleted right before the message.
14:02 cm     ok.
14:05 owen   biblioitems.marc and biblioitems.marcxml are NULL
14:09 cm     i'm looking at one of our undeleteable ones and marcxml is null but there is data in marc.  I don't know if it's correct, though.
14:10 cm     kyle, it looks like it's especially choking on the more recent additions to the db.
14:10 cm     hope it's not from our marc import script.  :(
14:11 cm     there were only 4 or 5 from the earlier section of the database.
14:22 paul   what would it mean exactly kyle ?
14:22 paul   (what kind of features could it involve ?)
14:24 kyle   Here, we have summer reading clubs at the libraries to encourage kids to read over summer break. Basically, it would just involve have a readinclubs table, and another table to connect a borrower with a given reading club.
14:24 kyle   basically, it would only really be used for generated statistics about reading clubs, participation, comparisons between libraries and/or different years
14:25 kyle   I already have a simple one made, it involed putting a column called summerReadingClub in the borrowers table, and setting it to 1 or 0
14:26 kyle   I would like to build something a *bit* more extensible than that ; )
14:27 kyle   I can either write it as part of koha-tools, or integrate it into koha. The latter would be far more work, and if nobody would find it useful, it would be better to have it as an add-on anyway.
14:39 hdl    kyle maybe it could get integrated with a kind of borrower groups or service subscription.
14:40 kyle   ?
14:40 hdl    we would have a table of services provided by library that borrowers could subscribe to.
14:42 kyle   I think I follow.
14:42 hdl    and a field in borrowers listing all the service they subscribed to.
14:42 hdl    Could also be useful to have kind of group managing
14:43 kyle   you would need a seperate table to connect borrowers to services, but I get it.
14:44 hdl    Would a simple field in borowers table not be enough, separating services by comma ?
14:45 kyle   it would work, but database-design-wise it would be a poor choice.
14:46 kyle   it would be much better to have a table called 'servicesSubscribedTo' with columns for borrowernumber, servicenumber, and any other extra data needed.
14:49 paul   kyle++
14:49 kyle   columns for dateEnrolled and dateCanceled would be good to have as well.
14:49 kyle   thanks paul.
14:50 kyle   ; )
15:04 rch_   kyle: i like the 'extensions' approach.
15:04 rch_   it would be good to define a standard way of doing that in koha
15:04 rch_   with a nice one-click install that adds extra tables, etc.
15:05 hdl    Could be integrated to webinstaller or extension tools just as in any php apliance.
15:06 kyle   I agree, a 'plugins' system would be a great boon to koha. It wouldn't be easy though, because adding features would require replacing template files, and that means one would need to write replacement templates for all available sets and languages.
15:07 kyle   but I'm sure we could figure something out.
15:07 rch_   in many cases one could simply add a tmpl_include ?
15:07 rch_   but yes, it would surely be easier to build directly into koha :)
15:08 kyle   true, we could add hooks to each page that would call a function embedded in each plugin, and the plugin can decide if it should display something.
15:08 kyle   rch, indeed.
15:08 kyle   For a good example of a plugin system, trapse through the codebase of wordpress.
15:08 rch_   yep... wordpress++
15:08 kyle   A good plugin architecture is built into the system from the ground up.
16:51 spooty i've got a koha metadata question.  anyone around?