| Time |
S |
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/cg[…]/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/refma[…]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/PHI[…]XML-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.c[…]/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/PHI[…]XML-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/p[…]es/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?[…]: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 |
