- Koha - lists.katipo.co.nz

A question about fines and account lines
by George Adams 26 Mar '08

26 Mar '08

Short version: In the "accountlines" table, there is a field called "accounttype" that can have values like L, F, FU, FM, O, etc. What do those values mean? Long version: I'm using the script <KOHA>/bin/cronjobs/fines2.pl to calculate fines on a nightly basis. It works pretty well, but I noticed that it has this line: UpdateFine($data->[$i]->{'itemnumber'}, $data->[$i]->{'borrowernumber'},$amount,$type,$due); This calls the UpdateFine subroutine in C4/Overdues.pm, which runs this command: my $sth2 = $dbh->prepare( "INSERT INTO accountlines (borrowernumber,itemnumber,date,amount, description,accounttype,amountoutstanding,accountno) VALUES (?,?,now(),?,?,'FU',?,?)" ); Note how "FU" is hardcoded as the "accounttype" in this section. But when a patron is viewing his/her summary screen in the OPAC (i.e. http://www.example.net/cgi-bin/koha/opac-user.pl) and has an overdue item, the line under "Fines" always says "No". Why? Because opac-user.pl has this bit of code: my $charges = 0; foreach my $ac (@$accts) { if ( $ac->{'itemnumber'} == $issue->{'itemnumber'} ) { $charges += $ac->{'amountoutstanding'} if $ac->{'accounttype'} eq 'F'; $charges += $ac->{'amountoutstanding'} if $ac->{'accounttype'} eq 'L'; } } $issue->{'charges'} = $charges; So, $charges is only going to be passed to the template if the accounttype is "F" or "L". But since C4/Overdues.pm is always setting it to "FU", that will never happen, and the Summary screen will always tell the patron they have no fines. So, can anyone tell me what the different accounttypes are? I could fix this, I guess, by changing the code for the UpdateFine subroutine or opac-user.pl fine calculation, but I don't want to go fiddling with the code lest it have some unforseen side effect. Thanks.

1 0

Error with Repeatable MARC tags
by Jennifer Johnston 26 Mar '08

26 Mar '08

I'm working with Koha 2.2.9, Win XP, IE 6 Now I'm thinking it's an IE problem? It's an Error on Page mssg: Could not get the type property. This command is not supported. I'll try running koha in Firefox and see if that helps- Thanks, Jennifer "Jennifer Johnston" <Johnston at arrowstreet.com> wrote: > I'm new to this list. I've been working on customizing Koha (2.2.9) for > Windows, and have run into a problem that was posted by someone else > last year--but I can't find a reply to it. Would anyone be able to help? [...] > This has to do with the MARC tags which are set to repeat in the bib > framework. When I click on the + sign to repeat the tag, nothing happens > and I get an "error" message at the bottom. Repeatable subfields are > working fine. Probably not with that info. At the very least, which browser/version is used and is the "error" message actually just the word "error" or does it give more detail? (Not that I can help with Windows-specifics or the Yahoo! javascript.) Hope that helps, -- MJ Ray (slef) Webmaster for hire, statistician and online shop builder for a small worker cooperative http://www.ttllp.co.uk/ http://mjr.towers.org.uk/ (Notice http://mjr.towers.org.uk/email.html) tel:+44-844-4437-237

1 0

Customising Add Item fields
by vimal kumar 26 Mar '08

26 Mar '08

Dear Friends, I just installed Koha 2.9.How can we remove some fields from Add Item section in cataloguing? I need only following fields, b - Location (homebranch) p Barcode v - Date acquired w - Price effective from Vimal Kumar Asst. Librarian Asian School of Business Technopark Trivandrum-695 581 http://www.asb.edu.in/vimal ---------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping

1 0

installing Koha on Windows
by Kim LaMarre 26 Mar '08

26 Mar '08

Greetings, I would like to install Koha on my current Windows XP machine for my small library. Will Koha 3 work on Windows? I am new to most of this, so the instructions are a bit confusing. I do have perl, Apache, Zebra and MySQL installed. I would love some step by step instructions of what I need to do next. Thanks! Kim LaMarre

4 4

�Please wait while the page loads...�.
by vimal kumar 25 Mar '08

25 Mar '08

Dear Koha Users, We just installed Koha 2.9 on Redhat EL with MySQL 5. All functions work well, but it take time to load Cataloguing pages (Advanced Cataloguing). While editing the existing records the same happens. It shows the message Please wait while the page loads.... I contacted system administrator, he said that the problem with MySQL and it takes time to retrieve records. How can we resolve this problem? Any incompatibility with MySQL and Koha 2.9? Thanks in advance, Vimal Kumar Asst. Librarian Asian School of Business Technopark Trivandrum-695 581 http://www.asb.edu.in/vimal ---------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping

