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

availability of a reserved item
by Paul POULAIN 05 Nov '08

05 Nov '08

Hello, If I don't mind, a book that has a hold on it is, in koha 3.0, displayed as "available" in OPAC. That sound strange, and a bug to me. Am I missing something, or does it have to be fixed ? -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc NOUVEAU TELEPHONE : 04 91 81 35 08

8 15

Fwd: [RFC: DBIx::Class 2/3] DBix::Class - moving C4::ClassSource over to using DBIx::Class
by Adam Thick 04 Nov '08

04 Nov '08

Hi All, Andrew thought it would be a good idea to forward this onto the list to get some discussion going about the use of DBIx::Class in Koha. I sent him an email about it's use, I think it's a great idea! Cheers, Adam T. Begin forwarded message: > From: "Andrew Moore" <andrew.moore(a)liblime.com> > Date: 31 October 2008 12:46:06 AM > To: "Adam Thick" <adam.thick(a)strategicdata.com.au> > Subject: Re: [Koha-devel] [RFC: DBIx::Class 2/3] DBix::Class - > moving C4::ClassSource over to using DBIx::Class > > Hi Adam - > > Thanks for taking the time to look over the patch and make your > comments. I'm glad that you agree that something like this would help > Koha. I'm hopeful that I can get it refined enough to get it accepted. > I think you and I agree on a lot of the points you brought up. Let me > hit a few of them one at a time: > > On Wed, Oct 29, 2008 at 7:47 PM, Adam Thick > <adam.thick(a)strategicdata.com.au> wrote: >> I also think it would be a really good fit for Koha to >> standardise the calls to the database and ensure the SQL is >> sanitised. >> I'd love to one day see Koha as a set of objects, like Koha::Member >> or >> Koha::Biblio, where Koha has attributes that can be handed round to >> each >> object, and each object with it's own set of attributes and methods >> to get >> things done, ah but one day! > > Yes, I'd like to make many of the C4::* packages into classes of > objects, and probably inherit properties from a base class, too. I > think that's a step that will be easier to take after this one, > though. Joe Atzburger and I have been playing with a few different > possibilities, so stay tuned for proposals along those lines. If you > have an example implementation of this, I encourage you to send it > along to the koha-devel list to gauge the community response. > >> I'd recommend creating the DBIx::Class schema with detailed column >> information and inflator/deflators for things like dates and such >> as a start >> too. This is time consuming to go back and add later, and having >> this kind >> of information helps create SQL from your schema and provide >> upgrade scripts >> :) > > That's a good point. In the improvements that I've made since Friday, > I'm using the Schema::Loader to make files that represent each of the > tables, instead of loading them to memory each time. In them, I'm > inflating dates, but nothing else. What else should I be inflating? > >>> my $sources = GetClassSources(); >>> @@ -91,13 +94,11 @@ foreach my $cn_source (sort keys %$sources) { >>> sub GetClassSources { >>> >>> my %class_sources = (); >>> - my $dbh = C4::Context->dbh; >>> - my $sth = $dbh->prepare_cached("SELECT * FROM >>> `class_sources`"); >>> - $sth->execute(); >>> - while (my $source = $sth->fetchrow_hashref) { >>> - $class_sources{ $source->{'cn_source'} } = $source; >>> + >>> + my @class_sources = $schema->resultset('ClassSources')- >>> >search(); >>> + foreach my $row ( @class_sources ) { >>> + $class_sources{ $row->get_column('cn_source') } = { >>> $row->get_columns }; >>> } >>> - $sth->finish(); >>> >>> return \%class_sources; >>> >> >> I found rather than using arrays to store the search in it was a >> bit faster >> ( cause your not loading up an array of data ) and syntactically >> prettier to >> get a result set like this >> >> my $class_sources = $schema->resultset('ClassSources')->search(); >> while ( my $row = $class_sources->next() ) { >> $class_sources->{$row->cn_source} = $row->get_columns >> #not sure if this can be called on a cursor or not, might want to >> look at >> something like >> http://search.cpan.org/~ash/DBIx-Class-0.08010/lib/DBIx/Class/ResultClass/H… > > I'm not a DBIC expert, but I tried sometime similar to that at first > and then switched to my method for some reason. I think it was so that > I could get ahold of the ->columns call. I was probably overlooking a > call like the one you show. I'm sure that we'll get better at using > DBIC as we go along. I'll depend on folks like you to help us use it > better. > >> I am really, really happy that database abstraction is being >> considered for >> Koha. It will mean the code base will be easier to maintain and can >> potentially make database upgrading easier too. I'd like to know if >> you are >> considering a MVC approach to Koha ( in the long run :) I've been >> running >> with Catalyst for a while now too and find that it's great for >> separation >> between Controller, Model and View and definitely makes maintenance >> and >> coding easier. Separating out the code like this also means we can >> re-purpose elements like the Model to perform other tasks like >> providing a >> webservice :) or cron scripts etc... > > I'd like to switch to something like Catalyst at some point, but > that's a pretty long-term goal. If you have any ways to help move in > that direction, I encourage you to share them with us. The roadmap > that I'm working on kind of goes along the lines of: > * abstract out the SQL using DBIC or maybe SQL::Abstract or > DBIx::Abstract > * improve the database upgrade tools by relying on something like > SQL::Translator and DBIx::Class::Schema::Versioned > * start making packages into classes. Maybe use something like Moose? > * Move to something like Catalyst or whatever is good by this point > in time. > > I'm glad that you and I seem to be in agreement on the kinds of things > that would make Koha easier to use, maintain, and extend. Please don't > hesitate to contribute your thoughts (or patches!) to the koha-devel > list. > > Thanks! > -Andy Adam Thick Strategic Data Pty Ltd Ph : +61 (3) 9340-9000 Fax: +61 (3) 9348-2015 Mob: 0404 032 763 Email: Adam.Thick(a)StrategicData.com.au Web: http://www.StrategicData.com.au/ Post: P.O. Box 1166 Carlton, VIC 3053 Australia

