- Question: What is the best way to find out if we have records with multiple 999c fields?
I need to find out if the record below is an anomaly, or if there is a bigger problem. I've reported a similar problem before, and commented on bug 6657 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6657 . I now have a record that seems to have lost its item records, acquired an item record from another record (which itself has vanished) and has a scary number of 999$c fields. To add to the confusion, the one item that is attached to the record was uploaded *before* the biblio record was created (and its parent record is gone without a trace). See record below. Some of this could be human error (merging two records that should not have been merged, or typing in the wrong number - we don't actually have barcodes). But the 999c is machine generated, and that's the worrying thing. Do you see anything strange about this record in addition to the 999c fields? How did that strange $d end up in the midst of them? Any ideas? =LDR 02138nam a22003737a 4500 =001 201211211518.nw =003 UkLoVW =005 20140319230939.0 =008 121120s1922\\\\enkg\\\g\\\\\\000\0\eng\d =040 \\$aUkLoVW$beng$cUkLoVW =099 \\$aQS 40 =100 \\$9822$aSharp, Cecil J. =245 10$aCountry dance tunes, set Xl :$bfrom The English dancing master (1650-1728) /$cArranged by Cecil J. Sharp. =260 \\$aLondon :$bNovello & Co.,$c1922. =300 \\$a26 p. :$bmusic ;$c31 cm. =500 \\$aIssued in connection with 'The country dance book, part Vl'. =600 \\$91045$aPlayford, John =650 \\$9163$aEngland =650 \\$910905$aCountry dance tunes =942 \\$2VWML$cBK$hQS 40$n0$6QS0040 =999 \\$c17304 | 18206 | 18205 | 18203 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194$d17304 | 18206 | 18205 | 18203 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 =999 \\$c18206 =999 \\$c18205 =999 \\$c18203 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 =999 \\$c18202 =999 \\$c18202 =999 \\$c18201 =999 \\$c18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 =999 \\$c18199 =999 \\$c18198 =999 \\$c18196 | 18194 | 18194 | 18194 =999 \\$c18194 | 18194 =999 \\$c18194 =952 \\$w2012-10-31$p17354$r2012-10-31$40$6AL_MACCOLL$918199$bVWML$10$oAL MACCOLL$d2010-01-01$71$2VWML$yBK$00$aVWML Hoping for a logical answer. Thanks! -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha