← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
Time | Nick | Message |
---|---|---|
12:34 | jmlongo | hi there... |
12:36 | Is someone working with Reports module? | |
12:38 | cause with the "issues by borrower type" report I always get a global report | |
12:38 | It lets me select a branch and input a borrower category ... | |
12:39 | but no matter what I select or input.. it always returns a total for all the branches and all borrwer types | |
12:45 | owen | Hi jmlongo. I think there may already be a bug filed for that. |
12:46 | Yep: http://bugs.koha.org/cgi-bin/b[…]ow_bug.cgi?id=840 | |
12:46 | Filed it myself. Unfortunately no one has taken it up. | |
13:21 | jmlongo | ooohhhh... ok... thanks owen! |
13:53 | paul | jmlongo & owen : i've hired henri damien laurent, that will work on reports soon |
13:53 | i'll send him the bug immediatly | |
13:54 | owen | Thanks. |
13:54 | paul | (report module, i've a document in french explaining what it will contains, can send it to anyone interested) |
13:54 | owen | Paul, did you see the bug about the MARCNOTES in the opac? |
13:55 | paul | yes, but i still haven't hunt it |
13:55 | owen | Okay. I'm sure you'll do better than me at figuring out what's wrong. |
17:39 | kados: are you around? | |
18:20 | kados | owen: am now ... what's up? |
18:20 | owen | Hi. I'm getting some incongruous search results on 101, I thought I'd see what you could see. |
18:22 | Try going to the advanced search screen in the intranet and doing a search on 'keyboarding' with branch 'Chauncey' specified. | |
18:24 | kados | ok ... no results |
18:25 | an opac search doesn't pull up any results for Chauncey either | |
18:25 | oh ... yes it does | |
18:25 | Typing and keyboarding for everyone | |
18:27 | owen | Strangely, if you search for the same keyword with branch 'Nelsonville', it comes up fine! |
18:29 | kados | could it be that the items.branchcode isn't "=" to CPL? |
18:29 | it might be "CPL " | |
18:29 | or " CPL" | |
18:29 | owen | Hm... I looked, but I may have missed that. |
18:31 | This query returns two results: | |
18:31 | SELECT distinct biblio.biblionumber | |
18:31 | FROM biblio, items | |
18:31 | WHERE biblio.title | |
18:31 | LIKE '%keyboarding%' AND items.holdingbranch = 'CPL' | |
18:33 | kados | yikes ... it has a wildcard in front? |
18:33 | that means no indexes will be used | |
18:33 | I wonder when that was added | |
18:34 | owen | No, that was just the query I typed in myself |
18:35 | kados | phew! |
18:36 | how about replacing = to like or wrapping CPL with wildcards ... any more results? | |
18:37 | oh ... I guess it doesn't matter at this point | |
18:37 | well ... actually try keyboarding% (without the front wildcard) | |
18:38 | if that returns results than we can rule out the "CPL " and " CPL" possibilities | |
18:38 | owen | The query I pasted above doesn't work if you take out the first % |
18:39 | (returns no results) | |
18:39 | kados | that probably means that we've got "CPL " or " CPL" |
18:40 | owen | The actual query as reported in the log is way over my head |
18:40 | kados | select count (*) from items where holdingbranch like " CPL"; |
18:40 | select count (*) from items where holdingbranch like "CPL "; | |
18:40 | try those | |
18:40 | oops | |
18:40 | that's select count(*) | |
18:41 | I think it fails with the space | |
18:45 | owen | SELECT count(*) FROM items WHERE holdingbranch = 'CPL' returns 7210 |
18:46 | The same results for a search with a space at the end. | |
18:48 | kados | hmmm , are we sure that these two searches are pulling holdings info from the same place? |
18:48 | maybe the opac uses marc | |
18:49 | owen | opac and intranet searches on 101 give the same results in this case |
18:50 | kados | well ... maybe the 'select by branch' function uses non-marc |
18:55 | owen | select count(*) from marc_subfield_table where subfieldvalue = 'CPL' gives 7901 |
18:59 | kados | ooh that's interesting |
19:00 | owen | What? I've got one too :) |
19:00 | kados | :-) |
19:00 | owen | In the 'keyboarding' case, the search fails for all branches except NPL. Almost all branches have it, though. But NPL is the only one with two copies. |
19:01 | kados | this is starting to sound like a bug |
19:02 | owen | Hmm... but ' biblio.title contains blow fly and items.holdingbranch = CPL' works even though CPL only has one copy. |
19:34 | pate | hiho |
19:36 | hmm, i'd've thought that someone might be awake | |
19:37 | owen | Hey pate! |
19:37 | Long time no see | |
19:37 | pate | yeah .. how're things at NPL? |
19:37 | owen | Pretty good. We're madly preparing for an upgrade to 2.2 |
19:37 | Trying to chase down some last bugs | |
19:37 | pate | sounds fun |
19:39 | owen | Keeps me busy :) |
19:39 | pate | yeah, i'll bet |
19:39 | owen | anything new with you? |
19:40 | pate | getting ready to move into a new group here in amazon ... should leave me with a bit more time |
19:40 | and a nice helper app for Koha (and maybe others) on the drawing board | |
19:41 | owen | are you able to talk about what you've been (or are going to be) doing at Amazon? |
19:41 | pate | i'm currently a systems engineer ... a herd the front- and back-end servers that run all of the various websites |
19:41 | i'm moving into the webservices group | |
19:42 | owen | That sounds cool. |
19:43 | kados | hey pate! good to read you |
19:46 | owen | Either that or he'll kick your ass for it! |
19:46 | pate | i need to look at your module ... |
19:46 | kados | hehe |
19:46 | well the one I committed is pretty minimal | |
19:47 | pate | which services are you using? |
19:47 | kados | I've got a more extensive one written but it's not really appropriate for general Koha use and it's kinda complicated to add |
19:47 | pate | and what are you using it for |
19:47 | kados | basically all the xml item details |
19:47 | and the 'read it now' | |
19:47 | (but that's just a link) | |
19:48 | the module dynamically grabs the amazon data rather than storing it in Koha's database | |
19:48 | which is good for some and bad for others iykwim | |
19:49 | well I'll have a demo up here soon and I'll post to the list when I do | |
19:49 | (I had one but I've taken it down) | |
19:50 | actually ... it's there ... just broken ;-) | |
19:52 | pate | heh |
19:54 | well, i oughta run and get some stuff done ... later everyone | |
19:55 | owen | Catch you tomorrow, kados, if you're around |
20:26 | Nausicaa | hi everyone ! |
20:28 | last 3 days i met 3 people knowing Paul Poulain and the Koha project... | |
20:28 | this was 3 nice days | |
20:31 | of course... i was with geek people in the "Salon Solutions Linux 2005" : http://www.solutionslinux.fr/fr/index.php | |
20:37 | if anyone wants to discuss... | |
20:42 | nice pics on the gallery... taking koha to sydney... |
← Previous day | Today | Next day → | Search | Index