Time  Nick         Message
13:28 hdl          hi there ?
13:28 hdl          Someone around ?
13:32 hdl          owen ?
13:32 dewey        it has been said that owen is hardly ever in direct contact with kados. We communicate here.
13:32 owen         Hi
13:32 hdl          hi
13:32 dewey        what's up, hdl
13:32 hdl          Do you know if kados will be around today ?
13:35 jaron        yesterday kados said he was on getting on a plane to give a demo
13:36 owen         Yeah, he's on the road much of this week
13:38 owen         He said he might be on IRC in the afternoon, but he wasn't sure
13:40 hdl          owen : I just sent some patches for git.
13:41 hdl          Wanted to know if he received them.
13:41 hdl          And when he would apply.
13:42 owen         I think they go through chris first, and then to kados. I don't know if his travel schedule will make that process slower or not
13:43 owen         Does it matter? Doesn't the git workflow mean that you can commit to your repository and continue working?
13:48 hdl          owen : Sure I can continue working.
13:49 hdl          But I was wondering if my first commits would be taken into account before making too many differences.
14:41 owen          I wonder if you can tell git to remember what email to send patches to?
14:43 Asir         hi
14:43 dewey        hey, Asir
14:43 owen         Hi Asir
14:43 owen         don't pay any attention to dewey, he's a bot
14:43 Asir         I've tried to install ubuntu
14:44 Asir         but i cant nstall cvs -z3 -d:pserver:anonymous@marcpm.cvs.sourceforge.net:/cvsroot/marcpm co -P marc-record
14:44 Asir         who can help me
15:17 hdl          Asir
15:18 hdl          Installing from marc::pm is not required any longer.
15:18 hdl          You can install directly from CPAN.
15:18 jaron        hdl++
15:18 hdl          (kados++ ;) )
15:19 jaron        hdl: but you provided the answer Asir needed :)
16:37 martinmorris hello
16:37 dewey        salut, martinmorris
16:37 martinmorris salut dewey :)
16:38 martinmorris we're finally getting quite close to implementing our installation and i'm sorting out barcoding
16:38 martinmorris i've been kindly sent a patch to apply to barcodeGenerator.pl but i'm unsure exactly how to use it in my setup
16:39 martinmorris can you advise?
16:41 thd          martinmorris: who sent the patch to you?
16:41 martinmorris M J Ray
16:41 martinmorris on the koha mailing list
16:41 martinmorris i think i've just managed to apply it actually
16:43 martinmorris yep, patch has been applied but now only have the author and title on a pdf, no actual barcode :)
16:44 thd          martinmorris: barcode generation in Koha has never worked perfectly for me.
16:44 thd          martinmorris: try asking M J Ray in an email.
16:44 martinmorris now i'm getting barcodes but the unicode characters aren't working
16:45 martinmorris i think i'll do that, thanks thd
16:45 thd          martinmorris: most barcode symbology only supports ASCII
16:46 martinmorris well, not the end of the world
16:48 thd          martinmorris: do you mean that Unicode does not work for some additional information on the label which is never encoded in the barcode itself?
16:48 martinmorris that's right, it's just the author/title information with teh barcode
16:49 martinmorris not disastrous, just looks a little ugly that's all
16:50 thd          martinmorris: maybe kados would fix that but I never had it working
16:51 thd          martinmorris: file a bug about that issue in http://bugs.koha.org
16:51 jaron        the font used can handle the unicode characters?
16:51 martinmorris i believe so
16:51 martinmorris can the font be changed?
16:51 jaron        that I don't know--might be hardcoded
16:51 thd          martinmorris: you should verify that
16:52 martinmorris yes, the font can handle the characters
16:53 thd          martinmorris: what is the font?
16:53 martinmorris helvetica bold
16:53 martinmorris (on a mac)
16:53 martinmorris it's an adobe font rather than ttf as far as i can tell
16:56 thd          martinmorris: file a bug about that issue in http://bugs.koha.org and be certain to stipulate that you are referring to the author/title label information which is not encoded in the barcode itself
16:56 martinmorris will do
16:56 martinmorris another little question too
16:57 martinmorris the actual title and author information above the barcode starts very to the left of the barcode and encroaches on to the space of the previous barcode
16:57 martinmorris it's as if the title/author is left aligned and the barcode right-aligned into the next label
16:57 thd          martinmorris: many many months were spent fixing Unicode bugs in Koha but you seem to have found one that was missed
16:58 martinmorris oh dear, sorry about that thd, wouldn't want to be a pain
16:58 jaron        martinmorris: it's very important to a lot of users to find unicode bugs
16:58 martinmorris ok i'll stop feeling guilty then :)
16:59 martinmorris any thoughts on the other issue?
16:59 thd          martinmorris: people may not want to fix the barcode module in Koha 2.2.X but people do want to fix all the Unicode bugs
16:59 jaron        ask MJ if it relates at all to his barcode patch?
16:59 martinmorris yes, i understand koha 3.0 has a shiny entirely new barcode generator
17:00 martinmorris have already emailed him jaron, thanks
17:01 thd          martinmorris: do you have that problem if you supply label information but no barcode?
17:01 martinmorris how do you mean thd?
17:03 thd          martinmorris: well it never worked completely for me but last time I looked you could select which fields to print
17:03 martinmorris ah i see
17:05 thd          martinmorris: maybe you could select parameters which prints neither the barcode nor the human readable barcode number but does print the author/title information
17:06 martinmorris can't see any way of doing that here thd
17:07 thd          martinmorris: printing the barcode may be the minimal requirement with the other elements optional
17:08 jaron        I remember it being a multi-step process to do barcodes and that selecting what information is on them was part of it.
17:08 martinmorris i can change the text under the label to a custom text, that's the only thing i believe i can change
17:11 thd          martinmorris: maybe M J Ray's patch is less flexible than the earlier code
17:11 martinmorris will see what he says
17:11 martinmorris thanks :)
17:12 thd          martinmorris: M J Ray's patch could be based on older code which was less flexible
17:12 martinmorris true
17:12 martinmorris i may just wait until koha 3.0 appears
17:12 jaron        and I thought there was the old barcode generator and the new spine and barcode generator
17:13 martinmorris ah, yes there is
17:14 martinmorris but that doesn't appear to ask me for barcode ranges at all and gives blank pdfs
17:15 thd          martinmorris: which one gives you blank pdfs?
17:16 martinmorris the 'spine and barcode labels' option from the circulation main page
17:16 martinmorris anyway, i need to dash
17:16 martinmorris thanks for your help guys
17:17 thd          martinmorris: you welcome.  The older one was probably never made Unicode compliant
21:14 chris        morning
22:44 linda-r      hello?
22:44 dewey        hello are you online ?
22:45 chris        hi linda
22:45 masonj       heya linda
22:45 linda-r      hi chris, thanks for your response to my post
22:45 linda-r      hey mason j
22:45 linda-r      do you think maybe I configured something wrong?
22:46 chris        maybe, if you look in koha administration, then into koha-marc links
22:47 chris        http://koha.liblime.com/cgi-bin/koha/admin/koha2marclinks.pl
22:47 chris        url will look like that
22:47 chris        what is 090c set too?
22:48 linda-r      let me check ...
22:49 linda-r      it's on an intranet, otherwise i would give you the url
22:50 chris        *nod*
22:52 linda-r      The first field is "biblionumber" tag 090 subfield c "Koha biblionumber"
22:53 chris        that looks right then
22:54 chris        ok if we look at
22:55 chris        http://koha.liblime.com/cgi-bin/koha/admin/marc_subfields_structure.pl?tagfield=090&frameworkcode=
22:55 chris        (with ur hostname instead)
22:55 chris        the 090 c is defined there eh?
22:56 linda-r      navigating...
22:57 linda-r      For subfield c, it says text "Koha biblionumber", constraints "subfield ignored"
22:57 chris        yep thats what I have too
22:58 chris        so that all looks right
22:58 linda-r      huh
22:58 chris        hmm i wonder what its doing
22:58 chris        (subfield ignored means a human doesnt ever need to touch this field)
22:59 chris        its a koha internal use one
23:00 linda-r      is just putting a "1" in the MARC tag 003 field "Control number identifier" okay?
23:01 linda-r      does that not matter?
23:01 chris        yeah, its not valid marc i dont think, but it shouldnt be busting it
23:01 chris        youve tried adding one wihtout using z3950 ?
23:01 linda-r      I'm at home where I can be root, so I can put print statements in anywhere
23:01 linda-r      I don't know where the data structure for field is defined
23:02 chris        ahh its a MARC::Record object
23:02 chris        Koha uses the MARC::Record perl module to deal with MARC
23:02 linda-r      Oh my god, it just worked.
23:02 chris        lol
23:02 linda-r      Let me check the ISBNs that didn't work.  Each try I used a different one.
23:02 chris        its like a mechanic, the car always works when they are watching
23:02 chris        *nod*
23:03 linda-r      Well at least it got to a different screen that says "New item".
23:03 linda-r      Yes.
23:03 linda-r      Hm, maybe I should continue with this or it will get in a weird state.
23:03 linda-r      But I have no idea what all these blank fields are for.
23:03 chris        yeah might be worth adding an item
23:04 chris        the only one you really need is barcode
23:04 linda-r      Oh, something different than at work earlier - field 090 is appearing - which it didn't earlier.
23:04 chris        interesting
23:05 linda-r      Maybe what's not working is when there is no 090 tag - this has 090 b
23:05 chris        could be, but im not sure about that
23:05 chris        you'll be pleased to know there is a new cataloging tool being worked on at the moment, which is much more robust :)
23:05 linda-r      If it doesn't automatically show tag 090, how would I add that?
23:06 linda-r      Oh good, any help would be great.
23:06 chris        if you look back at that url before, ull notice 090b is prbably not set to ignore
23:06 linda-r      I'm doing a paper on this for school and I'd prefer not to say "it's not quite ready for prime time".
23:06 chris        ahh, well it is in use in production in tons of libraries
23:07 chris        but setting up the marc frameworks is the trickiest bit
23:07 linda-r      Oh yes, you're right, it says subfield b, text="Koha Dewey Subclass [OBSOLETE]", Constraints="tab:0, Not repeatablee, Not mandatory, hidden"
23:08 chris        ahh so id try that, and see if that makes any difference
23:08 linda-r      The Ohio library?  Or in NZ?
23:08 chris        in nz
23:08 chris        theres quite a few in Ohio running it now
23:09 linda-r      Have you any suggestions about this 090b field?
23:09 chris        nope
23:09 chris        MARC is a black art to me
23:09 linda-r      Who would know about this?  Because it's a show stopper here.
23:10 chris        id just try setting it to be the same at work as it is where you are now
23:10 chris        if its working where you are now
23:10 chris        you can do that by clicking edit subfields
23:10 linda-r      Well, I think, if I use one of the other ISBNs that I used before, it won't work.
23:10 linda-r      It will do the internal server error again - let me try it.
23:12 chris        if you still get the error, id ask on the koha-devel list, thats what most of hte developers read
23:12 linda-r      Now the Z3950 search gave an internal error.
23:12 chris        ahh thats probably a network thing
23:13 chris        can it reach the z3950 servers?
23:13 linda-r      Maybe I need to finish doing this other add biblio that I started.
23:13 linda-r      ?
23:13 linda-r      It did a little while ago.
23:14 ryan         hi linda-r
23:14 linda-r      It popped up a window with the 3 z3950 servers, and the checkboxes filled in.
23:14 chris        ahh ryan .. ryan knows more :)
23:14 linda-r      Hi Ryan.
23:14 linda-r      Then clicking search or something it did the internal server error.
23:14 ryan         i'd recommend just trying to add a record from scratch before by z3950
23:14 ryan         is it successful then?
23:15 linda-r      Okay, I didn't alter the basic MARC set up.
23:15 linda-r      Do I need to fill in any mandatory fields?
23:15 ryan         i think by default 001,022,040,245,and 300a.
23:16 linda-r      The only one on this screen that's in bold is barcode - I'll just add it.
23:17 linda-r      Okay, now it shows one record in existing items.
23:17 linda-r      How do I go to the empty MARC record screen?  Catalog -> Add Biblio?
23:18 linda-r      Thanks, Ryan, I was finishing up the last one because maybe that was causing the internal server error, but now I'd like to retry something that gave the error that I posted about on the list.
23:18 ryan         linda-r: are you using the default or the npl intranet template?
23:18 linda-r      Default.
23:18 dewey        well, default is really quite bloated or not a selectable option
23:19 linda-r      Should I change it to NPL?
23:19 ryan         dewey: forget default
23:19 dewey        ryan: I forgot default
23:19 linda-r      Are there two places to change it?  I can't remember where they are but it wouldn't take long to go through the parameters ... one second...
23:19 ryan         linda-r: up to you.
23:19 linda-r      Do you think it will fix the bug?
23:20 linda-r      Or it mgiht?
23:20 ryan         if you got errors from z39.50 records, it might just be the server/records you were getting
23:21 ryan         default tmpl should work fine
23:21 linda-r      Okay, I'll leave it.
23:21 ryan         we use npl-based templates around here
23:22 ryan         do you have the system preference 'template encoding' set to utf-8?
23:22 linda-r      yes
23:22 linda-r      It's no problem to change it to npl.
23:25 ryan         ok, but so you have verified that you can successfully add a biblio and an item with the MARC editor by entering data manually, correct ?
23:25 linda-r      It has a completely white background.
23:25 linda-r      The npl, that is.
23:25 linda-r      I will try it next - shall I enter 001, 022, 040, 245, and 300a fields?
23:26 ryan         intranetcolorstylesheet  	colors.css  	Enter the name of the color stylesheet to use in Intranet  	Edit  	
23:26 ryan         intranetstylesheet 	intranet.css 	Enter a complete URL to use an alternate layout stylesheet in Intranet 	Edit 	
23:26 ryan         system prefs for css
23:27 linda-r      Do I have to create an intranetcolorstylesheet file?  Or are there premade options?
23:29 ryan         it should already be present
23:29 linda-r      Hm, I didn't see it, oh well, I'll look later.
23:30 linda-r      Um the 022 field seems like it's ISSN
23:30 ryan         ah, then i'm wrong on that one.
23:31 ryan         just 040c
23:31 ryan         245a and 300a
23:36 linda-r      Okay, I tried it, it had a lot of popup messages about required fields, but finally it went to "internal server error".  Maybe it needs a 090b field?
23:36 linda-r      Do I need to configure the MARC structure for that?
23:36 linda-r      Because the 090 MARC tag isn't showing up on this cataloging screen.
23:36 linda-r      I could check the logs.
23:37 ryan         linda-r: do you need to use 090 as locally defined LC-type call number ?
23:37 ryan         by default, 090 should not be shown anywhere.
23:37 linda-r      I don't know.  What does it mean?
23:38 linda-r      The only one that worked had a filed 090b.
23:38 linda-r      And when I put a print statement into the code, it said something about field 090.
23:38 linda-r      I changed machines, but I could put that print statement into this again.
23:39 ryan         Koha should manage its biblionumbers internally, so it will add data to the MARC field that its biblionumber is mapped to.
23:40 ryan         if you don't intend to use MARC field 090 , then 090c and d should hold koha's biblionumbers.
23:40 ryan         you said that in the marc mapping 090 c and d were set to tab 'ignore', correct?
23:41 linda-r      Yes, I think so, the only one that had anything was 090b.
23:42 linda-r      The message in the log is "about to delete field (on line 1440 of C4/Biblio.pm, tagfield1=090"
23:44 linda-r      Yes 090 a, c, and d all have constraints="subfield ignored".
23:44 linda-r      Maybe I've set up something else wrong?
23:45 linda-r      Maybe Koha 2.2.9 is not compatible with MySQL 4.1 ?
23:46 linda-r      Maybe if I change 090b so it's not hidden, and then try to manually add it, that would fix this problem?  Although its constraints include "not mandatory".
23:46 ryan         it is compatible.
23:47 linda-r      ah
23:47 ryan         no, koha needs to manage the biblionumbers.
23:47 ryan         what is the error where you just tried to add the biblio
23:48 ryan         and, btw, are you using firefox as your browser ?
23:48 linda-r      It's throwing this "server internal error" (yes - firefox) from this NEWnewbiblio subroutine in C4/Biblio.pm
23:49 linda-r      The only time it didn't do it, I noticed that the 090 b was filled in.  Another time it was blank and gave the error.  But maybe it's something else.
23:49 linda-r      Firefox iceweasel
23:51 linda-r      The apache error log las message is "Arguments must be MARC::Field object at ... C4/Biblio.pm line 1440
23:51 linda-r      This line 1440 is in the NEWnewbiblio subroutine.
23:51 chris        and thats when adding a record from scratch right?
23:51 chris        or when adding one fetched via z3950?
23:52 linda-r      This message has happened both ways.
23:53 ryan         linda-r:  perl -e 'use MARC::Record; print MARC::Record->VERSION;'
23:53 linda-r      It seems to be called from line 529 of cgi-bin/acqui.simple/addbiblio.pl
23:54 linda-r      grepping for NEWnewbiblio in cgi-bin and its subdirectories only yields this one place
23:54 linda-r      Also I think it might have mentioned it in a koha log, let me look ...
23:54 linda-r      Okay I'll print the MARC record version, one sec...
23:55 linda-r      2.0.0
23:59 linda-r      The koha-error_log says "Premature end of script headers: addbiblio.pl, referer: http://...:8080/cgi-bin/koha/acqui.simple/addbiblio.pl
23:59 thd          chris: I have a 14 MB frameworks patch which is too large an attachment for my mail system
00:01 thd          chris: I see that is the uncompressed size
00:01 thd          chris: I will try compressing it
00:01 [K]          <rangi@FreeNode> you can eiher compress it, or put it somewhere and send me the url to get it
00:03 linda-r      Well, maybe I should just try making the 090 b field non-hidden, and try entering another record manually, filling in the 090b field.
00:05 linda-r      Thank you very much for your help, Ryan and Chris.
00:05 thd          linda-r: filling the Koha 090 manually is asking for trouble
00:05 ryan         linda-r: i'd recommend getting back to the default framework
00:06 linda-r      okay
00:07 thd          linda-r: filling Koha 090 may prevent Koha from properly tracking the record you create and you may not be able to retrieve it
00:08 linda-r      When I tried to search in the OPAC for the one record I added that didn't throw this error, it didn't find it.
00:08 linda-r      Is that why?
00:08 linda-r      Because it had a 090b field?
00:08 linda-r      How do other people fix this?
00:09 linda-r      Maybe I should read the Perl MARC module documentation and try to import some records that way.
00:09 chris        i havent come across anyone else having this error
00:10 linda-r      Someone else had it in the list serve.
00:10 chris        the previous addbiblio.pl error was the browser prompting to save the file
00:10 linda-r      The Koha Main list.
00:10 chris        which is quite different
00:10 linda-r      Oh.
00:10 linda-r      It's different.
00:10 thd          linda-r: I guess that I was only referring to 090 $c and $b in the standard Koha MARC 21 bibliographic framework
00:11 linda-r      It's a fresh install of Debian 4.0.  I had a problem with LWP::Simple of all things, and had to do force install - I don't know.
00:12 thd          lida-r: To what is 090 $b set in your bibliographic framework?
00:13 thd          linda-r: To what is 090 $b set in your bibliographic framework?
00:13 dewey        i already had it that way, thd.
00:13 thd          almost dewey
00:15 linda-r      090b is Tab:0; Not repeatable, Not mandatory, hidden
00:15 thd          linda-r: are you saying that the records you are importing have an 090 field usually for local call number already?
00:16 linda-r      No, but I noticed the one record that did not give the internal server error when I pressed "add biblio" did have a 090b field.
00:18 thd          linda-r: if the record does have an 090 field before importing to Koha I would suggest remapping the original 090 fields to 999 and removing the original 090 fields.
00:19 linda-r      okay but the only time it worked was when there was a 090b field
00:20 linda-r      When it doesn't work, the last message in the apache error log is "about to delete field: tagfield1=090" which is from the code around C4/Biblio.pm near line 1440
00:21 thd          linda-r: it seems that may be having a problem where the 090 field used to track the record by Koha in 090 $c and $d is not being added.
00:21 linda-r      and then Arguments must be MARC::Field object at ... C4/Biblio.pm line 1440
00:21 linda-r      that's the error message in the Apache error log
00:22 thd          linda-r: unfortunately it has been too long since I used the Koha Z39.50 client for me to know what the problem may be
00:23 linda-r      I just looked at the Nelsonville setup for MARC tag 090:  http://koha.liblime.com/cgi-bin/koha/admin/marc_subfields_structure.pl
00:24 linda-r      it has "subfield ignored" for all of MARC tag 090's subfields a, b, c, and d
00:24 linda-r      Maybe I should change subfield b to be ignored?
00:24 thd          linda-r: For reliable results I have captured records with an external Z39.50 client, then precessed them such as moving 090 to 999, and then imported to Koha using bulkmarcimport.pl .
00:25 thd          s/precessed/pre-processed/
00:25 linda-r      I don't know of a way to create a file of MARC records to import.  Do you know?  We have a database of records in a nonMARC format.
00:26 linda-r      Is the way to import them to write a program using the Perl module MARC?
00:26 thd          lina-r: how many records do you have?
00:26 linda-r      um ... one second
00:26 linda-r      12861
00:27 linda-r      approximately
00:27 thd          lina-r: all non-MARC records?
00:27 thd          linda-r: all non-MARC records?
00:27 linda-r      Are you suggesting that if I turn off the 090 b field, that will work better?  Is that okay to do using the Z3950 input method?
00:27 linda-r      Yes all nonMARC.
00:28 thd          linda-r: are these records from a non-MARC version of Koha?
00:29 linda-r      They are from a homegrown file structure.  We have a little homemade perl script that is accessed from a webpage as a search engine to our catalog.
00:29 linda-r      We're a small library.
00:29 ryan         win 5
00:29 ryan         oops
00:30 thd          linda-r: manually capturing that many records over Z39.50 would take a very very long time.
00:31 linda-r      yes, i think we would only use the manual Z3950 client for new records
00:32 linda-r      I'm not familiar with the Perl MARC module.  Is that the thing to use?  Can it be used to write out a file of MARC records that can be bulkimported?
00:32 linda-r      I'm somewhat familiar with Perl.
00:32 thd          linda-r: I would suggest sending a representative sample of the records to Liblime for an estimate on converting your records to MARC format.
00:33 linda-r      I don't think my boss wants to spend money, because our homegrown system is free, and it suffices for our needs.  If we could get Koha working for no more cost than we spend now, which is nothing, we would use it.
00:33 linda-r      Otherwise, maybe not.
00:34 linda-r      Do some libraries use Koha without paying a support company?  Or do most libraries that have it working use a support company?
00:34 thd          linda-r: well you could use MARC::Record to convert your existing data to MARC 21 and then import it into Koha using bulkmarcimport.pl
00:34 chris        some do some dont
00:35 chris        depends on how much inhouse skills they have
00:35 chris        quite a few use support companies to convert records, because its a time consuming thing to do
00:36 linda-r      We just use some of the standard MARC fields, not that many.
00:36 chris        but there are hundreds of libraries around the world that dont use any 3rd party support
00:36 linda-r      And a few things like who donated it, when it was received, etc.
00:37 linda-r      Well, maybe if I change the 090b field to ignore, that will fix this problem
00:38 linda-r      Do people often look at the koha.liblime.com set up to see how to configure their MARC framework structure?
00:39 linda-r      If I run into problems, is that a place to check?
00:39 chris        sometimes, but its a demo site, so ppl change it .. so its not always right
00:39 thd          linda-r: converting existing non-MARC data to MARC 21 using MARC::Record is not especially difficult.  Complimenting the data you have with additional more complete data from the Library of Congress and other libraries is an additional difficulty at least a couple orders of magnitude more difficult to do accurately.
00:40 linda-r      That, would take awhile because some of our books are not in the Library of Congress and some have more than one entry.
00:40 linda-r      I guess we would just stick to what we have, but DL from LOC for new records.
00:40 linda-r      Do most people not get stuck like this/
00:41 linda-r      .../ -> ?
00:41 thd          linda-r: you can always download the latest version of the Koha frameworks which I just committed
00:41 chris        its the first time ive heard of this 090 problem
00:41 chris        might be worth trying the new framework and see if that fixes it
00:41 linda-r      Maybe it's something else I did wrong. But I didn't change the MARC framework from the default.
00:42 linda-r      Where do I get the new framework?
00:42 thd          lina-r: if you did not change the framework then the framework itself is probably not the problem
00:44 linda-r      That's probably true.  I used it at work, too, and these are both fresh installs, so I'm pretty sure I didin't change that part.
00:45 linda-r      Maybe if I look more closely at the code, I'll see what it's looping through.  The 090b field says obsolete, so maybe it works better if set to ignore.
00:46 thd          linda-r: you can update to the latest rel_2_2 MARC 21 bibliographic frameworks using the latest SQL script at http://cvs.savannah.nongnu.org/viewvc/koha/misc/marc21_standard_bib_framework.sql?root=koha&view=log
00:47 linda-r      Is this what to do: ...?
00:47 linda-r      cvs -d:pserver:anonymous@cvs.sv.gnu.org:/sources/koha co koha/misc/marc21_standard_bib_framework.sql
00:49 thd          linda-r: that may work, I have never used CVS to check out a single file.
00:50 thd          linda-r: you need to specify rel_2_2 for CVS
00:51 thd          linda-r: rel_2_2 is the Koha 2.2.X branch
00:51 thd          linda-r: you can always use the viewcvs download link at http://cvs.savannah.nongnu.org/viewvc/koha/misc/marc21_simple_bib_frameworks.sql?root=koha&view=log
00:52 linda-r      It says that cvs command at the top of the web page.
00:53 linda-r      Sorry, I don't know cvs.  How do you specify rel_2_2?  Is there an option to the cvs command?
00:54 thd          linda-r: yes it does but be certain to not use a version from a branch other than rel_2_2 for the bibliographic frameworks
00:59 linda-r      cvs -d:pserver:anonymous@cvs.sv.gnu.org:/sources/koha co -r rel_2_2 koha/misc/marc21_standard_bib_framework.sql
01:00 linda-r      I tried it with co -r rel_2_2 for the branch.
01:00 thd          linda-r cvs -z3 -d cvs.savannah.nongnu.org:/sources/koha co -r rel_2_2 koha will retrieve the latest version of all Koha 2.2.X files
01:05 linda-r      okay, it downloaded a lot of stuff.
01:05 linda-r      Is it a stable version?
01:06 thd          lind-r: no but I have always personally tested the latest version of the frameworks committed by thd
01:07 thd          linda-r: I actually run the CVS version of Koha locally but it is not in production
01:07 linda-r      are you using this with MySQL 4.1 or 5?
01:08 thd          linda-r: Liblime has run CVS versions of Koha in production for clients
01:09 thd          linda-r: I now use MySQL 5
01:11 linda-r      So would I just install MySQL 5, uninstall Koha, cd to this koha director, perl Makefile.PL, make, make install?
01:11 linda-r      director -> directory
01:11 thd          linda-r: there are instructions for maintaining a CVS update of Koha http://www.kohadocs.org/Updating_Koha.html
01:12 linda-r      I am thinking of using something at work, so it would be a production, stable version.
01:12 thd          linda-r: if the directories have moved a little the instructions may need adjustment
01:12 linda-r      I might be interested in working on this after I finish school but until then I unfortunately have limited time.
01:13 linda-r      Maybe in December or after.
01:14 linda-r      I'm sorry I don't know how to use this marc21_standard_bib_framework.sql file.
01:14 thd          linda-r: there may be some unnoticed unfixed bugs in Koha 2.2.9.  Try an earlier version if 2.2.9 is not working properly.
01:14 linda-r      How do you update to it?
01:15 thd          linda-r: there are instructions in a comment at towards beginning of the file
01:15 linda-r      Yes, I am thinking of downgrading to Koha 2.2.8
01:15 thd          s/at//
01:15 linda-r      Although I heard newer versions had bug fixes.
01:17 thd          linda-r: newer versions do have bug fixes but I am told that 2.2.9 introduced some bugs which had not been caught before release.
01:17 linda-r      It says dump some tables first - does that mean delete them?
01:18 thd          linda-r: the script deletes the existing frameworks tables before recreating them with new data
01:19 thd          linda-r: It will not delete your bibliographic records
01:19 thd          linda-r: Despite the caution it is quite safe unless you have custom modifications to your bibliographic frameworks
01:20 linda-r      I think I see in the notes it means back up some tables first, then run it as a batch file.
01:20 linda-r      No I'm just starting, everything can go.
01:21 thd          linda-r: oh yes dump means copy, drop means delete
01:21 linda-r      Sorry to ask a dumb question that is probably in the documentation:
01:22 thd          linda-r: maybe the problems you are having are related to the 2.2.9 Z39.50 client
01:22 linda-r      If I use mysqldump to create an .sql file, then I drop the dumped database, will the .sql batch script recreate the database?
01:23 thd          linda-r: the SQL file will dropt the bibliographic frameworks tables and recreate them with new data
01:23 linda-r      Maybe the problems are related to the Z39.50 client, although I had about the same errors when I tried to add a record manually.
01:24 linda-r      I will probably try to stick with a stable release, with the idea of using it at work.
01:25 thd          linda-r: the script itself will not dump your data but if you have no data over which to have concern then you should not worry.
01:25 thd          linda-r: there is no harm in using this script with a stable release.
01:26 thd          linda-r: it is more stable than the release
01:26 linda-r      Thank you very much for all your help, THD.
01:27 linda-r      I will try this script, and then, if that doesn't work, I will try Koha 2.2.8.
01:27 linda-r      Thank you.
01:28 thd          linda-r: you are welcome, if you are having problems which a new install which others have not reported I would try deleting Koha and installing again
01:28 linda-r      okay.
01:28 linda-r      May I please ask you your email address?
01:29 thd          linda-r: koha AT agogme.com
01:29 linda-r      Okay, thank you, if you get an email from lindamarcella at yahoo, it's me
01:30 thd          linda-r: when I am preoccupied I sometimes do not check my email for a few days
01:31 linda-r      i understand, thank you again, have a good night!
01:31 thd          good night linda-r
04:02 thd          chris: are you about?
07:18 hdl          chris ?
07:18 dewey        chris is now too
07:20 hdl          chris around ?
08:13 chris        hi hdl
08:13 hdl          hi chris ?
08:13 hdl          How are you ?
08:14 chris        not too bad thanks, mostly got rid of the jet lag now
08:15 hdl          Good.
08:15 hdl          How is Crayon ?
08:15 chris        good, he is just about to go to bed
08:15 chris        Kahurangi
08:15 dewey        Kahurangi is the Maori word meaning, "treasured possession"; " precious jewel", "pale greenstone" and " blue sky".
08:16 hdl          Big kiss to Kahurangi
08:16 hdl          I have seen you wanted to help me.
08:16 hdl          And I appreciate.
08:16 chris        ah yes, with Auth.pm
08:16 chris        i must have broken something
08:17 hdl          Yes indeed.
08:17 chris        checkauth is the only thing I changed
08:17 hdl          CGI::Session now stores little information
08:17 chris        yes, it stores stuff in the a_session bit
08:18 chris        so you can store whatever you want
08:18 chris        eg
08:18 hdl          And since ip, email and so on are accessed to put them into userenv...
08:18 hdl          It explodes the connection
08:19 chris        yep
08:19 chris        you can store them still
08:19 chris        and fetch them
08:19 chris        by doing
08:20 hdl          Since you did so because of security concern... Is it OK to do it ?
08:20 chris        my $ip=$session->param('ip');
08:20 chris        or to set
08:20 chris        $session->param('ip',$ip);
08:20 chris        yep, that stores it in the db, in the a_session colum
08:20 chris        rather than storing things in the cookie
08:21 hdl          Most of the time, my $session is null.... I wonder if i donot have a problem of connexion to database.
08:21 chris        hmmm could be, or the sessionid might not be getting set
08:21 chris         elsif ( $sessionID = $query->cookie("CGISESSID")) {
08:22 chris        my $session = new CGI::Session("driver:MySQL", $sessionID, {Handle=>$dbh});
08:23 hdl          I have this :
08:23 hdl          unless ($userid) {
08:23 hdl                  $sessionID = int( rand() * 100000 ) . '-' . time();
08:23 chris        hmmm
08:23 chris        what line is that?
08:24 chris        http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=C4/Auth.pm;h=68ed79d9d955d4e6e7a7f543978710a71638097c;hb=HEAD
08:24 chris        is the latest version
08:26 hdl          OK... version mixing... Since I had to test some things... I reverted to old Auth.pm
08:26 chris        ahh
08:26 hdl          btw... Have you received my patches I sent a week before ?
08:27 hdl          I tried and resend them yesterday.
08:27 chris        hmm i think so, did you send them to patches@koha.org?
08:27 hdl          yep
08:27 chris        ahh yes i applied some patches from you yesterday
08:27 chris        and pushed them to the RM repo, so just need joshua to push them live now
08:27 hdl          is it driver::MySQL or driver::mysql ?
08:27 chris        they applied fine
08:28 hdl          in new CGI::Session()
08:28 chris        ahh MySQL
08:28 hdl          I found it strange that sessions table donot have any autoincrement .
08:29 hdl          Is it OK ?
08:29 chris        yeah it makes a new md5 string
08:29 chris        for the id
08:29 chris        CGI::Session handles all that
08:29 hdl          And is it passed via a Cookie ?
08:29 chris        yep
08:30 chris        Author: Henri-Damien LAURENT <henridamien@koha-fr.org>
08:30 chris        Date:   Mon Aug 20 15:45:59 2007 +0200
08:30 chris            Modifying AddAuthorities in order to fix encoding bugs.
08:30 chris
08:30 chris            Signed-off-by: Chris Cormack <crc@liblime.com>
08:31 hdl          OK.
08:31 chris        so they should all go live as soon as joshua is back in front of his computer
08:31 hdl          So I think I will have to synch my Auth.pm back from git repository and test more harder.
08:32 hdl          (I may have made changes...)
08:32 chris        it should look something like this
08:32 chris        in the db
08:32 chris        | 07fb9cba7134e2561e5e2018e9fa2625 | $D = {'firstname' => 'Bws','_SESSION_ID' => '07fb9cba7134e2561e5e2018e9fa2625','flags' => '1','branchname' => 'Main Li
08:32 chris        brary','number' => '102949','ip' => '','branch' => 'MAIN','_SESSION_REMOTE_ADDR' => '','surname' => 'JOHNSON','_SESSION_CTIME' => 1
08:32 chris        187620944,'_SESSION_ATIME' => 1187620944,'cardnumber' => '007','id' => '007','lasttime' => 1187620945,'emailaddress' => ''};;$D
08:32 chris                                                   |
08:33 hdl          OK Thanks
08:33 hdl          Is order in table important ?
08:34 hdl          a_session and data ?
08:34 chris        no its quite cool CGI::Session just creates a hash and stores it in a_session
08:34 chris        so its totally extensible, you can add as much as you like
08:34 hdl          Or is it OK to have those fields at the end of old sessions table
08:35 hdl          is it longtext ?
08:35 hdl          for data ?
08:35 chris        oh yeah thats fine, they wont get used anymore
08:35 chris        heres what i have
08:35 chris        +-----------+----------+------+-----+---------+-------+
08:35 chris        | Field     | Type     | Null | Key | Default | Extra |
08:35 chris        +-----------+----------+------+-----+---------+-------+
08:35 chris        | id        | char(32) | NO   | PRI |         |       |
08:35 chris        | a_session | text     | NO   |     |         |       |
08:35 chris        +-----------+----------+------+-----+---------+-------+
08:36 hdl          so a_session is limited to text size.
08:36 chris        i got rid of the other columns, but you could keep them, they just wouldnt get used anymore
08:36 chris        yep, you could make it long text if you want
08:36 hdl          Which is quite big... But. limited.
08:36 chris        ie, its not a CGI::Session thing its how you define your db
08:37 hdl          I could be a good Idea for some libraries which have LOOOOOONNNNG branchnames ;)
08:37 chris        :)
08:37 hdl          OK Many thx.
08:37 chris        the other nice thing
08:37 hdl          hello to your family.
08:37 chris        is you can use a file .. so for the installer
08:37 chris        when we dont have the db yet
08:38 chris        we can still use CGI::Session
08:38 chris        but we use a temporary file instead
08:38 hdl          Cool.
08:38 hdl          CGI session finds alone the file to use ?
08:38 hdl          and detects there is no db ?
08:39 chris        my $session =
08:39 chris         246           new CGI::Session( "driver:File", $sessionID,
08:39 chris         247             { Directory => '/tmp' } );
08:40 chris        is what we now have in InstallAuth.pm
08:40 hdl          driver::Mysql for CGI::Session is loaded ?
08:40 hdl          Is there a way to find whether it is installed or not ?
08:40 chris        it comes with CGI::Session
08:41 chris        i think there is File Mysql and something else
08:41 hdl          I hope I have it.
08:43 chris        driver - CGI::Session driver. Available drivers are "File", "DB_File" and "MySQL". Default is "File".
08:49 hdl          hi walter
08:49 hdl          chris : why is there logbot newlogbot and dewey ?
08:50 chris        logbot is the old one, i should get walter at katipo to turn it off
08:51 chris        newlogbot is the new logging one .. and dewey is the old infobot, which we might just turn off, i dont think we need a new one of them
08:52 hdl          to synchronize with repository, it is "git pull" ?
08:52 chris        i usually do a
08:53 chris        git fetch
08:53 chris        git rebase origin
08:53 hdl          why so ?
08:53 chris        what it does is, bring the repo up to the same as the origin
08:53 chris        and then applies your local changes
08:53 chris        a git pull
08:53 dewey        i guess a git pull is really just a wrapper around git fetch and git merge
08:54 chris        grabs the origin and merges the changes with your repo
08:54 chris        so slightly different .. but achieves the same thing :)
08:55 chris        but i find that conflicts if they happen are easier to handle with the rebase