1 0

Congratulations to Rosalie Blake
by Chris Cormack 04 Nov '08

04 Nov '08

Hi all Just wanted to bring to the community's attention the fact that Rosalie Blake (the Head librarian at Horowhenua Library trust, and a massive reason why Koha exists) was just awarded a lianza fellowship. Lianza is the Library and Information association of NZ Aotearoa, and a fellowship is the highest honour they bestow. The article on the lianza site is http://www.lianza.org.nz/development/awards/professional/2008-recipients.ht… And I did a quick blog post at http://blog.bigballofwax.co.nz/2008/11/03/rosalie-blake-is-now-a-lianza-fel… So huge congrats to Rosalie and all her team at Horowhenua Library trust, may they always continue their trail blazing ways :) Chris

4 3

configuration files for Debian packaging 1/3 (servers and ports)
by Vincent Danjean 04 Nov '08

04 Nov '08

Hi, As I've a few free time, I'm trying to complete a first version of Debian Koha packaging. I've a few questions for koha/zebra/.. guru that I separate in 3 mails. Here is the first mail. If I understand correctly, a working koha server run several process (apache2, mysqld, ...) and some of them can be run on different machine (apache2 and mysql is the most obvious example). I need some help to correctly identify all the involved processes and to know, for each of them, the configuration files under /etc/koha used and the port(s) they are listening on if any. So, here is my guesses: * apache2 run on the 'main' machine. Would it be possible to setup opac and intranet on different machines ? (I think yes if the configuration is duplicated and koha-http.conf adapted) Port used: __WEBSERVER_PORT__, __WEBSERVER_PORT_LIBRARIAN__ Koha config files needed: koha-conf.xml koha-httpd.conf * mysqld can run on another machine (__DB_HOST__) Port used: __DB_PORT__ Koha config files needed: None * zebrasrv must run on the same machine as apache ? (in this case, opac and intranet cannot be separated) Or *** <listen id="biblioserver" >unix:__ZEBRA_RUN_DIR__/bibliosocket</listen> <listen id="authorityserver" >unix:__ZEBRA_RUN_DIR__/authoritysocket</listen> *** can be changed to point to another machine ? Started with misc/bin/koha-zebra-ctl.sh ? Port used (if SRU is enabled): ZEBRA_SRU_HOST:ZEBRA_SRU_BIBLIOS_PORT and ZEBRA_SRU_HOST:ZEBRA_SRU_AUTHORITIES_PORT Can SRU really be not enabled ? I see nothing in Makefile.PL to disable it. ZEBRA_SRU_HOST must be localhost or the hostname of the machine, must not it ? Port used (if PAZPAR2 is enabled): __MERGE_SERVER_PORT__ Koha config files needed: koha-conf.xml (again ? => which part of the file is needed by koha and which part be zebra ?) zebradb/* * pazpar2 can be run on another machine ? (__PAZPAR2_HOST__) Started with misc/bin/koha-pazpar2-ctl.sh Port used: __PAZPAR2_PORT__ Koha config files needed: pazpar2/* * zebraidx must be run on the same machine as zebrasrv ? Port used: None Koha config files needed: koha-conf.xml (again ?) zebradb/* So, if any guru can confirm/answer to my guesses, it would be easier for me to manage the configuration files without messing up all things and allowing a flexible koha installation on Debian. Best regards, Vincent -- Vincent Danjean GPG key ID 0x9D025E87 vdanjean(a)debian.org GPG key fingerprint: FC95 08A6 854D DB48 4B9A 8A94 0BF7 7867 9D02 5E87 Unofficial pacakges: http://www-id.imag.fr/~danjean/deb.html#package APT repo: deb http://perso.debian.org/~vdanjean/debian unstable main

