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

Holds Queue view_holdsqueue.pl 404 Error
by David Riggs 28 Jan '09

28 Jan '09

I've installed Koha 3.00.00 on Ubuntu 8.04, and when clicking the "Holds Queue" link in the Staff Client, I receive a 404 error trying to display view_holdsqueue.pl. Searching the mailing lists shows several people complaining about this, but no definitive answer as to the cause. Is this the result of some failed part of the installation? Missing cron job? Strangely, I've placed two holds via the OPAC successfully, but when I look in the database, 'select count(*) from tmp_holdsqueue' claims 1 row, and 'select * from tmp_holdsqueue' returns zero rows. Huh?! Can anyone explain what I've botched and how to get a working holds queue? Thanks, - DR -- david a. riggs software engineer, createTank mailto:riggs@createtank.com voice: +1-304-685-7537 fax: +1-800-975-8379 http://createtank.com

1 0

RFC: Koha 3.2 : Split Issuing rules into Circ rules and Circ policies
by Ryan Higgins 27 Jan '09

27 Jan '09

RFC : Split issuingrules into Circ rules and Circ policies Full version : http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_circ_policies Synopsis: The issuingrules table and smart-rules.pl interface currently mix definition of circulation policy with definition of when those policies should be applied. This proposal suggests two distinct interfaces for these operations. Details The issuingrules table currently holds performs two discrete functions: 1. it holds data describing circulation & fines policy, i.e. loan length, maxissues, fine, etc. 2. it describes which transactions should cause those policies to be applied. This RFC proposes that these two data sets be represented in two new tables in the Koha database, circ_rules and circ_policies, which would supercede the issuingrules table (i.e. issuingrules will be dropped). Benefits: 1. Database normalization. as described above. 2. Simplifies interface for those libraries that have many itemtype & borrower categories. 3. Simplifies future enhancements, allowing us to attach other types of policies to a given transaction context, e.g. adding a holds_policies table. Drawbacks: 1. Having the Policies described on a separate page than where they are assigned adds a level of complexity to assignment. This drawback is addressed by including in smart_rules.pl a 'policy lookup' allowing the user to look up any available circ policies, as well as an on-hover display of a policy in the rules display. (see screenshot). Database changes: * circ_rules will include branchcode, itemtype, categorycode and circ_policies_id (and circ_termset_id, see rfc: term loans) * circ_policies will include remaining columns from issuingules, with some cleanup. The patch set will include an updatedatabase patch that will extract repeated policies from the issuingrules table, name them in English with an appropriate description, and assign those policies to the circ_rules table. Please see wiki page for screenshot of interface. http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_circ_policies Comments appreciated. -- Ryan Higgins LibLime * Open-Source Solutions for Libraries Featuring KohaZOOM ILS 888-564-2457 x704

1 0

Bug in "Add to list" feature
by Jason Macki 26 Jan '09

26 Jan '09

Hello, I've recently imported data from our old library system to Koha version 3 on Linux. When someone opens a bibliographic record in the Koha management interface, and clicks "add to list", a popup window appears with the following error: Can't use string ("1") as an ARRAY ref while "strict refs" in use at /usr/share/koha/intranet/cgi-bin/virtualshelves/addbybiblionumber.pl line 101. Does anyone know how I can fix this problem? Thanks very much, Jason

1 0

KohaCon 2009 information about the conference and Registration
by David Schuster 26 Jan '09

26 Jan '09

Forgive the cross posting but trying to make sure I cover as much of the community as possible. KohaCon 2009 Registration KohaCon 2009 will be held in Plano, TX April 16 and 17. This is a FREE conference. There is no registration fee, but we are requesting that all attendees pre-register. Details (travel, hotels, agenda draft, etc) can be found at: Koha WIKI: http://wiki.koha.org/doku.php?id=kohacon2009 There is a "Tentative Schedule" - it will change as more people sign up probably for programs. Travel information along with Hotel accomodation information. Lunch and dinners will be on your own. Feel free to contact any of the three people listed on the Wiki at the top or email me directly. David Schuster -- View this message in context: http://www.nabble.com/KohaCon-2009-information-about-the-conference-and-Reg… Sent from the Koha - Dev mailing list archive at Nabble.com.

1 0

Re: [Koha-devel] adding a model abstraction ?
by Marc Chantreux 23 Jan '09

23 Jan '09

Hi Zeno, On Thu, Jan 22, 2009 at 06:27:21PM +0100, Zeno Tajoli wrote: >> - try to find a way to have an up-to-date diagram class > in fact I and Matteo Romanello we are working on this task. well ... i meant autogenerated diagrams using the introspection features provided by modern OO frameworks like Moose. regards -- Marc Chantreux BibLibre, expert en logiciels libres pour l'info-doc http://biblibre.com

1 0

