Time Nick Message 17:25 tumer antoine still working? 18:26 kados tumer: I thought that the results list and the details page was displayed with data from zebra in catalogue-home.pl, am I wrong? 18:27 tumer the result list from zebra details.pl from koha 18:28 tumer I discussed this with paul at dev-week and it looked logical to leave it that way 18:29 tumer any probs? 18:33 kados nope, just missunderstood 18:33 kados it is pulling it from the MARC in Koha though, right? 18:33 kados (man, this import script is fast!) 18:33 kados 150K records in 3 minutes :-) 18:34 tumer i left the zebra bits in it as well you can modify it 18:34 kados hmm, it crashed at 66K 18:35 kados Can't call method "subfield" on an undefined value at marcimport_to_biblioitems.pl line 50. 18:35 kados that's strange 18:35 tumer thats a typical non 090 error 18:36 kados I ran missing090 script before I exported 18:38 tumer about zebra searchresults from zebra marcdetails from koha-marc 18:39 tumer about the previous error its probably too fast thats why? hehee 18:40 kados hehe 18:40 kados "about zebra searchresults from zebra marcdetails from koha-marc" ? 18:40 kados could you explain what you mean :-) 18:41 tumer we search zebra get the results on our page if you click a title to see the details we read the marcrecord from koha 18:42 kados hmmm 18:42 kados that doesn't seem to be the way it's working for me 18:42 kados before I ran the new script the search results weren't displaying any title/author/etc. 18:42 kados once I ran it, they showed up 18:42 kados on the detail page, there is still no MARC data 18:42 tumer wwhich new script? 18:43 kados the fast new import script 18:43 tumer it looks as if you are searching on koha 18:44 kados it shows up in the zebra log 18:44 tumer how come you have title and no marc deata? 18:44 kados also, searching on something I would expect to have tons of hits 18:44 kados like 'new' doesn't have any 18:45 kados it's strange 18:46 kados select count(*) from biblio 18:46 kados 0 18:46 kados :-) 18:46 tumer i cant see your search page. its giving me script error 18:46 kados yea ... owen was working on the template I think 18:47 kados http://zoomkoha.liblime.com/cgi-bin/koha/catalogue-home.pl 18:47 tumer ohh I see the problem 18:47 kados does that one work? 18:47 tumer nop 18:47 kados works for me 18:47 kados search on 'book' 18:47 tumer we only populated the marc records not the old koha db 18:48 tumer go to cataloguserach and choose display MARC 18:48 kados I don't even see the marc 18:48 kados where is it? 18:48 kados in the sql db I mean 18:49 tumer adnaced serach page bottom where you choose zoom or normal 18:49 kados yea ... 18:49 tumer marc records in biblioitems marc 18:49 kados ahh 18:49 kados select count(*) from biblioitems; 18:49 kados 0 18:50 kados nothing in items either 18:50 tumer oops what happening 18:50 kados that would explain the speed :-) 18:50 tumer i though you are upgrading not filling a blank db 18:51 tumer stay with me for an axplanation 18:51 kados ok 18:51 kados what I did: 18:51 kados 1. export data using export.pl 18:52 kados (just MARC) 18:52 kados 2. convert to UTF-8 using new Record.pm 18:52 kados 3. create a new db using your koha.sql 18:52 kados 4. import a MARC21 framework 18:52 kados and some basic sys prefs, etc. 18:52 tumer I know what you did 18:53 tumer this script expect this 18:53 tumer you change the data in mysql to utf8 18:53 tumer export marc 18:54 tumer use record and conevrt to utf 8 18:54 tumer and just reimport marc 18:54 tumer biblios, items etc were supposed to stay as they were 18:54 kados ahh 18:54 kados so I suppose I should try bulkmarcimport then instead 18:55 kados hey owen-away 18:55 tumer cause it seemed thats how it was described by paul or you before 18:55 tumer how to convert your existing database to utf8 18:55 kados IMO it's incorrect to attempt to do this in mysql 18:56 kados (the utf-8 conversion) 18:56 kados because things like the leader need to be adjusted 18:56 kados as well as record length, etc. 18:56 tumer just change this new script 18:56 kados not to mention conversion from MARC-8 (which mysql knows nothing of) to UTF-8 18:57 tumer instaed of marcbulcimport 18:57 tumer which will try to call char_decode 18:57 tumer instaed of $sth->execute 18:58 tumer use NEWaddbiblio($dbh, ... 18:58 kados ok 18:58 tumer it should populate all tables wwith NEW biblionumbers 18:59 tumer so export again rebuild zebra 18:59 kados tumer: with head or dev_week Biblio.pm? 18:59 tumer dev_week 18:59 kados tumer: I need the same biblionumbers 18:59 tumer anything i discuss with you is dev_week 18:59 kados tumer: ok, the new script was committed to head :-) 19:00 tumer did I? 19:00 kados think so 19:00 tumer rushing to get you a script and you see? 19:00 kados hehe 19:00 tumer we will need it there as well anyway 19:00 kados yep 19:01 tumer to have the same biblionumbers you have to trick mysql 19:01 tumer do you know any sql scripts 19:02 kados I know a bit 19:02 tumer or shall i write them here 19:02 tumer i cannot reach cvs i am at home 19:02 kados sure 19:02 tumer so have to write it here 19:02 kados what do you mean by scripts? 19:03 tumer well you see you have to fill biblio with biblionumbers 19:03 tumer even if nothing else 19:03 kados hmmm 19:03 kados maybe easier just to use the old db 19:03 tumer let me be more specific 19:04 tumer the script tries to do an update 19:04 kados I'm just trying to figure out the best upgrade path 19:04 tumer of you had not truncated your old data it would have worked 19:05 kados truncated? 19:05 tumer or if you have your old db it still will 19:05 kados don't worry, I've got plenty of backups :-) 19:05 tumer truncated=deleted 19:05 kados yea ... my thought was just that it would be cleaner to start with a completely new db 19:05 tumer new db new biblionumbers 19:06 kados yea, guess I hadn't considered that 19:06 kados ok, I'll just do it the old way 19:06 kados and try to make database modifications manually 19:06 kados actually 19:06 kados I can just import biblio, biblioitems, items from the old db 19:07 tumer yep 19:07 tumer utf8 are they? 19:09 kados no 19:09 tumer i just checked the db it will be possible to write a script to import new data with old biblionumbers 19:13 tumer not staright away though. try importing your old data from mysql 19:14 kados I've just imported biblio, biblioitems, items from old db 19:14 kados now I need to run something to update them with MARC data, right? 19:14 tumer k run the new script the speeder 19:14 kados k 19:15 tumer should be about 7min 19:16 kados still pretty fast 19:16 kados approx how long does indexing 150K records in zebra take for you? 19:16 kados (I think I clocked it at 30 min at one point) 19:16 tumer 10 min 19:17 kados ahh ... maybe less for me too, need to actual time it 19:17 tumer well may be more sometime 19:18 tumer building first time is longer 19:18 tumer rebuilding is fast 19:18 kados ok, done 19:18 tumer imported all? 19:18 kados (I'm only working with half the data here) 19:19 kados cool, marc detail working 19:19 kados brief display not thou 19:19 kados http://zoomkoha.liblime.com/cgi-bin/koha/detail.pl?bib=1286&type=intra 19:19 kados items not showing up either 19:19 tumer that is a blank page javascript error 19:20 kados weird 19:20 kados http://zoomopac.liblime.com/cgi-bin/koha/opac-catalogue-home.pl 19:20 kados working all of a sudden 19:20 kados wasn't working earlier 19:21 kados maybe the marc framework isn't the same as the data 19:21 kados sigh 19:21 kados ok ... 19:21 kados I'm gonna start over 19:21 kados get all the data in 19:22 kados run that script 19:22 kados clean up the framework beforehand 19:22 kados and then go to bed :-) 19:22 tumer cant see anything so good luck 19:22 kados you using IE? 19:22 kados try firefox 19:22 tumer did chris see that context.pm xml problem 20:01 kados ok, re-converting data to utf-8 20:01 kados and saving records with no 090 seperately 20:01 kados then I can bulkmarcimport them after 20:01 kados this is a real nightmare 20:02 tumer this 090 thing is a big bug noone is mentioning 20:03 kados I mentioned it 20:03 kados but that was before we had support 20:03 kados tumer: were you happy with the bugfix that Adam provided? 20:03 kados tumer: for the bug we just reported? 20:03 kados tumer: pretty fast turnaround for that 20:04 tumer is there a bugfix? 20:04 kados didn't you check your hotmail account? 20:04 kados adam has sent three or four responses by now 20:04 kados and a new patched version was released 20:04 tumer i am just trying to recompile the zebra 20:04 kados I haven't had a chance to test the fix yet 20:05 kados was hoping to get to that today, but I got sidetracked 20:05 tumer i ve been busy today and i am travelling tomorrow, infact today 20:07 kados right 20:07 kados :-) 20:07 kados well did you get the emails at least? 20:08 kados one from me, several from them 20:11 tumer 2 mails both from one with some comm. with adam 20:11 tumer both from you 20:13 kados you didn't get the one from adam? 20:13 kados the last one? 20:13 tumer found them reading.. 20:14 kados apparantly the latest snapshot implements the bugfix 20:15 tumer I'll have to check and see 20:15 kados I'm tied to debian and would rather not complicate my already complicated system to try to see if it's fixed 20:15 kados esp since I've got to demo this on Friday 20:15 kados :-) 20:16 tumer I will still change the code if its going to give me NULL results 20:16 kados I guess I don't completely understand their answer 20:16 tumer the only reason I wrote it that way is for speed 20:17 tumer what they are saying is: 1- koha can change their code 20:17 tumer 2- they will provide a null value instaed of error 20:18 tumer which does not mean anything at all 20:18 kados yea, doesn't sound like much of a fix 20:18 kados suppose you'll need to check for a null value 20:19 tumer i ll check it this monday 20:19 kados k 20:19 kados could you write them a response, thanking them for their promptness and saying you'll look into it? 20:19 kados to see if it will work for us 20:19 kados if not, I'll do it 20:20 kados just let me know :-) 20:20 tumer i also bugged them today on support 20:20 kados ?? 20:20 kados at support@ ? 20:20 tumer about 1.4 not working at all now 20:20 kados can you cc me on those? 20:20 tumer yes support@indexdata.dk 20:21 tumer sure 20:21 kados please cc me when you send mail to that address so I can keep track 20:21 tumer i'll do that 20:22 kados thx 20:22 tumer so you thank them or you wnt me? 20:26 kados you can :-) 20:27 tumer k 20:28 tumer did you mention context.pm to chris about the xml thing 20:34 tumer night everyone 02:20 btoumi hi everybody 02:21 ToinS hi btoumi 02:21 pierrick hi #koha 02:21 ToinS hi pierrick 02:23 btoumi hi paul 02:23 paul et oui btoumi , je suis là ;-) 02:23 btoumi ;=) 03:38 chris hi all 03:38 ToinS hi chris 03:38 paul hi chris 03:42 chris hows the weather over there today? 03:42 paul no more wind. 03:43 chris :-) 03:43 paul very sunny, although very cold too 03:43 paul strange weather for Marseille in fact ! 03:43 chris yes, specially for summer 03:44 Comete hi 03:44 paul hello saint lo 03:44 paul bienvenu 03:44 chris hi comete 03:45 Comete salut paul :) 03:45 Comete hi chris 03:45 Comete paul: merci pour votre réponse 03:46 paul chris being from new zealand, as many other, we use to speak english when there is not only frenchies on the chanel 03:47 Comete ok 03:48 Comete paul: so, does the "import" script import documents informations too ? 03:49 Comete documents = items , right ? 03:49 paul (on phone) 03:51 chris alaurin: did you see http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1080 03:51 chris when you have made your changes to the circulation.pl .. i might try to integrate this patch 03:52 alaurin not yet 03:52 alaurin ok i do it 03:55 chris theres no big hurry, as I have no idea what code to put in the template to make the browswer make a sound :-) but I think its a good idea 03:55 Comete my problem is that i've exported "notices" (don't know the word in english) in UNIMARC encoding from my old application and i've imported it in koha, but now there are no complete items informations (price, etc...) 03:59 Comete so my question is : Are the items informations really exported with the "notices" ? or do i have to export items in a CSV file ? 04:00 chris what is your old application? 04:07 Comete chris: Orphee from C3RB 04:07 chris ahh, in that case i have no idea ... hopefully paul does :) 04:08 paul (back) 04:14 paul Comete: we can't know if Orphee export items or not. 04:14 paul but you can dumpmarc the file ;-) 04:15 paul in misc directory, there is a script called dumpmarc.pl 04:15 paul that should be helpful. 04:15 paul if you have setup Koha with Unimarc, your item informations should be in tag 995 04:20 Comete paul: ok but where should i look to see if price information is well exported ? 04:21 paul (on phone again) 04:22 pierrick hdl, are you around? 04:22 hdl yes 04:23 pierrick hi hdl :-) 04:23 hdl hi 04:23 dewey hi, hdl 04:23 paul Comete: with dumpmarc, you'll see all your datas. so : 04:23 pierrick hdl, I see you've commited the authorities tree :-) 04:23 paul 1- dump a biblio (=english for "notice") 04:23 paul 2- find it's ISBN or title 04:24 paul 3- search it in Orphee 04:24 hdl yes. a first working version. 04:24 paul 4- get the price written here 04:24 hdl Needs some good css 04:24 paul 5- look in your dumpmarc if you see this value 04:24 hdl and some javascript debugging too. 04:24 paul 6- if yes => just pick the field/subfield 04:24 paul - if no => it's not exported ! 04:24 chris ohh well done hdl :-) 04:25 paul everybody saw it's in a specific branch. 04:25 pierrick yes (I like the way you store father and grandfather ;-) 04:25 paul so, a cvs update on head or rel_2_2 won't work for this 04:26 hdl (thx pierrick ;) ) 04:29 Comete paul: ok thank you 04:30 paul your welcome. 04:38 Comete paul: on some imported datas, accents aren't well displayed but on others it's ok, do you know why ? 04:38 paul ah, yes, I know why. and it's a bad news for you... 04:38 paul it means the encoding is not always the same. 04:39 paul (from Orphée probably) 04:39 paul there is no simple solution to this problem. You may have to modify your datas on the fly. 04:39 paul and that will probably be a pain for you, sorry :-( 04:44 Comete paul: ok 04:45 paul (although 'perldoc Encode' will be a good start for some help) 04:47 Comete paul: so i've exported one biblio and edited it, i can see the barcode, but if i look in Koha database directly (items -> barcode) the value is NULL... any idea ? 04:47 paul yes ;-) 04:48 paul http://www.kohadocs.org/migrer_ses_donnees.html#d0e174 04:48 paul le champ en question ne doit pas être correctement "connecté" dans le paramétrage. 04:48 paul là, tu arrives dans la partie compliquée de la migration... 04:49 paul (oups... back to english. although kados should still be sleeping & chris starting to sleep ;-) ) 04:49 paul (so we are only frenchies...) 04:49 chris not asleep yet :) 04:50 paul Comete: pierrick is from Ineo (Paris), hdl is Henri Damien (Montpellier, my business partner), ToinS is Antoine (Marseille, my business partner too) 04:50 Comete ok 04:50 paul and alaurin being Arnaud (SAN-OP, Istres) and btoumi being Bruno (SAN-OP too) 04:50 paul logbot is the bot that record all our discussions on irc.koha.org 04:50 Comete ok 04:50 paul dewey being our stupid-genius 04:50 dewey paul: huh? 04:51 paul dewey : Comete is someone from Saint-Lo, a library planning to migrate to Koha 04:51 dewey OK, paul. 04:51 paul dewey : who is Comete ? 04:51 dewey Comete is someone from Saint-Lo, a library planning to migrate to Koha 04:51 paul hehe, dewey : good boy 04:52 Comete :) so before importing biblios and items i must configure the grid with the fields i want to use, right ? 04:53 paul right 04:53 paul and migrer_ses_donnees document explain how to do this 04:53 Comete so i've imported during 24h for nothing... :) 04:53 Comete lol 04:54 paul a trick : modify bulkmarcimport to import just 1 biblio on 100 04:54 Comete paul: i should read all the doc before doing something :) 04:54 paul NEWnewbiblio() unless $i % 100; will do the trick in bulkmarcimport 04:54 paul Comete: right ! 04:54 paul are u a student ? 04:54 paul (because i've been told some student will work on the migration) 04:55 paul (but I may be wrong) 04:55 paul if you plan to come here quite often, it would be nice to introduce yourself with : 04:55 paul - subsrcibing to koha-devel mailing list 04:55 Comete paul: no, i'm employed as a technician by the town 04:55 paul - sending a mail to the list. 04:56 Comete paul: ok i will do it, you're right i'm not polite 04:56 Comete :) 04:56 paul but do this only if you're decision to move to koha can be made public ! 04:56 Comete ok 04:57 Comete i can't say that at the moment... 04:58 Comete before i must make koha usable for users with a lot of datas 05:00 Comete but i'm not working for the library, i'm a computer scientist, so i don't understand yet all the vocbulary. So i'm trying to work the more they can with the employees of the library but that's not easy 05:01 paul that's where is my business : being a computer scientist, but librarians sometimes ask me wether i'm a librarian or not :-D 05:01 Comete i haven't got all my time to work on this project, we are 3 technicians for 300 users... 05:01 Comete on 20 differents sites 05:07 paul wow ! 05:08 paul Comete: 300 users don't means you have 300 librarians I hope ;-) 05:08 Comete paul: does the dumpmark.pl display depends on the grid configuration ? 05:08 Comete paul: no :) 05:08 paul nope. 05:08 paul it just dump a iso2709 file. it even don't depend of Koha. 05:08 Comete paul: because i can see the barcode number directly in the exported file xw 05:09 Comete with an editor 05:09 Comete but not with dumpmarc.pl 05:12 paul mmm... means it's poor iso2709... 05:12 paul did you try with -W parameter ? 05:12 paul it my stop saying "not a correct iso2709 file" 05:13 paul in this case, then you're really in a middle of a pain... 05:13 Comete lol 05:14 Comete paul: does it stop at start or at the end, because i've got 80000 entries in my file :) 05:14 paul ctrl-C 05:14 paul to stop it. 05:15 paul it's a basic script you know ;-) 05:15 Comete paul: yes i know but does the message "not a correct iso2709 file" appears directly ? 05:16 paul it shows the message & stops ! 05:16 Comete paul: so no message then :) ourah ! 05:17 paul not reall "hurray !!", if you don't see your data ! 05:18 chris alaurin: just tried out your commit, works great, the stuff i did still works and your new stuff looks really good 05:19 chris so im going to bed happy 05:19 chris :) 05:19 chris night all 05:20 Comete good night chris 05:21 Comete paul: sure 05:21 paul 'night chris 05:22 chris oh before i go to bed, congrats toins .. great news that you are working on 3.0 (i just saw the email) 05:22 Comete paul: sorry i'm stupid i didn't look at the good file :p 05:23 Comete paul: all is ok 05:24 Comete paul: is there a script to delete all the datas in the database ? 06:16 kados Comete: bulkmarcimport can do it for you (for bib data) 06:17 kados Comete: use the 'marcdump' and 'marclint' utilities to check the validity of an iso2709 file 06:25 Comete kados: thanks, my file is valid and i see all my datas now with dumpmarc.pl 06:26 Comete kados: are items deleted too with bulkmarcimport ? 06:26 paul Comete: yep. 06:26 kados Comete: yep 06:26 paul hello kados/joshua 06:26 paul 'morning 06:26 kados hey paul 06:27 kados can't wait to have toins start working on head :-) 06:32 kados the new search is oh so nice though 06:32 kados :-) 06:53 paul ./wengophone: error while loading shared libraries: libssl.so.5: cannot open shared object file: No such file or directory 06:53 paul " 06:53 paul :-( 06:55 Comete paul: is openssl installed ? 06:56 paul http://forum.mandrivaclub.com/viewtopic.php?t=49537&sid=a5e2bb648a42bdc8418f078eb7ba4c6c 06:56 paul ln -s /usr/lib/libssl3.so /usr/lib/libssl.so.5 06:56 paul and it works ;-) 06:56 Comete cool 06:56 paul (just ggled "wengo mandriva") 07:41 Comete is there any plan to make a XUL interface for Koha, it could be nice ? 07:42 paul Comete: yes, it coud be nice. not planned for instance, although OpenCataloger is XUL, so it may be a 1st step 07:43 Comete paul: OpenCataloger ? what's this ? 07:44 paul a new tool to create MARC records, that can be independant from Koha or used with it 07:45 Comete cool :) 07:46 Comete when doing my biblio import, how can i choose the grid to use ? 07:46 paul your librarian has the answer. it depends on your datas & what they want ! 07:49 Comete paul: yes but when they have done their grid, how can i select the "toto" grid for the import ? 07:49 Comete paul: it's possible to make differents grids, isn't it ? 07:50 paul usually from itemtypes. but sometimes from something else, that your librarian will explain, as he knows your cataloguer 07:50 paul yes, of course 07:50 Comete sorry i don't explain myself very well 07:51 paul in french it would be better ? 07:51 Comete paul: yes i hope :) 07:51 paul donc, causons français. 07:51 Comete paul: ok 07:52 Comete paul: admettons qu'ils aient paramètré une grille qu'ils ont appelé "TOTO" 07:52 Comete paul: avec tout ce qu'il faut dedans 07:53 Comete paul: comment, au moment ou je vais importer mes notices, je précise que l'import doit se faire par rapport à la grille "TOTO" 07:53 paul et bien tu modifies bulkmarcimport pour qu'à l'import le NEWnewbiblio soit appelé avec la grille kivabien 07:53 Comete y a-t-il un paramètre pour le script d'import 07:53 paul et ta bib te dira dans quels cas ils veulent "TOTO" 07:53 paul genre : notice saisie avant le X, ou du type Y, ou sur le site Z ... 07:54 paul bulkmarcimport est juste un outil générique, tuné pour chaque bib. 07:54 paul je dois bien en avoir une vingtaine de différents maintenant ! 07:54 paul par exemple, les bibs veulent parfois supprimer des trucs ou en rectifier d'autres lors de la migration 07:54 paul => hop, on modifie bulkmarcimport pour corriger les notices avant le NEWnewbiblio 07:55 Comete paul: donc il est improbable que toutes mes notices et exemplaires utilise la meme grille ? 07:55 paul pas sûr, ils peuvent trouver que ca leur suffit 07:55 paul mais à minima, il devrait qd même y avoir 3 choses ! 07:55 paul - monographies 07:55 paul - périodiques 07:55 paul - multimédia 07:55 Comete paul: oulala 07:55 Comete :) 07:56 paul monographie = livre en bibliothécairois 07:56 Comete l'outil (merdique) d'export me permet juste de faire une selection sur des codes barre... 07:56 Comete c'est pas gagné 07:57 paul pas grave, tu joues avec MARc::Record, et tu regardes dans la notice après l'avoir lue dans bulkmarcimport. 07:57 paul genre : 07:57 paul $grille='MONO' if $record->subfield('200','b') eq 'RGGEGREZG'; 07:57 paul et hop, 1 nouveau lien : 07:57 paul http://marcpm.sourceforge.net/MARC/Record.html 07:57 paul http://marcpm.sourceforge.net/MARC/Field.html 07:58 paul tiens, ca fait 2... 07:58 paul bon, cela dit, faut que j'arrête de trop t'aider, vous n'allez plus avoir besoin de faire appel à mes services sinon :-D 07:58 Comete lol 07:59 Comete oui vous avez raison 07:59 Comete paul: une dernière chose, comment marche logbot ? 08:00 paul tout seul : il loggue tout ce qui se dit ici, et c'est dispo sur irc.koha.org 08:00 Comete ok merci 08:00 paul c'est notre ami dewey qui est supposé être intelligent et répondre aux questions. 08:00 paul mais il est cmoplètement stupide, et nous fait plus rire qu'autre chose ! 08:03 Comete dewey: ca roule ? :) 08:03 dewey Comete: excuse me? 08:03 Comete lol 08:04 Comete dewey: paul thinks you are stupid... :) 08:04 dewey OK, Comete. 08:04 Comete lol 08:04 Comete c'est vrai qu'c'est rigolo 08:04 paul dewey : translate stupide from english to french ? 08:04 dewey paul: i haven't a clue 08:05 paul mmm... dewey is a translator too, or at least is supposed to be 08:05 paul but I never remember how to make it translate a word. 08:08 paul hi tnb / tina 08:08 tnb good morning/evening everyone! 08:08 tnb hi paul :) 08:10 alaurin paul: I've got a little question, for the color alerts in css, have you got any aswers about this question ????? 08:10 paul mmm... iirc, I asked on koha-devel 08:10 paul yep, although no subject. 08:10 paul see may, 19th 08:11 paul I think you can do it as we planned : having 2 css properties : 08:11 paul - warning 08:11 paul - problem 08:11 alaurin ok 08:14 alaurin but in my original program, I have css styles for different values of status of document (on loan is yellow, reserved is blue ......) 08:14 paul on loan => warning 08:14 paul reserved is a problem, that's true. 08:15 alaurin no, on loan has got is own property, different has warning 08:17 paul so, you may have to add 3 properties. 08:17 paul but as they are local to reserves, you could put a very clear warning in the stylesheet. 08:18 alaurin ok 08:34 paul welcome back, superman. 08:35 paul superman comes from krypton isn't it ? 08:36 kados hey tumer 08:36 kados tumer: got everything indexed 08:37 kados tumer: seems to be working really nicely 08:37 kados tumer: Owen and I will be working on interface today 08:37 kados tumer: and I'm gonna add a few new search types 08:37 kados http://zoomkoha.liblime.com/cgi-bin/koha/catalogue-home.pl 08:37 kados in case anyone's interested in trying it out 08:37 kados got 150K biblios (from NPL) 08:39 kados I'm adding CQL search atm 08:39 tumer yor link gives me internal sever error 08:41 kados ? 08:41 kados http://zoomkoha.liblime.com/cgi-bin/koha/catalogue-home.pl 08:41 kados works fine for me 08:41 kados (I was editing something, try again) 08:41 tumer now working 08:42 tumer no items ? 08:42 kados not in normal view 08:42 kados in MARC there should be 08:44 kados in MARC there should be items 08:44 kados don't know why the're not there in brief view 08:44 paul kados: MARCdetail is unavailable without a login it seems 08:44 kados paul: right 08:44 kados paul: it's the intranet :-) 08:45 paul but catalogue-home don't need one atm 08:45 kados right 08:45 kados it's set that way 08:45 tumer on search results no item details shows 08:45 kados tumer: right, why is that? 08:45 kados tumer: I didn't import issues of course 08:46 kados tumer: maybe my biblio,biblioitems,items tables don't have the right columls 08:46 tumer at least it should give the branch etc 08:46 kados no branches table imported 08:46 kados would that matter? 08:47 tumer yep items have to be mapped to marc 08:47 kados items are mapped to MARC 08:47 kados in the framework 08:47 kados is that what you mean? 08:47 tumer your items at 952 i believe 08:48 Comete paul: yes it is 08:49 tumer it tries to read which field is holdingbranch and then find the branchname 08:49 kados k, branches loaded 08:49 kados and they're showing up 08:49 kados what's supposed to go in the [] ? 08:50 tumer i cant see it yet 08:51 tumer i searched "book" found 45000 results but no holdingbranch 08:52 tumer well some with it some not 08:52 tumer [] contains location if you have that defined 08:54 kados maybe some don't have a holdingbranch 08:55 kados remember, NPL is running a hybrid 1.9/2.0/2.2 version of Koha 08:55 kados things were kinda shakey back then ;-) 08:55 kados (as if they're not now ;-)) 08:55 tumer kados: sorry [] contains itemcallnumber 08:55 kados ahh, right 08:55 kados they don't have itemcallnumbers 08:56 kados something I've got to fix with this upgrade (itemcallnumbers) 08:56 tumer k 08:56 tumer you got adams replies? 08:57 kados yep 08:57 kados one of them 08:57 kados this one: 08:57 kados Thanks. I am sorry we change index directory just like _that_.. But 08:57 kados that's the idea of 1.4.. until it gets official. 08:57 tumer and i forwarded the previous one 08:57 kados yep 08:57 kados thanks 08:58 tumer the new snapshot does not even compile but i am flying in half hour 08:59 kados hehe 08:59 kados the 1.3.x snapshot or the 1.4 snapshot? 08:59 kados (I think the fix is in both) 08:59 tumer 1.4 does not compile could not check 1.3 yet 09:00 kados right 09:00 kados tumer: have a safe flight ... and thanks for all your help! 09:01 tumer see ya 09:01 kados tumer: I've heavy documentation on how to get zebra working now :-) 09:01 kados ciao 09:57 kados hey owen 09:57 owen Hi 09:57 dewey privet, owen 09:57 kados sorry, working on the new cql search 09:57 kados didn't notice you come in :-) 09:57 owen dewey, what did you say to me? 09:57 dewey owen: i don't know 09:57 kados the other searches are working like a charm 09:58 kados http://zoomkoha.liblime.com/cgi-bin/koha/catalogue-home.pl 09:58 kados did you get my email about the advanced search? 09:58 owen Yes 09:59 kados did it make any sense? :-) 09:59 owen Yeah, I think so. I agree with you about the catalogue home page 09:59 kados cool 10:00 kados that's what I'm working on right now 10:00 kados I think the biggest thing they're going to be looking at 10:00 kados is how the page is layed out :-) 10:00 owen I see you added "Google-esque" to the intranet side 10:00 kados yea, it doesn't quite work yet :-) 10:00 kados but getting there 10:00 owen Agreed, re: page layout. That's why we really need to get it right 10:01 owen The first thing I'd like to do is step back and take a close look at all these search options 10:01 owen For instance: why is "call number" an option in the Simple Search? 10:02 kados well ... in my view, it's not the simple search screen 10:03 kados the good news is 10:03 kados it's really quite painless to shift things around 10:03 kados but ... 10:03 kados I'm not sure if that's the best use of our time atm 10:03 owen And by the way... What kind of holding database are we working with? Is this the NPL catalog? 10:03 kados yea, NPL 10:04 kados though the actual items might not be accurate 10:04 owen Ah... no items means no itemtype search, hunh? 10:05 owen Oh, no, it's just the detail screen isn't working 10:05 kados yea 10:05 kados the MARC detail screen works 10:05 kados probably because I didn't import itemtypes 10:05 kados hang on 10:05 owen Oh, it was just in the MARC record. 10:06 kados try it now 10:08 owen What did you mean by 'it's painless to shift things around?' 10:10 kados well ... 10:10 kados meaning that the way that the search is constructed is transparent to me 10:11 kados so we can group different options together 10:11 kados when we get further feedback from the staff 10:11 kados it's not like the old search 10:11 owen So the form itself is practically irrelevant as long as we have the right fields 10:11 kados where I had trouble understanding how it worked 10:11 kados well ... almost 10:11 kados next week, yes :-) 10:11 kados for now, i think we should stick with the elements we have 10:12 kados add a few types (like series) 10:12 kados and a couple new sort options (by date) 10:12 kados but that's the work of a moment 10:12 kados (once I get this cql stuff working) 10:12 kados what my goal is 10:12 kados tomorrow 10:13 kados is to bring my summary of the last meeting I had with NPL 10:13 kados and go point by point 10:13 kados and show how the new search does what they wanted 10:13 kados answer some questions, etc. 10:13 kados I don't have much time though 10:13 kados only 30 minutes 10:13 owen Do you have that list in digital form so you could send it to me? 10:14 kados yea, i sent it to koha-devel a while ago 10:14 kados I'll forward it to you 10:14 kados sent 10:14 kados brb 10:16 kados back 10:19 owen I don't seem to have permission to SCP opac-catalogue-home.pl 10:19 owen I want to point the search results page to opac-results.tmpl instead of catalogue/searchresults.tmpl 10:22 kados cql search working now 10:22 kados well, just got it to return results for the first time :-) 10:23 kados owen: k, try now 10:23 owen Nope 10:24 kados will opac-results.tmpl work? 10:24 kados try perms now 10:25 owen Worked, thanks. I just copied over the results page from the intranet for now and changed the includes to match the opac. 10:26 kados ahh, cool 10:26 kados is the OPAC search working? 10:27 btoumi somebody now something about this message =>DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' 10:27 kados btoumi: that's a pretty generic message 10:27 kados btoumi: anything before or after it? 10:28 kados owen: i think you've grouped things together slightly wrong in the layout 10:28 owen Okay. 10:28 kados owen: rather than one 'by' 10:28 btoumi :kados nothing just this message and line where u can find error 10:28 kados you need two 10:28 kados ttypeX => 10:28 kados exact ( phrase search) 10:28 kados normal ( unordered search) 10:28 kados atype => 10:28 kados start ( starts with) 10:28 kados wonder ( anywhere ) 10:28 kados owen: does that make sense? 10:29 kados btoumi: check the line and see what it is 10:29 btoumi i do it that why i ask for 10:29 paul btoumi : just "warn" on your query before running it & copy/paste it on phpMyAdmin. that's usually enough to find where it is wrong ! 10:29 btoumi kool i don't think to do like that i test 10:29 Comete bye 10:30 kados owen: looks like you've got 'wonder' grouped with 'exact' and 'normal' 10:30 kados owen: well ... suppose I should actually check the marckup :-) 10:30 owen I see... 10:30 owen The original had them grouped strangely too, so I was just mistaken in how I sorted it out 10:30 kados yea, it threw me for a loop until I read the source 10:30 btoumi :paul i try it 10:31 owen So we've got phrase|normal and starts with|anywhere 10:31 kados the first is asking about "proximity" (ttype) 10:31 kados yep 10:31 kados the second is asking about "order" 10:31 kados well ... they're almost the same thing 10:31 kados but not quite ;-) 10:32 kados ok ... so now ... CQL is working 10:32 kados here's some CQL: 10:32 kados http://www.loc.gov/standards/sru/cql/ 10:32 kados the "" don't work 10:32 kados I'm guessing because it's an input of type text 10:32 kados paul: is there a input type that will preserve quotation marks? 10:36 kados actually, it seems to be preserving them 10:36 kados try a CQL search on 10:36 kados title = "complete book of" 10:38 kados bbiab 10:46 owen All these search options are giving me a headache! 10:46 btoumi paul:i do what u say for the mysql error 10:47 btoumi but no problem with phpmyadmin 10:47 paul I said you could just put a "warn" in your code to dump your SQL in log 10:47 paul then copy/paste it on mysql ! 10:47 btoumi i do it 10:47 paul that means you don't have the same parameters 10:47 paul (or not the one you think you have) 10:48 btoumi i have no problem to insert just with update 10:52 btoumi :paul i do a warn just after $request and i saw all the data of sql request 10:56 owen kados: need your help interpreting opac-catalogue-home.pl 10:57 owen ttype is normal|exact, and atype is wonder|start right? Or is it the other way around? 11:01 kados I think my email broke it down 11:01 kados ttypeX => 11:01 kados exact ( phrase search) 11:01 kados normal ( unordered search) 11:01 kados atype => 11:01 kados start ( starts with) 11:01 kados wonder ( anywhere ) 11:01 kados ttype comes in three flavours (maybe 4) 11:01 kados ttype1, ttype2, ttype3 11:01 kados that's so you can link them to each of the three advanced search fields 11:02 kados make sense? 11:03 owen Right, so why is line 254+ of opac-catalogue-search.pl talking about normal vs. wonder? 11:03 kados sec 11:04 kados is it normal vs wonder? 11:04 kados it looks to me like it's normal and wonder together 11:05 kados } else { 11:05 kados $template->param(normal => 1); 11:05 kados $template->param(wonder => 1); 11:05 kados so that means 11:05 owen Why is it setting both of those there? 11:05 kados it's not a phrase search 11:06 kados and it doesn't 'start with' the $query 11:07 kados make sense? 11:08 owen Getting there... The way it seems to work is that it defaults to full phrase and starts with 11:09 kados yea 11:09 kados that's per spec 11:09 kados ie, it's what NPL staff wanted 11:09 owen Okay, gotcha 11:10 owen Now I'm going to have to re-learn how to search Koha! 11:10 kados hehe 11:10 owen Okay, take a look at what I've got now. 11:10 kados sec 11:11 kados hmmm, better 11:11 kados really, they should be drop-downs 11:11 kados exact/normal 11:11 kados start/wonder 11:11 owen Do they need to be drop-downs if there are only two choices? 11:11 btoumi good bye all 11:11 kados yea, I think they should be 11:12 kados because, we can add more choices if we want ;-) 11:12 owen "Full phrase (or not). Starts with (or doesn't)" 11:12 kados ahh 11:12 kados yea, that might work for now 11:12 owen I do see what you mean about more choices 11:12 kados but the search doesn't seem to be working for some reason 11:15 kados for the tabs 11:16 kados 'simple search' => google-esque 11:16 kados (cql) 11:16 kados Advanced Search => (current Simple Search) 11:16 kados Power Search => (current Advanced Search) 11:16 kados not sure we need the other one 11:17 kados I can add an ISBN search to one of the others 11:17 kados make sense? 11:17 owen Yes. I think that straightens things out very well. 11:17 kados cool 11:17 kados brb 11:17 owen Although the call number search I'm not sure about... 11:17 kados why? 11:18 kados not sure it's working you mean? 11:18 owen That should be a standalone search field, right? So it shouldn't require you to put in a keyword too 11:18 kados right 11:19 kados is the js requiring that? 11:19 kados we can just take that out 11:19 owen So the javascript just needs to be changed 11:19 kados yea, piece of cake 11:19 kados brb 11:21 kados did you make any modifs to opac-catalogue-search.pl? 11:21 owen Just to change the results template 11:21 kados k 11:21 kados I'll merge in the CQL stuff in a sec 11:36 kados don't so yet 11:42 kados i've got to tweak the index to get it working 11:42 kados I think we can get rid of the 'number of results' on the simple search 11:42 owen Yeah, I agree 11:42 kados just make it a hidden input and default to 20 11:43 paul bye everybody. see you tomorrow morning 11:43 kados ok, I'm gonna merge in the CQL stuff into the opac script 11:43 kados bye paul_away 11:43 owen Bye paul