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

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 21 Jan '09

21 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

‡biblios.net now available for free to all
by Nicole Engard 20 Jan '09

20 Jan '09

Fellow catalogers and Koha community members, I have been spending a lot of time these last few months working on getting a new web-based cataloging tool ready for you all. It's finally time! I'd like to invite you to sign up for free and try out ‡biblios.net (www.biblios.net) a community cataloging tool from LibLime. So, what the heck is it? ‡biblios.net is a web-based original and copy cataloging tool with built in federated search of any Z39.50 target (via an integrated search registry with over 2000 targets - or by adding your own) and a large (30 million strong) shared database of catalog records. This means that you can visit ‡biblios.net and benefit from the work of other catalogers who have gone before you. You can also edit and contribute to the database without any restrictions. I have also worked on creating some macros (others can be written by users) to help streamline some of our cataloging processes and templates for common item types to make original cataloging a little bit easier :) Best of all, you can set ‡biblios.net to automatically add records to your Koha system with the click of a button! I'm looking for both novice and professional catalogers to give me their opinions of the tools, services and overall user friendliness of ‡biblios.net. I am of course also looking for people to join the community so that this tool and grow and help us all with our cataloging work. I have worked very closely with the development crew on this new tool and believe very strongly both in it and the ideas behind it. The fact that we all work so very hard on our cataloging makes the fact that the records in ‡biblios.net are freely-licensed under the Open Data Commons (www.opendatacommons.org) all that more appealing. If you want to learn more you can read through the documentation on the site (www.biblios.net) and/or take a peek at this great write up by Jonathan Rochkind: http://bibwild.wordpress.com/2009/01/07/bibliosnet-and-the-future-of-catalo… Thank you so much! I can't wait to hear what you all think!! Nicole C. Engard Open Source Evangelist, LibLime --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce(a)liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel

1 0

authorities question again
by Rafael Antonio 20 Jan '09

20 Jan '09

Dear all I have seen several KOHA 3.0 demos where the page Authority search results allways show 0 biblio records. I have tested and did some links between biblio and authority but it never never changes. Does we need to run any script? Thanks, Rafael Antonio

3 2

About Mail::Sendmail
by Nahuel ANGELINETTI 16 Jan '09

16 Jan '09

Hi people, I'm adding the ability to send shelves by mail. During my addition I find a problem sending by mail: Wide character in subroutine entry This means the data encode_base64() received is too big. I was copying the script from sendbasket, so I tested with sendbasket and a large basket, the same happen. What is the good fix? Use another library that manage this problems? Still using this complicated library and find a solution, like pre-saving the iso2709 in a temporary file and encode as base64? Maybe someone have the solution to my problem? bests, -- Nahuel ANGELINETTI

4 5

how to handle the link back to amazon?
by Nicolas Morin 16 Jan '09

16 Jan '09

Hi there, I want to gather opinions about a possible small change in the way the Amazon covers are handled in the opac on the detailed view of a record. Currently we show the Amazon cover and link back to the product's page on Amazon's web site from the cover itself. Some librarians I talk to are uncomfortable with the idea that their public library will show a link to a (monopolistic (online-only (us-owned (insert-yr-own-fears-here)))) bookseller in such a prominent way : using the whole cover image as a link. At least some of them would be assuaged, I think, by a more discreet link between their opac and Amazon : removing the link from the image itself and providing it through a tiny text just below the image, saying "source : Amazon", might be a solution. See example at http://www.libfly.com/je-suis-une-legende-livre-25918.html What do you think? Nicolas -- Nicolas Morin Mobile: +33(0)633 19 11 36 http://www.biblibre.com

5 6

virtual hosting of Koha
by Han, Yan 16 Jan '09

16 Jan '09

Hello, All, I have been running Koha on a local server, but am testing to virtual host Koha on a commercial server (for example. Bluehost.com) In local server implementation, you need to "make install" to install Koha. In a commercial server, "make install" is not allowed. So does anyone have any luck to run koha in a commercial host? If so, please let me know the configuration changes, and the company's name. It seems that <virtualhost> configuration is not allowed in this commercial server. If Apache env is not allowed to change in this case, how can we setEnv for "perl5lib" and "Koha_conf"? # KOHA's OPAC Configuration <VirtualHost 150.135.239.44:80> ServerAdmin DocumentRoot /data1/koha/opac/htdocs ServerName kobol ScriptAlias /cgi-bin/koha/ "/data1/koha/opac/cgi-bin/" Redirect permanent index.html http://150.135.239.44:80/cgi-bin/koha/opac-main.pl ErrorLog /data1/koha/log/opac-error_log TransferLog /data1/koha/log/opac-access_log SetEnv PERL5LIB "/data1/koha/intranet/modules" SetEnv KOHA_CONF "/etc/koha.conf" </VirtualHost> Thanks, Yan

3 2