1 0

Re: [Koha] A very basic librarian question
by George Adams 24 Mar '08

24 Mar '08

Thank you all so much for your call number and library sorting assistance! Given how small our library is, I think I'm going to take the advice that a few people offered and sort the items into a few categories (basically "children" and "adult"), then sort everything alphabetically from there. If I'm not mistaken, our local library does something like that, and alphabetical order does seem to be the easiest and most logical way to sort videos. Again, thanks for all the great advice and personal experience stories! _________________________________________________________________ Test your Star IQ http://club.live.com/red_carpet_reveal.aspx?icid=redcarpet_HMTAGMAR

1 0

Setting a default library
by George Adams 23 Mar '08

23 Mar '08

(Koha 3.0 alpha, Gentoo Linux 2.6.24, MySQL 5.0.54) I really appreciate all the help so far. Here's another question: Our church has only a single library, so I defined just one under Koha Administration -> "Libraries, Branches and Groups". When I go to login to the Intranet site, I put in my username and password and note that the "Library" drop-down box has our library preselected. (It is, in fact, the only choice in the <select> box). Once logged in, however, the top-right corner of the screen shows "NO_LIBRARY_SET". Anything we want to do related to circulation redirects us to http://www.example.com/cgi-bin/koha/circ/selectbranchprinter.pl , where we have to set the library. (again, the <Select> box only has one choice next to "Choose Library") Shouldn't that information be automatically set during the login process? I'd like to avoid that redundant step of having to set the library manually every time following the login. Again, thanks for the help.

5 6

problem in installing the apache server
by rupesh_gaur＠rediffmail.com 23 Mar '08

23 Mar '08

a problem in configuring the apache server When i installed the Apeche server on my computer the following problem accord "Only one usage of each socket address(protocol/network address/port)is nornmally permited.:make_sock: could not bind to address 0.0.0.0:80" How can l solve the same

2 1

Announcing Koha 3.0 (Beta)
by Joshua Ferraro 23 Mar '08

23 Mar '08

Hi folks, I'm happy to announce that a packaged beta release of Koha 3 is now available. You can download from the usual location: http://download.koha.org/koha-3.00.00-beta.tar.gz http://download.koha.org/koha-3.00.00-beta.tar.gz.sig You can check the integrity of the package; either by verifying the provided GPG signature (.sig) or by comparing the MD5 checksum: 84f6ec3615155cfa755a9e7139bd07df koha-3.00.00-beta.tar.gz I've also tagged this in Git as "version 3.00.00 beta" v3.00.00-beta This is the second packaged release of Koha 3. Prior to the official stable release of Koha 3.0, software issues, bugs, and unimplemented features must be addressed. These are documented on Koha's Bugzilla: http://bugs.koha.org and organized on the 3.0 RM's QA notes Wiki page: http://wiki.koha.org/doku.php?id=en:development:qanotes3.0 The release notes for this beta version are pasted in below, and will also on the koha.org website sometime over the weekend. Cheers, -- Joshua Ferraro Koha 3.0 Release Manager ============================================================================== RELEASE NOTES FOR KOHA 3.0 ALPHA ============================================================================== Koha 3 is the next-generation release of the award-winning Koha open-source integrated library system. You can obtain Koha 3.0 Beta from the following URL: http://download.koha.org/koha-3.00.00-beta.tar.gz These Release Notes cover What's New in Koha 3, information about the new Revision control system (Git), and Version-release process, pointers to Download, Installation, and Upgrade documentation, a brief introduction to the new Templates, a call to Translation and Documentation writers, and finally, Known Issues with this version. ============================================================================== WHAT'S NEW IN KOHA 3? ============================================================================== 1. Zebra plugin - Zebra is a high-performance, general-purpose structured text indexing and retrieval engine. It supports large data sets (tens of millions of records) and includes support for SRU, Z39.50 and several query languages: CCL, CQL, and PQF. For more information about Zebra, please see: http://indexdata.dk/zebra Koha's new search engine, built on top of Zebra, supports features such as relevance ranking, field weighting, truncation, stemming, use of fuzzy operators, language-specific indexing, sorting, etc. Indexes are updated in real-time with circulation transactions, enabling limits by availability and statuses. Faceted refine-by limits are available from both staff and opac interfaces. For libraries that don't want the overhead of maintaing Zebra, Koha 3 ships with a NoZebra option, in which bibliographic and authority data is indexed in the RDBMS. 2. New installer - based on the common Perl module ExtUtils::MakeMaker, the new installer makes it a snap to get Koha running on just about any platform. The installer comes complete with a Developer's Toolkit target ('dev') that can be used to get a development environment linked directly to revision control, to support rapid prototyping and an agile development process. 3. Standard APIs - Koha 3 supports a number of important library search and retrieval standards and microformats, such as SRU/W, Z39.50 (http://www.loc.gov/standards/sru/) UnAPI (http://unapi.info/) and COinS/OpenURL (http://ocoins.info; http://www.niso.org/committees/committee_ax.html) Also supported is the popular Internet standard: OpenSearch (http://opensearch.a9.com/) created by Amazon's A9. Records are stored internally in an SGML-like format and can be retrieved in MARCXML, Dublin Core, MODS, RSS, Atom, RDF-DC, SRW-DC, OAI-DC, and EndNote; and the OPAC can be used by citation tools such as Zotero. Creating new export formats is a trivial exercise in writing XSLT; records can be passed through XSLT transformations either directly out of the index, or via a separate parsing function. To retrieve and interact with Circulation and Patron data, Koha 3 includes support for 3M's Standard Interchange Protocol (SIP2), using the OpenNCIP libraries (http://openncip.org) There are also an ever-expanding set of native REST APIs to handle interoperability with external tools such as third-party cataloging clients. These APIs provide authentication as well as add/edit/delete control over bibliographic data within a Koha system. For more information, see: http://wiki.koha.org/doku.php?id=en:development:web_services Koha 3 also includes pluggable authentication - easy integration with LDAP and Active Directory via the Auth_with_ldap module. The Amazon.com module can be enabled to enrich bibliographic data with jacket covers, professional reviews, ratings and comments from Amazon users, as well as point to 'Similar Items' within the catalog. OCLC's xISBN, and LibraryThing's ThingISBN can likewise be enabled to provide an 'Editions' tab on item detail pages. New with Koha 3 is service throttling for these services, to keep within subscription limits. 4. Cross-platform, multi-RDBMS, Web-server agnostic - Run Koha on the platform of your choice: Linux, Windows, Mac OS X, FreeBSD, Solaris. Koha 3 also includes better support for multi-RDBMS (MySQL 5.0 and PostgreSQL), and runs under Apache2, IIS, or the web server of your choosing. 5. Multi-lingual support - Koha was designed from the ground up for multilingual libraries. Koha 3 can handle Chinese, Japanese, and even right-to-left languages such as Arabic and Hebrew with ease (BiDi). Koha's index engine (Zebra) can handle record formats containing any UNICODE compliant script, such as Arabic, Chinese, Hebrew, Japanese and Korean. Zebra has this support via the ICU libraries created and maintained by IBM. You can translate Koha into your language using the built-in translation tools, or by visiting http://translate.koha.org. 6. New templates - Koha's staff and patron interfaces are developed with a template system that's easy to theme. The default templates are composed of 100% valid XHTML and CSS. Koha aims to meet or exceed U.S. Government Section 508 and W3C's WAI-AA standards for sight and motor impaired individuals. All Javascript usage comes with fallback modes that work in any web browser. 7. Koha 3 has quite a few new modules, as well as enhancements to existing modules, including: news writer, label creator, calendar, OPAC comments, MARC staging and overlay, notices, transaction logs, guided reports with a data dictionary and task scheduler, classification sources/filing rules. ============================================================================== REVISION CONTROL ============================================================================== With Koha 3, we've started using a new distributed revision control system called Git; it's the same system in use by many other projects, including the Linux Kernel. To learn more about how to develop Koha using Git, please see the Wiki page: http://wiki.koha.org/doku.php?id=en:development:git_usage ============================================================================== VERSION NUMBERING ============================================================================== With Koha 3, version numbering has been changed to use a method similar to Perl's: major.minor[.revision[.build]] * major: one digit * minor: two-digit * revision: two-digit * build: three-digit This beta release of Koha 3.0 is versioned 3.00.00.056. Every database change or significant enough code change requires an update to the 'build' number, and developers will be able to easily upgrade their systems using the built-in updater. Koha 3.0 Release Schedule: This beta release of Koha 3.0 includes the following general improvements over the alpha release on XXX: * General Bugfixing (everyone) * New API for item management (gmcharlt) * MARC21 Authorities (gmcharlt) * Improved I18N/L10N, lang detection (kados) * OPAC Templates re-design (oleonard) * Additional translations This beta release of Koha 3.0 will be followed by a stable release on Mar 15, 2008, including fixes to the following components: * General Bugfixing (everyone) * Sync the system preferences between dev_week, rel_2_2 and 3.0 (gmcharlt) * Additional Template improvements (oleonard) * Documentation and Translations (everyone) The final stable release of Koha 3.0 is now slated for March 15 2008 and will include bugfixes to 3.0 beta. Subsequent releases of 3.0 will be bugfix releases, and won't include any new features. New features will be available in Koha 3.2 and subsequent releases. ============================================================================== UPGRADING FROM A PREVIOUS VERSION OF KOHA ============================================================================== The upgrade process from a previous version of Koha is documented on the Wiki at the following page: http://wiki.koha.org/doku.php?id=22_to_30 ============================================================================== TEMPLATES ============================================================================== You may have heard that the templates for Koha 3 have been re-skinned; there is also the start of a template style guide on the Wiki: http://wiki.koha.org/doku.php?id=en:documentation:templates_style_guide Kudos to Owen Leonard and the Nelsonville Public Library for their contributions! ============================================================================== TRANSLATIONS ============================================================================== Koha 3 beta (this release) currently has complete translations for the following languages: OPAC: de-DE (German), el-GR (Greek), es-ES (Spanish), en (English), fr-FR (French) hu-HU (Hungarian), it-IT (Italian), pt-PT (Portuguese), tr-TR (Turkish), ru-RU (Russian), uk-UA (Ukranian) zh-Hans-CN (Simplified Chinese in China), zh-Hans-TW (Simplified Chinese in Taiwan) Staff Client fr-FR (French), en (English), hy-Armn (Armenian), ru-RU (Russian), uk-UA (Ukranian) zh-Hans-CN (Simplified Chinese in China), zh-Hans-TW (Simplified Chinese in Taiwan) Additionally, Koha 3 beta (this release) has partial translations for the following languages: OPAC: am-Ethi (Amharic), bg-Cyrl (Bulgarian), fa-Arab (Persian), fi-FI (Finnish) gl (Galego), he-Hebr (Hebrew), id-ID (Indonesian), ja-Japn (Japanese), kn-Knda (kannada), ko-Kore (Korean), mi-NZ (Maori), pl-PL (Polish), tet (Tetum) Staff Client: de-DE (German), el-EL (Greek), es-ES (Spanish), hu-HU (Hungarian), ja-Japn (Japanese), tr-TR (Turkish), The Koha Team welcomes additional translations; please see http://www.kohadocs.org/usersguide/apb.html for information about translating Koha, and join the koha-translate list to volunteer: http://lists.nongnu.org/mailman/listinfo/koha-translate ============================================================================== DOCUMENTATION ============================================================================== User-contributed documentation for Koha 3 is available on the Koha Wiki (http://wiki.koha.org) The Koha Team welcomes documentation contributions; please join the Koha-devel list to volunteer: http://lists.nongnu.org/mailman/listinfo/koha-devel ============================================================================== KNOWN ISSUES ============================================================================== Known bugs are documented on the Koha wiki: http://bugs.koha.org and at the 3.0 RM's QA notes Wiki page: http://wiki.koha.org/doku.php?id=en:development:qanotes3.0

