- Koha - lists.katipo.co.nz

SIP2 to koha 3.14.05.000
by Pankaj 27 Mar '14

27 Mar '14

I want to integrate koha 3.14.05.000 to RFID tool using SIP2 protocols .How can installed SIP2 server on Ubuntu please give me suggestion . On Thu, Mar 27, 2014 at 4:30 AM, <koha-request(a)lists.katipo.co.nz> wrote: > 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: Error when trying to save catalogue records (Fridolin SOMERS) > 2. Re: Zebra Indexing and stop words (Paul A) > 3. Re: Report Help - With Rollup (Nicole Engard) > 4. Re: Permission to delete cover image? (Nicole Engard) > 5. Permissions questions (Heather Braum (NEKLS)) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 26 Mar 2014 19:07:29 +0100 > From: Fridolin SOMERS <fridolin.somers(a)biblibre.com> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Error when trying to save catalogue records > Message-ID: <53331761.1030808(a)biblibre.com> > Content-Type: text/plain; charset=windows-1252; format=flowed > > In administration of authority types : cgi-bin/koha/admin/authtypes.pl > Each type must define "Authority field to copy" with the field > containing heading. > > Le 25/03/2014 04:40, Catherine Kerrigan a ?crit : > > Hi folks! > > > > I'm hoping someone can help me with an error I'm getting which is > preventing me from amending existing catalogue records or creating new > catalogue records. Whenever I try to save a record, I receive the > following error: > > > > > > Tag "" is not a valid tag. at /usr/share/koha/lib/C4/Biblio.pm line 575 > > > > Checking through the community's documentation in manuals, wiki and IRC > logs, I think I have tracked it down to the following lines: > > > > 575 > > > > > > > > my $authfield = > > 576 > > > > > > > > MARC::Field->new( $authtypedata->{auth_tag_to_report}, > > 577 > > > > > > > > '', '', "a" => "" . $field->subfield('a') ); > > > > However, I don't know where I go from here to fix it. We're using Koha > version 3.12.03.000. > > > > Many thanks. > > > > Catherine > > > > PS we did finally get our self-loan station up and running, after much > toing and froing with the vendors. > > > > Catherine Kerrigan ::: Librarian > > T 08 8299 7300 ::: F 08 8172 0504 > > Adelaide Central School of Art ::: PO Box 225 Fullarton SA 5063 > > 7 Mulberry Road Glenside SA 5065 ::: (adjacent to the Adelaide Film > Studios) > > www.acsa.sa.edu.au<http://www.acsa.sa.edu.au/> > > > > Library news<http://www.acsalibrary.blogspot.com.au/> > > _________________________ > > > > Adelaide Central School of Art is located in the Glenside Cultural > Precinct. > > Please call to book a tour of our new facilities. > > > > Support the School by clicking here.< > http://www.givenow.com.au/adelaidecentralschoolofart> > > > > Artist Talk @ 12.15 ? 1pm > > Lisa Young | 3 April > > View the program here.< > http://www.acsa.sa.edu.au/fileadmin/public/pdfs/Artspeak_flyer.pdf> > > > > In the Gallery > > Chapter Two? > > 30 Years of Adelaide Central School of Art: Gilles Street 1989-1993 > > 1 April - 2 May 2014 > > To be opened by Lisa Young, Artist Tuesday 1 April 6.00 ? 8.00pm > > William Anschutz, Johnnie Dady, Rita Hall, Dee Jones, Christopher > Orchard, Anna Platten, Rory Richardson, Rod Taylor and Lisa Young > > > > Open 9am ? 5pm week days and Saturday 5 April 2014 1 ? 4pm > > > > Preview the works online here< > http://www.acsa.sa.edu.au/the-gallery/exhibitions/chapter-two/> > > > > Watch video interviews with our graduates and staff by Sasha Grbich at > http://vimeo.com/centralschool > > > > > > > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > -- > Fridolin SOMERS > Biblibre - P?les support et syst?me > fridolin.somers(a)biblibre.com > > > ------------------------------ > > Message: 2 > Date: Wed, 26 Mar 2014 15:53:33 -0400 > From: Paul A <paul.a(a)navalmarinearchive.com> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Zebra Indexing and stop words > Message-ID: > <5.2.1.1.2.20140326154959.059e4a88(a)pop.navalmarinearchive.com> > Content-Type: text/plain; charset="iso-8859-1"; format=flowed > > At 07:02 PM 3/26/2014 +0100, Fridolin SOMERS wrote: > >The stop words are indeed obsolete, they where used by NoZebra mode, which > >has been removed in 3.14. > > Is 245 second indicator not used at all? MARC definitions give it as: > Second Indicator > Nonfiling characters > 0 - No nonfiling characters > 1-9 - Number of nonfiling characters > > Best -- Paul > > > >Le 17/02/2014 09:23, Fischer, Katrin a ?crit : > >>Hi Ann, > >> > >>I can confirm that Zebra doesn't use the stop word list - it doesn't need > >>one :) But I am surprised the configuration did effect the search, did > >>you change the SearchEngine or some other of the search system > preferences? > >> > >>Katrin > >> > >> > >>>-----Original Message----- > >>>From: koha-bounces(a)lists.katipo.co.nz [mailto:koha- > >>> >> bounces(a)lists.katipo.co.nz] On Behalf Of library > >>>Sent: Monday, February 17, 2014 1:36 AM > >>>To: koha(a)lists.katipo.co.nz > >>>Subject: [Koha] Zebra Indexing and stop words > >>> > >>>Hi y'all > >>> > >>>Can someone confirm for me, we can have Zebra Indexing OR Stop Words. > >>>I tried to set stopwords and none of the OPAC search functions would > work, > >>>so I had to re-set the Zebra Index to use. > >>>I am using 3.8.2 but hoping to upgrade to 3.14 soon. > >>> > >>>Regards > >>> > >>>Ann Murphy > >>>Librarian > >>>Katikati College > >>>Beach Road, Katikati, 3129 > >>>New Zealand > >>> > >>>0064 7 5492647 > >>> > >>>amurphy(a)katikaticollege.school.nz > >>>_______________________________________________ > >>>Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > >>>http://lists.katipo.co.nz/mailman/listinfo/koha > >> > >>_______________________________________________ > >>Koha mailing list http://koha-community.org > >>Koha(a)lists.katipo.co.nz > >>http://lists.katipo.co.nz/mailman/listinfo/koha > > > >-- > >Fridolin SOMERS > >Biblibre - P?les support et syst?me > >fridolin.somers(a)biblibre.com > >_______________________________________________ > >Koha mailing list http://koha-community.org > >Koha(a)lists.katipo.co.nz > >http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > ------------------------------ > > Message: 3 > Date: Wed, 26 Mar 2014 15:57:23 -0500 > From: Nicole Engard <nengard(a)gmail.com> > To: Nick Clemens <nick(a)quecheelibrary.org> > Cc: Koha <Koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Report Help - With Rollup > Message-ID: > < > CAC0K6VEZsm+gqwgbuAc_nhzOOJ8jDNDMLCsm2AVpNtEMWpQg4A(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Okay - now here's the new issue - the grand total does not show: > > SELECT IFNULL(a.lib,'*GRAND TOTAL*') as Location, thingy.circs AS > Circulations FROM (select i.location as loction, count(s.datetime) as > circs from statistics s left join items i using (itemnumber) left join > borrowers p using (borrowernumber) where s.type in ('issue','renew') > and p.categorycode != 'LIBRARYUSE' and s.branch=<<Check out/renewal > branch|branches>> and s.datetime between > <<Checked out or renewed between (yyyy-mm-dd)|date>> and <<and > (yyyy-mm-dd)|date>> group by i.location with rollup ) AS thingy LEFT > JOIN authorised_values a on thingy.loction=a.authorised_value > where a.category='LOC' > > On Tue, Mar 25, 2014 at 4:16 PM, Nick Clemens <nick(a)quecheelibrary.org> > wrote: > > Ah, I see now, not a bug, I thought the duplicate authorised_values > weren't > > showing up, they were just filing odd because I was using test values and > > not sorting. > > > > > > On Tue, Mar 25, 2014 at 4:03 PM, Nicole Engard <nengard(a)gmail.com> > wrote: > >> > >> Nick, > >> > >> I figured it out - we needed to limit to LOC authorized values: > >> > >> SELECT IFNULL(a.lib,'*GRAND TOTAL*') as Location, thingy.circs AS > >> Circulations FROM (select i.location as loction, count(s.datetime) as > >> circs from statistics s left join items i using (itemnumber) left join > >> borrowers p using (borrowernumber) where s.type in ('issue','renew') > >> and p.categorycode != 'LIBRARYUSE' and s.branch=<<Check out/renewal > >> branch|branches>> and s.datetime between > >> <<Checked out or renewed between (yyyy-mm-dd)|date>> and <<and > >> (yyyy-mm-dd)|date>> group by i.location with rollup ) AS thingy LEFT > >> JOIN authorised_values a on thingy.loction=a.authorised_value > >> where a.category='LOC' > >> > >> On Tue, Mar 25, 2014 at 1:08 PM, Nick Clemens <nick(a)quecheelibrary.org> > >> wrote: > >> > Here's a thought, it might be an error in the authorized values., and > I > >> > think it is a bug > >> > > >> > I recreated it on our system by adding an authorized_value in a > >> > different > >> > category with the same value as one in the LOC: > >> > i.e. > >> > I added AFIC to our Vendor category, with description Error! The > system > >> > doesn't throw an error, and I can't see that value in the listing, but > >> > it is > >> > then 'Adult Fiction' is duplicated in my report > >> > > >> > Is the issue clear? > >> > > >> > > >> > > >> > > >> > On Thu, Mar 20, 2014 at 7:04 PM, Nicole Engard <nengard(a)gmail.com> > >> > wrote: > >> >> > >> >> Okay, any idea why the Juveasy might be showing 2 times? > >> >> > >> >> http://screencast.com/t/6dbByW4eZ > >> >> > >> >> I added the location code in case that was it - they're identical as > >> >> are their numbers. > >> >> > >> >> On Thu, Mar 20, 2014 at 1:50 PM, Nicole Engard <nengard(a)gmail.com> > >> >> wrote: > >> >> > Thank you so much Nick!! > >> >> > > >> >> > Nicole > >> > > >> > > >> > > >> > > >> > -- > >> > Nick Clemens > >> > Quechee & Wilder Libraries > >> > Nick(a)quecheelibrary.org > >> > http://www.QuecheeLibrary.org > >> > Q (802) 295-1232 W (802) 295-6341 > > > > > > > > > > -- > > Nick Clemens > > Quechee & Wilder Libraries > > Nick(a)quecheelibrary.org > > http://www.QuecheeLibrary.org > > Q (802) 295-1232 W (802) 295-6341 > > > ------------------------------ > > Message: 4 > Date: Wed, 26 Mar 2014 16:08:00 -0500 > From: Nicole Engard <nengard(a)gmail.com> > To: "Hernandez, Heather" <heather_hernandez(a)nps.gov> > Cc: Koha <Koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Permission to delete cover image? > Message-ID: > < > CAC0K6VEgKZnWU_3COdWTnqg39Gg8de8eMSQdoafNFTYPNHRZ0A(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Thanks all!! > > On Wed, Mar 26, 2014 at 12:20 PM, Hernandez, Heather > <heather_hernandez(a)nps.gov> wrote: > > Thanks for mentioning this, Galen--I hadn't noticed the separate > permission > > in the patron permissions under Tools! I obviously need to do some > > reviewing! (Our Reference Librarian doesn't have that permission turned > > on--I'll have to ask her if she'd like it, since she does a lot of > scanning > > of content!) > > > > Cheerio, > > h2 > > ~~~~~~~~~~~~~~ > > Heather Hernandez > > Technical Services Librarian > > Cultural Resources and Museum Management Division > > San Francisco Maritime National Historical Park > > heather_hernandez(a)nps.gov > > 415-561-7032 (voice) 415-556-3540 (fax) > > http://www.nps.gov/safr/historyculture/library-collections.htm > > > > "The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > Message: 5 > Date: Wed, 26 Mar 2014 16:51:22 -0500 > From: "Heather Braum (NEKLS)" <hbraum(a)nekls.org> > To: Koha <koha(a)lists.katipo.co.nz> > Subject: [Koha] Permissions questions > Message-ID: > < > CABaQF39bLXgBJdgdFxZjQ+phUJvi_e6SdhXh5gv0+m5EAPx5QA(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > I'm doing an audit of the permissions of our staff accounts in our system, > and have several questions about certain permissions. > > I have already looked at the manual section on permissions and the granular > section, too, but it didn't give enough information ( > > http://manual.koha-community.org/3.14/en/patronpermissions.html#patronperms… > ) > > Is there any other online documentation that explains each permission and > what it turns/off or what it may depend upon? > > Here's the permissions I have questions about: > > *circulate* *group* > 1. circulate_remaining_permissions vs the other granular circulate > permissions -- what's the difference? > 2. manage_courses/put_coursereserves/remove_coursereserves -- should these > even be in *circulate? *I filed a bug about these ( > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11981) > > *catalogue vs staffaccess* > 1. what's the difference between the *catalogue* permission and the > *staffaccess* permission? > > > *reserveforothers group* > 1. edit_holds: how does one edit holds? What's this permission mean? > 2. place_holds vs add_holds: what's the difference between these two > permissions? > 3. modify_holds_priority vs. reorder_holds -- what's the difference between > these two permissions? > > > *edit_catalogue/tools groups * > 1. edit_catalogue/batch_edit_items vs tools/batch_edit_items -- what's the > difference between the two permissions? > > Thanks! > > Heather Braum > NExpress Coordinator > Resource Sharing Librarian > Northeast Kansas Library System > hbraum(a)nekls.org > > "The illiterate of the 21st century will not be those cannot read > and write, but those who cannot learn, unlearn, and relearn." ~Alvin > Toffler, *Rethinking the Future* > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 101, Issue 55 > ************************************* > -- * Thanks & Regards PANKAJ KUMAR MAURYASOFTWARE ENGINEERGreat Eastern Impex Pvt. Ltd.Plot no. : 285, Udyog Vihar,Phase - II, Gurgaon - 122016(HARYANA), IndiaPhone No. : +91-124-2347431, 2347432Fax No. : +91-124-2348432Vodafone No. : 9953938077Toll Free :-18002004015Visit us at www.geipl.com <http://www.geipl.com> An ISO 9001:2008 Certified Company*

