← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 13:09 | paul | sylvain, le template officiel pour la 2.2 est le template css. |
| 13:09 | le défaut est totalement dépassé, il faudrait le virer en fait. | |
| 13:09 | owen, are you here ? | |
| 13:09 | 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 | j'vais commiter ça alors pour le desc/asc | |
| 13:11 | pour le moment je regarde l'affichage explicite des champs manquants lors de la création d'une notice | |
| 13:12 | 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 | mais jusqu'ici tu sais tout, j'fais rien en secret ;) | |
| 13:13 | paul | lol |
| 13:14 | (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 | kados ? | |
| 14:14 | owen | Yes |
| 14:14 | Still no kados, I guess. | |
| 14:14 | paul | hdl & me have a problem |
| 14:14 | with issues stats. | |
| 14:15 | 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 | * date_due that is the date where the book is supposed to be returned | |
| 14:16 | * returndate, the date where the book is returned | |
| 14:16 | * but no field to define the date where he was issued | |
| 14:16 | (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 | to know how long the issue lasts | |
| 14:19 | i thought i could use timestamp, but it's automatically modified on each sql update | |
| 14:20 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 'morning kados! ;) | |
| 14:51 | kados | morning ;-) |
| 14:51 | JYL57 | hi kados |
| 14:54 | kados | ok ... so here's the query: |
| 14:54 | 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 | 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 | 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 | 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 | some of them are 952b and some are 952d | |
| 15:01 | that could be part of the problem | |
| 15:01 | so can you give me some titles that are in CPL? | |
| 15:01 | for sure ... | |
| 15:01 | owen | hamlet, king lear, as you like it |
| 15:01 | kados | ok |
| 15:02 | 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 | that's a major bug afaic | |
| 15:03 | two probs there ... | |
| 15:03 | first: shouldn't allow me to do that | |
| 15:04 | second: don't you have more than 475 books? | |
| 15:04 | :-) | |
| 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 | stephen probably accounted for in when the records are imported and mapped to Koha fields | |
| 15:05 | 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/k[…]iblionumber=67112 |
| 15:08 | 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 | (the one we 'fixed') | |
| 15:11 | 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 | I'm worried about the MARC21 version of Koha | |
| 15:15 | 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 | Only 952b shows up. | |
| 15:16 | select bibid, tag, subfieldcode, subfieldvalue from marc_subfield_table where bibid = 67112 and subfieldvalue = 'CPL'; | |
| 15:16 | 67112 | 952 | b | CPL | |
| 15:17 | Is 952d getting added/updated when an item is issued/transferred/returned? | |
| 15:17 | Because it would have to be if this search is supposed to work. | |
| 15:18 | 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 | https://66.213.78.69/cgi-bin/k[…]iblionumber=77421 | |
| 15:20 | I think you're on to something | |
| 15:20 | owen | What was your search? |
| 15:21 | But that item has both a 952d and a 952b | |
| 15:21 | So there was a 952d for the search to find. | |
| 15:24 | It looks like the holdingbranch information gets updated by sub dotransfer at line 487 of Circ2.pm. | |
| 15:25 | But it only updates the items table. | |
| 15:25 | 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 | 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 | Oh wait, maybe it /is/ the framework. | |
| 15:38 | 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 | 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 | PORT STATE SERVICE | |
| 16:23 | 21/tcp open ftp | |
| 16:23 | 23/tcp open telnet | |
| 16:23 | 80/tcp open http | |
| 16:23 | 280/tcp open http-mgmt | |
| 16:23 | 515/tcp open printer | |
| 16:23 | 631/tcp open ipp | |
| 16:23 | 9100/tcp open jetdirect |
← Previous day | Today | Next day → | Search | Index