Re: [Koha] Koha SMPT Server Configuration

2021-11-26 Thread John Fawcett

On 26/11/2021 03:52, Mahesh Palamuttath wrote:

Has anybody succeeded in configuring the SMTP server in Koha from version
20.11?

I have enabled Gmail two-step verification and added SMTP details along
with enabling email in my koha instance.

I tried my best but failed.

Hope anyone can help in this regard

Thanks in advance

-- Mahesh Palamuttath
___

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


Hi Mahesh

can you check the koha log files for useful messages about the failure?

best regards

John

___

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


Re: [Koha] purchase price

2021-11-20 Thread John Fawcett

On 16/11/2021 06:37, Сычев Игорь Алексеевич wrote:

Hello!
Marc21 has a field 952g (purchase price) that can store the value of the item 
price.  What is a field in UNIMARC?

Good Luck!

Igor A. Sychev
Tomsk Polytechnic University
https://lib.tpu.ru
___

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


Hi Igor

I guess it could be 010d

best regards

John

___

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


Re: [Koha] Koha with Centos7

2021-11-20 Thread John Fawcett

On 18/11/2021 10:17, Russel G. P. Shihepo wrote:

Hi

Is Koha ILS is compatible with Centos 7, Please advice?

Russel Shihepo
Notitia Systems cc
Namibia - Africa
___

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


Hi Russel

I originally tried doing an install on Centos when I did my first 
install around a year ago. The reason was that it was for a proof of 
concept and I wanted to reuse an existing server that had spare 
processing capaicity. I am sure that with enough persistence it would 
have worked out, but it was just too much of an uphill journey compared 
to the ease of the installation process on Ubuntu where there are 
packages already available and tested. So I took the route of setting up 
a separate server where I could install Ubuntu.


My assumption is that the majority of installations are done on Ubuntu 
and it is tried and tested combination. I also assume that most 
installations are dedicated servers that run only koha so that choice of 
operating system is not a show stopper.


best regards

John



___

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


Re: [Koha] Installation issues

2021-11-20 Thread John Fawcett

Thanks Zeno
I filed a bug for this.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29538

I was unable to see how to solve it. But I did see that there is no 
marcflavour subdirectory any under


Koha/installer/data/mysql/localization/it-IT/

in 21.05 which is slightly reorganized from 20.11 which did have the 
marcflavour subdirectory


Koha/installer/data/mysql/it-IT/marcflavour/

Seems to be the same for all all languages in localization subdirectory whereas 
languages that are in

Koha/installer/data/mysql/

do have the marcflavouor subdirectory.

Also was wondering why some languages are directly under mysql and others are 
under localization.

John

On 14/11/2021 21:15, Zeno Tajoli wrote:

Hi John,

point 1 and 2 are not very important.

Point 3 is bug,a and I confirm it.

Installing 21.05 with it-IT, only MARC21 is available.
Installing 20.05 with it-IT, it is possible to install MARC21 or Unimarc.

Bye
Zeno Tajoli

___

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


[Koha] Installation issues

2021-11-13 Thread John Fawcett

Hi

it's a while since I did an installation, but I did a fresh install of 
21.05 on Ubuntu 21.10 with it-IT language.


I found the following issues.

1. During the install of koha-common I got this message "Failed to 
enable unit: Unit /run/systemd/generator.late/koha-common.service is 
transient or generated."


2. During the install of the it-IT translation I got this message 
despite memcached service is started


Connection to the memcached servers '__MEMCACHED_SERVERS__' failed. Are 
the unix socket permissions set properly? Is the host reachable?

If you ignore this warning, you will face performance issues

3. During the web installer process, marc flavour gives only MARC21 
whereas on the previous install I did I was able to choose UNIMARC.


For 1 and 2 should I open issues on the tracker?

For 3 what needs to be done to get UNIMARC support back into the it-IT 
translation, unless it's been dropped for a reason?


Thanks

John

___

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


Re: [Koha] Disable library pull down menu on staff login page

2020-12-13 Thread John Fawcett
Thanks Katrina

IndependentBranches feature already implements the suppression of the
Library pull down menu,

John

On 13/12/2020 19:10, Katrin Fischer wrote:
> Hi John,
>
> we do some changes to the templates when there is only one library in
> the system, especially in the OPAC. For example there isn't a library
> pull down on the advanced search in that case.
>
> I suggest filing your findings about the library pull downs as this
> could be a nice project for students or other people looking for easy
> bugs to fix.
>
> Katrin
>
> On 13.12.20 15:13, John Fawcett wrote:
>> On 13/12/2020 14:01, Katrin Fischer wrote:
>>> Hi John,
>>>
>>> is there a reason you want to deactivate the pull down or just to
>>> simplify the form?
>>>
>>> Besides using CSS or jQuery turning on the IndependentBranches feature
>>> might do the trick. This is to not allow staff to switch their library
>>> on login for multi-branch installations, but might work here. But
>>> CSS/jQuery is probably less likely to have other side effects.
>>>
>>> You could also file an enhancement request, that the library pull down
>>> should only be shown when there is more than one library.
>>>
>>> Hope this helps,
>>>
>>> Katrin
>>>
>>>
>> Hi Katrin
>>
>> the idea was just to simplify things for the users in a single library
>> setup. I suppose it's not just limited to login but also any place there
>> are library pull down menus with a single value. If it's not already
>> configurable it's probably a bit invasive for little return. If I get
>> some time I'll look into it.
>>
>> John
>>
>>
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


