- Koha - lists.katipo.co.nz

need an sql report to count notices
by Saira Asghar 14 Mar '15

14 Mar '15

Dear All Is there any sql report that can count how many notices are being sent in a specific period of time? -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: saira.asghar(a)namal.edu.pk

2 1

iPad checkouts in Koha
by Chad Roseburg 14 Mar '15

14 Mar '15

We are going to start circulating iPads this month and had a question about circ rules. How would you set up a circ rule that would: * checkout for 2 hours - Once overdue, immediately: * Suspend the patron's account * Charge replacement costs Anyone else checking out iPads? What's your experience been and how do you handle checkouts, fines ...etc? Thank you! -- Chad Roseburg Automation Dept. North Central Regional Library

2 2

Fw: Please add us as new Paid Support for Asia - Philippines
by Mark Tompsett 13 Mar '15

13 Mar '15

Greetings, I notice Mirko's entry was added nearly immediately. Please add the following. I am included in the us, though as a silent technical partner. GPML, Mark Tompsett -----Original Message----- From: Manuel Tamayao Sent: Wednesday, February 04, 2015 12:18 AM To: koha(a)lists.katipo.co.nz Subject: [Koha] Please add us as new Paid Support for Asia - Philippines Good day Koha Community, Please add us as a new paid support for Philippines Company Name: Tulong Aklatan Contact Person: Manuel Tamayao Contact email: tulongaklatan(a)gmail.com Home: Pinagkaisahan, Makati City, Philippines Website: www.tulongaklatan.ph Short description of your services: We offer training, installation, support, migration, and hosting solutions for Koha. Salamat po, Manny Tamayao _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Fwd: Custom pages un Koha
by Viktor.Sarge＠regionhalland.se 13 Mar '15

13 Mar '15

Forwarding if anyone else is interested in the CMS functions. I’d like to see it develop further and for example create navigation without having to code your own. Maybe some kind of widget system for the customizable areas of the Opac as well so we can hide some of the raw code stuff of pasting things into systems parameters? > Hi! > > This page on the wiki might help you out: Koha as a CMS. http://wiki.koha-community.org/wiki/Koha_as_a_CMS I’ve been successfully using it to create pages integrated into the Opac and sharing the same header. There is a plugin ”Koha as CMS” as well that you could try that does the same thing. > > For creating the navigation I recommend having a look at the section ”Tabbed navigation” at http://www.myacpl.org/koha/new-opac-theme-bootstrap/ It’s highly useful. > > Kind regards/Viktor > > > Viktor Sarge > Utvecklingsledare > Regionbibliotek Halland > Kultur i Halland > > TFN: 035-17 98 73 > E-POST: Viktor.Sarge(a)regionhalland.se > BESÖKSADRESS: Södra vägen 9, 30180 Halmstad > WEBB: www.regionhalland.se/regionbibliotek > > > > > > > > > > > 12 mar 2015 kl. 19:05 skrev Ahmad Amanullah Khan <ahmadamanullahkhan(a)gmail.com>: > >> Hi All >> >> Can any body help me out.. >> >> We need to add some custom content pages in our koha and we want that opac >> header remains same on all page navigations. >> >> We are using the latest koha version. >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >

4 3

OBID-FEIG RFID
by vikram zadgaonkar 13 Mar '15

13 Mar '15

Dear Friends, Does any one using OBID(FEIG) RFID products with koha?

1 0

possible error at staff interface
by 毛慶禎 13 Mar '15

13 Mar '15

