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

[Koha] corporate author field does not show in staff normal view
by Ernesto Arias 16 Sep '13

16 Sep '13

Version koha:3.6.7 Hi, i´ve been working with the koha software and on the opac, a mistake comes up.When i try to find any given book, if its author it´s a corporative one, it doesn´t show next to the name of the book, just like it does when it´s a particular author. Serching in google I found online this subject has already been treated byIrakli Garibashvili and Mirko that are from this mailing list.My question is whether the solution foundThanks a lot!Ernesto

1 0

Re: [Koha-devel] [Koha] New newsletter editor volunteer
by Daniel Grobani 16 Sep '13

16 Sep '13

You're welcome, Estel! I'm glad I've been able to contribute to the community. Daniel On Mon, Sep 16, 2013 at 10:01 AM, Estel Porras <orlib(a)yahoo.com> wrote: > Hi, I just wanted to thank Daniel for your wonderful service to the list! > Welcome Chad. > > > Have a great day, ~Estel~ > Orland Free Library > 333 Mill St. > Orland CA. 95963 > [530]865-1640 > > ________________________________ > From: Daniel Grobani <danielg.koha(a)gmail.com> > To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz>; > koha-devel(a)lists.koha-community.org > Sent: Friday, September 13, 2013 3:34 PM > Subject: [Koha] New newsletter editor volunteer > > Hi, > > Chad Roseburg of North Central Regional Library has volunteered to > assume the role of community newsletter editor starting with the > December issue. Thanks, Chad! > > As I recall, when I took over from Nicole the only requirement was the > willingness to do it. What's the current process for Chad to get > approved by the community? > > Thanks, > Daniel Grobani > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > >

1 0

Re: [Koha-devel] 6xx fields with no RLIN
by Paul 15 Sep '13

15 Sep '13

At 01:14 PM 9/15/2013 -0300, Bernardo Gonzalez Kriegel wrote: >Paul, > >if what you are trying to do is link biblios to authorities, >you could use >misc/<http://link_bibs_to_authorities.pl>link_bibs_to_authorities.pl script. > >First try with >misc/<http://link_bibs_to_authorities.pl>link_bibs_to_authorities.pl -v -l >-test >to do a test, then without -test. Many thanks Bernardo, It will take a fair amount of "double checking" (and I'm short of cataloguers over the week-end), but it's certainly doing something in the sandbox. But what does "fuzzily linked" mean, please? Running a "SELECT ... WHERE length(650$a) != 0 and length(650$9)= 0 gives me: 5210 rows in set (1.06 sec) so ~5000 auths without RLINs (they're all 650s as far as I can tell, no 610s etc) and perl ./usr/share/koha/bin/link_bibs_to_authorities.pl -v -l -test gives me a summary: Bib authority heading linking report ======================================================= Linker module: C4::Linker::Default Run started at: 09/15/13 17:25:22 Run ended at: 09/15/13 17:29:22 Total run time: 239255 ms Number of bibs checked: 31163 Number of bibs modified: 0 Number of bibs with errors: 0 Number of headings linked: 48310 Number of headings unlinked: 0 Number of headings fuzzily linked: 27818 **** Ran in test mode only **** Many thanks - Paul >Don't forget to reindex. > >Regards, >Bernardo >Â > >--Â >Bernardo Gonzalez Kriegel ><mailto:bgkriegel@gmail.com>bgkriegel(a)gmail.com > > >On Sun, Sep 15, 2013 at 12:53 PM, Paul ><<mailto:paul.a@aandc.org>paul.a(a)aandc.org> wrote: >We have found (much too late!), several thousand instances of 6xx >Authority fields with valid $a but missing the $9 (RLIN); I would >sincerely appreciate assistance in correcting this. > >The $a fields are very repetitive, only about twenty in total; to do this >"by hand" in the staff interface is "easy" but would be nearly three weeks >work at say one minute per record. > >To do this (obviously starting in the sandbox) by manipulating the MySQL >db (biblioitems.marc and biblioitems.marcxml might be the way to go, but I >have no experience UPDATEing into longblobs and longtexts. > >So, (a) is there an easier way? Â Or (b) Has anyone got a pre-built MySQL >script for UPDATEing into long blobs and text? > >Many thanks for any suggestions. > >Best - Paul > >P.S. Â I've tried along the lines of: >UPDATE biblioitems (marc, '//datafield[@tag="650"]/subfield[@code="9"]') = >12345 >WHERE(marc, '//datafield[@tag="650"]/subfield[@code="a"]') = 'Authority in >question' >AND (marc, '//datafield[@tag="650"]/subfield[@code="9"]') IS NULL; > >but UPDATE seems to fail for marc and marcxml (longtext and longblob), and >of course INSERT will not take a WHERE argument. I can't find the field >structures in SchemaSpy -- but even with them, I'm not certain that I'm on >the right track. > >_______________________________________________ >Koha-devel mailing list ><mailto:Koha-devel@lists.koha-community.org>Koha-devel(a)lists.koha-community.org >http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >website : <http://www.koha-community.org/>http://www.koha-community.org/ >git : <http://git.koha-community.org/>http://git.koha-community.org/ >bugs : <http://bugs.koha-community.org/>http://bugs.koha-community.org/ > --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

