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