1 0

Upgrading Koha from 3.06 to 3.14
by Dibyendra Hyoju 27 Mar '14

27 Mar '14

Hi all, I installed Koha 3.06 from the source few years back. Recently, I have also installed Koha 3.14 using koha-common into another machine. My queries are: 1. I was wondering if there is a way to upgrade the database of Koha 3.06 to 3.14. 2. Or can we upgrade the Koha 3.06 to 3.14 using Koha 3.14 source? Thanking you, Dibyendra Hyoju

2 1

Zebra and search for accented letters
by Kallinen Pasi 27 Mar '14

27 Mar '14

Hello, We have a bit of a problem with Zebra and searching for accented letters. The Finnish alphabet has 'å', 'ä' and 'ö'[1], but the search does not distinguish between those and the non-accented versions. So, for example, searching for "rölli" returns "rolling stones" before "rölli". Is there any way we can make Zebra consider those three letters separate from the base letters? I've created /etc/koha/zebradb/etc/word-phrase-utf.chr that has the extra three letters in the lowercase and uppercase -definitions, and removes them from the equivalent and map -sets. Restarting and reindexing has no effect on searching. I've also created /etc/koha/zebradb/lang_defs/fi/sort-string-utf.chr that does the same thing. The /etc/koha/sites/*/zebra*.cfg -files point to the correct chr files. [1] a-ring, a-diaeresis, o-diaeresis. These are actual separate letters at the end of the alphabet, and cannot be lumped in with a and o. -- Ystävällisin terveisin Pasi Kallinen ICT-asiantuntija p. 0400-139747 pasi.kallinen(a)pttk.fi Pohjois-Karjalan Tietotekniikkakeskus Oy - www.pttk.fi

3 2

Nonfiling characters and sorting
by Paul A 27 Mar '14

27 Mar '14

I'm not sure if it's just our catalogue, so would ask for confirmation (or denial) by others before exploring further. In both OPAC and staff interface, the "sort" drop-down defaults to 'relevance', but for longer pages users and staff sort by 'title A-Z'. Normally a biblio with a 245 second indicator set to, say, 4 drops 'the ' (3 chars and space), but we are finding that it does *not* drop German articles such as 'der ' and 'die ' Example: <http://opac.navalmarinearchive.com/cgi-bin/koha/opac-search.pl?idx=au&q=now…:> which has both English and German usage. Has anyone else noticed this? Thanks -- Paul

4 4

Re: [Koha] Error when trying to save catalogue records
by Catherine Kerrigan 27 Mar '14

27 Mar '14

Fridolin wrote: > In administration of authority types : cgi-bin/koha/admin/authtypes.pl Each type must define "Authority field to copy" with the field containing heading. Thank you so much, Fridolin! That's pointed me in the direction of where I was going wrong. It will take me some time to work it through and check it, but I feel it's on the right track. Kind regards, Catherine Catherine Kerrigan ::: Librarian T 08 8299 7300 ::: F 08 8172 0504 Adelaide Central School of Art ::: PO Box 225 Fullarton SA 5063 7 Mulberry Road Glenside SA 5065 ::: (adjacent to the Adelaide Film Studios) www.acsa.sa.edu.au<http://www.acsa.sa.edu.au/> Library news<http://www.acsalibrary.blogspot.com.au/> _________________________ Adelaide Central School of Art is located in the Glenside Cultural Precinct. Please call to book a tour of our new facilities. Support the School by clicking here.<http://www.givenow.com.au/adelaidecentralschoolofart> Artist Talk @ 12.15 - 1pm Lisa Young | 3 April View the program here.<http://www.acsa.sa.edu.au/fileadmin/public/pdfs/Artspeak_flyer.pdf> In the Gallery Chapter Two... 30 Years of Adelaide Central School of Art: Gilles Street 1989-1993 1 April - 2 May 2014 To be opened by Lisa Young, Artist Tuesday 1 April 6.00 - 8.00pm William Anschutz, Johnnie Dady, Rita Hall, Dee Jones, Christopher Orchard, Anna Platten, Rory Richardson, Rod Taylor and Lisa Young Open 9am - 5pm week days and Saturday 5 April 2014 1 - 4pm Preview the works online here<http://www.acsa.sa.edu.au/the-gallery/exhibitions/chapter-two/> Watch video interviews with our graduates and staff by Sasha Grbich at http://vimeo.com/centralschool

2 1

Zebra Indexing and stop words
by library 27 Mar '14

27 Mar '14

Hi y'all Can someone confirm for me, we can have Zebra Indexing OR Stop Words. I tried to set stopwords and none of the OPAC search functions would work, so I had to re-set the Zebra Index to use. I am using 3.8.2 but hoping to upgrade to 3.14 soon. Regards Ann Murphy Librarian Katikati College Beach Road, Katikati, 3129 New Zealand 0064 7 5492647 amurphy(a)katikaticollege.school.nz

4 4

Permissions questions
by Heather Braum (NEKLS) 26 Mar '14

26 Mar '14

I'm doing an audit of the permissions of our staff accounts in our system, and have several questions about certain permissions. I have already looked at the manual section on permissions and the granular section, too, but it didn't give enough information ( http://manual.koha-community.org/3.14/en/patronpermissions.html#patronperms… ) Is there any other online documentation that explains each permission and what it turns/off or what it may depend upon? Here's the permissions I have questions about: *circulate* *group* 1. circulate_remaining_permissions vs the other granular circulate permissions -- what's the difference? 2. manage_courses/put_coursereserves/remove_coursereserves -- should these even be in *circulate? *I filed a bug about these ( http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11981) *catalogue vs staffaccess* 1. what's the difference between the *catalogue* permission and the *staffaccess* permission? *reserveforothers group* 1. edit_holds: how does one edit holds? What's this permission mean? 2. place_holds vs add_holds: what's the difference between these two permissions? 3. modify_holds_priority vs. reorder_holds -- what's the difference between these two permissions? *edit_catalogue/tools groups * 1. edit_catalogue/batch_edit_items vs tools/batch_edit_items -- what's the difference between the two permissions? Thanks! Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbraum(a)nekls.org "The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn." ~Alvin Toffler, *Rethinking the Future*

1 0

Permission to delete cover image?
by Nicole Engard 26 Mar '14

26 Mar '14

Is there any one permission that controls who can delete a cover image? If you have permission to upload them you can delete them? or is there no permission on there at all and can everyone delete covers? Just checking for documentation purposes. Thanks Nicole

3 4

Report Help - With Rollup
by Nicole Engard 26 Mar '14

26 Mar '14

Hi all, I need some help with a report that has With RollUp in it. I have used this before and had no problem, but for this report it keeps showing the last value 2 times at the bottom instead of 'grand total'. So here's how I started: select IFNULL(a.lib,'*GRAND TOTAL*') as location, count(s.datetime) as circs from statistics s left join items i using (itemnumber) left join borrowers p using (borrowernumber) LEFT JOIN authorised_values a ON (i.location=a.authorised_value) where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE' and s.branch=<<Check out/renewal branch|branches>> and a.category='LOC' and s.datetime between <<Checked out or renewed between (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> group by i.location with rollup This runs and is right, but at the end it repeats the last shelving location instead of showing 'Grand Total'. Next I tried: select if(i.location is null, '*GRAND TOTAL*', a.lib) as location, count(s.datetime) as circs from statistics s left join items i using (itemnumber) left join borrowers p using (borrowernumber) LEFT JOIN authorised_values a ON (i.location=a.authorised_value) where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE' and s.branch='BAILEYCOVE' and a.category='LOC' and s.datetime between '2014-03-19' and '2014-03-20' group by i.location with rollup This repeated the same location over and over. So then I tried this: select ifnull(i.location, 'GRAND TOTAL') as code, a.lib as location, count(s.datetime) as circs from statistics s left join items i using (itemnumber) left join borrowers p using (borrowernumber) LEFT JOIN authorised_values a ON (i.location=a.authorised_value) where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE' and s.branch=<<Check out/renewal branch|branches>> and a.category='LOC' and s.datetime between <<Checked out or renewed between (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> group by i.location with rollup Which shows grand total, but still repeats the darn location name again. And this which shows only one location over and over: select case a.location when null 'grand total' else a.lib as location, count(s.datetime) as circs from statistics s left join items i using (itemnumber) left join borrowers p using (borrowernumber) LEFT JOIN authorised_values a ON (i.location=a.authorised_value) where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE' and s.branch=<<Check out/renewal branch|branches>> and a.category='LOC' and s.datetime between <<Checked out or renewed between (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> group by i.location with rollup I'm up for any suggestion that gets me to have the final line just have the total and not a false location name.

2 7

Error when trying to save catalogue records
by Catherine Kerrigan 26 Mar '14

26 Mar '14

Hi folks! I'm hoping someone can help me with an error I'm getting which is preventing me from amending existing catalogue records or creating new catalogue records. Whenever I try to save a record, I receive the following error: Tag "" is not a valid tag. at /usr/share/koha/lib/C4/Biblio.pm line 575 Checking through the community's documentation in manuals, wiki and IRC logs, I think I have tracked it down to the following lines: 575 my $authfield = 576 MARC::Field->new( $authtypedata->{auth_tag_to_report}, 577 '', '', "a" => "" . $field->subfield('a') ); However, I don't know where I go from here to fix it. We're using Koha version 3.12.03.000. Many thanks. Catherine PS we did finally get our self-loan station up and running, after much toing and froing with the vendors. Catherine Kerrigan ::: Librarian T 08 8299 7300 ::: F 08 8172 0504 Adelaide Central School of Art ::: PO Box 225 Fullarton SA 5063 7 Mulberry Road Glenside SA 5065 ::: (adjacent to the Adelaide Film Studios) www.acsa.sa.edu.au<http://www.acsa.sa.edu.au/> Library news<http://www.acsalibrary.blogspot.com.au/> _________________________ Adelaide Central School of Art is located in the Glenside Cultural Precinct. Please call to book a tour of our new facilities. Support the School by clicking here.<http://www.givenow.com.au/adelaidecentralschoolofart> Artist Talk @ 12.15 – 1pm Lisa Young | 3 April View the program here.<http://www.acsa.sa.edu.au/fileadmin/public/pdfs/Artspeak_flyer.pdf> In the Gallery Chapter Two… 30 Years of Adelaide Central School of Art: Gilles Street 1989-1993 1 April - 2 May 2014 To be opened by Lisa Young, Artist Tuesday 1 April 6.00 – 8.00pm William Anschutz, Johnnie Dady, Rita Hall, Dee Jones, Christopher Orchard, Anna Platten, Rory Richardson, Rod Taylor and Lisa Young Open 9am – 5pm week days and Saturday 5 April 2014 1 – 4pm Preview the works online here<http://www.acsa.sa.edu.au/the-gallery/exhibitions/chapter-two/> Watch video interviews with our graduates and staff by Sasha Grbich at http://vimeo.com/centralschool

2 1