Hi, I found a possible error at staff interface. Home › Administration › System preferences at Administration preferences Login options timeout It read as: Automatically log out users after____ seconds of inactivity. Adding d will specify it in days, e.g. 1d is timeout of one day. In fact it should read as: Automatically log out users after____ milliseconds of inactivity. Adding d will specify it in days, e.g. 1d is timeout of one day. Use milliseconds replace seconds. Refer to Koha manual, please http://manual.koha-community.org/3.4/en/administration.html 1.2.3.5. timeout Automatically log out users after ___ milliseconds of inactivity. Wishing you all the best. . . . Anthony Mao 毛慶禎 mao AT lins.fju.edu.ＴＷ Department of Library and Information Science Fu Jen Catholic University http://bit.ly/lins No.510, Zhongzheng Rd., Xinzhuang Dist., New Taipei City 24205 Taiwan ＋886 2 29052334

4 4

database error
by etaisil ineseliam 12 Mar '15

12 Mar '15

I have installed koha using instance name library, but when i try to browse to its IP it shows this It works! This is the default web page for this server. The web server software is running but no content has been added, yet. and when I look at the database, the my library instance does not have any tables in it. Please can you show me what Im doing wrong here! thanks in advance. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | koha_library | | koha_library1 | | mysql | | performance_schema | +--------------------+ 5 rows in set (0.00 sec) mysql> use koha_library; Database changed mysql> show tables; Empty set (0.00 sec)

4 7

Re: [Koha] removing marc records
by Cathi Wiggins 12 Mar '15

12 Mar '15

