- Koha - lists.katipo.co.nz

Collection Code Totals
by Kerrie Stevens 20 Nov '13

20 Nov '13

I am trying to run a report to give me the total number of items within each of our collection codes (we have 5) at each branch but I can only get it show me the results from one of them... can anyone see where I'm going wrong? SELECT count(ccode), ccode AS collection FROM items WHERE items.homebranch='VIC' ORDER BY items.dateaccessioned DESC I have looked through the Reports Library but can't find anything to do this. I've tried to adapt others but without any luck. Any help is much appreciated. Thank you, Kerrie Stevens

3 2

Fwd: Koha Screen Shots
by Mohan Kumar K.V. 20 Nov '13

20 Nov '13

---------- Forwarded message ---------- From: Mohan Kumar K.V. <moni090(a)gmail.com> Date: Tue, Nov 19, 2013 at 11:35 AM Subject: Fwd: Koha Screen Shots To: members(a)wlsar.org.nz Cc: Shiva Kumara <shivu.rm(a)gmail.com> Hi Koha forum members, Anyone can resolve the following typical problem about koha web opac search by author. We had installed koah 3.12.06 on ubuntu, we noticed that while searching webopac by author field got software errors. But we noticed small “a” prefixed with author name, if we go search like “aAuthor” then only search results are positive. What could be the problem? Kindly guide us to resolve the typical problem. Please check the enclosed attachments for more information on Software Error and we hope will get positive reply from the forum members, Thanks in Advance, With regards Mohan ---------- Forwarded message ---------- From: Shiva Kumara <shivu.rm(a)gmail.com> Date: Wed, Nov 13, 2013 at 3:42 PM Subject: Fwd: Koha Screen Shots To: Mohan is Mine <moni090(a)gmail.com> ---------- Forwarded message ---------- From: suneel DM <suneeldm(a)gmail.com> Date: 13 November 2013 15:35 Subject: Koha Screen Shots To: shivu.rm(a)gmail.com Hi, Pls find koha screenshots error Regards Suneel.D.M -- ***With Regards*** Shivakumara RM Digital Library Analyst Institute for Social and Economic Change Dr. VKRV Rao Road, Nagarabhavi, Bangalore - 560 072 https://sites.google.com/site/shivakumararm/<http://sites.google.com/site/aigslibrary> <https://sites.google.com/site/shivakumararm/> -- With regards, Mohan Kumar K V Information Analyst, Hewlett-Packard Labs India Bangalore 560 030 India -- With regards, Mohan Kumar K V Information Analyst, Hewlett-Packard Labs India Bangalore 560 030 India

2 1

Does anyone use the "Overdues with fines" report?
by Kyle Hall 19 Nov '13

19 Nov '13

Hello all, I'm working on rewriting Koha's accounting system, and I'm looking to find out if anyone is currently using the "Overdues with fines" report ( aka circ/branchoverdues.pl ). The reason I ask this is because there is a lot of code I will need to add in order to support just this report, and it would be silly to do so if nobody is actively using it. Conversely, removing the report would simplify some underlying parts of Koha, which makes for a less bug-prone Koha! Please let me know! Thanks, Kyle http://www.kylehall.info ByWater Solutions ( http://bywatersolutions.com ) Meadville Public Library ( http://www.meadvillelibrary.org ) Crawford County Federated Library System ( http://www.ccfls.org ) Mill Run Technology Solutions ( http://millruntech.com )

7 6

Re: [Koha] Koha Digest, Vol 97, Issue 32
by Maxine Murphy 19 Nov '13

19 Nov '13

