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?