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