Re: [Koha] Report question

2016-04-22 Thread Coehoorn, Joel
This is one of those things that would be EASY in Sql Server, Oracle, or
Postgresql, which all have a split() function that can produce a set
suitable for use with an IN() clause.

Sadly, MySql has failed to keep pace with other DB platform, going even
back before it's acquisition by Oracle. It lacks split and a few other
functions, uses non-compliant NULL handling by default, does not have CTEs,
Windowing Functions, a lateral join/APPLY operation, or a FULL JOIN
operation. I'd really love the option of running Postgresql instead. These
days, it outclasses MySql in pretty much every category, and has done so
for nearly a decade now.



Joel Coehoorn
Director of Information Technology
402.363.5603
*jcoeho...@york.edu *

The mission of York College is to transform lives through
Christ-centered education and to equip students for lifelong service to
God, family, and society

On Fri, Apr 22, 2016 at 1:48 AM, Graham, Stephen 
wrote:

> Thanks François, I suspected as much.  I've tried doing things like:
>
> 35','36','37
>
> , but the report tool just escapes the ' with a backslash. Very
> frustrating!
>
> I guess I could use an OR, but I don't know how many values would be
> passed each time.  I guess I'll need to write a custom cgi script which
> outputs some JSON for what I want.
>
> Cheers, Stephen
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Francois
> Charbonnier
> Sent: 21 April 2016 17:14
> To: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Report question
>
> Hi Stephen,
>
> I don't see any workaround but right now, it can't work.
>
> Let's say the <> value is : 34,35,36
>
> With the IN operator, you have to get the query this way : IN(34,35,36)
> but with the <>, you'll get IN('34,35,36') instead. The query will
> look for the expression '34,35,36' which is not a biblionumber.
> Therefore, you don't have any result.
>
> I guess you could use multiple "OR"...
>
> Hope it helps!
>
> François Charbonnier,
> Bibl. prof. / Chef de produits
>
> Tél.  : (888) 604-2627
> francois.charbonn...@inlibro.com 
>
> inLibro | pour esprit libre | www.inLibro.com  Le
> 2016-04-21 11:16, Graham, Stephen a écrit :
> > Hi All - I want to set up a SQL report that can take a variable number
> of the same value. My SQL looks like:
> >
> > select
> > biblionumber,
> > concat (branchname, ', ', lib) as location, itemcallnumber, if(onloan
> > is null,'Available',onloan) onloan from
> > items,authorised_values,branches where biblionumber in (<>)
> > and authorised_values.category = 'LOC'
> > and items.location = authorised_values.authorised_value
> > and items.homebranch = branches.branchcode
> >
> > I want the <> value to be able to receive several values when I
> run the report from the staff client, but I cannot get it to work. Any
> advice/tips much welcome!
> >
> > Stephen
> >
> > Stephen Graham
> > Online Information Manager
> > Information Collections and Services
> > Library and Computing Services
> > University of Hertfordshire
> > Hatfield  AL10 9AB
> > UK
> > Tel. 01707 286111 Ext: 77751
> > Email s.grah...@herts.ac.uk
> >
> > ___
> > Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
>
> ___
> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Using build_oai_sets.pl with embed items option

2016-04-22 Thread Pedro Amorim
Hello Mirko,

Yes, I have basic knowledge in git, however I have never contributed to an
open-source project before.
My question was more about on how to file a bug, but I think I got it
sorted:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16327

So I have to:
1) Clone the project branch 3.22;
2) Alter the code;
3) Submit the patch using git format-patch
4) Attach the diff in the bug tracker

Is that it?

Thank you,

Pedro Amorim


2016-04-21 19:48 GMT+00:00 Mirko Tietgen :

