[Koha] Making a field into a drop down menu

Caroline Cyr-La-Rose caroline.cyr-la-rose at inlibro.com
Tue Oct 6 02:47:04 NZDT 2020

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.


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

Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
Caroline.Cyr-La-Rose at inLibro.com <mailto:caroline.cyr-la-rose at inLibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 

More information about the Koha mailing list