___

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


[Koha] Rebuilding .mo after change to .po

2020-12-13 Thread John Fawcett
Hi

I've temporarily made a change in .po file while waiting for the next
version of the strings to make it's way to the next official release. Is
there a script that I can lanuch locally to rebuild the Koha.mo file
from the constituent .po files so I can pick up my local changes in the
meantime?

Thanks

John

___

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


Re: [Koha] Disable library pull down menu on staff login page

2020-12-13 Thread John Fawcett
On 13/12/2020 14:01, Katrin Fischer wrote:
> Hi John,
>
> is there a reason you want to deactivate the pull down or just to
> simplify the form?
>
> Besides using CSS or jQuery turning on the IndependentBranches feature
> might do the trick. This is to not allow staff to switch their library
> on login for multi-branch installations, but might work here. But
> CSS/jQuery is probably less likely to have other side effects.
>
> You could also file an enhancement request, that the library pull down
> should only be shown when there is more than one library.
>
> Hope this helps,
>
> Katrin
>
>
Hi Katrin

the idea was just to simplify things for the users in a single library
setup. I suppose it's not just limited to login but also any place there
are library pull down menus with a single value. If it's not already
configurable it's probably a bit invasive for little return. If I get
some time I'll look into it.

John


___

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


[Koha] Disable library pull down menu on staff login page

2020-12-12 Thread John Fawcett
Hi

I didn't see any option about this. Is it possible to disable the pull
down menu for selecting the library on staff login page?

t's not needed if there is only one library.

John

___

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


Re: [Koha] Patrons report errors

2020-10-07 Thread John Fawcett
Solomon

for Koha the categories in the borrowers table need to be defined in the
categories table. In particular the report wants to read the description
of the category from the categories table to use it as a column heading.
Koha enforces this for records added or deleted through the GUI.

As a work around you can add the missing categories (if they are
correct) via the administration menu.

As a long term solution, it depends on whether you want to be able to
define new categories in the ERP or not.

If not, then the solution can be to implement an integration from Koha
to ERP to export the allowed categories and validate new borrower data
to ensure they have a valid category.  Potentially you oculd add a check
to the ERP-Koha borrower integration to ensure that borrowers without
valid categories are rejected.

If instead you want to be able to define new categories in the ERP
system, the solution could be to capture the relevant data (including
description) of the category in the ERP and pass it via a new
integration to Koha prior to importing the borrowers.

Hope that helps

John


On 07/10/2020 10:09, Solomon Mutai wrote:
> Yes, it does. From our ERP
>
> On Wed, Oct 7, 2020 at 1:46 AM John Fawcett  <mailto:j...@voipsupport.it>> wrote:
>
> On 06/10/2020 14:10, Solomon Mutai wrote:
> > Hi,
> >
> > I am new to Koha and was trying to check on patrons reports. We
> seem to
> > have no problems with catalging reports though. We have
> installed Koha
> > 20.05 on Ubuntu lts 20.04.
> >
> > The error we get is:
> > Software error:
> >
> > Can't call method "description" on an undefined value at
> > /usr/share/koha/intranet/cgi-bin/reports/borrowers_stats.pl
> <http://borrowers_stats.pl> line 323.
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
> Hi Solomon
>
> could be a data issue. Does your borrowers table contain a
> category code
> which isn't defined in the categories table?
>
> John
>

___

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


Re: [Koha] Making a field into a drop down menu

2020-10-05 Thread John Fawcett
thinking about this further the best solution might be to eliminate
field 995 r from the items menu altogether. It is probably redundant in
that 942 in the UNIMARC record already has this info. Not sure why an
item would need to be different.
John

