← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| 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 | kados are you here? | |
| 12:07 | kados | yep |
| 12:07 | tumer: what's up? | |
| 12:07 | I'm just getting Chris's cql search working | |
| 12:07 | http://zoomopac.liblime.com/cg[…]/koha/opac-cql.pl | |
| 12:08 | 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 | in biblioitems I have | |
| 12:09 | | marc | blob | YES | | NULL | | | |
| 12:09 | | 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 | 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 | 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 | ? | |
| 12:12 | yea, that looks like a version 3 change | |
| 12:12 | hmmm | |
| 12:12 | 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 | I'll check the cvs log | |
| 12:14 | gunna have to gut that db too | |
| 12:14 | with all those changes :-) | |
| 12:15 | tumer: can you dump out of mysql your entire database structure and commit it to dev-week? | |
| 12:15 | 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 | mysqldump -uroot -pmypass --add-drop-table -d koha > koha.sql | |
| 12:17 | the '-d' means 'no data' | |
| 12:18 | then you just get a bunch of CREATE statements | |
| 12:18 | tumer | and drop does not mean delete? |
| 12:18 | kados | nope |
| 12:18 | tumer: http://dev.mysql.com/doc/refma[…]en/mysqldump.html | |
| 12:18 | --add-drop-table | |
| 12:18 | Add a DROP TABLE statement before each CREATE TABLE statement. | |
| 12:19 | it just means to add DROP TABLE to the file before CREATE TABLE | |
| 12:24 | tumer: will zebra work with symlinks? | |
| 12:24 | tumer | what is symlinks |
| 12:24 | kados | hehe |
| 12:24 | nevermind | |
| 12:24 | tumer | feeling dumb now |
| 12:25 | kados | a symlink is just a way to say: |
| 12:25 | /koha is the same as /home/koha | |
| 12:25 | you can link the two dirs together | |
| 12:25 | for zebra this would be good | |
| 12:25 | because we could have a logical structure: | |
| 12:26 | /koha/zebradb/biblios | |
| 12:26 | that was linked to a completely separate disk: | |
| 12:26 | /zebradb | |
| 12:26 | woops ... | |
| 12:26 | /biblios even | |
| 12:26 | in fact, you might want to have like 8 separate disks for one Koha:Zebra | |
| 12:27 | /zebradb/biblios | |
| 12:27 | /zebradb/biblios/shadow | |
| 12:27 | /zebradb/authorities/shadow | |
| 12:27 | /zebradb/authorities | |
| 12:27 | /zebradb/items | |
| 12:27 | /zebradb/items/shadow | |
| 12:27 | etc. | |
| 12:27 | that way your system doesn't slow down on searches when updates are happening | |
| 12:28 | throw in a couple more disks, one for mysql, one for the OS | |
| 12:28 | :-) | |
| 12:37 | tumer | committed koha.sql and addbiblio.pl |
| 12:39 | kados | thx |
| 12:39 | 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 | so you did change addbiblio then | |
| 12:41 | I'll try the new one | |
| 12:41 | and I'll also try the db dump | |
| 12:41 | I know you have to go | |
| 12:41 | 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 | 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 | i write title=book get nothing any=book get nothing | |
| 12:44 | how do i use it | |
| 12:45 | kados | try just book |
| 12:45 | I dunno, I'm discovering myself | |
| 12:45 | :-) | |
| 12:45 | tumer | same thing |
| 12:45 | kados | it show results |
| 12:45 | just doesn't say what they are :-) | |
| 12:45 | 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 | I'll hack on this some more and commit it to dev_week when I'm satisfied | |
| 12:47 | tumer: also, let me know how libxml2 and XML::LibXML work out | |
| 12:48 | tumer: if Record.pm will ever be usable by you :-) | |
| 12:48 | tumer | well I have to get something working |
| 12:49 | cause when everything was marc we did not have problems | |
| 12:49 | kados | yea |
| 12:49 | another option | |
| 12:49 | would be to fix the html2marc sub | |
| 12:49 | I included it in Record.pm | |
| 12:49 | 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 | but make sure they are compatible versions | |
| 12:50 | and you need to install libxml2 first | |
| 12:51 | I'd check the docs for XML::LibXML carefully | |
| 12:51 | everything's working really nicely since I did that on my box | |
| 12:51 | hopefully it works on windows too | |
| 12:52 | tumer: http://search.cpan.org/src/PHI[…]XML-1.58_1/README | |
| 12:52 | tumer: there's some good explaination there | |
| 12:52 | tumer: ahh ... you've even got a precompiled PPM package: | |
| 12:53 | 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 | be back soon | |
| 14:27 | chris | good grief |
| 14:27 | 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 | i like the fact that s/he's supplying a patch for all his bugs/enhancements though | |
| 14:29 | his or her i should say | |
| 14:30 | im up early cos i have to go to a meeting, but ill try to read through them all later | |
| 14:31 | and apply what I can and close a few of them | |
| 14:31 | if the code looks nice, we should maybe see about getting them cvs access, so they can commit themselves :-) | |
| 14:32 | hows things anyway owen? | |
| 14:32 | owen | Just working on the giant zoom opac search screen for npl |
| 14:32 | trying to make sense of all those options | |
| 14:33 | chris | ahh yeah |
| 14:33 | 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 | 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 | right i better shut down this laptop and pack it up | |
| 14:43 | cyas later | |
| 21:13 | dean2 | I like the fibreoptic one too |
| 21:13 | http://staff.katipo.co.nz/gallery/album326/aae | |
| 21:13 | I like the cutout look of the NZmap in the logo | |
| 21:14 | just a shame it obscures the | |
| 21:14 | "registration and accomodation" | |
| 21:14 | nav heading | |
| 02:12 | btoumi | hi everybody |
| 02:12 | pierrick | hi btoumi |
| 02:12 | btoumi | hi pierrick |
| 03:08 | 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 | (trying to setup a VPN between marseille & montpellier | |
| 04:52 | ) | |
| 04:52 | alaurin | very funny game i suppose |
| 04:53 | paul | netgear rock ! |
| 04:53 | 10 mn to setup the router & "rebuild" my local network | |
| 04:54 | (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 | but i'll investigate later | |
| 04:56 | http://i5.bureau.paulpoulain.c[…]/koha/mainpage.pl fails, right ? | |
| 04:57 | alaurin | for me it's fails ... |
| 04:59 | 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 | @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 | - I have decided to hire Antoine for 6 motnsh | |
| 07:20 | - He accepted our proposal | |
| 07:20 | - hdl is OK with it too | |
| 07:20 | so ... | |
| 07:20 | between june 19th and dec 19th, ToinS will be available full time on HEAD. | |
| 07:21 | 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 | hi pierrick_ | |
| 07:21 | hi pierrick even ;-) | |
| 07:23 | 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 | hey pierrick | |
| 07:25 | pierrick | hi kados |
| 07:26 | 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 | 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 | 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 | 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 | FRBR ? | |
| 07:28 | kados | Functional Requirements for Bibliographic Records |
| 07:29 | 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 | that can be used only for searching ... but only for libraries who want it | |
| 07:30 | so we would have zebra databases: | |
| 07:30 | frbr_work | |
| 07:30 | biblios | |
| 07:30 | items | |
| 07:30 | 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 | 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 | ? | |
| 08:14 | tumer | for the next 24 hrs yes |
| 08:15 | 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 | 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 | there's a perl wrapper for it | |
| 08:16 | called XML::LibXML | |
| 08:17 | 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 | ok ... sec | |
| 08:18 | looking here: | |
| 08:18 | http://search.cpan.org/src/PHI[…]XML-1.58_1/README | |
| 08:18 | cool ... so yours works fine | |
| 08:18 | version 2.6.5: tested; not working (broken XIncludes) | |
| 08:18 | o up to version 2.6.8: tested; working | |
| 08:18 | or at least it should | |
| 08:19 | so it's probably easiest to install it via the PPM package | |
| 08:19 | http://theoryx5.uwinnipeg.ca/ppmpackages/ | |
| 08:20 | here's how to install it: | |
| 08:21 | C:\>ppm install http://theoryx5.uwinnipeg.ca/p[…]es/XML-LibXML.ppd | |
| 08:21 | (I think, never actually used ppm before) | |
| 08:47 | using the stuff in the new Record.pm | |
| 08:47 | 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 | I think bulkmarcimport will just delete existing biblionumber, etc. | |
| 09:25 | 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 | and advise to use it in the coding guidelines? | |
| 09:33 | 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 | 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 | I've got a set of MARC records I exported | |
| 10:18 | then I converted them to UTF-8 | |
| 10:18 | 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 | if not I'll write one | |
| 10:19 | bulkmarcimport should have an option in fact | |
| 10:21 | tumer | kados: I am committing one now to head |
| 10:21 | but it requires them to be in zebra | |
| 10:22 | kados | tumer: ok, so you : |
| 10:22 | 1. index with zebra | |
| 10:22 | 2. run this script | |
| 10:22 | ? | |
| 10:23 | tumer | and it updates the koha tables with marc records |
| 10:23 | that is they have to have biblionumbers | |
| 10:23 | kados | based on what's in zebra? |
| 10:23 | nifty | |
| 10:23 | 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 | or if you want to do it that'd be ok too :-) | |
| 10:25 | 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?[…]:codingguidelines |
| 10:26 | kados | tumer: do you remember the query for finding out how many records exist in a zebra db? |
| 10:26 | 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 | % yaz-client host:port/IR-Explain-1 | |
| 10:28 | Z> find @attr exp1 1=1 databaseInfo | |
| 10:28 | Z> form xml | |
| 10:28 | Z> show 1 | |
| 10:31 | hey paul | |
| 10:31 | paul | hey |
| 10:31 | (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 | haven't got a system to try it on yet | |
| 10:33 | tumer: whats' the name of the script? | |
| 10:33 | 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 | [13] Present request out of range -- v2 addinfo '1' | |
| 10:36 | but we might not have 'form xml' | |
| 10:37 | tumer | it returns 0 hits |
| 10:37 | kados | huh |
| 10:37 | 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 | tumer: I'll try it when I get back |
← Previous day | Today | Next day → | Search | Index