1 1

A very basic librarian question
by George Adams 22 Mar '08

22 Mar '08

As I try to setup our church library, it's been helpful for me to have a programming background as I work with Koha. Unfortunately, I don't have a librarian background, which is causing me to have to learn a lot of things that are probably obvious to anyone who's done this kind of thing before. Here's one such problem. I had thought I would simply enter all my DVDs into Koha, generate labels that contain the title of the DVD and the barcode #, and stick those labels on the DVD cases. Then items would be shelved in numeric order by barcode #. What finally occurred to me is that if we have several, say, VeggieTales videos as barcodes 11,12,13,14, then buy a new one later, the new DVD will have a barcode something like 104, and be shelved nowhere near the other ones. So obviously I need a different way to sort my items on the shelf that isn't based on the barcode. I'm guessing this is a "call number", right? (told you this was a really basic question!) So, my questions are: * How should I go about developing a system for creating a call number? Is there a "best practices" way of doing this? (The vast majority of these videos are from fairly small publishers, or are even created in-house, so they won't have any official Dewey or LC numbers or anything. So, I'm going to have to create a system from scratch, and I'd like to figure out the best way to do it. * Where do I store this information in Koha? I see fields that look like possibilities in 942h,i,k,m , but there are a lot of 0xx fields that look like possibilities as well. I'm not sure which is the best field to use... (or maybe that information is part of the "Item", not the "Biblio"? In which case I should maybe put it into "o - Koha full card number" on the "Add Item" screen that follows the "Add MARC Record" page?) Thanks for some basic help. :-)

5 4