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

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

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

06 Oct '05

kael(a)email.arizona.edu wrote: >> Han, Yan wrote: >> >>> That is right. >>> >>> Look at this >>> >> http://arrakis.library.arizona.edu:59/cgi-bin/koha/opac-detail.pl?bib=10 >> 48 >> >>> You can only search "22269; | 20013;& | &" >>> >> Kia Ora ano >> >> Further to my last email, do you have access to the Koha mysql database. >> If so can you please do a select * from biblio where biblionumber=1048; >> >> Is that where the 22269; is stored? or is it in the marc_word table? > > > When I do the SQL query on the on the biblio table I get (tranfered to a > hopefully email-friendly layout): > +---------------+------------------+ > | biblionumber | 1048 | > | author | 韩 | > | title | 中国 | > | unititle | | > | notes | NULL | > | serial | NULL | > | seriestitle | | > | copyrightdate | NULL | > | timestamp | 20051006163507 | > | abstract | NULL | > +---------------+------------------+ > > The '22269;' is also stored in the marc_word table: > +----------------+--------+ > | bibid | 1048 | > | tagsubfield | 245a | > | tagorder | 11 | > | subfieldorder | 1 | > | word | 22269; | > | sndx_word | 2000 | > +----------------+--------+ > Ah ha. So the biblio table is storing the entity properly, eg title 中国 So when the record is displayed it displays just fine. But marc_word (which is what is searched on) has had the &# stripped. So it looks like its a propblem with the routines storing data in the marc_word table. Ill look into the routines that do the storage and look for a fix. Anyone else who knows more about the MARC tables and/or unicode want to yell out now and tell me im on the wrong track? Or where to start looking? Chris -- Chris Cormack Katipo Communications Programmer www.katipo.co.nz 027 4500 789

1 0

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

06 Oct '05

Han, Yan wrote: > That is right. > > Look at this http://arrakis.library.arizona.edu:59/cgi-bin/koha/opac-detail.pl?bib=1048 > You can only search "22269; | 20013;& | &" > Hmm What that implies to me then, is that when you search, it needs to be converted to the right value eg 22269; before the search is spawned. Ill shift this conversation to koha-devel now, and reply in more detail Chris -- Chris Cormack Katipo Communications Programmer www.katipo.co.nz 027 4500 789

1 0

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

06 Oct '05

Han, Yan wrote: > That is right. > > Look at this http://arrakis.library.arizona.edu:59/cgi-bin/koha/opac-detail.pl?bib=1048 > You can only search "22269; | 20013;& | &" > Kia Ora ano Further to my last email, do you have access to the Koha mysql database. If so can you please do a select * from biblio where biblionumber=1048; Is that where the 22269; is stored? or is it in the marc_word table? Chris -- Chris Cormack Katipo Communications Programmer www.katipo.co.nz 027 4500 789

1 0