[Koha] Hazard notice: koha-community.org currently down, due to linode failure

[Liz Rea]

Linode says:


 An issue affecting the physical host this Linode resides on has
 been detected.

They are working on it and I'm sure hope to have it back soon.

Spare a thought for their engineers, they need your gentle caring and 
supportive thoughts.


Cheers,
Liz

--
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House,
150 Willis Street, Wellington.
P.O Box 11053, Manners Street,
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

Re: [Koha] Hazard notice: koha-community.org currently down, due to linode failure

[Liz Rea]

And just like that, it's back. :) Possibility for dodginess in the next 
while I'd reckon.



On 02/05/18 10:24, Liz Rea wrote:

Linode says:


 An issue affecting the physical host this Linode resides on has
 been detected.

They are working on it and I'm sure hope to have it back soon.

Spare a thought for their engineers, they need your gentle caring and 
supportive thoughts.


Cheers,
Liz



--
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House,
150 Willis Street, Wellington.
P.O Box 11053, Manners Street,
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

[Koha] Help with funding the koha-community.org webserver

[Liz Rea]

Hi all,
I've been funding the koha-community web server for about 5 years now, and
I've been happy to have the disposable income available to me to do that
personally. As it turns out, this year I don't really have that and I could
really use some help paying for it.

The server is paid for yearly, this year it was $308 NZD It's all paid up
until June of next year.

If you'd be interested in tossing a few dollars my way to support running
the website, I'd be really grateful. I think it would be better to have a
community funded server anyway. I'm happy to keep looking after the server
and website too.

I don't have a plan currently for how best to receive the funds - ideas
welcome on this front as well.

Thanks for your consideration,

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

Re: [Koha] Help with funding the koha-community.org webserver

[Liz Rea]

Oh everyone, you are really the best folks anywhere.

I have set up a ko-fi at https://ko-fi.com/lizrea and you can contribute
there

Why don't you all chip in a little and we can get this done lickety split
and tjay way nobody gets stuck with it all <3 <3

Thank you all so much!

Liz (wizzyrea)

On 6 Jun 2018 17:33, "Chris Brown"  wrote:

Liz,

I would be happy to chip in if you come up with an easy way to pay. Perhaps
you could set up a PayPal account?

Best Regards,

Chris Brown


On Tue, Jun 5, 2018 at 10:21 PM, Liz Rea  wrote:

> Hi all,
> I've been funding the koha-community web server for about 5 years now, and
> I've been happy to have the disposable income available to me to do that
> personally. As it turns out, this year I don't really have that and I could
> really use some help paying for it.
>
> The server is paid for yearly, this year it was $308 NZD It's all paid up
> until June of next year.
>
> If you'd be interested in tossing a few dollars my way to support running
> the website, I'd be really grateful. I think it would be better to have a
> community funded server anyway. I'm happy to keep looking after the server
> and website too.
>
> I don't have a plan currently for how best to receive the funds - ideas
> welcome on this front as well.
>
> Thanks for your consideration,
>
> Cheers,
> Liz
> ___
> 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] Help with funding the koha-community.org webserver

[Liz Rea]

Victory, everyone!

Goal achieved and the website is golden for another year!

Thank you all so much <3

The Koha community is truly awesome.

Now... To go freshen up that website :D

Cheers,
Liz

On Wed, 6 Jun 2018, 20:39 Narcis Garcia,  wrote:

> It's time to propose a better alternative for sending money:
> https://en.wikipedia.org/wiki/List_of_online_payment_service_providers
>
>
> El 06/06/18 a les 07:54, Michael Kuhn ha escrit:
> > Hi Liz
> >
> >> I have set up a ko-fi at https://ko-fi.com/lizrea and you can
> >> contribute there
> >
> > Sorry, but I don't like Paypal and I don't want to set up an account
> there.
> >
> > But as said I will contribute immediately if you send me the necessary
> > details (bank account etc).
> >
> > Best wishes: Michael
> ___
> 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] Help with funding the koha-community.org webserver (also short outage for Linode free upgrade!)

[Liz Rea]

Further to that, I do mostly keep the work on the website separate from
the work I do for Catalyst. That excepts the occasional urgent apt or
wordpress upgrade that has to happen during working hours, or urgent
help requests from members of the community in relation to working with
the website.

I'll try to figure out a way to make a nice "cost sheet" for the ko-fi,
I've added the most recent invoice from Linode so far. Sorry, I know
PayPal sucks but I like the model for ko-fi better than patreon or
direct transfers - much better for one-offs or little funding drives and
easy to keep transparent. Don't get me wrong, if you want to send a
direct transfer I'll try to facilitate your contribution as best I can. :)

That said, the server is paid for this year, and for next year (and a
little on top)! Well done team (thanks again so very much)! I'll hang on
to the money you've sent and spend it next year when I get the next invoice.

Also a hazard notice: Linode is upgrading your server ('cause hey, you
paid for it!) by migrating it to a new virtualhost with MOAR DISK and
MOAR RAM, they expect a ~20 minute downtime while they do this. That
will happen sometime today, don't panic (rather, let me do the panicking
for you).

Kia ora rawa atu,
Liz Rea

On 07/06/18 08:26, Chris Cormack wrote:
> Kia ora tātou
>
> Yay, so great to see how fast this was funded!
>
> Just a bit of background.
> After what happened in 2009 when we had a company in control of lots
> of our infrastructure, we decided to never let that happen again.
> Hence Liz running the www.koha-community.org site (rather than say
> Catalyst doing it).
>
> We shared out most of the sites, like git and bugs etc so that they are
> distributed and hard to capture :)
>
> A list is here
> https://wiki.koha-community.org/wiki/Website_Administration
>
> (So just to allay peoples concerns, it was a conscious community
> decision to share the infrastructure around )
>
> Chris
>
> On 06/06/18 21:08, Liz Rea wrote:
>> Victory, everyone!
>>
>> Goal achieved and the website is golden for another year!
>>
>> Thank you all so much <3
>>
>> The Koha community is truly awesome.
>>
>> Now... To go freshen up that website :D
>>
>> Cheers,
>> Liz
>>
>> On Wed, 6 Jun 2018, 20:39 Narcis Garcia,  wrote:
>>
>>> It's time to propose a better alternative for sending money:
>>> https://en.wikipedia.org/wiki/List_of_online_payment_service_providers
>>>
>>>
>>> El 06/06/18 a les 07:54, Michael Kuhn ha escrit:
>>>> Hi Liz
>>>>
>>>>> I have set up a ko-fi at https://ko-fi.com/lizrea and you can
>>>>> contribute there
>>>> Sorry, but I don't like Paypal and I don't want to set up an account
>>> there.
>>>> But as said I will contribute immediately if you send me the necessary
>>>> details (bank account etc).
>>>>
>>>> Best wishes: Michael
>>> ___
>>> 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

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7


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

Re: [Koha] Plugin Error

[Liz Rea]

A few things here:

* do you have the plugin directory defined in koha-conf.xml, a la
/var/lib/koha/instance/plugins

* are the directories listed above owned and grouped into instance-koha
(instance will be the name of your instance)

* are the permissions correct for that directory *and* it's
subdirectories (for plugins, usually 755 is good)

Package installs, except in exceptional and highly non-standard
circumstances, don't use the www-data user. Use the system user
koha-create created for you, as that's what your instance is running
with (you can see the user it's using in
/etc/apache2/sites-available/instance.conf under AssignUserID)

I hope this helps.

Cheers,

Liz


On 13/06/18 08:13, Chris Brown wrote:
> Hi Satish,
>
> What you probably need to do is to change the ownership of the directories
> to be whatever user identity the apache server is running with. You can
> find this with a command like:
>
> # ps -ef  | grep apache
>
> On my Debian system the user is 'www-data'
>
> Then change the ownership of the directories accordingly.
>
> Hope this helps,
>
> Chris Brown
>
>
> On Tue, Jun 12, 2018 at 7:43 PM SATISH  wrote:
>
>> Hi,
>>
>> With Koha 17.11.06.000 On L-Ubuntu 16,04 Desktop from package installation
>> method,
>>
>> I am getting follwoing error while uploading .kpz file at  Home › Tools ›
>> Plugins.
>>
>>
>> *Cannot unpack file to the plugins directory.Please verify that the Apache
>> user can write to the plugins directory.*
>>
>> What is the right permission ??
>> .
>> As a root user, I have created plugins directory
>>
>> drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48
>> gechlibrary
>> drwxr-xr-x 2 root root 4096 Jun 12 17:28 plugins
>>
>> I tried to change,
>> chown -R gechlibrary-koha:gechlibrary-koha /var/lib/koha/plugins/
>>
>> drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48
>> gechlibrary
>> drwxr-xr-x 2 gechlibrary-koha gechlibrary-koha 4096 Jun 12 17:28 plugins
>>
>>
>> Alias /plugin/ "/var/lib/koha/plugins/" is updated in
>> /etc/apache2/sites-available/gechlibrary.conf
>>
>> In both cases, I am not able to to perform upload plugin.
>>
>> Please help.
>>
>> Satish MV
>> Librarian
>> Govt. Engineering College, Hassan
>> ___________
>> 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

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7


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

Re: [Koha] EDS Plugin not loading

[Liz Rea]

I have seen this, make sure you've got all of the apache configs for the
EDS plugin in your /etc/apache2/sites-available/instance.conf. The ones
that you're probably looking for are the ones that let you execcgi on
that plugins directory, something like:

   Alias /plugin/ "/var/lib/koha/instance/plugins/"

   
  Options ExecCGI
  AddHandler cgi-script .pl
  AllowOverride All
  Require all granted
   

If you don't have this, the plugin will simply download the .pl over and
over (and you probably won't notice that for at least 30 minutes or so
because of the auto-close of that update-data button).

Cheers,

Liz


On 08/06/18 07:09, Mohamed Negm wrote:
> Yes the opacbaseurl filled out, and plugin doesn't return with any error, 
> loading and not get any data
>
>
>  Original Message 
> Subject: Re: [Koha] EDS Plugin not loading
> From: Nick Clemens
> To: Mohamed Negm
> CC: koha@lists.katipo.co.nz
>
>
> Are the OPACBaseURL and staffclientbaseurl system preferences filled out?
>
> Does the plugin return any info in the settings box to indicate an error?
>
> On Fri, Jun 1, 2018 at 9:16 AM Mohamed Negm 
> mailto:m.n...@live.com>> wrote:
> Hi
>
> I’m trying to configure EBSCO EDS plugin into Koha 17.11, I filled out all 
> require information in the plugin but when press loading data from EBSCO 
> admin, nothing change, any suggestions
>
> Sent from 
> Mail<https://go.microsoft.com/fwlink/?LinkId=550986<https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkId%3D550986&data=02%7C01%7C%7C1df09adb165842252a7008d5cc9f4894%7C84df9e7fe9f640afb435%7C1%7C0%7C636639906839737704&sdata=mxmlU%2BIp0qI6B1wK94IkjqIKtb%2F5A69X%2BjaJX9fBeYA%3D&reserved=0>>
>  for Windows 10
>
> ___
> Koha mailing list  
> http://koha-community.org<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org&data=02%7C01%7C%7C1df09adb165842252a7008d5cc9f4894%7C84df9e7fe9f640afb435%7C1%7C0%7C636639906839737704&sdata=VDCVlO%2FTPIsRzcksXwbForm8P8zDi17BV4BZGOaYEq4%3D&reserved=0>
> Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
> https://lists.katipo.co.nz/mailman/listinfo/koha<https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=02%7C01%7C%7C1df09adb165842252a7008d5cc9f4894%7C84df9e7fe9f640afb435%7C1%7C0%7C636639906839737704&sdata=JgZY%2FQgIhfAiYlyllKcpOyJuO6nVb1wxEEL6%2FVwdjNc%3D&reserved=0>
> --
> Nick Clemens
> Sonic Screwdriver (Development Support)
> ByWater Solutions
> IRC: kidclamp
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

Re: [Koha] EDS Plugin not loading

[Liz Rea]

Don't forget to restart apache and stuff after you add this. ;)


On 13/06/18 15:11, Liz Rea wrote:
> I have seen this, make sure you've got all of the apache configs for the
> EDS plugin in your /etc/apache2/sites-available/instance.conf. The ones
> that you're probably looking for are the ones that let you execcgi on
> that plugins directory, something like:
>
>    Alias /plugin/ "/var/lib/koha/instance/plugins/"
>
>    
>   Options ExecCGI
>   AddHandler cgi-script .pl
>   AllowOverride All
>   Require all granted
>    
>
> If you don't have this, the plugin will simply download the .pl over and
> over (and you probably won't notice that for at least 30 minutes or so
> because of the auto-close of that update-data button).
>
> Cheers,
>
> Liz
>
>
> On 08/06/18 07:09, Mohamed Negm wrote:
>> Yes the opacbaseurl filled out, and plugin doesn't return with any error, 
>> loading and not get any data
>>
>>
>>  Original Message 
>> Subject: Re: [Koha] EDS Plugin not loading
>> From: Nick Clemens
>> To: Mohamed Negm
>> CC: koha@lists.katipo.co.nz
>>
>>
>> Are the OPACBaseURL and staffclientbaseurl system preferences filled out?
>>
>> Does the plugin return any info in the settings box to indicate an error?
>>
>> On Fri, Jun 1, 2018 at 9:16 AM Mohamed Negm 
>> mailto:m.n...@live.com>> wrote:
>> Hi
>>
>> I’m trying to configure EBSCO EDS plugin into Koha 17.11, I filled out all 
>> require information in the plugin but when press loading data from EBSCO 
>> admin, nothing change, any suggestions
>>
>> Sent from 
>> Mail<https://go.microsoft.com/fwlink/?LinkId=550986<https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkId%3D550986&data=02%7C01%7C%7C1df09adb165842252a7008d5cc9f4894%7C84df9e7fe9f640afb435%7C1%7C0%7C636639906839737704&sdata=mxmlU%2BIp0qI6B1wK94IkjqIKtb%2F5A69X%2BjaJX9fBeYA%3D&reserved=0>>
>>  for Windows 10
>>
>> ___
>> Koha mailing list  
>> http://koha-community.org<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org&data=02%7C01%7C%7C1df09adb165842252a7008d5cc9f4894%7C84df9e7fe9f640afb435%7C1%7C0%7C636639906839737704&sdata=VDCVlO%2FTPIsRzcksXwbForm8P8zDi17BV4BZGOaYEq4%3D&reserved=0>
>> Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
>> https://lists.katipo.co.nz/mailman/listinfo/koha<https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=02%7C01%7C%7C1df09adb165842252a7008d5cc9f4894%7C84df9e7fe9f640afb435%7C1%7C0%7C636639906839737704&sdata=JgZY%2FQgIhfAiYlyllKcpOyJuO6nVb1wxEEL6%2FVwdjNc%3D&reserved=0>
>> --
>> Nick Clemens
>> Sonic Screwdriver (Development Support)
>> ByWater Solutions
>> IRC: kidclamp
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

Re: [Koha] How to use create_superlibrarian.pl

[Liz Rea]

I had to do this today, so here's what I did. Instance is the name of
your instance.

sudo koha-shell instance -c
"/usr/share/koha/bin/devel/create_superlibrarian.pl --userid
my_desired_username --password somethinglongandcomplicated"

Hope this helps!



On 26/06/18 14:46, Pablo Bianchi wrote:
> Also you might found useful to run
> $ perldoc create_superlibrarian.pl
>
> This work with almost all CLI Koha scripts, but sometimes with
> deprecated/incomplete info.
>
> Regards,
> Pablo
>
>
> Le dim. 24 juin 2018 à 12:51, Bedanta Borah  a
> écrit :
>
>> Can anyone please guide me with detailed instructions about how to use
>> create_superlibrarian.pl file to create new petron with superlibrarian
>> permissions?
>> ___
>> 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

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

[Koha] Fwd: Doubt on Integration of Extra feature In Koha

[Liz Rea]

-- Forwarded message --
From: Biren Sharma 
Date: Sat, Jul 7, 2018 at 8:32 PM
Subject: Doubt on Integration of Extra feature In Koha
To: wizzyrea+kc...@gmail.com



Hello Ma'am/Sir,

Can I add  Gate Register feature (entry and exit for the daily library
visitor)  with RFID card in Koha platform?.

Basically, I am trying to add a feature in which it will hold data (name,
date and time) of daily library visitors. Entry and exit will be recorded
using RFID card.
Is there any built-in feature for RFID card based entry/exit log? Purpose
of this is to do away with manual entry and exit while visiting the
library.


Therefore, I would be very grateful if you could let me know about the
feasibility and approach if I am allowed to edit or modify the koha
platform in such a manner.


Looking forward to your quick response.

Thanking you.

Yours faithfully,

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

Re: [Koha] Koha Master Password

[Liz Rea]

Hi Ashok,

This probably means that the password you have in your mysql server, and
the password in your koha-conf.xml are different. Make sure they are the
same (both username and password) and it should come right.

Cheers,
Liz

