Summary: | Add biblio.subtitle and appropriate mappings to MARC frameworks | ||
---|---|---|---|
Product: | Koha | Reporter: | Ian Walls <koha.sekjal> |
Component: | Database | Assignee: | Ian Walls <koha.sekjal> |
Status: | RESOLVED DUPLICATE | QA Contact: | Jonathan Druart <jonathan.druart> |
Severity: | enhancement | ||
Priority: | P5 - low | CC: | liz, marjorie.barry-vila, mglavica, patrick.robitaille |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: | |||
Attachments: | Bug 7715: Add biblio.subtitle and appropriate MARC21 framework mappings |
Description
Ian Walls
2012-03-14 15:05:43 UTC
Hmmm, looks like for several of the French UNIMARC frameworks, 200$e is mapped to biblioitems.volume. I assume this was done as a workaround? Or am I missing something? At any rate, my initial patch will not include UNIMARC until I can be sure I'm not going to break things. Created attachment 8316 [details] [review] Bug 7715: Add biblio.subtitle and appropriate MARC21 framework mappings This patch adds biblio.subtitle and deletedbiblio.subtitle to the Koha DB structure, and maps the MARC21 (and NORMARC) frameworks 245$b field to this database column if it's not already mapped (or is mapped to the non-existent bibliosubtitle.subtitle field). To Test: Upgrade (on MARC21 installation) 1. In one framework, map 245$b to an existent database field 2. Run updatedatabase.pl. You should now have the biblio.subtitle field 3. Check the framework to confirm your manual mapping still holds 4. Check another framework, one where 245$b was not mapped, to see that is now is 5. Add a biblio with a subtitle; the value of the 245$b should wind up in the database New installation 1. Install a new MARC21 database 2. Add a biblio with a subtitle; the value of the 245$b should wind up in the database, in the biblio.subtitle field This patch adds the database field and frameworks only, and only for MARC21 This solves the problem we faced previously where subtitle was in biblioitems and complicated joins were required to display it. However, the advantage of the "Keywords to MARC mapping" method is that you can add information besides 245$b: 245$h, 245$n or 245$p for instance. We stretch the definition of "subtitle" so that we can get more information into the display of title into more places in the intranet. The problem with having "subtitle" field in a database is that there is no such field in MARC21 nor in UNIMARC. MARC21 has 245$b - remainder of title (subtitle, paralel title, etc.) UNIMARC has 200$e - other title information (subtitle and other information subordinate to title proper) On the other hand, from the practical point of view, it is very tempting to have separate database filed for this, because in SQL reports title is often not enough. But than, for some cases, title + subtitle is also not enough because we also have multipart items so we need title and subtitle together with number of part and title of part. Keywords to MARC mapping is much nicer solution, but it is not usable in SQL reports. But than, for SQL reports we now can use MySQL XML handling function, so this is not so big problem as before MySQL 5.1.5 So in conclusion, I vote against having subtitle field in database. If we go (back) in that direction, the name of this field should not be subtitle. What about using the "Keywords to MARC mapping" setting to determine what information is pulled into the new quasi-subtitle field? I guess that would present problems if you wanted to modify the mapping. You'd have to run some kind of rebuild script. |