We have just installed 3.0 and I've not touched the Koha to MARC

Hi again, Thanks for responding. I've checked all of the frameworks and they all appear to have those two fields mapped to the same subfields. Could there be something else I've missed? Thank you for your generous assistance. Best, Marisa Wood, MLIS Member Support Specialist BCR 14394 E. Evans Ave. Aurora, CO 80014 303.751.6277/800.397.1552 -----Original Message----- From: Galen Charlton [mailto:galen.charlton@liblime.com] Sent: Wednesday, November 12, 2008 2:53 PM To: Marisa Wood Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha to MARC links issue Hi, On Wed, Nov 12, 2008 at 4:51 PM, Marisa Wood <mwood@bcr.org> wrote: links, but

when I run the Framework test I get an error for a couple of fields. The message reads: "The biblio.biblionumber and biblioitems.biblioitemnumber fields be mapped to a MARC subfield." I'm not finding this sentence very helpful... They're currently mapped to 999$c and 999$d, respectively. . Any suggestions?

This can happen if you have more than one framework and biblionumber and biblioitemnumber are not mapped in every framework. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709 skype: gmcharlt

Hi Galen, and list, On Nov 12, 2008, Marisa Wood <mwood@bcr.org> wrote:

We have just installed 3.0 and I’ve not touched the Koha to MARC links, but when I run the Framework test I get an error for a couple of fields. The message reads: “The biblio.biblionumber and biblioitems.biblioitemnumber fields be mapped to a MARC subfield.” I’m not finding this sentence very helpful… They’re currently mapped to 999$c and 999$d, respectively. . Any suggestions?

And on the same day, Galen Charlton <galen.charlton@liblime.com> replied:

This can happen if you have more than one framework and biblionumber and biblioitemnumber are not mapped in every framework.

On Nov 13, 2008, Marisa Wood <mwood@bcr.org> replied:

Thanks for responding. I've checked all of the frameworks and they all appear to have those two fields mapped to the same subfields. Could there be something else I've missed?

And finally, on the same day, Galen Charlton<galen.charlton@liblime.com> wrote:

The results of the following SQL query on your database may provide some information:

SELECT frameworkcode, tagfield, tagsubfield FROM  marc_subfield_structure WHERE kohafield in ('biblio.biblionumber', 'biblioitems.biblioitemnumber');

I'm following up to this old thread (8 months old) started by Marisa Wood, because I have the same question that she has: when doing a "MARC Bibliographic framework test", in a Koha installation (in my case, it's Koha 3.0.3), I'm getting the following error: ---------------------------------------- biblio and biblionumber The biblio.biblionumber and biblioitems.biblioitemnumber fields be mapped to a MARC subfield, ---------------------------------------- This Koha 3.0.3 installation has been previously an installation of Koha 3.0.1 that was migrated to 3.0.2 (by running "perl Makefile.PL --prev-install=/usr/share/koha/misc/koha-install-log"). I have later repeated that same procedure for upgrading to 3.0.3 The installation is done in a SLES 11 (SUSE Linux Enterprise Server) VMware Virtual Machine. I ran the SQL query suggested by Galen Charlton, and this is the resulting output (I have 3 MARC Bibliographic frameworks - the default framework, another one with code "CDFO" and a third one with code "FC"): ------------------------------------------------------------ mysql> SELECT frameworkcode, tagfield, tagsubfield FROM marc_subfield_structure WHERE kohafield in ('biblio.biblionumber', 'biblioitems.biblioitemnumber'); +---------------+----------+-------------+ | frameworkcode | tagfield | tagsubfield | +---------------+----------+-------------+ | | 001 | @ | | | 999 | 9 | | CDFO | 001 | @ | | CDFO | 999 | 9 | | FC | 001 | @ | | FC | 999 | 9 | | | 999 | a | | CDFO | 999 | a | | FC | 999 | a | +---------------+----------+-------------+ 9 rows in set (0.00 sec) ------------------------------------------------------------ So there are 9 lines / rows (3 for each framework) and that seems right to me. Should I be getting this error in the "MARC Biblibliographic framework test" even so? Cheers, Ricardo Dias Marques lists AT ricmarques DOT net Installation Guide for Installing Koha 3 on openSUSE 11 http://wiki.koha.org/doku.php?id=opensuse_11.0

Hi Galen, On Mon, Jul 13, 2009 at 13:13, Galen Charlton<galen.charlton@liblime.com> wrote:

...

mysql> SELECT frameworkcode, tagfield, tagsubfield FROM marc_subfield_structure WHERE kohafield in ('biblio.biblionumber', 'biblioitems.biblioitemnumber');

If you modify the query slightly to include the kohafield column in the output, what are the results?

Thanks for replying. Here's the output of the query, when including the kohafield column: ------------------------------------------------------------ mysql> SELECT frameworkcode, tagfield, tagsubfield, kohafield FROM -> marc_subfield_structure WHERE kohafield in ('biblio.biblionumber', -> 'biblioitems.biblioitemnumber'); +---------------+----------+-------------+------------------------------+ | frameworkcode | tagfield | tagsubfield | kohafield | +---------------+----------+-------------+------------------------------+ | | 001 | @ | biblio.biblionumber | | | 999 | 9 | biblio.biblionumber | | CDFO | 001 | @ | biblio.biblionumber | | CDFO | 999 | 9 | biblio.biblionumber | | FC | 001 | @ | biblio.biblionumber | | FC | 999 | 9 | biblio.biblionumber | | | 999 | a | biblioitems.biblioitemnumber | | CDFO | 999 | a | biblioitems.biblioitemnumber | | FC | 999 | a | biblioitems.biblioitemnumber | +---------------+----------+-------------+------------------------------+ 9 rows in set (0.00 sec) ------------------------------------------------------------ I wrote:

...

So there are 9 lines / rows (3 for each framework) and that seems right to me.

And Galen Charlton replied, saying:

There should be six - one mapping of biblionumber and one of biblioitemnumber per framework.

Hmmm..... In my case, the "item-level_itypes" System Preference is set to OFF. Does this affect the number of mappings that should exist? (This is an UNIMARC and NoZebra installation, in case that's relevant). Thanks again! Cheers, Ricardo