> Hi Pedro,
>
> there are different ways of setting up a dev environment. The
> easiest setup these days is said to be Kohadevbox.[1]
>
> A more manual setup info can be found in the wiki.[2]
>
> Have you used git before? If you are new to git don't be afraid,
> it's less complicated than it looks. You could drop by on IRC to get
> some help with the setup. There is someone around most of the time.
>
> HTH,
>
> Mirko
>
> [1] https://github.com/digibib/kohadevbox
> [2] https://wiki.koha-community.org/wiki/Version_Control_Using_Git
> [3] https://koha-community.org/get-involved/irc/
>
>
>
>
> Pedro Amorim schrieb am 21.04.2016
> > Hello Mirko,
> >
> > I have never done that before, would you please provide some information
> on how
> > to do it?
> >
> > Thanks,
> >
> > Pedro Amorim
> >
> > 2016-04-21 18:30 GMT+00:00 Mirko Tietgen  > >:
> >
> > Hi Pedro,
> >
> > it would be fantastic if you could file a bug report[1] and add a
> > patch with your changes, so we can test it and you are credited for
> it.
> >
> > Cheers,
> >
> > Mirko
> >
> > [1] https://bugs.koha-community.org/bugzilla3/
> >
> >
> >
> > Pedro Amorim schrieb am 21.04.2016
> > > By the way, using Koha 3.22 from debian packages.
> > >
> > > The problem was in CalcOAISetsBiblio function.
> > > I managed to solve the problem by changing the foreach in file
> > > /usr/share/koha/lib/C4/OAI/Sets.pm:494 to:
> > >
> > > foreach my $set_id (keys %$oai_sets_mappings) {
> > > foreach my $mapping (@{ $oai_sets_mappings->{$set_id} }) {
> > > next if not $mapping;
> > > my $field = $mapping->{'marcfield'};
> > > my $subfield = $mapping->{'marcsubfield'};
> > > my $operator = $mapping->{'operator'};
> > > my $value = $mapping->{'marcvalue'};
> > > #my @subfield_values = $record->subfield($field,
> $subfield);
> > > my @field_values = $record->field($field);
> > > foreach my $field_value (@field_values){
> > > my @subfield_values =
> $field_value->subfield($subfield);
> > >if ($operator eq 'notequal') {
> > > if(0 == grep /^$value$/, @subfield_values) {
> > > push @biblio_sets, $set_id;
> > > last;
> > > }
> > > }
> > > else {
> > > if(0 < grep /^$value$/, @subfield_values) {
> > > push @biblio_sets, $set_id;
> > > last;
> > > }
> > > }
> > > }
> > > }
> > > }
> > >
> >  > The original code was only extracting the *first* item for each
> biblio,
> > > hence why I was only getting 27 records indexed instead of an
> expected
> > > 1141. Those 27 records only had 1 item for each record, in the
> wanted
> > > library. All others have items from several libraries, including
> the one I
> > > wanted.
> > >
> > > Hopefully someone will confirm this was a bug and it's solved by
> the code
> > > above.
> > >
> > > Thanks,
> > >
> > > Pedro Amorim
> > >
> > >
> > >
> > >
> > >
> > > 2016-04-21 15:09 GMT+00:00 Pedro Amorim  >:
> > >
> > >> Hello all,
> > >>
> > >> I've configured an OAI set mapping with the field 995$a equals
> "libcode",
> > >> where 995$a holds the aquisition library code for the item.
> > >>
> > >> As this is an item field, not a biblio field, I have to run
> > >>build_oai_sets.pl  with '-i' option in
> order to
> > embed items to the records.
> > >>
> > >> This is working fine, however, it's only indexing records which
> only have
> > >> 1 item of 'libcode'.
> > >> Every other biblio with, say, 5 items from different libraries
> and 1 from
> > >> 'libcode' library are not indexing.
> > >>
> > >> I think the C4::Biblio::EmbedItemsInMarcBiblio function might be
> only
> > >> considering the first item in a biblio, instead of checking all
> of them.
> > >>
> > >> Has anyone else come across this situation?
> > >>
> > >> Thanks,
> > >>
> > >> Pedro Amorim
> > >>
>
>
>
> ___
> Koha mailing list  http://k

Re: [Koha] Using build_oai_sets.pl with embed items option

2016-04-22 Thread Mirko Tietgen
Hi Pedro,

Pedro Amorim schrieb am 22.04.2016

> Yes, I have basic knowledge in git, however I have never contributed to an 
> open-source project before.
> My question was more about on how to file a bug, but I think I got it sorted:
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16327

Great!

> 
> So I have to:
> 1) Clone the project branch 3.22;

Patches are done against the master branch, unless it's really
version specific. I changed it in the bug too.


> 2) Alter the code;
> 3) Submit the patch using git format-patch

You can use git-bz to directly interact with the bugtracker. have a
look at https://wiki.koha-community.org/wiki/Git_bz_configuration

HTH,

Mirko



signature.asc
Description: OpenPGP digital signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] SIPServer abaility

2016-04-22 Thread Joseph Hogan

Hello,

I read a recent message talking about the ability of Koha being able to 
use a SIPServer.


I tried looking in the wiki for more information, but while it seems to 
explain how to set it up, I can not find a uapication for it?