To edit or remove a batch of marc records that don't have barcodes or item records, but when there is the ability to create a full, accurate list based on other fields--creation date, call number, collection code, etc.--the records could be edited to add the 952 field and/or then copy the record number to the barcode field 'p' so they may be manipulated with the batch tools. We had imported a group of MARC records that didn't have barcodes, and BWS was able to copy the record number into the barcode field for us so we could further edit the records using the batch modification tool. -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: Thursday, March 12, 2015 1:53 PM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 113, Issue 20 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: database error (Mark Tompsett) 2. Re: removing marc records (Owen Leonard) 3. Support status on CentOS or RedHat (Jose-Marcio Martins) 4. Re: Support status on CentOS or RedHat (Ahmad Amanullah Khan) 5. Custom pages un Koha (Ahmad Amanullah Khan) 6. Re: Support status on CentOS or RedHat (Mark Tompsett) 7. Re: How to join aqorders and suggestions (Humberto Blanco Castillo) 8. Fwd: Custom pages un Koha (Viktor.Sarge(a)regionhalland.se) 9. Re: Fwd: Custom pages un Koha (Indranil Das Gupta) 10. Re: Custom pages un Koha (adalid(a)tij.uia.mx) ---------------------------------------------------------------------- Message: 1 Date: Thu, 12 Mar 2015 06:49:34 -0400 From: "Mark Tompsett" <mtompset(a)hotmail.com> To: "Robin Sheat" <robin(a)catalyst.net.nz> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] database error Message-ID: <BLU172-DS2190FEF7C62CCAD43C468AC6060(a)phx.gbl> Content-Type: text/plain; format=flowed; charset="utf-8"; reply-type=original Greetings, etaisil ineseliam schreef op do 12-03-2015 om 18:08 [+1300]: > Ive done the DNS one but I also disabled default site. but now i got > the "system is down for maintenance page" Robin Sheat wrote: > However, you should be able to sudo koha-enable library -- library.conf (arg to annoying Apache 2.2 vs 2.4 things) > ... I thought it was enabled by default but I could be wrong, I should > check that and update the docs accordingly. It may be their first time installing and the DB may not be populated. If I'm wrong, I blame just waking up. :) GPML, Mark Tompsett ------------------------------ Message: 2 Date: Thu, 12 Mar 2015 11:32:35 -0400 From: Owen Leonard <oleonard(a)myacpl.org> To: koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] removing marc records Message-ID: <CAO4qe2Mk5ktNavftfhYL3XzPohz4cez7VFJ76bVG+DEqYEEovw(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 > But in koha you have to use > barcode or item number for batch deletion. Is there any way this marc > record file can be used? As far as I know the answer is no, you can't use a MARC file to delete records. We are frequently in the same situation and I wish this was possible. If there was a unique identifier in each record you might be able to construct a report which would return barcodes which could be batch deleted. Otherwise I think you're stuck searching for and deleting records one by one. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ------------------------------ Message: 3 Date: Thu, 12 Mar 2015 17:50:10 +0100 From: Jose-Marcio Martins <Jose-Marcio.Martins(a)mines-paristech.fr> To: koha(a)lists.katipo.co.nz Subject: [Koha] Support status on CentOS or RedHat Message-ID: <5501C3C2.5040603(a)mines-paristech.fr> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hello, We're upgrading our current installation of Koha. We'd like to do it on a CentOS box. Most of our boxes are under RedHat or Fedora or CentOS. And I saw at some page of the wiki how to do it. My question is about the support status on CentOS. Someone told us that 99.9 % of Koha instances run on Debian (and derivatives) and it's absolutely unsure that it will run on CentOS or RedHat. Do you discourage using Koha on CentOS ? Just discourage ? Strongly discourage ? No support on CentOS ? Thanks for your answer. Regards Jos?-Marcio -- Envoy? de ma machine ? ?crire. --------------------------------------------------------------- Spam : Classement statistique de messages ?lectroniques - Une approche pragmatique Chez Amazon.fr : http://amzn.to/LEscRu ou http://bit.ly/SpamJM --------------------------------------------------------------- Jose Marcio MARTINS DA CRUZ http://www.j-chkmail.org Ecole des Mines de Paris http://bit.ly/SpamJM 60, bd Saint Michel 75272 - PARIS CEDEX 06 ------------------------------ Message: 4 Date: Thu, 12 Mar 2015 22:34:06 +0500 From: Ahmad Amanullah Khan <ahmadamanullahkhan(a)gmail.com> To: Jose-Marcio Martins <Jose-Marcio.Martins(a)mines-paristech.fr> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Support status on CentOS or RedHat Message-ID: <CAGo9-o=WEvbqpwh6xKyFdB+XwPA4-k2oUB+Gugo+UW9nMpe4eQ(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 We are using koha on centos without any issues. Not sure about support. On Mar 12, 2015 9:52 PM, "Jose-Marcio Martins" < Jose-Marcio.Martins(a)mines-paristech.fr> wrote: > > Hello, > > We're upgrading our current installation of Koha. > > We'd like to do it on a CentOS box. Most of our boxes are under RedHat or > Fedora or CentOS. > > And I saw at some page of the wiki how to do it. > > My question is about the support status on CentOS. > > Someone told us that 99.9 % of Koha instances run on Debian (and > derivatives) and it's absolutely unsure that it will run on CentOS or > RedHat. > > Do you discourage using Koha on CentOS ? Just discourage ? Strongly > discourage ? No support on CentOS ? > > Thanks for your answer. > > Regards > > Jos?-Marcio > > > -- > > Envoy? de ma machine ? ?crire. > --------------------------------------------------------------- > Spam : Classement statistique de messages ?lectroniques - > Une approche pragmatique > Chez Amazon.fr : http://amzn.to/LEscRu ou http://bit.ly/SpamJM > --------------------------------------------------------------- > Jose Marcio MARTINS DA CRUZ http://www.j-chkmail.org > Ecole des Mines de Paris http://bit.ly/SpamJM > 60, bd Saint Michel 75272 - PARIS CEDEX 06 > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ Message: 5 Date: Thu, 12 Mar 2015 23:05:38 +0500 From: Ahmad Amanullah Khan <ahmadamanullahkhan(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] Custom pages un Koha Message-ID: <CAGo9-o=3-TpYqyzc0wqozH4fZP78Cm9HZcP13a7WFGMEEDc9FA(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Hi All Can any body help me out.. We need to add some custom content pages in our koha and we want that opac header remains same on all page navigations. We are using the latest koha version. ------------------------------ Message: 6 Date: Thu, 12 Mar 2015 14:05:04 -0400 From: "Mark Tompsett" <mtompset(a)hotmail.com> To: "Jose-Marcio Martins" <Jose-Marcio.Martins(a)mines-paristech.fr> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Support status on CentOS or RedHat Message-ID: <BLU172-DS486FA2438939ADFEBFAB7C6060(a)phx.gbl> Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Greetings, The largest problem with running under a non-Debian-based distribution of Linux, such as RedHat variants, is support. The first headache you will encounter is installing the required libraries. Last I checked, it was around 18 or so of them require installation magic beyond a default installation on CentOS and/or Fedora. The second headache you will encounter is when you hit a problem, you may discover it is because of your non-Debian OS, because they did it differently that what the coders of Koha encountered using Debian-based OSes. Additionally, you may find only a few of people who use RedHat to run it, and they may or may not respond in a timely fashion to your problems. Debian, in particular, and Debian-based variations (Ubuntu is another popular one) are your best bet for finding support, and having a less painful installation. So is RedHat discouraged? Yes, why would we encourage headaches which we generally don't have the time to solve, because we mostly use Debian-based OSes? However, we believe in freedom, and if you wish to take on the mantle of pain, feel free. More power to you. :) For a more painful experience port it to run natively in Windows. ;) GPML, Mark Tompsett P.S. I did actually attempt the Windows, but gave up because the pain was worse than CentOS and Fedora. I only attempted them to see if it could be done, and yes, I was successful eventually. I don't recommend trying, unless you are seasoned Linux administrator. ------------------------------ Message: 7 Date: Thu, 12 Mar 2015 14:23:12 -0500 From: Humberto Blanco Castillo <hblancoca(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] How to join aqorders and suggestions Message-ID: <CAM9yoEXiL8kVNsfGSDQbu-GsE8KO7s_74aZtU=Ogj9qxxX5WhQ(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 hi, the poblem its here using record fusion for biblio with the same data, then i have the same biblio in many sugestions and orders. 2015-03-11 12:19 GMT-05:00 Mark Tompsett <mtompset(a)hotmail.com>: > Greetings, > > According to http://schema.koha-community.org/tables/suggestions.html, > there is comment on the biblionumber field: > "foreign key linking the suggestion to the biblio table after the > suggestion has been ordered". > > So, > SELECT * FROM suggestions WHERE biblionumber IS NULL; > is going to list all the suggestions which are NOT ordered. > > I know this isn't the answer you are looking for, but it should help you > find the correct direction. > > GPML, > Mark Tompsett > > -----Original Message----- From: Humberto Blanco Castillo > Sent: Wednesday, March 11, 2015 12:38 PM > To: koha(a)lists.katipo.co.nz > Subject: [Koha] How to join aqorders and suggestions > > > Hi, > How can i make teh correct relation between aqorders and suggestions? I > need to do a report but is not posible join correctly those tables. > > Any idea??? > > > -- > Cordialmente, > > > Humberto Blanco > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Cordialmente, Humberto Blanco ------------------------------ Message: 8 Date: Thu, 12 Mar 2015 19:37:25 +0000 From: <Viktor.Sarge(a)regionhalland.se> To: <Koha(a)lists.katipo.co.nz> Subject: [Koha] Fwd: Custom pages un Koha Message-ID: <968FBBED-BFC3-43E7-AF18-33066471975A(a)regionhalland.se> Content-Type: text/plain; charset="Windows-1252" Forwarding if anyone else is interested in the CMS functions. I?d like to see it develop further and for example create navigation without having to code your own. Maybe some kind of widget system for the customizable areas of the Opac as well so we can hide some of the raw code stuff of pasting things into systems parameters? > Hi! > > This page on the wiki might help you out: Koha as a CMS. http://wiki.koha-community.org/wiki/Koha_as_a_CMS I?ve been successfully using it to create pages integrated into the Opac and sharing the same header. There is a plugin ?Koha as CMS? as well that you could try that does the same thing. > > For creating the navigation I recommend having a look at the section ?Tabbed navigation? at http://www.myacpl.org/koha/new-opac-theme-bootstrap/ It?s highly useful. > > Kind regards/Viktor > > > Viktor Sarge > Utvecklingsledare > Regionbibliotek Halland > Kultur i Halland > > TFN: 035-17 98 73 > E-POST: Viktor.Sarge(a)regionhalland.se > BES?KSADRESS: S?dra v?gen 9, 30180 Halmstad > WEBB: www.regionhalland.se/regionbibliotek > > > > > > > > > > > 12 mar 2015 kl. 19:05 skrev Ahmad Amanullah Khan <ahmadamanullahkhan(a)gmail.com>: > >> Hi All >> >> Can any body help me out.. >> >> We need to add some custom content pages in our koha and we want that opac >> header remains same on all page navigations. >> >> We are using the latest koha version. >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ Message: 9 Date: Fri, 13 Mar 2015 01:23:29 +0530 From: Indranil Das Gupta <indradg(a)gmail.com> To: koha <Koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Fwd: Custom pages un Koha Message-ID: <CAEm3SZ2q4cdV=Fb5pB23assQx_CAUB7tP2qAqNEM2P+kRE4niw(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Hi, On Fri, Mar 13, 2015 at 1:07 AM, <Viktor.Sarge(a)regionhalland.se> wrote: > There is a plugin ?Koha as CMS? as well that you could try that does the > same thing. The plugin code is here - https://github.com/l2c2technologies/KohaCMS/releases/tag/v1.2 I've not worked on it for some time. So it may need some work in order to work. cheers -- 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 ------------------------------ Message: 10 Date: Thu, 12 Mar 2015 13:52:17 -0700 From: adalid(a)tij.uia.mx To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Custom pages un Koha Message-ID: <20150312135217.17708481dm4mb9ts(a)tij.uia.mx> Content-Type: text/plain; charset=UTF-8; DelSp="Yes"; format="flowed" This "Plugin" or some similar feature can be implemented in the opac user account after login to add pages/urls to protected resources? How? FAOA Biblioteca Loyola http://www.biblioteca.iberotijuana.edu.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. ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 113, Issue 20 *************************************