adding a model abstraction ?
by Marc Chantreux 22 Jan '09

22 Jan '09

hello guys, I just rewritten the C4::Bookseller::AddBookseller and it now looks like: sub AddBookseller { _koha_insert_and_get_id( 'aqbooksellers', shift ); } _koha_insert_and_get_id is a function where i deal with DBI and all specific DBD tricks with reuse in mind. You can see the following code. do i try to push it in koha ? and where ? It sounds like Koha::SQL package. regards sub _koha_insert_and_get_id { # Todo: implement uses of config # like exclude, defaults, ... # $tablename is a string and contains the name of the table # $data is a reference to an hash that contains column names to set as keys # optionnal $config alter default behaviour my ( $tablename, $data, $config ) = @_; my $dbh = C4::Context->dbh; # @fields to insert are all %$data (unless overwritten by $$config{fields} ) my @fields = (defined $config and exists $config->{fields}) ? @{ $config->{fields} } : keys %$data ; # build the query my $query = 'INSERT INTO ' . $tablename .' (' . join(',',@fields) . ') VALUES (' . join(',', map {'?'} @fields) . ');' ; my $sth = $dbh->prepare($query); # deal with the server $sth->execute( @$data{@fields}); if ( $sth->err ) { warn $sth->errstr; return undef; } # return the last id C4::Context->config('db_scheme') eq 'mysql' and return $dbh->{mysql_insertid}; # todo use the last_insert_id dbh function # my $id = $dbh->last_insert_id( ? ); # before give up warn 'database unable to get last inserted id'; return undef; } -- Marc Chantreux http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc

12 32

unimarc mapping to biblioitems.volume inconsistant
by Michael Hafen 22 Jan '09

22 Jan '09

So I'm working on adding a remainderoftitle column to the biblio table. I've been told that in Unimarc 200$e would be a good place to map this column. I'm looking at the French unimarc default framework sql file in the installer, and it seems that biblioitems.volume is already there. Now I look at the english unimarc default framework file, and biblioitems.volume is mapped to 225$v and 200$e is unmapped. I would like it if those who develop on the unimarc framework could resolve this inconsistency. Thank you. -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://koha-dev.washk12.org or git://koha-dev.washk12.org/koha

3 2

Re: [Koha-devel] [Koha] Adding to the circulation template
by Kyle Hall 21 Jan '09

21 Jan '09

Would it be better to add code to Koha so that the list starts with the current year, and gives the next five or ten years in the future? I'll submit a patch if anyone thinks this is a good idea. Kyle http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org ) On Wed, Jan 21, 2009 at 10:52 AM, Owen Leonard <oleonard(a)myacpl.org> wrote: >> How do we get to our >> circulation.tmpl to be able to see this and add the years? >> ... >> <option value="2008" >> selected="selected">2008</option> </select> > > That looks like the right place in the template, but your question > makes it sound like you couldn't find circulation.tmpl? > > I think you should be able to simply add additional <option>s to the HTML: > > <option value="2008" > selected="selected">2008</option> > <option value="2009" > selected="selected">2009</option> > <option value="2010" > selected="selected">2010</option> > <option value="2011" > selected="selected">2011</option> > > -- Owen > > -- > Web Developer > Athens County Public Libraries > http://www.myacpl.org > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

3 2

Advice on managing Git, Branches & Patches
by Kyle Hall 21 Jan '09

21 Jan '09

Hello All, I have some more questions about git. Really, what I'm interested in is how everyone handles fixing bugs and adding new features to koha, and submitting the patches. At the moment I have a private git repo that is up to date with git.koha.org's master branch. I have 5 commits on top of it, representing five new features. I was copying my master branch, adding a feature, then merging back into master, but some strange things were happening. It should have been a straight fast-forward, nothing had changed in master, but instead it seems as if the new commit was being merged in between other commits I had made, does anyone know what happened? To make five patches to submit, I created five branches based on master, then rebased each one leaving only one of the feature commits for each, thus ending up with five patches starting in 0001. Is this a reasonable way to work, or is there a better solution? Also, I submitted all five patches at once, with git send-email, but only four made it through. The 5th patch ended up bouncing back to me with the message CORRUPTED MESSAGE. This has happened to me before, but I found it very odd that it would work fine for 4 out of 5 patches, all submitted with one command. Thanks for the advice, Kyle http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org )

2 1

KohaCon, developer part (1st for David S.)
by paul POULAIN 20 Jan '09

20 Jan '09

Hi all, has a decision be taken about the developer part of the conference ? How long will it last ? will it occur after or before the user conference ? Who will come (seems there will be at least BibLibre and chris C., who else ?) http://wiki.koha.org/doku.php?id=kohacon2009 says nothing about it. I want to buy the air ticket & reserve the hotel, so I need to know (reminder : I'll come with Nahuel, so 2 BibLibre guys) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

3 2