I use SIP server sfor VOIP telephony purposes.  But, what is the use 
here in Koha?


Thanks

Joeph
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] SIPServer abaility

2016-04-22 Thread Tajoli Zeno

Hi,

Il 22/04/2016 17:46, Joseph Hogan ha scritto:

I use SIP server sfor VOIP telephony purposes.  But, what is the use
here in Koha?


i library field SIP is not related with VOIP.
See: https://en.wikipedia.org/wiki/Standard_Interchange_Protocol

It is a protocol to speak with specific hardware (autoloan station, RFID 
devices, etc.).


Bye
Zeno Tajoli

--
Zeno Tajoli
/ SVILUPPO PRODOTTI/ - Automazione Biblioteche
Email: z.taj...@cineca.it Fax: 051/6132198
*CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Report question

2016-04-22 Thread Barton Chittenden
Joel,

I think this has more to do with the code perl code rather than MySQL ...
there are other transformations that we do on the parameters that get
passed to the SQL It would be nice if it handled paramters handed to 'IN
()' as well.

Having said that, I too would like to see Koha un-married from MySQL --
ideally, it would all be database independent. I think that we're gradually
working that direction by virtue of DBIC, but do a 'git grep -i select' to
see how far we still have to go.

--Barton

On Fri, Apr 22, 2016 at 10:09 AM, Coehoorn, Joel  wrote:

> This is one of those things that would be EASY in Sql Server, Oracle, or
> Postgresql, which all have a split() function that can produce a set
> suitable for use with an IN() clause.
>
> Sadly, MySql has failed to keep pace with other DB platform, going even
> back before it's acquisition by Oracle. It lacks split and a few other
> functions, uses non-compliant NULL handling by default, does not have CTEs,
> Windowing Functions, a lateral join/APPLY operation, or a FULL JOIN
> operation. I'd really love the option of running Postgresql instead. These
> days, it outclasses MySql in pretty much every category, and has done so
> for nearly a decade now.
>
>
>
> Joel Coehoorn
> Director of Information Technology
> 402.363.5603
> *jcoeho...@york.edu *
>
> The mission of York College is to transform lives through
> Christ-centered education and to equip students for lifelong service to
> God, family, and society
>
> On Fri, Apr 22, 2016 at 1:48 AM, Graham, Stephen 
> wrote:
>
> > Thanks François, I suspected as much.  I've tried doing things like:
> >
> > 35','36','37
> >
> > , but the report tool just escapes the ' with a backslash. Very
> > frustrating!
> >
> > I guess I could use an OR, but I don't know how many values would be
> > passed each time.  I guess I'll need to write a custom cgi script which
> > outputs some JSON for what I want.
> >
> > Cheers, Stephen
> >
> > -Original Message-
> > From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of
> Francois
> > Charbonnier
> > Sent: 21 April 2016 17:14
> > To: koha@lists.katipo.co.nz
> > Subject: Re: [Koha] Report question
> >
> > Hi Stephen,
> >
> > I don't see any workaround but right now, it can't work.
> >
> > Let's say the <> value is : 34,35,36
> >
> > With the IN operator, you have to get the query this way : IN(34,35,36)
> > but with the <>, you'll get IN('34,35,36') instead. The query
> will
> > look for the expression '34,35,36' which is not a biblionumber.
> > Therefore, you don't have any result.
> >
> > I guess you could use multiple "OR"...
> >
> > Hope it helps!
> >
> > François Charbonnier,
> > Bibl. prof. / Chef de produits
> >
> > Tél.  : (888) 604-2627
> > francois.charbonn...@inlibro.com  francois.charbonn...@inlibro.com>
> >
> > inLibro | pour esprit libre | www.inLibro.com 
> Le
> > 2016-04-21 11:16, Graham, Stephen a écrit :
> > > Hi All - I want to set up a SQL report that can take a variable number
> > of the same value. My SQL looks like:
> > >
> > > select
> > > biblionumber,
> > > concat (branchname, ', ', lib) as location, itemcallnumber, if(onloan
> > > is null,'Available',onloan) onloan from
> > > items,authorised_values,branches where biblionumber in (<>)
> > > and authorised_values.category = 'LOC'
> > > and items.location = authorised_values.authorised_value
> > > and items.homebranch = branches.branchcode
> > >
> > > I want the <> value to be able to receive several values when I
> > run the report from the staff client, but I cannot get it to work. Any
> > advice/tips much welcome!
> > >
> > > Stephen
> > >
> > > Stephen Graham
> > > Online Information Manager
> > > Information Collections and Services
> > > Library and Computing Services
> > > University of Hertfordshire
> > > Hatfield  AL10 9AB
> > > UK
> > > Tel. 01707 286111 Ext: 77751
> > > Email s.grah...@herts.ac.uk
> > >
> > > ___
> > > Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> > > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> > ___
> > Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> > ___
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Report question

