Time Nick Message 12:04 tumer kados? 12:04 dewey kados is becoming a true Perl Monger... 12:05 tumer so it seems 12:05 tumer kados are you here? 12:07 kados yep 12:07 kados tumer: what's up? 12:07 kados I'm just getting Chris's cql search working 12:07 kados http://zoomopac.liblime.com/cgi-bin/koha/opac-cql.pl 12:08 kados I've got another NPL demo on Jun 2nd 12:08 tumer i tested dev-week it worked on mine 12:08 kados arg 12:08 tumer probably you do not have the necessary fields in biblioitems and items 12:09 kados let me check 12:09 kados in biblioitems I have 12:09 kados | marc | blob | YES | | NULL | | 12:09 kados | marcxml | text | | | | | 12:09 tumer you need marc,lcsort in biblioitems and onloan and Cutterextra in items 12:09 kados don't have lcsort 12:10 kados hang on ... 12:10 tumer the dev-week updater have these 12:10 kados so I'll just run updateadatabase then 12:11 tumer i presumo so 12:11 kados wow, lots of changes :( 12:11 kados this might take a while 12:12 tumer not all mine i believe they are version3 changes 12:12 kados altering borrowers emailaddress to email 12:12 kados ? 12:12 kados yea, that looks like a version 3 change 12:12 kados hmmm 12:12 kados why would a version 3 updatedatabase be in dev_week? 12:13 tumer i donno got mixed up i think when i updated dev-week or something 12:13 kados ahh 12:13 tumer i only added 2 lines to it though 12:13 kados hehe 12:13 kados I'll check the cvs log 12:14 kados gunna have to gut that db too 12:14 kados with all those changes :-) 12:15 kados tumer: can you dump out of mysql your entire database structure and commit it to dev-week? 12:15 kados tumer: then I'll customize the updatedatabase script to just add the differences between yours and rel_2_2 12:16 tumer i tought i did that gave it to chris at dev-week cause i donno how to do it 12:17 kados if you have mysqldump you can go: 12:17 kados mysqldump -uroot -pmypass --add-drop-table -d koha > koha.sql 12:17 kados the '-d' means 'no data' 12:18 kados then you just get a bunch of CREATE statements 12:18 tumer and drop does not mean delete? 12:18 kados nope 12:18 kados tumer: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html 12:18 kados --add-drop-table 12:18 kados Add a DROP TABLE statement before each CREATE TABLE statement. 12:19 kados it just means to add DROP TABLE to the file before CREATE TABLE 12:24 kados tumer: will zebra work with symlinks? 12:24 tumer what is symlinks 12:24 kados hehe 12:24 kados nevermind 12:24 tumer feeling dumb now 12:25 kados a symlink is just a way to say: 12:25 kados /koha is the same as /home/koha 12:25 kados you can link the two dirs together 12:25 kados for zebra this would be good 12:25 kados because we could have a logical structure: 12:26 kados /koha/zebradb/biblios 12:26 kados that was linked to a completely separate disk: 12:26 kados /zebradb 12:26 kados woops ... 12:26 kados /biblios even 12:26 kados in fact, you might want to have like 8 separate disks for one Koha:Zebra 12:27 kados /zebradb/biblios 12:27 kados /zebradb/biblios/shadow 12:27 kados /zebradb/authorities/shadow 12:27 kados /zebradb/authorities 12:27 kados /zebradb/items 12:27 kados /zebradb/items/shadow 12:27 kados etc. 12:27 kados that way your system doesn't slow down on searches when updates are happening 12:28 kados throw in a couple more disks, one for mysql, one for the OS 12:28 kados :-) 12:37 tumer committed koha.sql and addbiblio.pl 12:39 kados thx 12:39 kados addbiblio.pl? 12:39 dewey addbiblio.pl is what it was there 12:40 kados dewey: addbiblio.pl is how to add new MARC records to Koha 12:40 dewey ...but addbiblio.pl is what it was there... 12:40 tumer it used SearchMarc changed it to Search not important though 12:40 kados dewey: no it isn't 12:40 dewey kados: i'm not following you... 12:40 kados dewey: no addbiblio.pl is how to add new MARC records to Koha 12:40 dewey OK, kados. 12:40 kados hmmm 12:41 kados so you did change addbiblio then 12:41 kados I'll try the new one 12:41 kados and I'll also try the db dump 12:41 kados I know you have to go 12:41 kados thanks for the help! 12:41 tumer it uses findduplicate from these pms 12:41 kados ahh 12:42 tumer now it will use zebra to actually serach for a duplicate 12:42 tumer i do not have a searchmarc any more so gives me error on mine 12:43 kados gotcha 12:43 tumer this cql search not working 12:44 tumer i write title=book get nothing any=book get nothing 12:44 tumer how do i use it 12:45 kados try just book 12:45 kados I dunno, I'm discovering myself 12:45 kados :-) 12:45 tumer same thing 12:45 kados it show results 12:45 kados just doesn't say what they are :-) 12:45 kados see the list of 'title' after you search :-) 12:46 tumer yep 12:46 kados it's finding stuff, just not displaying the results 12:46 kados I'll hack on this some more and commit it to dev_week when I'm satisfied 12:47 kados tumer: also, let me know how libxml2 and XML::LibXML work out 12:48 kados tumer: if Record.pm will ever be usable by you :-) 12:48 tumer well I have to get something working 12:49 tumer cause when everything was marc we did not have problems 12:49 kados yea 12:49 kados another option 12:49 kados would be to fix the html2marc sub 12:49 kados I included it in Record.pm 12:49 kados along with documentation on what the bugs are 12:50 tumer but needing xml is giving me problems with characters that do not convert properly from marc thus breaking the xml file 12:50 kados yep 12:50 tumer thus zebra not getting updated 12:50 kados libxml2 and XML::LibXML ... 12:50 kados but make sure they are compatible versions 12:50 kados and you need to install libxml2 first 12:51 kados I'd check the docs for XML::LibXML carefully 12:51 kados everything's working really nicely since I did that on my box 12:51 kados hopefully it works on windows too 12:52 kados tumer: http://search.cpan.org/src/PHISH/XML-LibXML-1.58_1/README 12:52 kados tumer: there's some good explaination there 12:52 kados tumer: ahh ... you've even got a precompiled PPM package: 12:53 kados tumer: http://theoryx5.uwinnipeg.ca/ppmpackages/ 12:53 tumer i alreday have that 12:54 kados what version of libxml2? 12:55 tumer i'll paly with this later kados. I have other things to attend now. thanks 12:55 kados np, I hope it works 13:16 kados be back soon 14:27 chris good grief 14:27 chris mhafen is submitting bugs and patches like a madman 14:28 owen Do you know who mhafen is chris? 14:28 chris nope 14:29 chris i like the fact that s/he's supplying a patch for all his bugs/enhancements though 14:29 chris his or her i should say 14:30 chris im up early cos i have to go to a meeting, but ill try to read through them all later 14:31 chris and apply what I can and close a few of them 14:31 chris if the code looks nice, we should maybe see about getting them cvs access, so they can commit themselves :-) 14:32 chris hows things anyway owen? 14:32 owen Just working on the giant zoom opac search screen for npl 14:32 owen trying to make sense of all those options 14:33 chris ahh yeah 14:33 chris i think a good start if you havent already is make it default to anywhere, not starting with :) 14:34 owen right now it's defaulting to both "full phrase" /and/ "starting with" for some reason... not sure if it's something I broke or if it's the script 14:34 chris :) 14:36 chris hmm i think ill email mhafen and ask them to introduce themselves on the koha-devel list 14:36 owen I think it's a great idea 14:37 kados hey guys 14:37 chris heya kados 14:37 kados chris: just got a command-line CQL federated search client (asynchronous) working :-) 14:37 chris woot 14:38 kados only took ten minutes :-) 14:39 chris email away 14:42 chris right i better shut down this laptop and pack it up 14:43 chris cyas later 21:13 dean2 I like the fibreoptic one too 21:13 dean2 http://staff.katipo.co.nz/gallery/album326/aae 21:13 dean2 I like the cutout look of the NZmap in the logo 21:14 dean2 just a shame it obscures the 21:14 dean2 "registration and accomodation" 21:14 dean2 nav heading 02:12 btoumi hi everybody 02:12 pierrick hi btoumi 02:12 btoumi hi pierrick 03:08 btoumi hi hdl 03:08 ToinS hi all ! 03:09 hdl hi 03:09 dewey salut, hdl 04:36 paul hdl around ? 04:52 alaurin hi everybody 04:52 paul hello alaurin 04:52 paul (trying to setup a VPN between marseille & montpellier 04:52 paul ) 04:52 alaurin very funny game i suppose 04:53 paul netgear rock ! 04:53 paul 10 mn to setup the router & "rebuild" my local network 04:54 paul (could you check that bureau.paulpoulain.com show my local page ?) 04:55 alaurin ok 04:55 paul ouaip. except that it is not perfect from "inside" the network... 04:55 paul but i'll investigate later 04:56 paul http://i5.bureau.paulpoulain.com/cgi-bin/koha/mainpage.pl fails, right ? 04:57 alaurin for me it's fails ... 04:59 alaurin i've got a little question, is the function "cuecatbarcodedecode" is still using ??????? on version 3.0 ???? 04:59 paul_lunch going to lunch. read you later 04:59 alaurin ok 07:16 kados hi all 07:16 kados @tell 07:17 paul hello joshua 07:18 kados it seems infobot doesn't have a feature I was hoping for 07:18 btoumi hi joshua 07:19 kados hey btoumi 07:20 paul ok, guys, the tuesday good news : 07:20 paul - I have decided to hire Antoine for 6 motnsh 07:20 paul - He accepted our proposal 07:20 paul - hdl is OK with it too 07:20 paul so ... 07:20 paul between june 19th and dec 19th, ToinS will be available full time on HEAD. 07:21 paul I will announce it officially on koha-devel ASAP 07:21 kados that's great paul! 07:21 pierrick_ good :-) 07:21 paul (until june 19th, he will work for 1 week on OpenCataloger & get some free time 07:21 paul hi pierrick_ 07:21 paul hi pierrick even ;-) 07:23 paul the 2nd good news for today : I have a new screen (LCD 20.1") and a new router, that we will use to create a VPN between hdl & antoine/me 07:25 kados cool 07:25 kados hey pierrick 07:25 pierrick hi kados 07:26 pierrick kados, may I send you the extension manager today ? 07:26 kados pierrick: yes please :-) 07:26 paul pierrick: when do you plan to work on coding rules ? 07:26 kados pierrick: not sure I'll have much time to install today, but definitely soon 07:26 kados i also have some ideas to share 07:26 pierrick paul, right now 07:27 paul in something like 3 weeks we will have Antoine available to clean cvs HEAD, so it would be interesting to have complete coding rules 07:27 paul pierrick: ++ 07:27 kados last night Ryan and I discussed the problem of dealing with old koha tables and full MARC support in the same system 07:28 kados we concluded that it could be acomplished by adding a higher level to the current scheme ... by grouping biblioitems according to the FRBR algorithm 07:28 pierrick I've read what you said during last IRC meeting 07:28 pierrick FRBR ? 07:28 kados Functional Requirements for Bibliographic Records 07:29 kados we can take the MARC records in the system, run them through this algorithm, and it will generate a 'work' record for us 07:29 kados that can be used only for searching ... but only for libraries who want it 07:30 kados so we would have zebra databases: 07:30 kados frbr_work 07:30 kados biblios 07:30 kados items 07:30 kados authorities 07:30 dewey rumour has it authorities is authority records 07:30 kados and reservoir 07:30 dewey it has been said that reservoir is identical to biblios but not the actual catalog 07:31 kados dewey: no, reservoir is where downloaded MARC records are stored before entering the true catalog 07:31 dewey kados: wish i knew 07:31 kados dewey: no reservoir is where downloaded MARC records are stored before entering the true catalog 07:31 dewey wish i knew, kados 07:31 kados dewey: no reservoir is the place downloaded MARC records are stored before entering the true catalog 07:31 dewey OK, kados. 07:31 kados :-) 07:31 kados anyway ... 08:13 btoumi hi tumer 08:13 tumer hi btoumi 08:14 ToinS hi tumer 08:14 btoumi how are u in cyprus 08:14 btoumi ? 08:14 tumer for the next 24 hrs yes 08:15 tumer i am in cyprus for the next 24 hrs i mean and its very hot 37 degrees 08:15 kados hiho tumer 08:15 tumer hio 08:16 tumer kados: this lbxml2 thing is a C library. ý have it because its needed for zebra compiling 08:16 kados right 08:16 tumer but what do i do with it for our xml problem? 08:16 kados sure 08:16 kados there's a perl wrapper for it 08:16 kados called XML::LibXML 08:17 kados find out what version of libxml2 you have 08:17 tumer 2.2.6.23 08:17 kados then, check the README for XML::LibXML I posted yesterday to make sure your version works with the latest CPAN 08:17 kados ok ... sec 08:18 kados looking here: 08:18 kados http://search.cpan.org/src/PHISH/XML-LibXML-1.58_1/README 08:18 kados cool ... so yours works fine 08:18 kados version 2.6.5: tested; not working (broken XIncludes) 08:18 kados o up to version 2.6.8: tested; working 08:18 kados or at least it should 08:19 kados so it's probably easiest to install it via the PPM package 08:19 kados http://theoryx5.uwinnipeg.ca/ppmpackages/ 08:20 kados here's how to install it: 08:21 kados C:\>ppm install http://theoryx5.uwinnipeg.ca/ppmpackages/XML-LibXML.ppd 08:21 kados (I think, never actually used ppm before) 08:47 kados using the stuff in the new Record.pm 08:47 kados about 1/3 done, so far no crashes :) 09:00 hdl hi 09:00 kados hey hdl 09:06 osmoze hi 09:06 kados osmoze: yo 09:20 pierrick hi osmoze 09:21 kados anyone know if there's already a script to take raw MARC data that already has biblionumber and itemnumber info in it and import it into the new koha-zebra? 09:21 kados I think bulkmarcimport will just delete existing biblionumber, etc. 09:25 kados morning owen 09:25 owen Hi 09:33 pierrick is it OK if I create a sub dedicated to insert and update tables in the database ? 09:33 pierrick and advise to use it in the coding guidelines? 09:33 pierrick the goal is to make updates and inserts more readable 10:12 kados tumer: is there currently a script to import records that already have 090 (biblionumber)s but that don't exist in the koha tables? 10:16 kados tumer: is there currently a script to import records that already have 090 (biblionumber)s but that don't exist in the koha tables? 10:17 tumer I think there should be a script at head that reads from ver2_2 tables and populates ver3 tables 10:17 kados hmmm ... not quite the same 10:17 kados I've got a set of MARC records I exported 10:18 kados then I converted them to UTF-8 10:18 kados and I can index them in zebra (they have 090, etc.) 10:18 tumer oh sorry I see what you mean, I'll check whether I have one myself 10:18 kados cool, thanks 10:18 kados if not I'll write one 10:19 kados bulkmarcimport should have an option in fact 10:21 tumer kados: I am committing one now to head 10:21 tumer but it requires them to be in zebra 10:22 kados tumer: ok, so you : 10:22 kados 1. index with zebra 10:22 kados 2. run this script 10:22 kados ? 10:23 tumer and it updates the koha tables with marc records 10:23 tumer that is they have to have biblionumbers 10:23 kados based on what's in zebra? 10:23 kados nifty 10:23 kados yea, that's just what I'm looking for 10:24 tumer it can be modified to read the marc file rather than zebra if you like 10:24 kados well, yea, but i can do that easily enough I think 10:25 kados or if you want to do it that'd be ok too :-) 10:25 kados I've got to head out for about 3 hours in a few minutes 10:25 tumer no I am not doing it now. Its also hardcoded with 090 for biblionumber. Jut changing that line will make it globally usable 10:26 pierrick http://wiki.koha.org/doku.php?id=en:development:codingguidelines 10:26 kados tumer: do you remember the query for finding out how many records exist in a zebra db? 10:26 kados pierrick++ 10:26 pierrick (just writtent about SQL queries, I continue writting on my local wiki) 10:26 kados (yep, nice job) 10:27 tumer no I do not remember its supposed to be answered by ID on our zebralist 10:27 kados I'll look there 10:28 kados % yaz-client host:port/IR-Explain-1 10:28 kados Z> find @attr exp1 1=1 databaseInfo 10:28 kados Z> form xml 10:28 kados Z> show 1 10:31 kados hey paul 10:31 paul hey 10:31 paul (VPN active, but some problems remaining... today is a sysadmin day !) 10:31 tumer kados:did that scrip work? it did not with me 10:33 kados hmmm 10:33 kados haven't got a system to try it on yet 10:33 kados tumer: whats' the name of the script? 10:33 kados akkk, I've got to go ... 10:34 tumer i am talking about what you have written on the screen 10:36 kados I get : 10:36 kados [13] Present request out of range -- v2 addinfo '1' 10:36 kados but we might not have 'form xml' 10:37 tumer it returns 0 hits 10:37 kados huh 10:37 kados I've gotta run, late for a meeting 10:38 tumer kados:I have modified this script named import_to_biblioitems 10:38 kados thanks 10:38 tumer commiting now. it will take -f filename and do it from thare 10:39 kados tumer: thanks! 10:39 kados tumer: I'll try it when I get back