- Koha - lists.katipo.co.nz

marc editors and importing records
by Peel Lisa 20 Jul '11

20 Jul '11

Hello I have finally bought my first e-book ! The book supplier I used has sent me the MARC record as a .usm file but I do not have any idea how to open it or how to import the record into KOHA. Do I need to download/buy some external Marc Editor and how can I then import it into KOHA? As usual, any help and advice greatly appreciated! Regards Lisa [Description: Description: Description: CR_logo_POS_COULEUR b] LISA PEEL, PGDip, MA. Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel(a)ritz.edu<mailto:hortense.hofer@ritz.edu> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/>

2 2

A Survey of Koha in Indian Libraries
by SANDEEP BHAVSAR 20 Jul '11

20 Jul '11

Respected All The main aim of conducting this survey is to find out the satisfaction of Koha users and to suggest the future improvements. Kohacon11 at VPM Thane will have 3 days hackfest after the conference, wherein software developers will work on the improvements. I will try to give them the practical problems we face and the future improvement we want in Koha. I request all Koha users to participate in the survey and enjoy the real fruits of Open source software. https://spreadsheets.google.com/spreadsheet/viewform?hl=en_US&pli=1&formkey… Thanks and Regards Sandeep Bhavsar Librarian Dr.V.N.Bedekar Institute of Management Studies Thane(W) 400601 MUMBAI. INDIA @@@@@@@@@@@@@@@@@@@@@@@@@@ email : sandeep.bhavsar(a)gmail.com Mob : 9029 345777 elibrary :http://www.vpmthane.org/im/elib/main.htm @@@@@@@@@@@@@@@@@@@@@@@@@@

1 0

Need with suppression report
by Kathy Rippel 20 Jul '11

20 Jul '11

5 5

Re: [Koha] Need with suppression report
by Kathy Rippel 19 Jul '11

19 Jul '11

1 0

Searching problem after import marc
by Abdul Vali 19 Jul '11

19 Jul '11

