Re: [Koha] Deduplicate authorities
There is not any authority deduplicator at present included in Koha. I proposed bug 7419 because it would be very useful to have one, but that project has not been funded yet. It is possible that someone else has already written one, in which case I would encourage that person to contribute said script to the community, 'cause lots of us would love to have it. IMHO, authority deduplication is similar to authority unlink/link. Consider two terms like Bargioni, Stefano, 1959- linked to N1 biblios and Bargioni, Stefano linked to N2 biblios. You need to unlink N2 biblios from the second term, i.e. link them to the first one. Deduplication can be automatic, while the step of choosing term-from and term-to for unlink/link biblios must be manual. I added this comment to bug 7419 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7419. Stefano ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to let Koha support Chinese Character searching
On 2012-01-13, at 7:40 PM, Peter Zhao wrote: Hi, I have installed Koha 3.06.02 and everything is good. It can searching English very well,but can't searching Chinese character properly. Could anyone know how to hanld this problem? its a very tricky problem... :/ currently, zebra doesn't handle CKJ text very well for searching Solr does a better job, with a few CKJ tokenizers to choose from. try setting up a Koha+SOLR system, from BibLibre (i haven't done this before) fyi: this is one of the big reasons people are keen to move Koha to Solr - better searching capabilities for international character-sets PGP.sig Description: This is a digitally signed message part ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] linking bib records
Dear colleagues We have one customer that have several isbn in the same bib record, their original intention is give at the same record, info of the isbn work.. but also other related isbn ..like study guides to the original work. sample: http://ec2-79-125-63-173.eu-west-1.compute.amazonaws.com/cgi-bin/koha/opac-detail.pl?biblionumber=10717 here you have one record with 3 isbn, We think that it should be an analytical record, in the same sample there is one of the analytical.. What would you do? ... leave in 022 and become that field linkable... move to the analytic... any 7XX? any suggest will be welcomed! -- *Hugo Agud - Orex Digital * *www.orex.es* * * Director Avenida Sarriá 29 · 08029 Barcelona http://twitter.com/OrexDigital :http://orexsl.blogspot.comhugoaguda - Tel: 93 539 40 70 Fax: 93 539 33 30 ha...@orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Sessions table corrupt in Koha 3.0
I am trying to work on a small, older Koha (3.0.2)install that is not longer working. Koha is having issues connecting to the database after a problem with diskspace. While checking the Mysql and log files, I've come across with a problem with the sessions table in Koha. a CHECK TABLES on it or a REPAIR just hangs forever. They have backups so I should be able to restore the whole database (or possibly just this table) but before I do, does anyone have any other alternative solutions? What does this table do? Thanks, Edward ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Sessions table corrupt in Koha 3.0
Edward, Drop the table then recreate it. Your users will have to log in again, but that's it. I'm not sure that will reclaim the disk space, though. Regards, Jared 2012/1/13 ed c terrapi...@yahoo.com I am trying to work on a small, older Koha (3.0.2)install that is not longer working. Koha is having issues connecting to the database after a problem with diskspace. While checking the Mysql and log files, I've come across with a problem with the sessions table in Koha. a CHECK TABLES on it or a REPAIR just hangs forever. They have backups so I should be able to restore the whole database (or possibly just this table) but before I do, does anyone have any other alternative solutions? What does this table do? Thanks, Edward ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Jared Camins-Esakov Bibliographer, C P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Sessions table corrupt in Koha 3.0
The sessions table tracks logins to the system, and can drastically slow your system down if it gets too large. You can safely truncate it entirely; doing so will disconnect anyone presently logged in but it sounds like you can’t log in at the moment anyway. There is a script (misc/cronjobs/cleanup_database.pl) which has an option to clear the table overnight as a cron job, to keep it from getting too big. Jane Wagner Senior Project Manager LibLime, a division of PTFS Content Management and Library Solutions 11501 Huff Court North Bethesda, MD 20895 (301) 654-8088 x 151 jwag...@liblime.com jwag...@ptfs.com *From:* koha-boun...@lists.katipo.co.nz [mailto: koha-boun...@lists.katipo.co.nz] *On Behalf Of *ed c *Sent:* Friday, January 13, 2012 11:57 AM *To:* koha@lists.katipo.co.nz *Subject:* [Koha] Sessions table corrupt in Koha 3.0 I am trying to work on a small, older Koha (3.0.2)install that is not longer working. Koha is having issues connecting to the database after a problem with diskspace. While checking the Mysql and log files, I've come across with a problem with the sessions table in Koha. a CHECK TABLES on it or a REPAIR just hangs forever. They have backups so I should be able to restore the whole database (or possibly just this table) but before I do, does anyone have any other alternative solutions? What does this table do? Thanks, Edward ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Sessions table corrupt in Koha 3.0
Thanks Jared. This is probably my solution, however, I can't seem to drop this table. This is probably a basic mysql question, but how can I force a drop or remove a lock? When I try to drop the table, it just sits there waiting for the table: mysql show processlist; ++---+---+--+-+--+---+-+ | Id | User | Host | db | Command | Time | State | Info | ++---+---+--+-+--+---+-+ | 7 | kohaadmin | localhost | koha | Query | 31 | Waiting for table | drop table sessions | | 8 | kohaadmin | localhost | koha | Query | 0 | NULL | show processlist | ++---+---+--+-+--+---+-+ 2 rows in set (0.00 sec) mysql IS there a way to force the drop or unlock the table? I am having no luck searching google. Edward From: Jared Camins-Esakov jcam...@cpbibliography.com To: ed c terrapi...@yahoo.com Cc: koha@lists.katipo.co.nz koha@lists.katipo.co.nz Sent: Friday, January 13, 2012 12:01 PM Subject: Re: [Koha] Sessions table corrupt in Koha 3.0 Edward, Drop the table then recreate it. Your users will have to log in again, but that's it. I'm not sure that will reclaim the disk space, though. Regards, Jared 2012/1/13 ed c terrapi...@yahoo.com I am trying to work on a small, older Koha (3.0.2)install that is not longer working. Koha is having issues connecting to the database after a problem with diskspace. While checking the Mysql and log files, I've come across with a problem with the sessions table in Koha. a CHECK TABLES on it or a REPAIR just hangs forever. They have backups so I should be able to restore the whole database (or possibly just this table) but before I do, does anyone have any other alternative solutions? What does this table do? Thanks, Edward ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Jared Camins-Esakov Bibliographer, C P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.4.7. // additem.pl
Hi! We have a strange behaviour on test upgrade 3.4.4 - 3.4.7. with adding an item (additem.pl) Select options for all fields that have value 0 (2 or 4 for example) for hidden variable in subfield constraints in MARC bibliographic framework are not shown on Additem form. I'm not sure if this is a feature or bug. The only thing that I can see is an addition at around line 203 of additem.pl: if ($subfieldlib-{'hidden'}) { $subfield_data{marc_value} = qq(input type=hidden $attributes / $authorised_lib{$value}); } else { $subfield_data{marc_value} =CGI::scrolling_list( # FIXME: factor out scrolling_list -name = field_value, -values = \@authorised_values, -default = $value, -labels = \%authorised_lib, -override = 1, -size = 1, -multiple = 0, -tabindex = 1, -id = tag_.$tag._subfield_.$subfieldtag._.$index_subfield, -class= input_marceditor, ); } If I remove the first IF statement or if I set hidden to 0 in MARC bibliographic framework settings for that particular subfield, select options are shown. We have a same issue with 3.6.2 testing Koha. Any suggestions are welcome :). regards, alen -- Alen Vodopijevec (a...@irb.hr) Library, Rudjer Boskovic Institute tel.: +385 1 456 0954 (x1293) gsm: +385 98 584 045 http://lib.irb.hr ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Request to be added to Koha Support Provider
Hi everyone, I hope I'm sending this to the right email. It's a request to be added to the Koha community website, support provider list. Company Name: Libéo Contact Person: Jean-Francois Rousseau Contact email: jrouss...@libeo.com Website: www.libeo.com Telephone: 1 877 969-8324 Address: 6700 Boul. Pierre-Bertrand, #209, Québec, QC, Canada, G2J 0B4 Short description of your services: We are offering installation, customization and support for Koha. We currently are hosting 22 high schools in our environnement. Koha offering webpage : http://www.libeo.com/services/web-applicatif/systeme-integre-de-gestion-de-bibliotheque.html Thank you ! -- *Louis Buteau-Vaillancourt, Ing., M.Sc.* Directeur de production 418 520-0739, poste 146 _louis.buteau@libeo.com_ mailto:louis.but...@libeo.com *Libéo* */ Web et applications libres* 6700, boulevard Pierre-Bertrand, bureau 209 Québec (Québec) G2J 0B4 S. F. : 1 877 969-8324 Téléc. : 418 520-4554 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Marc 21 for Koha 3.4
Dear all, I have a question about the Marc 21 update used in the default framework of Koha version 3.4. Does anybody can tell me which is the Marc 21 Update used? The WorkGroup into the Koha-Kobli Community in Spanish (http://kobli.bage.es) is working in analyze the new functionalities for Koha and our customized distribution named Kobli. In order to study the Marc 21 – RDA we need to know the Marc 21 Update and if Koha Community has worked on it or has any report about it. (For further information about KOBLI , please see Koha archive http://lists.katipo.co.nz/pipermail/koha/2011-April/028481.html) Kind regards in advance, Nani Gonzalez Saez Koha-Kobli Community http://kobli.bage.es Subdirectorate General of Library Coordination Secretary of State for Culture. Spain. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Marc 21 for Koha 3.4
* anaisabel.gonza...@mcu.es (anaisabel.gonza...@mcu.es) wrote: Dear all, I have a question about the Marc 21 update used in the default framework of Koha version 3.4. Does anybody can tell me which is the Marc 21 Update used? The WorkGroup into the Koha-Kobli Community in Spanish (http://kobli.bage.es) is working in analyze the new functionalities for Koha and our customized distribution named Kobli. In order to study the Marc 21 – RDA we need to know the Marc 21 Update and if Koha Community has worked on it or has any report about it. (For further information about KOBLI , please see Koha archive http://lists.katipo.co.nz/pipermail/koha/2011-April/028481.html) Kind regards in advance, Nani Gonzalez Saez Koha-Kobli Community http://kobli.bage.es Koha 3.6.2 (soon to be .3) is the current stable release. Perhaps looking at that (3.8.0 will be released April 22) will be more useful? But as far as I know the default MARC21 framework has not been updated, I have seen frameworks with the RDA fields in them. And since in Koha 3.6.x you can import and export frameworks, adding RDA support in MARC (even though the Library of Congress has decided that is not the right thing to do) is possible. Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand signature.asc Description: Digital signature ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Sessions table corrupt in Koha 3.0
Truncating should work fine, but I saw somewhere (I think in the e-mail archives not positive), that it could take longer. I'm not sure that is true or not since I didn't try it. The advantage to truncate though would be I wouldn't have had to look up how to recreate the table. Edward From: Mason James m...@kohaaloha.com To: Jared Camins-Esakov jcam...@cpbibliography.com Cc: ed c terrapi...@yahoo.com; koha@lists.katipo.co.nz koha@lists.katipo.co.nz Sent: Friday, January 13, 2012 10:22 PM Subject: Re: [Koha] Sessions table corrupt in Koha 3.0 On 2012-01-14, at 6:01 AM, Jared Camins-Esakov wrote: Edward, Drop the table then recreate it. Your users will have to log in again, but that's it. I'm not sure that will reclaim the disk space, though. just curious, why not just truncate the table?___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha