October 2009 - Koha-devel - lists.koha-community.org

To mantain documentation on Mysql tables, indexess and relation
by Zeno Tajoli 12 Oct '09

12 Oct '09

Hi to all, as I said in the last IRC meeting, http://stats.workbuffer.org/irclog/koha/2009-09-02#i_295862, as CILEA we are working on mantain dcoumentation on Mysql tables, indexeses and relations. The work done until now is here: http://wiki.koha.org/doku.php?id=en:development:dbschema The instrument used is Schema Spy, http://schemaspy.sourceforge.net/. As I know is the better tool avaible for those works and open source. Well, to create a good documentation Schema Spy needs comments INSIDE definion of Mysql tables. So the SQL command of the table 'action_logs' now is : CREATE TABLE `action_logs` ( `action_id` int(11) NOT NULL auto_increment, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `user` int(11) NOT NULL default 0, `module` text, `action` text, `object` int(11) default NULL, `info` text, PRIMARY KEY (`action_id`), KEY (`timestamp`,`user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; For Schema Spy needs to be: CREATE TABLE `action_logs` ( `action_id` int(10) NOT NULL default '0' COMMENT 'Action ID', `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT 'Timestamp', `user` int(10) default NULL COMMENT 'User', `module` text COMMENT 'Module on which the action was performed', `action` text COMMENT 'Action (e.g., ADD,MODIFY,RETURN, etc.)', `object` int(11) default NULL, `info` text COMMENT 'Info about the action performed', PRIMARY KEY (`action_id`), KEY `timestamp` (`timestamp`,`user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='[sys] Log of actions performed on the system'; So Schema Spy need the command 'COMMENT' with useful information. So, the decision that we need to take: Do we insert the command 'COMMENT' in the basic definition SQL file, the file installer/data/mysql/kohastructure.sql ? Or do we insert the command 'COMMENT' in a specific file ? With the first option is very clear how to document a new develop on SQL, in the file installer/data/mysql/kohastructure.sql. With the second option we have a more standard installer/data/mysql/kohastructure.sql file [COMMENT is a command specific of MySQL] but it is easier to forget to document the new develop. I prefer the first option but there are differents opinion about it. So, please, tell what do you prefer. Bye Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)

5 6

Requests and Due Date Mail trigger
by Sai bhalaji Dhinakaran 12 Oct '09

12 Oct '09

Hi, I have Koha 3.0 running on Ubuntu. I would like to integrate it with our mail server. My requirements are: 1. User must be able to place request from OPAC page, which must drop into the Librarian's mail box. Is it configurable in the existing system or needs some code change? 2. User and the librarian must receive a mail whenever a book issued exceeds the due date. Please let me know if some more details are required to address this requirement. Thanks and Regards, Sai Bhalaji __________ Information from ESET NOD32 Antivirus, version of virus signature database 4498 (20091011) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ________________________________ This email and any attachment(s) transmitted may contain confidential, proprietary or legally privileged information relating to D&B TransUnion Analytic and Decision Services Private Limited. The information is intended solely for the recipient. No part of this information may be disclosed, copied, reproduced, distributed or made available in any form whatsoever without prior authorization. If you have received this email in error please notify the sender electronically and delete all copies immediately. This email may contain viruses. D&B TransUnion Analytic and Decision Services Private Limited has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this email. We strongly advise you to ensure that the email and any attachment(s) are free of any virus.

1 0

OPAC Log-in
by Bob Birchall ＠ Calyx 12 Oct '09

12 Oct '09

Hi all, Is it possible to configure the opac so that a user can perform a search only if logged in? A special library wishes to expose its catalogue to internal eyes only. So the required sequence would be to enter the url, be directed to a log-in page (the way the staff client works) and then when logged in be directed to opac-user.pl (as happens now when you log in from opac-main.pl) How can that be achieved? Thanks, Bob Birchall Calyx

2 1

Koha instal on Debian lenny
by Sébastien Hinderer 09 Oct '09

09 Oct '09

Hi, The SMS::Send that has to be installed through CPAN requires the modules Params::Util and Class::Adapter. The Params::Util module is packaged for lenn in the libparams-util-perl package. This package could hence be added to the install_misc/debian-lenny.packages file. Sébastien.

1 1

Way to limit by 2 locations at the same time
by David Schuster 07 Oct '09

07 Oct '09

is there a way in the OPAC to search 2 locations at the same time? branch:001,901 or something of that nature? David Schuster -- View this message in context: http://www.nabble.com/Way-to-limit-by-2-locations-at-the-same-time-tp257559… Sent from the Koha - Dev mailing list archive at Nabble.com.

2 2

Re: [Koha-devel] Koha-devel Digest, Vol 46, Issue 34
by Provasnik, JoAnn 07 Oct '09

07 Oct '09

Me too. I have started to document how many times a day I have had to log in. Anything you can do to alleviate this would be appreciated. Jo-Ann Provasnik Acquisitions Technician Landman Library at Arcadia University 450 S. Easton Road Glenside, PA 19038-3295 Tel: (215) 572-2137 Fax: (215) 572-0240 e-mail: provasnik(a)arcadia.edu Worldwide Web: http://www.arcadia.edu -----Original Message----- From: koha-devel-bounces(a)lists.koha.org [mailto:koha-devel-bounces@lists.koha.org] On Behalf Of koha-devel-request(a)lists.koha.org Sent: Saturday, September 26, 2009 6:00 AM To: koha-devel(a)lists.koha.org Subject: [Possible SPAM] Koha-devel Digest, Vol 46, Issue 34 Importance: Low Send Koha-devel mailing list submissions to koha-devel(a)lists.koha.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.koha.org/mailman/listinfo/koha-devel or, via email, send a message with subject or body 'help' to koha-devel-request(a)lists.koha.org You can reach the person managing the list at koha-devel-owner(a)lists.koha.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha-devel digest..." Today's Topics: 1. Staff Sessions get timeout'd even though they have been active (Michael Hafen) ---------------------------------------------------------------------- Message: 1 Date: Fri, 25 Sep 2009 12:34:59 -0600 From: Michael Hafen <mdhafen(a)washk12.org> Subject: [Koha-devel] Staff Sessions get timeout'd even though they have been active To: koha-devel(a)lists.koha.org Message-ID: <1253903699.26377.69.camel@koha-dev> Content-Type: text/plain My librarians brought to my attention that they were being logged out of Koha because their session timed out, even though they had been active less than two hours prior ( timeout sys. pref. is set to two hours ). I added a couple warns so I could see when lasttime was updated and when someone was timed out. I saw timeouts on sessions that had been active from 3 seconds to 1 hour 43 minutes prior. pianohacker suggested changing session storage from the database to the filesystem, which seems to have fixed the problem. Has anyone else seen this? I don't want to file a bug if it's just a problem with my setup. Thanks. -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha ------------------------------ _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel End of Koha-devel Digest, Vol 46, Issue 34 ******************************************

4 5

Cannot delete patron category
by Zico 07 Oct '09

07 Oct '09

Hi, I am trying to delete the "Kid" category from my server. As we don`t need to because our library is the university library. When i go to delete "Kid" category, it shows me the error that, "Cannot Delete. This category is used 4 times". I am not sure about those users who are in "Kid" category; but, i am sure that, we don`t need them anyway. So, now, *i want to forcefully delete this "KID" category". *How can i do that? Your any kind of advice is highly appreciable. -- Best, Zico

2 1

A bit of programmer humor :)
by Nicole Engard 07 Oct '09

07 Oct '09

Thought those of you working hard on writing patches would enjoy this little bit of humor: http://geekandpoke.typepad.com/geekandpoke/2009/10/geekpoke-celebrates-part… Nicole

2 1

Open Source ILS Add-ons
by Lori Ayre 07 Oct '09

07 Oct '09

I am preparing for a one hour webinar on Open Source ILS Add-on products. By "ILS Add-on," I mean products that extend the functionality of the ILS and wish seem to fall into three main categories: discovery interface, and metasearch. If you are using, have used or have knowledge of any of the following products, I'd be much obliged if you'd tell me a bit about your experience. Like it? Love it? Using it? Know it is dead? Know something better? You know it works with Koha/Evergreen/anything else? Thanks in advance! Discovery Interface products: SOPAC2 Blacklight Kochief Scriblio VuFind XC Metasearch: LibraryFind Pazpar2 dbWiz ILL: Relais (not quote OSS yet?) PLEIAS

1 0

Re: [Koha-devel] [Koha] New IRC Meeting Tomorrow
by Edward M Corrado 06 Oct '09

06 Oct '09

If the 6 was upsided down it would be better :). Of course this is the problem with trying to get people together from all of the world. It is always 6am somewhere. Edward Sent from my iPhone On Oct 6, 2009, at 4:45 PM, Nicole Engard <nengard(a)gmail.com> wrote: What's wrong with 6am? I'll be there :) On Tue, Oct 6, 2009 at 3:52 PM, Joe Atzberger <ohiocore(a)gmail.com> wrote: On Tue, Oct 6, 2009 at 2:50 PM, Nicole Engard <nengard(a)gmail.com> wrote: Just a reminder the next general IRC meeting will be held on #koha on 7 October 2009 at 10:00 UTC+0 Time Converter: http://www.worldtimeserver.com/meeting-planner-times.aspx?&L0=US-FL&L1=UTC&… Agenda: http://wiki.koha.org/doku.php?id=en:events:meetings:irc_meetings:meetingnot… To confirm, that is: Wed 10/7/2009 6:00 AM EDT (NYC) Wed 10/7/2009 10:00 AM UTC (GMT) Wed 10/7/2009 11:00 AM (UK) Wed 10/7/2009 3:30 PM (India) Wed 10/7/2009 11:00 PM (NZ) Being that makes it 6AM for me (and earlier for other US TZs), I'll don't think I'll be able to join you all. Have a good session! --joe _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0