- Koha - lists.katipo.co.nz

MYSQL
by esmael 24 Feb '14

24 Feb '14

Im looking for the report to count number of items that is falls between specific callnumber, eg Call No Total ItemH-HA 101 HB-HD 112etc ... tq -- View this message in context: http://koha.1045719.n5.nabble.com/MYSQL-tp5788462.html Sent from the Koha-general mailing list archive at Nabble.com.

1 0

xslt and how not to show field if there are no data
by schnydszch 24 Feb '14

24 Feb '14

hi all! I'm trying to modify my koha's xslt. I have the following: <xsl:if test="marc:datafield[@tag=597]"> Musical director: <xsl:for-each select="marc:datafield[@tag=597]"> <xsl:call-template name="chopPunctuation"> <xsl:with-param name="chopString"> <xsl:call-template name="subfieldSelect"> <xsl:with-param name="codes">a</xsl:with-param> </xsl:call-template> </xsl:with-param> </xsl:call-template> <xsl:choose><xsl:when test="position()=last()"><xsl:text></xsl:text></xsl:when><xsl:otherwise><xsl:text>; </xsl:text></xsl:otherwise></xsl:choose> </xsl:for-each> </xsl:if> <xsl:if test="marc:datafield[@tag=597]"> Musical director's Write up: <xsl:for-each select="marc:datafield[@tag=597]"> <xsl:call-template name="chopPunctuation"> <xsl:with-param name="chopString"> <xsl:call-template name="subfieldSelect"> <xsl:with-param name="codes">b</xsl:with-param> </xsl:call-template> </xsl:with-param> </xsl:call-template> <xsl:choose><xsl:when test="position()=last()"><xsl:text></xsl:text></xsl:when><xsl:otherwise><xsl:text>; </xsl:text></xsl:otherwise></xsl:choose> </xsl:for-each> </xsl:if> <xsl:if test="marc:datafield[@tag=597]"> Musical director's Date of birth: <xsl:for-each select="marc:datafield[@tag=597]"> <xsl:call-template name="chopPunctuation"> <xsl:with-param name="chopString"> <xsl:call-template name="subfieldSelect"> <xsl:with-param name="codes">c</xsl:with-param> </xsl:call-template> </xsl:with-param> </xsl:call-template> <xsl:choose><xsl:when test="position()=last()"><xsl:text></xsl:text></xsl:when><xsl:otherwise><xsl:text>; </xsl:text></xsl:otherwise></xsl:choose> </xsl:for-each> </xsl:if> What I actually want my Koha to show is if there are no data in the example 597$b, the string Musical director's write up should not show. but I'm still seeing the field with no data, especially if one of the subfileds have data on it. So, how do I make Koha to not show MARC field-subfields with blank data. Thanks in advance and cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/xslt-and-how-not-to-show-field-if-there-a… Sent from the Koha-general mailing list archive at Nabble.com.

1 1

What is the difference / similaritiy between libraries and branches
by Josef Kreitmayer 23 Feb '14

23 Feb '14

Hello there, my name is Josef, we are currently about to implement our first 1600 books for the Future Library Vienna (Austria) in our Koha setup. Many thanks to Nicole Engard here, most of what I know about Koha I learned from her ByWater Solutions Koha Introduction Videos. I tried to reserach my following topic, but could not find any answer that gives clarity to my question. We are setting up a library that has a main library and some branches. The circulation is mainly closed within the branches, but books can also be returned at other branches. We also have temporary branches. Our big question for the Data-Implementation is: How / where do we best assign the items? One Library, several branches? Is Branch synonymous with Library? How do we best do for easy (mostly voluntary) administration and good overview? There is some posts in the list already touching the topic of libraries and branches, but I do not really get clarity by them. Sometimes both terms are used synonymous, sometimes they seem distincted. ___ Libraries and Branches | what is the difference, what is the similarity, what does it mean administrationwise? thank you heaps, josef *Mag. Josef Kreitmayer* E j(a)getactive.org T 0699/81 634 148 www.getactive.org <http://www.dragondreaming.at>

1 0

Install Koha-3.14.03 with Single Command in Ubuntu 12.04 LTS
by DP Tripathi 23 Feb '14

23 Feb '14

Dear Library Professionals, Install Koha 3.14 with single command in Ubuntu 12.04 LTS. Download and keep the file wherever you wish to keep in the server. (For ex: someone keeps the file at Desktop) then run the following command. Login as root: sudo su (Enter) Enter the password: Run the following command: *root@localhost:/home/library/Desktop# *chmod +x install_koha.sh *root@localhost:/home/libraryDesktop# *./install_koha.sh Ensure that your system is connected with Internet. Follow the Instruction. Add the port 8080 (Listen 8080) when it asks to add and save & close the file. It will install Koha 3.14 in your system. To open the Interface, use the following user id and password. User ID : koha_library Password: (please note down the password from terminal, it appears like 10ImCcKq3QHpfdx7) Enjoy! Feel free to contact at dptkvs(a)gmail.com, if you face any problem. Download the File at http://librarianguide.in/install_koha.sh Thanks! -- **************** ****** D. P. Tripathi Assistant Librarian BP Central Library NIT Rourkela Odisha, India www.librarianguide.in **************** ******

2 1

Re: [Koha] Borrowers DB file for offline circulation
by Paul A 22 Feb '14

