Re: [Koha] Report help
Hi Kerrie, I think adding AND s.branch =Branch|branches will do what you're looking for. So the whole SQL statement would be: SELECT concat(b.surname,', ',b.firstname) AS name, count(s.borrowernumber) AS checkouts FROM statistics s LEFT JOIN borrowers b USING (borrowernumber) WHERE s.datetime BETWEEN Top checkouts BETWEEN (-mm-dd)|date AND and (-mm-dd)|date AND s.branch =Branch|branches GROUP BY s.borrowernumber ORDER BY count(s.borrowernumber) DESC LIMIT 20 That is, assuming each campus library is defined as a separate branch in Koha, of course. Hope this helps! Steve -Original Message- From: Kerrie Stevens [mailto:kstev...@harvest.edu.au] Sent: Tuesday, October 14, 2014 12:29 AM To: koha@lists.katipo.co.nz Subject: [Koha] Report help Hi Everyone, I've been using the report 'Patrons with most checkouts in date range' with success, but when I try to modify it to allow me to select which campus library the patrons are from so I can get a top 20 list for any of our campus libraries, I can't get it to work - can anyone help me with this? SELECT concat(b.surname,', ',b.firstname) AS name, count(s.borrowernumber) AS checkouts FROM statistics s LEFT JOIN borrowers b USING (borrowernumber) WHERE s.datetime BETWEEN Top checkouts BETWEEN (-mm-dd)|date AND and (-mm-dd)|date GROUP BY s.borrowernumber ORDER BY count(s.borrowernumber) DESC LIMIT 20 Thank you! Kerrie Stevens COLLEGE LIBRARIAN Harvest Bible College ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Enable PHP in OpacMainUserBlock
We've done this by having a script generate HTML for the covers each night and using javascript to include it on the page. You can also use an iframe to pull in content from a different page. This is useful if you don't have access to PHP on the server on which Koha is installed. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] A Road Map for Koha
1. To maintain a road map for Koha - that is not time based. 2. The road map is to address both features and architecture. 3. The monthly general meeting following each major release will consider updates to the road map. 4. However maintenance of the road map can be a continuous process. If I don’t make it to the IRC meeting here are my thoughts: A roadmap sounds like something that could spark useful discussion on where we want to go. I have no problem with the current way of doing things, but I do occasionally get the feeling that I don’t see the big picture of what’s planned and down what path that development is taking Koha. Sometimes decisions get taken just by small stuff like adding a nifty little feature that makes our users expect even more features in the that area. I do see scenarios where a roadmap/central planning of development could become a problem, but from the description it sounds like a good idea. Therefore we propose two new roles in the community release team. These are roles that could be effectively filled by librarians (one for each role, or a team), allowing developers to keep developing. _Wiki Curator_ - a lot of work needs to be done to clean up the wiki; - could also participate (with some developers) in updating the wiki technology; - the role is not seen as a controller of wiki content or as being required to approve content, rather it is a curation task: moving stuff around, keeping it tidy, collaborating with the wiki contributors (So, looking at stuff and asking: Is this correct? Does it need to be updated? Should it be moved? Renamed? etc) _Communication Manager_ - promote the project and its achievements; - gather press releases and stories; - liaise closely with the newsletter editors (Chad and JD); - update the koha-community.org website; - send items to Marshall Breeding or other distribution sites; - write articles or twist the arms of others who might write articles. Both these two areas could use a boost so I approve. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Hackmeeting in Italy: Segrate (MI) 13-14/Nov/2014
Nice initiative Zeno, I hope it'll be a success. The more people testing patches and working on translations, the better. Best wishes, Bob Birchall Calyx On 15/10/14 00:49, Zeno Tajoli wrote: Hi to all, my firm, Cineca, has decide to organize an hackmeeting on Koha. The hackmeeting will be in Segrate very near Milan. We probably work on: -- last tests of incoming 3.18 -- transaltion of the manual (3.16) -- how to use sandboxes, wiki, mailinglist, etc. No problem if you don't speak Italian, we try to use english as much as possible. Timetable: 13/Nov 09.30 - 17.30 14/Nov 09.30 - 17.30 Arrive. You can arrive in Stazione Centrale of Milan, than you go to Repubblica station with metro 3 (yellow line) and you take Passante train direction to Pioltello or Treveglio. You go down to Segrate station, you can arrive to you buildign by foot. Our address is Via R. Sanzio 4 - Segrate. Here a map from google maps: http://www.hpc.cineca.it/content/how-reach-cineca-milan Sleeping We suggest to reserve an Hotel in Milan near metro. If you came I can send same suggestions. If you want to came and you need more info, write me. - Here a more long advice in italian Hackmeeting Koha 13 e 14 Novembre 2014 Due giorni dedicati allo sviluppo e alla traduzione della manualistica in lingua italiana di Koha: lavoriamo insieme per rendere Koha sempre più vicino alle esigenze del mondo bibliotecario italiano! Per unirvi a noi, prendete parte al primo hackmeeting in Italia organizzato da Cineca il 13 e il 14 novembre prossimi. HACKMEETING: COS'E'? Nella tradizione del software open, un Hackmeeting è un momento in cui utenti, sviluppatori e persone interessate in genere si ritrovano per vedersi, parlarsi, scambiarsi idee e lavorare insieme. E' quindi un'occasione per condividere esperienze e fare qualcosa insieme. CHI PUO' PRENDERVI PARTE? Tutti sono i benvenuti! Per la partecipazione infatti non vi sono prerequisiti, basta essere interessati a Koha e aver voglia di impegnarsi e confrontarsi con altri. Per lavorare al meglio, ci si dividerà in piccoli gruppi che svolgeranno attività su specifici argomenti, decisi in base all'interesse e al background dei partecipanti. Si affronteranno quindi sia argomenti tecnici che non. DOVE COME QUANDO? Dove: presso la sede del Cineca di Segrate, Milano, in via r. Sanzio 4. Il CINECA metterà a disposizione la sede, un laboratorio IT, una sala riunioni e la rete wi-fi. Come: ciascuno lavorerà sul proprio pc portatile (consigliamo che abbia già installata una versione di Koha recente). Se non avete possibilità di portarlo, nessun problema! Segnalatelo al momento della registrazione e provvederà Cineca a fornirvi gli strumenti per partecipare. Quando: giovedì 13 e venerdì 14 novembre. Inizieremo sempre la mattina alle 9:30. Le attività si concluderanno al pomeriggio, indicativamente entro le 17:30. ARGOMENTI? Decidiamoli insieme! L'obiettivo è migliorare insieme Koha perché sia sempre più adatto all'Italia. Si svilupperà, si tradurrà il manuale, si guarderanno insieme le problematiche al momento presenti nella versione più recente e si vedrà come risolverle. Indicazioni utili per la partecipazione -- Suggeriamo a tutti di portare il proprio pc portatile con già sopra un'installazione Koha funzionante; -- Tutte le iniziative saranno principalmente in lingua italiana con eventuale uso dell'inglese in caso di presenza di ospiti stranieri; -- La sede di Cineca di Segrate (MI) sita in via R. Sanzio 4. è a pochi minuti a piedi dalla fermata del Passante Ferroviario (linee S5 e S6). Se arrivate alla Stazione Centrale di Milano, prendete la metro 3 (gialla), arrivate a Repubblica, prendete uno dei treni in direzione Pioltello o Treviglio, scendete alla stazione di Segrate. Da li a piedi è molto vicino. Una mappa di aiuto è qui: http://www.hpc.cineca.it/content/how-reach-cineca-milan -- La partecipazione è aperta a tutti ma i posti sono limitati! E' necessario registrarsi per tempo inviando un email direttamente a Zeno Tajoli (z.taj...@cineca.it). In caso di sovrannumero, potrebbero non essere accettate tutte le richieste. -- All'atto della registrazione vi possiamo dare consigli sugli hotel dove soggiornare. Bye all -- Bob Birchall Director Calyx Group Pty Limited Mob: 0414 796 988 Email: b...@calyx.net.au Web: www.calyx.net.au Participating in the Koha Open ILS project: http://koha-community.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Extra Records
Hello, Mr Olugbenga Adara, Thanks for your solution. It worked liked a charm. I am now able to import records from the reservoir into Koha through the cataloguing module. Thank you so much. I also tried Bob Birchall solution too but did not know how to log into the Koha instance, create the instance as Z39.50 server and import the records. I failed and I think its mainly because of my limited knowledge. I will continue trying. Thanks a million though On 15 October 2014 07:57, Chrispin Simasiku Sitali libsit...@gmail.com wrote: Hi Mr Olugbenga, I am very fine. I will try your solution and inform you of the outcome the course of the day On 15 October 2014 05:55, Olugbenga Adara gbengaad...@gmail.com wrote: Hi Crispin, How are you doing? On Tue, Oct 14, 2014 at 5:54 AM, Chrispin Simasiku Sitali libsit...@gmail.com wrote: Greetings Koha Community, I am at my wits end. I have a marc file with 10 000 records on it. I want to have this in my Koha installation for searching only. I am currently cataloguing some books and I want to use this for searching through only, if I find a marching record for a particular book then I import it in my collection. When I finish cataloguing I then delete the collection because I may not need it any more Please how do I go about it. I believe what you need to do is to get the MARC records staged for import but not actually complete the import. Then when you make a search in the cataloging module, you should get a hit from the reservoir which would have the records you staged for import. Go to Tools Stage MARC records for import then import the file, don't follow through with the last step of importing into the catalog. Once done with the cataloging, go to Tools Staged MARC management and you should be able to clean the records from the reservoir. Hope this helps. -- Olugbenga Adara Skype: gbengaadara -- Charles Lwanga College of Education, P. O. Box 660193, Monze, ZAMBIA. Mobile: +26 0979 869471 +26 0966 869471 SKYPE: Libsitali -- Charles Lwanga College of Education, P. O. Box 660193, Monze, ZAMBIA. Mobile: +26 0979 869471 +26 0966 869471 SKYPE: Libsitali ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] A Road Map for Koha
On 15/10/14 14:15, BWS Johnson wrote: Could this be like the QA team and bug wranglers? That is, what are people's thoughts on having more than one person working on cleaning the wiki? In my opinion, more people is more good. A designated leader is not a bad thing though, to help make sure things move along. Bob ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Extra Records
There's often more than one way to do things. Olugbenga's solution is quicker and easier. I'm glad it worked for you. Bob On 16/10/14 00:26, Chrispin Simasiku Sitali wrote: Hello, Mr Olugbenga Adara, Thanks for your solution. It worked liked a charm. I am now able to import records from the reservoir into Koha through the cataloguing module. Thank you so much. I also tried Bob Birchall solution too but did not know how to log into the Koha instance, create the instance as Z39.50 server and import the records. I failed and I think its mainly because of my limited knowledge. I will continue trying. Thanks a million though On 15 October 2014 07:57, Chrispin Simasiku Sitali libsit...@gmail.com wrote: Hi Mr Olugbenga, I am very fine. I will try your solution and inform you of the outcome the course of the day On 15 October 2014 05:55, Olugbenga Adara gbengaad...@gmail.com wrote: Hi Crispin, How are you doing? On Tue, Oct 14, 2014 at 5:54 AM, Chrispin Simasiku Sitali libsit...@gmail.com wrote: Greetings Koha Community, I am at my wits end. I have a marc file with 10 000 records on it. I want to have this in my Koha installation for searching only. I am currently cataloguing some books and I want to use this for searching through only, if I find a marching record for a particular book then I import it in my collection. When I finish cataloguing I then delete the collection because I may not need it any more Please how do I go about it. I believe what you need to do is to get the MARC records staged for import but not actually complete the import. Then when you make a search in the cataloging module, you should get a hit from the reservoir which would have the records you staged for import. Go to Tools Stage MARC records for import then import the file, don't follow through with the last step of importing into the catalog. Once done with the cataloging, go to Tools Staged MARC management and you should be able to clean the records from the reservoir. Hope this helps. -- Olugbenga Adara Skype: gbengaadara -- Charles Lwanga College of Education, P. O. Box 660193, Monze, ZAMBIA. Mobile: +26 0979 869471 +26 0966 869471 SKYPE: Libsitali -- Bob Birchall Director Calyx Group Pty Limited Mob: 0414 796 988 Email: b...@calyx.net.au Web: www.calyx.net.au Participating in the Koha Open ILS project: http://koha-community.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Extra Records
Using MarcEdit: +Open the file +Search for the records you want +Copy and paste in a new window/document in Marceditor +Compile +Import to Koha Saludos, Adalid Ortiz Biblioteca Loyola http://www.loyola.tij.uia.mx Koha OPAC http://clavius.tij.uia.mx This message was sent using IMP, the Internet Messaging Program. -- Este correo electronico puede contener informacion confidencial y privilegiada, por lo que se prohibe el uso, reproduccion, retransmision o divulgacion no autorizada, parcial o total, de su contenido. Si usted no es el destinatario del presente correo, por favor notifiquelo al remitente mediante reenvio a su correo electronico y borrelo de inmediato. Para conocer el aviso de privacidad le pedimos acceder a la siguiente liga: http://www.iberotijuana.edu.mx/?doc=/avisoprivacidad/index.html -- Los acentos han sido removidos intencionalmente para facilitar la lectura del mensaje independiente a la codificacion del mismo. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] How to delete items with no barcode...
Dear Sir, I have some items in my koha database with no barcodes. Please help me to delete these items and records also. I am using koha 3.12 on ubuntu. regards. -- Jatinder K. Samyal, ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] e-books management with Koha @ NIT Rourkela
Dear All, We are managing NIT Rourkela e-books collections with Koha, ILMS. It is very simple and useful for the enhancement of usages statistics of electronic resources. Kindly look into the below website and feel free to contact if need any assistance for the same in your libraries. http://opac.nitrkl.ac.in/cgi-bin/koha/opac-main.pl http://opac.nitrkl.ac.in/cgi-bin/koha/opac-search.pl?limit=mc-itype%3AEBsort_by=pubdate_dscaddto=Add+to...biblionumber=50loggedinuser Thanking You. With regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishrav...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to delete items with no barcode...
Tools - Batch item deletion will accept a file of itemnumbers. You can use a report to help get the list of itemnumbers. The tool also allows you to delete empty records when deleting those items. You can also delete them manually from the edit items page if you don't have a lot. On Wed, Oct 15, 2014 at 12:23 AM, jksamyal jksam...@gmail.com wrote: Dear Sir, I have some items in my koha database with no barcodes. Please help me to delete these items and records also. I am using koha 3.12 on ubuntu. regards. -- Jatinder K. Samyal, ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Can't get jquery scripts to work in koha
Hello Marty, On Sat, Oct 11, 2014 at 11:11 PM, Marty Jongepier marty.jongep...@gmail.com wrote: snipped So I tried something else, and found in the koha jquery library a script by Nicole C. Engard (and I am convinced she KNOWS what she is doing) to change the text of the OPAC login form. I pasted that into the opacuserjs system preference, and that did not do anything either. Just for reference, I pasted that in here as well (see end of message). Nicole's script works perfectly fine. This is what you are tripping over http://www.standardista.com/javascript/15-common-javascript-gotchas/#linebreaks You had copy-pasted the code... right? You need to remove the line-break after Log in to and the code will work :-) $(document).ready(function(){ $(#auth legend:contains('Log in to your account')).text(Log in to your library account); $(#auth label[for='userid']).html(Library Card Number:); $(#auth label[for='password']).html(PIN:);}); cheers -indra -- Indranil Das Gupta Phone : +91-98300-20971 Blog: http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha