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

Offline Module
by C W Nel 13 Mar '08

13 Mar '08

Can anyone tell me if the offline module (part of koha-tools) is functional? Is it usable in practise? Thanks for any info.

4 4

git.koha.org server change
by Galen Charlton 13 Mar '08

13 Mar '08

Hi, The public git repository, gitweb, and gitstats running on git.koha.org will be moved to a new server later today, and consequently the DNS entry for git.koha.org will be changed to point to the new server. As noted earlier this week, gitweb is currently not functioning, although the git repository itself remained accessible via the git protocol. The breakage was caused by our (LibLime's) attempt to apply security updates on the virtual private server running git.koha.org. However, this appears to have resulted in an incompatibility between the C library and the kernel of either the host or client operating system, which in turn prevented from Apache from running. I apologize for not providing more details of what went wrong, but at present I don't have them. Rather than spend even more time trying to resolve the issue on the original box, we have transferred the public repository, gitweb, and gitstats to another, more stable box. The public git repository will be frozen until we're sure that the DNS changes have had enough time to propagate. Please note that all patches submitted to patches(a)koha.org are still in the hands of the QA and release managers; none of them are lost. On behalf of LibLime, I apologize to the Koha community for the outage and for our failure to resolve the problem more quickly. I will post again once the DNS change has taken place. If any issues are discovered with git on the new server, please CC me on any notifications. Regards, Galen -- Galen Charlton Koha Application Developer LibLime galen.charlton(a)liblime.com p: 1-888-564-2457 x709

3 2

what is a 'PE' branch ?
by Paul POULAIN 13 Mar '08

13 Mar '08

Hello, could someone explain to me what is the meaning (functionnaly speaking) of this portion of code : (C4/Circulation.pm) # check if the book is in a permanent collection.... my $hbr = $iteminformation->{'homebranch'}; my $branches = GetBranches(); if ( $hbr && $branches->{$hbr}->{'PE'} ) { $messages->{'IsPermanent'} = $hbr; }

2 1

RFC: create old_issues and old_reserves
by Galen Charlton 11 Mar '08

11 Mar '08

Hi, I would like to create two new tables, old_issues and old_reserves, that would be used to store completed checkouts (issues) and hold requests (reserves). Similar to how tables like deleteditems function, whenever a checkout or hold request transaction is completed or canceled, the row representing it would be moved to old_issues or old_reserves respectively. I believe doing this would have several advantages: 1. The issues and reserves tables would cease to grow indefinitely; instead, they would have only as many rows as needed for a library's peak number of transactions. It is my hope that this would improve performance, particularly when processing long hold queues. 2. It would become possible to add a unique key constraint on issues.itemnumber (as an item can be issued only once at a time). Similarly, it may become possible to add unique key constraints on reserves. 3. Some queries and joins would be simplified. Perl code and ad-hoc reports could rely on a conceptually simpler notion that if a row is present in issues or reserves, it represents a current or otherwise active transaction. 4. Koha administrators could safely archive or truncate the old_issues and old_reserves tables if they desire to remove or completely anonymize circulation history. Thoughts? Regards, Galen -- Galen Charlton Koha Application Developer LibLime galen.charlton(a)liblime.com p: 1-888-564-2457 x709

6 7

zebra deleting
by Ignacio Javier 11 Mar '08

11 Mar '08

Good evening to everybody in my GMT area, good night and moorning for the rest, and good whatever for Space Station resident personal: I've been adjusting a little /usr/share/koha/bin/cronjobs/update_items.pl script to change it consequently for koha 3 alpha SQL tables and API, and my doubt is: a) Does not koha make this process directly when the insert/update/delete of a MARC record? , or is always needed to do similar zebraidx -et ceteras... to syncronize it in a cron fashion? Thanks in advance and greetings. Ignacio Javier Gómez Rodríguez Analista - Programador Tfno: 902905590 - Fax: 981571425 ignacio.gomez(a)coremain.com www.coremain.com

1 0

Re: [Koha-devel] Welcome new Koha translators
by Joe Atzberger 11 Mar '08

11 Mar '08

Kurt and Tao -- Welcome both of you to the Koha development list. It is great to hear your interest extending the reach of the Koha project. For practical instructions on how to begin translation, the first place to start is: http://translate.koha.org/ There is also a separate translators' listserv via* koha-translate(a)nongnu.org *with more information available at: http://lists.nongnu.org/mailman/listinfo/koha-translate The members of that list are the most likely to be helpful with the details of how to proceed. Tao, you may be pleased to see that 2 partial Chinese translations already have been started. Your vision of Koha in schools across China is very exciting! Kurt, you will want to contact Josh Ferraro (via that list, for example) to request Dutch be added to translate.koha.org. Thanks for your interest and efforts! --Joe Atzberger Systems Administrator, LibLime On Tue, Mar 11, 2008 at 6:58 AM, Kurt Debrouwer < secretariaat(a)academiewaregem.be> wrote: > We are working on implementing the Koha library software in our music > academy which is situated in the northern Dutch speaking part of Belgium. > We would like to translate the OPAC file into Dutch. How do we proceed in > order to do so? Can Dutch be added to the list of languages? And what do > we do next? > > Awaiting your reply, > Kind regards > > Kurt Debrouwer > Administrator in Chief > ______________________________ Previously Tao Huang wrote: > Hi everyone, > > I'm Tao from Shanghai, China. I started to use Koha about one year ago > when I planned to establish a small library in my company. But I'm only a > part-time librarian:) I found that Koha was interesting and powerful. > > I have had this dream for about several months: Every school in China can > use Koha as their electronic library. You may have known or not yet, in some > regions of China, the schools there don't have enough fund to afford > commercial library software. Koha seems to be the best choice for them. > However, the language maybe becomes the biggest problem when they try to use > Koha, although Koha have been partly translated into Chinese. > > That's why I join this list. First I am willing be a translator, then I > will make a wonderful Chinese document for Koha. > > You guys are the most intelligent and experienced. Please give me > suggestions and help to make my dream come true! > > Many Thanks, > Tao Huang

1 0

translating Koha into Dutch
by Kurt Debrouwer 11 Mar '08

11 Mar '08

1 0

Problems on gitWeb
by Zeno Tajoli 11 Mar '08

11 Mar '08

Hi to all, I'm trying to see the koha git web site http://git.koha.org I receive the error: failed: Connection refused. No problems on update the sources with git. What is it the problem ? Bye Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)

3 2

Re: [Koha] Follett to Koha 2.2.9 migration help
by Mason James 10 Mar '08

10 Mar '08

On 2008/03/8, at 5:24 AM, Darren De Zeeuw wrote: > I am the volunteer IT guy for a small private school. We have been > using > Follett's Circ Plus/Cat Plus software for many years, but their > upgrade path > is too expensive and our old Mac OS 9 machine running the software > in the > library had a disk failure. It's time to find another solution. > Koha seems > to be the perfect fit for us, but I need to show that it's better > than what > we have in order to get approval. Hi Darren, Recently at LIblime, we did some conversions from Follet systems to Koha. > I have a MICROLIF file with around 8000 records > exported from our Follett catalog. I ran the bulkmarcimport.pl > script and > it brought most of the data over as far as I can see (I'm not a > librarian), > but seems to be missing our bar-coding information at least. I'm also > unsure if I can migrate over our patron list as well. The missing item info you are describing is because Follet's MICROLIF marc records store their item-info in the 852 fields ( from memory... ) (Every ILS vendor have their little quirks about where they stuff the item-level info, Follets looks to be in 852 What is needed is a small script to fetch those Follet 852 item- values and move them to their corresponding Koha 952 fields, then write those corrected records out to a new file. Run Bulkmarcimport.pl on this new file, and you will successfully pick up those missing item-level values in your Koha marc import. FYI: when i get some time, I plan to add to the koha-wiki some general code examples of this mapping process I described. I hope that helps, Cheers, Mason.

2 1

RFID and other hardware moves...
by Ignacio Javier 10 Mar '08

10 Mar '08

Hi all: I just was wandering if Koha 3 has done any integration with RFID and/or optical barcode readers, is already started, planned or is just a "wrap, wrap... doit yourself"?. There seems to be a world down under lib/C4/SIP but.... is "baby safe"? Thanks, Ignacio Javier Gómez Rodríguez Analista - Programador Tfno: 902905590 - Fax: 981571425 ignacio.gomez(a)coremain.com www.coremain.com

2 2