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

How to create a message box with 3 buttons in Koha?
by Mathieu Saby 19 Sep '13

19 Sep '13

Hello I would like to work on Bug 7791 "Deleting basket should not delete all existing orders without warning" My idea : If there are non cancelled orders in the baskets, create a js popup alert giving the choice between : - Cancel (do NOT supress the basket) - Supress the basket and all the orders within - Supress the basket and all the orders within AND all the records if possible But I don't know the best way for creating a popup with 3 choices according to Koha guidelines (maybe jquery "dialog" box?). All examples I found are "confirm" boxes with only 2 buttons. Could you tell me how you would do that, or an example of a template with currently 3 buttons in a js popup ? Regards, Mathieu -- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby(a)univ-rennes2.fr

2 3

2013-09-23 Global bug squashing day - come join the fun!
by Magnus Enger 19 Sep '13

19 Sep '13

Dear Community! Some of the dates in Galen's RM proposal* are drawing dangerously near: 25 September 2013: feature slush** 3 October 2013: feature freeze 31 October 2013: string freeze 21 November 2013: release of 3.14.0 That's right, feature slush is just a few days away. And we have something of a queue of things that would be cool to have in 3.14: http://dashboard.koha-community.org/ So let's join forces and knock those numbers way down, on Monday 23rd: http://wiki.koha-community.org/wiki/2013-09-23_Global_bug_squashing_day That page should give you some clues about things you can do, but if you are unsure about how you can contribute, don't hesitate to jump on the IRC and ask for help: http://koha-community.org/get-involved/irc/ And rumour has it there will be a QA Sprint immediately the GBSD, but Katrin will have to fil in the details of that. Have fun! Magnus * See http://wiki.koha-community.org/wiki/Proposal_for_RM_3_14_gmcharlt ** Excerpt from the last general IRC meeting: <cait> gmcharlt: can you define feature slush a little? want to prevent any misunderstandings if possible :) <gmcharlt> cait: feature slush -- any new features that have hit passed QA by that date will be included in 3.14, assuming they don't raise signfiicant QA concerns on my part <gmcharlt> new features that have /not/ hit passed QA by feature slush are more liable to be left for the next release; if you want something that misses slush to make it in, you'll need to advocate for it <thd> Why does slush have the name slush? <gmcharlt> a partial freeze, of course

2 1

About "I'm just a bot" on bugzilla
by Paul Poulain 18 Sep '13

18 Sep '13

Hello koha-devel, I see that many patches are now automatically marked as "patch doesn't apply", automatically. If I'm not wrong, it's Chris C. that setup this bot. Useful job. 2 questions: * Has this been discussed/announced somewhere ? Not on koha-devel, somewhere else ? * the script is marking as "patch does not apply" patches have a conflict. Does it mark as such patches that only have an updatedatabase/sysprefs.sql conflict ? Those conflicts happends on every updatedatabase push, it would be a pain to have to rebase them on every push. 2 options to fix this: - push the new updatedb, that has been tested a lot, is passed QA for a while (bug 7167) - Prevent updatedatabase/sysprefs.sql conflicts from resulting in a "patch does not apply" status -- Paul POULAIN - BibLibre http://www.biblibre.com Free & Open Source Softwares for libraries Koha, Drupal, Piwik, Jasper

2 2

Extended attributes, making them generic ?
by Paul Poulain 18 Sep '13

18 Sep '13

Hi Koha-devel, We've a customer that is asking for new -probably specific- fields in the subscription. For example, what they called: "subscription origin". I was wondering if a good way to do that would be to transform our "borrowers attributes" to become "extended attributes". Those extended attributes being managed as patron, subscription, acquisition,... attributes. What it means : * changing the table name ! (now, it's borrowers_attributes and borrowers_attribute_types) * removing foreign keys to borrowers table. * add a field "scope" (or similar name), that would be borrower, subscription, acquisition, ... * update all the code to handle this "scope" field. For example, borrower_attributes.borrowernumber would become "extended_attributes.externalid", pointing to the borrowernumber, the subscriptionid or the ordernumber. What do you think of the idea ? (I don't promize that, even if everybody says it's a wonderful idea, we will do it) -- Paul POULAIN - BibLibre http://www.biblibre.com Free & Open Source Softwares for libraries Koha, Drupal, Piwik, Jasper

4 3

[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 13 Sep '13

13 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