- Koha - lists.katipo.co.nz

SQL report: help needed
by Vimal Kumar 08 Apr '10

08 Apr '10

Dear Friends, I have created an SQL query to create a collection list for our library. This report will display the details like Call Number, author, title etc. I could not include the element for subject or keyword. Here, I am using 650-a field for keyword in cataloguing. I could not found the details of table and field of "keyword" (650-a Topical term) in Koha. Can you help me to complete this SQL query for this report? SELECT items.itemcallnumber,biblio.author,biblio.title,biblio.copyrightdate,biblioitems.publishercode,biblioitems.place FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) ORDER BY items.itemcallnumber asc Regards, -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Update table's fields value
by Quanzhong Zhang 08 Apr '10

08 Apr '10

Hello, I'm using Koha 3.0.4 and its database upgraded from Koha 2.2.9 I want to update the table biblioitems' fileds biblioitems.marc and biblioitems.marcxml on the MySQL database interface. Could you kindly give me some advice? Thanks and Best Regards, Zhang QZ

1 0

Zebra problem...
by Scott Kushner 08 Apr '10

08 Apr '10

Does anyone know if there's an issue with Zebra and a specific version of YAZ 3.0.52? Or Perhaps a firewall issue? Keep getting the 109 error....Can't figure this out. Any help greatly appreciated. Thanks. zebradb/bibliosocket 26549 21:25:05-07/04 zebrasrv(2) [request] Auth idPass root - 21:25:05-07/04 zebrasrv(2) [request] Init OK - ID:81 Name:ZOOM-C/YAZ Version:3.0.52 e687cb7eb87c841f0d1a374174d51d30371f2d97 21:25:05-07/04 zebrasrv(2) [request] Search biblios ERROR 109 1 1+0 RPN @attrset Bib-1 @attr 1=1016 @attr 4=6 @attr 5=1 jazz 21:25:05-07/04 zebrasrv(2) [session] Connection closed by client Scott Kushner Information Technologies Middletown Public Library

2 2

Community Handover meeting
by Chris Cormack 07 Apr '10

07 Apr '10

Hi all March 2 2010, 19:00 UTC is the scheduled time for the next community meeting the agenda is here http://wiki.koha.org/doku.php?id=en:events:meetings:irc_meetings:meetingnot… Quick summary is Welcomes and introductions. Report on DRAFT Horowhenua Library Trust Koha Committee RULES Report on status of negotiations over assignment of trademarks and domains. Possible suggestions on unresolved negotiations. Next issues if negotiations have concluded. Agree time of next meeting. Chris

3 2

Serials Textual Holdings in 866
by Zachary Spalding 06 Apr '10

06 Apr '10

I have some holding information in the 866$0 filed and was wondering what is the correct the 952 field to map that too? I have several libraries that have print serials but have different years and would like to assign each holding year to that specific library. Thanks -- Zachary Spalding Systems Manager Southeastern NY Library Resources Council 21 S. Elting Corners Rd Highland, NY 12528 Phone: 845-883-9065x13 Fax: 845-883-9483 Email: spalding(a)senylrc.org

1 0

Koha in libraries for the blind?
by Brevik, Thomas 06 Apr '10

06 Apr '10

Does anybody know if a library for the blind and sight impaired uses Koha? I have discussed Koha with a person working in such a library and he thought it might be a good system for this type of libraries. Many libraries for the blind have very old and specially adapted systems that needs replacing in the near future, so here is an opportunity I think. Yours Thomas Brevik Head librarian Royal Norwegian Naval Academy

3 2

Problem on installation of Yaz
by Bariki G. Kamara 06 Apr '10

06 Apr '10

Hi, Am trying to install YAZ but am facing the following problems; [root@library redhat]# cd RPMS/i386/ [root@library i386]# rpm -ivh libyaz3-3.0.32-1.i386.rpm libyaz3-devel-3.0.32-1.i386.rpm yaz-3.0.32-1.i386.rpm yaz-debuginfo-3.0.32-1.i386.rpm yaz-icu-3.0.32-1.i386.rpm yaz-illclient-3.0.32-1.i386.rpm Preparing... ########################################### [100%] package libyaz3-3.0.32-1.i386 is already installed file /usr/share/man/man7/yaz.7.gz from install of libyaz3-devel-3.0.32-1.i386 conflicts with file from package libyaz-2.1.54-1.el5.1.i386 file /usr/bin/yaz-client from install of yaz-3.0.32-1.i386 conflicts with file from package yaz-2.1.54-1.el5.1.i386 file /usr/bin/yaz-iconv from install of yaz-3.0.32-1.i386 conflicts with file from package yaz-2.1.54-1.el5.1.i386 file /usr/bin/yaz-marcdump from install of yaz-3.0.32-1.i386 conflicts with file from package yaz-2.1.54-1.el5.1.i386 file /usr/bin/yaz-ztest from install of yaz-3.0.32-1.i386 conflicts with file from package yaz-2.1.54-1.el5.1.i386 file /usr/bin/zoomsh from install of yaz-3.0.32-1.i386 conflicts with file from package yaz-2.1.54-1.el5.1.i386 file /usr/share/man/man1/yaz-client.1.gz from install of yaz-3.0.32-1.i386 conflicts with file from package yaz-2.1.54-1.el5.1.i386 file /usr/share/man/man1/yaz-iconv.1.gz from install of yaz-3.0.32-1.i386 conflicts with file from package yaz-2.1.54-1.el5.1.i386 file /usr/share/man/man1/yaz-marcdump.1.gz from install of yaz-3.0.32-1.i386 conflicts with file from package yaz-2.1.54-1.el5.1.i386 file /usr/share/man/man1/zoomsh.1.gz from install of yaz-3.0.32-1.i386 conflicts with file from package yaz-2.1.54-1.el5.1.i386 file /usr/share/man/man7/yaz-log.7.gz from install of yaz-3.0.32-1.i386 conflicts with file from package yaz-2.1.54-1.el5.1.i386 file /usr/share/man/man8/yaz-ztest.8.gz from install of yaz-3.0.32-1.i386 conflicts with file from package yaz-2.1.54-1.el5.1.i386 Can any one help on this.

3 2

apologies for Koha Community meeting
by Joann Ransom 06 Apr '10

06 Apr '10

Hi all, Very sorry but it is highly unlikely I will be able to make the scheduled Koha Community meeting tomorrow. Nothing to report re Koha domain names etc. All koha subcommitteee members were contacted to discuss whether any point in us meeting: answer no. Chris, Galen et al are all equally up with the play as I am. Position of Kaitiaki may be a discussion item. Cheers Jo. -- Joann Ransom RLIANZA Head of Libraries, Horowhenua Library Trust.

1 0

SMS
by Melanie Hedgespeth 06 Apr '10

06 Apr '10

Does anyone utilize the SMS option for messaging? If so, what send driver do you use? Thanks. m -- Melanie Hedgespeth Salina Public Library: Tech Center Manager www.salpublib.org / 785.825.4624 x233 / melanie(a)salpublib.org mytechrelief.com / melanie(a)mytechrelief.com

2 1

Tying different databases together
by Olugbenga Adara 04 Apr '10

04 Apr '10

Hello all, Happy Easter to everyone. I am trying to find out out to have a single search interface that will search koha, dspace, LANTEEAL and possible other online journals like jstor. I've been taking a look at dbwiz but i cant seem to get how to get it to search koha and helpful documentation. Also I've heard about solutions like libraryfind. My question now is, has anybody done this and can give me advice or pointers to documentation etc?, is it feasible? I will appreciate any help. Thanks Olugbenga Adara Mobile: 234-803-3220288

1 0