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