Time  Nick      Message
17:32 nengard   after I claim a serial shouldn't it's status be updated to Claimed? or do I have to do this manually?
15:55 hdl       marcxml is parsed. But only after MARC::File::XML parsed it.
15:54 gmcharlt  hdl: right, but assuming that the record is being read from the database, either bibiloitems.marcxml or biblioitems.marc must be parsed
15:53 hdl       It takes a MARC::Record
15:53 hdl       gmcharlt acmoore : it doesnot at the moment.
15:22 gmcharlt  ?
15:22 acmoore   holy cow.
15:22 gmcharlt  acmoore: it should be
15:21 acmoore   just out of curiousity, is this thing parsing the biblioitems.marcxml field?
15:21 acmoore   OK, thanks. I think I can embrace and extend this.
15:14 acmoore   cataloguing/addbiblio.pl?
15:13 hdl       Then getting the results.
15:13 hdl       Then parsing the bib with tagslib (the result of GetMarcStructure)
15:12 hdl       It details getting the whole bib.
15:12 hdl       acmoore: see add_biblio.pl
15:12 hdl       But It would be better if it could be cached for a session lifetime... If structure is not edited.
15:11 acmoore   so, the marc_subfield_structure table does tell me about the authorised values, but how do I know what authorised values are set for this biblioitem I'm looking up?
15:10 hdl       gmcharlt++
15:10 gmcharlt  but yeah, that's a digression
15:09 gmcharlt  hdl: true; my point it is (assuming it's working properly) the DB lookup from marc_subfield_structure and marc_tag_structure is done only once during a CGI script's lifetime
15:08 hdl       gmcharlt: but we are talking of display, not batch jobs
15:07 acmoore   I'll have to look at that. It's possible that's going to do what I'm looking for.
15:07 gmcharlt_ hdl: it is cached, partially, at least as far as batch jobs are concerned
15:05 hdl       (Maybe it would be better if we cached it... But for now, it is not cached.)
15:04 hdl       hash
15:04 hdl       returns the has of your framework.
15:04 hdl       &GetMarcStructure
15:03 acmoore   what table was that?
15:02 hdl       and parse the record.
15:02 acmoore   hdl, well, not quite. So that tells me about a particular autorised_value. But, it doesn't tell me what value is set for that authorised_value for a particular biblioitem
15:02 hdl       you just have to use the tagslib table
15:01 acmoore   aaah. thta's what I was looking for.
15:01 kados     hdl: suppose we create a new authorized value called 'audience' and we link it to 942 $l (which is not used), and 942 $l is not linked to the biblioitems or biblio tables ... how do we get the authorized value to display in the results page?
15:01 hdl       In gets the lib value of an authorised value.
15:00 hdl       In Biblio.pm
15:00 acmoore   what's GetAuthorisedValueDesc?
14:59 hdl       you have GetAuthorisedValues and GetAuthorisedValueDesc .
14:58 hdl       Why ?
14:58 kados     it's complicated
14:58 hdl       No would not.
14:58 kados     for records that have authorized values linked to the MARC, but that don't exist in the koha tables
14:57 kados     oops, on the results page
14:57 kados     hdl: but we're trying to figure out how to display authorized values on the bib page
14:57 hdl       :P
14:57 kados     hdl: acmoore just added a picture path to authorized values
14:57 acmoore   I intend to add a path to an image to authorised_values. will that pose a problem?
14:56 acmoore   I don't think I understand the problem you're describing.
14:56 hdl       mmm... quite a dangerous change, imho...
14:55 hdl       we could add picture path to authorised_values
14:55 hdl       with this system, we would have to query much more.
14:54 hdl       Now with Koha for 1 bib, you have 1 record (in a join)
14:54 hdl       problem
14:54 acmoore   hdl, I think you and I are picturing the same thing.
14:52 hdl       am i wrong ?
14:52 hdl       1 containing the values...
14:52 kados     acmoore: typically a library will create a MARC record for their bib data, and import it into Koha ... or create it within Koha's MARC editor
14:52 hdl       1 describing the added fields
14:52 hdl       there ought to be 2 tables
14:52 kados     acmoore: the workflow for how these records are added is probably important background
14:51 kados     acmoore: is it stored in the catalog record somewhere?
14:51 kados     acmoore: yes, I get how it works on the database end of things, but how about for the user ...
14:51 hdl       (you can add custom fields to user data)
14:51 acmoore   but surely we have one of these already in our database. It's not a far out concept. I'll look.
14:50 acmoore   I have no idea what drupal does.
14:50 acmoore   so, if I were to add a new authorised value for "smell", I don't add a biblioitems.smell column, I start adding rows to this table like "item #123 has value 'flowery' for authorised_value 'smell'"
14:50 hdl       acmoore: would it be quite like it is done for users in drupal ? link to a bib in a table and custom names ?
14:49 acmoore   let there be a table with biblionumber and authroised_value_id (and probably a few other columns). Then, if biblionumber "green eggs and ham" has a "Juvenile" set for "audience", you can make an entry in that table, instead of having a new column in the biblioitems table for "audience".
14:48 kados     I'm just trying to figure out how the user would indicate that a given bib should be linked to, say 'JUV' audience
14:47 kados     can you expand on that for me?
14:46 acmoore   because, you can do that with another database table, instead of adding columns each time.
14:46 acmoore   when you say that another option would be adding collumns to the biblioitems table, do you mean adding a column for whatever arbitrary authorized value that an installation may define?
14:45 kados     acmoore: a lookup table for what now?
14:45 kados     acmoore: they have rules that I think I forwarded to you and Debra
14:44 kados     acmoore: is that folks like HCL actually use the call number to determin which items show up at the bib level
14:44 acmoore   or adding a lookup table for them, so you don't have to add a column for each one.
14:44 kados     acmoore: another thing I discovered
14:43 kados     other option would be adding columns to the biblioitems table for things like format, audience, etc.
14:43 kados     koha.icons or something
14:43 kados     or else we could come up with a new namespace or something
14:43 kados     acmoore: it's not pretty though, because we'll have to hard-code some tag/subfields in the resulting XSL
14:42 kados     acmoore: so maybe we could add the images at that point
14:42 kados     acmoore: the XSl work I did does a preparse of every MARCXML record as it comes back from the index, and substitutes authorized value descriptions for codes
14:40 kados     for items it's easier since all of the item fields are linked to database fields and items table is authoritative for them
14:39 acmoore   yep, I'm with you. the ones with actual database fields are much easier.
14:39 kados     there's no easy way to display the values for records that have a value there
14:39 kados     so that audience example we did yesterday for example
14:39 kados     )
14:39 kados     (in the relational database0
14:39 kados     acmoore: displaying authorized values in the search results pages is going to be especially hard ... extra hard if there is no koha2marc linking the marc field to a koha field
14:38 acmoore   these words are hard to use.
14:38 acmoore   but, it doesn't seem to know anything about items. I thought that an item may have an actual value for a possible authorized value.
14:38 kados     ahh, you may be right
14:37 acmoore   I think that finds which authorized values exist in a category.
14:37 acmoore   I thought so, too, but that doesn't seem to do what I thought it did.
14:36 kados     acmoore: GetAuthorisedValues in Koha.pm I think
14:35 acmoore   is there a function that will fetch the values of arbitrary authorized values for an item (ie, ones that aren't tied to database fields)?
14:12 nengard   manual question - will biblios automatically be integrated into koha 3? or will it require additional installation steps? I'm asking so I know if I have to write a how to integrate step in the manual
12:56 hdl       Del and Add.
12:56 hdl       because ModBiblio does
12:54 kados     edit should be specialUpdate, not sure why it does recordDelete
12:54 hdl       Not worse but same problem
12:52 hdl       So you end up in zebraqueue with 1 recordDelete and 1 specialUpdate (because when you edit things, you index the record only once... no checking done when you delete...  maybe if one would edit a biblio and then delete it it would be even worse.)
12:49 hdl       kados : recordDelete because when you edit, you 1st delete.
12:48 hdl       It justs commits elements to database once rather than committing it each time.
12:48 hdl       NoZebra could also be commited I think.
12:47 hdl       It is one of our customers that asked for that.
12:47 hdl       I think that recent acquisition pages could be added.
12:46 kados     hdl: what should I do with these?
12:46 kados     hdl: and    NoZebra : Commiting things only when done
12:46 kados     hdl:    Adding Recent Acquisitions page
12:46 kados     hdl: I have two patches from you that I'm not sure about
12:43 nengard   k
12:43 kados     nengard: no tags, just straight css, like in the example I gave
12:42 kados     nengard: it's CSS
12:42 nengard   question - for OPACUserCSS - how is the data supposed to be formatted? url? css? <style> tags?
12:42 kados     and why two?
12:41 kados     why a recordDelete?
12:41 hdl       And it seems to be trying to do the recordDelete Before the speciaUpdate
12:40 hdl       (mm 1 recordDelete and 1 specialUpdate)
12:40 hdl       And SpecialUpdate
12:40 hdl       there are 2 recordDelete
12:39 kados     hdl: there should only be one zebraqueue entry if I'm not mistaken
12:39 kados     hdl: and what is happening behind the scenes?
12:26 hdl       And overflood mysql db.
12:26 hdl       it takes over 50% CPU
12:25 hdl       kohazebraqueue daemon won't pardon you.
12:25 hdl       wait for a while
12:25 hdl       save
12:25 hdl       edit the same biblio (Oops, I misspelled the title)
12:25 hdl       right after
12:24 hdl       save it
12:24 hdl       add a new Biblio
12:24 kados     hdl: I don't quite understand the use case, could you walk through it again?
12:08 hdl       Or you would try to delete a ghost record and cramp the system.
12:08 hdl       hi fbcit
12:08 hdl       either you would delete create the record and then delete.
12:08 fbcit     morning everyone
12:07 hdl       the thing is that ModZebra does a del and an Add but when you save, visually check then edit back.
12:06 kados     here too
12:06 hdl       Many ppl here check their catalog. when the enter a biblio.
12:06 kados     yep, it's annoying, I agree
12:06 hdl       But it annoyed them not to be able to search a biblio for a minute.
12:05 hdl       had zebraqueuedeamon launched  every minutes or so.
12:05 kados     he shuld be around in about 2 hours
12:05 kados     maybe galen has some other ideas
12:05 hdl       IPT
12:04 kados     hdl: what who had before?
12:04 hdl       Install from beta2.
12:04 hdl       Yes.
12:04 hdl       this is what they had before.
12:04 kados     hdl: are you sure you're running the very latest zebraqueue daemon
12:04 kados     I thought zebraqueue damon did the same
12:03 kados     hdl: and won't run if a process is running already
12:03 kados     hdl: I think rebuild_zebra now checks to see if it's already running
12:03 kados     hdl: how about 2 minutes
12:02 hdl       So ppl will have to wait for 10 minutes before sbeing able to search their biblios ???
12:02 hdl       :(
12:02 kados     hdl: I hope so ... if you run it in cron every 10 minutes or something
12:01 hdl       would that solve the problem ?
12:01 kados     hdl: it lets you index from zebraqueue
12:01 kados     hdl: an alternative to zebraqueue daemon is rebuild_zebra with the -z flag
12:01 kados     hi guys