- Koha - lists.katipo.co.nz

Re: [Koha] Possible APP development
by Miller, Tim 23 Apr '14

23 Apr '14

Hi Sue, I like your ideas and think you have pin-pointed some good functionality and features that are useful and desirable to the typical library user. However, I'd encourage you to design a great mobile OPAC rather than a native app. Koha's mobile layout has already done a lot of the work for you (and my library isn't on 3.14 yet, but it sounds like the Bootstrap OPAC theme is even better). Requiring folks to download a native app often seems like a novel approach, but in many respects it is unnecessary and can be a stumbling block for users. A native app takes up space on the device, requires learning a new interface (and learning how to download an app- which isn't an easy task for every user), and app updates require user authorization. A web-based app (mobile-optimized OPAC) can offer the same functionality and provide access to the catalog without requiring new downloads or learning a new interface (when constructed well). In fact, a good web site's mobile and desktop layouts will be similar enough so that the user has very little to learn. You can figure out how to store the user's password (HTML5 localStorage?)- or even offer a video/web tutorial to teach your users about how to store passwords in browsers. This would teach users a skill that will be useful in many applications (and teach to online security, to boot). Any features already in the OPAC are available to the mobile user, so your work is almost done. Web apps can also be used across devices and operating systems- a good website already works on any device. Even the absolute best native apps require different programs for each OS and often for different devices/OS versions (e.g. a need for separate iPhone and iPad apps). The workload to develop a set of native apps (to avoid ignoring a segment of your user base) is far bigger than for developing a great web app. The most time-consuming aspect of creating a web app is in making the interface user-friendly. Since this is the most important part of developing an app (no one wants to use an unusable app!), that is a great place to put your efforts and resources- and you'll end up with a great product. Almost all of your bullet points are already available in the OPAC and those that aren't should be in the desktop website as well, anyway. All of those should be developments in Koha. One aspect that a native app can offer which a web-based app cannot is offline work. However, that would be incredibly messy with users trying to renew items and cancel holds. What if the app didn't update the ILS in time to avoid fines? Is that the fault of the library or patron? In many ways, creating an app that allows time-sensitive functions while offline is not optimal from a customer service point of view. This is, of course, all my humble opinion, but there are many great arguments about choosing which way to go- http://mashable.com/2012/09/12/web-vs-native-apps/ http://www.wired.com/2012/11/native-apps-vs-mobile-web/ http://uxmag.com/articles/native-or-web-based-selecting-the-right-approa ch-for-your-mobile-app And I'd be very interested in helping with developing a mobile web app that meets your goals! I've already worked with optimizing our library's mobile OPAC (http://sometimesmotion.wordpress.com) and am chomping at the bit to work on the Bootstrap theme :) Tim Miller Library Technician College of the Redwoods Library 7351 Tompkins Hill Rd. Eureka, CA 95501-9300 (707) 476-4256 -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Sue McMillan Sent: Wednesday, April 09, 2014 1:21 PM To: koha(a)lists.katipo.co.nz Subject: [Koha] Possible APP development Hello everyone, After a brainstorming session this morning I have come up with the idea of an Apple and Android app that give users the ability to manage their Koha account without signing in the library catalogue. Not knowing the limitations of apps (so I may be asking for too much!) these are the features that I feel patrons would find useful in a Koha app. There may be other crucial tasks that I haven't listed below that other libraries or patrons would find useful. 1. The app keeps the patron signed in (probably by entering their Library card number and password into the app) 2. Lists all resources currently issued to their card (or maybe the ones due in the next x number of days?) 3. Alerts patrons to resources that are coming up overdue. 4. Gives the patron the ability to renew books from the app, with a single swipe or click 5. Alerts the patron to Holds that come available for pickup 6. Gives the patron the ability to delete the hold with a single swipe or click and at the same time alerts the library via an email or something that the book is no longer needed. 7. Gives the patron the ability to contact the library via the app. 8. Gives the patron he ability to review a resource and leave a star rating (if this is enabled in the catalogue). 9. And the nice to have would be the ability to have something like amazon recommendations "Patrons who read this book also read.....) I would imagine patrons would want the ability to download the app for free from the Google play or iTunes store. Is there any library interested in such a development and a developer with the skills to undertake the project? Or possibly someone is already working on this. Regards Susan McMillan Cataloguing and Systems Administrator| South Taranaki District Council 105-111 Albion St, Hawera 4610 | Private Bag 902, Hawera 4640, NZ Phone: +64 6 278 0555 | Cell: | www.southtaranaki.com This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorised and may be illegal. Please note that this communication does not designate an information system for the purposes of the Electronic Transactions Act 2002. _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

7 11

Barcode Text Size
by Binu Thomas 23 Apr '14

23 Apr '14

Hello Is anyone aware of the Barcode text sixe issue in Koha. It is also listed as Bug No. 10762 in Bugzilla. I have tried printing barcode labels on Koha 3.14.05 and increasing the text size doesnot have any effect on the printed barcodes i.e. the barcode no. that comes below the barcode. Can anyone help me on this? Binu

1 0

What is a "reservoir"
by zolot 23 Apr '14

23 Apr '14

Greetings, What is a "reservoir" and the name of reservoir's file ? (Koha 3.14.) Gennady

13 14

Re: [Koha] Dewey Number does not show up for Items even though available in 082a Tag.
by Mahesh Angadi 23 Apr '14

23 Apr '14

Dear Satish, Tag 082a stores content of class number of bibliographic record. Tag 952o stores contens of class numbr of items attached to bibliographic record. At the time of import, it is advisble to import class number data at both tags, 082 and 952. This is a major reason that many times only catalogue record gets imported and item (holding) details such as class number are not imported. Further, all item details should appear in one single line record at the time of import using MARCEDIT. If it appears on separate line, item data on each line will be imported as separate item. -- Mr. Mahesh M. Angadi, Librarian, Model College, Dombivli (E). Contact No. 9869120258, (0251) 2470010.

2 1

Dewey Number does not show up for Items even though available in 082a Tag.
by SATISH 23 Apr '14

23 Apr '14

Hello, I am working with Koha 3.14 on Ubuntu ( installed via packages) I have a strange behaviour, reg- class number display. I am updating Dewey Number in 082a field for a record. and after adding multiple items to the same record, items do not show up Dewey Class number in OPAC or in Normal View. I would like to know, why it is happening? For fixing this, I am doing, "edit items in batch" and updating dewey once again at "full call number" for all the items. then it displays in opac. How to avoid this ? Do we have any settings koha? with thanks. Satish MV Librarian Govt. Engineering College Hassan, Karnataka. --

3 2

Re: [Koha] Empty shelves
by Paul A 22 Apr '14

22 Apr '14

At 08:57 AM 4/22/2014 -0400, Katelyn Browne wrote: >Hi Paul, >Not sure if you've solved this yet--we've been on spring break! I got your >report to work by changing the order of the tables joined together. By >pulling from authorised_values first (and joining everything to that), you >get all possible location values rather than just the ones that appear in >biblioitems. Hi Katelyn, Many thanks for your reply. With a little assistance and some refining, we ended up with a good working solution (in fact biblioitems was an unnecessary complication) : SELECT authorised_value AS Auth_Location, COUNT(items.itemnumber) FROM authorised_values LEFT JOIN items ON (authorised_values.authorised_value=items.location) WHERE authorised_values.category LIKE 'loc' GROUP BY authorised_value HAVING COUNT(DISTINCT(items.itemnumber))=0; Best regards and again thanks, Paul >Here's a report that worked for me: > >SELECT authorised_values.authorised_value AS Auth_Location, >COUNT(DISTINCT biblioitems.biblionumber) as Quantity >FROM authorised_values >LEFT JOIN items ON (authorised_values.authorised_value=items.location) >LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) >WHERE authorised_values.category LIKE 'loc' >GROUP BY authorised_values.authorised_value HAVING COUNT(DISTINCT >biblioitems.biblionumber)=0 > >--Katelyn. > > >Katelyn Browne >Middle/High School Librarian >Capital City Public Charter School >100 Peabody Street NW >Washington, DC 20011 >(202) 387-0309 x1745 ><mailto:kbrowne@ccpcs.org>kbrowne(a)ccpcs.org >http://www.ccpcs.org/library/ > > >On Wed, Apr 16, 2014 at 11:40 AM, Paul A ><<mailto:paul.a@navalmarinearchive.com>paul.a(a)navalmarinearchive.com> wrote: >Help requested, please -- the MySQL part of my brain is obviously not at >the right caffeine level. > >Over the years, we have used a lot of "shelves" (authorized values, mostly >temporary boxes) and now I need to identify the "empty" ones as a >cleanup/caretaking excercise. > >The following SQL query works syntactically, and finds any shelf with at >least one item: > >SELECT authorised_values.authorised_value AS Auth_Location, >COUNT(DISTINCT biblioitems.biblionumber) as Quantity >FROM biblioitems >LEFT JOIN items ON (items.biblioitemnumber=biblioitems.biblioitemnumber) >LEFT JOIN authorised_values ON >(authorised_values.authorised_value=items.location) >WHERE authorised_values.category LIKE 'loc' >GROUP BY authorised_values.authorised_value HAVING COUNT(DISTINCT >biblioitems.biblionumber)>0; > >but if I change the final >0 to =0 it fails to find any empty box ;={ > >I'm sort-of convinced that this comes from JOINing the >authorised_values.authorised_value to the items.location (obviously that >location no longer exists in items), but am going in circles looking for >an alternate method. > >Thanks in advance -- Paul > > >_______________________________________________ >Koha mailing list <http://koha-community.org>http://koha-community.org ><mailto:Koha@lists.katipo.co.nz>Koha(a)lists.katipo.co.nz ><http://lists.katipo.co.nz/mailman/listinfo/koha>http://lists.katipo.co.nz/mailman/listinfo/koha > --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

1 0

Empty shelves
by Paul A 22 Apr '14

22 Apr '14

Help requested, please -- the MySQL part of my brain is obviously not at the right caffeine level. Over the years, we have used a lot of "shelves" (authorized values, mostly temporary boxes) and now I need to identify the "empty" ones as a cleanup/caretaking excercise. The following SQL query works syntactically, and finds any shelf with at least one item: SELECT authorised_values.authorised_value AS Auth_Location, COUNT(DISTINCT biblioitems.biblionumber) as Quantity FROM biblioitems LEFT JOIN items ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN authorised_values ON (authorised_values.authorised_value=items.location) WHERE authorised_values.category LIKE 'loc' GROUP BY authorised_values.authorised_value HAVING COUNT(DISTINCT biblioitems.biblionumber)>0; but if I change the final >0 to =0 it fails to find any empty box ;={ I'm sort-of convinced that this comes from JOINing the authorised_values.authorised_value to the items.location (obviously that location no longer exists in items), but am going in circles looking for an alternate method. Thanks in advance -- Paul

2 1

SQL Report..
by Jerwyn Fernandez 22 Apr '14

22 Apr '14

Good day! I would like to make an SQL report that can provide me the follow information: Barcode (952$p) Title(245$a) Remainder of the Title(245$b) Author(245$c) Target Audience Note((521$a) Reading Level(526$c) Call Number Prefix(942$k) Is there anyone can help me with my dilemma. I am looking forward regarding with this matter. Thank you, *BE AMAZING. BE SOUTHVILLE.* Jerwyn G. Fernadez, RL Basic Education Librarian Southville International School and Colleges Tel: 825-6374 loc.117/146 *Like us https://www.facebook.com/sisc.monarchs <https://www.facebook.com/sisc.monarchs>* *Follow us https://twitter.com/SISCMonarchs <https://twitter.com/SISCMonarchs>* * www.southville.edu.ph <http://www.southville.edu.ph/>* * https://www.youtube.com/watch?v=CEeXh3JyXRg <https://www.youtube.com/watch?v=CEeXh3JyXRg>* *http://library.southville.edu.ph*<http://library.southville.edu.ph>

1 0

Get Listed Paid Support Request
by Carlos Rodrigo Cordova Sandoval 22 Apr '14

22 Apr '14

*Company Name: Open Geek Service* *Contact Person: Carlos Córdova* *Contact email: ccordova(a)opengeek.cl <ccordova(a)opengeek.cl>* *Website: http://www.opengeekservice.cl <http://www.opengeekservice.cl/>* *Telephone: *+569 6668 32 94 *Address: Don luis manuel de zañartu 567, Puente Alto. Chile* *Short description of your services: We have two strong lines, one of them is the OPAC software, and the other, infraestructure and platform services based on Red Hat portfolio products.* *We work with VuFind and KOHA, and we implemented catalogs and services of these products in Chile, South America.* *http://www.opengeekservice.cl/sitio/bibliotecas/koha.html <http://www.opengeekservice.cl/sitio/bibliotecas/koha.html>* -- -Carlos

2 1

we want alert system for new edition of books
by Ashok Gangurde 21 Apr '14

21 Apr '14

Dear sir, We have a list of books in excel format. we want update or check the latest edition of particular books frequently. There is any software or online website it will give us an alert system that new edition came in the market. kindly do the needful Thanks Ashok Gangurde

2 1