IRC log for #koha, 2010-03-05

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
00:13 ebegin Hi all.  What is the ETA for 3.2beta?
00:14 chobbs joined #koha
00:14 chobbs OK, marclint is both cool and humbling :)
00:17 gmcharlt ebegin: 3.2 alpha2 by the end of th wekend
00:17 beta as soon as the blockers are closed
00:17 ebegin ok.  Thanks.
00:29 braedon|home1 left #koha
00:29 braedon|home joined #koha
00:38 brendan so year one birthday and my car treats me to a flat tire :)
00:39 bgkriegel left #koha
00:41 * chris_n hands brendan a virtual jack
00:42 brendan and new tire please :)
00:44 chris_n maybe fix-a-flat?
00:44 * chris_n finally coerces his zebra back to work
00:44 brendan for now pumping it up with a bike pump in a few hours
00:44 a nice work-out for the arms
00:44 tame that zebra
00:48 chris http://blog.bigballofwax.co.nz[…]fternoon-funnies/
00:54 brendan :)
00:58 gmcharlt atu clearly has a future as a very direct therapist
01:01 chobbs Is there a particular pastebin you all use for sharing code snippets in chat?
01:03 gmcharlt pastebot: help
01:04 chobbs: http://paste.workbuffer.org/
01:05 chobbs Thanks!
01:06 Anyone know of a good way to pick out one marc record (by number) in a marc file of 90K records? I'm currently looping through all records and using a counter to locate the record of interest. It feels kinda ugly :)
01:08 gmcharlt well, that's pretty much the way to do it
01:09 if you need to do it repeated on the same set of records, you could load and index them, then retrieve the records of interest
01:10 chobbs Well ,the problem is that loading them isn't working, and I'm trying to figure out why :)
01:10 More accurately, loading seems to work, but indexing is breaking.
01:10 I've run marclint on the exported_records and it blows up on record 78552, so I'm trying to id what's wrong with that record.
01:11 gmcharlt is 78552 the biblionumber of the database or the sequence number of the bib in the original file?
01:12 chobbs Good question. It's the number zebra_rebuild squawked on.
01:12 Which would that be?
01:13 gmcharlt could you paste the specific squawk?
01:13 chobbs I knew you were going to ask that - it's scrolled out of my terminal buffer, so I'll need to re-run zebra_build :(
01:14 gmcharlt screen is your friend ;)
01:14 chobbs Actually, it ought to be in theirc log, since I showed it to Chris earlier - wait one.
01:14 CGI822 joined #koha
01:15 chobbs I'm actually in screen, but still no joy :)
01:17 CGI822 left #koha
01:17 pastebot "chobbs" at 192.168.15.101 pasted "zebra_rebbuild squawk" (4 lines) at http://paste.workbuffer.org/9
01:18 chobbs marclint is having trouble with the record as well - looks like I'm missing a record terminator of some sort
01:19 gmcharlt what do you get when you run yaz-marcdump the_record.mrc
01:19 chobbs let me wait and see - 90,000 records :)
01:20 well, no errors
01:21 but it stopped after 21,945 titles
01:22 (assuming this is a legitimate way of counting records: grep '^245 [0-9][0-9] \$a' out.txt | wc -l )
01:22 and it's not
01:22 gmcharlt indicator regex should be [ 0-9][ 0-9]
01:23 chobbs I have 90,589 records, which is pretty much right on
01:23 yup, figured that out :)
01:23 gmcharlt what does grep -v '^[0-9]' out.txt | grep -v '^$' show ?
01:24 chobbs 90616, which is correct
01:24 actually, it might be 10 over, if memory serves
01:24 I thought I had 90,606
01:27 pastebot "chobbs" at 192.168.15.101 pasted "OK, there are errors in there:" (10 lines) at http://paste.workbuffer.org/10
01:28 chobbs found the 10 extra lines :)
01:28 found the 10 extra lines :)
01:29 gmcharlt ok - less out.txt and grep for ^( will show you the bad records
01:30 chobbs got it
01:30 pastebot "chobbs" at 192.168.15.101 pasted "Bad record" (12 lines) at http://paste.workbuffer.org/11
01:31 chobbs So how would I go about finding the record in my source MARC file, and figure out what I did wrong while building it? I'm in the process of conversion, btw.
01:32 gmcharlt select biblionumber from biblioitems where marc like '1201666%';
01:33 chobbs sweet
01:34 gmcharlt or if that doesn't work
01:34 select biblionumber from biblioitems where marc like '%Vid22005-04-1150%';
01:35 chobbs grr. no results in either case.
01:36 gmcharlt try this
01:36 select biblionumber from biblioitems where marc like '%nam2208509%';
01:36 and
01:37 select biblionumber from biblioitems where length(marc) > 99999;
01:37 * chobbs wonders if biblioitems is indexed: 43 seconds to select count(*) ?
01:37 gmcharlt select(*) is always slow in InnoDB - it's just a quirk of that storage engine
01:38 select count(*), even
01:38 chobbs ah, ok. :)
01:38 OK, biblionumber 78852
01:39 * gmcharlt takes a wild guess that the lowest biblionumber is your DB is 301
01:40 chobbs select min(biblionumber) from biblioitems; 1
01:40 gmcharlt eh, oh well :)
01:41 chobbs select length(marc) from biblioitems where biblionumber=78852; 120239
01:41 gmcharlt could you paste biblioitems.marcxml for that bib?
01:42 chobbs how would i get that?
01:42 ne'er mind
01:43 pastebot "chobbs" at 192.168.15.101 pasted "marcxml for 78552" (446 lines) at http://paste.workbuffer.org/12
01:45 chobbs that's not the right one :(
01:45 hold on
01:46 pastebot "chobbs" at 192.168.15.101 pasted "marcxml for 78552" (89 lines) at http://paste.workbuffer.org/13
01:46 chobbs The new one is based on this url - is this the right way to access it? http://koha:8080/cgi-bin/koha/[…]iblionumber=78552
01:47 gmcharlt yep
01:47 is it biblionumber 78852 or 78552 that's the bad one?
01:48 chobbs grumble
01:49 holy crap we have a lot of those items :)
01:50 wow, an 8MB marcxml file :)
01:51 gmcharlt whee!
01:51 adding -x to rebuild_zebra.pl causing it to process the bibs in thier MARC XML form
01:51 chobbs Yeah, it's 200K lines long - you sure you want me to paste it, or can we assume it's just plain not going to like it :)
01:51 gmcharlt let's not kill chris' pastebot :)
01:52 ... and that way, it would ignore the 99,999 byte limit of MARC record blob
01:53 but practically speaking, you'll need to duplicate that bib and spread its items around
01:53 chobbs OK, but looking at it, it seems broken.
01:53 the 952 fields seem to be run together
01:53 gmcharlt what does select count(*) from items where biblionumber = 78852 show?
01:53 chobbs 695
01:54 gmcharlt thought so
01:54 chobbs but that's way wrong
01:54 gmcharlt anyway, try rerrunning rebuild_zebra.;pl with the -x option
01:54 chobbs grep '<subfield code="p">3147' Downloads/bib-78852.marcxml | wc -l
01:54 9961
01:54 3147 being our barcodes
01:55 gmcharlt ah - is it a magazine?
01:55 chobbs nope, some ridiculous video adapter for computers.
01:55 tempted to just drop it :)
01:55 gmcharlt indeed
01:56 chobbs although we apparently got them fairly recently (03/2005)
01:56 gmcharlt did somebody really go to the trouble of barcoding over 3,000 video adapters?
01:56 chobbs no, they barcoded 9,961!
01:56 3147 is the start of our barcode tag number
01:57 gmcharlt ah right
01:57 what on earth did the poor slop who did it do to get that task? ;)
01:57 chobbs that was the year before I took over, so no idea :)
01:57 biglego joined #koha
01:58 chobbs alright, I appreciate your help identifying the problem. Now to figure out what to do about it.
01:58 * chobbs shakes head.
01:58 chobbs That's like 5% of our biblioitems table :)
01:58 gmcharlt more seriously, removing that bib and items for now would make sense - you can then munge that record to split it into a few dozen copies of the bib
01:59 chobbs is that as easy as delete from biblio, biblioitem where biblionumber=78852; ?
01:59 and items, of course
01:59 gmcharlt just deleting from biblio will cascade all the way
01:59 chobbs in mysql, or through koha?
01:59 gmcharlt in mysql
01:59 chobbs wow, real relationships :)
02:00 gmcharlt are they wonderful things?
02:00 then rerun rebuild_zebra
02:00 chobbs indeed
02:00 wilco
02:01 and thanks to screen, I can shut down my computer and head home. Really appreciate the help!
02:04 gmcharlt you're welcome
02:05 chobbs left #koha
02:07 brendan my $dbh = C4::Context->dbh;
02:07 oh man sorry wrong window :)
02:07 gmcharlt it's *my* $dbh, I tell you
02:08 * brendan hits head on wall
02:08 brendan poor wall
02:18 chris_n hehe
02:18 it's Friday eve, brendan ;)
02:18 brendan heh
02:19 chris_n but it sure looks as though you have a handle on things... especially the db
02:19 * brendan feels like my head is stuck in this loop
02:19 gmcharlt time to unroll the loop and do something else for a bit
02:20 brendan not sure all I can think about is MFHD_ITEM etc.
03:33 Amit_G joined #koha
03:33 Amit_G heya brendan
03:34 eythian left #koha
03:34 brendan heya Amit_G
03:44 chobbs joined #koha
03:45 chobbs gmcharlt:  Rrbuild went smoothly this time. Thanks again!
04:11 richard left #koha
04:15 johnindy_ joined #koha
04:20 brendan success
04:24 johnindy left #koha
04:49 Nouman joined #koha
04:52 Nouman zebra process is not running
04:52 http://pastebin.org/101498
04:57 Ropuch left #koha
04:58 Nouman left #koha
04:58 Ropuch joined #koha
05:16 Nouman joined #koha
05:17 Nouman Ropouch r u there?
05:19 http://pastebin.org/101498
05:19 could any body help me?
05:22 Amit_G left #koha
05:25 Nouman left #koha
05:29 Nouman joined #koha
05:29 Nouman could any body help me?
05:31 masonj Nouman: you have another zebrasrv already running, i think
05:31 Nouman Masonj: I am doing fresh installation, I have delete previous one
05:31 masonj $ killall zebrasrv
05:32 $ ps -ef|grep zebrasrv
05:33 make sure no other zebrasrv is running, before you start a new zebrasrv
05:33 Nouman I have applied these both
05:33 masonj '13:49:31-03/03 [fatal] Failed to bind to unix:/var/run/koha/zebradb/authoritysocket [File exists]'
05:33 cool
05:34 now start zebrasrv....
05:34 Nouman o/p is http://pastebin.org/101510
05:34 Mansonj: Im installing koha-3.00.05 on debian-lenny
05:35 masonj u didnt kill zebra
05:35 Nouman there are two options to start zebra, which one should I select
05:35 masonj # kill 3160
05:35 chobbs left #koha
05:36 masonj zebrasrv -f /etc/koha/koha-conf.xml
05:36 starts zebra ;)
05:37 Amit_G joined #koha
05:38 Nouman Masonj: http://pastebin.org/101512
05:38 Amit_G heya Nouman
05:39 masonj # kill -9 3160
05:39 still  didnt kill it :/
05:39 Amit_G heya masonj
05:39 masonj hiya amit
05:41 Nouman Masonj: is zebra now running  or not
05:42 ?
05:42 masonj on your box?, i dont know :)
05:43 Nouman ps -ef|grep zebrasrv root      3429  3413  0 14:40 pts/0    00:00:00 grep zebrasrv
05:43 masonj no, its not running - on your box
05:43 Nouman I dont recognize that whether zebra is running or not o/p is here
05:44 kill -9 3160 lumhs-b70715be2:/home/nouman# ps -ef|grep zebrasrv root      3429  3413  0 14:40 pts/0    00:00:00 grep zebrasrv
05:44 masonj .
05:44 koha      3160  3128  0 13:49 pts/0    00:00:00 zebrasrv -f /etc/koha/koha-conf.xml
05:44 Nouman Hey Amit
05:44 masonj .
05:45 that shows that a zebrasrv process is running (id=3160)
05:45 so.... start up a zebrasrv ;)
05:45 Nouman Masonj: Im not getting what is its mean?
05:47 masonj hmmm, i gotta go soon... :/
05:47 Nouman http://pastebin.org/101516   is it runnig or not
05:48 Amit_G Nouman: not running your zebra
05:48 Nouman Amit_G: thanks. plz could u with me as I can complete installation
05:48 masonj no, its not running - on your box
05:49 Nouman ok should I give commands now
05:50 Amit_G Noumna: r u on which OS
05:50 Nouman Im installing koha-3.00.05 on  debian-lenny
05:50 still show same problem http://pastebin.org/101518
05:52 masonj stop zebra, again.... then..
05:53 EXPORT KOHA_CONF="/home/koha/koha3-pr​od/etc/koha-confxxxxxxx.xml";
05:53 EXPORT PERL5LIB='/home/koha/git/koha3-prodxxxxxx'
05:54 $ sudo zebrasrv -f /etc/koha/koha-conf.xm
05:54 l
05:54 try running zebasrv as root, not koha user
05:55 now i go.... bye
05:56 Nouman left #koha
05:58 Nouman joined #koha
05:59 Nouman he is the http://pastebin.org/101521
05:59 zebra is running or not could any body tell me? if it is running, how can I stop it?
06:02 Amit_G Nouman: Your zebra is running
06:04 indradg left #koha
06:04 davi joined #koha
06:05 Nouman left #koha
06:06 Amit_G heya davi
06:12 davi hi Amit_G
06:12 How is it going?
06:12 Nouman joined #koha
06:13 Nouman ps -ef|grep zebrasrvroot      3573  3413  0 15:10 pts/0    00:00:00 grep zebrasrv
06:14 Amit: is it stop now? if it stop then what should I go to complete the installation
06:19 schuster left #koha
06:25 Nouman left #koha
06:25 Nouman joined #koha
06:27 Nouman I need some help regarding zebra initilization
06:27 could any one help me
06:31 nouman@lumhs-b70715be2:/usr/share/koha/bin$ sudo -u $KOHA misc/bin/zebraqueue_daemon.pl sudo: no passwd entry for misc/bin/zebraqueue_daemon.pl!
06:31 I have above problem
06:33 is any body there?
06:38 Nouman left #koha
06:39 Nouman joined #koha
06:41 Nouman ..
06:41 nouman@lumhs-b70715be2:~/koha-3.00.05$ sudo -u $KOHA misc/bin/zebraqueue_daemon.pl sudo: no passwd entry for misc/bin/zebraqueue_daemon.pl!
06:41 I have above problem
06:47 Nouman left #koha
07:08 braedon|home left #koha
07:09 Ropuch Morning #koha
07:15 Nouman joined #koha
07:24 Nouman Ropuch r u there?
07:24 could u help me
07:26 Ropuch Hello Nouman
07:27 What's the problem?
07:32 nicomo joined #koha
07:34 Nouman Ropuch:
07:34 nouman@lumhs-b70715be2:~/koha-3.00.05$ sudo -u $KOHA misc/bin/zebraqueue_daemon.pl sudo: no passwd entry for misc/bin/zebraqueue_daemon.pl!
07:34 this is the problem
07:36 Ropuch ok
07:36 First thing: $KOHA is variable rather than value
07:37 Nouman so what should I do
07:37 Ropuch sudo -u koha misc/bin/./zebraqueue_daemon.pl
07:38 francharb joined #koha
07:38 Nouman no it is not working
07:39 Ropuch What does it say?
07:39 Nouman http://pastebin.org/101550
07:40 Ropuch You have koha up and running?
07:41 Nouman mean? Im not getting
07:41 Ropuch You installed koha?
07:41 Nouman yeah, koha-3.00.04_fixed was installed on this pc
07:42 Ropuch No, that's not what I mean
07:42 Have you finished your 3.00.05 instaltion?
07:42 Nouman I remove it and installing
07:42 no Im still in step 5
07:43 when I want to install
07:43 http://<servername>:8080/
07:43 it is not installing
07:43 laurence joined #koha
07:44 Ropuch You've followed all steps?
07:44 Nouman Yeah, I followed each and every step
07:44 exactly
07:44 Ropuch Ok
07:44 mysql -u root -p
07:45 I have an idea what could be wrong
07:45 Nouman Now Im at MYsql>
07:45 Ropuch Ok
07:45 create database koha;
07:45 paul_p joined #koha
07:46 Nouman I have created already
07:46 Ropuch grant all on koha.* to 'kohaadmin'@'localhost' idetified by 'katikoan'
07:47 paul_p hello #koha
07:47 Ropuch Just add ; at the end of line
07:48 Hello paul_p
07:49 Nouman I have done it already
07:49 when I want to run koha installer
07:49 it show http://pastebin.org/101552
07:50 Ropuch Hm
07:51 grep VirtualHost /etc/apache2/sites-enabled/koha
07:53 Nouman http://pastebin.org/101553
07:55 Ropuch Hm. can you try http://121.52.186.197:8080
07:55 Nouman yeah Im trying this
07:55 it show
07:55 Not Found  The requested URL / was not found on this server. Apache/2.2.9 (Debian) Server at 10.1.2.36 Port 8080
07:56 Ropuch http://10.1.2.36:8080
07:56 Nouman I tried this also but it is also not working, it also show the same prolem
07:57 Ropuch It's odd
07:58 Can you replace VirtualHost 121.52.186.197 with VirtualHost 127.0.1.1
07:59 In /etc/apache2/sites-available/koha
07:59 Nouman My pc is on netting
08:00 Ropuch I'm not sure I understand
08:00 Nouman actual ip outiside this system is 121.52.186.197 but on my pc it is 10.1.2.36
08:00 Ropuch Oh
08:00 Nevermind
08:01 Nouman through same configuration, some one have installed koha on this pc
08:01 but when I tried to remove and install again 3.00.05 it show this problem
08:02 Ropuch What koha version was installed earlier?
08:02 Nouman 3.00.04_fixed
08:02 Ropuch And it was working, right?
08:03 Nouman all was right but catalgue search from my own system was not working even after completing fast index
08:03 but search from z39.50 was working
08:04 Ropuch Nouman: you're installing koha for testing,m right? The opac don't need to be accesible from outside?
08:04 magnus joined #koha
08:05 Nouman No I want to deploy koha in my organization..
08:05 opac as well as intranet search was not working even books were added. while z39.50 was workin. I have imported books via z39.50
08:07 I replace pwd 12 instead of katikoan of mysql
08:07 is it my mistake ot it is alright.
08:07 Ropuch It's ok
08:08 I was sure you're doing insytall for test only
08:08 And inthat case leaving default is better idea for troubleshoting
08:08 And avoiding troubles in general
08:09 Actually i strongly advice you to do local koha install, test it
08:09 And then tune it to your need
08:10 Problem with The requested URL / was not found... is not koha-related
08:12 Nouman Yeah! I kept each and every thing by default.
08:12 What should I do now
08:18 Ropuch I'm just average koha user, not apache expert
08:18 Nouman ok
08:18 Ropuch You replace VirtualHost 121.52.186.197 with VirtualHost 10.1.2.36
08:19 And have koha locally untill you'll figure out how to fix apache problem
08:20 Nouman locally? Im not getting
08:20 I installed at localhost
08:22 brendan left #koha
08:22 Ropuch I mean: you can have working koha that will be anly accesible from local machnes (within 10.1.* network)
08:22 You can add some record, configure it
08:23 And by the time you decide it's time to go live, I'm sure you'l find the way to fix apache issues
08:26 Nouman but koha is not running
08:26 so how can I add and configure records
08:28 Ropuch Set VirtualHost to 10.1.2.36, restart apache and try http://10.1.2.36:8080
08:30 brendan joined #koha
08:31 Ropuch Hi brendan
08:32 brendan hi Ropuch
08:34 Nouman could any body help me  about apache server
08:34 I have problem
08:41 when I want to run koha installer or local host at my browser it show
08:41 http://pastebin.org/101592
08:42 plz assist me
08:55 Nouman left #koha
09:09 Nouman joined #koha
09:09 Nouman left #koha
09:10 Nouman joined #koha
09:20 Nouman I have some problem could any one one tell me
09:20 when I want to run koha installer or local host at my browser it show
09:20 http://pastebin.org/101592
09:21 plz solve my issue
09:27 slef Nouman: your apache is misconfigured.  Check /var/log/apache2/error.log
09:27 also make sure the "apache2ctl -S" output lists koha-httpd.conf
09:28 I'll just check whether the INSTALL.debian-lenny is correct
09:29 So I assume you finished step "4. Configure and start Apache".
09:31 Nouman Slef: it show File does not exist: /htdocs
09:34 slef Nouman: Could you run "grep ServerName /etc/koha-httpd.conf" please?
09:35 Ropuch Hi slef
09:36 Nouman slef: it show grep 121.52.156.200 /etc/koha-httpd.conf grep: /etc/koha-httpd.conf: No such file or directory
09:38 I need help
09:39 slef Nouman: want to give me access to your computer?
09:39 you can watch over my shoulder
09:39 (or boot me out, as you like)
09:39 if your connection is reasonably high-speed
09:40 Oh my mistake!
09:40 grep ServerName /etc/koha/koha-httpd.conf
09:40 it moved
09:40 retry with that command
09:40 hi Ropuch
09:40 Ropuch ;>
09:41 Nouman slef: how can I give u acces to my computer in debian-lenny.. I dont know the way. tell me as  I can give u access
09:41 Ropuch slef: Nouman seems to be behind NAT
09:41 slef Nouman: try the grep command above first
09:41 Ropuch: it won't stop me.
09:42 Ropuch heheh
09:42 slef Ropuch: everyone is behind NAT, even me.
09:43 Nouman I have given. it did not show any output just happen
09:44 Ropuch slef: it's just easier to explain someone to install ssh server, taht's what I meant
09:44 ;>
09:44 Ok, bbiab
09:47 Nouman http://pastebin.org/101608
09:47 slef Nouman: ok, I'll send you connection details in private
09:47 erm, that is output
09:47 Nouman ok
09:48 output... mean?
09:48 slef OK, have you visited http://lumhs-b70715be2:8080/ ?
09:48 Nouman no
09:48 slef try that - that is where your Koha is installed
09:49 whether or not it can hear you - different question :-/
09:49 Nouman Im not getting what r u saying
09:49 koha was installed last time
09:50 slef Visit http://lumhs-b70715be2:8080/ and Koha may appear.
09:50 Nouman but now i removed and now trying to install koha it is now showing
09:51 When I want to put servername:8080 or localhost it show the problem
09:51 slef That is because Koha is listening at lumhs-b70715be2:8080, not servername:8080 or localhost.
09:51 Nouman I removed apache2 and installed it again but change
09:51 slef Removing apache2 will not change where Koha is listening.
09:52 Can you put the output of "apache2ctl -S" into pastebin, please?
09:53 Nouman http://pastebin.org/101614
09:54 slef What happens when you visit http://lumhs-b70715be2:8080/ ?
09:54 Nouman it show networki time out
09:55 http://pastebin.org/101616
09:56 I was accessing koha in past as http://10.1.2.36:8080
09:56 I just removed koha and starting fresh installation
09:57 after that it show this problem
09:57 slef OK
09:57 Open the file /etc/koha/koha-httpd.conf
09:58 below each ServerName line, add
09:58 ServerAlias 10.1.2.36
09:58 then save and exit, /etc/init.d/apache2 reload
09:58 then retry
09:58 What was happening was that Koha is only listening on an address that does not work.
09:59 The installer autodetected the address that does not work because your local DNS configuration is slightly broken.
09:59 Nouman http://pastebin.org/101617
09:59 this is the already connection
10:00 slef Not enough to break most things, but enough to break autodetection.
10:00 OK, that is interesting.
10:00 Nouman is it right or not?
10:00 slef I think its address is http://121.52.186.197:8080/
10:00 Try changing line 6 to say
10:00 <VirtualHost *:80>
10:01 and the similar line later on to say
10:01 Nouman My computer is on netting by Network administrator
10:01 slef <VirtualHost *:8080>
10:01 then save&exit, then /etc/init.d/apache2 reload
10:01 Nouman from my computer and network it will be accessed 10.1.2.36 while outside it will be accessed 121.52
10:03 slef so you need to have * in the VirtualHost lines I think
10:03 to listen on multiple addresses
10:04 I think most servers don't need that, so it isn't the default
10:04 Nouman should I write this way <VirtualHost 121.52.186.197*:8080>
10:06 or <VirtualHost *:80> only
10:09 slef <VirtualHost *:80> only
10:17 Nouman slef How can I save file
10:17 I have open this via vi
10:17 slef ZZ
10:17 (shift-z twice)
10:23 Nouman slef: I cant do it
10:24 when I try to do vi  /etc/koha/koha-httpd.conf
10:24 slef why not?
10:24 Nouman it is opening  but When I want to edit there become error
10:24 editing is not happeing
10:25 gedit also open the file but it cant save
10:26 shift+z twice is not saving the file
10:26 I think it is read only file and changes could not be happeing
10:31 changes are  not saving
10:34 slef yes, you maybe need to "sudo vi /etc..."
10:34 Nouman even I type to localhost  it show same msg
10:39 slef: I have changed but still show message
10:40 slef what is exact message?
10:41 Nouman http://pastebin.org/101631
10:41 on top of browser it show 404 not found
10:47 slef: r u ther?
11:01 slef back
11:01 ah, you mean you saved the file?
11:01 Did you /etc/init.d/apache2 reload ?
11:05 Amit_G heya slef
11:07 Nouman left #koha
11:10 slef Amit_G: hi
11:16 Nouman joined #koha
11:16 Nouman slef: it show error
11:17 magnus am i overdue for a bit of lunch or does http://koha-community.org/tarb[…]ha-3-2-available/ imply that http://git.koha.org/cgi-bin/gi[…]ranslator;hb=HEAD is missing a script called install-code.pl?
11:19 Nouman Slef It now show another error
11:19 http://pastebin.org/101644
11:20 slef magnus: it is in http://git.koha.org/cgi-bin/gi[…]7eb20ee5a7b7be130
11:20 Nouman: can you try mysql -u kohaadmin -p koha with the password you gave the installer?
11:21 saorge joined #koha
11:21 Nouman No I have give different password to installer and give here different
11:21 bz same password is not working
11:21 slef Nouman: if that fails, then you need to repeat step "2.2 Create the Koha database"
11:25 magnus slef: thanks, definitely time for lunch then...
11:26 Nouman Slef: I already create this  but password to mysql -u kohaadmin -p is changed with the installer
11:27 so is it necessary to keep same password as I given default in Makefile.PL
11:27 while  '12' in katikoan
11:27 sorry '12' in mysql
11:27 what should I do now
11:28 saorge_ left #koha
11:29 slef You could edit /etc/koha/koha-conf.xml to include the new password.
11:32 Nouman Slef: couple of thanks.. installation is in working.
11:32 I cant explain my feeling
11:32 Slef: lot of thanks again
11:33 slef It's OK.  I do this stuff all the time for software.coop
11:33 usually rather quicker than 3 hours ;-)
11:33 but then people need to pay the co-op.
11:34 Nouman IM engaging koha since last 3 months
11:34 Actually since last 6 months
11:34 Ropuch Nouman: you should have try irc earlier ;>
11:35 Nouman Yeah offcourse
11:35 what a tremendous acheivement.....
11:35 Ropuch Glad to hear you have your Koha :)
11:35 Nouman Thanks Ropuch
11:36 one error is still there so should I skip it or fix it
11:36 http://pastebin.org/101648
11:37 slef That looks to me like $KOHA is not set.
11:37 try replacing it with the name of your koha system user account
11:38 Nouman I kept every thing default so what should be my koha system user a/c
11:40 Nouman left #koha
11:40 Nouamn joined #koha
11:41 slef checking INSTALL
11:41 Nouamn mean?
11:42 Amit_G left #koha
11:42 slef "it's also recommended that you create a Koha system user, which you will have specified during the install process."
11:42 So I think it was up to you.
11:43 Nouamn Im not getting
11:43 if i write su koha  then it show koha@lumhs-b70715be2:/home/nouman$
11:43 u mean it?
11:44 Im not getting ur point
11:47 Slef: r u there?
11:47 Im in so hurry to populate web installer
11:48 slef I think that means: sudo -u koha misc/...
11:51 Nouamn it also show same message
11:51 I tried it also several times
11:56 Slef: r u there?
11:56 and should I continue installation without it or first I must fix it
12:01 04Ropuch01
12:01 r u there?
12:03 nengard joined #koha
12:03 Ropuch Nouamn: try
12:03 sudo -u koha misc/bin/zebraqueue_daemon.pl &
12:03 Hello nengard
12:03 nengard hiya
12:05 Nouamn Ropuch: its output show
12:05 [1] 6724
12:05 mean it is working? should I go for installation
12:06 Ropuch ps a | grep zebra
12:06 If ist shows line with /usr/bin/perl misc/bin/zebraqueue_daemon.pl
12:06 slef There is no way it will show the same message
12:06 "[1] 6724" just means it went into the background
12:07 ps 6724 to see its details
12:09 Nouamn it is hanged message is below
12:09 sudo -u koha misc/bin/zebraqueue_daemon.pl & [1] 6754 nouman@lumhs-b70715be2:~$ sudo: misc/bin/zebraqueue_daemon.pl: command not found
12:09 and it is still in process
12:11 http://pastebin.org/101654
12:11 is it successful or not?
12:13 04Ropuch
12:13 ??
12:16 slef Hi.  I'm stopping answering here because it's all being sent to the email list anyway.  BBL.
12:17 Nouamn Slef: plz solve this problem as I can go with installation
12:21 Ropuch: plz check it http://pastebin.org/101658
12:34 jwagner joined #koha
12:34 Nouamn left #koha
12:42 collum joined #koha
12:46 Nouman joined #koha
12:47 jdavidb joined #koha
12:47 Nouman http://pastebin.org/101658
12:48 plz solve my problem
12:48 Nate joined #koha
12:52 slef Your problem is that your database is not installed.
12:52 Have you run the web installer?
12:53 "Note: if you are running in this mode, you may wish to defer starting the
12:53 zebraqueue until you've run the web installer (see below)."
12:54 Nouman left #koha
12:58 NOuman joined #koha
12:58 NOuman But database is already exist when I want to create it show already exist
13:00 juan-xercode left #koha
13:02 slef But there is nothing in it
13:02 You need to run the web installer to put things in it.
13:04 nengard: please don't post just to agree with your boss :-(
13:04 nengard slef - he's not my boss
13:04 slef nengard: I thought you worked for both biblibre and bywater?
13:05 nengard i'm an independant contractor who works for several companies and several libraries and several individuals
13:05 my primary company is bywater
13:05 and so my boss is brendan
13:06 and yes bywater has a deal with biblibre and i do work for them
13:06 and bywater has a contract with equinox and i do work for them
13:06 and bywater has a contract with ptfs and i do work for them
13:07 slef but you have no contract with software.coop, so I'm unhappy you take sides without making your affiliation(s) clear.
13:07 Ropuch :)
13:07 nengard i'm not taking any sides
13:07 that is my own opinion
13:07 i enjoy seeing which companies are doing what with which libraries
13:07 am i not allowed to have my own opinion because i work for a company?
13:08 slef You are allowed to have an opinion, but I think it is naughty to +1 someone you have a commercial relationship with when that isn't obvious to the most causal observer.
13:09 nengard oh please!!!
13:09 slef Why does seeing which companies are doing what with which libraries mean that it should be reposted to koha-community.org and not simply linked?
13:09 I don't see that at all.
13:10 I also don't understand why I'm locked out of koha-community.org, but I want time to try to regain access and/or talk to wizzyrea before getting too upset with that.
13:11 (In case anyone else can look: I got "ERROR: Incorrect password" and I've tried the "Lost your password" but it hasn't arrived.)
13:11 nengard just cause you don't agree doesn't mean you can just assume we all have anterior motives - promoting that libraries are switching to Koha is necessary to further the popularity of Koha - and if that means having the library linked to a vendor so be it - i read these releases way before i worked for any support vendor and i know many libraries that do - it's koha news as much as it's vendor news
13:11 and on that note i'm going to stop this discussion cause i've had one hell of a week and i'm not in the mood to fight with anyone else
13:12 nengard left #koha
13:12 gmcharlt slef: I'll reset your password and pm you
13:13 slef gmcharlt: thanks.
13:14 On the context: I think nengard has a clear conflict of interest as several of us do, but new readers would not know that.
13:15 On the substance: I think that company X has persuaded company Y to sign a contract for koha is more often news about how persuasive the vendor sales team is and does not say much about koha.
13:16 I'm a bit unhappy if koha-community.org becomes simply like koha.org but shared between more companies than liblime.
13:16 gmcharlt thought the PRs do give users one piece of information when they're evaluating vendors - customers of that vendor who have not necessarily been vetted by the future as "good references"
13:18 davi They can evaluate vendors by other methods
13:19 gmcharlt doesn't mean that any possible source of information should be removed
13:20 slef How would a link to the announcement on a company site not acheive the same?
13:21 gmcharlt slef: I apologize - WP-MU is fighting with me on getting your password reset - I'm sure wizzyrea will help once she's online
13:22 also, it's possible the email got caught up in a spam filter
13:22 slef gmcharlt: thanks for trying.
13:22 Nate slef: this is Nate from ByWater...
13:22 slef Yes, I keep strumming the mailbox to make sure, but it's coming into one that I don't control 100%.
13:22 Nate we in no way intend our prs to be proclimations of who we sign
13:23 we dont say X signed Y
13:23 we say Y is using X to get Koha
13:23 we title the release that way to avoid that
13:23 if it is taken another way we apologise
13:24 davi Just say "Y is using Koha"
13:24 if you want
13:24 slef Point remains - if it has "is using X" then it should be on your site and linked, not reposted.
13:24 Nate until the community has decided which way to post releases we will hold them
13:25 we will wait for the community at large to decide which semantics are appropriate adn proceed from theere
13:25 we in no way intend on making this a big issue, and will do whatever we all decide is appropriate
13:26 ByWater does not look at teh community site as a way to promote our company.
13:26 slef ok, but I'm not convinced that neutral point of view will prevail because I think most of koha-community are still vendor-linked, so it may need some very persuasive brass-necked people :-/
13:26 Nate If the community decides that it is appropriate to use it as such an outlet, we will graciously accept, otherwise we will refrain
13:27 slef Nate: on a related note, do you have a social media policy for your workers?
13:28 Nate I can get back to you on that
13:28 slef ok, np
13:28 NOuman left #koha
13:30 slef Mainly I wondered if you always have a sig like Brendan's if it's on company time, or if that is only the directors.
13:30 no worries
13:31 ebegin left #koha
13:31 slef munin: do you ever tell people the later messages?
13:31 munin slef: Error: "do" is not a valid command.
13:31 slef munin: hello
13:31 munin slef: Error: "hello" is not a valid command.
13:32 slef hmm
13:32 owen joined #koha
13:32 jdavidb Mornin'. owen.
13:32 owen Hi
13:33 jwagner Hi owen.
13:35 tekonivel left #koha
13:36 tekonivel joined #koha
13:36 slef hi owen - I think I'm having interesting times again :-/
13:36 owen Victim of a Chinese curse?
13:36 slef seem to be
13:42 gmcharlt: I think http://koha-community.org/ knows that I want to try to change its title to something like "Koha Library Software Community" and that is why it is resisting - it's gone Artificially Intelligent ;-)
13:43 gmcharlt aye, the problem of the days - turn your back for a second, and your software starts racing towards the Singularity
13:43 slef (we call Koha an LMS more than an ILS, and we call it free software not open source)
13:43 gmcharlt: in 12 minutes time, it will invent Skynet.
13:43 adegroff joined #koha
13:44 slef biab
13:56 chris_n well, the scroll back buffer is hot this morning ;-)
13:56 adegroff happy Friday all
13:59 biglego left #koha
14:05 jwagner @wunder 20740
14:05 munin jwagner: The current temperature in Hollywood, College Park, Maryland is 3.8�C (9:04 AM EST on March 05, 2010). Conditions: Mostly Cloudy. Humidity: 49%. Dew Point: -6.0�C. Windchill: 1.0�C. Pressure: 30.03 in 1016.8 hPa (Rising).
14:10 jwagner @quote random
14:10 munin jwagner: Quote #47: "pianohacker bah, go collision attack the front of a moving car" (added by brendan at 05:15 PM, November 16, 2009)
14:10 magnus ouch
14:11 jdavidb @quote random
14:11 munin jdavidb: Quote #52: "<wizzyrea> Ahh, it's like putting on your slippers" (added by gmcharlt at 03:50 PM, January 28, 2010)
14:15 chris_n @wunder 28334
14:15 munin chris_n: The current temperature in Erwin, North Carolina is 2.0�C (8:42 AM EST on March 05, 2010). Conditions: Clear. Humidity: 52%. Dew Point: -7.0�C. Windchill: -1.0�C. Pressure: 30.09 in 1019 hPa (Rising).
14:22 chris_n does the catalog search in the staff interface not rank results by relevancy?
14:22 or rather
14:22 it says it does, but does not appear to?
14:27 adegroff left #koha
14:27 CGI149 joined #koha
14:28 CGI149 hello
14:28 CGI149 left #koha
14:30 owen chris_n: A bug was filed recently about search results being different in the staff client
14:30 magnus chris_n: i get the results in the same order both in opac and staff (running HEAD)
14:30 owen I wonder if it's the same issue
14:32 magnus bug 4116
14:32 munin 04Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=4116 critical, P5, ---, henridamien@koha-fr.org, ASSIGNED, results from cataloging search is different from advanced search results
14:33 owen Oh, no, I guess that's different.
14:33 Cataloging search has always been different than regular search
14:34 chris_n it appears that if I search for "An Exact Title" and I have an item by that title, it appears near the bottom of the list rather than the top
14:36 owen title or keyword search?
14:36 chris_n http://tinypic.com/view.php?pic=2j0edl5&s=6
14:37 keyword
14:37 but it still should rank at the top
14:37 I'd think
14:37 http://i45.tinypic.com/2j0edl5.jpg # less clutter
14:39 owen: same ranking search both by title and keyword
14:40 owen I get a similar result, which I can't even explain by pointing to additional keyword hits in subject or notes fields
14:41 * chris_n wonders if the ranking algorithm is sorting backwards
14:41 chris_n try a title search
14:42 of course, if it is like most "problems," I'm simply missing the obvious ;)
14:43 owen What do you mean?
14:44 chris_n owen: the problem I'm seeing occurs when searching by title as well
14:45 hence, my thought that maybe the sorting is backwards (ie. from least relevant to most relevant)
14:46 wizzyrea slef: it won't become like koha.org if I can avoid it
14:47 chris_n can anyone else running 3.01.00.120 or greater confirm the problem with relevance ranking?
14:48 g'morning wizzyrea
14:48 wizzyrea morning koha peeps
14:48 chris_n how's the battle with the docbook format going?
14:51 slef wizzyrea: yo! Any idea what's with the password resetter? I'll go check my mailbox again.
14:52 wizzyrea I can't put any SPF records for the domain on until the DNS situation is resolved :(
14:52 so it's likely getting flagged/dumped as spam
14:54 slef I'm pretty sure we don't use SPF, which is broken by design.
14:54 wizzyrea oh, and there's no reverse DNS
14:55 yet
14:56 which is probably the more problematic situation of the two
14:57 slef That's more likely a problem, yes.
14:58 owen chris_n: http://screencast.com/t/MTcwYTZm
15:00 chris_n: And the title search: http://screencast.com/t/NzBlMjQ3NTA
15:05 chris_n hmm
15:05 it appears to be an issue with the one title I mentioned
15:05 other titles appear to sort correctly
15:06 * chris_n scratches his head
15:06 slef Do I need to ask on the mailing list or at a community meeting about fixing the koha-community.org site name?
15:07 Or how best to approach it?
15:07 wizzyrea what do you want it to be?
15:07 slef I was trying to come up with a globally-acceptable one... my best so far is "Koha Library Software Community"
15:07 owen I think it needs a discussion and a vote.
15:08 slef If it gets taken to a first-past-the-post vote, the US view will simply outnumber all.
15:09 wizzyrea well I actually like your suggestion, fwiw
15:09 not a great deal of brain cycles went into the current title
15:09 great number*
15:09 slef Well, I'll email it and we'll see, but I expect some flaming because we're unhappy about "open source" and "ILS" again.
15:10 as in "there's nothing wrong with open source" which isn't a discussion I enjoy having, as someone who was involved with the Open Source Initiative before it failed ;-)
15:10 having one's nose rubbed in one's mess is never fun
15:10 wizzyrea hehe
15:11 my thought is: it's so new, if we change it... no one will care.
15:11 the software is Koha, we are it's community
15:11 we can say it's free software and and ILS somewhere else
15:12 * wizzyrea is a beg forgiveness rather than ask permission type
15:12 collum I like your suggestion, as well.  I think the terms "open source" and "ILS" will eventually become dated.
15:12 slef let me post a "does anyone mind..." sort of thing then
15:12 wizzyrea there was literally no thought involved in titling the page
15:12 gmcharlt +1 "Koha Library Software Community"
15:13 wizzyrea nah I say don't even ask we'll just change it and ask forgiveness
15:13 if someone complains
15:13 (which I don't anticipate)
15:13 CGI133 joined #koha
15:13 CGI133 left #koha
15:13 * owen will not complain
15:13 gmcharlt +1 to just making that change
15:14 wizzyrea done and done
15:14 tomascohen hi, is there a consensus between koha devs
15:14 on how to deal with XML within the project?
15:15 I've made some examples for patron import
15:15 using XML::Simple
15:15 tekonivel left #koha
15:15 tomascohen and, before integrating it to koha, i'd like to ask
15:16 perhaps XML::SAX is more suitable for large data sets
15:16 ideas? thoughts?
15:16 gmcharlt Koha uses XML::Simple in several places, but I have a slight allergy to it
15:16 owen wizzyrea: Did you see the unapi example I msged you the other day?
15:17 tomascohen nope
15:17 wizzyrea: no
15:18 wizzyrea yes I did
15:18 tomascohen: ?
15:18 tomascohen gmcharlt: You prefer not to use a DOM based lib?
15:18 wizzyrea: sory, it was a mistake, not a good IRC user yet
15:18 wizzyrea oh ;) np np
15:19 tomascohen: we were talking about things that were ever so slightly controversial earlier, I thought you might be voicing an opinion ^.^
15:20 gmcharlt tomascohen: didn't say that - it's more that XML::Simple can sometimes need an undue amount of fiddling to produce a consistent data structure that doesn't break on certain legal variations in the input
15:21 XML::LibXML or XML::SAX I think would be better for heavy-duty parsing
15:21 and I think it would be worth trying XML::Twig
15:22 tomascohen gmcharlt: as we provide a example csv, I plan to provide a proper xsd for checking xml consistency and help other apps devs to test their output
15:25 magnus wizzyrea: http://koha-community.org/hello-world/ still says "open source" and "ils"...
15:25 wizzyrea um... yes, it does
15:25 gmcharlt and now it doesn't
15:26 magnus great!
15:27 tomascohen wizzyrea: anything that contributes to integrate the community efforts will have my support
15:28 that was our goal when creating the spanish-speaking koha community
15:31 magnus is now known as magnus_away
15:38 paul_p hi world
15:38 moodaepo @wunder 56001
15:38 munin moodaepo: The current temperature in South on Monks, Mankato, Minnesota is -0.6�C (9:36 AM CST on March 05, 2010). Conditions: Clear. Humidity: 64%. Dew Point: -6.0�C. Windchill: -5.0�C. Pressure: 30.26 in 1024.6 hPa (Falling).
15:38 paul_p does anyone know how you could configure mysql to avoid a sql query taking all ressources ?
15:40 collum left #koha
15:40 moodaepo paul_p: maybe by user is the only option?
15:41 paul_p what i'm looking for is avoiding a mySQL crash if someone does something silly like "SELECT * FROM biblio JOIN items" in the SQL reports
15:41 atm, if you do that, mysql builds a result set that is biblio*items large.
15:42 on a 180 000items DB, that means consume more than 8GB of data, and kill the myslq
15:42 (tested yesterday :\ )
15:42 wizzyrea oh my
15:42 moodaepo I'd look into setting a decent query timeout (?)
15:43 wizzyrea http://www.google.com/#q=koha&hl=en&fp=1
15:43 is it #2 for anyone else?
15:43 (the title hasn't been spidered yet, don't freak)
15:43 paul_p wizzyrea: nop, for me it's the last entry of page 1
15:43 gmcharlt #9 for me
15:44 moodaepo wizzyrea: seems to be #4 for me on that link.
15:44 wizzyrea how weird
15:44 owen #7 for me
15:44 moodaepo we are talking about koha-community right?
15:44 wizzyrea yea
15:44 signed into google?
15:44 or no?
15:44 (maybe it's some magic of weighting searches based on your history)
15:44 paul_p signed, it's 1st, as I "upped" it.
15:44 * moodaepo heh koha hockey is #2
15:44 * owen is happy to see my Koha blog beating liblime.com in that list :P
15:45 paul_p unsigned, it's last entry of page 1
15:46 moodaepo paul_p: max_execution_time and memory_limit might be something to check for you
15:46 wizzyrea unsigned in on mine it's #2
15:46 paul_p owen: for me, you blog isn't on page 1 (sorry for that)
15:46 gmcharlt #9 if I do it via lynx and reject Google's cookies
15:46 moodaepo unsigned in #5
15:47 tekonivel joined #koha
15:47 wizzyrea welp... so we can say "on the first page"
15:47 gmcharlt seems like it
15:48 wizzyrea I was excited about it showing up #2, now I'm not as excited
15:48 will give the spider a few more days to work... going to check to make sure our links are pointing to the right thing
15:49 chris_n #7 here also
15:51 paul_p moodaepo: /me blind, but can't find "max_execution_time" on mysql doc
15:51 tekonivel left #koha
15:51 tekonivel joined #koha
15:53 moodaepo paul_p: I just had google mention that to me so it could be an older setting
15:54 sql_select_limit then (?) > http://dev.mysql.com/doc/refma[…]em-variables.html
15:55 * owen thinks Google is good at showing me what I want to see
15:55 biglego joined #koha
15:55 schuster joined #koha
15:56 mib_fp8zkg left #koha
15:57 wizzyrea owen: isn't it crazy that they know you so well. Scary.
15:58 moodaepo wizzyrea++ omniscient_google+-?!
16:00 schuster so did my eyes deceive me or did I see that 3.2.beta may be out next week?
16:00 paul_p moodaepo++
16:03 tomascohen gmcharlt: XML::Twig looks great, I like $twig->purge;
16:04 Do u think i'd be ok to put XML::Twig as a dependency?
16:05 gmcharlt not for 3.2, I think, but should be fine for 3.4
16:09 but I'd see great potential for moving more XML processing over to XML::Twig in 3.4
16:17 CGI702 joined #koha
16:17 tekonivel left #koha
16:20 CGI833 joined #koha
16:20 tekonivel joined #koha
16:20 CGI833 hi
16:21 schuster ;)
16:22 CGI702 left #koha
16:25 tekonivel left #koha
16:26 tekonivel joined #koha
16:27 CGI833 does anyone one
16:28 know if it is possible to insert cartography in to koha ?
16:29 slef definitely possible
16:30 wizzyrea: can we install a table sorter plugin on koha-community.org please?  thd suggested it yonks ago and I think I researched it around the time the new site launched.  Let me know if I should dig up links.
16:30 adegroff joined #koha
16:41 wizzyrea we have tables to sort? lol
16:41 j/k, I'll look :)
16:41 owen slef: do you mean for the vendor list?
16:43 wizzyrea actually, I suppose it would be good to know what we need it for
16:43 slef yes
16:43 wizzyrea what if we did something different than table sorting
16:43 can you give me a couple of days to think about the ultimate goal of the support company pages?
16:44 owen Links to different views perhaps?
16:44 wizzyrea I'm thining that a post category + tags would be a better way to handle it
16:44 slef wizzyrea: I think thd-away did a long analysis when new.koha.org launched
16:44 wizzyrea (excluding the cat from the main timeline, of course)
16:45 I will look back through the list for his comments
16:45 * wizzyrea can see a way it could work in her mind
16:46 slef I'll take a look for it in a mo
16:46 wizzyrea okies
16:46 chobbs joined #koha
16:46 * wizzyrea is also working on a quite huge other project today, and is grateful for help :)
16:47 slef me too
16:47 francharb left #koha
16:52 laurence left #koha
16:53 paul_p left #koha
16:54 chobbs Conversion question: what's the appropriate value to put in 952_q to reflect that an item is checked out?
16:54 mib_30qiay joined #koha
16:56 chobbs Or will that become populated when I import into 'issues'?
16:57 biglego left #koha
16:57 slef chobbs: it should be the due date, I think.
16:58 http://koha.org/documentation/[…]ds-data-migration
16:58 I'm not sure what "Display only field" means there.
16:59 chobbs That's what I thought, but it isn't showing them checked out. That may be because I 've not yet imported into the issues table yet - I've only imported MARC records (with 952 fields attached).
16:59 Guess I'll work on loading the issues and see if that clears it up.
17:01 gmcharlt chobbs: you'll need to both load issues and set the 952$q value to the yyyy-mm-dd due date
17:02 you can do the latter by using sql item update items.onloan, then running the sync_items_in_marc.pl script
17:02 chobbs good deal, thanks for the info. at least I know I have the 952$q qorking correctly in my conversion script.
17:02 cool!
17:03 slef wizzyrea: http://old.nabble.com/-Koha-an[…]14.html#a23447686
17:03 wizzyrea sweet ty
17:08 i've already stated that the demos should be handled differently... I'm curious about this map bit, that would be neat to include, and I think the cat/tags would clear up the support company page organization
17:08 localization is another issue, but patience will be required there as I'm new to WP+localization (perfectly happy and willing to learn though)
17:09 as it stands, I'll link to koha-fr.org
17:09 which needs to be done anyway
17:10 slef I don't really see how cat/tags will clear up the support company page organization because there would still be a sort order, wouldn't there?
17:11 wizzyrea mm not necessarily
17:11 every vendor has a post, every post has multiple tags
17:11 click the tags, you get only things relative to that
17:11 so list just the tags, only see the relevant posts
17:12 seewhatimean?
17:12 no sort
17:12 only tags
17:13 slef so we still have someone always top and someone always last?
17:13 cm joined #koha
17:13 wizzyrea I suppose within tags
17:14 but you would have a lot fewer within each tag listing
17:14 slef I think what will happen is the seller listed last on the "view all" would still be last on each tag.
17:15 cm greetings!  has anyone here tinkered with facets?  I've added the collection code to mine, but I can't figure out how to get it to display the description instead of the code.
17:15 wizzyrea I can look into randomizing the order of posts, dk what else to tell you
17:15 slef I think there are basically two good solutions: random and user-sortable.
17:16 I tend to think that user-sortable table and trim down the info on the community site as much as possible (almost all vendors have their own sites anyway) is the better of the two, but if you don't want me to code it, I don't mind it being something else.
17:17 wizzyrea if you have the time and the desire to code it, we can leave that as an option
17:18 * wizzyrea has something tickling her mind about a plugin that handles this kind of thing...
17:18 slef I think I looked up one plugin... I can make a table sortable with javascript, but I can't randomise the starting order or handle non-JS browsers without a plugin IIRC.
17:19 wizzyrea slef: can you give me a few days to think about the vendor page problem? I have a couple of thoughts and I'd rather not go all balls out crazy until I have a chance to think about it a little more :)
17:26 slef wizzyrea: sure.
17:27 wizzyrea: I think you have 85% of the info I have on it now.
17:27 wizzyrea okies cool beans
17:27 slef wizzyrea: but I have no idea what I'm doing tomorrow, so if I don't do this now, I'll probably not get time for a week!
17:51 tomascohen left #koha
18:02 CGI306 joined #koha
18:03 CGI306 hello.. Can anyone tell me How can I find a last borrower of deleted item book
18:03 ebegin joined #koha
18:06 CGI306 hello.. Can anyone tell me How can I find a last borrower of deleted item book
18:08 jdavidb If you still know the barcode, it should be in the statistics log, as an "issue" transaction.
18:08 brendan looking the old_issues tables
18:09 whoops -- misread the questions :)
18:09 CGI306 yes but item no is not present in old
18:09 issues tabe
18:09 I have barcode
18:09 and I want to know the person who had that book last
18:09 From Barcode I got Item number from DeletedItems table
18:10 jdavidb The item number and borrowernumber would be in the statistics table.
18:10 brendan if the item was checked out before and returned -- I'm sure that it should appear in the old_issues
18:10 CGI306 yes it is appearing but Item number is missing
18:10 brendan ahhhh
18:10 CGI306 Let me check the statistic table
18:10 brendan make sense
18:10 hi jdavidb :)
18:11 good day to you
18:11 jdavidb Howdy, brendan! :D  you too.
18:12 wizzyrea slef: still around?
18:16 CGI306 Can I have Same Item number for different ItemType?
18:17 because I am getting the results from statistics table but there are so many records for that.. and none of that have a borrowernumber that I am looking for
18:18 jdavidb W?HERE type = "issue" SORT BY datetime DESC might be useful
18:40 biglego joined #koha
18:43 schuster left #koha
18:47 CGI306 hey guys thanks a lot.. I got the result that I want..
18:47 CGI306 left #koha
18:49 * jdavidb has done his good deed for the day, can safely revert to grumpy-mode.
18:53 chris :)
18:54 biglego left #koha
18:54 jdavidb Howdy, chris. :)
18:55 chris craft2.0 today
18:56 http://craft2.org/
18:56 laurel is selling her tshirts there, so im on kid duty
18:57 jdavidb ooooo...
19:08 slef wizzyrea: yes
19:08 oic
19:38 * owen wonders how the Koha-list poster could be connecting to his virtual machine via ssh but not be able to SFTP
19:38 owen Aren't they the same protocol?
19:40 wizzyrea he could probablty scp
19:41 adegroff left #koha
19:42 gmcharlt owen: same protocol, but it is possible to have a server accept ssh login but not sftp
19:45 slef and the other way around
19:46 the ssh connection starts up and then there is a subsystem requested
19:51 nicomo left #koha
19:57 tekonivel left #koha
19:58 tekonivel joined #koha
20:11 jdavidb left #koha
20:40 CGI833 not the same protocol, sftp is an extension of ssh
20:41 will someone be kind enough to indicate in what way can I associate an image with a new record?
20:42 I can't seem to find any field that allows image upload in the new record interface :P
20:42 owen There isn't.
20:42 What kind of image do you want to add?
20:43 CGI833 regular jpeg ou png... actually a map. the image format would be irrelevant
20:44 owen There's always the 856 tag, you could put in the URL to the location on your server where the image was stored
20:49 CGI833 thanks for the reply :) but the client wants images to be displayed along with the reference info.. since it intends to use it to catalog cartography. So I guess I'll have to search for a new system
20:50 owen It sounds like you want a digital library rather than a library catalog
20:52 CGI833 well.. the client wants a ILMS  that has images ... you know clients... they can't understand why though they can see the sun, they can't reach it :P
20:52 thanks for the help :)
20:53 chris_n CGI833: there is some image storage functionality in Koha
20:53 but not inside marc records
20:53 we store images for patrons
20:53 CGI833 I've read in the manual
20:53 chris_n and also images for patron cards
20:53 CGI833 yes
20:53 but I needed it to be associated with a record
20:54 chris_n the short is this: it might not be hard to take that and do some additional coding to do what you want
20:54 the db could get quite big, however
20:57 CGI833 that woud not be an issue though I truelly would rather not to have the images in the database. If I where to code it, I'd place it somewhere on the web server. they're as public as it gets anyway
20:58 problem is the system is cgi. and i'd have to learn it
20:58 well.. perl
21:01 CGI833 left #koha
21:06 jwagner left #koha
21:09 cm left #koha
21:25 owen left #koha
21:29 magnus_away left #koha
21:39 mib_30qiay left #koha
22:00 chobbs Here's a UI question: in our current ILS, when a patron card is scanned whiel checking out the prior patron, it loads the new patron and you can immediately scan items. How tough would it bne top get similar functionality in Koha?
22:01 * chobbs marvels at his typing...
22:01 chobbs I'm envisioning somethink javascripty that matches a regex for our patron barcodes and submits the proper form if it sees one.
22:03 gmcharlt would be easy to do it exactly like that
22:04 chobbs So when can I get a copy of it ;-)
22:04 gmcharlt can you program in javascripty? ;)
22:05 chobbs Not so much... not to say I couldn't learn (just) enough to figure this one out.
22:06 Assuming I got something hacked toegther, how easy is it to extend Koha so that I could enter the regex through system adminsitration
22:06 gmcharlt fairly straightforward, though a bit fiddling
22:06 chobbs iow, to make something portable enough for others to use
22:06 gmcharlt in the simplest case, you'd make a system preference
22:06 however, since a number of Koha users run multiple libraries in a single database
22:07 chobbs yikes, I see where that leasds :)
22:07 gmcharlt yeah ...
22:07 but if you want to get your feet wet, doing it as a global system preference would be a good start
22:08 chobbs But in theory, I could use a system preference for the regex and somehow incorporate the info from that into a js script and I'm off and running
22:08 Cool, somethign to do this weekend then :)
22:09 brendan wow I don't have a clue what you said or asked up their chobbs
22:10 chobbs btw, did get my issues imported and it looks pretty good. The only oddity is that OPAC shows all items checked out in the search, but the detail for a biblio looks right
22:11 brendan:  imagine a librarian checking out student after student (we're at a school). The way koha works now, they have to mouse to the patron field to process the next kid. What I'm sugegsting is that the item field would have a script attached that recognizes patron cards and lets them scan right into the book field.
22:12 So instead of scan card, scan book, scan book, click in patron field, scan card, scan book - instead they scann card, scan book, scan book, scan card, scan book, scan card, scan book, scan book, etc...
22:12 would elimiate a lot of mousing and clicking
22:13 * chobbs still marvels at his typing. Must be Friday.
22:13 brendan that's how I use the system though?
22:14 i.e you wand the patron card number into checkout spot -- it loads the new borrower...  right?
22:14 chobbs only if the cursor is in the top field on the page. Once that happens, the focus moves to the item field and you have to click back to the top field to wand the next patron.
22:15 my sugegstion allows you to wand the patron card into the item box and it would automatically load the next patron. Right now you get a "The barcode was not found" error if you try that.
22:15 brendan right...
22:15 gmcharlt one barcode input field to find them ...
22:16 * brendan was thinking wrong box....
22:16 chobbs no worries - it's a bit visual to describe in irc :)
22:16 brendan :)
22:16 I think we are on the same page now
22:16 chobbs now i just need to write it :)
22:17 brendan yup would be a nice improvement and greatly appreciated
22:19 chobbs gmcharlt:  any idea why opac would be showing all items checked out? See here for ex: http://koha.nhusd.k12.ca.us/cg[…]orcerer%27s+stone
22:20 brendan gmcharlt - RE: wiki  - how much of the old info are you looking to bring over?  or just assign someone to be responsible for porting a page/section on old wiki --> to new_update_awesome_koha_community wiki...
22:23 gmcharlt chobbs: you may need to reindex
22:23 chobbs i'll give that a shot
22:23 at least it won't blow up with my thousands of adapters again :)
22:24 gmcharlt brendan: I'm neutral on that question, really
22:24 brendan yeah it seems that parts are useful and others...  I could care less about
22:24 gmcharlt I'm happy to bring over old content if we can get a recentish dump
22:25 or reconstruct it from the various crawls that people have been making
22:25 but there's a lot to be said for start with a blank slate and just manually copying over the good bits
22:26 and of course, the answer to that question may well be different for en vs ua vs es vs fr, etc.
22:26 brendan yup, that's the big key there
22:45 collum joined #koha
22:54 collum left #koha
23:11 chobbs Is there any magic for creating authority records from MARC records? This is one area I've not spent much time looking at yet.
23:12 SelfishMan ha, perfect timing since I was about to ask the same thing
23:13 chobbs I'm wondering if I need to build the authority marc file separately as my conversion script loops through my bibliio marcs.
23:13 I don't have any real idea what I'm talking about tho :)
23:15 * chobbs isn't exactly sure what an authority record actually is
23:23 davi left #koha
23:26 tekonivel left #koha
23:26 tekonivel joined #koha
23:44 braedon|home joined #koha

← Previous day | Today | Next day → | Search | Index

koha1