On 05/10/2020 16:49, John Fawcett wrote:
> Hi Caroline
>
> thanks for your answer. Yes I confirm that itemtypes is present in the
> table "authorized_value_categories". This value has is_system = 1.
>
> John
>
> On 05/10/2020 15:47, Caroline Cyr-La-Rose wrote:
>> Hi John,
>>
>> I looked in my db and noticed there was an entry "itemtypes" in the
>> table "authorised_value_categories". Do you also have this? I'm not
>> sure how item types as authorised values are managed since it is not a
>> real authorised value category.
>>
>> Caroline
>>
>>
>> On 20-10-04 07 h 01, John Fawcett wrote:
>>> Hi
>>>
>>> first of all let me say I'm completely new to Koha and am taking a look
>>> at it potentially to use in a school library. So thanks to all the
>>> people that have contributed to making the software what it is today.
>>>
>>> It's been a bit of a learning curve. First off, I tried and abandoned
>>> the idea of installing on my existing Centos 8 server and took the
>>> easier path of using the packaged install on latest Ubuntu release on a
>>> new dedicated server, following this link:
>>>
>>> https://wiki.koha-community.org/wiki/Debian
>>>
>>> I did find an issue that stopped me installing mariadb due to
>>> incompatible versions, but mysql installed without problems.
>>>
>>> Needing to use Italian, I did run into some issues in the provided sql
>>> which I had to tweak in order to get the install to correctly finish
>>> without violating not null constraints (on the 307 record in the
>>> marc_subfield_structure).
>>>
>>> So now I've got an up and running installation which I'm trying out, but
>>> one thing which I cannot work out.
>>>
>>> After adding a Unimarc record, I'm on the editor for adding items.
>>> There's a field 995 r "Type of item and material" (or in my version
>>> "Tipo della copia e materiale". This is a free input text field, not a
>>> drop down menu limited to a list of predefined values.
>>>
>>> In the Italian translation this field did not have any
>>> "authorised_value" in the table marc_subfield_structure. I've modified
>>> with the value itemtypes. However for some reason this does not seem to
>>> make the field into a drop down menu in the staff GUI. So my  question
>>> to more experienced users are: after changing the "authorised_value" do
>>> I need to run a script or restart something in order to get the free
>>> text field to change into a drop down menu?
>>>
>>> Or is there a different way of doing that?
>>>
>>> thanks for any help.
>>>
>>> John
>>>
>>>
>>> ___
>>>
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


___

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


Re: [Koha] Making a field into a drop down menu

2020-10-05 Thread John Fawcett
Hi Caroline

thanks for your answer. Yes I confirm that itemtypes is present in the
table "authorized_value_categories". This value has is_system = 1.

John

On 05/10/2020 15:47, Caroline Cyr-La-Rose wrote:
> Hi John,
>
> I looked in my db and noticed there was an entry "itemtypes" in the
> table "authorised_value_categories". Do you also have this? I'm not
> sure how item types as authorised values are managed since it is not a
> real authorised value category.
>
> Caroline
>
>
> On 20-10-04 07 h 01, John Fawcett wrote:
>> Hi
>>
>> first of all let me say I'm completely new to Koha and am taking a look
>> at it potentially to use in a school library. So thanks to all the
>> people that have contributed to making the software what it is today.
>>
>> It's been a bit of a learning curve. First off, I tried and abandoned
>> the idea of installing on my existing Centos 8 server and took the
>> easier path of using the packaged install on latest Ubuntu release on a
>> new dedicated server, following this link:
>>
>> https://wiki.koha-community.org/wiki/Debian
>>
>> I did find an issue that stopped me installing mariadb due to
>> incompatible versions, but mysql installed without problems.
>>
>> Needing to use Italian, I did run into some issues in the provided sql
>> which I had to tweak in order to get the install to correctly finish
>> without violating not null constraints (on the 307 record in the
>> marc_subfield_structure).
>>
>> So now I've got an up and running installation which I'm trying out, but
>> one thing which I cannot work out.
>>
>> After adding a Unimarc record, I'm on the editor for adding items.
>> There's a field 995 r "Type of item and material" (or in my version
>> "Tipo della copia e materiale". This is a free input text field, not a
>> drop down menu limited to a list of predefined values.
>>
>> In the Italian translation this field did not have any
>> "authorised_value" in the table marc_subfield_structure. I've modified
>> with the value itemtypes. However for some reason this does not seem to
>> make the field into a drop down menu in the staff GUI. So my  question
>> to more experienced users are: after changing the "authorised_value" do
>> I need to run a script or restart something in order to get the free
>> text field to change into a drop down menu?
>>
>> Or is there a different way of doing that?
>>
>> thanks for any help.
>>
>> John
>>
>>
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>

___

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


[Koha] Making a field into a drop down menu

2020-10-04 Thread John Fawcett
Hi

first of all let me say I'm completely new to Koha and am taking a look
at it potentially to use in a school library. So thanks to all the
people that have contributed to making the software what it is today.

It's been a bit of a learning curve. First off, I tried and abandoned
the idea of installing on my existing Centos 8 server and took the
easier path of using the packaged install on latest Ubuntu release on a
new dedicated server, following this link:

https://wiki.koha-community.org/wiki/Debian

I did find an issue that stopped me installing mariadb due to
incompatible versions, but mysql installed without problems.

Needing to use Italian, I did run into some issues in the provided sql
which I had to tweak in order to get the install to correctly finish
without violating not null constraints (on the 307 record in the
marc_subfield_structure).

So now I've got an up and running installation which I'm trying out, but
one thing which I cannot work out.

After adding a Unimarc record, I'm on the editor for adding items.
There's a field 995 r "Type of item and material" (or in my version
"Tipo della copia e materiale". This is a free input text field, not a
drop down menu limited to a list of predefined values.

In the Italian translation this field did not have any
"authorised_value" in the table marc_subfield_structure. I've modified
with the value itemtypes. However for some reason this does not seem to
make the field into a drop down menu in the staff GUI. So my  question
to more experienced users are: after changing the "authorised_value" do
I need to run a script or restart something in order to get the free
text field to change into a drop down menu?

Or is there a different way of doing that?

thanks for any help.

John


___

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