22 Feb '14

At 09:28 AM 2/20/2014 +0500, Saira Asghar wrote: >Hello Everyone > >If we are using offline circulation, We need borrowers DB file. Any one can >please tell me that how we can get this DB file from database? I am using >ubuntu based koha version 3.14.01. Have you tried a report such as: SELECT * FROM borrowers; Paul

1 0

Re: [Koha] Report guidance
by Cab Vinton 21 Feb '14

21 Feb '14

Head slap. Well, that's what I get for editing one of my old reports too quickly -- It should be b.branchcode = 'PLAISTOW' instead of b.branchcode <> 'PLAISTOW' Or rather -- WHERE i.homebranch = <<Owning Library|branches>> AND b.branchcode = <<Borrower Home Branch|branches>> Sheesh. Long week ... Thank you, KB. Cab Vinton Plaistow PL On Fri, Feb 21, 2014 at 3:06 PM, Katelyn Browne <kbrowne(a)ccpcs.org> wrote: > Hi Cab, > > If I understand correctly, you want a list of Plaistow items checked out to > Plaistow patrons, so you should have b.branchcode = 'PLAISTOW'. > > The way you have it set up, it's finding Plaistow books checked out to > non-Plaistow patrons. (Or is that really what you want, and the numbers are > still too small?) > > --Katelyn. > > Katelyn Browne > Middle/High School Librarian > Capital City Public Charter School > 100 Peabody Street NW > Washington, DC 20011 > (202) 387-0309 x1745 > kbrowne(a)ccpcs.org > http://www.ccpcs.org/library/ > > > On Fri, Feb 21, 2014 at 2:29 PM, Cab Vinton <bibliwho(a)gmail.com> wrote: >> >> Hi, All -- >> >> We're in a small consortium of three libraries & I'm trying to write a >> report providing stats as follows -- >> >> Checkouts, renewals & local use of materials owned by a particular >> branch by patrons belonging to a particular branch >> >> The following report is generating numbers an order of magnitude too small >> -- >> >> SELECT s.datetime, i.itemcallnumber, i.itype, i.ccode, i.barcode, >> b.categorycode, s.type >> FROM statistics s >> LEFT JOIN items i on (i.itemnumber = s.itemnumber) >> LEFT JOIN borrowers b ON (s.borrowernumber = b.borrowernumber) >> WHERE i.homebranch = 'PLAISTOW' AND b.branchcode <> 'PLAISTOW' AND >> s.type in ('issue','renew','localuse') AND s.datetime BETWEEN >> '2013-01-01' AND '2013-12-31' >> ORDER BY i.cn_sort asc, i.itype, i.ccode >> >> Grateful for any assistance or pointers. >> >> All best, >> >> Cab Vinton, Director >> Plaistow Public Library >> Plaistow, NH >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha > >

1 0

Report guidance
by Cab Vinton 21 Feb '14

21 Feb '14

Hi, All -- We're in a small consortium of three libraries & I'm trying to write a report providing stats as follows -- Checkouts, renewals & local use of materials owned by a particular branch by patrons belonging to a particular branch The following report is generating numbers an order of magnitude too small -- SELECT s.datetime, i.itemcallnumber, i.itype, i.ccode, i.barcode, b.categorycode, s.type FROM statistics s LEFT JOIN items i on (i.itemnumber = s.itemnumber) LEFT JOIN borrowers b ON (s.borrowernumber = b.borrowernumber) WHERE i.homebranch = 'PLAISTOW' AND b.branchcode <> 'PLAISTOW' AND s.type in ('issue','renew','localuse') AND s.datetime BETWEEN '2013-01-01' AND '2013-12-31' ORDER BY i.cn_sort asc, i.itype, i.ccode Grateful for any assistance or pointers. All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH

1 0

Re: [Koha] Installation
by schnydszch 21 Feb '14

21 Feb '14

Debian is what most Koha users to install Koha, so you can follow instruction from here: http://wiki.koha-community.org/wiki/Koha_3.x_on_Debian_Squeeze Obviously, you must have Debian installed in your computer/server. For other Linux distro, look for your distro here: http://wiki.koha-community.org/wiki/Category:Installation click your distro, and follow the instructions -- View this message in context: http://koha.1045719.n5.nabble.com/Installation-tp5788268p5788312.html Sent from the Koha-general mailing list archive at Nabble.com.

1 0

How to make bootable cd/dvd of livecd or livedvd
by Mahesh Angadi 21 Feb '14

21 Feb '14

I have downloaded liblivedvdv1.4. However, I am not able to do a bootable cd of it. I tried NERO as well as FreeISOBurner. -- Mr. Mahesh M. Angadi, Librarian, Model College, Dombivli (E). Contact No. 9869120258, (0251) 2470010.

1 0

Setting up a new branch
by library 21 Feb '14

21 Feb '14

Kia ora everyone I'm sorry I am having a brain fade, but how do you get patrons into a new branch (the same patrons as the old branch) and assign the issuing permissions for the new branch. I have looked through all the help files I can find and I am stumped. I can see the patrons fine if I use my Superlibrarian login, but not the circulation login for the branch. Using 3.8 so far Thanks Ann Murphy Librarian Katikati College Beach Road, Katikati, 3129 New Zealand 0064 7 5492647 amurphy(a)katikaticollege.school.nz

2 1