- Koha - lists.katipo.co.nz

Report Help - Extracting XML
by Nicole Engard 29 Jul '11

29 Jul '11

Hello all, I need some report assistance. I want to add the summary (520a) to this report: select count(statistics.datetime) as circs, CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.title,'</a>') AS Title, CONCAT('<a href=\"http://mycatalogv/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'\">http://catalog.losgatosca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'</a>') as URL, biblio.author, items.location from statistics join items on (items.itemnumber=statistics.itemnumber) left join biblio on (biblio.biblionumber=items.biblionumber) where DATE(statistics.datetime) Between <<Date between (yyyy-mm-dd)>> and <<and (yyyy-mm-dd)>> and statistics.itemnumber is not NULL and location = <<Shelving Location Code>> group by biblio.biblionumber order by circs DESC Limit 10 Can someone make some suggestions?

3 8

Seeking Koha Newsletter Editor
by Nicole Engard 29 Jul '11

29 Jul '11

Community members, In case you missed it in the most recent newsletter (July 2011) I am resigning my post as newsletter editor and am currently seeking someone to fill my position. I have held this post for 1.5 years and am unable to continue managing both the manual and the newsletter (and of course all the other stuff I do). The new editor will take over for the August issue and continue at least through December 2012. That will be a 1.5 year term (as mine has been). If you would like to volunteer please do so at the next Koha meeting or place your proposal on the agenda if you cannot attend the meeting. Thanks Nicole C. Engard

8 8

ILS open sources
by Jonson philip 29 Jul '11

29 Jul '11

hi i'm going to create a document about Integrated Library Systems in open sources , any one can helps me by official list of open sources ILS . thank's

3 3

Problems Column in Inventory
by Nicole Engard 29 Jul '11

29 Jul '11

Can anyone tell me what the last column that shows on the shelf listing for the inventory tool is for? It is labeled as 'Problems' but I have never seen anything but 'None' under that - and I've tested on a lot of systems. What would a problem be? What is being reported by this column? Nicole

2 2

Seeking Cosponsors for Bug 2720 - Fines that debar automatically, should undebar automatically when paid.
by Liz Rea 28 Jul '11

28 Jul '11

NEKLS is seeking cosponsors for the development to fix Bug 2720 - Fines that debar automatically, should undebar automatically when paid. We will be working with ByWater Solutions on the development, should we get adequate cosponsorship. If you are interested in helping us out, please contact either NEKLS at nexpresshelp(a)nekls.org, or ByWater Solutions at staff(a)bywatersolutions.com to express your interest in cosponsoring. Be sure to put in your message "interested in cosponsoring bug 2720 - fines that debar should undebar automatically when paid." Looking forward to working with you! Liz Rea lrea(a)nekls.org

2 2

someone using XITI for OPAC ?
by Paul Poulain 28 Jul '11

28 Jul '11

Hi, Is there someone using xiti services to have stats on the OPAC ? We have one customer trying to use it, it does not work, and we don't understand why (the library uses xiti for other softwares, it fails only for koha) Any help/idea warmly welcomed !!! -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Fwd: Re: Quick Consensus
by Rémi NEDELEC 28 Jul '11

28 Jul '11

Dear Lee Philips, I am Remi Nedelec, company "Aesis Conseil", France and we got a mail from Paul Poulain about your needs in terms of public computer management system. Our society provides such a solution called WebKiosk. WebKiosk offers your users a highly secure Internet access and tools which are adapted to your library. Here are the features : - a simple, pleasant and intuitive web-based control panel with users rights management - works as a stand-alone client or in conjunction with a print release terminal - works in conjunction with koha (full compatibility) - scheduled or immediate computer reservation - time allocation management - free third party Internet-filtering software SquidGuard - both Ubuntu 10.04 LTS Server and Desktop Edition - and more ! WebKiosk is not translated in us/english language yet. The translation file is easy to make though. Indeed, we split the language file from the application so we can easily add a language support. You should contact us at informations(a)aesis-conseil.com to tell us more details about your needs. @Biblibre : thanks for the information ! Cordially, | Remi Nedelec | +(33) 9 63 46 97 15 | rnedelec(a)aesis-conseil.com | http://www.aesis-conseil.com -------- Message original -------- Sujet: Re: [Koha] Quick Consensus Date : Thu, 28 Jul 2011 11:31:16 +0200 De : Paul Poulain <paul.poulain(a)biblibre.com> Pour : koha(a)lists.katipo.co.nz, lphillips(a)buttepubliclibrary.info Copie à : informations(a)aesis-conseil.com, "philippe.Chabanon_Biblibre.com" <philippe.chabanon(a)biblibre.com> Le 27/07/2011 20:39, Lee Phillips a écrit : > Hello all, > Looking at a public computer management system- choices are Envisionware > or Pharos. We run Koha and Unbuntu. Thoughts on best match and best > support/service? > Lee in Butte, Montana Hi Lee, Here in France, BibLibre is parterning with aesis-conseil, a company that has developped an OpenSource public computer management system. I don't know if they work in english though. Just FYI, i've cced them HTH (Aesis = I met Lee at KohaCon09 and 10, she's an awesome librarian ;-) ) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Quick Consensus
by Lee Phillips 28 Jul '11

28 Jul '11

Hello all, Looking at a public computer management system- choices are Envisionware or Pharos. We run Koha and Unbuntu. Thoughts on best match and best support/service? Lee in Butte, Montana

4 3

How to use my customized feature in all versions of Koha
by devendratapdia 28 Jul '11

28 Jul '11

Hi, I will like to use my customized feature in all versions of Koha. So I have few questions regarding the same. 1) Whether I can add my feature as a plug-in to Koha Versions? 2) Does Koha has plug-in architecture like Eclipse? -Devendra Tapdia -- View this message in context: http://koha.1045719.n5.nabble.com/How-to-use-my-customized-feature-in-all-v… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Using my customized Feature in all versions
by Devendra Tapdia 28 Jul '11

28 Jul '11

Hi, I will like to use my customized feature in all versions of Koha. So I have few questions regarding the same. 1) Whether I can add my feature as a plug-in to Koha Versions? 2) Does Koha has plug-in architecture like Eclipse? -Devendra Tapdia

1 0