5 5

Binding journal option iin koha 3
by mallikarjun dora 04 Nov '08

04 Nov '08

HI All, we are planning to switch to koha 3 , we have practice to bind the old journal but in koha 3 , i didn t find that option. if there , please guide me how it? thanks

1 0

RFC: Common base for Koha table operations
by Joe Atzberger 03 Nov '08

03 Nov '08

Koha's DB interfacing in C4 is very procedural and full of repetitive code for basic table operations. We haven't enforced a strict naming convention, or an argument style, so the result is predictably confusing. The arguments are frequently recognized by position, so you have to remember which is which, and how many, like: GetItem(undef,$barcode) GetItem($itemnumber,undef,1) C4::Table manipulates table data in a completely OO way, with the same argument style regardless of which table is being accessed. There is no reason that we should have to code a new Get_XXX_by_YYY function or add a new positional argument to existing Get_XXX functions every time we want to be able to query efficiently against a given field. We should be able to do that from the start. For example: use C4::Table; my $table = C4::Table->new('items'); my $set1 = $table->select({barcode => $barcode}); my $set2 = $table->select({itemnumber => $itemnumber}); Please note that this is not designed as a substitute for true DBI abstraction (like DBIx::Class) or other more sophisticated OO layers. It doesn't build composite objects from multiple JOIN statements or that kind of thing. But it does make all Koha table data immediately available to API queries with comparison (=, >, <, >=, <=) to any field, sortable +/- by any field, and LIMITable to a given value. I'll sending the small proof-of-concept patch for a C4::Table with an example test script (a good place to start). This approach is still experimental, so it does not supplant any production code. Please review and feedback. --Joe Atzberger, LibLime

1 0

Re: [Koha-devel] [Koha] Congratulations to Rosalie Blake
by BWS Johnson 03 Nov '08

03 Nov '08

Salvete! >Just wanted to bring to the community's attention the fact that >Rosalie Blake (the Head librarian at Horowhenua Library trust, and a >massive reason why Koha exists) was just awarded a lianza fellowship. > >Lianza is the Library and Information association of NZ Aotearoa, and >a fellowship is the highest honour they bestow. >The article on the lianza site is >http://www.lianza.org.nz/development/awards/professional/2008-recipient s.html A hearty congratulations for the well deserved recognition! (And many more awards to you in future ;) Cheers, Brooke

1 0

Help me.
by sony george 01 Nov '08

01 Nov '08

I am using Fedora 9 and I have downloaded koha v.3.0 and installed Koha, also installed the dependencies of perl, setup the mysql database. never add any changes in apache server. my problem is simple - how to run this application..? note:- there is no such directory[/cgi-bin/koha] found after installation.. if somebody can help me please.. Sony George Cochin.

2 1

configuration files for Debian packaging 3/3 (default configuration)
by Vincent Danjean 31 Oct '08

31 Oct '08

