- Koha - lists.katipo.co.nz

Acquisitions Fields
by Nicole Engard 17 Aug '11

17 Aug '11

Can someone tell me what the unitprice, rrp, and ecost fields in the aqorders table are? Which field is for which price field? Thanks Nicole

3 3

Re: Koha shows error on adding an item
by Msgr. Marion J. Makarewicz 17 Aug '11

17 Aug '11

Swaprava, I looked through my old logs to see what I did regarding that error when I did my first install, but I had deleted them. If I can recall correctly, it had to do with not getting required fields filled in when I imported my data from the previous ILS. It took me a while to figure it out but it had to do with making sure that the item subfield itype had BK in it. Also I didn't have both the homebranch and holding branch filled in for all the records. Another problem on some records was series information in the biblioitems were in two different fields. Double check your MARC structure and make sure that all the required fields have the necessary data in them. Remember that as you set up your framework, you also have to ensure that all the fields are visible in the proper view in the biblio and item editing tabs. Is the error on all records? Search on this thread to get some more info: Problems after upgrade to 3.4.3 What version are you running? Marion >Hello all, >We recently installed Koha for our small library, and we don't have any exposure to library sciences, we're just amateurs. We could install Koha properly. But there is one error which is showing up at the end of adding the item. I couldn't attach the csv file of our customized MARC structure for the 40KB limit of mails. >screenshot of the error: Software error: >Can't call method "subfield" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 2881. For help, please send mail to the webmaster ( <http://koha.1045719.n5.nabble.com/user/SendEmail.jtp?type=node&node=4703467 &i=0> [hidden email]), giving this error message and the time and date of the error. >Even if we use the default MARC structure, we still get the error. Interestingly, the item gets added to the record. However, while checking out the item against a patron, after giving the Barcode and pressing ok, we hit the same error >page again. Even while returning the book once we click on return the book, the same error comes. We saw some community pages where people encountered this kind of a problem. We don't have any clue to fix this. Any inputs? >Thanks in advance. >Swaprava

1 0

Re: [Koha] Kohacon11 : Last date of paper submission extended till August 30 2011
by Koustubha Kale 17 Aug '11

17 Aug '11

On Tue, Aug 16, 2011 at 4:59 PM, Chris Cormack <chrisc(a)catalyst.net.nz>wrote: > * Koustubha Kale (kmkale(a)anantcorp.com) wrote: > > Hi All, > > We have extended the last date of paper submission ( which was today > 15th > > August ) till 30th August 2011. > > > > Request all of you who would like to present at Kohacon111 to step > forward > > and submit an abstract at > > http://kohacon11.vpmthane.org/ocs/index.php/k/k11/schedConf/cfp for > > review. > > > > Also request all of you whose abstracts have been accepted to hurry up > and > > submit the full papers / presentations.. > > > Hi Koustubha > > I don't ever write full presentations, only notes for myself. > Submitting full papers is a very academic conference type of thing to > do, this would definitely be the first Kohacon that had written papers. > > Is this a must have, or just a 'it would be nice to have' condition? > > Chris > -- > Chris Cormack > Catalyst IT Ltd. > +64 4 803 2238 > PO Box 11-053, Manners St, Wellington 6142, New Zealand > Hi chris, Actually we are planning to have all the presentations / papers published as a Souvenir plus CD. So in order to have the same ready for handing over to participants during the conference itself, its necessary to have the papers / presentations in beforehand. Still if the community feels this is not done. Let me know and I will discuss with VPM. Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2

4 4

Kohacon11 : Last date of paper submission extended till August 30 2011
by Koustubha Kale 16 Aug '11

16 Aug '11

Hi All, We have extended the last date of paper submission ( which was today 15th August ) till 30th August 2011. Request all of you who would like to present at Kohacon111 to step forward and submit an abstract at http://kohacon11.vpmthane.org/ocs/index.php/k/k11/schedConf/cfp for review. Also request all of you whose abstracts have been accepted to hurry up and submit the full papers / presentations.. Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2

3 2

KohaCon
by Carlin, William 16 Aug '11