I m using Koha 3.4.2 version at ubuntu 10.04. i hve imported data from a csv file by converting records into marc using marcedit. After import complete (1340 biblios). I rebuild zebra with the following command: ./rebuild_zebra.pl -b -a -r -v I got the following output: 22:24:39-19/07 zebraidx(5448) [log] add grs.marcxml.record /tmp/HkeqHyxF2u/biblio/exported_records 1389993 22:24:39-19/07 zebraidx(5448) [log] add grs.marcxml.record /tmp/HkeqHyxF2u/biblio/exported_records 1391237 22:24:39-19/07 zebraidx(5448) [log] add grs.marcxml.record /tmp/HkeqHyxF2u/biblio/exported_records 1392183 22:24:39-19/07 zebraidx(5448) [log] add grs.marcxml.record /tmp/HkeqHyxF2u/biblio/exported_records 1393781 22:24:39-19/07 zebraidx(5448) [log] Records: 1000 i/u/d 1000/0/0 22:24:39-19/07 zebraidx(5448) [log] More than 1000 file log entries. Omitting rest *** stack smashing detected ***: zebraidx terminated ======= Backtrace: ========= /lib/tls/i686/cmov/libc.so.6(__fortify_fail+0x50)[0x536390] /lib/tls/i686/cmov/libc.so.6(+0xe233a)[0x53633a] /usr/lib/libidzebra-2.0.so.0(+0x71fd4)[0xceafd4] /usr/lib/libidzebra-2.0.so.0(+0x17b45)[0xc90b45] [0x0] ======= Memory map: ======== 00110000-001cd000 r-xp 00000000 08:06 1098635 /usr/lib/libyaz.so.3.0.0 001cd000-001ce000 r--p 000bd000 08:06 1098635 /usr/lib/libyaz.so.3.0.0 001ce000-0026f000 rw-p 000be000 08:06 1098635 /usr/lib/libyaz.so.3.0.0 0026f000-00276000 r-xp 00000000 08:06 588872 /lib/libwrap.so.0.7.6 00276000-00277000 r--p 00006000 08:06 588872 /lib/libwrap.so.0.7.6 00277000-00278000 rw-p 00007000 08:06 588872 /lib/libwrap.so.0.7.6 00278000-00295000 r-xp 00000000 08:06 588757 /lib/libgcc_s.so.1 00295000-00296000 r--p 0001c000 08:06 588757 /lib/libgcc_s.so.1 00296000-00297000 rw-p 0001d000 08:06 588757 /lib/libgcc_s.so.1 00297000-0029a000 r-xp 00000000 08:06 588769 /lib/libgpg-error.so.0.4.0 0029a000-0029b000 r--p 00002000 08:06 588769 /lib/libgpg-error.so.0.4.0 0029b000-0029c000 rw-p 00003000 08:06 588769 /lib/libgpg-error.so.0.4.0 0029c000-0029d000 r-xp 00000000 08:06 1138335 /usr/lib/idzebra-2.0/modules/mod-text.so 0029d000-0029e000 r--p 00001000 08:06 1138335 /usr/lib/idzebra-2.0/modules/mod-text.so 0029e000-0029f000 rw-p 00002000 08:06 1138335 /usr/lib/idzebra-2.0/modules/mod-text.so 0029f000-002a2000 r-xp 00000000 08:06 1138334 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 002a2000-002a3000 r--p 00002000 08:06 1138334 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 002a3000-002a4000 rw-p 00003000 08:06 1138334 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 002a4000-002a8000 r-xp 00000000 08:06 1138332 /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 002a8000-002a9000 r--p 00004000 08:06 1138332 /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 002a9000-002aa000 rw-p 00005000 08:06 1138332 /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 002aa000-002ad000 r-xp 00000000 08:06 1138330 /usr/lib/idzebra-2.0/modules/mod-alvis.so 002ad000-002ae000 r--p 00002000 08:06 1138330 /usr/lib/idzebra-2.0/modules/mod-alvis.so 002ae000-002af000 rw-p 00003000 08:06 1138330 /usr/lib/idzebra-2.0/modules/mod-alvis.so 002b4000-002b5000 r-xp 00000000 00:00 0 [vdso] 002b5000-003d9000 r-xp 00000000 08:06 1098626 /usr/lib/libxml2.so.2.7.6 003d9000-003da000 ---p 00124000 08:06 1098626 /usr/lib/libxml2.so.2.7.6 003da000-003de000 r--p 00124000 08:06 1098626 /usr/lib/libxml2.so.2.7.6 003de000-003df000 rw-p 00128000 08:06 1098626 /usr/lib/libxml2.so.2.7.6 003df000-003e0000 rw-p 00000000 00:00 0 003e0000-00450000 r-xp 00000000 08:06 588762 /lib/libgcrypt.so.11.5.2 00450000-00451000 r--p 00070000 08:06 588762 /lib/libgcrypt.so.11.5.2 00451000-00453000 rw-p 00071000 08:06 588762 /lib/libgcrypt.so.11.5.2 00454000-005a7000 r-xp 00000000 08:06 613951 /lib/tls/i686/cmov/ libc-2.11.1.so 005a7000-005a8000 ---p 00153000 08:06 613951 /lib/tls/i686/cmov/ libc-2.11.1.so 005a8000-005aa000 r--p 00153000 08:06 613951 /lib/tls/i686/cmov/ libc-2.11.1.so 005aa000-005ab000 rw-p 00155000 08:06 613951 /lib/tls/i686/cmov/ libc-2.11.1.so 005ab000-005ae000 rw-p 00000000 00:00 0 005ae000-005d2000 r-xp 00000000 08:06 588750 /lib/libexpat.so.1.5.2 005d2000-005d4000 r--p 00024000 08:06 588750 /lib/libexpat.so.1.5.2 005d4000-005d5000 rw-p 00026000 08:06 588750 /lib/libexpat.so.1.5.2 005d5000-005da000 r-xp 00000000 08:06 1138331 /usr/lib/idzebra-2.0/modules/mod-dom.so 005da000-005db000 r--p 00004000 08:06 1138331 /usr/lib/idzebra-2.0/modules/mod-dom.so 005db000-005dc000 rw-p 00005000 08:06 1138331 /usr/lib/idzebra-2.0/modules/mod-dom.so 005dc000-005e2000 r-xp 00000000 08:06 1138333 /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 005e2000-005e3000 r--p 00005000 08:06 1138333 /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 005e3000-005e4000 rw-p 00006000 08:06 1138333 /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 005ef000-005f8000 r-xp 00000000 08:06 613955 /lib/tls/i686/cmov/ libcrypt-2.11.1.so 005f8000-005f9000 r--p 00008000 08:06 613955 /lib/tls/i686/cmov/ libcrypt-2.11.1.so 005f9000-005fa000 rw-p 00009000 08:06 613955 /lib/tls/i686/cmov/ libcrypt-2.11.1.so 005fa000-00621000 rw-p 00000000 00:00 0 0063b000-0063d000 r-xp 00000000 08:06 613957 /lib/tls/i686/cmov/ libdl-2.11.1.so 0063d000-0063e000 r--p 00001000 08:06 613957 /lib/tls/i686/cmov/ libdl-2.11.1.so 0063e000-0063f000 rw-p 00002000 08:06 613957 /lib/tls/i686/cmov/ libdl-2.11.1.so 00680000-006a4000 r-xp 00000000 08:06 613959 /lib/tls/i686/cmov/ libm-2.11.1.so 006a4000-006a5000 r--p 00023000 08:06 613959 /lib/tls/i686/cmov/ libm-2.11.1.so 006a5000-006a6000 rw-p 00024000 08:06 613959 /lib/tls/i686/cmov/ libm-2.11.1.so 006cf000-00705000 r-xp 00000000 08:06 1098631 /usr/lib/libxslt.so.1.1.26 00705000-00706000 r--p 00035000 08:06 1098631 /usr/lib/libxslt.so.1.1.26 00706000-00707000 rw-p 00036000 08:06 1098631 /usr/lib/libxslt.so.1.1.26 00721000-007b7000 r-xp 00000000 08:06 1097953 /usr/lib/libgnutls.so.26.14.12 007b7000-007bb000 r--p 00095000 08:06 1097953 /usr/lib/libgnutls.so.26.14.12 007bb000-007bc000 rw-p 00099000 08:06 1097953 /usr/lib/libgnutls.so.26.14.12 0084a000-00865000 r-xp 00000000 08:06 588698 /lib/ld-2.11.1.so 00865000-00866000 r--p 0001a000 08:06 588698 /lib/ld-2.11.1.so 00866000-00867000 rw-p 0001b000 08:06 588698 /lib/ld-2.11.1.so 00867000-00a18000 r-xp 00000000 08:06 1098117 /usr/lib/libicui18n.so.42.1 00a18000-00a19000 ---p 001b1000 08:06 1098117 /usr/lib/libicui18n.so.42.1 00a19000-00a1e000 r--p 001b1000 08:06 1098117 /usr/lib/libicui18n.so.42.1 00a1e000-00a20000 rw-p 001b6000 08:06 1098117 /usr/lib/libicui18n.so.42.1 00a34000-00a45000 r-xp 00000000 08:06 1097787 /usr/lib/libexslt.so.0.8.15 00a45000-00a46000 r--p 00010000 08:06 1097787 /usr/lib/libexslt.so.0.8.15 00a46000-00a47000 rw-p 00011000 08:06 1097787 /usr/lib/libexslt.so.0.8.15 00a4d000-00a60000 r-xp 00000000 08:06 588877 /lib/libz.so.1.2.3.3 00a60000-00a61000 r--p 00012000 08:06 588877 /lib/libz.so.1.2.3.3 00a61000-00a62000 rw-p 00013000 08:06 588877 /lib/libz.so.1.2.3.3 00a62000-00b99000 r-xp 00000000 08:06 1098132 /usr/lib/libicuuc.so.42.1 00b99000-00b9a000 ---p 00137000 08:06 1098132 /usr/lib/libicuuc.so.42.1 00b9a000-00ba2000 r--p 00137000 08:06 1098132 /usr/lib/libicuuc.so.42.1 00ba2000-00ba4000 rw-p 0013f000 08:06 1098132 /usr/lib/libicuuc.so.42.1 00ba4000-00ba6000 rw-p 00000000 00:00 0 00be5000-00bf4000 r-xp 00000000 08:06 1098518 /usr/lib/libtasn1.so.3.1.7 00bf4000-00bf5000 r--p 0000e000 08:06 1098518 /usr/lib/libtasn1.so.3.1.722:24:50-19/07 zebraidx(5450) [log] zebra_start 2.0.43 abd433d1a315576cf1f4a53f2c70365f9a76477f 22:24:50-19/07 zebraidx(5450) [log] config /etc/koha/zebradb/zebra-biblios.cfg 22:24:50-19/07 zebraidx(5450) [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-text.so 22:24:50-19/07 zebraidx(5450) [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 22:24:50-19/07 zebraidx(5450) [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 22:24:50-19/07 zebraidx(5450) [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-alvis.so 22:24:50-19/07 zebraidx(5450) [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-dom.so 22:24:50-19/07 zebraidx(5450) [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 22:24:50-19/07 zebraidx(5450) [warn] previous transaction didn't reach commit 22:24:50-19/07 zebraidx(5450) [log] enabling shadow spec=/var/lib/koha/zebradb/biblios/shadow:20G 22:24:50-19/07 zebraidx(5450) [log] cache_fname = /var/lib/koha/zebradb/biblios/shadow/cache 22:24:50-19/07 zebraidx(5450) [log] zebra_stop: 0.04 0.00 0.04 ==================== CLEANING ==================== root@desktop:/usr/share/koha/bin/migration_tools# After this i m not able to search in both OPAC or Intranet. what should i do/ and wht the above log files says? Note: plz tell me the process so that the zebra automatically make index at certain time. (i know it is job of cron but which user will run this command, etc) -- Regards Abdul Vali Librarian - ASE School

2 1

Koha and Computer Management Systems
by Melissa Parker 19 Jul '11

19 Jul '11

Good Morning All, My system is looking into computer management systems for our library. We need one that interfaces with KOHA. Currently we have been looking at cybrarian and libki, but are there any others that you recommend that are work well AND interfaces with KOHA? Thanks for your help in this search Melissa Parker SEKLS

5 6

How to extract tag 050 data only in marcxml field from biblioitems table
by Yohannes Mulugeta 19 Jul '11

19 Jul '11

Dear folks, I'm using Koha ver 3.2. I want to extract the Title, Author, itemcallnumber, (LC call no.), barcode, holdingbranch directly from mySQL tables. But the itemcallnumber field is empty. The call number is available in the marcxml and marc field in biblioitems table. After migrating the bibliographic records from verion 2.4 to the Koha 2.9 and then Koha 3.2, the classification field which we used to store our call number is not available in the current biblioitems table. So, is there a way to select the call number data (tag 050) only from marcxml or marc field in the biblioitem table. Becuase most of our call number were stored in the older version of Koha, classification.biblioitems, are not available in Koha version 3.2. As a result the itemcallnumber field is almost empty. Any help please. Yohannes Mulugeta Addis Ababa University Libraries

2 1

es.koha-community.org available
by Tomas Cohen Arazi 19 Jul '11

19 Jul '11

Dear Koha Community We are pleased to announce the availability of the spanish-speaking community's Koha portal. You will find in it the translated official announcements and several resources and news related to the spanish-speaking Koha community. We hope to get your feedback and suport to make this site full of relevant information for the community. The address: http://es.koha-community.org Martín Longo Miguel Angel Calvo Tomás Cohen Arazi Bernardo González Kriegel Alejandro Tiraboschi ============================================= Estimada comunidad de Koha. Estamos orgullosos de anunciar la puesta en linea del nuevo portal de la comunidad hispanohablante de Koha. En él podrán encontrar los anuncios oficiales en español, como así también como recursos y noticias vinculadas con la comunidad hispanohablante de Koha. Esperamos sus comentarios y aportes para hacer de este un portal útil y rico en información para la comunidad. Para acceder, dirigirse a: http://es.koha-community.org Martín Longo Miguel Angel Calvo Tomás Cohen Arazi Bernardo González Kriegel Alejandro Tiraboschi

1 0

Searches problems (acqdate and callnumber)
by Vitor Fernandes 19 Jul '11

19 Jul '11

Hi there. I'm using Koha 3.2.6 with UNIMARC and i'm facing two problems with Koha searches. First i'm having a problem with acquisition date search. For example if i search for "2011-06-30" are returned the record that have items with that acquisition date bu also records that items are loaned or returned on that date. I've checked record.abs and acqdate is mapped to 995^5 and not to any other field. Why Zebra is searching in other subfields that 995^5? What can I do to solve this problem? The second problem is with callnumber ordering. For example the following callnumbers: G.122 VIA*Mar G.122 VIA*Mar 2ª ed G.122 AGU*Mar are ordered (0-9 to A-Z) in this; G.122 VIA*Mar G.122 AGU*Mar G.122 VIA*Mar 2ª ed That ordering is wrong... Should be: G.122 AGU*Mar G.122 VIA*Mar G.122 VIA*Mar 2ª ed What is wrong with this? Anyone have a solution to this? Thanks in advance. Regards. Vitor Fernandes

1 1

Issue with renewals
by Peel Lisa 19 Jul '11

19 Jul '11

Hello We upgraded to 3.4 at the end of June. Yesterday I was doing some staff training and noticed that if I issue a book to a patron and on the same day renew it, the date keeps rolling forward instead of renewing to the same date. For example, I issued a 1 week loan to a patron yesterday, original due date 25th July. I renewed it yesterday the first time, instead of the due date remaining the 25th, it was now 1st August. Second time, 8th August. Third time 15th August. Is there anything in the circ rules (or anywhere else for that matter!) to stop this happening? If any of our students realise it will do this I can envisage them renewing their items several times immediately to get longer loans before other students can place holds. Any help (as always) appreciated! Lisa Lisa Peel Librarian "César Ritz" Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel(a)ritz.edu<mailto:lisa.peel@ritz.edu> http://www.ritz.edu/ - http://www.culinaryarts.ch/ +++ 25 Years "César Ritz" Colleges Switzerland +++

2 3