On 06/08/18 17:59, Ashok Francis wrote:
> Dear All,
>
> I was using koha 17.05. When I changed koha's master password by following
> this blog link 
> http://kohageek.blogspot.com/2013/05/how-to-change-master-password-of-koha.html,
>
> <http://kohageek.blogspot.com/2013/05/how-to-change-master-password-of-koha.html>
> I am getting the following error.
>
> Then, I tried to update and upgrade to the new version of koha 18.05. Even
> then, I am getting the same error.
>
> Software error:
>
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
> ccess denied for user 'koha_library'@'localhost' (using password: YES)
> at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1398. at
> /usr/share/koha/lib/Koha/Database.pm line 100
>
> For help, please send mail to the webmaster ([no address given]), giving
> this error message and the time and date of the error.
> Please help me to solve this problem. I really appreciate your help.
>
> Thank you,
>
> Ashok.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

Re: [Koha] [Koha-devel] Koha community site Wordpress issue

[Liz Rea]

Have been in contact with Chad, but haven't heard anything yet. The latest
wordpress upgrade broke both the editor and the permissions plugin we were
using, both seem to be working ok for me after a bit of fixing.

Cheers,
Liz

On Sat, Mar 2, 2019 at 2:56 PM kohanews  wrote:

> The Wordpress site koha-community.org will not save my edits and I'm
> unable to publish.
>
> Anyone know who manages that?
>
> Thank you!
>
> --
> Chad Roseburg
> Editor, Koha Community Newsletter
>
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Fwd: Problem with Koha

[Liz Rea]

-- Forwarded message -
From:Facundo Gallego 
Date: Wed., 1 May 2019, 8:34 am
Subject: Problem with Koha
To: 


Good Morning!

I want to report the problem I'm having with Koha. Everytime I want to
enter on the page biblioteca.com.ar (my library page) an error runs:


Software error:

DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (111) at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1492. at
/usr/share/koha/lib/Koha/Database.pm line 100

For help, please send mail to the webmaster ([no address given]), giving
this error message and the time and date of the error.


I really need to get this solved, please. I'm begging for your help.

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

[Koha] 18.05.14 Released

[Liz Rea]

Kia ora koutou,

The Koha community is pleased to announce the maintenance release of Koha
version 18.05.14. This is a security release, all users of 18.05 are
suggested to update to this version as soon as possible.

Full release notes can be found at
https://koha-community.org/18-05-14-released/ as well as download links.

Thanks to Lucas Gass (previous 18.05 maintainer), Martiin Renvoize, and
Chris Cormack for helping get this release out the door.

Be well everyone,
Liz Rea
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] koha-community.org inaccessible

[Liz Rea]

It seems that linode UK is having a problem currently, and the
koha-community.org web server is unavailable. Likely all will be well when
that problem is resolved - you can keep an eye on it (as I will be doing)
at https://status.linode.com/

Cheers,
Liz Rea
___

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

Re: [Koha] koha-community.org inaccessible

[Liz Rea]

And just like that it is back!

Let me know if anything seems amiss. :)

Cheers,
Liz

On Mon, 1 Aug 2022, 17:27 Liz Rea,  wrote:

> It seems that linode UK is having a problem currently, and the
> koha-community.org web server is unavailable. Likely all will be well
> when that problem is resolved - you can keep an eye on it (as I will be
> doing) at https://status.linode.com/
>
> Cheers,
> Liz Rea
>
___

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

Re: [Koha] [Koha-devel] Critical error on Koha website

[Liz Rea]

Hi friends,

This was related to an update to Wordpress and the theme we use. Have
sorted out those issues and things are seeming better now, if you'd please
test!

Cheers,
Liz

On Thu, Sep 29, 2022 at 2:51 PM Michael Kuhn  wrote:

> Hi
>
> When I'm trying to preview or release the current Koha newsletter I'm
> getting the following message:
>
> There has been a critical error on this website.
>
> I'm also getting this message when I try to access older newsletters,
> for example
>
> * https://koha-community.org/koha-community-newsletter-april-2022/
> * https://koha-community.org/koha-community-newsletter-august-2022/
>
> Can someone with the necessary rights and knowledge please remove this
> problem?
>
> Best wishes: Michael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
>
___

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

[Koha] Koha 3.18.10 released

[Liz Rea]

The Koha release team are proud to announce the release of Koha
3.18.10. This is a maintenance release and contains 1 security fix.
All Koha 3.18.x users are recommended to upgrade.

As always you can download at download.koha-community.org, or wait for
a few hours for the packages to be available.

Please read the full release notes at

http://koha-community.org/koha-3-18-10-released/

Thanks to all of our contributors for this release!

Cheers,

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

[Koha] Many support providers added

[Liz Rea]

I have added many support providers to the paid support list from the last
couple of months. If you have been waiting to be listed, please check.

If you look and find your company is still missing, please email me
directly.

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

[Koha] Many support providers added

[Liz Rea]

I have added many support providers to the paid support list from the last
couple of months. If you have been waiting to be listed, please check.

If you look and find your company is still missing, please email me
directly.

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

Re: [Koha] E: Sub-process /usr/bin/dpkg returned an error code (1)

[Liz Rea]

Hi Irène,

There will be more to this error message above that in the output, I
don't think we can help diagnose this without a bit more information,
and more of the error message.

You may be able to see the errors in your /var/log/apt/term.log file
from the last upgrade attempt (or not, it just depends).

Cheers,
Liz
On 01/09/15 23:19, Irène MUSHIMIYIMANA wrote:
> Hey! I am trying to install koha on ubuntu 14.04 and I get the following 
> error:Errors were encountered while processing:koha-commonE: Sub-process 
> /usr/bin/dpkg returned an error code (1).I tried some steps I found from 
> internet but still it doesn't work, I unstalled koha and reinstall, I even 
> updated koha but nothing.Please I need your help. Irène M 
> Tel. (250)788623682
> Head of Programming
> INILAK
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Many support providers added (Liz Rea)

[Liz Rea]

Hi,

You need to follow the instructions on this page:
http://koha-community.org/support/paid-support/how-to-get-listed/

in particular, you are not fulfilling the requirement: "Companies must
show their support of the Koha Community by adding a visible link to the
Koha community website at http://www.koha-community.org to their Koha
offering web page."

While it does not preclude you from inclusion on the paid support
list, it has been consensus in the past to not use
koha.top_level_domain
for business, but redirect that to the official Koha website at
http://koha-community.org. This is just considered being a good
community citizen.

Cheers,
Liz

On Wed, Sep 2, 2015 at 3:39 AM, Quốc Uy  wrote:

> In vietnam, there is a company D&L working on koha with paid service. We
> have worked for 3 years at least. Please visit us at http://koha.vn,
> http://dlcorp.com.vn and
> Dreamlib.vn
> We did ask for joining paid list but no luck!
> Please add our company to this list. I will give u more information if u
> need!
> Best regards!
> Nguyen Quoc Uy
>
> ___
> 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] Koha error 2.2.8

[Liz Rea]

Hi,

This version is very old, and not supported for various reasons (it's
very old, you're running it on Windows, it's very very old).

The Windows install may seem "easy" but I promise you'll have better
results, better support, and better success if you run this on Debian or
Ubuntu. Plus, we'll be able to help you. :)

Cheers,
Liz
On 09/09/15 21:59, Gaurav Sharma wrote:
> hi,
> I try to newand try to install koha 2.2.8 on my system windows 7 32 bit
> with
> 1.Apache http server 2.2 at location @ C>Program files>Apache Software
> Foundation>Apache2.2
> 2.Active Pearl 5.20 at location c:/usr
> 3. MySql 4.1
> 4.koha 2.2.8
>
> i successfully installed the koha installation with error state that koha
> is tested on 5.8.8.x.x still i continue the installation process
> successfully without any error.
> when i try to access the url for koha it gives an error 500 internal server
> error.
> i checked the log files in apache log ataching them.
> please help!!!
> thanks
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7



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

Re: [Koha] Wrong shortcuts in Koha menu "Cataloging"

[Liz Rea]

This is, actually, how it is. And yes, I think it's confusing. Please
file a bug at http://bugs.koha-community.org.

Probably we need to add a shortcut to this screen because it's got extra
tabs.

Cheers,
Liz

On 31/07/15 05:52, Michael Kuhn wrote:
> Hi
>
> There are three shortcuts or hotkeys in the Koha staff client:
>
> * Alt + U = Check out
> * Alt + R = Check in
> * Alt + Q = Search the catalog
>
> As I understand these shortcuts should work all over the staff client,
> and mostly they do. In Koha 3.20 though when going to Koha menu
> "Cataloging" they don't work as expected. Here the mapping is:
>
> * Alt + U = Search the catalog
> * Alt + R = Cataloging search
> * Alt + Q = Check out
>
> Is this a bug or do I miss something?
>
> Kind regards, Michael
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Mini Material Type Icon

[Liz Rea]

Also, you can turn this off in the system preferences with the
|DisplayOPACiconsXSLT |
and
|DisplayIconsXSLT

|System preferences

Liz
||
On 18/09/15 01:30, Michael Kuhn wrote:
> Hi Caitlin
>
> > Does anyone know how to change the mini material type icon?  I'm using
>> 3.20.03.000.
>
> It depends on the letter you give in the MARC LEADER (aka field 000)
> on position 6. For example:
>
> 00677nam a22002417a 4500
>
> Here the "a" shows a little book icon.
>
> While
>
> 00677nem a22002417a 4500
>
> will show a little map icon.
>
> Hope this helps
>
> Michael
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7



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

Re: [Koha] batch item modification problem

[Liz Rea]

Hi,

Do all of the authorised values have descriptions attached to them? Or
do they possibly have diacritics in the description?

Cheers,
Liz

On 23/09/15 09:50, www retive wrote:
> hi, 
>
>
> i run koha 3.18.10 on debian wheezy.
>
> when i want to use the "batch item modification" tool, some authorized values
> don't display correctly.
> there is a screenshot at 
> https://laretive.info/wp-content/uploads/2015/09/screenshot-authorized-values-display-problem.png
>
> any ideas ?
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] batch item modification problem

[Liz Rea]

Hi,

Please file a bug for this issue at http://bugs.koha-community.org, with
the information you've provided here. Thanks!

Liz

On 23/09/15 10:30, www retive wrote:
> hi,
>
> yes, all authorised values have descriptions, including those that are not 
> displayed.
> And yes, the authorised values that are not displayed have diacritics in the 
> description.
>
> i found out that when there are diacritics the generated html is missing the 
> description :
>
> Histoire / Afrique / Colonialisme & 
> Anti-colonialisme
> --> no diacritics, generated html ok
>
>
> 
> --> with "e accute", the generated html is missing the description
>
> cheers
> philippe
>
>
>
> Le Mercredi 23 septembre 2015 0h07, Liz Rea  a écrit :
> Hi,
>
> Do all of the authorised values have descriptions attached to them? Or
> do they possibly have diacritics in the description?
>
> Cheers,
> Liz
>
>
> On 23/09/15 09:50, www retive wrote:
>> hi, 
>>
>>
>> i run koha 3.18.10 on debian wheezy.
>>
>> when i want to use the "batch item modification" tool, some authorized values
>> don't display correctly.
>> there is a screenshot at 
>> https://laretive.info/wp-content/uploads/2015/09/screenshot-authorized-values-display-problem.png
>>
>> any ideas ?
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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] Fwd: Re: slow check out/check in

[Liz Rea]

I failed at email addressing. This should have gone to the list.


Hi Scott,

Is that really Koha 3.01?

The solution to this is probably "upgrade Koha," as this version is no
longer supported.

Cheers,
Liz

On 23/09/15 06:21, Scott Owen wrote:
> Patrons seem to pull up fine, but, there seems to be a 30 second delay in
> any part of the circulation module.
>
> Mass checking in a stack of books is taking huge amounts of time due to the
> 30 second delay between scanning and the ability to do the next scan.
>
> Anything I can try for a quick fix on this ??
>
> Using Firefox as the web browser,
>
>
>
> Server informationKoha version:3.01.00.145OS version ('uname -a'):Linux
> koha3 2.6.26-2-686 #1 SMP Thu Aug 19 03:44:10 UTC 2010 i686 GNU/LinuxPerl
> interpreter:/usr/bin/perlPerl version:5.010001Perl @INC:/usr/share/koha/lib
> /etc/perl
> /usr/local/lib/perl/5.10.1
> /usr/local/share/perl/5.10.1
> /usr/lib/perl5
> /usr/share/perl5
> /usr/lib/perl/5.10
> /usr/share/perl/5.10
> /usr/local/lib/site_perl
> /usr/local/lib/perl/5.10.0
> /usr/local/share/perl/5.10.0
> .
> MySQL version:mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486)
> using readline 5.2Apache version:Server version: Apache/2.2.16 (Debian)Zebra
> version:Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free software,
> covered by the GNU General Public License, and you are welcome to change it
> and/or distribute copies of it under certain conditions. SHA1 ID:
> 419ad759807269fdfa379799a051ed3a551c6541 Using ICU
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7








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

Re: [Koha] software error

[Liz Rea]

15685] Script timed out before returning headers:
>>>>> opac-search.pl, referer:
>>>>> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>>>>> [Fri Sep 25 15:19:40.318628 2015] [cgi:warn] [pid 6432] [client
>>>>> 10.1.1.111:15700] AH01220: Timeout waiting for output from CGI script
>>>>> /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
>>>>> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>>>>> [Fri Sep 25 15:19:41.062151 2015] [cgi:error] [pid 6432] [client
>>>>> 10.1.1.111:15700] Script timed out before returning headers:
>>>>> opac-search.pl, referer:
>>>>> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>>>>> [Fri Sep 25 15:20:03.586683 2015] [cgi:error] [pid 6847] [client
>>>>> 10.1.1.111:36745] AH01215: ., referer:
>>>>> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>>>>>
>>>>>
>> ___
>>>>>
>>>>> Thanks for any pointers of where to go from here 
>>>>>
>>>>> -S
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Sep 22, 2015 at 10:48 PM, Robin Sheat 
>>>> wrote:
>>>>>> Scott Owen schreef op di 22-09-2015 om 22:25 [-0400]:
>>>>>>> Hummm.database is located on the same boxso I think a
>>>>>>> conductivity
>>>>>>> issue is unlikely. Guess I'll start digging through logs in my free
>>>>>>> timeany particular log that might be a good place to start? any
>>>>>>> key
>>>>>>> words I should be looking for ?
>>>>>> Nothing in particular, but I'd look for anything odd in syslog,
>> perhaps
>>>>>> turn the mysql logging level up a bit and see what it says, and so
>>>>>> forth. Note that I'm not 100% sure that this is the cause of your
>> issue,
>>>>>> but it looks like it from the surface.
>>>>>>
>>>>>> --
>>>>>> Robin Sheat
>>>>>> Catalyst IT Ltd.
>>>>>> ✆ +64 4 803 2204
>>>>>> GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF
>>>>>>
>>>>>> ___
>>>>>> 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
>>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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] Koha 3.18.11 Released

[Liz Rea]

The Koha release team is pleased to announce the release of Koha 3.18.11.
This is a maintenance release, but does contain one security fix. All users
are recommended to upgrade.

You can read the full release notes at
http://koha-community.org/koha-3-18-11-released/

As usual, you can download the tarball from
http://koha-community.org/downloads or wait for the debian packages, which
should be forthcoming in the next day or two.

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

Re: [Koha] Circulation Problem

[Liz Rea]

Hi Bob,

I was unable to replicate this on 3.18.11. We would need to know more
about your setup to help with this, I think.

One possible thing, would be that perhaps you need to clear your cache
and/or cookies.

Cheers,
Liz

On 05/10/15 02:31, Katrin Fischer wrote:
> Hi Bob,
>
> I just tried testing this on master - but couldn't reproduce. Maybe it's
> something specific to 3.18 (or I missed something) - could you file a
> bug report please?
>
> Katrin
>
>
> Am 02.10.2015 um 14:39 schrieb Bob Ewart:
>> We have volunteers on the circulation desk.  They are individual/family
>> members of type 'Adult' not 'Staff'.  We are currently running 3.18.11
>> built from the tar ball on openSUSE 13.2.
>>
>> Their permissions are set to:
>> circulate (all)
>> catalogue
>> reserveforothers (all)
>> borrow
>> updatecharges(all)
>>
>> When they go to check out items, they get logged out with a "timeout"
>> error.  But the item is checked out!
>>
>> staffaccess permission doesn't make any difference on or off.
>>
>> It work as it should when the borrowers permission is set, but we don't
>> want volunteers to be able to modify patrons.
>>
>> It was working in 3.18.05.
>>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Circulation Problem

[Liz Rea]

Hi Bob,

It's totally that "STRICT_TRANS_TABLES" that's doing this. I just tested
on my MariaDB (same v. as yours) with that and I get the errors too now.

Cheers,
Liz