16 Aug '11

Does anyone know where I can get the number of attendees over the years at KohaCon? Best wishes, William Carlin Systems Washoe County Library System

3 3

SQL for to generate the Libarian that pay, cancel or Write Off a fine
by Akin Adigun (Akinomatics) 16 Aug '11

16 Aug '11

Can anyone help with the sql statement that can display the Librarian that cancel, pay or write off and the amount of fine each Librarian pay,cancel or write off . thanks --- On Mon, 8/15/11, koha-request(a)lists.katipo.co.nz <koha-request(a)lists.katipo.co.nz> wrote: From: koha-request(a)lists.katipo.co.nz <koha-request(a)lists.katipo.co.nz> Subject: Koha Digest, Vol 70, Issue 32 To: koha(a)lists.katipo.co.nz Date: Monday, August 15, 2011, 1:33 PM Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: SQL for reports (Owen Leonard) 2. Re: Koha and Drupal (Lori Bowen Ayre) 3. KohaCon (Carlin, William) 4. Kohacon11 : Last date of paper submission extended till August 30 2011 (Koustubha Kale) 5. Re: Koha installation on Debian/Ubuntu (Dibyendra Hyoju) ---------------------------------------------------------------------- Message: 1 Date: Mon, 15 Aug 2011 12:18:21 -0400 From: Owen Leonard <oleonard(a)myacpl.org> To: "Akin Adigun (Akinomatics)" <akinomatics(a)yahoo.com> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] SQL for reports Message-ID: <CAO4qe2NeLSvcM-ZK5WZsOwu2Tg=WEFSK6QpyWtBnLQFhdUA2kg(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 > I am using Koha 3.4 and on Ubuntu. Can any one help me out with the sql statement that can > generate librarian that pay, cancel or writeoff a fine in koha. Have you looked here? http://wiki.koha-community.org/wiki/SQL_Reports_Library Also, please don't reply to and quote the entire Koha digest when posting. Please start a new thread by emailing Koha(a)lists.katipo.co.nz. Thanks, Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ------------------------------ Message: 2 Date: Mon, 15 Aug 2011 09:51:37 -0700 From: Lori Bowen Ayre <lori.ayre(a)galecia.com> To: S?bastien Hinderer <Sebastien.Hinderer(a)ens-lyon.org> Cc: Koha list <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Koha and Drupal Message-ID: <CAEJpJYVEjoaiB8O-U_i0=mnN+GCG8H=Hg+CQCxBtzqBdBhZfRA(a)mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Have you seen eXtensible Catalog? It provides a top layer that is Drupal based (one node per record as you mentioned). And they have some nice conversion utilities for grabbing catalog content and converting it to the XC Schema which relies on Drupal for the OPAC layer. http://www.extensiblecatalog.org/ Lori =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-= Lori Bowen Ayre // Library Technology Consultant / The Galecia Group Oversight Board & Communications Committee / Evergreen (707) 763-6869 // Lori.Ayre(a)galecia.com <Lori.Ayre(a)galecia.com>Specializing in open source ILS solutions, RFID, filtering, workflow optimization, and materials handling =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= On Sun, Aug 14, 2011 at 11:46 AM, S?bastien Hinderer < Sebastien.Hinderer(a)ens-lyon.org> wrote: > Hello Henri-Damien, many thanks for your so detailed response ! > > > you may find on git.biblibre.com koha_biblibre.git (which are also on > > git.koha-community.org/koha.git in so far as all the ils-di required > > infrastructure is concerned), sopac.git and locuum.git and insurge.git, > > which contains all the patches we had to do to install SOPAC on top of a > > Koha installation. > > Okay, many thanks for the pointers ! > > > It is working but it not that handy to install. > > I see. Does it mean that, altough it is difficult to install, once the > initial installation is done it is working relatively well and easy to > maintain ? > > > And some choices for SOPAC makes that project quite difficult to run > > (namely sphinx and the insurge/locum technology and the fact that it > > relies on old drupal version), along with quite hard coded css quite > > restrict the potential of SOPAC. > > Okay. I'd like to ask several questions here. > 1. Which version of drupal does it rely on ? > 2. I have to say I did not understand what locum and insurge are. Any > clue for me ? > > > We tried to contribute the patches we wrote in order to fix some bugs. > > But it is free software, ppl may or may not take on your contributions > > and proposals. > > Indeed. Does it mean that there are currently no exchanges with sopac > maintainers ? > > > It is in production for some libraries. We can assist in the realization > > of that or provide you with url for that. > > I'm interested in any URL. I'm trying to build yet another digital > library. Now that I know about Koha and how good it is for cataloging > and exploring an OPAC, I have to say it is difficult for me to renounce > to powerful cataloguing/opac features. My first idea was ths a three > component solution: Drupal for the protal, Koha for the OPAC and a third > component yet to be chosen to handle files pertaining to each book. > Such an approach has, however, several pitfalls: it is heavy and there > is a problem if one wants to share authenticaiton. So I thought that > SOPAC could help: the (Koha) OPAC and Drupal would merge, and then I > could use Drupal to store and give access to the files associated with > each book. > > Any comment here would be warmly appreciated. > > > We are still convinced that drupal is really a nice thing and the fact > > that solr could be also used in drupal could make it really handy. > > Yeah I'd love to be able to use drupal for my digital library, find it > rather convenient, too. > > > Maybe you could also take a look at mkdrul from indexdata and find > > something interesting. > > Is such a module interesting even when you'd query only one Z39.50 > server ? In my case, I think I'd query only my local Koha where > everything would be catalogued. And would such an approach let one see > from within drupal the virtual shelves defined in Koha. And finally: the > fact that it seems to rely heavily on javascript makes me think it would > perhaps not be very accessible, but I didn't try it out... > > > Hope that helps. > > It helps, thanks a lot and best wishes, > S?bastien. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

1 0

Koha shows error on adding an item
by Swaprava Nath 16 Aug '11

16 Aug '11

Hello all, We recently installed Koha for our small library, and we don't have any exposure to library sciences, we're just amateurs. We could install Koha properly. But there is one error which is showing up at the end of adding the item. I couldn't attach the csv file of our customized MARC structure for the 40KB limit of mails. screenshot of the error: Software error: Can't call method "subfield" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 2881. For help, please send mail to the webmaster (webmaster@debmaker32 <mailto:webmaster@debmaker32>), giving this error message and the time and date of the error. Even if we use the default MARC structure, we still get the error. Interestingly, the item gets added to the record. However, while checking out the item against a patron, after giving the Barcode and pressing ok, we hit the same error page again. Even while returning the book once we click on return the book, the same error comes. We saw some community pages where people encountered this kind of a problem. We don't have any clue to fix this. Any inputs? Thanks in advance. Swaprava

1 0

Holds option is not working
by Arun Adrakatti 16 Aug '11

16 Aug '11

Dear All, I am using koha 3.00.05 vesion (installed through koha live CD) Holds option is not working in Administrator Interface. It shows below mentioned error. Pl assist me for resolving the same. Gateway Time-out The gateway did not receive a timely response from the upstream server or application. ------------------------------ Apache/2.2.12 (Ubuntu) Server at localhost Port 8080 REgards Arun

5 5

3.4.3 on opensuse 11.4 SMS::Send Date::ICal problem.
by clint.deckard 15 Aug '11

15 Aug '11

Greetings, First time poster, long time lurker. Met some of you at Kohacon 2010 and around. Thank you in advance. I have installed Koha 3.4.3 on a fresh install of Opensuse 11.4. Web installer reports SMS::Send and Date::ICal as missing but are installed. Google searching found similar reported problem and reported bug 6560 and 6561 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6560 but resolution so far. What to do now? Some (hopefully) relevant info belong. Thank you, Clint. koha-server:/home/clint # locate Send.pm /root/.cpan/build/SMS-Send-0.05-TgycpQ/blib/lib/SMS/Send.pm /root/.cpan/build/SMS-Send-0.05-TgycpQ/lib/SMS/Send.pm /usr/lib/perl5/vendor_perl/5.12.3/Mail/Send.pm /usr/lib/perl5/vendor_perl/5.12.3/SMS/Send.pm /usr/local/lib/perl5/site_perl/5.13.9/SMS/Send.pm koha-server:/home/clint # perldoc -l SMS::Send /usr/local/lib/perl5/site_perl/5.13.9/SMS/Send.pm koha-server:/home/clint/koha-3.04.03 # perl -e 'print "@INC\n"' /usr/share/koha/lib /usr/local/lib/perl5/site_perl/5.13.9/x86_64-linux /usr/local/lib/perl5/site_perl/5.13.9 /usr/local/lib/perl5/5.13.9/x86_64-linux /usr/local/lib/perl5/5.13.9 . koha-server:/home/clint/koha-3.04.03 # ./koha_perl_deps.pl -m [Mon Aug 13 13:00:37 2012] koha_perl_deps.pl: UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/lib/perl5/site_perl/5.12.3/Memoize/Memcached.pm line 6 Module Name Current Version Required Version Module Required -------------------------------------------------------------------------------------------------------------------------- Date::ICal 0 * 1.72 Yes SMS::Send 0 * 0.05 No -------------------------------------------------------------------------------------------------------------------------- Total modules reported: 2 * Module is missing or requires an upgrade. koha-server:/home/clint/koha-3.04.03 # env | grep KOHA KOHA_CONF=/etc/koha/koha-conf.xml koha-server:/home/clint/koha-3.04.03 # env | grep PERL5LIB PERL5LIB=/usr/share/koha/lib koha-server:/home/clint/koha-3.04.03 # perl -V Summary of my perl5 (revision 5 version 13 subversion 9) configuration: Platform: osname=linux, osvers=2.6.37.1-1.2-desktop, archname=x86_64-linux uname='linux koha-server 2.6.37.1-1.2-desktop #1 smp preempt 2011-02-21 10:34:10 +0100 x86_64 x86_64 x86_64 gnulinux ' config_args='' hint=recommended, useposix=true, d_sigaction=define useithreads=undef, usemultiplicity=undef useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef use64bitint=define, use64bitall=define, uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='cc', ccflags ='-fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O2', cppflags='-fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include' ccversion='', gccversion='4.5.1 20101208 [gcc-4_5-branch revision 167585]', gccosandvers='' intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='cc', ldflags =' -fstack-protector -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib /lib64 /usr/lib64 /usr/local/lib64 libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc -lgdbm_compat perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc libc=/lib/libc-2.11.3.so, so=so, useshrplib=false, libperl=libperl.a gnulibc_version='2.11.3' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E' cccdlflags='-fPIC', lddlflags='-shared -O2 -L/usr/local/lib -fstack-protector' Characteristics of this binary (from libperl): Compile-time options: PERL_DONT_CREATE_GVSV PERL_MALLOC_WRAP USE_64_BIT_ALL USE_64_BIT_INT USE_LARGE_FILES USE_PERLIO USE_PERL_ATOF Built under linux Compiled at Aug 12 2012 15:25:59 %ENV: PERL5LIB="/usr/share/koha/lib" PERL_LOCAL_LIB_ROOT="/home/clint/perl5" PERL_MB_OPT="--install_base /home/clint/perl5" PERL_MM_OPT="INSTALL_BASE=/home/clint/perl5" @INC: /usr/share/koha/lib /usr/local/lib/perl5/site_perl/5.13.9/x86_64-linux /usr/local/lib/perl5/site_perl/5.13.9 /usr/local/lib/perl5/5.13.9/x86_64-linux /usr/local/lib/perl5/5.13.9

4 3

Koha and Drupal
by Sébastien Hinderer 15 Aug '11

15 Aug '11

Dear all, I'd be interested in building an OPAC within Drupal. I know that work has been started by BibLibre to develop a Koha Connector for SOPAC but I can't find the actual connector so I am wondering about the status of this project. Has it been given up or is it still developed ? How mature is it ? Many thanks in advance for any help with this. Best wishes, Sébastien.

3 3