Time  Nick  Message
20:30 rch   can anyone out there give a quick rundown on reserveconstraints?
20:30 rch   hey
15:41 cm    yep.  :)
15:38 kados itemtypes++ ;-)
15:35 cm    thanks.  :)
15:35 cm    hey kados--it works perfectly now that I have itemtypes.
14:11 paul  yep.
14:11 paul  lol
14:11 slef  paul: ça va?
14:11 slef  paul: I don't have any dangling discussion with you yet ;-)
14:11 paul  (hdl seems not to be here since 30mn)
14:10 dewey slef: wish i knew
14:10 slef  dewey, es-tu bot?
14:10 slef  hdl, kados: içi? here?
14:10 dewey bonjour, slef
14:10 slef  hi
12:52 cm    sorry for wasting your time!
12:52 cm    i'm reloading the data now.
12:52 cm    i think i remapped my fields incorrectly, and so they didn't get inserted by bulkmarcimport.
12:49 cm    yes, indeed.  :)
12:46 kados koha will will work much better with itemtypes ;-)
12:29 cm    shoot, they're still null.  i'm going to have to use bulkmarcimport.
12:26 cm    oops
12:26 cm    mc
12:25 cm    i like tumer's quit message.  :)
12:25 cm    i'm reloading the database from an old backup.
12:19 cm    that's a possibility.
12:19 cm    I guess I'll have to run bulkmarcimport again to get them back, unless they happen to be in one of my backups.
12:18 cm    too much going on!
12:18 cm    i must have managed to blitz them again and didn't realize it or got sidetracked.
12:17 cm    well, crap.
12:17 cm    huh...itemtype is indeed empty.
12:16 kados we'll see soon I suppose :-)
12:16 kados so I'm guessing that's where the problem has been the whole time
12:16 kados the query is dependent on itemtype not being empty
12:15 kados ccode can be empty in that query
12:15 kados actually ...
12:13 kados I still can't figure out what i was thinking committing that ccode query
12:13 cm    ok.  it'll take me a few minutes to get it started.
12:13 kados try restoring the db and check for values in biblioitems.itemtype
12:12 cm    console.
12:12 kados did you do it fromp phpmyadmin? or the mysql console?
12:12 cm    hmm...maybe itemtype was empty before?  i should've looked before I did it.
12:11 cm    i'm looking at biblioitems in phpmyadmin, and they're both empty.
12:10 kados update biblioitems set ccode=itemtype; should have updated only ccode
12:10 cm    well, i have a database backup from last night, at least.
12:10 kados er?
12:10 cm    uh oh, you got it reversed too.  I just obliterated the itemtypes again.  :P
12:08 kados ok, I'll put it on the list
12:08 cm    that would be good.
12:08 kados well, it would be simple enough to make a syspref to turn them on or off
12:07 cm    yeah, you kind of threw us for a loop with that.
12:07 cm    then i reuploaded the database & got sidetracked by something else.
12:07 kados a bit of coding I'm definitely not proud of
12:07 kados yea, and frankly, the ccodes is a bit of a hack
12:07 cm    so I obliterated all our itemtypes--oops!
12:06 cm    i tried it the other day, but got ccodes & itemtypes reversed,
12:06 kados k
12:06 cm    yeah, i'll do that.
12:06 kados which would make all the ccodes identical to the itemtypes
12:06 kados update biblioitems set ccode = itemtype;
12:06 cm    most of our records (if not all) are missing deweys too.
12:06 kados what we could do is something like:
12:05 cm    let me add one to test it.
12:05 kados you may be right
12:05 kados ahh, wait a sec
12:05 kados nope, ccodes aren't required
12:05 kados Empty set
12:05 cm    i'm wondering if it's because I don't have any ccodes in there yet.
12:04 kados cm: SELECT items.*,issues.timestamp      AS timestamp, issues.date_due       AS date_due, items.barcode         AS barcode, biblio.title          AS title, biblio.author         AS author, biblioitems.dewey     AS dewey, itemtypes.description AS itemtype, biblioitems.subclass  AS subclass, biblioitems.ccode  AS ccode, biblioitems.isbn  AS isbn, biblioitems.classification AS classification FROM issues,items,biblioitems,biblio, itemtypes WHERE issues.borrowernum
12:04 kados cm: and that returns nothing in mysql when I run it
12:02 kados SELECT items.*,issues.timestamp      AS timestamp, issues.date_due       AS date_due, items.barcode         AS barcode, biblio.title          AS title, biblio.author         AS author, biblioitems.dewey     AS dewey, itemtypes.description AS itemtype, biblioitems.subclass  AS subclass, biblioitems.ccode  AS ccode, biblioitems.isbn  AS isbn, biblioitems.classification AS classification FROM issues,items,biblioitems,biblio, itemtypes WHERE issues.borrowernumber
12:02 kados cm: here's the query:
12:02 kados :-)
12:02 kados paul++
12:01 paul      $Zconnbiblio[0] = C4::Context->Zconn( $server, 0, 1 );
12:01 paul  in fact :
12:01 paul  the last line of zebraop
12:01 kados !!
12:01 paul       $Zconnbiblio[0]->destroy();
12:00 paul  that should never have been here, as it destroys the persistant connection
12:00 kados is it a zebraop line?
12:00 paul  and I just commented the line 3483
12:00 paul  bulkmarcimport.pl -d -f aniso_file
12:00 kados paul: what did you do?
12:00 paul  at least, it don't die. I don't have checked things are indexed correctly, but I hear my HD working
11:59 kados how?
11:59 kados it does?
11:59 paul  bulkmarcimport works ;-)
11:58 kados hehe
11:58 paul  (line 3483 sorry)
11:58 paul  kados, pls : open Biblio.pm, go to line 3486 and tell me what you see :-D
11:56 cm    ok.
11:56 kados cm: so we could throw some warns in there to figure out why it's not finding issues properly
11:55 kados cm: yea, it's called in circulation.pl and the routine is in Circ2.pm
11:55 cm    i found it in circ2.pm.
11:54 kados paul: like 1 minute, or 10 minutes
11:54 kados paul: update_items can't handle simple times
11:54 paul  ok, i'll investigate the question & see what I can do
11:54 cm    ok.
11:53 paul  tumer: 1 point
11:53 kados paul: it's much more efficient
11:53 kados cm: give me a sec, I'm still troubleshooting
11:53 tumer paul: with update_items script cannot delete a record from ZEBRA!!!
11:53 paul  (so it's more "real time update" than your solution)
11:53 paul  (except it can be run once every 10mn or once every hour if needed)
11:53 cm    do you know where the getissues call is?
11:52 cm    it's probably something we did then.
11:52 kados paul: if you have time to port it to rel_3_0 please do
11:51 kados paul: yep, my opinion is that it's a great solution
11:50 paul  tumer: thanks. kados, any opinion on tumer mail ?
11:50 kados cm: because I've got a few CVS installs that don't exhibit this behavior
11:49 kados cm: I'm not sure it's in CVS
11:48 tumer see my mail on zebraop
11:48 paul  yep
11:48 cm    i'm looking at the cvs digest to see what has changed between now and then.
11:48 tumer paul:around??
11:47 cm    so, something must have happened between now and then to break it again.
11:47 cm    in my bugtracker I'm using to track our project, I found that I marked it as working on Nov 15.
11:47 cm    hmm.
11:45 kados cm: the getissues call isn't returning data
11:45 kados cm: found where the problem is happening
11:40 paul  (+ with mod_perl, the problem would have happen in Koha itself, as the zconn is persistant)
11:39 paul  but of course, the next zebraop will reach an empty connexion & fail.
11:39 paul  between them, the context->Zconn is dropped, I still don't know why.
11:39 paul  the 1st zebraop works, the 2nd fails.
11:29 cm    cool.
11:29 cm    ok, will do.
11:29 kados cm: I'm in
11:29 kados cm: won't hurt, but shouldn't affect anything
11:27 cm    kados: should I update to the Circ2.pm you just committed?
11:26 kados cm: ok ...
11:26 kados could be a zoom bug, or else koha bug related to how the connection is forged, or else zebra bug for closing the connection without being told to
11:25 paul  ok
11:25 paul  is it related to the zebra problem or something else ?
11:25 kados paul: it's the connection problem I told you about yesterday
11:25 kados paul: even in dev_week
11:25 cm    hi paul.  :)
11:25 kados paul: that bug has always existed
11:25 paul  hi cm
11:24 cm    hey kados--the passwords are reset, so i'll be around whenever you're ready.
11:23 paul  ???
11:23 hdl   was this bulkmarcimport modified according to the latest Context.pm ?
11:21 paul  kados : bulkmarcimport says : {_conn} undefined: has this Connection been destroy()ed? at /usr/lib/perl5/site_perl/5.8.8/i386-linux/ZOOM.pm line 344.
11:14 paul  ESI => not decided, but we plan at least to have a strong API to be able to add it when needed.
11:13 paul  acquisitions will be divided by "poles" (=subjects), with buyers being responsible of a specific budget for each pole, having monthly reports tools...
11:12 kados electronic ordering, etc.?
11:12 kados will it use ESI?
11:12 paul  the idea being to have a complete suite to analyse & decide what to buy to have the most useful catalogue for a public library
11:12 kados paul: great news!@
11:11 hdl   not for addbiblio.
11:11 paul  I must add that SAN-OP will sponsor a 100% new acquisition module in 2007, with so many new features that I can't list them ;-)
11:11 paul  for serials, hdl did it already if I understand what you mean.
11:10 kados we should integrate acquisitions and serials with additem.pl and addbiblio.pl
11:10 kados hehe
11:10 paul  it's something coming from koha 1.x, so you should ask chris for this one ;-)
11:09 kados this is undocumented 'feature'?
11:09 kados !!!
11:09 paul  none of our customers do that, so it may not work on default as well. but iirc, you are supposed to enter 3 barcodes, separated by a space.
11:08 paul  !
11:08 kados yes
11:08 paul  you want to put barcodes on items just when you recieve them, right ?
11:08 paul  mmm...
11:07 kados (I have confirmed the problem exists for me in rel_2_2 npl templates ... a shame ... I'll test with default now)
11:07 kados is that barcode added to every item (out of 3)?
11:07 kados so if I enter a barcode for instance
11:06 kados yes, I do, but only one item is available to edit
11:06 paul  don't you have a field to enter this ?
11:06 paul  no, you just say 3 items in acocunting detail.
11:06 kados yes
11:06 paul  you mean 4 items of a single title ?
11:05 kados paul: when i add an item, do I fill in 3 in accounting details?
11:05 kados paul: suppose I order 4 items, and I recieve a parcel with 3 of them
11:04 kados paul: this is confusing to me ...
11:04 kados paul: it asks how many items were received
11:04 kados paul: when receiving an item, there is an Accounting Details section