On 07/10/15 02:06, Bob Ewart wrote:
> Thanks Liz and Katrin
>
> I'm beginning to think that it may be a problem with mariadb or
> something else that was updated recently.
>
> I'm currently running openSUSE 13.2 with mariadb 10.0.21  with Koha
> 3.18.10 built from a tar ball.
>
> I tried to setup 3.18.11 and selected "install all optional data" in
> the web installer for a test case.  This generated two errors (see bug
> 14952 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14952>
> )  This was working when I created a test database on 3.18.09 last
> month for my Donor Tracking plugin.  It's now failing even on 3.18.08.
>
> I know there was a problem with changes made to mysql's
> STRICT_TRANS_TABLES variable reported in bug 13523
> <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523> in
> January and am wondering if there are any other recent changes.
>
> I'm setting up a couple of fresh installs of openSUSE 13.2 and will
> try to reproduce the problem.
>
> I am also going to check my current database structure with the fresh
> installs.  Our database was created somewhere around Koha 3.0 and has
> been upgraded skipping a few releases.  It may be that some changes to
> the structure or system variables have not be made.
>

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Report help

[Liz Rea]

Hi,

Try this:

SELECT biblio.title, biblio.author, items.itemcallnumber, lcsh FROM
(SELECT biblionumber,
ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]') AS
lcsh FROM biblioitems) AS subjects JOIN biblio USING(biblionumber) JOIN
items USING(biblionumber) WHERE lcsh LIKE "%KEYWORD%";


On 06/10/15 23:45, Charlotte Stock wrote:
> This must be simple to fix but I'm not fluent enough in Koha-speak to crack 
> the problem. Would anyone be able to help amend this SQL report, so that the 
> results show the title, author and call number for each entry, instead of a 
> hyperlinked biblionumber?
>
> All suggestions gratefully received!
>
>
>
> Charlotte Stock
> Librarian
> charlo...@bu-london.co.uk<mailto:charlo...@bu-london.co.uk>
>
> Boston University Study Abroad London
> 43 Harrington Gardens
> London, SW7 4JU
> T 0207 244 6255   F 0207 373 9430
> http://www.bu.edu/london/
>
> Registered company in England no. FC020819
> ---
> This email message has been delivered safely and archived online by Mimecast.
> For more information please visit http://www.mimecast.com 
> ---
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] International Koha Fund Committee

[Liz Rea]

Hi,

I'm still waiting for the foundational materials for the website that
will help people to understand why they should contribute, and where the
money goes.

Currently it's like a GoFundMe with no description.

Liz

On 16/10/15 10:23, Brendan Gallagher wrote:
> Hello all -
>
> We had our first meeting today using Google Hangouts.  It was a very
> productive meeting and we are compiling minutes which will be emailed out
> and put on the wiki.  We will have a few action items to be voted on at the
> next general irc meeting which we will add to that agenda.  All committee
> members were present.  Very exciting!
>
> Also just a reminder, there is a "donate now" button on the main page of
> http://koha-community.org - every small little amount helps.
>
> Thanks,
> Brendan
>

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] koha LDAP

[Liz Rea]

Hi Richard,

You would add the configs in /etc/koha/sites/instancename/koha-conf.xml

More information can be found here:

http://perldoc.koha-community.org/C4/Auth_with_ldap.html

Cheers,
Liz

On 16/10/15 12:56, Richard Maileseni wrote:
> Hi, 
>
> Please can anyone show me where I could acces the extra configs for ldap
>
>  
>
> 1
>
>  
>
> Thanks,
>
> Richard
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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] String Freeze for 3.18

[Liz Rea]

Hi all,

It's that time, I'm going to call a string freeze for 3.18 to give the
translators some time to work.

Also, since we didn't have a string freeze last month, it's doubly
important to get one in this month. :)

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

[Koha] Slightly late hazard notice for koha-community.org

[Liz Rea]

koha-community.org will be down for up to two hours today to allow for
Linode to complete critical scheduled maintenance to their Xen
infrastructure.

Sorry for any inconvenience this may cause.

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

[Koha] Koha 3.18.12 released

[Liz Rea]

The Koha community are pleased to announce the release of Koha 3.18.12, a
maintenance and bugfix release of the popular open-source library
management system.


Packages for Debian will be available soon, or you can download the tarball
from http://download.koha-community.org.

Thanks to all contributors!

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

Re: [Koha] Errors upgrading from 3.18.11 to 3.18.12

[Liz Rea]

These ones are harmless, and won't occur in 3.18.13.

Cheers,
Liz

On 14/11/15 17:14, Bob Elgie wrote:
> I hoped/expected that someone else would post about these errors I received
> when upgrading from 3.18.11 to 3.18.12. Since no one has ...
>
> My system:
> 1 instance of koha-common running under Linux Mint Debian 2, mysql-server
> 5.5.46-0+deb8u1, apache2 5.5.46-0+deb8u1
> This is a personal-use installation of koha that, despite the errors below,
> appears to function properly.
>
> Screen-grab from apt-get:
>
> Preparing to unpack .../koha-common_3.18.12_all.deb ...
> Stopping Zebra server for mint
> SIP server for mint not running.
> Unpacking koha-common (3.18.12) over (3.18.11) ...
> Processing triggers for man-db (2.7.0.2-5) ...
> Setting up koha-common (3.18.12) ...
> Installing new version of config file /etc/koha/zebradb/ccl.properties ...
> Installing new version of config file
> /etc/koha/zebradb/marc_defs/unimarc/biblios/biblio-koha-indexdefs.xml ...
> Installing new version of config file
> /etc/koha/zebradb/marc_defs/unimarc/biblios/biblio-zebra-indexdefs.xsl ...
> Starting Zebra server for mint
> Upgrading database schema for mint
> DEV atomic update: hourlyloans.sql
> C4::Installer::load_sql returned the following errors while attempting to
> load
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/hourlyloans.sql:
> ERROR 1060 (42S21) at line 1: Duplicate column name 'lengthunit'
> DEV atomic update: oai_sets.sql
> C4::Installer::load_sql returned the following errors while attempting to
> load
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/oai_sets.sql:
> ERROR 1062 (23000) at line 35: Duplicate entry 'OAI-PMH:AutoUpdateSets' for
> key 'PRIMARY'
>
> Question:
> Do these errors need to be rectified? If so, I'm comfortable working at the
> command line in mysql.
>
> Thanks!
>
> Bob Elgie
> _______
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Problem with BarcodeFallbackSearch

[Liz Rea]

If this is a desirable feature, a good place to start would be to file a
bug at http://bugs.koha-community.org. :)

Quite sure that having this functionality for the returns was not part
of the spec for the original barcode fallback search development.

Cheers,
Liz

On 10/12/15 10:09, Nombre wrote:
> Hello all.
>
> I'm testing checkouts and returns. I have configured
> itemBarcodeFallbackSearch parameter as enabled.
>
> I've tested for chekouts and runs well: if I type the title instead of
> barcode I get a button with the title and barcode to select. But for
> returns it seems doesn't work: the only way to select the item is typing
> the barcode.
>
> Shouldn't be the correct behaviour to show a list of items when I type
> the title or author?
>
> Regards and thanks in adanced
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] [ByWater Partners] Your suggestions for a new name of Koha NA

[Liz Rea]

Perhaps you should consider resurrecting KUDOS

Koha users and developers, open source.

Liz

On 21/12/15 10:13, Chris Cormack wrote:
> * Alford, Paul (palf...@mylakelibrary.org) wrote:
>> "Kohana means family. Family means nobody gets left behind or forgotten"
>>
> From a southern hemiphere perspective. I think the NA what people
> are objecting to.
> Also picking the name of another open source project seems like a bit
> of a stink move.
>
> Chris
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7



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] Koha 3.18.13 Released

[Liz Rea]

The Koha team is pleased to announce the happy holiday release of Koha
3.18.13.

Please refrain from putting down your holiday beverage of choice to install
this version, it will be waiting for you when you get back from your time
away. :)

As always, the release notes are available at
https://koha-community.org/release-notes-for-koha-3-18-13/

Have a very jolly holiday period, stay safe, and we'll see you all back in
the new year, when I know you are all going to be refreshed and ready to
contribute patches, signoffs, opinions, and good humour to the Koha
community.

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

[Koha] Fwd: Some Questions About Koha

[Liz Rea]

Hi Fabricio,

I'm on holiday this week, but I've forwarded your message to the koha
community email list, hopefully someone there will have an answer for your
questions.

Cheers,
Liz
-- Forwarded message --
From: "Fabricio Soares" 
Date: Dec 30, 2015 6:59 PM
Subject: Some Questions About Koha
To: "wizzy...@gmail.com" 
Cc:

Hello Liz

I found your email by Github (Koha project). My name is Fabricio and I'm
from Brazil, I am working on the implementation of Koha in my institution
with about 20 libraries, and we are writing some scientific articles (one
of them has been published in a scientific journal here in Brazil ) in one
of the articles that we are writing, we are describing the evolution of
development by assessing the Bugzilla bug reports . Anyway, we have some
questions and we would like to clarify for the completion of our work. Do
you know who can clarify such matters? We look forward to completing our
work and thus disclose the Koha in scientific journals and also in Brazil
(which still does not know the tool) and South America.

I await answers ,

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

Re: [Koha] [Koha-devel] RFC: Circulation Rules Interface and Backend Revamp RFC

[Liz Rea]

I'd like to see a test mode where you can scan a borrower and an item,
and it will tell you which rule applied.

Cheers,
Liz

On 08/01/16 09:12, Jesse wrote:
> The backend and frontend of the circulation/policy rules in Koha have been
> extended and stretched to the point where they cause a fair amount of
> issues and frustration. Many librarians and developers are uncertain when
> default rules are applied, and the very large number of possible settings
> makes the interface and backend unwieldy.
>
> Full details for our intended solution can be found at the link at the
> bottom of this email, but here's the gist:
>
> Instead of having one database row with all settings for a given
> library/category/itemtype, allow each setting (checkout length, fine
> amount, holds allowed, etc.) to be specified separately.
> Rework the interface to more clearly show the specificity of
> default/specific rules, and allow for this new database model.
> Accomplish the above incrementally by gradually changing APIs.
>
> http://wiki.koha-community.org/wiki/Circulation_Rules_Interface_and_Backend_Revamp_RFC
>
> Any and all comments are appreciated. Development on this project has been
> fully sponsored, and we are looking to start work later this year.

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] [Koha-devel] RFC: Circulation Rules Interface and Backend Revamp RFC

[Liz Rea]

And a branch. You'd need that too.

Liz

On 08/01/16 09:50, Liz Rea wrote:
> I'd like to see a test mode where you can scan a borrower and an item,
> and it will tell you which rule applied.
>
> Cheers,
> Liz
>
> On 08/01/16 09:12, Jesse wrote:
>> The backend and frontend of the circulation/policy rules in Koha have been
>> extended and stretched to the point where they cause a fair amount of
>> issues and frustration. Many librarians and developers are uncertain when
>> default rules are applied, and the very large number of possible settings
>> makes the interface and backend unwieldy.
>>
>> Full details for our intended solution can be found at the link at the
>> bottom of this email, but here's the gist:
>>
>> Instead of having one database row with all settings for a given
>> library/category/itemtype, allow each setting (checkout length, fine
>> amount, holds allowed, etc.) to be specified separately.
>> Rework the interface to more clearly show the specificity of
>> default/specific rules, and allow for this new database model.
>> Accomplish the above incrementally by gradually changing APIs.
>>
>> http://wiki.koha-community.org/wiki/Circulation_Rules_Interface_and_Backend_Revamp_RFC
>>
>> Any and all comments are appreciated. Development on this project has been
>> fully sponsored, and we are looking to start work later this year.
>
>
> ___________
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7



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

Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07

[Liz Rea]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,

I've just done this exact same thing, and I used the patch from 15341
to patch the running system live. It should be fixed in 3.20.08.

Nasty little bug, that.

Liz

