Roger, from your example, it looks like the only thing you have in the 852 tag is the itemtype, in 852k. At the risk of looking stupid, may I ask if you have mapped 852k to biblioitems.itemtype? Stephen Roger Horne said:
On Thu 15 Apr, I wrote:
[snip] Clicking on the title produced a partial display of the Marc entries:
020 -INTERNATIONAL STANDARD BOOK NUMBER a International Standard Book Number 0406948291
852 -LOCATION/CALL NUMBER k Call number prefix (NR) TB
[snip] [followed by a box containing]
homebranch RH
"TB" stands for text book so the 852 line would seem to be wrong. (If I go to edit I am given a drop down box for that line with text book, law report etc.)
Further experiment shows that the error in the 852(k) line is *introduced* by the Item Type Admin page (admin/itemtypes.pl ). Yesterday I got the daemon to work at least partially and it found the biblio for the Perl Cookbook at the Library of Congress and added it. But the 852k line was still TB (ie text book). So I added another "type", BS (for brussells sprout --- not I admit something usually found in libraries) and searched for the Cookbook again. When I tried to edit it (aqui.simple/addbiblio.pl ) the 852 line contained text book and the drop down menu now included the item brussells sprout. And that expression appears in table itemtypes.
But seeing how TB gets into the display is way beyond me. A couple of tables show the Perl Cookbook:
select biblionumber,author,title from biblio; +--------------+--------------------+----------------------------------------+ | biblionumber | author | title | +--------------+--------------------+----------------------------------------+ | 1 | Gammie | Tolley Yellow Tax Handbook | | 2 | Michael Thomas | Stamp Duty Land Tax | | 3 | Longrigg Higgins | Family Breakdown and Trusts | | 4 | DuBois, Paul, | MySQL Cookbook / | | 5 | Petersen, Theo. | Web development with Apache and Perl / | | 6 | Christiansen, Tom. | Perl cookbook / | +--------------+--------------------+----------------------------------------+ 6 rows in set (0.00 sec)
mysql> select biblionumber,itemtype,isbn from biblioitems; +------------------+----------+------------+ | biblionumber | itemtype | isbn | +--------------+----------+------------+ | 1 | NULL | 0406939985 | | 2 | TB | 0521545153 | | 3 | TB | 0406948291 | | 4 | NULL | 0596001452 | | 5 | NULL | 1930110065 | | 6 | NULL | 1565922433 | +------------------+----------+------------+ 6 rows in set (0.00 sec)
The 852 line still shows as TB although the itemtype line in the table is NULL. It has somehow found its way into marc_subfield_table:
select subfieldid,bibid,tag,subfieldcode,subfieldvalue from marc_subfield__table where bibid='6'; +------------+-------+-----+--------------+------------------------+ | subfieldid | bibid | tag | subfieldcode | subfieldvalue | +------------+-------+-----+----+----------------------------------+ | 89 | 6 | 010 | a | 99176053 | | 90 | 6 | 020 | a | 1565922433 | | 91 | 6 | 035 | a | (DLC) 99176053 | | 92 | 6 | 035 | a | (OCoLC)39872119 | | 93 | 6 | 852 | k | TB | | 94 | 6 | 100 | a | Christiansen, Tom. | | 95 | 6 | 245 | a | Perl cookbook / | | 96 | 6 | 260 | c | c1998. | | 97 | 6 | 300 | a | xxxiv, 757 p. ; | | 98 | 6 | 300 | c | 24 cm. | | 99 | 6 | 650 | a | Perl (Computer program language) | | 100 | 6 | 650 | a | Perl (Computer program language) | | 101 | 6 | 090 | c | 6 | | 102 | 6 | 090 | d | 6 | | 103 | 6 | 952 | b | RH | | 104 | 6 | 952 | d | RH | | 105 | 6 | 952 | u | 5 | +------------+-------+-----+--------------+------------------------+ 17 rows in set (0.00 sec)
Have 852 and 952 got mixed up somewhere? (RH, ie Roger Horne, is what I would have expected to see in "location" on a search.)
But it turns out to be more complicated ... On a simple search the location of the Perl Cookbook shows correctly as Roger Horne (although it doesn't in a Marc search). But the location of the Mysql Cookbook doesn't show as Roger Horne in a simple search but as a blank (but shows as TB in a full search). There are very small differences in the marc_subfield_table but nothing that would appear to cause this:
+------------+-------+-----+--------------+----------------------------------------+ | subfieldid | bibid | tag | subfieldcode | subfieldvalue | +------------+-------+-----+--------------+----------------------------------------+ | 69 | 5 | 010 | a | 2002281940 | | 70 | 5 | 020 | a | 1930110065 | | 71 | 5 | 035 | a | (OCoLC)ocm49871541 | | 72 | 5 | 852 | k | TB | | 73 | 5 | 100 | a | Petersen, Theo. | | 74 | 5 | 245 | a | Web development with Apache and Perl / | | 75 | 5 | 260 | c | c2002. | | 76 | 5 | 300 | a | xviii, 410 p. : | | 77 | 5 | 300 | b | ill. ; | | 78 | 5 | 300 | c | 24 cm. | | 79 | 5 | 650 | a | Perl (Computer program language) | | 80 | 5 | 650 | a | Web site development. | | 81 | 5 | 650 | a | Open source software. | | 82 | 5 | 650 | a | Open source software. | | 83 | 5 | 090 | c | 5 | | 84 | 5 | 090 | d | 5 | | 85 | 5 | 952 | u | 3 | | 86 | 5 | 952 | b | RH | | 87 | 5 | 952 | d | RH | | 88 | 5 | 952 | u | 4 |
Roger -- Roger Horne, 11 New Square, Lincoln's Inn, London WC2A 3QB mailto:roger@number7.demon.co.uk
------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ Koha-devel mailing list Koha-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com