Re: [Koha] Deduplicate authorities

2012-01-13 Thread Stefano Bargioni
 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

2012-01-13 Thread Mason James

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

2012-01-13 Thread Hugo Agud
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

2012-01-13 Thread ed c
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

2012-01-13 Thread Jared Camins-Esakov
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

2012-01-13 Thread Wagner, Jane
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

2012-01-13 Thread ed c
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

2012-01-13 Thread Alen Vodopijevec
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

2012-01-13 Thread Louis Buteau-Vaillancourt

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

2012-01-13 Thread anaisabel.gonzalez
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

2012-01-13 Thread Chris Cormack
* 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

2012-01-13 Thread ed c
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