- Koha - lists.katipo.co.nz

Renewal Report
by Lal S 02 Apr '14

02 Apr '14

Dear, Kindly send us the report for daily renewal with following fields issuedate,renewal date, duedate,surname,title , author,callnumber,barcode *Lal.sLibrarian*

1 0

[Arabic tutorial video] Installation Koha 3.14 - Debian packages - Ubuntu 12.04 LTS
by Karam Qubsi 02 Apr '14

02 Apr '14

Good mornings ... 3 Days ago I posted a tutorial video on YouTube talking about the installation process of Koha 3.14 using Debian packages on Ubuntu 12.04 LTS . I've got a good feedback that the video was clear and easy to follow from Koha Arab community ... http://youtu.be/mSb5Dxi5jSA I added a new page in koha wiki about it : http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages_(Arabic_Video) Best regards -- *Karam Qubsi*

1 0

emails with koha
by Ketan Kulkarni 01 Apr '14

01 Apr '14

Dear Experts, Issue: Our Koha server is unable to send email notification for any activity done (e.g. check-in/check-out) Requirement: Every action such as check-in/check-out should send an email notification to the patrons. Environment Overview: · We have Koha 3.14 with Debian O.S. · Microsoft Exchange 2010 server · Configured A.D. to Koha using LDAP o Our domain users are able to login into the OPAC and Admin pages o This means the LDAP is configured successfully Attempts: · Tried Sendmail (no email is sent) · Configured Postfix (email can be sent to gmail, hotmail, etc.) o Emails are going only through the terminal (mail -v test(a)gmail.com) but not through check-in/check-out · Configured Postfix with SMTP (no email is sent) Would appreciate your valuable inputs and suggestions. Many Thanks !

3 2

Report help
by Nicole Engard 01 Apr '14

01 Apr '14

I'm looking for a report that shows items that have holds on them where there are no other items available at the branch. Available being checked in and not lost. I was using this report as a starting point. SELECT i.itemnumber, i.reserves, i.issues, i.datelastseen, i.dateaccessioned, i.ccode, b.title, b.author, i.itemcallnumber, i.barcode, v.lib, IF(h.reservedate IS NULL, '', 'on hold') AS holds FROM items i LEFT JOIN biblio b USING (biblionumber) LEFT JOIN authorised_values v ON (i.itemlost=v.authorised_value) LEFT JOIN reserves h ON (b.biblionumber=h.biblionumber) WHERE i.itemlost != 0 AND v.category='LOST' and i.homebranch=<<Item's branch|branches>> Thanks in advance, Nicole

1 0

Sorting of accession numbers
by manoj382093 01 Apr '14

01 Apr '14

Dear Friends, I have used alphabets in barcode numerbers for different item types, now when i have generated the accession register sorted by barcode it sort like A1, A11, A12, A21.. etc instead of A1,A2,A3,A4..... Please help! Manoj Kumar Misra -- View this message in context: http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591.ht… Sent from the Koha-general mailing list archive at Nabble.com.

4 4

[araik@flib.sci.am: RE: upgrading error]
by Chris Cormack 01 Apr '14

01 Apr '14

----- Forwarded message from Araik Manukyan <araik(a)flib.sci.am> ----- Date: Tue, 1 Apr 2014 11:06:37 +0400 From: Araik Manukyan <araik(a)flib.sci.am> To: 'Chris Cormack' <chrisc(a)catalyst.net.nz> Subject: RE: [Koha] upgrading error X-Mailer: Microsoft Office Outlook 12.0 Hi Chris, Thank you for quick respond. I have installed the missing modules. Best Regards Arayik. -----Original Message----- From: Chris Cormack [mailto:chrisc@catalyst.net.nz] Sent: Tuesday, April 01, 2014 10:12 AM To: Araik Manukyan Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] upgrading error * Araik Manukyan (araik(a)flib.sci.am) wrote: > Dear All, > > We try upgrading our koha 3.12.03 version to koha 3.14.05 after that > when we try to open homepage we received such error > > Software error: > > Can't locate Crypt/Eksblowfish/Bcrypt.pm in @INC (@INC contains: > /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.14.2 > /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 > /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at > /usr/share/koha/lib/Koha/AuthUtils.pm line 21. > This is telling you you are missing a perl module. If you were using the packages, this would have been installed for you. But if you are using the tarball, you will want to do (in your unpacked tarball) ./koha_perl_deps.pl -m This will tell you all the missing modules. Then you need to install them Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2247 / Virus Database: 3722/6776 - Release Date: 03/31/14 ----- End forwarded message ----- -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand

1 0

tes
by Athar Anwar Shaikh 01 Apr '14

01 Apr '14

Test please ignore

1 0

upgrading error
by Araik Manukyan 01 Apr '14

01 Apr '14

Dear All, We try upgrading our koha 3.12.03 version to koha 3.14.05 after that when we try to open homepage we received such error Software error: Can't locate Crypt/Eksblowfish/Bcrypt.pm in @INC (@INC contains: /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at /usr/share/koha/lib/Koha/AuthUtils.pm line 21. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/AuthUtils.pm line 21. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 32. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 32. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. How can we solve this problem? Best Regard, Arayik.

2 1

ATHENA to KOHA Migration.
by Jerwyn Fernandez 01 Apr '14

01 Apr '14

Good day! We are currently migrating our system ATHENA to KOHA. ATHENA holds data in 852 and on the other part KOHA holds data in 952. I used MarcEdit tool to edit the data. I was able to edit it somehow however; when I upload the data to KOHA I notice there are problems in callnumber. ATHENA holds the data of callnumber in 852 $kPrefix $hMain $iCutter $mSuffix a KOHA holds the data of callnumber in 952 $ofull callnumber I do have a problem for those data that I exported in ATHENA that has *"multiple items on a single record and to those subfileds that are not properly arranged".* One of the attached file is the data that I exported to ATHENA, I just selected 3 records due to we have thousands of records. And the other attached file is the data that I was able to edit please check it. Is there anyone can help me with my problem? I heard that several libraries was successfully done this, some used regular expression and to be honest I'm not very particular with it. Hopefully I came in to the right place to answer my query. Thank you and best regards, -- Jerwyn G. Fernadez Basic Education Librarian Southville International School and Colleges

5 10

Interesting report request
by Nicole Engard 31 Mar '14

31 Mar '14

I think this can be done - but I'm not sure how to tackle it. I got this request for a report to find items that probably got missed at checkin so the staff can go look to the shelves to find these items. The question was - could we take the set of patrons who had items due during a three day period (today, tomorrow and yesterday?) And limit that to patrons who we have actual recorded checkins for during that time period and then produce a list of other items that these patrons had checked out that were due during the same three day period and generate this list of items --- in order to do a quick check to see if we actually received them but missed checking them in? Ideas?

2 2