On 13/01/16 12:42, Bortel, Gary wrote:
> Hmmm...
> 
>>> The installation here is Ubuntu 14.04.3 with a multi-tenant 
>>> package install of Koha. Mysql  Ver 14.14 Distrib 5.5.46, for 
>>> debian-linux-gnu (x86_64) using readline 6.3
> 
> I updated to  Koha 3.20.07 this morning and the staff site is now 
> exhibiting behavior related to Bug 15431 
> (http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15431). 
> After navigating to a patron with materials checked out, 
> "Checkout(s)" at the bottom of the page shows "Loading..." 
> indefinitely. Clicking on the "Check out" tab brings a pop-up 
> message box " Loading…you may continue scanning.", but the checked 
> out items never appear.
> 
> I assume checkouts and returns continue to work. (There's no way
> to verify since the checkout information doesn't appear.) This
> does, however, make it difficult for them to renew materials for 
> patrons.
> 
> Any suggestions?
> 
> 
> gcb __
> 
> Gary C. Bortel Office of the Secretary of State, Washington State 
> Library gary.bor...@sos.wa.gov 360.570.5588
> 
> Washington State Library: Empowering 21st Century Washington
> 
> -Original Message- From: Koha 
> [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Jonathan 
> Druart Sent: Monday, January 11, 2016 9:14 AM To: 
> koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 
> --> 3.20.07
> 
> http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/da
ta/mysql/updatedatabase.pl;h=950ed2067dac0edd51cf5e49ff25862c6f53ecdb;hb
=refs/heads/3.20.x#l10576
>
>
> 
It exploded because you already had the constraint
> (course_reserves_ibfk_2), so everything is fine.
> 
> 2016-01-11 17:01 GMT+00:00 Bortel, Gary :
>> Hmmm...
>> 
>> Using "SHOW CREATE TABLE course_reserves" returns...
>> 
>> . . . PRIMARY KEY (`cr_id`), UNIQUE KEY `pseudo_key` 
>> (`course_id`,`ci_id`), KEY `course_id` (`course_id`), KEY 
>> `course_reserves_ibfk_2` (`ci_id`), CONSTRAINT 
>> `course_reserves_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES 
>> `courses` (`course_id`), CONSTRAINT `course_reserves_ibfk_2` 
>> FOREIGN KEY (`ci_id`) REFERENCES `course_items` (`ci_id`) ON 
>> DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT 
>> CHARSET=utf8 |
>> 
>> The course reserves function is not enabled on this instance and 
>> both course_reserves and course_items are empty. Could it be 
>> updatedatabase.pl is expecting that function to be enabled and 
>> those tables to contain at least one item? I hate to admit it, 
>> but I don't see a line 10584 in updatedatabase.pl so it's 
>> difficult for me to determine what is throwing the error.
>> 
>> 
>> gcb __
>> 
>> Gary C. Bortel Office of the Secretary of State, Washington
>> State Library gary.bor...@sos.wa.gov 360.570.5588
>> 
>> Washington State Library: Empowering 21st Century Washington
>> 
>> 
>> -Original Message- From: Koha 
>> [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Jonathan 
>> Druart Sent: Monday, January 11, 2016 8:24 AM To: 
>> koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 
>> --> 3.20.07
>> 
>> Hi Gary,
>> 
>>> DBD::mysql::db do failed: Can't create table 
>>> 'koha_library.#sql-4b9_42' (errno: 121) at 
>>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase
.pl
>>>
>>> 
line 10584.
>> 
>> I would say that the foreign key on course_reserves has not been 
>> created. You should check the data in course_items (some don't 
>> have a correspondence in course_reserves).
>> 
>>> DBD::mysql::db do failed: Duplicate entry '1-self_checkout'
>>> for key 'PRIMARY' at 
>>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase
.pl
>>>
>>> 
line 10614.
>> 
>> You can forget this one, you already had the self_checkout 
>> syspref in your database.
>> 
>> Regards, Jonathan
>> 
>> 2016-01-11 16:02 GMT+00:00 Bortel, Gary 
>> :
>>> I am seeing two MySQL errors thrown when trying to update from 
>>> 3.18.11 --> 3.20.07. Are these benign or something about which 
>>> concern should be raised?
>>> 
>>> The installation here is Ubuntu 14.04.3 with a multi-tenant 
>>> package install of Koha. Mysql  Ver 14.14 Distrib 5.5.46, for 
>>> debian-linux-gnu (x86_64) using readline 6.3
>>> 
>>> . . . . Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL 
>>> to include protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) 
>>> Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly 
>>> set) Upgrade to 3.20.01.002 done (Bug 13993: Correct 
>>> orderstatus for transferred orders) Upgrade to 3.20.02.000
>>> done (Koha 3.20.2) Upgrade to 3.20.03.000 done (Koha 3.20.3) 
>>> DBD::mysql::db do failed: Can't create table 
>>> 'koha_library.#sql-4b9_42' (errno: 121) at 
>>> /usr/share/koha/intranet/cgi-bin/insta

Re: [Koha] Problem with Check expiration in Serials

[Liz Rea]

Hi,

Are you doing this with the database user logged in, or a regular user?

Cheers,
Liz

On 08/03/16 06:54, Elaine Bradtke wrote:
> ​We're running 3.20.7 and just getting around to testing out some of the
> features in the Serials module. We set up a dummy record to try things like
> notices, etc. and when I clicked on Check Expiration all I got was an error
> message.​
>
> Any idea what the following means?  I
> ​ get the gist of it - something's missing somewhere. I​
> can't find any system preferences that look remotely
> ​like they might address this. There really is only one 'branch' in our
> system.
> ​
> ​
> Global symbol "$branch" requires explicit package name at
> /home/koha/koha-test/intranet/cgi-bin/serials/checkexpiration.pl line 84.
> Global symbol "$branch" requires explicit package name at
> /home/koha/koha-test/intranet/cgi-bin/serials/checkexpiration.pl line 84.
> Execution of /home/koha/koha-test/intranet/cgi-bin/serials/
> checkexpiration.pl aborted due to compilation errors.

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Remove the password option in patron attributes

[Liz Rea]

Hi Dianna,

The PIN/Password we are talking about here is separate from the normal
user id and password that you put in when you are registering a
borrower. That user id and password are what allow logins to the public
side of Koha, these extended attribute passwords are different to those,
they are stored in plain text (very bad), and don't have any code behind
them to even be used.

You can confirm whether or not you are trying to use this feature by
going to Administration -> Patron attribute types, and clicking through
each one, verifying that the "Password" box is not checked on any of the
attributes.

If you have no attributes listed here, you are not using this and it
would be safe for us to remove it. :)

I hope this helps, please let us know what you find.

Cheers,
Liz

On 20/04/16 08:29, Dianna Waite wrote:
> The PIN  is used at our library as  a way for patrons to log in to their
> account online and to use our  virtual services.  In the patron
> registration field once the pin is put in  the staff can not see what it
> was.  So  it is not clear for anyone else to see.
>
> On Tue, Apr 19, 2016 at 3:07 PM, Katrin Fischer 
> wrote:
>
>> Hi Jonathan,
>>
>> I think you have a good point about it being a bad idea to store
>> passwords as plain text. So far it seems unused too - removing it would
>> be ok for me.
>>
>> Katrin
>>
>> Am 19.04.2016 um 09:22 schrieb Jonathan Druart:
>>> Hello everybody,
>>>
>>> I'd like to get opinion on the password option available in patron
>> attributes.
>>> Initially this field was created to allow patrons to use an alternate
>>> password to login, but it has never been implemented.
>>> I have suggested to remove it on bug 12267 as we don't use it
>>> internally and as it's a bad idea to use a password stored in clear
>>> text.
>>> If you are using this option, please tell us know to discuss the matter.
>>>
>>> Regards,
>>> Jonathan
>>>
>>> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12267
>>> ___
>>> 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
>>
>
>

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Upgraded to 16.05 and can't retrieve Patrons by Surname

[Liz Rea]

Hi Tim,

Please try force-refreshing the page (Shift+f5 or shift+reload button),
this probably has to do with outdated Javascript.

Cheers,
Liz Rea
Catalyst IT


On 20/06/16 15:56, Tim Auld wrote:
> Hi,
> I upgraded to 16.05 from 3.18 this evening. After the upgrade, which seemed
> to work very well, I find that I can't lookup Patrons using either the
> Search facility searching on Surname, or clicking on one of the Alpha
> buttons (the retrieve all Patrons that start with "S" for example).
>
> I notice that there was an issue recorded already (ticket 14193) for this
> problem, which should have a fix included in the 16.05 release according to
> the documentation.  Am I missing something here or should I roll back to
> the backup that I took prior to starting the upgrade?
>
> Regards,
>
> Tim Auld
> Northern Philatelic Library
> Minnesota.
>
> Ps. I apologize if this question has already been asked and I missed it.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Need help to open a staff patron

[Liz Rea]

Hi,

This is because you are using Ubuntu 16.04 with MySQL 5.7 - see bug
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16583 and
other related bugs.

The recommendation is to downgrade MySQL version or use an OS that comes
with any prior version of MySQL until this bug is sorted.

Cheers,
Liz

On 28/06/16 16:14, Mahmudul Hasan wrote:
> Dear All
>
> I am new here. So, I have read the manual and seen nothing to solve
> this problem. According to manuual whenever i am going to add a new
> patron. It can not.
>
> At the first time when i was logged in following warning message shows
> and that is
>
> "You are logged in as the database administrative user. This is not
> recommended because some parts of Koha will not function as expected
> when using this account.
>
> Please log in instead with a regular staff account. To create a staff
> account, create a library, a patron category 'Staff' and add a new
> patron. Then give this patron permissions from 'More' in the toolbar."
>
>
> According to the message i went to the top of the site to set library
> from there i chose the canterville. After that i clicked on create
> patron>new patron and from drop down menu choose staff. There a
> message came that is "can not add patron. please add a patron
> category." So i clicked on the patron category. There i add a new
> patron category named College Staff. Again i continued but again this
> message comes. At last i went to tools>patron list> new patron> create
> a new patron list> Give name "Staff">save and following message comes.
>
>
> Software error:
>
> Can't call method "patron_list_id" on an undefined value at
> /usr/share/koha/intranet/cgi-bin/patron_lists/add-modify.pl line 55.
>
> For help, please send mail to the webmaster ([no address given]),
> giving this error message and the time and date of the error.
>
>
> How can i fix it? I have no idea. Please help me. Even i can not open
> the list. There also show same type message.
>
> By the way I have installed on the following
>
> Koha version-16.05.00.000
> server platform- ubuntu 16.04 LTS amd64
> method of installation-marc21
>
> Thanks in advance.
>
> Regards
>
> Mahmud
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Specific Dimensions for Avery 5428 Self-Adhesive Labels When Using Spine Label Creator

[Liz Rea]

Hi Kate,

It would be a really cool feature, for sure, but sadly there isn't a way
to import label templates.

If you file a bug at https://bugs.koha-community.org asking for it, it
could become reality. Even better if you toss a few bucks towards a
developer to make it happen!

Cheers,
Liz

On 24/06/16 11:46, Kate Cunningham wrote:
> Does anyone else use this product when creating spine labels? Is there a
> way to upload the template into the creator? I thought I'd reach out to the
> community before getting out my ruler.
> Thanks!
> Katie Cunningham
> Conway Public Library
> Conway, NH USA
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Did the Let's Encrypt cert for koha-community.org just expire?

[Liz Rea]

This should be sorted now. Hazards of being an early adopter!

Liz

On 04/07/16 21:32, Indranil Das Gupta wrote:
> Hi just a heads up!
>
> echo $SUBJECT
>
> I'm probably seeing this because of TZ diff between where the server
> is and my location.
>
> cheers
> -idg
>
>
>

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Patron import problem 3.22

[Liz Rea]

Hi Elaine,

This was a bug in 3.22.06 - I've seen it too and there was a patch for
it included in 3.22.07:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16426

Hope this helps,

Liz

On 12/07/16 06:43, Elaine Bradtke wrote:
> We routinely import patron records (derived from our membership database)
> and overwrite the old ones in order to update expiration dates, addresses,
> etc.
> I recently ran this process through our test site (running 3.22.06) and it
> failed. The error message I got back was the records were not imported
> because the userid was already in use or missing. I had chosen 'overwrite
> matching records'
>
> Oddly, the import process  worked fine in the production site
> running 3.22.07
>
> Is there a system preference I should check in the test site?
> Maybe this is related to Bug 15840 - Import borrowers tool explodes if
> userid already exists
> ​We match on cardnumber,  Is this the same as the userid? We don't have a
> column in our csv file called userid.​
>

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] "No Title" in search results

[Liz Rea]

Also, I wonder if you also see this behaviour in the cataloguing search
(More -> Cataloguing -> do a search)

Also do you use custom frameworks?

Cheers,
Liz

On 27/07/16 09:25, Tomas Cohen Arazi wrote:
> Is there a reason for you so you don't use the XSLT view?
>
> El mar., 26 jul. 2016 a las 18:18, Coehoorn, Joel ()
> escribió:
>
>> We have a number of records that show "No Title" in the search results. As
>> an example, visit our opac and search for "McNeese"
>> <https://koha.york.edu/cgi-bin/koha/opac-search.pl?q=mcneese>. You can see
>> that these records clearly DO have a title: it shows if you click through
>> to view the full result, and it shows in the 245 field if you view the MARC
>> record. It's just in the search results that it's missing.They'll even show
>> the "rest of the title" field if there is one. This problem does not occur
>> for all records.
>>
>> In an effort to figure out what's going on I have updated to 16.05, and
>> also completely re-indexed zebra.
>>
>> Any ideas how to fix this?
>>
>>
>> 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
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] "No Title" in search results

[Liz Rea]

I've seen this as well - do you use custom frameworks (or maybe only
*old* frameworks)? I've only seen it happen on items catalogued with a
custom framework.

Cheers,
Liz

On 27/07/16 09:37, Coehoorn, Joel wrote:
> The title is also missing in Cataloguing view, even after turning on XSLT.
>
>
>
> 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 Tue, Jul 26, 2016 at 4:32 PM, Liz Rea  wrote:
>
>> Also, I wonder if you also see this behaviour in the cataloguing search
>> (More -> Cataloguing -> do a search)
>>
>> Also do you use custom frameworks?
>>
>> Cheers,
>> Liz
>>
>> On 27/07/16 09:25, Tomas Cohen Arazi wrote:
>>> Is there a reason for you so you don't use the XSLT view?
>>>
>>> El mar., 26 jul. 2016 a las 18:18, Coehoorn, Joel ()
>>> escribió:
>>>
>>>> We have a number of records that show "No Title" in the search results.
>> As
>>>> an example, visit our opac and search for "McNeese"
>>>> <https://koha.york.edu/cgi-bin/koha/opac-search.pl?q=mcneese>. You can
>> see
>>>> that these records clearly DO have a title: it shows if you click
>> through
>>>> to view the full result, and it shows in the 245 field if you view the
>> MARC
>>>> record. It's just in the search results that it's missing.They'll even
>> show
>>>> the "rest of the title" field if there is one. This problem does not
>> occur
>>>> for all records.
>>>>
>>>> In an effort to figure out what's going on I have updated to 16.05, and
>>>> also completely re-indexed zebra.
>>>>
>>>> Any ideas how to fix this?
>>>>
>>>>
>>>> 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
>>>> ___
>>>> Koha mailing list  http://koha-community.org
>>>> Koha@lists.katipo.co.nz
>>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>
>> --
>> --
>> Liz Rea
>> Catalyst.Net Limited
>> Level 6, Catalyst House,
>> 150 Willis Street, Wellington.
>> P.O Box 11053, Manners Street,
>> Wellington 6142
>>
>> GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7
>>
>>
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] "No Title" in search results

[Liz Rea]

Hi Joel,

Also, do you happen to have more than one field mapped to biblio.title
in your framework?

Cheers,
Liz

On 27/07/16 10:12, Katrin Fischer wrote:
> Hi Joel,
>
> quickly running out of ideas :(
>
> Can you check if BKS is really the framework used here? The itemtype
> might be misleading. The easiest way to see is on editing. Another idea:
> Save it again with a little change and check if that changes something.
>
> Katrin
>
> Am 27.07.2016 um 00:05 schrieb Coehoorn, Joel:
>> Looking at one of the records, I can see the item and material type
>> both show "book":
>>
>> Inline image 1
>>
>> and the title does show in the 245 a field
>>
>> Inline image 2
>>
>> and that the 245 a field for the BKS (book) framework does map to
>> biblio.title:
>>
>> Inline image 3
>>
>> Moreover, I can do an SQL query into the biblios table for that item
>> and see that the title field is populated:
>>
>>
>> mysql> select title from biblio where biblionumber = 96711;
>> +-+
>> | title   |
>> +-+
>> | Illustrated myths of Native America |
>> +-+
>> 1 row in set (0.00 sec)
>>
>> mysql>
>>
>>
>>
>>
>>  
>>
>> Joel Coehoorn
>> Director of Information Technology
>> 402.363.5603
>> *jcoeho...@york.edu <mailto: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 Tue, Jul 26, 2016 at 4:53 PM, Katrin Fischer
>> mailto:katrin.fischer...@web.de>> wrote:
>>
>> Hi Joel,
>>
>> have you changed your Koha-2-Marc-Mappings by chance? I wonder if for
>> the problematic records the title was not saved to biblio.title. This
>> could be caused by a missing mapping of 245$a to biblio.title for
>> one or
>> more of your frameworks.
>>
>> Hope this helps,
>>
>> Katrin
>>
>> Am 26.07.2016 um 23:37 schrieb Coehoorn, Joel:
>> > The title is also missing in Cataloguing view, even after
>> turning on XSLT.
>> >
>> >
>> >
>> > Joel Coehoorn
>> > Director of Information Technology
>> > 402.363.5603 
>> > *jcoeho...@york.edu <mailto:jcoeho...@york.edu>
>> mailto: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 Tue, Jul 26, 2016 at 4:32 PM, Liz Rea > <mailto:l...@catalyst.net.nz>> wrote:
>> >
>> >> Also, I wonder if you also see this behaviour in the
>> cataloguing search
>> >> (More -> Cataloguing -> do a search)
>> >>
>> >> Also do you use custom frameworks?
>> >>
>> >> Cheers,
>> >> Liz
>> >>
>> >> On 27/07/16 09:25, Tomas Cohen Arazi wrote:
>> >>> Is there a reason for you so you don't use the XSLT view?
>> >>>
>> >>> El mar., 26 jul. 2016 a las 18:18, Coehoorn, Joel
>> (mailto:jcoeho...@york.edu>>)
>> >>> escribió:
>> >>>
>> >>>> We have a number of records that show "No Title" in the
>> search results.
>> >> As
>> >>>> an example, visit our opac and search for "McNeese"
>> >>>>
>> <https://koha.york.edu/cgi-bin/koha/opac-search.pl?q=mcneese>. You can
>> >> see
>> >>>> that these records clearly DO have a title: it shows if you click
>> >> through
>> >>>> to view the full result, and it shows in the 245 field if you
>> view the
>> >> MARC
>> >>>> record. It's just in the search results that it's
>> missing.They'll even
>> >> show
>> >>>> the "rest of the title" field if there is one. This problem
>> does not
>> >> occur
>> >>&

Re: [Koha] Superscript?

[Liz Rea]

You can also try using the Windows (or Mac) character map to copy/paste
the superscript:

Windows 10: 
http://www.isunshare.com/windows-10/6-ways-to-access-character-map-in-windows-10.html

MacOS (various): http://symbolcodes.tlt.psu.edu/keyboards/charpalosx.html

Apologies if you already thought to do this and just want to type it in.
This is the "easiest" way I know of.

Liz

On 27/09/16 10:06, Chris Cormack wrote:
> * Elaine Bradtke (e...@efdss.org) wrote:
>> Excellent!  How did you do it?   I've tied my fingers in knots trying all
>> sorts of key combinations. I've gotten some unexpected results, but not
>> what I wanted.
> http://www.fileformat.info/info/unicode/char/b2/index.htm
>
> Chris
>
>> On Mon, Sep 26, 2016 at 8:44 PM, Chris Cormack 
>> wrote:
>>
>>> * Elaine Bradtke (e...@efdss.org) wrote:
>>>> One of my colleagues has asked if it's possible to type a superscript in
>>>> Koha
>>>>
>>>> ​"Otherwise, essay2 (a record label) becomes essay2."​
>>> Yes it is,
>>>
>>> As long as it is a utf8 character.
>>>
>>> http://demo.mykoha.co.nz/cgi-bin/koha/opac-detail.pl?biblionumber=30727
>>>
>>> (This record will disapear at 6am tomorrow NZ time (in 22 hours or so) but
>>> you
>>> can take a look before then
>>>
>>> Chris
>>>
>>>
>>>> I have tried a number of variations of holding down and pressing keys in
>>>> the cataloguing mode in Koha but haven't successfully managed to do
>>>> anything useful.  Creating the text in a text editor and copying and
>>>> pasting didn't work either
>>>>
>>>>  It may be complicated by the fact that I'm running Windows on an
>>> emulator
>>>> on my Mac. . .
>>>> The rest of the staff uses fairly recent Windows if that makes any
>>>> difference.
>>>>
>>>> --
>>>> Elaine Bradtke
>>>> Data Wrangler
>>>> VWML
>>>> English Folk Dance and Song Society | http://www.efdss.org
>>>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>>>> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
>>> and
>>>> Song Society in London, England. If you wish to phone me personally, send
>>>> an e-mail first. I work off site)
>>>> 
>>> --
>>>> Registered Company No. 297142
>>>> Charity Registered in England and Wales No. 305999
>>>> 
>>> ---
>>>> "Writing about music is like dancing about architecture"
>>>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>>>> ___
>>>> Koha mailing list  http://koha-community.org
>>>> Koha@lists.katipo.co.nz
>>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>> --
>>> Chris Cormack
>>> Catalyst IT Ltd.
>>> +64 4 803 2238
>>> PO Box 11-053, Manners St, Wellington 6142, New Zealand
>>>
>>
>>
>> -- 
>> Elaine Bradtke
>> Data Wrangler
>> VWML
>> English Folk Dance and Song Society | http://www.efdss.org
>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
>> Song Society in London, England. If you wish to phone me personally, send
>> an e-mail first. I work off site)
>> --
>> Registered Company No. 297142
>> Charity Registered in England and Wales No. 305999
>> ---
>> "Writing about music is like dancing about architecture"
>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>> ___
>> 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

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7



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

Re: [Koha] Request to add

[Liz Rea]

This request has been completed.

Cheers,
Liz


On 11/10/16 01:48, radek.si...@centrum.cz wrote:
> Hello,
> I'd like to ask anybody who's responsible to add the following record
> into the list of paid service providers.
> Thanks in advance
> Radek Siman
>  
>  
> Company Name: R-Bit Technology, s.r.o.
>  
> Country: Czech Republic, Europe
>
> Contact Person: Radek Šiman
> Contact email: i...@koha-v-knihovne.cz 
>
> Website: http://www.koha-v-knihovne.cz 
>
> Telephone: +420 604 944 755 
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Regarding updating Patron messaging preferences

[Liz Rea]

Hi,

There is a script to do this in the Koha package, in
misc/maintenance/borrowers-force-messaging-defaults

To use it, you would set your borrower categories up the way you want in
terms of messaging, and this script will update all borrowers based on
their category default.

Bear in mind, if you have had the enhanced messaging preferences on
previously, and borrowers have updated their own settings, using this
tool will wipe out their settings and replace them with the new default.
This could make users angry.

I hope this helps,

Liz Rea

CatalystIT

On 24/11/16 00:48, Sahadeo Taware wrote:
> We are using koha software for our library (version 16.05.05.000) on ubuntu
> server
>
> Presently we are sending email alert for overdue, checkin, checkout, predue
> and due
> But now we want to send email alert only for overdue and predue and not for
> checkin and checkout
>
> How can I update the all patron messaging preferences in a single query

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Manual locations?

[Liz Rea]

Hi Michael,

Please file a bug under "Koha -> Website" on bugs.koha-community.org and
we'll get this looked into. I see what you are talking about and it does
in fact seem wrong. Nothing on the page itself has changed recently, so
it must be that stuff has moved around on the target server and no one
let us know.

Cheers,
Liz Rea


On 24/11/16 12:06, Michael Kuhn wrote:
> Hi Irma
>
>> You will find the Koha 16.05 Manual
>> here: http://manual.koha-community.org/16.05/en/index.html
>> <http://manual.koha-community.org/16.05/en/index.html>
>
> Thanks, yes!
>
> Will these new links be permanent? I wish links would alwaysw be
> permanent, forever I mean... sigh.
>
> However, most of the links shown under
> https://koha-community.org/documentation/ are now broken, because the
> point to the following kind of paths:
>
> http://translate.koha-community.org/manual/xx.xx/en/html-desktop/
>
> http://translate.koha-community.org/manual/xx.xx/en/pdf/Koha-xx.xx-koha-manual-en.pdf
>
>
> So someone with the needed privileges should fix this.
>
> Best wishes:

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Number of Koha Libraries in the Word

[Liz Rea]

It's gone. For now.



On Thu, Dec 8, 2016 at 9:44 AM, Michael Kuhn  wrote:

> Hi Sebastian
>
> We discussed this issue before and a number of very impressive figures were
>> quoted, but when I go to the home page of the Koha community, at
>> https://koha-community.org/about/libraries/, I only see a sample of Koha
>> libraries and our library is missing.
>>
>
> I was not aware of this list, which is very incomplete and uninformative
> compared to https://wiki.koha-community.org/wiki/Koha_Users_Worldwide or
> especially to Marshall Breedings great list of Koha libraries throughout
> the world at
> https://librarytechnology.org/lwc-processquery.pl?ILS=Koha (which
> actually list 4'427 libraries with a lot of details).
>
> Please do not get me wrong, I think that the list is good, but as any list,
>> hard to keep up to date.
>>
>> In light of our marketing effort, we should bring it as up to date as we
>> can. In order to get us listed, I went to https://gitlab.com/koha-
>> community-devs-users/Koha-library-list/ and clicked on "Merge Request,"
>> but
>> could find how to place a new request. There is no "new" button or
>> similar.  Others were able to do it and I applaud them, but we are not
>> going to get many new libraries to list themselves and keep this list
>> relevant, if they cannot easily and immediately place a request.  Is this
>> something that could be fixed?  I.e. add a green "NEW" button or something
>> of the sort.  And could you explain me how I could add our library?
>>
>
> To me it seems an absolutely horrible idea that libraries or anyone should
> learn or use Git when they want to include themselves in a simple list.
> Instead I suggest to delete this list and instead link to
> https://wiki.koha-community.org/wiki/Koha_Users_Worldwide
>
> In my case however I stick to the above mentioned lists and I will simply
> ignore the list at https://koha-community.org/about/libraries/ when
> adding new libraries.
>
> Best wishes: Michael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
>
> ___
> 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] Number of Koha Libraries in the Word

[Liz Rea]

Hi,

I'd really like to see Hea improved, and link to that instead. It is our
own, open, data. It is fully voluntary. We can make the registration
process easier for libraries - possibly as part of the installer. It is too
hidden now.

An API to Hea that I could pull from to use the data on the website would
be a nice thing, but not a requirement. I'm happy to simply link to it.

We have this tool, we should encourage more strongly the use of it, instead
of depending on a third party with non-open data.

Liz

On Tue, Dec 13, 2016 at 6:18 AM, Katrin  wrote:

> +1
>
> While Marshall's directory is a valuable source with lots of interesting
> information, there are also known limits to it that have been discussed
> before.
>
> I think it has merit that we as a community have a way for libraries to
> enlist themselves as users. So far we got Hea and a lot of cool entries on
> the wiki. I think for marketing purposes the wiki is a bit nicer, as it has
> the full names of the libraries and links to their catalogs. Why not link
> this page and maybe clean it up a bit? We could also offer to help
> libraries to add their entries there without having to register.
>
> Katrin
>
>
>
> On 12.12.2016 18:05, Indranil Das Gupta wrote:
>
>> On Dec 12, 2016 10:28 PM, "Chris Cormack"  wrote:
>>
>>> Hi All
>>>
>>> I'm going to be a dissenting voice on this. (There's always one)
>>>
>>> I much prefer hea because it has an open data license.
>>>
>> +1
>>
>> -idg
>> ___
>> 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] Number of Koha Libraries in the World

[Liz Rea]

http://hea.koha-community.org/libraries This is the list I am referring
to. There is an option to send your library name as part of Hea
registration.

Cheers,
Liz

On 13/12/16 12:37, Marc Véron wrote:
> +1
>
> Marc
>
>
> Am 12.12.2016 um 23:15 schrieb Liz Rea:
>> Hi,
>>
>> I'd really like to see Hea improved, and link to that instead. It is our
>> own, open, data. It is fully voluntary. We can make the registration
>> process easier for libraries - possibly as part of the installer. It
>> is too
>> hidden now.
>>
>> An API to Hea that I could pull from to use the data on the website
>> would
>> be a nice thing, but not a requirement. I'm happy to simply link to it.
>>
>> We have this tool, we should encourage more strongly the use of it,
>> instead
>> of depending on a third party with non-open data.
>>
>> Liz
>>
>> On Tue, Dec 13, 2016 at 6:18 AM, Katrin 
>> wrote:
>>
>>> +1
>>>
>>> While Marshall's directory is a valuable source with lots of
>>> interesting
>>> information, there are also known limits to it that have been discussed
>>> before.
>>>
>>> I think it has merit that we as a community have a way for libraries to
>>> enlist themselves as users. So far we got Hea and a lot of cool
>>> entries on
>>> the wiki. I think for marketing purposes the wiki is a bit nicer, as
>>> it has
>>> the full names of the libraries and links to their catalogs. Why not
>>> link
>>> this page and maybe clean it up a bit? We could also offer to help
>>> libraries to add their entries there without having to register.
>>>
>>> Katrin
>>>
>>>
>>>
>>> On 12.12.2016 18:05, Indranil Das Gupta wrote:
>>>
>>>> On Dec 12, 2016 10:28 PM, "Chris Cormack" 
>>>> wrote:
>>>>
>>>>> Hi All
>>>>>
>>>>> I'm going to be a dissenting voice on this. (There's always one)
>>>>>
>>>>> I much prefer hea because it has an open data license.
>>>>>
>>>> +1
>>>>
>>>> -idg
>>>> ___
>>>> 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

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Up-to-dateness of Koha database analysis by SchemaSpy

[Liz Rea]

Second this, terrifying as it is. Drop the database and reload the
backup. It has to do with the way mysqldump exports the data,
alphabetically and without regard to foreign key dependencies.

Cheers,
Liz

On 28/12/16 20:32, Katrin wrote:
>
> I have seen errors like this when trying to restore into a database
> where the web installer already created the tables for Koha. If that's
> the case, try to drop and create the database and then load your backup.
>
> Hope this helps,
>
> Katrin
>
> On 27.12.2016 08:39, Ahmad Nasser wrote:
>> i install koha using package installation and i when i restore backup
>> it give me this error ("Can't create table 'koha_library.aqbasket'
>> (errno: 150)")
>>
>> i install koha version 16.5 and my backup file for koha 3.16 so how
>> solve it.
>>
>> On Tue, Dec 27, 2016 at 8:43 AM, Katrin > <mailto:katrin.fischer...@web.de>> wrote:
>>
>> Hi Ahmad,
>>
>> it's hard to tell for us where the problem is without the error
>> messages. Sometimes you will get warnings that can be safely
>> ignored. Can you send them with a new subject to the list?
>>
>> Katrin
>>
>>
>> On 26.12.2016 21:36, Ahmad Nasser wrote:
>>
>> i have old version for koha 3.16 and i want to upgrade so i
>> want to update
>> or upgrade schema-koha to avoid error because when i upgrade
>> to koha 3.22
>> or koha 3.20 it five me errors, please help me
>>
>> On Mon, Dec 26, 2016 at 9:57 PM, Chris Cormack
>> mailto:chr...@catalyst.net.nz>>
>> wrote:
>>
>> Hi All
>>
>> I actually have most of that set up, eg
>> http://schema.koha-community.
>> org/master/
>>
>> And
>>
>> http://schema.koha-community.org/16_05/
>> <http://schema.koha-community.org/16_05/>
>>
>> Just needs to be finished off, I'll try to do that in the
>> next time few
>> days, we will need to submit some patches to Koha so we
>> link to the right
>> version from the reports page though.
>>
>> Chris
>>
>> On 27 December 2016 8:44:29 AM NZDT, David Nind
>> mailto:david.n...@gmail.com>>
>> wrote:
>>
>> Hi Michael.
>>
>> I will look into getting it up-to-date.
>>
>> It may take a few days though, as I work through what
>> is required.
>>
>> I will also work out whether we can display the schema
>> for different
>> versions of Koha.
>>
>> Regards.
>>
>> David Nind | david.n...@gmail.com
>> <mailto:david.n...@gmail.com>
>> PO Box 12367, Thorndon, Wellington, New Zealand 6144
>> m. +64 21 0537 847 | w. +64 4 8906 098
>> ___
>> Koha mailing list http://koha-community.org
>> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> <https://lists.katipo.co.nz/mailman/listinfo/koha>
>>
>> --
>> Sent from my Android device with K-9 Mail. Please excuse
>> my brevity.
>> ___
>> Koha mailing list http://koha-community.org
>> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> <https://lists.katipo.co.nz/mailman/listinfo/koha>
>>
>> ___
>> Koha mailing list http://koha-community.org
>> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> <https://lists.katipo.co.nz/mailman/listinfo/koha>
>>
>>
>> ___
>> Koha mailing list http://koha-community.org
>> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> <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

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Koha 16.05 - Holds Script - Run Frequency

[Liz Rea]

Hi Craig,
The cron job is run from files are in /etc/cron.hourly/koha-common for a
package install.

Note that "build_holds_queue.pl" doesn't affect the holds to pull. It
only affects the hold queue. 

To change the frequency, you could comment out the job in
/etc/cron.hourly/koha-common, adding an octothorpe at the beginning of
the job like

# koha-foreach --enabled
/usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl

and then create one in the /etc/cron.d/koha-common like

*/15 * * * * koha-foreach --enabled
/usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl

very much like the process_message_queue.pl entry. This will run the job
every 15 minutes, at 00, 15, 30, and 45. To change the interval, swap
out the the 15 in */15 for your desired interval.

On a recent debian(8)/ubuntu(16), you can check the cron log super
easily with sudo systemctl status cron

I hope this helps!

Cheers,
Liz


On 26/01/17 04:11, Craig Butosi wrote:
> Hi all,
>
> Koha 16.05 on Ubuntu 14.04 LTS
>
> Can someone confirm the name and location of the script that controls the 
> processing of hold requests? By 'processing' I mean when a patron clicks on 
> "Place Hold" from the OPAC, and then that request gets entered into the 
> "Holds to Pull" screen in the staff client. I see in directory 
> /etc/koha/cron.hourly/ there is a script called "build_holds_queue.pl". Is 
> this the one?
>
> If it is, then if I wanted to run it as frequently as every 15 minutes 
> (instead of every hour), how would I go about doing that (I've never had to 
> edit a cron in the cron.hourly folder, only in crontab)? Are there any issues 
> will running this script more frequently than every hour? (We are a library 
> with a user base of about 600, and with a collection of about 50,000 items; 
> by most standards a small library).
>
> Many thanks all!
>
> Craig Butosi, MA, MLIS, B Mus (Hons.)
> LIBRARY SERVICES MANAGER
> the royal conservatory
> TELUS Centre for Performance and Learning
> 273 Bloor Street West
> Toronto, ON M5S 1W2
> 416.408.2824 x338
> www.rcmusic.ca<http://www.rcmusic.ca/>
>
>
>
> Note: This email message and any attachments are intended only for the use of 
> the individual to which it is addressed, and may contain information that is 
> privileged, confidential and exempt from disclosure under applicable law. If 
> the recipient of this email is not the intended recipient (or the employee or 
> agent responsible for delivering the email to the intended recipient), you 
> are hereby notified that any review, dissemination, distribution or copying 
> or other use of this message is strictly prohibited. If you have received 
> this communication in error, please notify the sender immediately by return 
> email and delete this message and attachments from your system, thank you.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Koha 16.05 - Holds Script - Run Frequency

[Liz Rea]

A common thing on the holds-to-pull list is that the default limit for
holds to show on holds-to-pull is 2 days, you might consider upping the
default limit in the system preferences, or adding a filter that is
further back, which might catch a bunch of things you didn't know were
there!

Cheers,
Liz

On 26/01/17 11:06, Craig Butosi wrote:
> Hi Liz,
>
> Ah, okay. It's clearer to me now how to edit crons in the .hourly, .daily 
> folders. I thought it might have had something do with commenting out extant 
> entries and moving them elsewhere - thanks for clarifying! If " 
> build_holds_queue.pl " has nothing to do with posting holds to the "Holds to 
> Pull" page, then I won't touch it.
>
> I had a strange report of a student placing a hold recently, but nothing 
> appearing on the "Holds to Pull" page (we've had no problems with our hold 
> system to date, which has been running since September). My first thought was 
> possible lag time between the hold request itself and a holds-related script 
> running; but, this issue may be a case where the student didn't place a hold 
> correctly, or something else. I'll investigate further.
>
> Many thanks,
>
>
> Craig Butosi, MA, MLIS, B Mus (Hons.)
> LIBRARY SERVICES MANAGER
> THE ROYAL CONSERVATORY
> TELUS Centre for Performance and Learning
> 273 Bloor Street West
> Toronto, ON M5S 1W2
> 416.408.2824 x338
> www.rcmusic.ca
>
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Liz Rea
> Sent: January-25-17 3:53 PM
> To: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Koha 16.05 - Holds Script - Run Frequency
>
> Hi Craig,
> The cron job is run from files are in /etc/cron.hourly/koha-common for a 
> package install.
>
> Note that "build_holds_queue.pl" doesn't affect the holds to pull. It only 
> affects the hold queue.
>
> To change the frequency, you could comment out the job in 
> /etc/cron.hourly/koha-common, adding an octothorpe at the beginning of the 
> job like
>
> # koha-foreach --enabled
> /usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl
>
> and then create one in the /etc/cron.d/koha-common like
>
> */15 * * * * koha-foreach --enabled
> /usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl
>
> very much like the process_message_queue.pl entry. This will run the job 
> every 15 minutes, at 00, 15, 30, and 45. To change the interval, swap out the 
> the 15 in */15 for your desired interval.
>
> On a recent debian(8)/ubuntu(16), you can check the cron log super easily 
> with sudo systemctl status cron
>
> I hope this helps!
>
> Cheers,
> Liz
>
>
> On 26/01/17 04:11, Craig Butosi wrote:
>> Hi all,
>>
>> Koha 16.05 on Ubuntu 14.04 LTS
>>
>> Can someone confirm the name and location of the script that controls the 
>> processing of hold requests? By 'processing' I mean when a patron clicks on 
>> "Place Hold" from the OPAC, and then that request gets entered into the 
>> "Holds to Pull" screen in the staff client. I see in directory 
>> /etc/koha/cron.hourly/ there is a script called "build_holds_queue.pl". Is 
>> this the one?
>>
>> If it is, then if I wanted to run it as frequently as every 15 minutes 
>> (instead of every hour), how would I go about doing that (I've never had to 
>> edit a cron in the cron.hourly folder, only in crontab)? Are there any 
>> issues will running this script more frequently than every hour? (We are a 
>> library with a user base of about 600, and with a collection of about 50,000 
>> items; by most standards a small library).
>>
>> Many thanks all!
>>
>> Craig Butosi, MA, MLIS, B Mus (Hons.)
>> LIBRARY SERVICES MANAGER
>> the royal conservatory
>> TELUS Centre for Performance and Learning
>> 273 Bloor Street West
>> Toronto, ON M5S 1W2
>> 416.408.2824 x338
>> www.rcmusic.ca<http://www.rcmusic.ca/>
>>
>>
>>
>> Note: This email message and any attachments are intended only for the use 
>> of the individual to which it is addressed, and may contain information that 
>> is privileged, confidential and exempt from disclosure under applicable law. 
>> If the recipient of this email is not the intended recipient (or the 
>> employee or agent responsible for delivering the email to the intended 
>> recipient), you are hereby notified that any review, dissemination, 
>> distribution or copying or other use of this message is strictly prohibited. 
>> If you have received this communication in error, please notify the sender 
>>

Re: [Koha] Koha Plugin System

[Liz Rea]

Hi Bob,

Probably you have a compile error in your plugin, see bug
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17461. It
turns out that if the plugin has some kind of syntax error, the plugin
entry won't turn up in the intranet, *and* won't give any errors either!

I'm going to take a guess that you have a use C4::Branches in your
plugin, as that seems quite common a thing for plugins to choke on since
all of the branches stuff was moved to Koha::Libraries in a recent version.

You could also try applying or editing your code to use the patch off of
the above bug, and see if you get more useful diagnostic information.

Sincerely,
Liz, who just spent much too long figuring out what the heck was going
on and now has a bruised forehead from banging her head on the wall.

On 04/02/17 17:50, Bob Ewart wrote:
> I just installed Debian-live-8.7.1-amd64-kde-desktop.iso on a virtual
> machine and Koha 16.11.03 from the Debian packages, and mysql 5.5.  I
> reloaded my koha.sql data from the old system 3.22.05.
>
> The upgrade went with a few errors:
>
> [Fri Feb 3 22:08:01 2017] updatedatabase.pl: At least one
> authorised value has an icon defined (imageurl)
> [Fri Feb 3 22:08:01 2017] updatedatabase.pl: The system preference
> AuthorisedValueImages or StaffAuthorisedValueImages could be turned
> off if you are not aware of this feature
> [Fri Feb 3 22:08:30 2017] updatedatabase.pl: item-level_itypes set
> but no itype defined for item (495) at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13447.
> [Fri Feb 3 22:08:32 2017] updatedatabase.pl: item-level_itypes set
> but no itype defined for item (1632) at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13447.
> [Fri Feb 3 22:08:32 2017] updatedatabase.pl: item-level_itypes set
> but no itype defined for item (658) at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13447.
> [Fri Feb 3 22:08:34 2017] updatedatabase.pl: item-level_itypes set
> but no itype defined for item (20337) at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13447.
> [Fri Feb 3 22:08:34 2017] updatedatabase.pl: DBD::mysql::db do
> failed: Can't DROP 'isbn'; check that column/key exists [for Statement
> "ALTER TABLE biblioitems DROP INDEX isbn"] at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13734.
> [Fri Feb 3 22:08:34 2017] updatedatabase.pl: DBD::mysql::db do
> failed: Can't DROP 'issn'; check that column/key exists [for Statement
> "ALTER TABLE biblioitems DROP INDEX issn"] at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13735.
>
> I followed the wiki and Kyle's additions to set up plugins.
>
> I tried to install my DonorApp plugin.  It put the plugin in the
> proper place but no plugins showed up on the Tools Plugins page. I
> tried ByWater's kitchen-sink-v1.kpz with the same result.
>
>
> On 01/29/2016 02:30 PM, Kyle Hall wrote:
>> Glad to help!
>>
>> Kyle
>>
>> http://www.kylehall.info
>> ByWater Solutions ( http://bywatersolutions.com )
>> Meadville Public Library ( http://www.meadvillelibrary.org )
>> Crawford County Federated Library System ( http://www.ccfls.org )
>> Mill Run Technology Solutions ( http://millruntech.com )
>>
>> On Fri, Jan 29, 2016 at 1:14 PM, Bortel, Gary 
>> wrote:
>>
>>> Perfect, Kyle!
>>>
>>> Thanks for adding the updates to the instructions at
>>> https://github.com/bywatersolutions/koha-plugin-coverflow
>>>
>>>
>>> gcb
>>> __
>>>
>>> From: Kyle Hall [mailto:kyle.m.h...@gmail.com]
>>> Sent: Friday, January 29, 2016 3:17 AM
>>> To: Bortel, Gary 
>>> Cc: koha@lists.katipo.co.nz
>>> Subject: Re: [Koha] Koha Plugin System
>>>
>>> Add this as well:
>>>
>>> 
>>>Options Indexes FollowSymLinks
>>>AllowOverride None
>>>Require all granted
>>> 
>>>
>>> http://www.kylehall.info
>>> ByWater Solutions ( http://bywatersolutions.com )
>>> Meadville Public Library ( http://www.meadvillelibrary.org )
>>> Crawford County Federated Library System ( http://www.ccfls.org )
>>> Mill Run Technology Solutions ( http://millruntech.com )
>>>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] z39.50 protocol

[Liz Rea]

This sounds to me like you have specified the MARC flavour for the 
zTarget incorrectly, perhaps it is set to UNIMARC instead of MARC21, or 
vice versa?


Cheers
Liz

On 24/02/17 07:59, Michael Kuhn wrote:

Hi Luis


Hi, we are having the same problem and we couldn't fix it.
Why the problem, if everything was running ok? We do not know.
What we did was: reinstall everything from zero.
But know we are having the same problem again.


That mail was directed to you. But you didn't tell what is the exact 
problem... That's why I asked:


1. What exactly did you enter in menu "Koha administration > 
Z39.50/SRU servers > New Z39.50 server" ?


2. Have you been able to connect to the entered Z39.50 server using 
YAZ client and find some item there?


If you can't connect to the Z39.50 server reinstalling everything from 
zero won't help, of course.


Best wishes: Michael




On Tue, Feb 21, 2017 at 11:53 AM, Michael Kuhn mailto:m...@adminkuhn.ch>> wrote:

Hi Luis

> We are trying to use the z39.50 protocol, all servers are defined,
> but when we do a search of any book, only say:
>   record No. xxx
>
> Not result.
>
> Any help?

What exactly did you enter in menu "Koha administration > Z39.50/SRU
servers > New Z39.50 server" ?

Have you been able to connect to the entered Z39.50 server using YAZ
client and find some item there?

Best wishes: Michael

--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. 
Fachausweis

Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch
 · W www.adminkuhn.ch 


___
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] SQL query to enable all patrons messaging preferences

[Liz Rea]

Hi Vimal,

There is a script provided in Koha to do this, on the packages it will
be at /usr/share/koha/bin/maintenance/borrowers-force-messaging-defaults

To use it, set the defaults for each category within the Patron
categories editor in the Koha administration, then use this script to
apply those defaults to all borrowers. Be aware that if you have
borrowers that have personally set these settings already, using the
tool to force defaults will override their preferences. This can lead to
angry borrowers.

I hope this helps,

Cheers,
Liz Rea

Catalyst IT


On 01/03/17 08:28, Vimal Kumar V. wrote:
> Dear Friends,
> I would like to enable all SMS and Email messaging preferences (Check-in,
> check-out etc) of all patrons.
>
> Kindly help me to create an SQL query to do the process.
> Regards,

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Exporting batchs in card creator

[Liz Rea]

Hi Tony,

In your batch, do you have titles that have macrons or other special
characters in them? In older versions of Koha I recall there might have
been a problem with special characters in the label creator.

If you do have titles with special characters, removing them from the
batch might solve the immediate problem of the batch not printing. You
might have to do the labels with special characters manually.

Cheers,
Liz

On 27/02/17 08:58, Tony Morton wrote:
> Hi there, I am trying to export a classroom "batch", however when I go to 
> export it, it will not provide me with a document to print.
> I have deleted this and started all over again, and its still the same 
> problem.  I have had no troubles with the other 3 classes "batches".  Is this 
> common, or am I doing something wrong?
> I'm going under tools, patron card creator, manage batches - then I choose 
> batch I want to export.
> Please advise.
> Thanks JO
>
>
>
> Ngā mihi - Kind regards
> Tony
>
> Tony Morton Dip ILS | Senior Librarian
> Waimate District Library
> Waimate District Council | 125 Queen Street | PO Box 122 | Waimate 7960 | New 
> Zealand
> •: +64 3 689  | DDI: +64 3 689 0071 | Ê: +64 3 689 8075 | Mobile: +64 
> 0210740867
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

[Liz Rea]

Hi,

In the Koha interface, you can go to Circulation -> Holds awaiting
pickup and have a look at the "Hold(s) over" tab. This should show you
the information you are wanting.

Cheers,
Liz Rea

Catalyst IT

On 01/03/17 23:16, vanda koha wrote:
> Hi everybody,
>
> I would like to run a report that would show me all the users, their e-mail
> adresses, titles and barcodes of items whose holds  have been waiting for
> pickup longer than the ReservesMaxPickupDelay number of days (in our case 7
> days). Can anyone please help me with the SQL Report? It would be great if
> the report showed the number of days or the hold expiration date.
>
> Many thanks,
>
> Vanda
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Koha 16.05 - Changing Material Type Values with JQuery?

[Liz Rea]

Hi Craig,

try something like:

$('.results_material_type').html($('.results_material_type').html().replace('Music',
'Sound Recording'));

It's not the prettiest thing, but I think it will work.

Cheers,
Liz
On 11/03/17 07:45, Craig Butosi wrote:
> Hi all,
>
> Koha 16.05 on Ubuntu 14.04 (package install).
>
> Has anyone successfully changed the Material Type field values (set by 
> LDR/06) found in the XSLT templates using JQuery? I'd rather not edit 
> templates directly.
>
> I am trying to change the default value "Music" for bib records that are set 
> to LDR/06 - j - Musical Sound Recording to read "Sound Recordings" instead. 
> I.e.,:
>
> $(".results_material_type:contains('Music')").text("Sound recording");
>
> At the risk of stating the obvious, I am, of course, placing this script in 
> OPACUSERJS.
>
> Would a kind soul have any suggestions? Unsure where I'm going wrong here. 
> Apologies if this is too off-topic.
>
> Many thanks,
>
> Craig Butosi, MA, MLIS, B Mus (Hons.)
> LIBRARY SERVICES MANAGER
> the royal conservatory
> TELUS Centre for Performance and Learning
> 273 Bloor Street West
> Toronto, ON M5S 1W2
> 416.408.2824 x338
> www.rcmusic.ca<http://www.rcmusic.ca/>
>
>
>
> Note: This email message and any attachments are intended only for the use of 
> the individual to which it is addressed, and may contain information that is 
> privileged, confidential and exempt from disclosure under applicable law. If 
> the recipient of this email is not the intended recipient (or the employee or 
> agent responsible for delivering the email to the intended recipient), you 
> are hereby notified that any review, dissemination, distribution or copying 
> or other use of this message is strictly prohibited. If you have received 
> this communication in error, please notify the sender immediately by return 
> email and delete this message and attachments from your system, thank you.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] How disable sending email

[Liz Rea]

If you installed with packages, you can run

sudo koha-email-disable instancename

where instancename is the name of your instance. This will disable all
emails, including things like hold notices and all of the enhanced notices.

Cheers,
Liz


On 06/04/17 06:09, Eric Bégin wrote:
> Tim,
>
> Meanwhile, you can comment out the process_message_queue.pl script
> from your cronjob.
>
> Eric
>
> On 2017-04-05 14:01, Jonathan Druart wrote:
>> Hi Tim,
>>
>> This is certainly dues to bug 15854.
>> It has been fixed in all stable releases.
>>
>> Regards,
>> Jonathan
>>
>> On Wed, 5 Apr 2017 at 14:37 Tim Koop  wrote:
>>
>>> Our Koha is sending duplicated emails for checkin notices.
>>>
>>> Is there an easy way to disable this for everybody until we can upgrade
>>> Koha to get it fixed?
>>>
>>> Thanks.
>>>
>>>
>>> Tim Koop
>>> ,
>>> t...@mysouthland.com<mailto:t...@mysouthland.com>
>>> ___
>>> 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

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

Re: [Koha] Slow Koha OPAC login process

[Liz Rea]

Hi,

If you are running plack, you will want to be looking in the
plack-error.log.

Cheers,
Liz

On 10/05/17 05:57, Michael Kuhn wrote:
> Hi
>
> We're running a productive host with Debian GNU/Linux 8 and Koha
> 16.11.04.
>
> One month ago I already described the case that on this host the Koha
> OPAC login process is often very slow. At such occasions the following
> process can be seen with "top", taking 99% of the CPU resources:
>
> phsh-ko+ 59422 56031 11 16:30 ? 00:00:35
> /usr/share/koha/opac/cgi-bin/opac/opac-user.pl
>
> Nothing is written to the file "opac-error.log".
>
> I had already sent the output of strace in my e-mail from 18 April
> 2017 18:09 but this didn't help no further. See
> https://lists.katipo.co.nz/public/koha/2017-April/047804.html
>
> With my poor Perl knowledge I have now measured the execution time of
> the various parts of script "opac-user.pl". As I found out everything
> is always very fast (using less than 1 second execution time) except
> the very last function in this script which looks as follows:
>
> output_with_http_headers $cgi, $cookie, $template->output, $content_type;
>
> Usually this function takes around 2 seconds to complete, but in the
> case of the slow login process it takes around 32 seconds which makes
> me think there must be some kind of timeout (30 seconds).
>
> I tried to find out more but I am stuck in file
> "/usr/share/koha/lib/C4/Output.pm" where function
> "output_html_with_http_headers" makes use of another function called
> "output_with_http_headers".
>
> Can anyone please give me a hint how I could dig deeper to maybe find
> out why the script "opac-user.pl" sometimes takes so long to complete
> its task?
>
> Best wishes: Michael

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

Re: [Koha] Koha circ & fine rules based on CCODE instead of item type

[Liz Rea]

You can add a tab to the search page to limit by collection code as well
as by itype, and change the order of them so that say, ccode comes
first. It's in the system preferences.

I don't know if that knowledge helps you really, but thought I'd point
it out.

Cheers,

Liz

On 31/05/17 10:01, Christopher Davis wrote:
> Dear Colleagues,
>
> I thought that I remember someone stating that Koha's circ and fine
> rules can be configured using collection codes instead of item types.
> Have any of you heard that too? My institution wants to circulate new
> videos for one week instead of three, but if we configure the circ and
> fine rules using item types, then a patron would not be able to view
> all of the DVDs by clicking the "DVD" item type search limiter unless
> they also thought to click the "New DVD" item type limiter. It make
> more sense to me if the item type reflects the physical manifestation
> of the item instead of how an item circulates. I hope that example
> made sense.
>
> Thank you,
>
> Christopher Davis, MLS
> Systems & E-Services Librarian
> Uintah County Library
> cgda...@uintah.utah.gov
> (435) 789-0091 ext.261
> uintahlibrary.org
> basinlibraries.org
> facebook.com/uintahcountylibrary
> instagram.com/uintahcountylibrary
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

Re: [Koha] Wiping all partial or full Koha isntallation(s) and installing stable under Mint

[Liz Rea]

ache-shared-opac.conf
>>>>>>>>
>>>>>>>>ServerName opac
>>>>>>>>SetEnv KOHA_CONF "/etc/koha/sites/library/koha-conf.xml"
>>>>>>>>AssignUserID library-koha library-koha
>>>>>>>>
>>>>>>>>ErrorLog/var/log/koha/library/opac-error.log
>>>>>>>> #  TransferLog /var/log/koha/library/opac-access.log
>>>>>>>> #  RewriteLog  /var/log/koha/library/opac-rewrite.log
>>>>>>>> 
>>>>>>>>
>>>>>>>> # Intranet
>>>>>>>> Listen 7028
>>>>>>>> 
>>>>>>>>   = 2.4>
>>>>>>>>Define instance "library"
>>>>>>>>   
>>>>>>>>Include /etc/koha/apache-shared.conf
>>>>>>>> #  Include /etc/koha/apache-shared-disable.conf
>>>>>>>> #  Include /etc/koha/apache-shared-intranet-plack.conf
>>>>>>>>Include /etc/koha/apache-shared-intranet.conf
>>>>>>>>
>>>>>>>>ServerName intranet
>>>>>>>>SetEnv KOHA_CONF "/etc/koha/sites/library/koha-conf.xml"
>>>>>>>>AssignUserID library-koha library-koha
>>>>>>>>
>>>>>>>>ErrorLog/var/log/koha/library/intranet-error.log
>>>>>>>> #  TransferLog /var/log/koha/library/intranet-access.log
>>>>>>>> #  RewriteLog  /var/log/koha/library/intranet-rewrite.log
>>>>>>>> 
>>>>>>>> ~
>>>>>>>>
>>>>>>>>
>>>>>>>> I had earlier tried to access opac:7027 and got the reported
>>> error.
>>>>> Now
>>>>>>> I
>>>>>>>> am trying to access intranet:7028 and I can't tell a difference.
>>>>>>>>
>>>>>>>> Do I need to be doing more if I reassign port numbers?
>>>>>>>>
>>>>>>>>
>>>>>>>> Thanks,
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

Re: [Koha] After Upgrade no biblio_metadata and mo marcxml

[Liz Rea]

Hi,

Koha, by default, runs backups of the database every night and keeps 2
copies in /var/spool/koha/ * gevos (gelinger...@yandex.com) wrote:
>> Overyesterday We have updated ubuntu server and the koha was updated
>> too.
>> Apparently because of the mysql 5.7 the script somehow failed and we
>> have
>> landed to a point where only from 30.000 books only 2 books landed to
>> the
>> book_metadata.  and we don't have  now the original column marcxml in
>> biblioitems  :(
>
> All you can do is restore from your backup I am afraid
>
> Chris
>>
>>
>>
>> -- 
>> View this message in context:
>> http://koha.1045719.n5.nabble.com/After-Upgrade-no-biblio-metadata-and-mo-marcxml-tp5941726.html
>> Sent from the Koha-general mailing list archive at Nabble.com.
>> ___
>> 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

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7



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] JSPrint & ff57

[Liz Rea]

Are you saying that doing something like the following:

 * Type *about:config*, in the address bar of Firefox. Click “I’ll be
   careful, I promise!” on the warning message.
 * Type, *print.alway**s* in Filter.
 * Look for *print.always_print_silent*.
 * Double-click the value to change it to false.

no longer enables silent printing?

Cheers,
Liz


On 17/11/17 10:37, Mike D. wrote:

Hello Koha Community,
how we'll solve printing from Koha in new FF? Mozilla close debate about
silent printing https://bugzilla.mozilla.org/show_bug.cgi?id=1385827
Its time to move to other browser? Which solution for printing do you
prefer  now?

Thank you

Mike
___
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] Allowing patrons to set their passwords during self-registration

[Liz Rea]

Hi Arturo,

While I haven't tested your scenario precisely, it's possible that the
reason that you are having problems here is that we don't want to set a
password before the account has been confirmed via email. A possible
shortcoming of the feature is that it doesn't take this into account
(but haven't tested it so don't take that as absolute truth).

Regarding the emails, you can see the registration emails and links by
putting this report into your saved sql reports:

select to_address, content, time_queued from message_queue where
date(time_queued) = CURDATE();

Then copy/paste the link from the content into your browser.

The sandboxes don't send mail for a very good reason, to keep spammers
from using them for evil.

Good luck, happy testing,

Liz

Catalyst IT

ps with apologies to Arturo, I didn't send this to the list and I should
have, so sending it again.

On 20/12/17 07:12, Arturo Longoria wrote:
> No solution yet. I have a suspicion that the problem I'm seeing is because 
> our library has the  PatronSelfRegistrationVerifyByEmail set to "Require" 
> rather than "Don't require."
>
> I set up sandbox 6 from BibLibre to test this theory out with master, and if 
> I set the preference to "Don't require," it will allow me to set my own 
> password during self-registration without issue after I configure it to 
> require a password during self-registration. The account is created 
> successfully and with the password I indicated.
>
> I then wanted to test it out with "Require," but I'm experiencing an issue 
> with the sandbox not sending out any e-mails. I've added an e-mail address to 
> the KohaAdminEmailAddress per the instructions in the wiki, but no luck -- 
> e-mails are not being sent at all, so I'm not able to test whether it will 
> allow me to keep the password I entered in the form once I verify my e-mail.
>
> Other than entering a valid e-mail in KohaAdminEmailAddress, is there 
> anything else I would need to do in the sandbox to have Koha send e-mails? 
> I'd like to make sure this is a bug before entering it to Bugzilla.
>
> Arturo
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Christopher 
> Davis
> Sent: Tuesday, December 19, 2017 12:00
> To: Katrin Fischer 
> Cc: Koha 
> Subject: Re: [Koha] Allowing patrons to set their passwords during 
> self-registration
>
> ​Arturo,
>
> I would also be interested in the status of this feature.​
>
> Thank you,
>
> Christopher Davis
> Systems & E-Services Librarian
> Uintah County Library
> cgda...@uintah.utah.gov
> (435) 789-0091 <14357890091> ext.261
> uintahlibrary.org
> basinlibraries.org
> facebook.com/uintahcountylibrary
> instagram.com/uintahcountylibrary
>
>
> On Mon, Dec 18, 2017 at 3:12 PM, Katrin Fischer 
> wrote:
>
>> Hi Arturo,
>>
>> have you been able to solve this? It should work with the 
>> configuration you described. If it's still an issue, please consider 
>> filing a bug report on http://bugs.koha-community.org
>>
>> Katrin
>>
>>
>> On 29.11.2017 15:18, Arturo Longoria wrote:
>>
>>> What I do is I remove "password" from the 
>>> PatronSelfRegistrationBorrowerUnwantedField
>>> preference and add "password" to the PatronSelfRegistra
>>>
>> ___
>> 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

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 150 Willis Street, Wellington.
P.O Box 11053, Manners Street, Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7


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

Re: [Koha] Koha 17.11.01 released

[Liz Rea]

Hi Bruce,

If you are really on Debian Squeeze (6.0), that's super old Debian and
Koha 17.11 won't work with that - as you noticed some of the
dependencies aren't there for that old a version of Debian.

This upgrade will be a slightly bigger project for you, as you'll need
to upgrade your OS before you can upgrade Koha. You should probably do
that anyway, sooner rather than later. Debian is now up to version 9,
code name Stretch.

Cheers,
Liz Rea

Catalyst IT


On 05/01/18 05:35, Bruce A. Metcalf wrote:
> On 01/03/2018 12:25 PM, Jonathan Druart wrote:
>
>> The Koha community is proud to announce the release of Koha  >
>> 17.11.01. Packages are also available.
>
> When I attempt to upgrade using apt-get, the system proposes to remove
> koha-common, but not to replace or upgrade it. This is not how
> previous upgrades have been done. Is this correct?
>
> Koha 17.05.05 installed via packages under Debian Squeeze.
>
> Regards,
> / Bruce /
> Bruce A. Metcalf, FAS
> Augustan Society Library
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

Re: [Koha] Upgrade problem Debian Packages

[Liz Rea]

On 15/01/18 11:55, clint.deckard wrote:
> Following an upgrade form 16.05 to 17.11 using the packages (and
> koha-restore) on Debian Jessie I get the following error when trying
> to access the staff or opac interface;
> "DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
> Access denied for user 'koha_instance'@'localhost' (using password:
> YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1490. at
> /usr/share/koha/lib/Koha/Database.pm line 100"
>
> I did notice the error during koha-restore 'DROP USER koha_instance
> failed' (approx).
>
> I'd appreciate some help.
>
> Clint.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Clint,

Did the instance koha_instance exist before you tried to restore the
database? i.e. did you koha-create instance before or after you restored
the database?

Is the instance name the same between your dumped database and the new
instance? If not, they probably should be. If you can't do that for some
reason, you'll need to unzip and edit the database dump to include the
new db name, it'll look something like:

--
-- Current Database: `koha_instance`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `koha_instance` /*!40100
DEFAULT CHARACTER SET latin1 */;

USE `koha_instance`;

if "instance" there doesn't match the name of your new db/instance,
you'll need to edit the dump to change it to match up, if that makes sense.

I'm making a grand assumption that you know that most Koha instances
aren't named instance, they can be named whatever you want and that
there's nothing magic about "instance" as a name when you've done
koha-create, or koha_instance as the database name. All that needs to
happen is that the koha-create  and koha_ should
match up. Then everything should work. And that the  should
exist before you try to import the database.

If koha-restore doesn't work after you've unzipped and edited the dump
file, you can do (I'm assuming you'll have only one dump file in the
current directory - if you have more than one specify the full filename!)

cat instance-*.sql | sudo koha-mysql instance

and that will import the edited database into the instance's database.

Cheers,
Liz





-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7


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

Re: [Koha] Text on issue reciepts

[Liz Rea]

Another way to do this is to escape the intranetuserjs preference and add some 
styling to the receipts in there, a la (this is what goes into your 
intranetuserjs preference box):

[begin example]
 



[[the css you want to modify, properly formatted]]

Re: [Koha] Text on issue reciepts

[Liz Rea]

On Mar 30, 2011, at 3:56 PM, Liz Rea wrote:

> Another way to do this is to escape the intranetuserjs preference and add 
> some styling to the receipts in there, a la (this is what goes into your 
> intranetuserjs preference box):
> 
> [begin example]
> 
> 
> 
> 
> [[the css you want to modify, properly formatted]]
> 
> 
> 
> 

Re: [Koha] Problem circulation records

[Liz Rea]

Betsy,
Which version of Koha are you using?

Liz Rea
NEKLS

On Apr 1, 2011, at 2:27 PM, Kelly, Betsy wrote:

> Why does Koha allow one to delete an item record that is in use!? It should 
> be simple enough to check it's status before permitting the record to be 
> deleted. It does that with patron records, why not item records?
> 
> Betsy Kelly
> Becker Medical Library
> Washington University in St Louis
> 
> 
> Message: 5
> Date: Fri, 1 Apr 2011 15:14:18 +1300
> From: Chris Cormack 
> Subject: Re: [Koha] Problem circulation records
> To: Sharon Jackson 
> Cc: koha@lists.katipo.co.nz
> Message-ID:
>
> Content-Type: text/plain; charset=UTF-8
> 
> 2011/4/1 Sharon Jackson :
>> Hi,
>> Can anyone help me please? ? I have a problem with some of my circulation
>> records.
>> The patron checkout session shows that an item is checked out to a patron
>> but there are no item details, just a due date, which I can't get rid of.
>> The (non-existent)? item can't be checked in.? Can anyone suggest how to
>> remove these?
>> 
> Hi Sharon
> 
> I have seen this happen before when an item has been deleted, while it
> was still on issue.
> I don't know of a way in Koha to get these off the record. The easiest
> way is to do it in the database.
> 
> Chris
> 
> The materials in this message are private and may contain Protected 
> Healthcare Information or other information of a sensitive nature. If you are 
> not the intended recipient, be advised that any unauthorized use, disclosure, 
> copying or the taking of any action in reliance on the contents of this 
> information is strictly prohibited. If you have received this email in error, 
> please immediately notify the sender via telephone or return mail.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

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

Re: [Koha] Problem circulation records

[Liz Rea]

Whoa, that's a pretty big bug and I don't see anything like it in bugzilla. 
Since you know more about it would you mind filing one for that at 
bugs.koha-community.org?

Liz Rea
NEKLS

On Apr 1, 2011, at 3:38 PM, Nora Blake wrote:

> Hi Betsy,
> 
> We've found out (the hard way) that if you reverse an imported batch of
> records using the batch import tool and some of those items are checked out,
> Koha will delete the item records anyway leaving you with blank check out
> information as you have described in your message.
> 
> So don't reverse an imported batch of records using the batch import tool if
> there's any chance some of the items from that imported file could be
> checked out.
> 
> Take care,
> 
> Nora
> 
> 
> Nora Blake
> MassCat Manager
> Massachusetts Library System
> P.O. Box 609
> South Deerfield, MA 01373-0241
> 413-665-9898 x123
> 800-282-7755
> Email: nbl...@masslibsystem.org
> AIM: noraatmls 
> 
> 
> -Original Message-
> From: koha-boun...@lists.katipo.co.nz
> [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Kelly, Betsy
> Sent: Friday, April 01, 2011 3:28 PM
> To: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Problem circulation records
> 
> Why does Koha allow one to delete an item record that is in use!? It should
> be simple enough to check it's status before permitting the record to be
> deleted. It does that with patron records, why not item records?
> 
> Betsy Kelly
> Becker Medical Library
> Washington University in St Louis
> 
> 
> Message: 5
> Date: Fri, 1 Apr 2011 15:14:18 +1300
> From: Chris Cormack 
> Subject: Re: [Koha] Problem circulation records
> To: Sharon Jackson 
> Cc: koha@lists.katipo.co.nz
> Message-ID:
>
> Content-Type: text/plain; charset=UTF-8
> 
> 2011/4/1 Sharon Jackson :
>> Hi,
>> Can anyone help me please? ? I have a problem with some of my circulation
>> records.
>> The patron checkout session shows that an item is checked out to a patron
>> but there are no item details, just a due date, which I can't get rid of.
>> The (non-existent)? item can't be checked in.? Can anyone suggest how to
>> remove these?
>> 
> Hi Sharon
> 
> I have seen this happen before when an item has been deleted, while it
> was still on issue.
> I don't know of a way in Koha to get these off the record. The easiest
> way is to do it in the database.
> 
> Chris
> 
> The materials in this message are private and may contain Protected
> Healthcare Information or other information of a sensitive nature. If you
> are not the intended recipient, be advised that any unauthorized use,
> disclosure, copying or the taking of any action in reliance on the contents
> of this information is strictly prohibited. If you have received this email
> in error, please immediately notify the sender via telephone or return mail.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

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

Re: [Koha] Problem circulation records

[Liz Rea]

I just tested this in (something very close to) current master. The issue you 
describe here is no longer an issue in koha. Which version are you running?

One caveat to that statement, as bug 3597 states, it still doesn't check for 
transit or waiting status for reserves. This screencap confirms that on issue 
items are not deleted, but that waiting and transit status items are deleted: 
http://screencast.com/t/Lh5vwCxetec

I've updated the original bug to reflect this discovery. Thanks for bringing it 
up so that we could double check it!

Liz Rea
NEKLS

On Apr 1, 2011, at 3:55 PM, Hal Bright wrote:

> Actually, Checked out items can be deleted from the drop down box that says 
> "Delete All Items". We had to stop using it for that reason.  We used it for 
> deleting our Interlibrary Loan temp records.  You should use "Edit Items" on 
> the same function and then delete from the table that appears.  It checks for 
> Checked out status.
> 
> -Original Message-
> From: koha-boun...@lists.katipo.co.nz 
> [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Owen Leonard
> Sent: Friday, April 01, 2011 3:57 PM
> To: Kelly, Betsy
> Cc: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Problem circulation records
> 
>> Why does Koha allow one to delete an item record that is in use!?
> 
> It doesn't. You can't delete an item which is checked out if you try
> to do it from the Koha interface. Koha will warn you that the item is
> checked out. However, it's always possible someone could do deletions
> directly in the database.
> 
> 
>  -- Owen
> 
> -- 
> Web Developer
> Athens County Public Libraries
> http://www.myacpl.org
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 9.0.894 / Virus Database: 271.1.1/3544 - Release Date: 04/01/11 
> 02:36:00
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

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

Re: [Koha] [Koha-devel] Koha print circulation slips

[Liz Rea]

Linda,
This configuration information may help you, it is what we do to configure our 
receipt printers to print automatically.

http://www.nexpresslibrary.org/go-live/configure-your-receipt-printers/

You can also do this with a version of portable firefox, used only for Koha, 
that has the receipt printer configurations built in. I'm happy to provide 
direction in how to get that working as well (there are a few tricks to it).

Liz Rea
NEKLS

On Apr 12, 2011, at 4:01 PM, Linda Culberson wrote:

> All,
> I am trying to find a way to print circulation slips (hold/checkout) 
> automatically.  Has anyone else tried to do this?
> Thanks!
> -- 
> Linda Culberson   lcul...@mdah.state.ms.us
> Archives and Records Services Division
> Ms. Dept. of Archives & History
> P. O. Box 571
> Jackson, MS 39205-0571
> Telephone:  601/576-6873
> Facsimile:  601/576-6824
> 
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/

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

Re: [Koha] [Koha-devel] Koha print circulation slips

[Liz Rea]

This information can now be found on the Koha wiki as well, at 
http://wiki.koha-community.org/wiki/Configure_Automatic_Receipt_Printing

:)

Liz Rea
NEKLS

On Apr 13, 2011, at 8:57 AM, Linda Culberson wrote:

> What wonderfully detailed information! Thank you!
> Linda
> 
> On 4/13/2011 8:47 AM, Liz Rea wrote:
>> Linda,
>> This configuration information may help you, it is what we do to
>> configure our receipt printers to print automatically.
>> 
>> http://www.nexpresslibrary.org/go-live/configure-your-receipt-printers/
>> 
>> <http://www.nexpresslibrary.org/go-live/configure-your-receipt-printers/>You
>> can also do this with a version of portable firefox, used only for Koha,
>> that has the receipt printer configurations built in. I'm happy to
>> provide direction in how to get that working as well (there are a few
>> tricks to it).
>> 
>> Liz Rea
>> NEKLS
>> 
>> On Apr 12, 2011, at 4:01 PM, Linda Culberson wrote:
>> 
>>> All,
>>> I am trying to find a way to print circulation slips (hold/checkout)
>>> automatically. Has anyone else tried to do this?
>>> Thanks!
>>> --
>>> Linda Culberson lcul...@mdah.state.ms.us <mailto:lcul...@mdah.state.ms.us>
>>> Archives and Records Services Division
>>> Ms. Dept. of Archives & History
>>> P. O. Box 571
>>> Jackson, MS 39205-0571
>>> Telephone: 601/576-6873
>>> Facsimile: 601/576-6824
>>> 
>>> ___
>>> Koha-devel mailing list
>>> koha-de...@lists.koha-community.org
>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>> website : http://www.koha-community.org/
>>> git : http://git.koha-community.org/
>>> bugs : http://bugs.koha-community.org/
>> 
> 
> -- 
> Linda Culberson   lcul...@mdah.state.ms.us
> Archives and Records Services Division
> Ms. Dept. of Archives & History
> P. O. Box 571
> Jackson, MS 39205-0571
> Telephone:  601/576-6873
> Facsimile:  601/576-6824
> 

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

Re: [Koha] [Koha-devel] Koha print circulation slips

[Liz Rea]

I also added one more bit of information regarding better use of Firefox as a 
Koha client:

http://wiki.koha-community.org/wiki/Using_Portable_Firefox_as_a_Koha_Client

This way you can have a version of firefox with a restricted printer, and a 
version that can print to any printer.

Liz Rea
NEKLS

On Apr 13, 2011, at 8:57 AM, Linda Culberson wrote:

> What wonderfully detailed information! Thank you!
> Linda
> 
> On 4/13/2011 8:47 AM, Liz Rea wrote:
>> Linda,
>> This configuration information may help you, it is what we do to
>> configure our receipt printers to print automatically.
>> 
>> http://www.nexpresslibrary.org/go-live/configure-your-receipt-printers/
>> 
>> <http://www.nexpresslibrary.org/go-live/configure-your-receipt-printers/>You
>> can also do this with a version of portable firefox, used only for Koha,
>> that has the receipt printer configurations built in. I'm happy to
>> provide direction in how to get that working as well (there are a few
>> tricks to it).
>> 
>> Liz Rea
>> NEKLS
>> 
>> On Apr 12, 2011, at 4:01 PM, Linda Culberson wrote:
>> 
>>> All,
>>> I am trying to find a way to print circulation slips (hold/checkout)
>>> automatically. Has anyone else tried to do this?
>>> Thanks!
>>> --
>>> Linda Culberson lcul...@mdah.state.ms.us <mailto:lcul...@mdah.state.ms.us>
>>> Archives and Records Services Division
>>> Ms. Dept. of Archives & History
>>> P. O. Box 571
>>> Jackson, MS 39205-0571
>>> Telephone: 601/576-6873
>>> Facsimile: 601/576-6824
>>> 
>>> ___
>>> Koha-devel mailing list
>>> koha-de...@lists.koha-community.org
>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>> website : http://www.koha-community.org/
>>> git : http://git.koha-community.org/
>>> bugs : http://bugs.koha-community.org/
>> 
> 
> -- 
> Linda Culberson   lcul...@mdah.state.ms.us
> Archives and Records Services Division
> Ms. Dept. of Archives & History
> P. O. Box 571
> Jackson, MS 39205-0571
> Telephone:  601/576-6873
> Facsimile:  601/576-6824
> 

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

Re: [Koha] [Koha-devel] Koha print circulation slips

[Liz Rea]

Yea, we tried that and it was much too clunky for normal usage: users wanted to 
run them at the same time side by side.

Liz Rea
NEKLS
On Apr 13, 2011, at 5:40 PM, Robin Sheat wrote:

> Liz Rea schreef op wo 13-04-2011 om 10:21 [-0500]:
>> This way you can have a version of firefox with a restricted printer,
>> and a version that can print to any printer.
> 
> You can set up Firefox to have multiple profiles, each with a different
> independent configuration. That sounds easier to maintain than multiple
> copies of portable firefox.
> 
> Running it as 'firefox -ProfileManager' will bring up the window that
> lets you configure this (there's possibly a way to activate it from
> within the GUI, but I'm not sure.)
> 
> -- 
> Robin Sheat
> Catalyst IT Ltd.
> ✆ +64 4 803 2204
> GPG: 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D

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

Re: [Koha] Help with report, please!

[Liz Rea]

> I found Nicole's report in the SQL library for "Patrons with fines".
> 
> I modified it to allow our libraries to choose their "branch".
> 
> But it doesn't seem to run.
> 
> Can someone show me where the problem is, please?
> 
> Kathy
> ---
> 
> SELECT
>   borrowers.cardnumber,
>   borrowers.surname,
>   borrowers.firstname,
>   FORMAT(SUM(accountlines.amountoutstanding),2) AS due
> FROM
>   borrowers
> LEFT JOIN
>   accountlines
> ON
>   (borrowers.borrowernumber=accountlines.borrowernumber)
> WHERE
>   accountlines.amountoutstanding > 0 AND borrowers.branchcode='__BRANCHCODE__'
> GROUP BY borrowers.cardnumber
> ORDER BY borrowers.surname ASC
> Kathleen D. Rippel
> Dept. Head/Consultant--Resource Sharing and Access ;
> Pathfinder Central (Manager)
> Central Kansas Library System
> 1409 Williams
> Great Bend, KS 67530
> 
> (620-792-4865) phone
> (800-362-2642) toll-free, KS
> (620-792-5495) fax
> 
> k...@ckls.org
> 
> I'm currently reading: This fatal writ, by Sara Woods.
> I'm currently listening to: The passage, by Justin Cronin.  
> 
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

In 3.2 the parameters are defined like this:

<>

So instead of: '__BRANCHCODE__'

Use the <> and it should work. :)

The complete how-to is in the manual: 
http://koha-community.org/documentation/3-2-manual/?ch=x15127#runtimefaq

Liz Rea
NEKLS



SELECT
  borrowers.cardnumber,
  borrowers.surname,
  borrowers.firstname,
  FORMAT(SUM(accountlines.amountoutstanding),2) AS due
FROM
  borrowers
LEFT JOIN
  accountlines
ON
  (borrowers.borrowernumber=accountlines.borrowernumber)
WHERE
  accountlines.amountoutstanding > 0 AND borrowers.branchcode=<>
GROUP BY borrowers.cardnumber
ORDER BY borrowers.surname ASC

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

Re: [Koha] Issues with superlibrarian

[Liz Rea]

Zachary,
Probably what you want to do is create another patron/staff user, and give that 
user Superlibrarian privileges. You can then assign a "home library" to that 
user, log in as that user, and the dropdowns will be populated correctly.

I'm making an assumption here: that you are logging in as the koha user that 
you use to update your database (go through the web installer). That user is 
supposed to be used ONLY for that function, and not for everyday cataloging 
functions.

Any account can be given superlibrarian privileges, and any other account 
besides the original superlibrarian can be assigned a home branch. 

I hope this helps, please let us know if you change your user and you're still 
having trouble.

Liz Rea
NEKLS

On Apr 20, 2011, at 9:11 AM, Zachary Spalding wrote:

> I am currently using Koha 3.2.6 and have noticed some issues with a 
> super librarian that I didn't see to have before.
> 
> I have a user with the superlibrian permission assigned and about 15 
> independent catalogs in Koha.  After the upgrade to 3.2.6 this person 
> now is missing access to the full drop down list of locations when 
> adding an item.  They now have to set a home branch to access the 
> location they want to assign the item too.
> 
> Also when they go to delete an item they get a message that "The items 
> do not belong to your branch".  They have to set their home location to 
> that branch or change the item to the branch they currently have defied 
> as there home.
> 
> 
> Does anyone have any suggestions of what files I could edit to give the 
> superlibrian more access?
> 
> 
> -- 
> Zachary Spalding
> Systems Manager
> Southeastern NY Library Resources Council
> 21 S. Elting Corners Rd
> Highland, NY 12528
> 
> Phone: 845-883-9065x13
> Fax: 845-883-9483
> Email: spald...@senylrc.org
> 
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

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

Re: [Koha] Problem Setting the Renewal Field on Item Types

[Liz Rea]

I believe a recent change to Koha moved the renewals out of the item type 
definition, and into the circulation rules. The rules for renewals by item type 
are now located in the circulation rules (where they properly belong, imo) and 
can be edited through that interface.

This tripped us up on a recent upgrade as well, so you're not alone. :)

You didn't say which version you were running, so I can't be totally sure about 
this. If this seems wrong, holler back and we'll try to troubleshoot more.

Liz Rea
NEKLS

On Apr 20, 2011, at 8:49 AM, Kyle Noakes wrote:

> Hello,
>  
> I am unable to edit existing item types to allow them to be renewable.  I am 
> also unable to add a new item type with the "Renewals" field set.  Does 
> anyone have any ideas of why this particular field would not save, but other 
> fields in Item Types Administration would?
>  
> In the past I have had a similar situation with saving something in 
> Administration.  When it happened previously, I was able to locate the table 
> and field in Mysql and update it manually.  I am unable to find where the 
> "Renewals" field is in the database as it is not located in the itemtypes 
> table.  Any help on the location of the Renewals field would be greatly 
> appreciated.
>  
> Thank you,
>  
>  
>  
> Kyle Noakes
> Manager of Information Systems
> East Grand Rapids Public Schools
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

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

Re: [Koha] Report coming up short?

[Liz Rea]

Paul,
Try adding a LIMIT  
to the end of that report, and see if it works.

Liz Rea
NEKLS

On Apr 21, 2011, at 12:57 PM, Paul wrote:

> Would some kind librarian with more than 10,000 biblios please try running 
> the following Mysql report. I works as expected, except that the csv output 
> truncates at 10,000.  If confirmed, I will attempt to post a bug.
> 
> SELECT biblionumber,
> CONCAT(' href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',title,'')
>  
> AS Title
> FROM biblio
> ORDER BY biblionumber
> 
> Thanks,
> 
> Paul
> Tired old sys-admin 
> 
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

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

Re: [Koha] reports function

[Liz Rea]

On Apr 25, 2011, at 1:06 PM, Caitlin McGurk wrote:

> When commanding a report to run, Koha asks me to "Enter parameters for
> report Cataloged Books:", with a bar below it that says "itype:" and
> has an empty scroll bar with no choices to pick from. When I click
> run, nothing happens. Anyone know what this means or how to fix it?
> 
> Also, is there a way to export reports in any format other than a .csv
> or .tab? Neither of these are viewable on my machine.
> 
> Thanks!
> Caitlin McGurk
> 
> --
> Caitlin McGurk
> Librarian
> The Schulz Library
> The Center for Cartoon Studies
> mcg...@cartoonstudies.org
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

Caitlin,
Can you paste us the sql of the report you are trying to run?

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

Re: [Koha] reports function

[Liz Rea]

For the 1st, a CSV/tab delimited file is viewable in any text editor or 
spreadsheet program. I really like using Libre Office 
(http://www.libreoffice.org) for that as it's pretty smart about dealing with 
CSV and Tab delimited files. You can use MS Excel if you File -> Open the file, 
but it's not quite as slick as LO.

As for your 2nd question, I believe you have your parameter set up incorrectly. 
Try this: 

> SELECT 
> sum(items.barcode),sum(biblio.title),sum(biblio.author),sum(biblio.datecreated),
> items.barcode,biblio.title,biblio.author,biblio.datecreated FROM items
> LEFT JOIN biblioitems on
> (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio
> on (biblioitems.biblionumber=biblio.biblionumber)   WHERE
> items.itype=<> GROUP BY
> items.barcode,biblio.title,biblio.author,biblio.datecreated ORDER BY
> items.barcode asc,biblio.title asc,biblio.author
> asc,biblio.datecreated asc

You were missing an 's' on your itemtypes parameter declaration. :)

Liz Rea
NEKLS

On Apr 25, 2011, at 1:37 PM, Caitlin McGurk wrote:

> This is the SQL I'm trying to run and export in something other than
> .tab or .csv:
> SELECT  
> borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.email,
> FROM borrowers   WHERE borrowers.branchcode='H25C'
> 
> This is the SQL I'd like to run for cataloged books:
> SELECT 
> sum(items.barcode),sum(biblio.title),sum(biblio.author),sum(biblio.datecreated),
> items.barcode,biblio.title,biblio.author,biblio.datecreated FROM items
> LEFT JOIN biblioitems on
> (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio
> on (biblioitems.biblionumber=biblio.biblionumber)   WHERE
> items.itype=<> GROUP BY
> items.barcode,biblio.title,biblio.author,biblio.datecreated ORDER BY
> items.barcode asc,biblio.title asc,biblio.author
> asc,biblio.datecreated asc
> 
> Regards,
> CM
> 
> On Mon, Apr 25, 2011 at 2:15 PM, Liz Rea  wrote:
>> 
>> On Apr 25, 2011, at 1:06 PM, Caitlin McGurk wrote:
>> 
>>> When commanding a report to run, Koha asks me to "Enter parameters for
>>> report Cataloged Books:", with a bar below it that says "itype:" and
>>> has an empty scroll bar with no choices to pick from. When I click
>>> run, nothing happens. Anyone know what this means or how to fix it?
>>> 
>>> Also, is there a way to export reports in any format other than a .csv
>>> or .tab? Neither of these are viewable on my machine.
>>> 
>>> Thanks!
>>> Caitlin McGurk
>>> 
>>> --
>>> Caitlin McGurk
>>> Librarian
>>> The Schulz Library
>>> The Center for Cartoon Studies
>>> mcg...@cartoonstudies.org
>>> ___
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>> 
>> Caitlin,
>> Can you paste us the sql of the report you are trying to run?
>> 
>> Liz Rea
>> NEKLS
>> 
> 
> 
> 
> -- 
> Caitlin McGurk
> Librarian
> The Schulz Library
> The Center for Cartoon Studies
> mcg...@cartoonstudies.org

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

Re: [Koha] Font changes on receipts

[Liz Rea]

Lesley,

Congratulations on your go live! I hope things are going well! :)

As to your question, yes, it is possible to use the intranetuserjs preference 
to edit the CSS for the receipts. Here's a snippet of what I have in ours:

> [begin example]
> 
>  
>  
> 
> #receipt {
> font: 15px, arial, sans-serif; /*The CSS, edit it to your whim*/
> }
> 
>  
>  
> 
> [end example]

There is a lot more  you could do to the fonts/receipts, a decent primer on 
font styling in CSS is available here: 
http://www.w3schools.com/css/css_font.asp. If you are using Koha 3.4, there is 
actually an IntranetUserCSS preference now that you can use to avoid the 
necessity of using  to start your style block in intranetuserjs. In 
that case, I believe you'd just need the bit:

> #receipt {
> font: 15px, arial, sans-serif; /*editing to your whim, of course*/
> }

to style your receipt fonts.

You'll probably want to get rid of my comments in the code, so copy/paste the 
following: 


> [begin example]
> 
> 
>  
> 
> #receipt {
> font: 15px, arial, sans-serif; 
> }
> 
>  
> 

Re: [Koha] Help with report - again!

[Liz Rea]

On Jun 2, 2011, at 8:45 AM, Peel Lisa wrote:Hello I need to create a list which will give me details of all the items at one library including the year of publication. Have tried adding publication year to the guided search but no data appears in the column. Apologies for making such a basic request but I have been asked for the report to be done urgently! Any help appreciated Regards Lisa   LISA PEEL, PGDip, MA.LibrarianCésar Ritz Colleges Switzerland1897 Le Bouveret - SwitzerlandTel: +41 24 482 82 82 Fax: +41 24 482 82 80E-mail: lisa.p...@ritz.eduhttp://www.ritz.edu - http://www.culinaryarts.ch ___Koha mailing list  http://koha-community.orgKoha@lists.katipo.co.nzhttp://lists.katipo.co.nz/mailman/listinfo/kohaSELECT items.itemcallnumber, items.barcode, biblio.author, biblio.title, biblioitems.publicationyear FROM items JOIN biblio USING (biblionumber) join biblioitems USING (biblionumber) WHERE items.homebranch='yourbranch' limit 15 ORDER BY items.itemcallnumber ascnotes: Paste this into the reports "Create from SQL" section, and run from there.you'll want to put in your branch code for 'yourbranch'Set the limit to something above the maximum number of records you expect.Hope this helps!
Liz Real...@nekls.org

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

Re: [Koha] tagging in koha

[Liz Rea]

On Jun 8, 2011, at 1:45 PM, Library InfoGeek wrote:I was wondering.. Our library is considering using tags in a more extensivemanner, but wanted to ask a few questions:1. Were these tagged suggested by staff or students?2. If they were suggested by students, how did you initiate participation?3. If they were not suggested by students, do you plan to? --View this message in context: http://koha.1045719.n5.nabble.com/tagging-in-koha-tp4423072p4470440.htmlSent from the Koha - Discuss mailing list archive at Nabble.com.___Koha mailing list  http://koha-community.orgKoha@lists.katipo.co.nzhttp://lists.katipo.co.nz/mailman/listinfo/kohaThis blog post by our own Owen Leonard may help you understand tagging a bit better: http://www.myacpl.org/koha/?p=396
Liz Real...@nekls.org

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