2 1

6xx fields with no RLIN
by Paul 15 Sep '13

15 Sep '13

We have found (much too late!), several thousand instances of 6xx Authority fields with valid $a but missing the $9 (RLIN); I would sincerely appreciate assistance in correcting this. The $a fields are very repetitive, only about twenty in total; to do this "by hand" in the staff interface is "easy" but would be nearly three weeks work at say one minute per record. To do this (obviously starting in the sandbox) by manipulating the MySQL db (biblioitems.marc and biblioitems.marcxml might be the way to go, but I have no experience UPDATEing into longblobs and longtexts. So, (a) is there an easier way? Or (b) Has anyone got a pre-built MySQL script for UPDATEing into long blobs and text? Many thanks for any suggestions. Best - Paul P.S. I've tried along the lines of: UPDATE biblioitems (marc, '//datafield[@tag="650"]/subfield[@code="9"]') = 12345 WHERE(marc, '//datafield[@tag="650"]/subfield[@code="a"]') = 'Authority in question' AND (marc, '//datafield[@tag="650"]/subfield[@code="9"]') IS NULL; but UPDATE seems to fail for marc and marcxml (longtext and longblob), and of course INSERT will not take a WHERE argument. I can't find the field structures in SchemaSpy -- but even with them, I'm not certain that I'm on the right track.

2 1

Call for news for the September newsletter
by Daniel Grobani 14 Sep '13

14 Sep '13

Dear Koha kommunitarians, I'm harvesting news for this month's newsletter. Please send me by the 23rd anything you think your fellow community members might like to know about. "News" can be as short as a sentence or as long as a paper. I especially encourage you to send me a line or two for the gossip/society column about what you're currently working on. And if you know of a go-live not announced on the list, please be sure to let me know about it. Thanks, Daniel Grobani

1 0

Bugzilla account changes?
by Cab Vinton 12 Sep '13

12 Sep '13

I'm moving to a new job (to another Koha library!) and I'd like to take my Bugzilla a/c with me. The login appears to be locked to my old work email address, however. Is there an admin who could change the login and/ or help me manage the transfer? Thanks, Cab Vinton Sanbornton PL -------> Plaistow PL

2 2

Display856uAsImage preference
by Edisnel C. C. 12 Sep '13

12 Sep '13

Greetings, I am working with Koha 3.12, in Administration I set the Display856uAsImage preference to "Details page only", but the note says : The corresponding XSLT option must be turned on. What option I must to turn on? Where can I find it? Thank you. ------- "¿Quieres subir? Comienza por descender. Planeas una torre que atravesará las nubes? Coloca primero el fundamento de la humildad." ~ San Agustín __________________________________________________ "Todos el 12 de Septiembre con una Cinta Amarilla" FIN A LA INJUSTICIA, LIBERENLOS YA!! http://www.antiterroristas.cu http://justiciaparaloscinco.wordpress.com

2 1

Kohacon 2014 proposals: deadline 15 September 18 UTC
by Mirko 11 Sep '13

11 Sep '13

Dear lists, this is the last reminder that the deadline for Kohacon 2014 proposals is 15 September. If you would like to host next year's Kohacon, please add your proposal to the Wiki now. http://wiki.koha-community.org/wiki/KohaCon2014_Proposals I hereby arbitrarily declare 18 UTC the official closing time for proposals. -- Mirko

1 0

Koha General IRC Meeting today at 18:00 UTC
by Owen Leonard 11 Sep '13

11 Sep '13

The next Koha General IRC Meeting is today at 18:00 UTC: http://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+General+IRC+M… The agenda is here: http://wiki.koha-community.org/wiki/General_IRC_meeting,_11th_September_2013 I hope to see you there, Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 0

Postmortem on Git server outage
by Galen Charlton 10 Sep '13

10 Sep '13

Hi, First, my thanks to Kyle for bouncing the Git server this morning. Upon my review of the logs, I determined that the outage was initiated by a single host making 79 requests to download tarball snapshots from Gitweb. This occurred between 05:55:22 and 07:27:19. A significant number of the requests were made between 05:58 and 06:05. Creating a tarball snapshot is a relatively expensive operation, one that Gitweb provides as a convenience but which does not scale well as currently implemented. Further analysis of the logs suggests that at least some other outages or slowness of the Git server can be attributed excessive snapshot requests. For now, I have turned off the snapshot-download functionality. While I'm not inclined to turn it on again, the logs do indicate that there may be some people using this feature legitimately. If you are one of those people, please let me know if your needs can be met by (say) a cronjob that produces a daily static tarball of the current state of master. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

1 0