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

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

[QA] QA Sprint Day
by Fischer, Katrin 10 Sep '13

10 Sep '13

Hello all, during our QA team meeting last week one of the ideas that came up was holding a QA Sprint Day. We wasted no time and set a date for it – it’s going to take place this Thursday 12th! I have added the item to the agenda for the IRC meeting on 11th: http://wiki.koha-community.org/wiki/General_IRC_meeting,_11th_September_2013 And there is also a new wiki page dedicated to our QA Sprint Day activities: http://wiki.koha-community.org/wiki/2013-09-12_QA_Sprint_day Please join us - there is a lot of signing off, rebasing, discussing and testing to be done! Katrin

1 0

Question of sax parser
by Samuel Desseaux 05 Sep '13

05 Sep '13

Hi, During the install, when i run this command "./sax_parser_print.pl", i've the following error Koha wants something like: XML::LibXML::SAX::Parser=HASH(0x81fe220) You have: XML::SAX::Expat=HASH(0x99127b0) Looks bad, check INSTALL.* documentation. I check my ParserDetails.ini and something miss (Sax Parser) [XML::SAX::PurePerl] http://xml.org/sax/features/namespaces = 1 [XML::LibXML::SAX] http://xml.org/sax/features/namespaces = 1 [XML::SAX::Expat] http://xml.org/sax/features/namespaces = 1 http://xml.org/sax/features/external-general-entities = 1 http://xml.org/sax/features/external-parameter-entities = 1 I think the following lines give the main reason but i don't know how to do root@kohadev:/home/koha/kohaclone# cpan XML::LibXML::SAX::Parser Going to read '/root/.cpan/Metadata' Database was generated on Thu, 05 Sep 2013 04:29:04 GMT Running install for module 'XML::LibXML::SAX::Parser' Running make for S/SH/SHLOMIF/XML-LibXML-2.0104.tar.gz Checksum for /root/.cpan/sources/authors/id/S/SH/SHLOMIF/XML-LibXML-2.0104.tar.gz ok CPAN.pm: Going to build S/SH/SHLOMIF/XML-LibXML-2.0104.tar.gz enable native perl UTF8 running xml2-config...didn't manage to get libxml2 config, guessing options: LIBS='-L/usr/local/lib -L/usr/lib -lxml2 -lm' INC='-I/usr/local/include -I/usr/include' If this is wrong, Re-run as: $ /usr/bin/perl Makefile.PL LIBS='-L/path/to/lib' INC='-I/path/to/include' Checking for ability to link against xml2...no Checking for ability to link against libxml2...libxml2, zlib, and/or the Math library (-lm) have not been found. Try setting LIBS and INC values on the command line Or get libxml2 from http://xmlsoft.org/ If you install via RPMs, make sure you also install the -devel RPMs, as this is where the headers (.h files) are. Also, you may try to run perl Makefile.PL with the DEBUG=1 parameter to see the exact reason why the detection of libxml2 installation failed or why Makefile.PL was not able to compile a test program. No 'Makefile' created SHLOMIF/XML-LibXML-2.0104.tar.gz /usr/bin/perl Makefile.PL INSTALLDIRS=site -- NOT OK Running make test Make had some problems, won't test Running make install Make had some problems, won't install Could not read metadata file. Falling back to other methods to determine prerequisites Thank you for your help Best regards, Samuel

2 1