[Koha] Making a field into a drop down menu

John Fawcett john at voipsupport.it
Tue Oct 6 07:40:53 NZDT 2020

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.

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 at lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list