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

Re: [Koha-devel] MARC editor for Koha 3.0
by Partha Mukhopadhyay 26 Oct '05

26 Oct '05

Hello Fiends, Koha 3.0 is in the pipeline. Great news. It'll include an expert MARC editor and the schema has already been designed.I've one question about MARC editor. Is it going to include Leader field (24 characater fixed field)in MARC editor this time? In fact we failed to add leader field in MARC framework in koha 2.2.3.(Although it produces minimum (computer generated) leader data during export) If yoy have an idea about how to add Leader in MARC framework of released koha version (particularly 2.2.3, we've not yet explored 2.2.4) let us know. Partha Mukhopadhyay Lecturer, Vidyasagar University, WB, India -- India.com free e-mail - www.india.com. Check out our value-added Premium features, such as an extra 20MB for mail storage, POP3, e-mail forwarding, and ads-free mailboxes!

1 0

Last Acquired RSS
by Owen Leonard 21 Oct '05

21 Oct '05

We'd like to offer RSS feeds for newly acquired items, but we haven't managed to figure out how to do it well. The current configuration for the last Acquired feed doesn't work well at all. It uses this query: select biblio.title as title, biblio.author as author, biblio.biblionumber as bibid from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.dateaccessioned is not NULL order by items.dateaccessioned desc This doesn't work well for a couple of reasons: 1. It returns duplicate results 2. It returns results for items which have been recently added to old biblios I'm wondering whether a simply search by biblionumber isn't going to return better results? At least it would get me only new biblios, rather than new items. What do others think? Is anyone using Koha's RSS? -- Owen

2 1

Re: [Koha-devel] Koha Statuses and MARC?
by COURYHOUSE＠aol.com 20 Oct '05

20 Oct '05

The best thing is to keep MARC as standard as you can... Ed Sharpe archivist for SMECC. > Paul et al, > > In Paul's proposed scheme for item statuses, the items.notforloan > field is linked to MARC field 942$k and then an authorized value > is set for that field (defined by the library). Before we invest > too much development energy on this idea I'd like to question > whether it's even a good idea to store status information in the > MARC record, especially we we move toward using Zebra to store our > textual (MARC) database. > > Stephen and I spoke earlier today and he's got me thinking that maybe > it's not such a good idea to store statuses in MARC. MARC wasn't > really designed for anything but the static record information. It's > ill-suited for transactional based data such as statuses. > > I propose that for Koha 3.0 we create a new field in the Koha tables > called 'items.status'. items.status can be a numeric value and have > a set of library-defined authorized values. We can then add a framework > for setting those values that a library must setup when they install > the system. For instance, it should be possible to set Koha to > automatically set an items status to 'in transit' when an item is > on reserve to a patron in a branch other than the holdingbranch (when > the item is returned) and 'waiting' when it arrives and is scanned. > But the goal would be to make this a setting that the library could > define when setting Koha up, a set of 'status rules'. > > Comments, suggestions, volunteers? > > Cheers, > -- > Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE > President, Technology migration, training, maintenance, support > LibLime Featuring Koha Open-Source ILS > jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS Thanks, Ed Sharpe, Archivist for SMECC See the Museum's Web Site at www.smecc.org We are always looking for items to add to the museum's display and ref. library - please advise if you have anything we can use. Coury House / SMECC 5802 W. Palmaire Ave. Phone 623-435-1522 Glendale Az 85301 USA CONFIDENZIALE: Questo messaggio e gli eventuali allegati sono confidenziali e riservati. Se vi è stato recapitato per errore e non siete fra i destinatari elencati, siete pregati di darne immediatamente avviso al mittente. Le informazioni contenute non devono essere mostrate ad altri, né utilizzate, memorizzate o copiate in qualsiasi forma. CONFIDENTIAL: This e-mail and any attachments are confidential and may contain reserved information. If you are not one of the named recipients, please notify the sender immediately. Moreover, you should not disclose the contents to any other persons, nor should the information contained be used for any purpose or stored or copied in any form.

6 5

New document on kohadocs
by Stephen Hedges 19 Oct '05

19 Oct '05

I have loaded a new (French) document on http://www.kohadocs.org -- Manuel dutilisation de Koha by "Boris Gapihan, Christelle Le Borgne, Fabien Malclès, Marie-France Palestro (élèves conservateurs à l'ENSSIB, promotion DCB14)" This is an OpenOffice .sxw file, so you will need OO to access it. I am working on xml and xhtml versions, but this is an extensive document and it will take some time to convert it. Meanwhile I thought it was important to make this version available. -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com

1 0

RE: [Koha] Chinese support?
by Han, Yan 17 Oct '05

17 Oct '05

We did the update. Searching "$#22269;" works, but you cannot search "中" to get the result. >>>>>>>>>>>>>>>>>>>>>>>>>>>> mysql> select * from marc_word where bibid=1048 -> ; +-------+-------------+----------+---------------+----------+-----------+ | bibid | tagsubfield | tagorder | subfieldorder | word | sndx_word | +-------+-------------+----------+---------------+----------+-----------+ | 1048 | 952u | 39 | 4 | 12 | 1000 | | 1048 | 952p | 39 | 3 | 9090 | 9000 | | 1048 | 952d | 39 | 2 | MAIN | M000 | | 1048 | 952b | 39 | 1 | MAIN | M000 | | 1048 | 90d | 38 | 2 | 1048 | 1000 | | 1048 | 90c | 38 | 1 | 1048 | 1000 | | 1048 | 245a | 11 | 1 | 国 | 2000 | | 1048 | 245a | 11 | 1 | 中 | 2000 | | 1048 | 245a | 11 | 1 | & | &000 | | 1048 | 100a | 9 | 2 | 38889; | 3000 | | 1048 | 100a | 9 | 2 | & | &000 | | 1048 | 50a | 7 | 1 | 70 | 7000 | | 1048 | 50a | 7 | 1 | TA76 | T000 | +-------+-------------+----------+---------------+----------+-----------+ 13 rows in set (0.00 sec) YH -----Original Message----- From: Chris Cormack [mailto:chris@katipo.co.nz] Sent: Sunday, October 09, 2005 1:40 PM To: kael(a)email.arizona.edu Cc: Han, Yan; Koha-devel Subject: Re: [Koha] Chinese support? Kia Ora e hoa ma, > The '22269;' is also stored in the marc_word table: > +----------------+--------+ > | bibid | 1048 | > | tagsubfield | 245a | > | tagorder | 11 | > | subfieldorder | 1 | > | word | 22269; | > | sndx_word | 2000 | > +----------------+--------+ > Would you be able to do me a favour please, try running UPDATE marc_word SET word='国' WHERE bibid=1048 AND word='22269;'; Then if you search on the character that 国 represents in koha does it find you a result? Chris -- Chris Cormack Katipo Communications Programmer www.katipo.co.nz 027 4500 789

2 1

Promotion of Koha release
by lars＠rovaniemelainen.com 14 Oct '05

14 Oct '05

Is there a list of places to contact with press releases when Koha releases new versions? Obviously some would only be interested in major revisions, others would be interested in point versions (e.g. from 2.2 to 2.4) I'd like to suggest adding OSS4LIB: http://oss4lib.org/ and maybe the Usenet group: comp.internet.library -Lars ---------------------------------------------------------------- This mail sent through L-secure: http://www.l-secure.net/

1 0

Translation into Vietnamese
by Le Thuy Duong 13 Oct '05

13 Oct '05

Dear Developers, I am a Vietnamese student who is currently doing Master of Library and Information Studies at School of Information Management, Victoria University of Wellington. I am also Webmaster of Vietnamese Information and Library Portal (http://www.thuvientre.com) in Vietnamese, which is devoted to the professional development of Vietnamese librarianship. I am particularly interested in open source softwares for libraries. I also have good background in Web development, Web programming (PHP and MySQL). I have a plan to initiate and encourage Vietnamese libraries to apply these types of software into their operation because they are suitable for libraries in developing countries. I came to know Koha nearly one year ago. I have tried its demo and found that it is suitable for many Vietnamese public libraries who cannot afford comercial softwares. Therefore, I would like to translate Koha into Vietnamese so that the libraries and their users can benifit from your great effort. Look forward to cooperation with Koha's development team. With my best regards, -- Le Thuy Duong Founder and Webmaster Vietnam Information and Library Portal http://www.thuvientre.com

2 1

someone knocks at the door. who is it ? It's koha 2.2.4 !
by Paul POULAIN 10 Oct '05

10 Oct '05

http://sourceforge.net/project/shownotes.php?release_id=362377 RELEASE NOTES ============= Koha is the 1st Open-Source Integrated Library System. Released at first in New zealand, in 2000 januaray, it is maintained by a team of volunteers from around the globe, the Koha system is a full catalogue, opac, circulation and acquisitions system. Koha 2.2 is more than 247 000 lines of code, developped by more than 30 differents developpers (excluding translators). With the 2.2 version, Koha is now a mature product, with a lot of nice features. It's used in more than 50 libraries, from all kinds (public, schools, search, religious...), of all size (from 1 to 8 branches, from 1000 to 300 000 items). Koha 2.2.4 should be the last release of the 2.2 branch with new features. Koha 2.2.5 should contain only bugfixes. However, Koha 3.0 is already on the way and should give libraries a new great experience ;-) ======== WARNINGS ======== * The librarian interface is tested only with mozilla/firefox. Should work (partially) with IE. OPAC should work fine with any navigator. * The installer is *wrong* on languages available. In this release, french & english are uptodate. Other language po files are provided in the package. If you update/complete one of them, please send it at paul.poulain @ free.fr, it will be included in a 2.2.4b release ! KNOWN BUGS : ****** Critical/blocking : none see bugs.koha.org for more information. Please report any problem in bugs.koha.org ======= DIFFS ======= Diff 2.2.3 => 2.2.4 ******************* DB MODIFS : *********** DB structure : * field note added in serial table. * field branchcode added in aqbookfund and aqbasket table. * DB content : * systempref IndependantBranch added (see detail below) * systempref ReturnBeforeExpiry added (see detail below) * systempref Disable_Dictionary added (see detail below) Koha opac stylesheets : * no new stylesheet class, but the official stylesheet has been highly modified BUGFIXES === CATALOGUING === * created a plugin & tools to manage the MARC leader. * fixing a bug in subfield order when MARCgetbiblio * adding some diacritic decoding (Ä, Ü...) * removing -s parameter in z3950 client, as it does not work for FreeBSD servers * Managing multiple URLs in normal view : if you type more than 1 URL in 856$u (same field in both marc21 and unimarc!), the normal view will show multiple URL, not a single one with all urls concatenated. * Fixing a bug in MARC editor for fields >200 characters. * fixing a bug in MARC editor when there are more than 1 list of the same type (lang, branch...) === OPAC === * getting rid with "Internal Server Error" that happends when there is no stopwords * Removing a 'request' button in opac-detail, that was here even if there was no items for loan IMPROVEMENTS === ACQUISITION === * budget can now be branch dependant : when you define a bookfund, you can choose a branch. If you don't, the bookfund can be used by any librarian in acquisition. If you choose one, only a librarian from the branch can use this bookfund. Note that librarians with superlibrarian flag can always order from any bookfund. * adding the number of orders & line count in acquisition history. * if the library defines Asort1 or/and Asort2 (A for Acquisition) authorized values category, the free fields sort1 and sort2 will be a list containing what the authorized value category contains. If they are not defined, the behaviour does not change : the value in sort1 and sort2 is a standard input === CIRCULATION=== * added a ReturnBeforeExpiry systempreferences. If set to yes, then the returndate will be limited to the expirydate of the borrower card. If set to no, then the returndate can be after the expirydate of the borrowercard. This was the previous behaviour, but some libraries have expirydate that means "the student will leave the school at this date", so the return limit must be properly set. === CATALOGUE === * when displaying ISBN, - are automatically added where needed. (Internally, ISBN are sill without -) * some graphic modifs in MARC view : colors & font weight + when a field has only 1 subfield, the subfield name & code is not repeated, as it is useless. === CATALOGUING === * getting rid with the limit "biblionumber & biblioitemnumber must be in the same tag". So, we can put biblionumber in 001 (field that has no subfields, so we can't also put biblioitemnumber in this field), and use biblionumber as identifier in the MARC biblio too. * adding a script misc/migration_tools/build_authorities.pl to rebuild authorities after a bulkmarcimport. This script is highly faster & better than build_6xx.pl that is still here, but just for historic purposes. === MEMBERS === * adding the number of member & line count in searching members screen * if the library defines Bsort1 or/and Bsort2 (B for Borrower) authorized values category, the free fields sort1 and sort2 will be a list containing what the authorized value category contains. If they are not defined, the behaviour does not change : the value in sort1 and sort2 is a standard input. === OPAC === * Adding reading history button when the user is identified. * Adding page to let patron change it's password. * Adding an 'exact search' checkbox in advanced search. Will search exactly what the user type. * improving subject links for libraries with complex/complete authority management. * Re-introduced exact search to do a search on terms exactly like the user type it. * added volumdeddesc to result list, will be more friendly for books in X parts. * added Disable_Dictionnary systempref. If set to yes, there is no more dictionnary button in OPAC. * added SortItemsBy systempref. === SERIALS === * when recieving a serial, 2 options have been added (not issued & delete. Options added to waited, arrived, missing & late). Not issued means "book not issued, will never arrive at the library. "delete" deletes the entry. It's useful when you are waiting for Issue #511 and Issue #512 and recieve a Issue #511-512 : you change issue # for one of them & set "recieved" and delete the other. * a note field has been added for each serial. You can use it to store some information on a given (waited/late) serial. For example, you can note "bookseller called on 8/21/05, serial will be sent next month". * detailled history view ported from OPAC to librarian interface as well. * the history view is ordered by year, but also by subscription, to see all issues of a given subscription at once. * the feature to delete a subscription ONLY when no issues has been done has been removed : you can delete a subscription at any time (it deletes issues & history as well, be careful when deleting ;-) ) === SYSTEM PREFERENCES === * adding tabs to systempreferences screen : displaying preferences category by category (admin, acquisition, authorities, catalogue, circulation, members, OPAC and others). That makes systempreferences system easier to use * Adding a "IndependantBranch" systempref. If you select it, then your branches are considered as independant, and the librarians from a branch can't change things from another branch : - items owned by branch A can't be modified/deleted by a librarian from branch B - items, bookfunds and borrower created by a librarian can only be attached to it's own branch - borrowers from a branch A can't be modified/deleted by a librarian from branch B Note that issues are not concerned by this limit : a borrower from branch A can issue/return book from anywhere and, of course, transferts can always be done too. Also remember that librarians with superlibrarian privilege can alway work on every branch === ALL == * adding a small image with Koha egg to have the egg in window title bar & get rid with those pesky "can't find favicon.gif" in apache logs. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Re: [Koha] Chinese support?
by Chris Cormack 09 Oct '05

09 Oct '05

Kia Ora e hoa ma, > The '22269;' is also stored in the marc_word table: > +----------------+--------+ > | bibid | 1048 | > | tagsubfield | 245a | > | tagorder | 11 | > | subfieldorder | 1 | > | word | 22269; | > | sndx_word | 2000 | > +----------------+--------+ > Would you be able to do me a favour please, try running UPDATE marc_word SET word='国' WHERE bibid=1048 AND word='22269;'; Then if you search on the character that 国 represents in koha does it find you a result? Chris -- Chris Cormack Katipo Communications Programmer www.katipo.co.nz 027 4500 789

1 0

MARC editor for Koha 3.0
by Paul POULAIN 08 Oct '05

08 Oct '05

Hi, i've taken some minuts to write a schema on my ideas for expert MARC editor in Koha 3.0 You can see it at www.koha-fr.org/MARC-E.pdf (OOo file at www.koha-fr.org/MARC-E.sxd) Let me know what you think of it ? Joshua, do you have student to work on this as you expected ? PS : I realize that it may not be clear or what is typed by the librarian : everything that is blue on my schema. (what is in green is automatically filled by javascript) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

5 8