While we are talking about changes to the biblio table I would like to propose a change.
Looking at the file installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql I see that the subfield 245$b is linked to the koha table bibliosubtitle.subtitle, which seems to not exist anymore. I'm sure this is left over from Koha 2.2. I remember this table from before, and so do my librarians. My librarians ask that the marc21 field 245$b be shown on the search results page. I found that by adding a column to the biblio table and linking it in the marc structure I could get the value to export to the template. This happened even though the column in the database remains empty. I can submit a patch to add a column to the biblio table to this end. I'm thinking it would be linked in marc21 to the 245$b, as I have said. In Unimarc it seems 200$e is a good candidate. I don't know Unimarc, and so I hope someone who does can contribute to this RFC a recommendation on which subfield to use there. Once I have community support I will get on the wiki for updatedatabase.pl and reserve an update number for this patch. The name of the column could be either `subtitle` or `remainderoftitle`. The `remainderoftitle` name represents the use of the column in respect to Marc21. The `subtitle` name is more historic, and is probably based on the expectation of linking this field in Unimarc to 200$e (subtitle). Looking at 2.2.9 code though I don't see bibliosubtitle.subtitle linked in the Unimarc structure. I'm leaning toward `subtitle` because it is shorter. However I'm open to suggestions here. The final detail is whether I should put together a script to go in misc which would get values from the marc to fill in the column of the database for existing records. On Sat, 2008-11-22 at 12:58 -0500, Ryan Higgins wrote: > > Late entry, I know, but I would like to get rid of the clunky extra > table, > and merge the columns that we need from biblioitems into a new biblio > table. I've listed the columns to keep on the wiki; please review and > add > any that are missing. > > http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_biblio_table > > > > -- > Ryan Higgins > > LibLime * Open-Source Solutions for Libraries > Featuring KohaZOOM ILS > 888-564-2457 x704 > _______________________________________________ > Koha-devel mailing list > Koha-devel@lists.koha.org > http://lists.koha.org/mailman/listinfo/koha-devel -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://koha-dev.washk12.org or git://koha-dev.washk12.org/koha _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
