Time Nick Message
16:23 kados 9100/tcp open jetdirect
16:23 kados 631/tcp open ipp
16:23 kados 515/tcp open printer
16:23 kados 280/tcp open http-mgmt
16:23 kados 80/tcp open http
16:23 kados 23/tcp open telnet
16:23 kados 21/tcp open ftp
16:23 kados PORT STATE SERVICE
15:42 kados hmmm?
15:40 owen Oh, I'm just not remembering correctly. The tag was set to tag '10', which means its handled by additem.pl...I think.
15:39 kados we need a marc expert
15:39 owen I was under the impression that the links only came into play when adding to the database. But I could be wrong.
15:39 kados yea ... seems a bit strange
15:39 owen In fact I'm not even sure how that works... item info attached to the MARC record?
15:39 kados I'm not clear on how the 'links' work ...
15:38 kados is items.holdingbranch 'linked' to 952d? and if not should it be ... and if so, does that mean that when one or the other is changed it updates the other?
15:38 owen Yeah, I think 952 was hidden on purpose.
15:31 owen Oh wait, maybe it /is/ the framework.
15:29 owen I still don't know why the 952 tag isn't showing up.
15:27 kados it seems like that would be a problem for his libraries too
15:26 kados huh ... yea I wonder if paul should take a look at that too
15:25 owen Maybe all we have to do is add a query there to update marc_subfield_table?
15:25 owen But it only updates the items table.
15:24 owen It looks like the holdingbranch information gets updated by sub dotransfer at line 487 of Circ2.pm.
15:21 owen So there was a 952d for the search to find.
15:21 owen But that item has both a 952d and a 952b
15:20 owen What was your search?
15:20 kados I think you're on to something
15:19 kados https://66.213.78.69/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=77421
15:19 kados huh ... here's an item that shows up in the "CPL" search but it still doesn't have 952s in the MARC editor
15:18 owen Here: sub returnbook at line 1006 of Circ2.pm
15:17 owen Because it would have to be if this search is supposed to work.
15:17 owen Is 952d getting added/updated when an item is issued/transferred/returned?
15:16 owen 67112 | 952 | b | CPL
15:16 owen select bibid, tag, subfieldcode, subfieldvalue from marc_subfield_table where bibid = 67112 and subfieldvalue = 'CPL';
15:16 owen Only 952b shows up.
15:16 owen The record I'm looking at doesn't show up because there's no 952d subfield for it.
15:15 kados so ... we need to figure out why some of the items are working and others aren't
15:12 kados I'm worried about the MARC21 version of Koha
15:12 kados sigh
15:11 owen Yes
15:11 kados so the fields should show up even if the're blank (in the editor) right?
15:10 kados (the one we 'fixed')
15:09 kados I wonder if this is related to our other marc display problem
15:08 owen 952b is homebranch. 952d is holdingbranch. So both are valid values. The search should be looking for items which have holdingbranch = CPL, so 952d = CPL.
15:07 owen https://66.213.78.69/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=67112
15:07 kados which marc editor?
15:06 owen Why is the 952 tag not showing up in the MARC editor?!
15:05 kados which would explain why it's right in items.*
15:05 kados stephen probably accounted for in when the records are imported and mapped to Koha fields
15:04 kados so something's amiss ... I suspect the 952d vs 952b
15:04 owen I know we're small, but that's too small!
15:04 kados :-)
15:04 kados second: don't you have more than 475 books?
15:03 kados first: shouldn't allow me to do that
15:03 kados two probs there ...
15:03 kados that's a major bug afaic
15:03 kados interesting ... leaving all search fields blank and limiting by CPL brings up 475 records
15:02 owen making chocolates
15:02 kados how about some non-shakespear titles
15:01 kados ok
15:01 owen hamlet, king lear, as you like it
15:01 kados for sure ...
15:01 kados so can you give me some titles that are in CPL?
15:01 kados that could be part of the problem
15:00 kados some of them are 952b and some are 952d
14:59 kados select * from marc_subfield_table where subfieldvalue like 'CPL' limit 0,20; works
14:59 owen (and I don't see a 952d tag in the MARC record)
14:59 kados hmmm...
14:58 owen Wait a sec--if it's checking the MARC record, then how can it know the holdingbranch? The holdingbranch gets updated in items whenever you return an item.
14:57 owen Oh, well I checked items.holdingbranch, but I didn't look at the MARC record.
14:57 kados so we're sure that CPL is how it exists in 952d?
14:57 kados huh
14:56 owen What's strange is that if you use a different branch, you'll get results.
14:56 kados but I'm pretty sure that's not where it is
14:56 owen Oh, I see.
14:56 kados well ... we shouldn't need items.holdingbranch as that's actually populated via the MARC
14:56 kados does 'subfieldvalue = CPL' look like the prob there?
14:55 owen Uh... where's items.holdingbranch in all that?
14:54 kados select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_subfield_table as m2 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid) and ((m1.word like 'shakespeare')and (m2.subfieldvalue = 'CPL' and concat(m2.tag,m2.subfieldcode) in ('952d'))) order by biblio.title
14:54 kados ok ... so here's the query:
14:51 JYL57 hi kados
14:51 kados morning ;-)
14:50 owen 'morning kados! ;)
14:49 owen The value is correct in the database.
14:49 kados hi all
14:49 owen No, holdingbranch just isn't showing up correctly in additem.pl.
14:46 owen Hmm... perhaps it is a problem with items.holdingbranch
14:45 JYL57 We have two branches here, I will try to find a common author
14:44 owen 2.2
14:44 JYL57 which Koha version owen ?!
14:44 owen I'll double-check.
14:43 JYL57 items.holdingbranch is correctly set I suppose ?!
14:43 owen Even though that branch owns books by shakespeare, the search is coming up with nothing
14:42 owen I'm trying a search for 'shakespeare' and limiting it to one branch.
14:40 JYL57 owen could you explain your strange results ?!
14:35 paul_away (sorry owen)
14:34 owen paul, we're getting strange results when we try to limit a search by branch
14:26 JYL57 Ok, vais essayer, pas sûr cependant pour Eclipse...
14:25 paul ok, we will mail chris
14:25 paul JYL57 : tu peux avoir un accès anonyme sans rien demander à personne ;-)
14:25 owen True.
14:25 JYL57 paul, should I get CVS access on Koha Project (or a part of) ?! I'm checking eclipse workbench
14:25 paul yes. The problem being to know how to find which issue goes with which return
14:23 paul because each movement is one line.
14:23 owen The 'type' column seems to have what you're looking for: issue, renew, return, payment
14:23 paul it COULD be helpful, but is poorly designed
14:23 paul yes.
14:23 owen have you looked at the statistics table?
14:23 paul yes, i'll send a mail to koha-devel.
14:23 owen I'll be chris would be able to help.
14:22 owen Or Stephen. But Stephen doesn't seem to be able to get online this morning!
14:22 JYL57 unless checking recursion on contiguous issues lines !
14:22 paul is kados more familiar you think ?
14:22 owen Maybe so--I'm not familiar with that table.
14:21 paul in fact, maybe the statistics table is what we are looking for.
14:20 paul ??
14:20 owen Interesting...it doesn't look like there's a way, does it?
14:20 paul and return or renewal is a sql update.
14:19 paul i thought i could use timestamp, but it's automatically modified on each sql update
14:19 paul to know how long the issue lasts
14:19 paul yes.
14:19 owen So you're trying to find out when the book was first issued?
14:16 paul (the timestamp field is modified on each movement)
14:16 paul * but no field to define the date where he was issued
14:16 paul * returndate, the date where the book is returned
14:15 paul * date_due that is the date where the book is supposed to be returned
14:15 paul I mean that in the issues table, we have :
14:15 owen What do you mean?
14:15 paul are you able to know how long an issue lasts ?
14:14 paul with issues stats.
14:14 paul hdl & me have a problem
14:14 owen Still no kados, I guess.
14:14 owen Yes
14:14 paul kados ?
14:14 paul owen ?
14:06 hdl J'attends que tu m'appelles en visio ?
14:03 paul je t'attends en visio
14:02 hdl J'aurais des questions sur les issues stats
14:02 paul yep
14:02 hdl Paul, toujours là ?
13:15 sylvain j'ai vu ses commit ouais au niveau des stats mais j'ai pas encore regardé. Et pour les serveurs ouais j'ai vu ça sur une ML
13:14 paul (et hdl n'a pas encore commencé, il peaufine 2-3 choses sur le module stat & gère le changement de serveur koha-fr.org)
13:13 paul lol
13:13 sylvain mais jusqu'ici tu sais tout, j'fais rien en secret ;)
13:13 sylvain ouais c'est sur que ça vaut pas le coup
13:12 paul ok, dis moi bien au fur et à mesure ce que tu fais, histoire d'éviter que hdl et toi bossiez sur la même chose !
13:12 sylvain mais qu'est-ce qu'elles sont lourdes ces pages de créaion de notice, sur mon ptit pc, c'est dur ;)
13:11 sylvain pour le moment je regarde l'affichage explicite des champs manquants lors de la création d'une notice
13:10 sylvain j'vais commiter ça alors pour le desc/asc
13:10 sylvain ok paul ça tombe bien ;)
13:10 owen Hi
13:09 paul good morning.
13:09 owen Yes
13:09 paul kados, are you here ?
13:09 paul owen, are you here ?
13:09 paul le défaut est totalement dépassé, il faudrait le virer en fait.
13:09 paul sylvain, le template officiel pour la 2.2 est le template css.