Time  Nick   Message
16:24 slef   What is citylink.co.nz?
16:33 chris  umm how to describe them
16:34 chris  they run a big layer 2 network
16:35 chris  is their main task, .. they also run things like the peering exchanges, and cafenet
16:35 chris  why?
16:40 chris  http://www.linuxjournal.com/issue/135  slef if you pick up a linux journal ... they are the cover story
16:40 chris  well talking more about wix (the wellington internet exchange) but they do a bit of a citylink history thing
16:41 slef   chris: yes, wix is the problem
16:42 slef   http://mirror.debian.org/ftp.nz.debian.org.html
16:42 chris  yep
16:42 chris  2 big telcos decided to pull out of the peering exchange
16:44 chris  in order to try and extort more money
16:47 chris  if you are on lots of other isps, that still peer, you can get to it just fine
16:48 chris  but the 2 big telcos here are trying to get their customers to pay to receive, and the content providers to pay to deliver
16:50 chris  so they pulled all their routes to wix
16:50 chris  and want ppl to negotiate a dedicated connection with them
16:52 chris  its a classic geeks vs suits
16:52 chris  situation
17:00 slef   so is citylink doing the wrong thing, or the telcos connecting to nz?
17:00 chris  in my opinion the telcos
17:00 chris  http://publicaddress.net/default,2213.sm#post2213
17:01 chris  that pretty much sums up the situation
18:02 Genji  kados, installed the new HEA?D
23:28 Genji  finished my search options sidebar, everything works, and its in HEAD of CVS.
23:50 rach   well done
00:09 Genji  one problem is the search is alittle bit slower, due to the addition of two tables in the mysql 'from' clause.
07:10 hdl    hi
07:12 hdl    does anyone around has ever dived into MARCdetail code and especially the javascript Active ?
07:55 osmoze bonjour paul
07:55 paul   salue js
07:55 osmoze je n arrives pas a retrouver ton adresse, tu peux me la redonner ?
07:55 paul   adresse mail ou physique ?
07:56 osmoze ( c est pour une invitation pour l innoguration de la mediatheque)
07:56 osmoze physique
08:06 osmoze paul ? Pour la reinstallation de la 2.0 pour faire l upgrade par la suite, je peux prendre la 2.0.2 ?
08:07 paul   oui, il n'y a pas de différence dans les bases.
08:07 osmoze merci :)
08:30 kados  osmoze: hey there osmoze
08:30 osmoze kodos ?
08:31 osmoze -o+a
08:31 kados  osmoze: it's Joshua ;-)
08:31 kados  osmoze: do you work for a library?
08:31 osmoze yes, i m admin of a librairy
08:31 osmoze (Lafrancaise, France)
08:31 kados  osmoze: right
08:32 kados  osmoze: so does your library use koha?
08:32 kados  osmoze: or are you just investigating?
08:32 osmoze yes of course :)
08:32 osmoze 2.0
08:32 kados  osmoze: great! and paul supports you?
08:32 osmoze of course
08:32 kados  osmoze: :-)
08:32 osmoze i ll prepare upgrade to 2.2.3
08:32 kados  osmoze: which library is it?
08:32 paul   (osmoze is "Lafrancaise" public library
08:33 kados  osmoze: ahh Lafrancaise is a name ... /me thought 'the french'
08:33 osmoze ^^
08:33 kados  my french is quite bad you know ;-)
08:33 osmoze yes, a little 'bourg' near Toulouse (airbus powa)
08:33 kados  ahh
08:33 paul   (very little, but 3 branches !)
08:33 osmoze it s better that my poor english :)
08:33 kados  hehe
08:34 kados  non
08:34 paul   osmoze & jean sébastien, that writes sometimes on info is the same person.
08:34 kados  ahh ... /me knows the second name
08:34 kados  hi owen
08:35 paul   hi owen
08:35 hdl    hi owen
08:36 osmoze hi
08:36 osmoze (owen too ^^)
08:38 paul   wow, lot of ppl here today.
08:41 osmoze  that proves that it is well :)
08:46 kados  paul: I've got a quick question about dateenrolled/expiry
08:46 paul   i'm listening.
08:47 kados  we're testing out the new code where a borrower isn't allowed to issue items if they have expired
08:47 kados  and I can't find any way to remove the block
08:47 kados  I just get a message "issueing impossible" borrower card expired
08:48 kados  with now way to override it
08:48 paul   just change expiry date ;-)
08:48 kados  I see ... (our staff will never go for that ;-))
08:48 paul   (it's in my release notes : there was bugs in canbookbeissued checking. Fixing it will probably create many many "card expired"
08:48 kados  right ... we have 13,000 ;-)
08:49 paul   so, just say 99 years for borrowercategory
08:49 kados  out of 40,000 expired ;-)
08:49 paul   and update borrowers set expirydate...
08:49 owen   kados: how about a button like our 'lift debarrment' button?
08:49 kados  owen: yea that might be a good idea
08:49 paul   a single sql request should do the job.
08:49 kados  owen: but what's the point of keeping track of the borrower expiry anyway?
08:49 kados  owen: is it a stats thing?
08:50 paul   joshua : saying 99 years for borrower duration in borrower category will solve the pb for future borrowers.
08:50 owen   It's a way to remind the staff to check about changes to address, phone, etc.
08:50 paul   for existing ones, you just must update the database.
08:50 kados  right
08:51 kados  owen: in that case, having the button to lift expiry sort of defeats the purpose ;-)
08:52 owen   No, because the staff member can look at their address and phone right on the circulation screen.  If it hasn't changed, they can just click the button
08:52 owen   Otherwise they can click edit to change everything, along with the expiration date
08:53 kados  right ... ok ... lets's do that
08:53 owen   That's how we handled it with Spydus
08:53 kados  paul: sorry to bother you ;-)
08:53 paul   no problems.
08:53 owen   But maybe run it by Stephen... we only did it that way with Spydus because Spydus forced us to.
09:02 tim    I'm looking at member flags (using the default theme in 2.2.2b) and most of the flags are reapated twice.
09:02 tim    three of each.
09:28 owen   tim, where are you looking?
09:30 tim    cgi-bin/koha/members/member-flags.pl
09:31 tim    you probably need to add a member=##
09:31 owen   Are you using the default template?
09:33 paul   tim : maybe you have data twice in userflags table
09:33 paul   what says select * from userflags.
09:34 tim    I looked at that, but they weren't all together like they are in the browser.
09:35 tim    Checking again with order by flag made it easier to spot.
09:35 tim    I wonder how I got that?
09:35 tim    And I wonder why I didn't have all of them three times.
09:35 tim    So it should be safe to just delete the extras?
09:37 tim    Don't have data twice.  Have it three times.  Except the last three displayed on the page.
09:37 tim    How do I remove two of them when there are no unique values to select by?
09:40 paul   imho, mysqldump, then truncate, then manually delete lines, then reimport
09:40 paul   will be the faster
09:43 tim    Good idea.  Thanks!
09:51 tim    That looks a lot better.
09:52 gavin  hi. is anyone here familiar with the workings of the opac search code?
09:53 kados  gavin: sure ... paul and I have a pretty good handle on it ;-)
09:53 gavin  i was thinking you might have :-)
09:53 kados  gavin: I'd like to see your suggestions -- chris mentioned that you've put together some good stuff
09:54 gavin  the function catalogsearch returns an ref to array of hashrefs
09:54 kados  right ... as required by HTML::Template LOOPs
09:54 gavin  within those hashes there are many entries, one or two i'm not sure about , could you let me know what they are
09:54 kados  sure
09:55 paul   (on phone)
09:55 gavin  (i've been trying to focus specifically on one area and not get drawn to the rest. Must look at HTML::Template though, sounds cool
09:55 gavin  CN?
09:55 kados  CN is just an object for storing item information iirc
09:56 gavin  description, odd, bn, norequests, totitem (actually I think odd is just 1,0,1,0,1,0, ie is this an odd entry?
09:56 kados  right
09:57 kados  odd is used for fancy coloring on the results screen
09:57 kados  (so every other item has a differnt background color)
09:57 gavin  there must be something wrong with my "odd" then as that's what I had guessed but i'm getting all one colour
09:57 kados  totitem is the total items
09:57 kados  strange
09:58 kados  bn is biblionumber
09:58 gavin  (don't worry, it'd efinitely my mistake :)
09:58 gavin  which is already in as biblionumber?
09:58 kados  norequests is set to 1 if the items isn't able to be requested
09:58 kados  hmmm ... maybe
09:58 gavin  ah yes
09:58 gavin  not a big deal....
09:59 kados  not sure about description
09:59 kados  I dont' find that in catalogsearch
09:59 kados  where's it coming out?
09:59 gavin  I was printing out all elements of the returned array in order to clone that function
10:00 gavin  and it's among them. didn't chase where it came from that much
10:01 gavin  CN seems (in my minimal test) to be (1,1)
10:02 kados  so the HTML::Template LOOP function is critical for understanding why data is pulled out the way it is
10:02 kados  in HTML Template, just like in Perl, you can have scalar data (TMPL_VAR NAME="")
10:02 kados  and array data (TMPL_LOOP NAME="")
10:03 kados  array data is looped over for each 'set' of data
10:04 kados  CN is a loop
10:04 kados  gavin: does that make sense?
10:05 gavin  one momenet osrry
10:05 kados  (on phone)
10:06 gavin  me 2
10:10 paul   back.
10:11 paul   CN is for CallNumber
10:11 gavin  kados: not totally sure I get you know
10:11 paul   be careful, we may speak of Search.pm of SearchMarc.pm catalogsearch sub.
10:11 gavin  s/know/no/
10:11 gavin  SearchMarc.pm
10:11 paul   cataloguesearch we are using now is SearchMarc.pm
10:12 gavin  yeah, i noticed that so that's what I'm working from
10:12 gavin  I'll hopefully stick some concept code in CVS tonight to show you what I'm at
10:12 gavin  I've copied SearchMarc.pm into SearchBiblio.pm
10:13 gavin  i see what my problem is with odd
10:13 gavin  i was assuming i need 1,0,1,0
10:13 gavin  what I need is 1,"",1,""
10:14 gavin  ... i think
10:23 paul   gavin : no diff from Perl point of view : 0 & "" are both false
10:24 gavin  ah there booleans of course
10:25 gavin  hmmm. it's probably something I'm doing, i'll track it down. it's a minor enough thing anyway
10:26 gavin  so, with what should i populate the CN array?
10:32 paul   gavin, you must populate the CN array with all items informations.
10:32 paul   that's what appear on the right; on this page :
10:33 paul   http://bureau.paulpoulain.com:9006/cgi-bin/koha/opac-search.pl?op=do_search&type=opac&marclist=&and_or=and&excluding=&operator=contains&value=chaos
10:33 paul   (in "Location" column)
10:34 gavin  eg  " CDI SL (N 3 KAP)" ??
10:37 paul   yep.
10:37 gavin  okeydokey
10:37 paul   branch + location + callnumber + status
10:37 paul   (status if any)
10:37 paul   (like lost, on repair - status found from items.lost & a authorised value table)
10:38 paul   (or on loan until ... if issued)
10:38 gavin  are they the each of the elements of the array or is that whole string an element?
10:38 paul   note that npl (bipping owen) has requested that every item with the same info could be shown in just 1 line
10:38 paul   like CDI SL (N8KIM) (2)
10:39 owen   Indeed.
10:39 paul   but i could not code this until now.
10:39 paul   ;-)
10:39 gavin  will leave it for the minute but bear it in mind
10:39 paul   gavin, each element is in a separate entry.
10:39 gavin  cool
10:40 paul   owen, do you have a minut ?
10:40 gavin  the npl request probably should be done with a group by clause no?
10:40 gavin  and a count()
10:40 owen   yes, paul
10:40 paul   yes, or with some perl checks
10:40 paul   a CSS question :
10:40 paul   http://bureau.paulpoulain.com:9010/cgi-bin/koha/opac-MARCdetail.pl?bib=3
10:41 paul   with style sheet
10:41 gavin  my philosophy (such as it is) has generally been to make the db do the work where practical
10:41 paul   http://bureau.paulpoulain.com:9010/opac-tmpl/css/en/includes/opac.css
10:42 paul   if you clic on "items", you'll see that the columns are wrong
10:42 paul   do you have an idea why ?
10:42 paul   seems to be due to :
10:43 paul   position:absolute or display:block
10:43 paul   in div.tabblock
10:43 paul   how to restore default behaviour ?
10:47 gavin  not a css expert i'm afraid
10:48 owen   I've never seen a table behave like that before
10:48 owen   I didn't know it was possible!
10:48 paul   if i remove position;absolute in div.tab, line 420, the table is fine
10:48 gavin  paul, would you have five mins to have a look at some code if i upload to cvs now...
10:48 kados  paul: display:table
10:48 paul   gavin, no, but i'll take care of it on monday.
10:48 kados  paul: try that
10:49 gavin  fair enough
10:49 paul   kados, adding the property to table {} don't change anything
10:50 kados  hmmm
10:50 paul   adding this property to td or th is even worst
10:50 paul   my doc of css shows the following properties for display :
10:50 kados  interesting
10:50 paul   inline | block | list-item | run-in | inline-block | table | inline-table | table-row-group | table-header-group | table-footer-group | table-row | table-column-group | table-column | table-cell | table-caption | none
10:51 kados  paul do you have the firefox web Developer plugin?
10:51 paul   yes
10:51 kados  when I select "outline" "table cells" look what happens
10:52 paul    !!!!
10:52 kados  also try "outline tables"
10:52 kados  very strange!
10:52 paul   it's OK !
10:52 kados  hehe yep
10:52 paul   really strange ...
10:52 kados  could be ... I'll try it in safari
10:53 paul   no, could be some property webdev add.
10:53 kados  hmmm ... you don't even want to see it in safar  ;-)
10:53 kados  none of the content is displayed .. everything is shifted to the left
10:54 paul   same thing on opera & konqueror.
10:54 owen   Internet Explorer too
10:54 kados  so probably not a ff bug ;-)
10:54 paul   no.
10:55 paul   reload, works now on opera
10:55 paul   (i've removed some css properties)
10:55 paul   works on opera & konqui. but still not on ff
10:56 paul   ok, i must leave (planned time with my 1st son)
10:56 kados  some validation probs too
10:56 kados  can't use numbers to start id or class names :-?
10:57 kados  ok ... have fun
10:57 paul   we should.
10:57 paul   (use start id)
10:57 gavin  thanks for help paul..
10:59 owen   Whoops.  Wrong close button.
11:00 kados  hehe
11:15 kados  here's an interesting perspective:
11:15 kados  http://www.infotoday.com/cilmag/jun05/Ostrowsky.shtml
11:15 kados  "Anonymous Library Cards Allow You to Wonder, 'Who Was That Masked Patron?"
11:16 kados  gift cards for libraries
11:16 kados  neat idea
11:22 gavin  nice idea, horrendous reality that it needs doing...
11:24 gavin  I'm trying to put the string "php -code" into a sql query but the "-" seems to be getting sanitized out. any ideas how I can avoid that?
11:27 kados  hmmm ... try putting it into a variable and then puting the variable in the query
11:28 kados  (you're working in perl?)
11:30 gavin  yeah, i'm working in the SearchMarc.pm
11:30 gavin  (or a fork of that)
11:30 kados  ideally the 'library gift card' signup process would be anonomous as well
11:30 kados  right
11:31 gavin  i'm not sure what's causing it, it's a bit weird
11:31 kados  did you try the variable idea?
11:31 gavin  is there something santizing this that I don't see?
11:31 kados  probably perl ;-)
11:32 gavin  i thought only PHP went on with that sort of thing ;)
11:32 kados  hehe
11:33 kados  I suppose one problem with the gift card idea is that the library becomes a kind of bank
11:33 kados  with 'money' in the form of library cards (each worth $20)
11:34 kados  (assuming I can turn in my card at any point for a refund)
11:34 gavin  well, you could argue that they already are, with money in the form of books
11:34 kados  hehe ... this could be really interesting
11:34 kados  true, but I can't trade book for money AT the library
11:34 kados  (though I can trade money for book ;-))
11:35 gavin  no, but i would assume you can't trade it in, it just gets offset against charges
11:36 kados  ahh ... yea ... that wouldn't work then
11:39 gavin  found that sanitization thing... grrrr.
11:40 gavin  it's always something silly
11:45 kados  gavin: what was it?
11:47 gavin  oh, i was running catalogsearch (the orig) and catalogsearch1 and the former was sanitizing before the latter got to see the variable
11:47 gavin  this seems to be nearly working now (apart from the stupid colouring thing!)
11:52 kados  cool
11:52 gavin  would you have time to have a look?
11:53 kados  yea!
11:53 gavin  okay, i'lll just do the cvs trickery and give you a shout
11:54 kados  cool
11:55 kados  (please commit to HEAD and not to rel_2_2)
11:56 gavin  errr... I think that's what I'll be doing?
11:56 kados  as long as you're not specifying rel_2_2, probably ;-)
11:56 gavin  cool