Time Nick Message
00:04 wajasu ok. i found out why by librarian was upset about the detail record.
00:04 chris what was the issue?
00:04 wajasu it seems that the title was shown from 700, 710, 730, and he wanted 245abc
00:04 wajasu thre is a tone of info in the 245 that the acaemics want
00:05 chris yeah thats totally non standard
00:05 chris 700 etc
00:05 chris koha out of the box uses 245 for title
00:05 chris (at least for MARC21)
00:06 wajasu what he is doing is going to other proprietary libraries, pulling up the equivalent record, and comparing. so he is upset that a lot of info is missing.
00:06 wajasu now he wants me to find the XSLT or templates and start changing things to make all that other stuff show.
00:07 wajasu once he goes down that road it might be hard to upgrade koha. right?
00:10 wajasu i also found out that the 245b didn't show until he: 1) went to keywords to MARC mappings and added fields subtitle, 245b and 2) switch to XSLTDetailDisplay from normal.
00:13 chris yeah but the xslt should be showing 245abc
00:13 chris it does for me
00:13 chris with no edits
00:13 wajasu maybe he didn't need the subtitle thing, but once he added the XSLT. I'll remove and check.
00:16 chris what im wondering about is where it got these 700 things from
00:16 wajasu yeah, ur right. the XSLT was all that was needed.
00:16 chris cool
00:17 nelsonlib Hey guys, I am having some troubles with the SAX parser in my koha install
00:18 larsw nelsonlib, what kind of trouble?
00:18 nelsonlib I have gotten rid of any reference to the PurePerl module in both the site_perl and vendor_perl ParserDetails.ini file - but the setting checker still says it looks bad
00:19 larsw nelsonlib, are you running Debian or some other operating system? do you have more copies of ParserDetails.ini? e.g., somewhere under /etc?
00:19 larsw find /etc -name ParserDetails.ini
00:19 nelsonlib I am running CentOS 5.3
00:19 larsw that would find all copies
00:20 wajasu i saw "by Cobb, John B." on the normal results display. then looking closer, I saw that the info he wanted was in the 700 710 730 fields.
00:20 nelsonlib I am finding copies only in vendor_perl and site_perl - both of which are correct and look like:
00:20 nelsonlib [XML::LibXML::SAX::Parser] http://xml.org/sax/features/namespaces = 1 [XML::LibXML::SAX] http://xml.org/sax/features/namespaces = 1
00:21 nelsonlib Except the vendor_perl one has got the PurePerl lines commented out at the bottom
00:21 larsw actually, I don't know how CentOS handles that, I use Debian and it might do things differently
00:21 larsw brb
00:21 chris wajasu: oh, so he doenst want 245abc showing he wants the 700's showing? sorry i misunderstood i thought you said he wanted 245abc
00:23 nelsonlib larsw - this is not a common issue
00:23 bgkriegel nelsonb, I only left the first one, and comment the second
00:23 nelsonlib This feature (specifically, searching for titles to add to a label batch) has worked for weeks and now, all of a sudden it does not work
00:24 nelsonlib @bgkriegel - could you pastebin me your ParserDetails.ini?
00:24 munin nelsonlib: Error: "bgkriegel" is not a valid command.
00:24 bgkriegel I try
00:24 nelsonlib Thank you
00:24 nelsonlib In fact, the only thing that has changed is an update of the packages on the server today
00:25 bgkriegel nelsonlib, http://pastebin.com/2Q1wMKFT
00:26 nelsonlib Ok, thank you bgkriegel, the sax_printer script passes now
00:26 bgkriegel cool
00:26 nelsonlib Unfortunately, I am now running into an error regarding the XML module but I think I can fix that
00:27 bgkriegel oops, what error
00:27 nelsonlib This version of XML::LibXSLT requires XML::LibXML 1.59 (ABI 1), which is incompatible with currently installed XML::LibXML 1.70 (ABI 2). Please upgrade XML::LibXSLT, XML::LibXML, or both! at /usr/lib/perl5/5.8.8/CGI/Carp.pm line 314.
00:29 bgkriegel perhaps you could try to updates those modules from CPAN
00:30 nelsonlib I tried, XML::LibXML is up to date
00:30 nelsonlib And XML::LibXSLT will not compile because yum gave me an out-of-date lbixslt
00:30 nelsonlib libxslt*
00:32 bgkriegel don't know if you could install a new version of libxslt, from centos 5.5 o 5.4
00:32 nelsonlib I am trying it now
00:36 nelsonlib Nope didn't work
00:36 nelsonlib Unless I can supply configure arguments to cpan
00:39 nelsonlib Ok, then I guess another question is posed.... does anyone know of a good way to generate the labels for all of the records in the Koha database?
00:39 bgkriegel you download the module and try passing arguments to perl Makefile.pl http://pastebin.com/QLwP7Skw
00:39 bgkriegel thats from the README
00:40 bgkriegel for the labels, I use a script to generate a LaTeX file, then a PDF
00:41 nelsonlib Would be interested in sharing the script?
00:42 bgkriegel no problem, write to me (bgkriegel@gmail.com), I need to found it, I wrote it a year and a half ago
00:44 nelsonlib Actually, is not necessary - I fixed it
00:44 nelsonlib Thanks to you, bgkriegel! :)
00:44 nelsonlib However - I do have one last question
00:45 nelsonlib When I do a wildcard '%' search on 'Title' for the Label creator - I get enough rows for all of my items, but the data for only the first 22 are listed
00:46 nelsonlib Unless I am searching for the records incorrectly, whch could very well be the case
00:50 bgkriegel sorry, I was trying, I obtain a pdf with many pages
00:51 bgkriegel I do a select all from the results
00:53 nelsonlib What do you type in in order to get all of the results?
00:53 bgkriegel not all the results, in fact
00:53 bgkriegel only try with a particular subject
00:56 nelsonlib I actually returned to the search pop-up when I search for anything but '%'
00:57 bgkriegel that wilcard search give no results to me
00:57 nelsonlib Hmm
00:58 nelsonlib If I leave the two date fields blank, and enter "symbol" (as in the lost symbol by dan brown, which is in the catalogue) in the title field, then I am returned back to that very same page
01:10 bgkriegel I have a question: which is the script that updates the info in koha-zebra-ctl.sh in the install process? because it updates every variable except USER and GROUP. If you choose a user different from "koha" then you need to edit that file by hand
01:12 chris rewrite-config.PL
01:12 bgkriegel good. I look on it and try a fix. Thank you
01:13 chris it wont be it
01:13 chris it will be the thing calling it
01:14 chris is not passing it KOHA_USER and KOHA_GROUP
01:15 chris so probably the makefile generated by Makefile.PL
01:28 bgkriegel there is no KOHA_USER and KOHA_GROUP on Makefile, on Makefile.PL it seems to read those like the other variables
01:30 chris yeah but when you call rewrite-config.PL you have to pass it variables either in the ENV or on the command line
01:30 chris if you dont pass those to
01:30 chris two
01:30 chris it uses koha:koha
01:32 bgkriegel I understand, but Makefile.PL ask other things like DB_NAME, if I choose a value different than the default, it catch it, but not the username
01:33 bgkriegel they must be defined as snv variables?
01:33 bgkriegel sorry, env variables?
01:33 chris yep
01:33 chris or make makefile.pl ask for them
01:33 chris and remember them, and pass them to rewrite-config.pl
01:35 bgkriegel but Makefile.PL asks you about them, then choose to forget... only those values.
01:35 chris then it needs to be fixed so it doesnt forget them
01:35 bgkriegel ok :), I look on it. It's too late here
01:35 chris :)
01:36 chris its probably just not passing them (rather than forgetting)
01:36 chris good luck, its hard work reading Makefile.PL
01:36 bgkriegel yes
02:28 brendan evening
02:43 chris hi brendan, genji and Joann
02:44 genji hiya..
02:44 genji how does templates, html files and po translations, work in koha?
02:44 genji and how do i ensure that custom templates are git-upgradable?
02:46 chris po files are used to generate new templates, based on the english ones
02:46 chris and templates should only be customised via css or jquery to keep an upgrade path
02:46 chris but if you must modify them, you will have to maintain a local git branch and track changes
02:48 genji in other words, manually bring the changes that are necessary, into the custom templates eh?
02:49 chris yep
02:52 genji "templates should only be customized by ccs or jquery" so.. no new / different text.... and what about images?
02:52 chris there are few images that are sysprefs, you can change them with no change to the templates, in fact there are no images that are harcoded into the templates
02:52 chris they are all controlled by either the css, or sysprefs
02:59 genji git can upgrade files which are lightly modified, correct?
02:59 chris git will upgrade anything
03:00 reed you can often merge safely / correctly w/git
03:00 reed but sometimes it will shoot you in the hed
03:00 chris as long as you have your changes committed, but the more changes you make the more likely you are to have conflicts
03:00 reed so, always good to review
03:00 chris *nod*
03:54 wajasu chris: this http://library.redeemerseminary.org/cgi-bin/koha/opac-detail.pl?biblionumber=4 pulls from the 700,710 fields. No 245 fields are in the normal view. The MARC and ISBD views show 245 fields though.
03:55 chris is that with xslt on?
03:55 wajasu quick check. hold on.
03:56 wajasu yes
03:56 chris http://search.myacpl.org/cgi-bin/koha/opac-detail.pl?biblionumber=174786
03:56 chris cos that is 245
03:57 genji how do i git blame for lines without blame/
03:57 genji ?
03:57 chris what?
03:58 genji git blame identifies lines, and the commit that created them.
03:58 genji how do i do the opposite? find lines that have no blame/
03:58 genji ?
03:59 chris lines that no commit created??
03:59 chris umm that doesnt happen
03:59 robin chris: it does
03:59 robin if you have uncommitted changes
03:59 chris well yeah but thats just a git diff
03:59 genji when people don't commit, causing a hassle.
04:00 larsw does git blame report uncommitted changes?
04:00 robin larsw: yeah
04:00 genji what does a uncommited change look like?
04:00 robin e.g. 00000000 (Not Committed Yet 2010-05-18 16:02:48 +1200 25) if (!@ARGV) {
04:00 genji hmm..
04:01 wajasu chris ur url is taking forever "transferring data". maybe its me?
04:02 chris wajasu: must be, thats one in the US
04:02 chris heres one here
04:02 chris http://opac.koha.workbuffer.org/cgi-bin/koha/opac-detail.pl?biblionumber=325
04:02 chris with xslt turned on
04:02 chris stock standard koha ... (master branch) no changes ... and its showing 245 ... i knw .. because this record has no 700's
04:03 wajasu i see.
04:04 wajasu i looked at MARC21slim2OPACDetail.xsl and it looks like it pulls from 700s (alpha1 tar from a month ago)
04:05 wajasu the url i gave for great books... you can see in the ISBD view the 245 fields. But not in Normal.
04:05 chris thats author
04:05 chris 700, 710 etc are author fields
04:05 chris <h5 class="author">
04:05 chris <xsl:call-template name="m880Select">
04:05 chris <xsl:with-param name="basetags">100,110,111,700,710,711</xsl:with-param>
04:06 chris <h1 class="title">
04:06 chris <xsl:call-template name="m880Select">
04:06 chris <xsl:with-param name="basetags">245</xsl:with-param>
04:06 chris <xsl:with-param name="codes">abhfgknps</xsl:with-param>
04:06 chris thats what is in git currently
04:06 chris if thta doesnt match, you might want to try upgrading to alpha2
04:06 wajasu ok. so you think it should match. right?
04:08 chris lemme check the code that was in alpha
04:08 chris but yes 700 should never ever be in title
04:08 chris thats an author field
04:09 wajasu my librarian wants 245c, which has "_cRobert Maynard Hutchins, editor in chief." showing in normal.
04:10 chris right, instead of using the 100a field, where most ppl put author?
04:13 wajasu i see. since no 100a, then we go to 700s
04:13 chris *nod*
04:13 wajasu but no 245c
04:13 chris nope, you could add that, 100a, then 245c
04:14 chris but its not a mod we could do to koha, because cataloguers would go mental
04:14 chris so it would have to be a local mod to the xslt file
04:14 Amit heya chris, brendan
04:14 wajasu ok.
04:14 brendan heya amit
04:15 chris in terms of searching too, if you do an author search, it won't be searching 245c
04:15 wajasu my librarian want 245c showing because he says there is lots of other info in that field, and he cites other theological libraries.
04:15 chris (general search will, it searches pretty much everything)
04:15 wajasu i'll try a quick mod. i hope.
04:15 chris *nod* you can make it show, but for it to show before the 700's
04:15 chris it would have ot be a local mod
04:17 wajasu 245c is "Statement of Responsibility"
04:17 wajasu i'm sure you guys get in catch-22 situations.
04:17 wajasu can't please all the cataloguers all the time.
04:18 chris the best you can do is follow the standards, and then you can at least say you did that
04:18 chris and let others make local mods :)
04:18 chris the idea with the keyword thing
04:18 chris like setting subtitle = 245b
04:18 chris is that you would be able to do author=245c
04:19 chris that might be worth trying
04:19 chris swithc off xslt, set up that mapping like you have done for subtitle
04:19 chris i have no idea if it will work, but its worth a shot
04:21 brendan ok I've got a mysql question
04:21 brendan a few different records in my database that mulitple copies - only one item has a itemcallnumber
04:22 brendan I'm looking for a mysql statement that would go through and copy the first non-null itemcallnumber per biblionumber
04:24 brendan and place that non-null itemcallnumber into the rest of the callnumers
04:27 chris you might have to do script that
04:30 brendan yeah that's what I thought - was checking first
04:30 brendan thanks chris
04:30 chris i was trying to think how to do it with subselects
04:31 chris and my brain started to hurt
04:31 wajasu i tried the xslt mod. got the 245 3 times. a bit more time needed. will try the subtitle way w/o xslt
04:35 genji omg.. blame is amazing. just what i needed.
04:36 Amit heya genji
04:46 cait morning koha
04:46 chris hi cait
04:54 wajasu chris: the normal mode author idea had no effect.
04:55 chris ah well, was worth a shot
04:56 wajasu my librarian want things to look like: http://library.dts.edu/uhtbin/cgisirsi/pnnuVbskVj/SIRSI/154000005/9 (choose the catalog record tab)
04:57 chris ohh thats isbd
04:57 chris you can totally do that in the sysprefs
04:57 chris http://library.redeemerseminary.org/cgi-bin/koha/opac-ISBDdetail.pl?biblionumber=4
04:57 chris it already does :)
04:58 chris but that whole ISBD view is editable in the system preferences
04:58 wajasu hmm.
04:58 chris in staff go to
04:58 chris /cgi-bin/koha/admin/preferences.pl?tab=cataloguing
04:58 chris then edit the ISBD
04:59 chris then in the opac prefs
04:59 chris set the default view to isbd
04:59 * chris has to catch his bus
04:59 wajasu so add the 245c in the ISBD
05:02 wajasu chris: that works. I'll leave it there ISBD by default.
05:02 wajasu thx
05:31 robin http://paste.ubuntu.com/435331/ <-- so far, this is what my CSV-to-MARC conversion script is capable of. It's becoming quite a monster.
05:31 wajasu pretty
05:34 wajasu when i did my db migration, i exported to CSV. then wrote a java program to import it into a java based database(h2), then i could do sql queries through the web based sql console.
05:35 wajasu then i added a java db function that called the yaz marc record to string, i could select records based on that text version of a marc record.
05:35 robin that's nifty.
05:35 wajasu then i wrote a routine that went out and harvested marc records from z3950 servers. and store in db.
05:36 robin cool. The CSV file I'm working with has very inconsistent data, which make it interesting.
05:37 wajasu then i wrote an exportto marc using marc4j and added 1 945 item for each book. then staged those 16000 records and imported into koha.
05:37 robin It was quite close to someone using a spreadsheet as a database as a catalogue.
05:37 robin yeah, that's what this can do.
05:37 robin And what I'm about to test.
05:38 wajasu the records i didn't find in z3950 servers, i built my own records. i also generated barcode numbers with the format in koha.
05:38 wajasu i realized i had written marcedit and koha. with no gui. Eclipse ide...
05:39 robin haha :)
05:39 wajasu i was going to write a javaFX gui to be a marc editor. or and ajax marc editor.
05:39 robin This is hopefully going to be a scriptable alternative to marcedit, at least for the purposes of going from CSV to mark.
05:40 robin it'd be nice to have an open source one.
05:40 wajasu i should give you my java source so you can read all the stuff i went through for your script.
05:40 robin If not for the lack of time I had, I wouldn't have minded making this a GUI app.
05:41 robin not a bad idea, although I'm pretty much done with it (I hope :)
05:44 wajasu i really like the fact i could do sql queries like "select callnumber, author, title from x where MARCSTRING(marcbinaryblob) like '%Joe%' for record that made koha choke. and update a colum to marc as skippable to be fixed later.
05:44 wajasu i learned way too much about marc. and cried one evening for the library community.
05:45 robin haha I know exactly where you're coming from :)
05:45 wajasu everything that industry is doing is being done by computer science guys with no library background. createing metadata repos for callable services.
05:46 robin Well, also things from the era of fixed-length records, too.
05:46 mib_cxlj4t how can I install koha-3.06. I have installed koha3.05 but koha3.06 is not available like 3.05. it is in signature
05:47 wajasu i feel i should put a distributed database (graph like api) with couchodb or the like, on a cloud, or in tahoe distributed file system, so no one owns the biblios.
05:47 robin that would be pretty cool
05:47 wajasu but then the problem of who should be the ones to add /edit biblios?
05:47 robin make it a wiki! they solve everything ;)
05:47 wajasu and what should the semantic vocabulary be.
05:47 wajasu exactly.
05:48 wajasu flasg based bib editor, hiding the implementatio.
05:48 wajasu instead of napster, its bibster.
05:49 robin There is already something out there along those lines, aimed at p2p sharing of bibliographies for academic writing. Can't think of the name.
05:50 wajasu i think the information in books today will b over run by the digital content produced by the upcoming genration(s). that is if we edumacated them enough.
05:52 wajasu i which i had your script. so make it happen.
05:53 robin Yeah, I think that is already happening, books provide the topical centralisation though.
05:57 wajasu once i started reading about the authority record stuff and lcsh, i knew there is a power struggle over managing concepts, words, etc.
05:59 wajasu just like unicode has 65000 codes/numbers that represent concepts of letters. i think if we do the same for words pertaining to the vocabulary of business, then different languages could bind to the numbers and interoperate semantically.
06:01 robin More semantics is always a good thing, I don't want to be the one to design it though ;)
06:01 wajasu we don't need that many words (i.e item=1, product=2, order3, and on) and we need a torrent for the vocabulary. then watch the fireworks.
06:01 wajasu its hard work. i'm not up to it.
06:03 wajasu but even if we created 10000 words, we could get alot of business running through it world wide.
06:03 wajasu enough for today. gnite.
06:04 robin cya :)
06:43 Ropuch^_ Morning #koha
06:47 kmkale good morning all
06:51 mib_cxlj4t how can I install koha-3.06. I have installed koha3.05 but koha3.06 is not available like 3.05. it is in signature
06:53 Amit heya kmkale
06:53 kmkale hi amit
06:53 Amit kmkale: Any new news
06:57 kmkale nope
06:59 Ropuch^_ mib_cxlj4t: http://download.koha-community.org/
07:00 Ropuch^_ There's two gz's
07:00 Ropuch^_ 3.00.06 with all translations and english only
07:12 chris evening
07:15 robin chris: so, it seems koha won't import marc XML
07:16 chris you need to use the commandline script
07:16 miguel good morning
07:16 robin ahh right. I just made my app output us_marc files.
07:18 chris xml2marc
07:18 chris or you can do that
07:18 chris having a switch might be nice
07:18 robin $record->as_usmarc :)
07:18 robin yeah, I'll add that some stage soon.
07:19 chris --format=xml --format=iso2709 (which is usmarc)
07:19 robin yeah
07:20 chris the nice thing is
07:20 chris you can do stuff like
07:20 chris marc2dc
07:20 robin dc?
07:20 chris to create a dublin core file
07:21 robin ah right
07:21 robin I think this import process may take a little while. Time to go home I think :) cya later
07:21 chris :) cya later
07:24 richard hey chris
07:25 pastebot "kmkale" at 192.168.15.101 pasted "hdl: icu.xml Unknown element transliterate" (6 lines) at http://paste.workbuffer.org/8
07:26 kmkale hdl: can you please tell me whats going on with this transliterate element from the icu.xml?
07:28 chris heya richard
07:30 Ropuch^_ Hi chris
07:30 chris hiyea Ropuch^_ hows things going?
07:32 pastebot "kmkale" at 192.168.15.101 pasted "icu.xml" (21 lines) at http://paste.workbuffer.org/9
07:33 kmkale hdl: whenever you have some free moments please have a look at the above paste
07:33 Ropuch^_ chris: fast forward ;-)
07:35 hdl kmkale: It is a special process for ISBN normalization.
07:35 hdl kmkale: it suppress the - in the numbers.
07:36 kmkale hdl: oh ok. and transliterate?
07:36 hdl And the NFD NFC Nonspacing marks is to remove any diacritics.
07:38 kmkale hdl: guess i will need to keep diacritics for devanagari?
07:38 kmkale hdl:thanks
07:49 kmkale hdl: is it necessary for authorities to be also using icu to be able to search for devanagari data? if yes how do i get zebra to use icu for authorities too? or are the changes to default.idx for icu.xml applicable to both biblios and authorities databases?
08:06 hdl kmkale: to both
08:06 kmkale ok I have just deleted a record and zebra reindexing has not ran yet as its on a 5 min cron; so when I search for it i get "Can't call method "field" on an undefined value at /home/kalibindia/kohaclone/C4/Koha.pm line 1233" should't there be a more graceful way of handling it?
08:06 kmkale hdl: thanks.
08:12 kmkale umm.. one more thing. I cant get the above error to go away unless I do a -r in the rebuild_zebra
08:17 chris yep there is a patch out there for that
08:18 chris the cant call method field one
09:10 kf hi #koha
09:12 magnus hi kf
09:12 chris hi kf
09:14 kf hi chris and magnus
09:15 kf chris: munin was right - will not finish my xslt project this week :(
09:16 chris :(
09:16 kf too many other things coming out of the nowhere that need to be done first
09:16 kf so at least we know now: munin does know
09:17 kf @eightball sunny weekend?
09:17 munin kf: You know the answer better than I.
09:24 chris @eightball should i have another piece of chocolate?
09:24 munin chris: Maybe...
09:24 chris good enough for me
09:46 kf @eightball should i have another piece of chocolate?
09:46 munin kf: No clue.
09:53 chris just tweeted to me - http://community.eldis.org/Ayuko/.59c6e759/.59d1f791
10:53 gmcharlt good morning
10:53 hdl hi gm
10:56 chris hi gmcharlt
10:57 chris gmcharlt: W refs/heads/newfeatures/ptfs_patron_features koha chrisc DENIED by fallthru
10:57 chris error: hook declined to update refs/heads/newfeatures/ptfs_patron_features
10:58 chris not urgent just was another branch i was gonna push up ... and then get colin to look at
10:59 gmcharlt chris: try pushing to new/ptfs_patron_features
11:00 chris will do
11:02 chris that worked
11:03 gmcharlt cool
11:03 gmcharlt we both have permissions to push to new/*
11:03 gmcharlt and you can clone gitmaster@git.koha-community.org:gitolite-admin and push changes to the config when you need to
11:05 chris sweet
11:25 jdavidb hello, #koha!
11:25 kmkale hi anyone from europe around?
11:25 chris hi jdavidb
11:26 kmkale hi chris , jdavidb
11:50 hdl hi kmkale
11:51 chris hi jwagner and nengard
11:51 jwagner Good [time of day] all
11:51 chris jwagner: i saw the first pitch
11:51 nengard hiya both
11:51 chris and the marlins doing cricket skills drills, and vice versa
11:51 jwagner of the Marlins game? I was too busy watching my other teams get beat "-(
11:51 kmkale hi hdl
11:51 kmkale hdl you are in europe I suppose?
11:51 chris i wonder if they will televise the nz vs sri lanka game
11:52 hdl yes kmkale
11:52 kmkale hdl: my parents are flying to amsterdam tonight. any news about the ash cloud stuff?
11:53 jwagner chris, as long as you're online -- I was asking owen yesterday. The templating changes you're planning for 3.4, will that make any difference to pages that need to get more markeup tags? Like adding div tags so jquery can hide stuff on the staff side? owen didn't think so, but I figured I'd ask you too.
11:53 chris nope
11:53 chris no changes to the html
11:53 chris just to the template tags
11:54 hdl http://www.radarvirtuel.com/
11:54 hdl you can see it there.
11:55 jwagner chris, thanks. There are several staff pages where people have asked me to hide things, but they aren't set up for jquery to do it. I might work on them at some point.
11:55 hdl Click layers/ volcano ashes layer
11:55 kmkale thanks hdl. I think Schipol is not closed. I am a bit worried about them as they are quite aged..
11:57 kmkale right. bye all
12:07 kf chris: around?
12:17 chris for a few more minutes
12:17 kf oh
12:18 chris someone crashed pootle eh?
12:18 kf dont want to keep you awake
12:18 kf not crashed yet
12:18 kf but my colleague is changing acq translation and she said its loading for minutes
12:18 chris yeah something is beating the machine to death
12:18 kf cant imagine her to do something like that
12:19 * jwagner hands kf's colleague a big club
12:19 chris its probably google
12:19 hdl oh no I can't eat any longer :P (club is also a sandwich in france )
12:19 jwagner an edible club?
12:19 chris answering ping, just nothing else
12:19 chris ill have to have a look in the morning if it hasnt come right by then
12:22 Amit heya owen, jwagner
12:22 jwagner Hi Amit
12:43 kf chris: im sorry, phone call - thx for your help
12:43 chris should be fixed now
12:44 chris i wont be sorry to say goodbye to pootle :)
12:54 magnus been away for a week... did anyone else get an invitation from Packt Publishing to be a "Technical Reviewer" for a book called "Koha 3 Library Management"?
12:55 jwagner magnus, I did
12:55 paul_p magnus, I did too (a long time ago)
12:55 magnus guess they scraped the mailinglist archives or something then
12:56 jwagner Gee, and I was feeling all special :-)
12:56 kf chris: poor poootle
12:56 magnus me too... :-)
12:58 chris magnus: me too
12:58 magnus anyone planning on volunteering? sounds like nengard would be the perfect candidate...
12:58 nengard huh?
12:59 chris nope
12:59 nengard what am I being volunteered for?
12:59 jwagner I don't have time right now (or any real inclination)
12:59 nengard Oh!! That book is not good ...
12:59 nengard I did volunteer and then said no thank you after I read it
12:59 nengard sorry :(
12:59 * owen grumps about not getting an invitation anyway
12:59 chris i think its out of date now, and will be more out of date by the time its published
13:00 jwagner I suppose they don't want negative reviews....
13:00 nengard it's just my manual in print form ...
13:00 nengard jwagner they thanked me and said they would improve upon it ... but we'll see
13:00 chris I have talked it over with her and it sounds like the book is written as a manual. We already have a manual available under a free software license, GPLv2 or later, which being digital is able to change at the rapid the software changes. For this reason alone I would have to decline.
13:00 chris If the book was instead on something more immutable like the project history, or if it had involved the wider Koha community from the start I might be interested.
13:00 chris thats what i said
13:01 magnus nicely put, chris
13:03 kf chris: its slow again, I take the poor pootle back
13:03 kf pootle--
13:03 magnus owen: i can decline and then suggest they contact you... ;-)
13:03 kf @karma pootle
13:03 munin kf: Karma for "pootle" has been increased 0 times and decreased 1 time for a total karma of -1.
13:03 owen magnus: :)
13:05 gmcharlt fredericd: will you be running something other than pootle?
13:06 chris well, pootle is ok on its own server
13:06 chris but not on my home machine, with the bots, and the irclog search, and 3 kohas etc
13:07 * jwagner read that as irc clog....
13:07 owen chris: Not to mention the "cute kid quote" AI you've been developing
13:07 owen that takes a lot of cycles
13:07 gmcharlt owen++
13:08 gmcharlt @quote add <owen> chris: Not to mention the "cute kid quote" AI you've been developing. that takes a lot of cycles
13:08 munin gmcharlt: The operation succeeded. Quote #74 added.
13:08 chris heh
13:08 jwagner Fortunately, there's an endless supply of cute kid quotes, right?
13:09 chris i think they stop around 12
13:09 chris then they just tell you you suck for 6 years
13:09 jwagner I was thinking, at least until they become surly teenagers instead....
13:10 jwagner They do get over it though. Starting along about my 20s, the older I got the smarter my parents got :-)
13:10 chris :)
13:11 gmcharlt @quote add <jwagner> They do get over it though. Starting along about my 20s, the older I got the smarter my parents got :-)
13:11 munin gmcharlt: The operation succeeded. Quote #75 added.
13:11 * jwagner repeats chris's "heh"
13:16 owen chris: Unfortunately for me the sass has already started at age 6
13:19 chris sleep time
13:19 chris good night all
13:21 paul_p chris, sweet dreams
13:25 Koha-Noob hi =)
13:27 owen Hi Koha-Noob
13:27 dschust Alter ego of schuster here... Trying to do inventory with a file and getting an error... owen you calling me a koha-Noob? I probably deserve it... ;)
13:27 dschust Undefined subroutine &main::AddReturn called at /home/liblime/kohaclone/tools/inventory.pl line 137, <fh00001bio2.txt> line 4.
13:28 dschust I'm on 3.01.00.032
13:29 dschust I've been able to upload files in the past so this is a new mystery...
13:31 Koha-Noob hey i'm new into this whole Koha thing and i'm totally unexperienced
13:31 Koha-Noob could you guys help me by recommending me some tutorials?
13:31 Koha-Noob please =)
13:32 jwagner dschust, is fh00001bio2.txt your input file? If so, what does line 4 of it look like?
13:32 dschust 30126012569023
13:32 owen Have you been here Koha-Noob? http://koha-community.org/documentation/
13:32 jwagner dschust, and that's a valid barcode in your system?
13:33 Koha-Noob hey thanks
13:33 dschust jwagner - I'm afraid there is something in the .pl... Yes Jane Addams :
13:45 dschust hmmm - I copied some of the barcodes to a file even though it looks like a LF<return> is there it isn't reading that as it loads. When I manually put it in then the file loads.... hmmmm interesting.
14:13 brendan good morning all :)
14:13 braedon|home howdy
14:13 brendan braedon - you up late?
14:13 braedon|home hmm
14:13 braedon|home 2:15
14:13 braedon|home damn you internets!
14:13 brendan or could be considered early
14:14 braedon|home yes, it does turn into that sometimes
14:14 braedon|home not very conducive to the next night however
14:17 braedon|home s/to the/to sleep the/
14:19 wizzyrea nengard: please see: http://koha-community.org/documentation/
14:20 nengard OH BOY OH BOY!!!!!
14:20 nengard even though it's evil M$ - OH BOY!
14:21 wizzyrea well you have to pay google now
14:21 nengard but it doesn't seem to have all of the pages indexed yet ... i searched for opac and only got 3 results
14:21 nengard so now it's evil google too!!!
14:21 wizzyrea yea, I just now put it on
14:25 nengard THANK YOU!!
14:25 wizzyrea :D
14:25 nengard Maybe one day - when someone has time (ha ha) we can put an open source one on there- but this is better than nothing!!!
14:25 wizzyrea PDF shouldn't be too hard
14:25 nengard nope
14:25 nengard there are scripts for that
14:25 nengard like the HTML ones
14:26 wizzyrea yep
14:27 wizzyrea I hate to say this
14:27 wizzyrea the bing webmaster tools work a lot better than google's
14:27 nengard hehe
14:27 braedon|home blasphemy!
14:27 * wizzyrea ducks
14:27 braedon|home Shun the non believer!
14:28 wizzyrea but... but...
14:28 * braedon|home chants "shun, shun"
14:28 * wizzyrea sobs
14:30 chris_n bing--
14:30 chris_n google++
14:30 wizzyrea hey I didn't say I am like a bing supporter now
14:31 wizzyrea only that the webmaster tools work a little bit better :P
14:31 * chris_n gives wizzyrea an 'E' for 'Effort' :)
14:31 wizzyrea pbbbt
14:32 jcamins Obligatory UserFriendly reference: http://ars.userfriendly.org/cartoons/?id=19991001
14:32 jcamins And, good morning, #koha
14:32 wizzyrea ...lol
14:32 wizzyrea good morning
14:32 nengard chris_n wizzyrea said google was charging ... which kind of knocks one of those pluses off
14:33 wizzyrea yea, they charge for sitesearch now
14:33 jdavidb wizzyrea++
14:33 wizzyrea it's pretty cheap, $100/yr for <1k pages
14:33 wizzyrea but still
14:33 wizzyrea we're pushing 800 on k-c now
14:33 wizzyrea er, 900
14:33 * chris_n wonders if google has come to the end of its rainbow
14:34 braedon|home we must keep faith!
14:36 braedon|home let us not doubt our solitary ray of sun in a forest of evil due to the dimming of a few passing clouds
14:36 wizzyrea ... i thought that was koha :P
14:37 braedon|home (Koha isn't a Internet corporation)
14:37 wizzyrea oh tha
14:37 wizzyrea t
14:38 braedon|home never fear, the mighty google is fighting as we speak to push back the spreading darkness
14:38 braedon|home do not begrudge it a few dimes for the cause
14:39 wizzyrea lol if you want to donate that to the cause i'll change it :P
14:39 mib_7wo0o6 Hi guys
14:39 mib_7wo0o6 I'm confused about version numbers.
14:40 wizzyrea okies
14:40 mib_7wo0o6 Is koha-3.00.06 an update to koha-3.02.00.alpha
14:40 wizzyrea nope
14:40 mib_7wo0o6 I was hoping for the other answer.
14:41 wizzyrea sorry
14:41 mib_7wo0o6 How do I get off alpha?
14:41 wizzyrea 3.00.06 is an update to 3.00.05
14:41 braedon|home wizzyrea: alas, braedon does not currently have a credit or debit plus card to easily do so(nor a proof of current address to get one)
14:41 wizzyrea you mean back off of alpha to 3.0.06?
14:41 gmcharlt mib_7wo0o6: koha-3.02.00.alpha2 is an update to the first alpha
14:41 mib_7wo0o6 Well, I want to move to stable code.
14:42 mib_7wo0o6 The last guy who managed our site moved us to the alpha branch.
14:43 braedon|home do you know if it is a dev install? or standard?
14:43 mib_7wo0o6 I don't.
14:43 mib_7wo0o6 The last thing -I- did was install koha-3.02.00-alpha
14:43 mib_7wo0o6 over the code we had.
14:44 mib_7wo0o6 I think that was obtained via git
14:45 braedon|home did you just pull the new version? or did you have to explicitly upgrade the old install with a make once you had it?
14:45 mib_7wo0o6 I followed the upgrade instructions.
14:45 braedon|home ok, standard install then
14:46 mib_7wo0o6 That sounds promising.
14:47 mib_7wo0o6 What would be a good way to move this production box to production code?
14:47 braedon|home you should be able to move to 3.0.06 the same way(i think), but of course the upgrade path is designed for moving from older to newer, not the other way around. Some issues may arrise. I am not sure if anyone has tested doing so
14:48 mib_7wo0o6 Would I have to wait a long time for a non alpha 3.02 version?
14:48 braedon|home unless anyone else has any better ideas, i would make a complete backup of everything, and try "upgrading" to the 3.0.06
14:48 wizzyrea won't be too long, I don't think (a few weeks to a couple of months?)
14:49 jcamins mib_7wo0o6: How much data do you have in your Koha installation?
14:50 mib_7wo0o6 We've got lots and lots of data.
14:50 mib_7wo0o6 At least now I'm not shooting in the dark.
14:50 wizzyrea if I can ask what kind of problems are you having with the alpha?
14:50 mib_7wo0o6 Well...
14:51 jcamins Okay. Just figured I'd check, because if it were just MARC records, you could just do a straight export/import.
14:51 mib_7wo0o6 One thing that keeps coming up is the history of messages that an individual has gotten tends to show the history of messages that every individual has gotten.
14:52 mib_7wo0o6 I keep having to go back and fix that, and I've been meaning to let you guys know about it.
14:52 wizzyrea ...no time like the present
14:52 mib_7wo0o6 I think there's also an issue of renewals not working, but we've got an odd collection.
14:52 mib_7wo0o6 I've got to go to a meeting right now, but I'll be back.
14:52 wizzyrea ok
14:53 chris_n mib_7wo0o6: you will probably have problems with your db when downgrading
14:53 wizzyrea it would probably be better to "suffer" through til the official release
14:53 chris_n yup
14:54 chris_n since there is no 'downgradedatabase.pl'... :)
14:54 wizzyrea boy, would be nice if his complaints were registered somewhere official so we could fix those problems...
14:55 * chris_n thinks it would be nice if mibbit generated nicks that were more conducive to typing :-P
14:56 wizzyrea what's funny
14:56 wizzyrea is that they have the option to type in a name
14:57 kmkale hi wizzyrea
14:57 gmcharlt mib_7wo0o6: http://bugs.koha.org would be a place to detail your problem
14:57 kmkale hi chris_n
14:57 chris_n heya kmkale
14:57 wizzyrea but I wish mibbit had less stupid nicks too
14:58 wizzyrea heya kmkale
14:59 kmkale i think wyzzyrea is a tongue twister too ;)
14:59 wizzyrea :D
15:00 kmkale :))
15:00 braedon|home does chris_n not have autocomplete?
15:00 braedon|home yours is the most annoying for me
15:01 braedon|home i have to type an underscore to complete it
15:01 braedon|home though would hit the same thing with multiple mibbit accounts
15:04 braedon|home hey!
15:04 __chris__ hehe
15:04 braedon|home actually, that is stil easier
15:04 brendan heya __chris__
15:04 braedon|home just need the underscore plus tab
15:04 wizzyrea maybe you should be _chris_n
15:04 braedon|home not c tab underscore
15:04 * brendan prefers chris_n
15:04 * brendan doesn't know this __chris__ character
15:05 chris_n and we're back
15:05 brendan chris_n++
15:05 braedon|home of course not - that name isn't exported
15:05 braedon|home s/exported/imported/
15:05 braedon|home o, wait, this is a perl club isn't it :(
15:09 braedon|home actually, two trailing underscores, so isn't mangled.
15:09 kmkale bye all good night
15:09 * braedon|home retracts his lame and incorrect joke
15:09 braedon|home sigh
15:11 wizzyrea awww
15:11 gmcharlt tough crowd
15:12 braedon|home and fried brain
15:12 * braedon|home calls it a night
15:16 chris_n sleep well braedon|home
15:22 brendan @wunder 93117
15:22 munin brendan: The current temperature in Northwest Goleta, Goleta, California is 12.7�C (8:21 AM PDT on May 18, 2010). Conditions: Overcast. Humidity: 90%. Dew Point: 11.0�C. Pressure: 30.04 in 1017.2 hPa (Rising).
15:39 owen Why is the debug_level "0" message "<p>production mode - trapped fatal error</p>" ?
15:39 owen How does that help?
15:39 owen presumably if you've got the debug level set to 0 you want to hide weird errors from your users
15:40 owen So how about offering the same kind of options that a 404 or 500 error give you?
15:42 jwagner Got a question for anyone who does patron load updates (dschust, anyone else) -- if there is absolutely no unique number associated with the incoming data, has anyone tried loading, say, email addresses into a patron attribute & using that as the patron load match point?
15:43 jwagner I was just experimenting, and it looks like you can't use anything but cardnumber from the main patron fields. But you can create a patron attribute field that's configured as unique, and then use that.
15:43 jwagner I just don't know if that's a good/workable idea
15:43 wizzyrea could you end up with kids having the same email addresses as their parents?
15:44 jwagner Not for this particular site (it's a college), but in general that could be a problem.
15:44 jwagner I suppose we could also try using email addresses as the card number; not sure that's a good idea either.
15:48 gmcharlt jwagner: does the library plan to issue barcodes later?
15:48 gmcharlt more commonly, colleges tend to use the student's college ID number for that purpose
15:49 wizzyrea ooh, good call on that one
15:49 jwagner Yes. They would have to do those manually in the library. They want to do regular patron updates from the registrar, and there is no usable ID number from that system. (They use SSN which I flatly refuse to import into Koha for privacy/security/identity reasons.)
15:49 owen Bug 2318 seems to imply that at one time one would get a 404 error for an invalid biblionumber
15:49 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=2318 enhancement, P5, ---, gmcharlt@gmail.com, NEW, Attempting to view details of a biblio that does not exists results in a 404 error
15:49 owen I'm finding that I'm getting an error message instead
15:50 owen "Can't call method "field" on an undefined value at /home/oleonard/kohaclone/C4/Koha.pm line 1233."
15:52 owen Or, with XSL enabled: "Can't "next" outside a loop block at /home/oleonard/kohaclone/C4/XSLT.pm line 67."
15:56 gmcharlt jwagner: maybe you can generate a salted hash of the SSN to use as the match key?
15:56 gmcharlt I agree that SSNs should stay out of the database
15:57 gmcharlt owen: yep, it should be a 404 (or probably better, a friendlier page explainign that no such bib exists)
15:58 jwagner gmcharlt, we thought about hashing the SSN, but I'd really rather not get into allowing SSN data in _any_ form if we can find some alternative.
15:58 wizzyrea "that item is no longer in the catalog"
15:58 owen See the comments on Bug 2318 for discussion of whether it should be a 404 or a more specific error
15:58 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=2318 enhancement, P5, ---, gmcharlt@gmail.com, NEW, Attempting to view details of a biblio that does not exists results in a 404 error
15:58 gmcharlt jwagner: problem with email addresses is that while the campus may hand out unique email addresses from the campuses' domain, unless they have a policy to the effect that the students *must* use those addresses for official colllege communication, the library is going to be under pressure from the students to use whatever their actual addresses are
15:59 gmcharlt but if the college *does* enforce such a policy, email address qua unique identifier may be good enough
15:59 jwagner gmcharlt, yes, that was one of the problems I saw with that approach -- they have multiple email addresses for each patron.
16:00 jwagner If I remember correctly, there's a character limit on cardnumber field (10?), but not on a patron attribute. Is that the case?
16:01 jcamins jwagner: The other problem with e-mail addresses is that some colleges assign two e-mail addresses to TAs- one for being a student, one for being a TA (not an issue if there are no TAs, of course).
16:03 jcamins (assuming you can use college-assigned addresses for matching, and a preferred address for contact)
16:03 janewagner Harrumph
16:03 gmcharlt jwagner: even if it has no status as an official campus ID, can the registrar include whatever the student record primary key is?
16:05 gmcharlt janewagner: how much did you miss?
16:05 janewagner gmcharlt, that was something I was wondering as well. I'd much rather use a unique number as cardnumber than mess around with trying to match on email address. I'llhave to talk to them.
16:05 gmcharlt cardnumber is varchar(16)
16:06 gmcharlt a borrower attribute is varchar(64)
16:06 janewagner OK, cardnumber wouldn't work for email address then.
16:30 gmcharlt @quote random
16:30 munin gmcharlt: Quote #3: "< bignose-work> the only constant in climate over the next several decades will be that the climate doesn't match what you just got used to." (added by chris at 09:55 PM, June 11, 2009)
16:37 wizzyrea @quote random
16:37 munin wizzyrea: Quote #41: "owen: Being an ass doesn't qualify as a medical condition ;)" (added by jwagner at 11:13 AM, October 16, 2009)
16:38 wizzyrea tee hee
16:38 * owen curses and throws away his sick leave request form
16:39 wizzyrea hahahahahaha
16:40 CGI905 hm
16:40 wizzyrea hm?
16:42 jcamins Does anyone know if there has been a bug reported on the staff client's handling of holds (in 3.2-alpha)?
16:42 jcamins *limits
16:42 jcamins I found a bug on handling holds, when searched for limits.
16:43 owen What's the deal #koha? Why you keep kicking me?
16:44 brendan @roulette
16:44 munin brendan: *click*
16:44 brendan owen++
16:44 brendan maybe that will help
16:45 owen :)
16:47 nengard_lunch owen - i keep getting kicked too
16:49 brendan nengard++
16:49 brendan that will help :)
16:49 nengard :)
17:07 owen Wow, Bug 3594 is a real train wreck of a report
17:07 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3594 enhancement, P5, ---, gmcharlt@gmail.com, NEW, two item dropped from the data base or stuff interface
17:10 brendan heh
17:10 nengard "stuff interface" ??
17:10 nengard hehe
17:36 cait hi #koha
17:42 jwagner Hi cait
17:43 cait hi jwagner
17:47 gmcharlt nengard: "stuff interface"? why not? Koha is all about managing the library's stuff ;)
17:47 nengard I was more asking what a stuff interface was :)
18:16 wajasu I have a problem showing a detail view for XSLT in the staff client interface. http://pastebin.org/249237
18:25 gmcharlt` wajasu: check that your copy of koha-tmpl/intranet-tmpl/prog/en/xslt/MARC21slimUtils.xsl is up to date
18:25 wajasu ok.
18:26 gmcharlt` also see http://git.koha-community.org/gitweb/?p=koha.git;a=commit;h=e65fcb998bbba11b9d695cd42fcfbfb65924dc5a
18:31 gmcharlt @quote random
18:31 munin gmcharlt: Quote #10: "< pianohacker> You helped start an open source project; clearly your sense of what to avoid to make your life easier has been impaired for a while :)" (added by chris at 03:59 PM, June 23, 2009)
18:33 wajasu that gitweb site is slow. where's it at?
18:33 owen It's very fast for me
18:44 gmcharlt wajasu: Texas, I believe
18:44 wajasu yes. i'm doing a speed test now.
18:51 jdavidb harrrumph!
18:51 jwagner Yes, indeed.
18:57 wajasu my speedtest is fine 7Mbps down, 1.5up. i'm in dallas. its takeing me 5-10 minutes to get a page . still transferring...
18:58 owen Looking at Bug 3125... When you choose to add a field from the list of choices, should that field be removed from the first column? Or just added to the second column?
18:58 munin` 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3125 normal, P3, ---, oleonard@myacpl.org, NEW, IE7: Selected columns list in Reports Dictionary is not showing column names.
18:58 owen In other words, should the user be able to select a certain column more than once?
19:03 schuster Question - about inventory - seems like there were some patches done by BibLibre to Inventory... Can anyone expound on those fixes? I think I have run across a but in 3.2 that biblibre may have fixed.
19:03 wajasu cloning da git now.
19:03 gmcharlt owen: for the reports dictionary, I think just allow a column to be selected once
19:04 schuster We are now thinking that - Undefined subroutine &main::AddReturn called at /home/liblime/kohaclone/tools/inventory.pl - mean AddReturn subroutine is supposed to "RETURN" the book if it is found but inventory.pl can't find the subroutine.
19:06 gmcharlt schuster: that's an old bug (bug 3329)
19:06 munin` 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3329 major, PATCH-Sent, ---, nahuel.angelinetti@biblibre.com, RESOLVED FIXED, missing dependency in inventory.pl
19:06 gmcharlt fixed in HEAD in June 2009
19:06 schuster Well that's what happens when you are on an OLD version of Koha... :0
19:07 jwagner We're working on that!
19:07 schuster Nothing against PTFS...
19:07 gmcharlt commit fc798b0e8d9605b8fbacdc07eb83f3925bf6fc2f should be cherry-pickable just fine
19:08 schuster Just noting a problem. Thanks gmcharlt...
19:08 jwagner schuster, it should already be in the version that you'll be getting when we do your update
19:10 owen Anyone have an opinion/directive regarding my guided reports dictionary question?
19:12 jwagner owen, you're talking strictly about reports? There shouldn't be a need to repeat fields there. In notices, I could see a use for it.
19:12 gmcharlt owen: for the reports dictionary, I think just allow a column to be selected once
19:12 * owen imagines the notices template may use the same faulty js
19:13 gmcharlt note that allowing multiple copies of the same column to be displayed in report output, although unusual, could be desierable
19:13 gmcharlt i.e., there's a difference between the reports dictionary and the main guided reports wizard
19:15 chris morning
19:15 jwagner morning, chris
19:15 chris_n hey chris
19:18 owen Hmmm.. the notices template has its own problems in IE.
19:19 jwagner owen, is there anything that DOESN'T have problems in IE?
19:20 libtek Can't call method "append_fields" on an undefined value at /usr/local/share/perl/5.10.0/MARC/File/SAX.pm line 92.
19:20 libtek need some advice. I've attempted to create a record through a z39.50 search (I am no cataloger by any means). When I try to save the record I get the error:
19:20 libtek Can't call method "append_fields" on an undefined value at /usr/local/share/perl/5.10.0/MARC/File/SAX.pm line 92.
19:21 chris_n IE eq PROBLEM
19:21 chris_n always evaluates as true
19:21 libtek I found the following link:
19:21 libtek http://sourceforge.net/projects/marcpm/
19:22 cait2 morning chris and thx again for pootle
19:22 cait2 :)
19:22 libtek I'm not sure what to do with the files. Nothing guides me in updating any files. Anyone have any suggestions?
19:22 gmcharlt libtek: you need to provide more information
19:22 gmcharlt *which* record from *which* Z39.50 server are you trying to import?
19:23 chris cait2: it didnt crash again or anything did it? the problem is apache/pootle use too much ram
19:25 cait2 no, it didn't. just wanted to say thank you again
19:26 chris cool :)
19:26 chris was just checking for sarcasm :-)
19:26 cait no :)
19:26 chris nginx++
19:26 chris apache2--
19:26 libtek gmcharlt: I searched for ISBN 0764507060 on the OCLC server fsz3950.oclc.org:210
19:27 cait jsp--
19:27 chris cait++
19:27 chris just cos
19:27 libtek gmcharlt: This is only my 2nd attempt. I've tried two different records with the same results.
19:29 gmcharlt libtek: what z39.50 database name and syntax?
19:30 libtek gmcharlt: OLUC and UNIMARC.
19:35 libtek gmcharlt: I'm guessing on the settings. Basing some of this on current settings in our current ILS. Had to guess on syntax and encoding (which is set to UTF-8)
19:36 gmcharlt libtek: are you in fact using UNIMARC, not MARC21?
19:37 chris ok bus time back in a bit
19:39 gmcharlt libtek: zcat.oclc.org , base OLUCWorldCat , syntax MARC21/UNIMARC, charset UTF-8 work for me
19:40 libtek gmcharlt: Honestly, I don't know. I just tried these settings and it was pulling the information up. Everything worked for the import. It was only when I saved the item record that the error was thrown up.
19:42 gmcharlt libtek: ah, you didn't say that the problem was occuring when you came to same an item, as opposed to the bib
19:44 libtek gmcharlt: sorry. I'm trying to be clear.
19:48 libtek gmcharlt: sorry, IE crashed
19:48 * owen shudders
19:48 wajasu just checked up on how my git clone is doing. its sitting at Receiving objects: 0% (115/147608), 36.00 KiB Hmm.
19:48 gmcharlt libtek: were there any diacritics or the like (in say the call number) of the item you attempted to add
19:48 gmcharlt also, can you confirm whether your library in fact uses UNIMARC or not
19:49 Mike Can anyone cast any light on this error msg: zebrasrv: sortidx.c:472: zebra_sort_read: Assertion `sf' failed.
19:51 libtek gmcharlt: I am a tech only. I don't know anything about diacritics. Also, Koha is a new install we are testing. I don't know if it is using UNIMARC or not.
19:54 chris_n libtek: you had to select either UNIMARC or MARC-21 during the webinstaller run
19:55 gmcharlt libtek: the marcflavour system preference would be a hint; if your library has catalogers on staff, they would be able to definitively tell you what MARC format they are using
19:55 wizzyrea_laptop libtek: us library?
19:55 wizzyrea_laptop or elsewhere?
19:58 libtek gmcharlt: I don't see it listed in the instructions, so if it presented me with choices during install, I went with defaults.
19:58 libtek wizzyrea_laptop: Yes, US.
20:01 libtek ah, one of our catalogers says MARC-21
20:02 gmcharlt libtek: as a first step, in the z3950 server definition for OCLC
20:02 gmcharlt try changing the server to zcat.oclc.org
20:02 gmcharlt the database to OLUCWorldCat
20:02 gmcharlt and the syntax to MARC21
20:02 gmcharlt also, please go the Administration | System Preferences
20:02 gmcharlt search for marcflavour
20:03 gmcharlt and tell us what the value of that system preference is
20:03 libtek um, I think I corrupted the database
20:03 libtek I am such an idiot :/
20:06 libtek There is part of a record left. If I click on it to remove it, it now throws up the error
20:06 libtek Can't call method "fields" on an undefined value at /usr/share/koha/intranet/cgi-bin/catalogue/MARCdetail.pl line 123.
20:09 wajasu maybe your indexes need to be rebuilt.
20:11 wajasu i can't get a git clone for koha.git to happen. hangs at Receiving objects usually.
20:13 libtek gmcharlt: Okay...I'll get the hang of this eventually. Getting a crash course in cataloging... I found marcflavour and it is indead MARC21. I've setup a new OCLC server per your request. However, I still have this piece of record in the db. Any clue as to how I can purge it?
20:13 gmcharlt from SQL, you could delete it from the biblio and biblioitems table, then run an index rebuild (using rebuild_zebra.pl)
20:18 libtek gmcharlt: okay...let me see if I can figure that one out....
20:20 wajasu can someone try git clone git://git.koha-community.org/koha.git so i know if its me thats the problem?
20:20 libtek gmcharlt: okay...I am really green with ubuntu. I am learning everything as I go. Can you give me a little push? How do I get into MySQL?
20:21 gmcharlt wajasu: works for me
20:21 gmcharlt whereabouts are you located?
20:22 wajasu aaargh. dallas tx
20:22 hdl wajasu: looks ok for me
20:22 chris_n works for me too
20:22 wajasu unless its an ISP thing TWcable
20:22 chris_n wajasu: traceroute git.koha-community.org may tell
20:22 wajasu i just did that
20:23 wajasu 12 hops.
20:23 chris_n no slow ones?
20:23 wajasu the slowest was 68ms
20:24 brendan weird the main hosting spot for that is in Dallas-Fort-worth
20:24 chris_n strange indeed
20:25 wajasu http://pastebin.org/249862
20:26 gmcharlt wajasu: your ISP isn't filtering on traffic 9418?
20:26 gmcharlt port 9418, rather
20:26 wajasu not that i know about.
20:26 wajasu shouldn't filter anything as far as i'm concerned.
20:27 wajasu letme research .
20:27 wajasu i'm receiving objects now. 6 KiB/s
20:28 wajasu maybe throttling?
20:28 Mike Can anyone decode this error message for me? zebrasrv: sortidx.c:472: zebra_sort_read: Assertion `sf' failed.
20:30 wajasu let me check modem signal db ratio
20:32 richard hi
20:35 wajasu that code assertion check that the sortFile is not NULL. a file being specifed for sorting (si-> current_file) in the code, was not specified correctly for some reason.
20:36 chris back
20:41 libtek gmcharlt: I figured out how to get in the database. biblio and biblioitems are empty. I am not sure where else this record information lives.
20:41 gmcharlt libtek: then just run rebuild_zebra.pl -b -r
20:44 wajasu when the database is empty, you get that "fields" error. i struggled when i 1st installed koha, built indexes, then unimported my staged records.
20:45 libtek gmcharlt: I located 3 instances of that script. Does it matter which one I run?
20:45 wajasu the rebuild hopefully syncs reality.
20:48 libtek didn't do any good. Still gettingthe fields error.
20:50 libtek I'm going to have to list each table till I find the bad record :/
20:56 chris_n libtek: did you run rebuild_zebra.pl as your kohauser?
21:00 libtek chris_n: sudo perl /usr/share/koha/bin/micration_tools/rebuild_zebra.pl -b -r
21:01 libtek chris_n: that's all I knew to type
21:01 libtek that should read migration_tools
21:01 chris_n sudo su koha
21:01 libtek okay...I'll give that a whack.
21:01 chris_n then 'perl /usr/share/koha/bin/micration_tools/rebuild_zebra.pl -b -r -v'
21:02 chris_n assuming your kohauser is the default 'koha'
21:02 chris_n the -v will show up any errors during the rebuild
21:03 libtek it is
21:03 libtek Okay. I did: sudo su koha
21:04 libtek Then: perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v
21:05 libtek It does not report any errors
21:05 libtek do I need to restart the db?
21:05 chris_n nope
21:05 chris_n that should do it
21:06 libtek I still have the 1 result in the catalog, and it gives the field error when clicked on. :/
21:07 libtek Now, I was checking the koha db in MySQL earlier. Did I look at the right db?
21:07 cait libtek: reindexing should work, it did when I had the field error
21:07 cait :)
21:07 chris_n libtek: what does 'ps -ef | grep zebra' say?
21:08 cait oh
21:08 * cait is perhaps too tired
21:08 * chris_n thinks it should work too
21:09 libtek what's the clipboard url?
21:09 chris_n paste.workbuffer.org
21:10 pastebot "libtek" at 192.168.15.101 pasted "results for ps -ef | grep zebra" (6 lines) at http://paste.workbuffer.org/10
21:11 chris_n for starters, stop the zebraqueue daemon
21:12 chris_n and then re-run the rebuild script
21:13 libtek done
21:14 libtek and I didn't even have to ask how to stop the daemon! Score 1 for me!
21:14 chris_n you should also setup zebrasrv to start this way: http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=INSTALL.debian;h=07d13a4ed8964dd8c7d71d40ab4e3cb131a75719;hb=HEAD#l332
21:14 chris_n that way it logs and auto starts on reboot
21:14 chris_n check to see if your item is still hung now
21:17 libtek do I need to do this zebrasrv setup or restart the daemon first?
21:18 chris_n no, you can check first
21:18 chris_n if that does not fix it, you should probably setup zebrasrv as mentioned
21:18 libtek still there and still hung
21:22 chris_n libtek: if you have not done any data entry, you could drop and re create the database in mysql
21:22 chris_n then walk back through the web installer
21:22 chris_n and reindex zebra
21:22 chris_n that should clear it for sure
21:22 chris_n and should take all of 5 min
21:23 chris_n in any case, you don't want to run the zebraqueue daemon
21:23 libtek chris_n: This is how I set this up. These are the same instructions I used. I initially did the Zebraqueue Daemon instructions, but then later setup the crontab per instructions.
21:24 chris_n yes, but the zebraqueue daemon was running based on your ps output
21:24 chris_n and the two don't seem to cohabit nicely
21:28 libtek Okay. Well, I stopped the daemon as you instructed, and I do have the crontab set as */5 * * * * KOHA_CONF=/etc/hoha/koha_conf.xml PERL5LIB=/usr/share/koha/lib/ /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -a -z >/dev/null
21:29 chris_n that's right
21:29 libtek That shoud read KOHA_CONF=/etc/koha...
21:29 libtek not hoha
21:30 chris_n well, as I say, droping the db will fix it
21:30 chris_n dropping even
21:30 chris_n gotta run, bbl
21:31 libtek that will get rid of the patron/staff account I am using and the matix and libraries too, right?
21:31 libtek thanks for the help! I appreciate the time.
21:49 chris hmm i just discovered a nasty
21:50 wizzyrea_laptop uh oh
21:50 chris _get_url in XISBN
21:50 chris will return 1, if it fails
21:50 chris then we do
21:50 chris $response->{isbn} = [ @{ $xisbn_response->{isbn} or [] }, @{ $syndetics_response->{isbn} or [] }
21:50 chris and kabloom
21:50 chris [Wed May 19 09:49:55 2010] opac-detail.pl: WARNING: URL Request Failed 500 read timeout
21:50 chris [Wed May 19 09:49:56 2010] opac-detail.pl: XISBN Failed Can't use string ("1") as a HASH ref while "strict refs" in use at /home/chrisc/git/koha/C4/XISBN.pm line 121.
21:51 chris 500 error on the opac
21:51 * chris will fix and send a patch
21:57 wajasu i ended up pulling the MARC21slim2intranetDetail.xsl from http://git.librarypolice.com/?p=koha-galen.git;a=tree;f=koha-tmpl/intranet-tmpl/prog/en/xslt;h=6a80d8cfec2cc87eac62007a9ff775064229ab50;hb=HEAD but still get m880Select was not found errors.
21:59 gmcharlt wajasu: you need the MARC21slimUtils.xsl
21:59 wajasu as well?
21:59 wajasu ok
22:04 wajasu gmcharlt++
22:04 wajasu that was it!
22:04 wajasu should i grab MARC21slimUtils2.xsl or is it not needed
22:06 gmcharlt wajasu: not needed, and you should have it anyway
22:14 chris http://www.kohacon10.org.nz/ <-- more sponsors, thanks chilts for putting the logos up
22:26 libtek anyone have a suggestion for backing up the mysql koha database before I mess it up again?
22:26 brendan mysqldump
22:26 larsw libtek, do a dump of the database using mysqldump, and store that somewhere safe
22:28 libtek what is the syntax for using mysqldump? Never used it before.
22:29 larsw mysqldump --databases --user="$mysqluser" --password="$mysqlpass" "$mysqldb" |
22:29 larsw gzip > "$dbdump"
22:29 larsw that's what the dump script I am including the Koha Debian package uses
22:31 libtek do I use the quotes or drop them?
22:32 larsw keep them, replace whatever is inside them with the right value for user, password, name of database, and name of compressed dump file
22:35 libtek okay, I ran it, but I can't locate the "kohabackup" I supposedly created.
22:36 larsw it should be in the filename you put in place of $dbdump
22:37 libtek Yeah, I put kohabackup, but I am not find a file my that name anywhere with locate.
22:37 larsw locate uses a database that is updated only once per day
22:37 larsw what does ls tell you?
22:38 libtek okay. I see it.
22:39 libtek larsw: If I ever have to restore from this backup, what do I do?
22:39 larsw it should be a compressed file (compressed with gz), so it is customary to name it something like kohabackup.sql.gz (the .sql to indicate that is an sql dump file)
22:40 larsw libtek, my restore script uncompresses it and feeds the uncompressed file to the mysql command (/usr/bin/mysql), you may need to provide --user and --password options to that, too
22:40 larsw libtek, but I am not sure if that is the best way to do it, I am new to databases
22:41 robin larsw: I think that is the correct way for mysql
22:42 libtek I don't see a myrestore script anyware
22:42 libtek anywhere
22:45 reed libtek, it's the normal mysql command, I don't there there's a separate restore command
22:45 reed (but I might be wrong)
22:47 larsw libtek, mysqldump makes a file that contains normal sql commands that re-create a database; the /usr/sbin/mysql command reads any sql commands and executes them; when it reads the dump file, it executes the commands to re-create the databse
22:47 bgkriegel libtek, you could do a restore this way: 1) first drop database, 2 create database, 3 gunzip backup, 4 load backup, or by commands "mysqladmin -uroot -pxxx drop koha; mysqladmin -uroot -pxxx create koha; gunzip kohabackup.sql.gz; mysql -ukohaadmin -pyyyy koha < kohabackup.sql"
22:48 libtek ah. Okay. I hope I never have to use it.
22:48 bgkriegel try a couple of times
22:48 bgkriegel with a test database
22:49 larsw that's what test environment are for, so you can safely destroy everything in order to learn :)
22:49 libtek I'll see what I can do. If I make another backup, do I need to delete the old one, or does the mysqldump replace it if I use the same filename?
22:50 bgkriegel use a different name
22:50 larsw it will replace it, so it's better to use a different name, yes
22:50 bgkriegel a use a name that ends with the date
22:51 bgkriegel something like kohabackup-$(date +%Y%m%d).sql
22:52 larsw possibly even kohabackup-$(date +%Y%m%dT%H%M%S).sql to have more than one backup per day
22:57 libtek thank you for the advice. I have copied it down and will see what I can do!
23:01 larsw libtek, another thing: I have just learned about the MySQL Admin GUI tool, for GNOME, which seems like a nice one for many things
23:01 larsw libtek, it seems to have commands for backing up and restoring
23:03 libtek Thanks. I'm not using a gui on the server. I'm pushing myself to learn command line again. I haven't done a lot with it since my pre windows days in DOS. Time to remember things again and learn to take control :)
23:04 larsw oh, the mysql admin gui tool does not run on the server, just connects to it
23:04 larsw but I'm all for command line learning, it is the path to automating everything in your life so you have more time to spend on automating everything else in your life
23:55 pianohackr|work Hi, #koha
23:57 chris holy crap
23:57 chris its pianohackr|work
23:57 chris :)
23:58 chris how the heck are you??
23:58 pianohackr|work Hi, chris
23:58 pianohackr|work Very good
23:58 pianohackr|work Almost out of high school (glory hallelujah)
23:58 pianohackr|work You?
23:58 chris i hear you got accepted into a good university?
23:58 pianohackr|work Yup, an engineering school in my state
23:58 chris keeping busy :)
23:58 chris awesome !
23:59 pianohackr|work thanks.
23:59 pianohackr|work Will be sending in some of our library's custom changes over the next few months as we get ready to switch to outside support