2016-04-22 Thread Paul A

At 09:09 AM 4/22/2016 -0500, Coehoorn, Joel wrote:

This is one of those things that would be EASY in Sql Server, Oracle, or
Postgresql, which all have a split() function that can produce a set
suitable for use with an IN() clause.


Given that the query below works perfectly on CLI (using real values 1, 2, 
3 rather than the << input, input2, input3 >> construct), maybe we should 
look at the code that prepares the MySQL query, rather than just saying 
that MySQL doesn't remove the single quotes.


I haven't had time to chase down whether it's Koha or a standard library 
that adds the quote marks, but wherever it is, it should be fairly trivial 
to remove them.


Best -- Paul



Sadly, MySql has failed to keep pace with other DB platform, going even
back before it's acquisition by Oracle. It lacks split and a few other
functions, uses non-compliant NULL handling by default, does not have CTEs,
Windowing Functions, a lateral join/APPLY operation, or a FULL JOIN
operation. I'd really love the option of running Postgresql instead. These
days, it outclasses MySql in pretty much every category, and has done so
for nearly a decade now.



Joel Coehoorn
Director of Information Technology
402.363.5603
*jcoeho...@york.edu *

The mission of York College is to transform lives through
Christ-centered education and to equip students for lifelong service to
God, family, and society

On Fri, Apr 22, 2016 at 1:48 AM, Graham, Stephen 
wrote:

> Thanks François, I suspected as much.  I've tried doing things like:
>
> 35','36','37
>
> , but the report tool just escapes the ' with a backslash. Very
> frustrating!
>
> I guess I could use an OR, but I don't know how many values would be
> passed each time.  I guess I'll need to write a custom cgi script which
> outputs some JSON for what I want.
>
> Cheers, Stephen
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Francois
> Charbonnier
> Sent: 21 April 2016 17:14
> To: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Report question
>
> Hi Stephen,
>
> I don't see any workaround but right now, it can't work.
>
> Let's say the <> value is : 34,35,36
>
> With the IN operator, you have to get the query this way : IN(34,35,36)
> but with the <>, you'll get IN('34,35,36') instead. The query will
> look for the expression '34,35,36' which is not a biblionumber.
> Therefore, you don't have any result.
>
> I guess you could use multiple "OR"...
>
> Hope it helps!
>
> François Charbonnier,
> Bibl. prof. / Chef de produits
>
> Tél.  : (888) 604-2627
> francois.charbonn...@inlibro.com 
>
> inLibro | pour esprit libre | www.inLibro.com  Le
> 2016-04-21 11:16, Graham, Stephen a écrit :
> > Hi All - I want to set up a SQL report that can take a variable number
> of the same value. My SQL looks like:
> >
> > select
> > biblionumber,
> > concat (branchname, ', ', lib) as location, itemcallnumber, if(onloan
> > is null,'Available',onloan) onloan from
> > items,authorised_values,branches where biblionumber in (<>)
> > and authorised_values.category = 'LOC'
> > and items.location = authorised_values.authorised_value
> > and items.homebranch = branches.branchcode
> >
> > I want the <> value to be able to receive several values when I
> run the report from the staff client, but I cannot get it to work. Any
> advice/tips much welcome!
> >
> > Stephen
> >
> > Stephen Graham
> > Online Information Manager
> > Information Collections and Services
> > Library and Computing Services
> > University of Hertfordshire
> > Hatfield  AL10 9AB
> > UK
> > Tel. 01707 286111 Ext: 77751
> > Email s.grah...@herts.ac.uk
> >
> > ___
> > Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
>
> ___
> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Report question

2016-04-22 Thread Joel Coehoorn
Accepting parameters for an IN() expression is a common and well known 
situation among database developers, and the typical solution involves a 
split() function of similar that's supported by just about every db but MySQL. 
Look me up on Stack Overflow, you'll see I know what I'm talking about in this 
area.

Sent from my iPad