Hi, As I've a few free time, I'm trying to complete a first version of Debian Koha packaging. I've a few questions for koha/zebra/.. guru that I separate in 3 mails. Here is the third mail. Most of the koha configuration (mostly what is asked by Makefile.PL) will be handled by debconf. I needed to know for the following questions if there is a sensible default to the question. Debconf offers to setup a default answer and we also have to setup the level of the question. On a typical basic installation, only question of level 'high' will be asked (other will get the default value). Debconf levels are: * low Very trivial items that have defaults that will work in the vast majority of cases; only control freaks see these. * medium Normal items that have reasonable defaults. * high Items that don't have a reasonable default. * critical Items that will probably break the system without user intervention. So, here are my propositions/questions Using zebra or not: will be selected by the choice of the packages (koha-zebra or koha-nozebra) MARC format for Zebra indexing Default: UNIMARC ? Level: high ? [1] Primary language for Zebra indexing Default: en ? Level: high ? [1] Authorities indexing mode Default: dom ? Level: medium ? [is not dom more powerful than grs1?] Enable SRU? Default: no ? Level: medium ? SRU Database host? (only if SRU is enabled) Default: localhost ? Level: low ? SRU port for bibliographic data? (only if SRU is enabled) Default: ? Level: high ? [2] SRU port for authority data? (only if SRU is enabled) Default: ? Level: high ? [2] Enable Pazpar2 ? Default: no ? Level: medium ? Zebra bibliographic server host? (only if Pazpar2 is enabled) Default: localhost ? Level: low ? Zebra bibliographic port for PazPar2 to use? (only if Pazpar2 is enabled) Default: ? Level: high [2] PazPar2 host? (only if Pazpar2 is enabled) Default: localhost Level: low ? PazPar2 port? (only if Pazpar2 is enabled) Default: ? Level: high ? [2] [1]: if you tell me in the previous mail (mail 2/3) that it is easy to switch from a setup to the other one, then I will lowered the level to 'medium' [2]: if you can give me sensible default port, then the level can be lowered to 'low' So, if any guru can confirm/answer to my guesses, it would be easier for me to manage the configuration files without messing up all things and allowing a very easy default koha installation on Debian. Best regards, Vincent -- Vincent Danjean GPG key ID 0x9D025E87 vdanjean(a)debian.org GPG key fingerprint: FC95 08A6 854D DB48 4B9A 8A94 0BF7 7867 9D02 5E87 Unofficial pacakges: http://www-id.imag.fr/~danjean/deb.html#package APT repo: deb http://perso.debian.org/~vdanjean/debian unstable main

3 4

Re: [Koha-devel] availability of a reserved item
by Adrea Lund 31 Oct '08

31 Oct '08

Our public library is in the process of migrating from Follett to KOHA with Liblime's help and we would like to contribute to the discussion re: how reserved items are listed in the catalog. Our current ILS, Follett, displays the status of items as "on hold" as soon as a patron or staff member place a hold on an item and it stays that way until the patron who placed the hold checks it out or the hold is cancelled. We would like to see the same thing in KOHA. While testing out our migrated data in KOHA, I actually made a note abouts "holds" showing up as "available" in both the staff client and the OPAC, and I added this to my list of potential "bugs" to mention to our project manager Beverly. I'm glad to see that this is being discussed. In our public library we see no reason not to display the true status of items that are "on hold." The suggestion "not currently on shelf" seems too confusing for patrons and staff. We agree with Susan Bennett's comment - "We try to give our patrons the best customer service possible so I'm for giving them more complete information." In our opinion, items on hold need to say clearly in the OPAC and staff client that they are "on hold", or we could be looking all over the library for them and they would be sitting on the hold shelf. I have come across another problem related to holds... I'm not sure if this is the right place to bring it up, but I'll describe it anyway. When I go to place a hold in KOHA's OPAC or using the staff client, and I want a particular volume of a multi volume set - for example our library has the DVD set for "Deadwood the complete second season"- KOHA shows you specific volume info on the material details page, but then when you click on "place hold" that info is gone. You can't tell one volume of the set from another, which is a problem if perhaps you have disc 1 and want disc 2 which is checked out by someone else. In the staff client you at least get a barcode, but unless you've previously written the barcode down of the volume you want, you are out of luck. This problem could be solved by including volume info on the page where you "place a hold on a specific copy." Thanks, Adrea Adrea Lund Head of Adult Services Grand County Public Library 257 E. Center St. Moab, UT 84532 435-259-1111 ext11

3 2