- Koha - lists.katipo.co.nz

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

Koha installation
by recep ýsýk 21 Feb '14

21 Feb '14

I've install koha-3.14.03, when write http://localhost:8080/ the browser shows the source code. Like this #!/usr/bin/perl # This file is part of Koha. # # Koha is free software; you can redistribute it and/or modify it under the # terms of the GNU General Public License as published by the Free Software # Foundation; either version 2 of the License, or (at your option) any later # version. # # Koha is distributed in the hope that it will be useful, but WITHOUT ANY # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR # A PARTICULAR PURPOSE. See the GNU General Public License for more details. # # You should have received a copy of the GNU General Public License along # with Koha; if not, write to the Free Software Foundation, Inc., # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. use strict; use warnings; use CGI; use C4::Auth; # get_template_and_user use C4::Output; use C4::NewsChannels; # get_opac_news use C4::Languages qw(getTranslatedLanguages accept_language); my $input = new CGI; my $dbh = C4::Context->dbh; my ( $template, $borrowernumber, $cookie ) = get_template_and_user( { template_name => "opac-main.tmpl", type => "opac", query => $input, authnotrequired => ( C4::Context->preference("OpacPublic") ? 1 : 0 ), flagsrequired => { borrow => 1 }, } ); my $casAuthentication = C4::Context->preference('casAuthentication'); $template->param( casAuthentication => $casAuthentication, ); # display news # use cookie setting for language, bug default to syspref if it's not set my ($theme, $news_lang) = C4::Templates::themelanguage(C4::Context->config('opachtdocs'),'opac-main.tt','opac',$input); my $all_koha_news = &GetNewsToDisplay($news_lang); my $koha_news_count = scalar @$all_koha_news; $template->param( koha_news => $all_koha_news, koha_news_count => $koha_news_count ); # If GoogleIndicTransliteration system preference is On Set paramter to load Google's javascript in OPAC search screens if (C4::Context->preference('GoogleIndicTransliteration')) { $template->param('GoogleIndicTransliteration' => 1); } output_html_with_http_headers $input, $cookie, $template->output; How can I manag to resolve it. thanks.

2 1

heading subfields mismatch between auth and bib records using the thesaurus plugin
by Fabio T. 20 Feb '14

20 Feb '14

Hello everyone! There are some cases where a mismatch between the authority heading subfields and the receiving bibliographic ones could happen. This occurs when enabling the thesaurus plugin for bibliographic fields who are not designed as main/added entry fields, either in MARC21 and UNIMARC instances; I will bring one example each. UNIMARC: 410$t set to receive the heading of an authority record from a book series authority index. When choosing the authority record from the thesaurus plugin search results, the authority heading is placed in 410$a instead of 410$t. MARC21: 260$b set to receive the heading of an authority record from a publisher authority index. When choosing the authority record from the thesaurus plugin search results, the authority heading is placed in 260$a instead of 260$b. I'd like to exchange some ideas on this topic, with librarians and developers along (hence the post in the main list). Do you use any workaround ("redirecting" the output coming from the plugin, changing the authority heading subfields to reflect the bibliographic ones...?)? Is it made this way by design (expected behaviour), or would it make sense to change the code to handle these cases? Thanks in advance for sharing your thoughts! Fabio -- View this message in context: http://koha.1045719.n5.nabble.com/heading-subfields-mismatch-between-auth-a… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Location and item information (Marc 952) from Koha 2.x to 3.14
by Giuseppe Angilella 20 Feb '14

20 Feb '14

Hi, I'm in the progress of updating my Koha system here from 2.x to 3.14 (a giant leap, seemingly!) After using the built-in migration scripts and fixing many local inconsistencies, I am left with the Koha-to-Marc mapping of the subfields in the 952 tab (Location and item information). I am keeping Koha 2.x Marc framework as a default, and using Koha 3.14 Marc framework to catalogue all new biblios and items. I plan to edit all old biblios (and items) gradually and individually, change them into the new framework, and fill in the missing fields. However, although this seems to work with biblio records, some inconsistencies seem to remain with existing items. After editing and changing framework for a given biblio, I can only edit existing items through the "barcode" link. The framework structure for tag 952 in Koha 3.14 then appears (with most fields blank, of course), and the itemnumber showing in the 952.u subfield, now reserved for the Uniform Resource Identifier. Other values are also assigned to wrong fields, both in the intranet form for cataloguing and in the Opac. I would expect that filling the (new) fields correctly and saving would result in an updated item, now belonging to and complying with the (new) framework. In particular, I would expect that a further attempt at editing the same item would show the correct values filling the appropriate fields. But this is not the case: even though I can check (via direct access to the mysql database) that any modification has indeed taken place as desired, it seems as if the item is still interpreting those values as corresponding to fields arranged as in the old Marc framework. (The bibliographic framework test returns OK, with all the columns in the items table mapped to the 952 subfields as in the "new" framework.) On the other hand, items belonging to biblio records still in the default (old) framework are displayed correctly. Is the Marc framework only specific to biblio records? Shouldn't it be possible to have items belonging to different frameworks? Can two frameworks with different Koha-to-Marc mappings in the 952 tag, as in my case, coexist? Any comment and hopefully help would be greatly appreciated! Many thanks, Giuseppe.

3 5

Borrowers DB file for offline circulation
by Saira Asghar 20 Feb '14

20 Feb '14

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. -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan.

1 0

Bulk patron Import password issue
by geromoselle 20 Feb '14

20 Feb '14

I will like to know how exactly I can see the password I have created for my patrons. If I use say '123456' as the password, what will it be after upload. Because I dont understand Koha md5 hash conversion style George Sent from Samsung Mobile

2 1