Hi Kyle Oamaru Library does not use this 'Overdues with fines' option in Circulation. We use a 'report', if we want a list of borrowers with money on their card. When I looked at this report, it is not user friendly for me, why:- - columns do not sort (currently in Borrower Surname order) - can not select list by Branch (Waitaki has one other library on koha) - can not download list Also wondering what this list is good for. cheers Maxine Technical Services and Systems Administrator Waitaki District Libraries -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: Tuesday, 19 November 2013 12:00 p.m. To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 97, Issue 32 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: Importing books creates multiple items (John Palmer) 2. Re: Rearranging patron page (Jenice S. Tate) 3. Does anyone use the "Overdues with fines" report? (Kyle Hall) 4. Re: Does anyone use the "Overdues with fines" report? (Nicole Engard) 5. Re: Does anyone use the "Overdues with fines" report? (AfZaL ImAm) 6. Re: Does anyone use the "Overdues with fines" report? (Bob Birchall) 7. Re: Enable SMS messaging options (Robin Sheat) ---------------------------------------------------------------------- Message: 1 Date: Mon, 18 Nov 2013 08:56:39 -0800 From: John Palmer <writing2009(a)gmail.com> To: magmatic <magmatic(a)timkoop.com> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Importing books creates multiple items Message-ID: <CAOan+39Y-Z517Fkeb3d5hmdckd-iaYbvuTdF_HPe9NsnpTJEyQ(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 I'm having a similar problem. I have 10 attributes per excel tuple. Two attributes (the 100 and 245 fields) map correctly in the underlying MARC21 data, but each of the 952 field are imported as separate tuples instead of all into the first tuple. Correspondingly, I get eight individual items created, each only one of the 952 attributes. I found that during mapping the excel data into the appropriate 952 fields, MarcEdit 5.9 creates a separate 952 entry for each individual attribute. These separate 952 items are apparently is imported as separate books rather than a single book. I speculate that creating a single 952 cell and populating the data with the appropriate MARC data delimiters ($a, $b ...) would solve this problem, but that seems suboptimal on a large scale import. On Mon, Nov 18, 2013 at 8:13 AM, magmatic <magmatic(a)timkoop.com> wrote: > I'm importing a csv file of books into Koha, using MarcEdit. The > fields > are: > author, title, publisher, year, item type, barcode, and shelf location. > > It looks like I'm getting two items for every line in the file. One > item contains the correct barcode, and the other item contains the > correct shelf location. > > Anyone have any ideas where I'm going wrong? > > And this might be a related question: what is the difference between > an authority record and a bib record? > > Thanks > -- > Tim > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Importing-books-creates-multiple-ite > ms-tp5778596.html Sent from the Koha-general mailing list archive at > Nabble.com. > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ Message: 2 Date: Mon, 18 Nov 2013 11:38:55 -0600 From: "Jenice S. Tate" <jtate(a)mdah.state.ms.us> To: Owen Leonard <oleonard(a)myacpl.org> Cc: koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Rearranging patron page Message-ID: <528A50AF.4010702(a)mdah.state.ms.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed The current arrangement is Patron identity Main address Alternate addrecc Library management Library set-up OPAC/Staff login Additional attributes & identifiers I would like to change the arrangement to Library management Patron Identity Main address Alternate address Additional attributes & identifiers Library set-up On 11/18/2013 4:49 AM, Owen Leonard wrote: >>>> I would like to rearrange the patron page. >>> Please be more specific. What page are you talking about, and how do >>> you want to rearrange it? >> It's the page where you enter a patron. > ...and how do you want to rearrange it? > > -- Owen > -- Jenice S. Tate, Systems Administrator MS Department of Archives & History Archives & Records Services Division - Computer Support Phone: (601) 576-6821 Fax: (601) 576-6824 Email: jtate(a)mdah.state.ms.us ------------------------------ Message: 3 Date: Mon, 18 Nov 2013 13:18:36 -0500 From: Kyle Hall <kyle.m.hall(a)gmail.com> To: Koha <koha(a)lists.katipo.co.nz> Subject: [Koha] Does anyone use the "Overdues with fines" report? Message-ID: <CACpVHfzxqjt6=5O0Y1Y7f+bgZq7azGKVp3QacZdNytCrfABidw(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hello all, I'm working on rewriting Koha's accounting system, and I'm looking to find out if anyone is currently using the "Overdues with fines" report ( aka circ/branchoverdues.pl ). The reason I ask this is because there is a lot of code I will need to add in order to support just this report, and it would be silly to do so if nobody is actively using it. Conversely, removing the report would simplify some underlying parts of Koha, which makes for a less bug-prone Koha! Please let me know! Thanks, Kyle http://www.kylehall.info ByWater Solutions ( http://bywatersolutions.com ) Meadville Public Library ( http://www.meadvillelibrary.org ) Crawford County Federated Library System ( http://www.ccfls.org ) Mill Run Technology Solutions ( http://millruntech.com ) ------------------------------ Message: 4 Date: Mon, 18 Nov 2013 12:23:33 -0600 From: Nicole Engard <nengard(a)gmail.com> To: Kyle Hall <kyle.m.hall(a)gmail.com> Cc: Koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Does anyone use the "Overdues with fines" report? Message-ID: <CAC0K6VHr64J-QbK+gW=EO6W-H=rPESO-2Pzs=pkN9-AYXJjmmg(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 For years this wasn't even in the manual because I didn't know what the point of it was and no one complained ... to me that says no one was looking for info on it ... if that helps at all. Nicole On Mon, Nov 18, 2013 at 12:18 PM, Kyle Hall <kyle.m.hall(a)gmail.com> wrote: > Hello all, > > I'm working on rewriting Koha's accounting system, and I'm looking to find > out if anyone is currently using the "Overdues with fines" report ( > aka circ/branchoverdues.pl ). > > The reason I ask this is because there is a lot of code I will need to add > in order to support just this report, and it would be silly to do so if > nobody is actively using it. Conversely, removing the report would simplify > some underlying parts of Koha, which makes for a less bug-prone Koha! > > Please let me know! > > Thanks, > Kyle > > http://www.kylehall.info > ByWater Solutions ( http://bywatersolutions.com ) > Meadville Public Library ( http://www.meadvillelibrary.org ) > Crawford County Federated Library System ( http://www.ccfls.org ) > Mill Run Technology Solutions ( http://millruntech.com ) > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ Message: 5 Date: Mon, 18 Nov 2013 23:55:25 +0530 From: AfZaL ImAm <afzalimam33(a)gmail.com> To: Nicole Engard <nengard(a)gmail.com> Cc: Koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Does anyone use the "Overdues with fines" report? Message-ID: <CANh4Dua88Fu-H+JaykBOGJ_KGqv+GU5=LZLRZJWcn8XehotybA(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 how to unsubscribe this Koha conversation i am irrirtate when you they all messages come in my inbox On Mon, Nov 18, 2013 at 11:53 PM, Nicole Engard <nengard(a)gmail.com> wrote: > For years this wasn't even in the manual because I didn't know what the > point of it was and no one complained ... to me that says no one was > looking for info on it ... if that helps at all. > > Nicole > > > On Mon, Nov 18, 2013 at 12:18 PM, Kyle Hall <kyle.m.hall(a)gmail.com> wrote: > > > Hello all, > > > > I'm working on rewriting Koha's accounting system, and I'm looking to > find > > out if anyone is currently using the "Overdues with fines" report ( > > aka circ/branchoverdues.pl ). > > > > The reason I ask this is because there is a lot of code I will need to > add > > in order to support just this report, and it would be silly to do so if > > nobody is actively using it. Conversely, removing the report would > simplify > > some underlying parts of Koha, which makes for a less bug-prone Koha! > > > > Please let me know! > > > > Thanks, > > Kyle > > > > http://www.kylehall.info > > ByWater Solutions ( http://bywatersolutions.com ) > > Meadville Public Library ( http://www.meadvillelibrary.org ) > > Crawford County Federated Library System ( http://www.ccfls.org ) > > Mill Run Technology Solutions ( http://millruntech.com ) > > _______________________________________________ > > 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 > -- *Afzal imam* *Technical Assistant* *Dean Student Welfare* *Aligarh Muslim University* *Aligarh* *Mob: 09319135278* ------------------------------ Message: 6 Date: Tue, 19 Nov 2013 08:59:41 +1100 From: Bob Birchall <bob(a)calyx.net.au> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Does anyone use the "Overdues with fines" report? Message-ID: <528A8DCD.4020206(a)calyx.net.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed You will find an 'unsubscribe' box at the bottom of this page: http://lists.katipo.co.nz/mailman/listinfo/koha We're sorry to see you go. Bob Birchall Calyx On 19/11/13 05:25, AfZaL ImAm wrote: > how to unsubscribe this Koha conversation i am irrirtate when you they all > messages come in my inbox > > > On Mon, Nov 18, 2013 at 11:53 PM, Nicole Engard <nengard(a)gmail.com> wrote: > >> For years this wasn't even in the manual because I didn't know what the >> point of it was and no one complained ... to me that says no one was >> looking for info on it ... if that helps at all. >> >> Nicole >> >> >> On Mon, Nov 18, 2013 at 12:18 PM, Kyle Hall <kyle.m.hall(a)gmail.com> wrote: >> >>> Hello all, >>> >>> I'm working on rewriting Koha's accounting system, and I'm looking to >> find >>> out if anyone is currently using the "Overdues with fines" report ( >>> aka circ/branchoverdues.pl ). >>> >>> The reason I ask this is because there is a lot of code I will need to >> add >>> in order to support just this report, and it would be silly to do so if >>> nobody is actively using it. Conversely, removing the report would >> simplify >>> some underlying parts of Koha, which makes for a less bug-prone Koha! >>> >>> Please let me know! >>> >>> Thanks, >>> Kyle >>> >>> http://www.kylehall.info >>> ByWater Solutions ( http://bywatersolutions.com ) >>> Meadville Public Library ( http://www.meadvillelibrary.org ) >>> Crawford County Federated Library System ( http://www.ccfls.org ) >>> Mill Run Technology Solutions ( http://millruntech.com ) >>> _______________________________________________ >>> 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 >> > > -- Bob Birchall Director Calyx Group Pty Limited Mob: 0414 796 988 Email: bob(a)calyx.net.au Web: www.calyx.net.au Participating in the Koha Open ILS project: http://koha-community.org ------------------------------ Message: 7 Date: Tue, 19 Nov 2013 11:51:53 +1300 From: Robin Sheat <robin(a)catalyst.net.nz> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Enable SMS messaging options Message-ID: <1384815113.26996.1.camel@zarathud> Content-Type: text/plain; charset="UTF-8" arihant schreef op ma 18-11-2013 om 05:09 [-0800]: > Right now I have entered "Email" inside the sms send driver preference > which > generates an error in the log that process_message_queue.pl failed due > to > the sms send driver not configured properly. If I keep the sms send > driver > preference empty, I do not see the SMS messaging preference. It sounds like the correct approach would be to write an SMS driver that talks to the HTTP API to send the SMS. -- Robin Sheat Catalyst IT Ltd. ? +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 97, Issue 32 ************************************

1 0

Just finished Koha server - now... how to find database with barcodes for books
by Allyn Baskerville 19 Nov '13

19 Nov '13

Is there a centralized barcode repository for books, to where we can search for a title, author, etc., and import that information directly into Koha and print off the labels to place on the books? I see how this can be done manually, but certainly there is a quicker way to do this. I've gone through the initial setup and downloaded the 3of9 font (http://www.barcodesinc.com/free-barcode-font/) but I'm not sure exactly what to do next to make the next process quicker. Thanks

2 1

Regarding Cataloging
by rocky bang 19 Nov '13

19 Nov '13

Hi koha, I have koha 3.08 and facing problems in cataloging modules. I have cataloged records in koha using excel file being converted into marc file and then uploaded in koha. It was uploaded successfully and now i have to make some changes in the Catalogued item and now i don't have the excel file which i have migrated earlier into marc. As editing single record one by one is a tedious job. So is there any way to take back the excel file from koha with all the fields which i have entered. Thanks in advance.

2 3

Re: [Koha] Rearranging patron page
by Owen Leonard 19 Nov '13

19 Nov '13

> > > I would like to rearrange the patron page. > > > Please be more specific. What page are you talking about, and how do > > you want to rearrange it? > > It's the page where you enter a patron. ...and how do you want to rearrange it? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

2 2

Re: [Koha] Rearranging patron page
by David Roberts 19 Nov '13

19 Nov '13

You need to be a bit cautious about rearranging the add new patron page - we found out (just last week actually!), that Koha appears to like to get the data from the registration form in a certain order. If the library management block is before the patron identity block, you won't be able to add any new users. That may not be true for all versions of the software, so your mileage may vary. Hope this helps David Date: Mon, 18 Nov 2013 11:38:55 -0600 > From: "Jenice S. Tate" <jtate(a)mdah.state.ms.us> > To: Owen Leonard <oleonard(a)myacpl.org> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Rearranging patron page > Message-ID: <528A50AF.4010702(a)mdah.state.ms.us> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > The current arrangement is > > Patron identity > Main address > Alternate addrecc > Library management > Library set-up > OPAC/Staff login > Additional attributes & identifiers > > I would like to change the arrangement to > > Library management > Patron Identity > Main address > Alternate address > Additional attributes & identifiers > Library set-up > > > -- David Roberts Customer Support Consultant. PTFS Europe Ltd. david.roberts(a)ptfs-europe.com Skype: david.roberts.2 http://www.ptfs-europe.com

1 0

Patron/Member Renewal Notice
by Iming Chan 19 Nov '13

19 Nov '13

Dear all, I'm trying to work out a way to generate a patron membership renewal notice (say 60 days before expiration date). If anyone has successfully achieve this, please let me know how this is done. I prefer the notice to be in the format of a letter with latest subscription cost, etc. Then it can be e-mailed (or posted, if no e-mail address recorded) to the patron concerned. Looking forward to your response soon. Kind regards, Iming Chan (Mr.) Translib Information Service Melbourne, Australia ----- Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Patron-Member-Renewal-Notice-tp5778693.ht… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

mapping for marc
by arafat u rahman 19 Nov '13

19 Nov '13

Dear all i am rying to convert exceel to marc please help me by giving me the marc map code for title , author , barcode ,pages ,edition etc.

2 1