> On Apr 22, 2016, at 9:55 AM, Paul A  wrote:
> 
> At 09:09 AM 4/22/2016 -0500, Coehoorn, Joel wrote:
>> This is one of those things that would be EASY in Sql Server, Oracle, or
>> Postgresql, which all have a split() function that can produce a set
>> suitable for use with an IN() clause.
> 
> Given that the query below works perfectly on CLI (using real values 1, 2, 3 
> rather than the << input, input2, input3 >> construct), maybe we should look 
> at the code that prepares the MySQL query, rather than just saying that MySQL 
> doesn't remove the single quotes.
> 
> I haven't had time to chase down whether it's Koha or a standard library that 
> adds the quote marks, but wherever it is, it should be fairly trivial to 
> remove them.
> 
> Best -- Paul
> 
> 
>> Sadly, MySql has failed to keep pace with other DB platform, going even
>> back before it's acquisition by Oracle. It lacks split and a few other
>> functions, uses non-compliant NULL handling by default, does not have CTEs,
>> Windowing Functions, a lateral join/APPLY operation, or a FULL JOIN
>> operation. I'd really love the option of running Postgresql instead. These
>> days, it outclasses MySql in pretty much every category, and has done so
>> for nearly a decade now.
>> 
>> 
>> 
>> Joel Coehoorn
>> Director of Information Technology
>> 402.363.5603
>> *jcoeho...@york.edu *
>> 
>> The mission of York College is to transform lives through
>> Christ-centered education and to equip students for lifelong service to
>> God, family, and society
>> 
>> On Fri, Apr 22, 2016 at 1:48 AM, Graham, Stephen 
>> wrote:
>> 
>> > Thanks François, I suspected as much.  I've tried doing things like:
>> >
>> > 35','36','37
>> >
>> > , but the report tool just escapes the ' with a backslash. Very
>> > frustrating!
>> >
>> > I guess I could use an OR, but I don't know how many values would be
>> > passed each time.  I guess I'll need to write a custom cgi script which
>> > outputs some JSON for what I want.
>> >
>> > Cheers, Stephen
>> >
>> > -Original Message-
>> > From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Francois
>> > Charbonnier
>> > Sent: 21 April 2016 17:14
>> > To: koha@lists.katipo.co.nz
>> > Subject: Re: [Koha] Report question
>> >
>> > Hi Stephen,
>> >
>> > I don't see any workaround but right now, it can't work.
>> >
>> > Let's say the <> value is : 34,35,36
>> >
>> > With the IN operator, you have to get the query this way : IN(34,35,36)
>> > but with the <>, you'll get IN('34,35,36') instead. The query will
>> > look for the expression '34,35,36' which is not a biblionumber.
>> > Therefore, you don't have any result.
>> >
>> > I guess you could use multiple "OR"...
>> >
>> > Hope it helps!
>> >
>> > François Charbonnier,
>> > Bibl. prof. / Chef de produits
>> >
>> > Tél.  : (888) 604-2627
>> > francois.charbonn...@inlibro.com 
>> >
>> > inLibro | pour esprit libre | www.inLibro.com  Le
>> > 2016-04-21 11:16, Graham, Stephen a écrit :
>> > > Hi All - I want to set up a SQL report that can take a variable number
>> > of the same value. My SQL looks like:
>> > >
>> > > select
>> > > biblionumber,
>> > > concat (branchname, ', ', lib) as location, itemcallnumber, if(onloan
>> > > is null,'Available',onloan) onloan from
>> > > items,authorised_values,branches where biblionumber in (<>)
>> > > and authorised_values.category = 'LOC'
>> > > and items.location = authorised_values.authorised_value
>> > > and items.homebranch = branches.branchcode
>> > >
>> > > I want the <> value to be able to receive several values when I
>> > run the report from the staff client, but I cannot get it to work. Any
>> > advice/tips much welcome!
>> > >
>> > > Stephen
>> > >
>> > > Stephen Graham
>> > > Online Information Manager
>> > > Information Collections and Services
>> > > Library and Computing Services
>> > > University of Hertfordshire
>> > > Hatfield  AL10 9AB
>> > > UK
>> > > Tel. 01707 286111 Ext: 77751
>> > > Email s.grah...@herts.ac.uk
>> > >
>> > > ___
>> > > Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
>> > > https://lists.katipo.co.nz/mailman/listinfo/koha
>> >
>> > ___
>> > Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>> > ___
>> > Koha mailing list  http://koha-community.org
>> > Koha@lists.katipo.co.nz
>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>> >
>> _