Re: [Koha-devel] Advice on syncing and DBIC

2014-01-21 Thread Robin Sheat
Magnus Enger schreef op di 21-01-2014 om 11:17 [+0100]: > - Attributes are less intrusive, they only need to be added to systems > that want to sync with the Norwegian national patron database. I'd tend to go towards attributes, but... > - New columns could be re-used by others, to implement othe

Re: [Koha-devel] Advice on syncing and DBIC

2014-01-21 Thread Kyle Hall
I do believe use of DBIx::Class in existing subs is both good and encouraged! That is, as long as there are no regressions! It seems like a good idea to add that field to the borrowers table. I'm sure there are many Koha administrators that need to sync data between Koha and other systems, and it s

[Koha-devel] Advice on syncing and DBIC

2014-01-21 Thread Magnus Enger
Hi! I am working on Bug 11401 - Add support for Norwegian national library card: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11401 The goal is to sync patrons in Koha back and forth to the Norwegian national patron database. In order to do this I need to keep track of - which patrons

Re: [Koha-devel] SQL Query : multiple items

2014-01-21 Thread Fridolin SOMERS
Hie, It works weel, but it would be more explicite/logic to use itemnumber in HAVING : SELECT biblio.biblionumber, CONCAT('href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.title,'') AS title, biblio.author, GROUP_CONCAT(items.ccode SEPARATOR ',

Re: [Koha-devel] Suggestion for OPAC theme bug fix patches

2014-01-21 Thread Fridolin SOMERS
++, thanks Galen Le 10/01/2014 16:53, Tomas Cohen Arazi a écrit : +1 I'm glad that you proposed that Galen, thanks! To+ On Fri, Jan 10, 2014 at 12:28 PM, Galen Charlton wrote: Hi, If you're writing a patch that fixes a bug with an OPAC template file, you'll need to at least touch the Boot