1 0

Re: [Koha] How to join aqorders and suggestions
by Humberto Blanco Castillo 12 Mar '15

12 Mar '15

hi, the poblem its here using record fusion for biblio with the same data, then i have the same biblio in many sugestions and orders. 2015-03-11 12:19 GMT-05:00 Mark Tompsett <mtompset(a)hotmail.com>: > Greetings, > > According to http://schema.koha-community.org/tables/suggestions.html, > there is comment on the biblionumber field: > "foreign key linking the suggestion to the biblio table after the > suggestion has been ordered". > > So, > SELECT * FROM suggestions WHERE biblionumber IS NULL; > is going to list all the suggestions which are NOT ordered. > > I know this isn't the answer you are looking for, but it should help you > find the correct direction. > > GPML, > Mark Tompsett > > -----Original Message----- From: Humberto Blanco Castillo > Sent: Wednesday, March 11, 2015 12:38 PM > To: koha(a)lists.katipo.co.nz > Subject: [Koha] How to join aqorders and suggestions > > > Hi, > How can i make teh correct relation between aqorders and suggestions? I > need to do a report but is not posible join correctly those tables. > > Any idea??? > > > -- > Cordialmente, > > > Humberto Blanco > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Cordialmente, Humberto Blanco

1 0

Custom pages un Koha
by Ahmad Amanullah Khan 12 Mar '15

12 Mar '15

Hi All Can any body help me out.. We need to add some custom content pages in our koha and we want that opac header remains same on all page navigations. We are using the latest koha version.

1 0