From 96264fc8c58f2b7088b7cf7c7a299a365cdba0f5 Mon Sep 17 00:00:00 2001 From: Salvador Zaragoza Rubio Date: Mon, 14 Mar 2011 18:45:39 +0100 Subject: [PATCH] Bug 4888 - pre-set of field indicators value Content-Type: text/plain; charset="utf-8" Preload on database of the set of field indicators value as defined by http://www.loc.gov/marc/bibliographic/ecbdhome.html. New sql files in marc21/mandatory to create and populate the indicators tables with the sets of values for the Default framework. Each framework will be able to have its own copy to allow individual modification of indicators value. When modifying the framework text exists the possibility of cloning the indicators set from an existing framework populated with indicators. Modification of the intranet administration-Marc Frameworks to clone on creation from another framework and to delete set of indicators from a framework. Management (add/modify/delete) for indicators of the fields in the Framework Structure. Modification of the intranet cataloguing addbiblio to enable a plugin to see the defined indicators value for a specific framework, and to check validity of indicators value. Two new system preferences: CheckValueIndicators for checking the value of the indicators when cataloguing a biblio record; DisplayPluginValueIndicators: to enable the plugin at addbiblio to see indicators value and to check too. --- C4/Indicators.pm | 791 ++++++++++++++++++++ admin/biblio_framework.pl | 16 + admin/marc_indicators_structure.pl | 151 ++++ admin/marctagstructure.pl | 14 + cataloguing/addbiblio.pl | 27 +- cataloguing/indicators_ajax.pl | 121 +++ cataloguing/marc21_indicators.pl | 103 +++ .../marc21/mandatory/marc21_indicators.sql | 84 ++ .../marc21/mandatory/marc21_indicators.txt | 1 + installer/data/Pg/kohastructure.sql | 58 ++ installer/data/mysql/de-DE/mandatory/sysprefs.sql | 2 + installer/data/mysql/en/mandatory/sysprefs.sql | 3 +- .../marc21/mandatory/marc21_indicators.sql | 106 +++ .../marc21/mandatory/marc21_indicators.txt | 1 + .../1-Obligatoire/unimarc_standard_systemprefs.sql | 2 + installer/data/mysql/it-IT/necessari/sysprefs.sql | 7 +- installer/data/mysql/kohastructure.sql | 71 ++ installer/data/mysql/pl-PL/mandatory/sysprefs.sql | 3 + ...m_preferences_full_optimal_for_install_only.sql | 3 + ...m_preferences_full_optimal_for_install_only.sql | 6 +- installer/data/mysql/updatedatabase.pl | 57 ++ .../intranet-tmpl/prog/en/css/staff-global.css | 14 +- koha-tmpl/intranet-tmpl/prog/en/js/indicators.js | 442 +++++++++++ .../prog/en/modules/admin/biblio_framework.tmpl | 15 +- .../modules/admin/marc_indicators_structure.tmpl | 86 +++ .../prog/en/modules/admin/marctagstructure.tmpl | 7 +- .../en/modules/admin/preferences/cataloguing.pref | 12 + .../prog/en/modules/cataloguing/addbiblio.tmpl | 99 +++- .../en/modules/cataloguing/marc21_indicators.tmpl | 165 ++++ 29 files changed, 2458 insertions(+), 9 deletions(-) create mode 100755 C4/Indicators.pm create mode 100755 admin/marc_indicators_structure.pl create mode 100755 cataloguing/indicators_ajax.pl create mode 100755 cataloguing/marc21_indicators.pl create mode 100755 installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_indicators.sql create mode 100755 installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_indicators.txt mode change 100644 => 100755 installer/data/Pg/kohastructure.sql create mode 100755 installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_indicators.sql create mode 100755 installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_indicators.txt mode change 100644 => 100755 installer/data/mysql/kohastructure.sql create mode 100755 koha-tmpl/intranet-tmpl/prog/en/js/indicators.js create mode 100755 koha-tmpl/intranet-tmpl/prog/en/modules/admin/marc_indicators_structure.tmpl mode change 100644 => 100755 koha-tmpl/intranet-tmpl/prog/en/modules/admin/marctagstructure.tmpl mode change 100644 => 100755 koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref mode change 100644 => 100755 koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbiblio.tmpl create mode 100755 koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/marc21_indicators.tmpl diff --git a/C4/Indicators.pm b/C4/Indicators.pm new file mode 100755 index 0000000..a2451e4 --- /dev/null +++ b/C4/Indicators.pm @@ -0,0 +1,791 @@ +package C4::Indicators; + +# Copyright 2010-2011 Spanish Minister of Culture +# +# This file is part of Koha. +# +# Koha is free software; you can redistribute it and/or modify it under the +# terms of the GNU General Public License as published by the Free Software +# Foundation; either version 2 of the License, or (at your option) any later +# version. +# +# Koha is distributed in the hope that it will be useful, but WITHOUT ANY +# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +# A PARTICULAR PURPOSE. See the GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License along +# with Koha; if not, write to the Free Software Foundation, Inc., +# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + +use strict; +use warnings; +use C4::Context; +use C4::Debug; + + +use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS); + +BEGIN { + $VERSION = 3.02; # set version for version checking + require Exporter; + @ISA = qw(Exporter); + @EXPORT = qw( + &GetFrameworks + &CloneIndicatorsFramework + &GetIndicatorsFramework + &DelIndicatorsFramework + &GetDataFieldMarc + &GetIndicator + &AddIndicator + &DelIndicator + &AddIndicatorValue + &DelIndicatorValue + &ModIndicatorValue + &ModIndicatorDesc + &GetValuesIndicator + &GetValuesIndicatorFrameWork + &GetLanguagesIndicators + &binarySearch + &CheckValueIndicatorsSub + ); +} + +=head1 NAME + +C4::Indicators - Indicators Module Functions + +=head1 SYNOPSIS + + use C4::Indicators; + +=head1 DESCRIPTION + +Module to manage indicators on intranet cataloguing section + +Module to manage indicators on the intranet cataloguing section +applying the rules of MARC21 according to the Library of Congress +http://www.loc.gov/marc/bibliographic/ecbdhome.html + +Functions for handling indicators on cataloguing. + + +=head1 SUBROUTINES + + + + +=head2 GetFrameworks + +Returns information about existing frameworks with indicators + +=cut + +sub GetFrameworks +{ + + my $frameworkcode = shift; + + my @frameworks; + my $dbh = C4::Context->dbh; + if ($dbh) { + eval { + my $sth = $dbh->prepare("SELECT b.* FROM biblio_framework b , marc_indicators i WHERE b.frameworkcode<>? AND b.frameworkcode=i.frameworkcode GROUP BY frameworkcode"); + $sth->execute($frameworkcode); + while ( my $iter = $sth->fetchrow_hashref ) { + push @frameworks, $iter; + } + }; + } + return ( \@frameworks ); +}#GetFrameworks + + + + +=head2 CloneIndicatorsFramework + +Clone all the indicators from one framework to another one + +return : +the new frameworkcode + +=cut + + +sub CloneIndicatorsFramework +{ + my ($frameworkcodeSource, $frameworkcodeDest) = @_; + + my $indicators = GetIndicatorsFramework($frameworkcodeSource); + my $hashRefSource; + my ($id_indicator, $id_indicator_value); + for $hashRefSource (@$indicators) { + if (GetDataFieldMarc($hashRefSource->{tagfield}, $frameworkcodeDest)) { + $id_indicator = AddIndicator($hashRefSource->{tagfield}, $frameworkcodeDest); + if ($id_indicator) { + my ($id_indicator_old, $data) = GetValuesIndicator($hashRefSource->{id_indicator}, $hashRefSource->{tagfield}, $frameworkcodeSource); + for (@$data) { + $id_indicator_value = AddIndicatorValue($id_indicator, $hashRefSource->{tagfield}, $frameworkcodeDest, $_->{ind}, $_->{ind_value}, $_->{ind_desc}, $_->{lang}); + } + } + } + } + return $frameworkcodeDest; +}#CloneIndicatorsFramework + + + +=head2 GetIndicatorsFramework + +Get all the indicators from a framework + +return : +an array of hash data + +=cut + + +sub GetIndicatorsFramework +{ + my ($frameworkcode) = @_; + + my @data; + my $dbh = C4::Context->dbh; + if ($dbh) { + eval { + my $query = qq|SELECT id_indicator, tagfield FROM marc_indicators WHERE frameworkcode=?|; + my $sth = $dbh->prepare($query); + $sth->execute($frameworkcode); + my $hashRef; + while ($hashRef = $sth->fetchrow_hashref) { + push @data, $hashRef; + } + }; + if ($@) { + $debug and warn "Error GetIndicatorsFramework $@\n"; + } + } + return \@data; +}#GetIndicatorsFramework + + + +=head2 DelIndicatorsFramework + +Delete indicators in a specific framework + +return : +the success of the operation + +=cut + + +sub DelIndicatorsFramework +{ + my ($frameworkcode) = @_; + + my $dbh = C4::Context->dbh; + if ($dbh) { + eval { + my $query = qq|DELETE FROM marc_indicators + WHERE frameworkcode=?|; + my $sth = $dbh->prepare($query); + $sth->execute($frameworkcode); + }; + if ($@) { + $debug and warn "Error DelIndicatorsFramework $@\n"; + } else { + return 1; + } + } + return 0; +}#DelIndicatorsFramework + + + +=head2 GetDataFieldMarc + +Get the data from marc_tag_structure for a field in a specific framework + +return : +the data hash for the datafield + +=cut + + +sub GetDataFieldMarc +{ + my ($tagfield, $frameworkcode) = @_; + + my $data = {}; + my $dbh = C4::Context->dbh; + if ($dbh) { + eval { + my $query = qq|SELECT tagfield,liblibrarian,libopac,mandatory,repeatable + FROM marc_tag_structure + WHERE frameworkcode=? AND tagfield=?|; + my $sth = $dbh->prepare($query); + $sth->execute($frameworkcode, $tagfield); + $data = $sth->fetchrow_hashref; + }; + if ($@) { + $debug and warn "Error GetDataFieldMarc $@\n"; + } + } + return $data; +}#GetDataFieldMarc + + + +=head2 GetIndicator + +Get the indicator id from a field in a specific framework + +return : +the id of this indicator + +=cut + + +sub GetIndicator +{ + my ($tagfield, $frameworkcode) = @_; + + my $id_indicator; + my $dbh = C4::Context->dbh; + if ($dbh) { + eval { + my $query; + my $sth; + if ($frameworkcode) { + $query = qq|SELECT id_indicator + FROM marc_indicators + WHERE tagfield=? AND frameworkcode=?|; + $sth = $dbh->prepare($query); + $sth->execute($tagfield, $frameworkcode); + } else { + $query = qq|SELECT id_indicator + FROM marc_indicators + WHERE tagfield=? AND frameworkcode=''|; + $sth = $dbh->prepare($query); + $sth->execute($tagfield); + } + ($id_indicator) = $sth->fetchrow; + }; + if ($@) { + $debug and warn "Error GetIndicator $@\n"; + } + } + return $id_indicator; +}#GetIndicator + + + +=head2 AddIndicator + +Adds a new indicator to a field in a specific framework + +return : +the id of this new indicator + +=cut + + +sub AddIndicator +{ + my ($tagfield, $frameworkcode) = @_; + + my $id_indicator; + my $dbh = C4::Context->dbh; + if ($dbh) { + eval { + my $query = qq|INSERT INTO marc_indicators + (tagfield,frameworkcode) VALUES (?,?)|; + my $sth = $dbh->prepare($query); + $sth->execute($tagfield, $frameworkcode); + if ($sth->rows > 0) { + $id_indicator = $dbh->{'mysql_insertid'}; + } + }; + if ($@) { + $debug and warn "Error AddIndicator $@\n"; + } + } + return $id_indicator; +}#AddIndicator + + + +=head2 DelIndicator + +Delete a new indicator to a field in a specific framework + +return : +the success of the operation + +=cut + + +sub DelIndicator +{ + my ($id_indicator, $tagfield, $frameworkcode) = @_; + + my $ret; + my $dbh = C4::Context->dbh; + if ($dbh) { + eval { + my $query; + my @arrParams; + if ($id_indicator){ + $query = qq|DELETE FROM marc_indicators + WHERE id_indicator=?|; + push @arrParams, $id_indicator; + } else { + $query = qq|DELETE FROM marc_indicators + WHERE tagfield=? AND frameworkcode=?|; + @arrParams = ($tagfield, $frameworkcode); + } + my $sth = $dbh->prepare($query); + $sth->execute(@arrParams); + $ret = 1; + }; + if ($@) { + $debug and warn "Error DelIndicator $@\n"; + } + } + return $ret; +}#DelIndicator + + + +=head2 AddIndicatorValue + +Adds a new indicator value and (if defined) description to a field in a specific framework + +return : +the id of this new indicator value + +=cut + + +sub AddIndicatorValue +{ + my ($id_indicator, $tagfield, $frameworkcode, $index, $value, $desc, $lang) = @_; + + my $id_indicator_value; + my $dbh = C4::Context->dbh; + if ($dbh) { + $id_indicator = GetIndicator($tagfield, $frameworkcode) unless ($id_indicator); + $id_indicator = AddIndicator($tagfield, $frameworkcode) unless ($id_indicator); + eval { + my $query = qq|INSERT INTO marc_indicators_value + (id_indicator,ind,ind_value) VALUES (?,?,?)|; + my $sth = $dbh->prepare($query); + $sth->execute($id_indicator, $index, $value); + if ($sth->rows > 0) { + $id_indicator_value = $dbh->{'mysql_insertid'}; + if ($id_indicator_value && $desc) { + $query = qq|INSERT INTO marc_indicators_desc + (id_indicator_value,lang,ind_desc) VALUES (?,?,?)|; + $lang = 'en' unless ($lang); + my $sth2 = $dbh->prepare($query); + $sth2->execute($id_indicator_value, $lang, $desc); + } + } + }; + if ($@) { + #print $@; + $debug and warn "Error AddIndicatorValue $@\n"; + } + } + return $id_indicator_value; +}#AddIndicatorValue + + + +=head2 DelIndicatorValue + +Delete a new indicator value in a framework field + +return : +the success of the operation + +=cut + + +sub DelIndicatorValue +{ + my ($id_indicator_value) = @_; + + my $ret; + my $dbh = C4::Context->dbh; + if ($dbh) { + eval { + my $query = qq|DELETE FROM marc_indicators_value + WHERE id_indicator_value=?|; + my $sth = $dbh->prepare($query); + $sth->execute($id_indicator_value); + $ret = 1; + }; + if ($@) { + $debug and warn "Error DelIndicatorValue $@\n"; + } + } + return $ret; +}#DelIndicatorValue + + + +=head2 ModIndicatorValue + +Modify a indicator value in a framework field + +return : +the success of the operation + +=cut + + +sub ModIndicatorValue +{ + my ($id_indicator_value, $value, $desc, $lang, $ind) = @_; + + my $ret; + my $dbh = C4::Context->dbh; + if ($dbh) { + eval { + my $query = qq|UPDATE marc_indicators_value + SET ind_value=?, ind=? + WHERE id_indicator_value=?|; + my $sth = $dbh->prepare($query); + $sth->execute($value, $ind, $id_indicator_value); + if ($desc) { + $ret = ModIndicatorDesc($id_indicator_value, $desc, $lang); + } else { + $ret = 1; + } + }; + if ($@) { + $debug and warn "Error ModIndicatorValue $@\n"; + } + } + return $ret; +}#ModIndicatorValue + + + +=head2 ModIndicatorDesc + +Modify a indicator description in a framework field and language + +return : +the success of the operation + +=cut + + +sub ModIndicatorDesc +{ + my ($id_indicator_value, $desc, $lang) = @_; + + my $ret; + my $dbh = C4::Context->dbh; + if ($dbh) { + eval { + my $query = qq|SELECT COUNT(*) FROM marc_indicators_desc + WHERE id_indicator_value=? AND lang=?|; + my $sth = $dbh->prepare($query); + $sth->execute($id_indicator_value, $lang); + my ($num) = $sth->fetchrow; + $sth->finish; + if ($num) { + $query = qq|UPDATE marc_indicators_desc + SET ind_desc=? + WHERE id_indicator_value=? AND lang=?|; + $sth = $dbh->prepare($query); + $sth->execute($desc, $id_indicator_value, $lang); + } else { + $query = qq|INSERT INTO marc_indicators_desc + (id_indicator_value,lang,ind_desc) VALUES (?,?,?)|; + $sth = $dbh->prepare($query); + $sth->execute($id_indicator_value, $lang, $desc); + } + $ret = 1; + }; + if ($@) { + $debug and warn "Error ModIndicatorDesc $@\n"; + } + } + return $ret; +}#ModIndicatorDesc + + + +=head2 GetValuesIndicator + +Get distinct values and descriptions from framework field + +return : +the id of the indicator and an array structure with the data required + +=cut + + +sub GetValuesIndicator +{ + my ($id_indicator, $tagfield, $frameworkcode, $lang) = @_; + + my @data; + my $dbh = C4::Context->dbh; + if ($dbh) { + $id_indicator = GetIndicator($tagfield, $frameworkcode) unless ($id_indicator); + if ($id_indicator) { + eval { + my $query; + my $sth; + if ($lang) { + $query = qq|(SELECT v.id_indicator_value, v.ind, v.ind_value, d.ind_desc, d.lang + FROM marc_indicators_value v, marc_indicators_desc d + WHERE v.id_indicator=? AND d.id_indicator_value=v.id_indicator_value AND d.lang=? + ) + UNION + (SELECT v.id_indicator_value, v.ind, v.ind_value, NULL AS ind_desc, NULL AS lang + FROM marc_indicators_value v + WHERE v.id_indicator=? AND NOT EXISTS (SELECT d.* FROM marc_indicators_desc d WHERE d.id_indicator_value=v.id_indicator_value)) + ORDER BY ind, ind_value|; + $sth = $dbh->prepare($query); + $sth->execute($id_indicator, $lang, $id_indicator); + } else { + $query = qq|SELECT v.id_indicator_value, v.ind, v.ind_value, d.ind_desc, d.lang + FROM marc_indicators_value v + LEFT JOIN marc_indicators_desc d ON d.id_indicator_value=v.id_indicator_value + WHERE v.id_indicator=? + ORDER BY v.ind, v.ind_value|; + $sth = $dbh->prepare($query); + $sth->execute($id_indicator); + } + while (my $hashRef = $sth->fetchrow_hashref) { + push @data, $hashRef; + } + }; + if ($@) { + $debug and warn "Error GetValuesIndicator $@\n"; + } + } + } + return ($id_indicator, \@data); +}#GetValuesIndicator + + + +=head2 GetValuesIndicatorFrameWork + +Get distinct values and descriptions from framework template + +return : +the frameworkcode and an hash structure with the data required + +=cut + + +sub GetValuesIndicatorFrameWork +{ + my ($frameworkcode, $tagfieldsArrRef, $lang) = @_; + + my %data; + my $dbh = C4::Context->dbh; + if ($dbh) { + unless ($tagfieldsArrRef && @$tagfieldsArrRef) { + $tagfieldsArrRef = []; + eval { + my $query; + my $sth; + if ($frameworkcode) { + $query = qq|SELECT tagfield FROM marc_tag_structure + WHERE tagfield NOT LIKE '00%' AND frameworkcode=?|; + $sth = $dbh->prepare($query); + $sth->execute($frameworkcode); + } else { + $query = qq|SELECT tagfield FROM marc_tag_structure + WHERE tagfield NOT LIKE '00%' AND frameworkcode=''|; + $sth = $dbh->prepare($query); + $sth->execute(); + } + my $tagfield; + while (($tagfield) = $sth->fetchrow) { + push @$tagfieldsArrRef, $tagfield; + } + }; + } + for (@$tagfieldsArrRef) { + my ($id_indicator, $dataInd) = GetValuesIndicator(undef, $_, $frameworkcode, $lang); + $data{$_} = $dataInd; + } + if ($@) { + $debug and warn "Error GetValuesIndicatorFrameWork $@\n"; + } + } + return ($frameworkcode, \%data); +}#GetValuesIndicatorFrameWork + + + +=head2 GetLanguagesIndicators + +Get distinct languages from indicators descriptions + +return : +the languages as a sorted array + +=cut + + +sub GetLanguagesIndicators +{ + my @languages; + my $dbh = C4::Context->dbh; + if ($dbh) { + eval { + my $query = qq|SELECT DISTINCT lang FROM marc_indicators_desc ORDER BY lang|; + my $sth = $dbh->prepare($query); + $sth->execute(); + my $lang; + while (($lang) = $sth->fetchrow) { + push @languages, $lang; + } + }; + if ($@) { + $debug and warn "Error GetLanguagesIndicators $@\n"; + } + } + return \@languages; +}#GetLanguagesIndicators + + + +=head2 binarySearch + +Little binary search for strings + +return : +true or false + +=cut + + +sub binarySearch +{ + my ($id, $arr) = @_; + + if ($arr && @$arr) { + my $i = 0; + my $j = scalar(@$arr) - 1; + my $k = 0; + while ($arr->[$k] ne $id && $j >= $i) { + $k = int(($i + $j) / 2); + if ($id gt $arr->[$k]) { + $i = $k + 1; + } else { + $j = $k - 1; + } + } + return 0 if ($arr->[$k] ne $id); + return 1; + } + return 0; +}#binarySearch + + + +=head2 CheckValueIndicators + +Check the validity ot the indicators form values against the user defined ones + +return : +Hash with the indicators with wrong values + +=cut + + +sub CheckValueIndicatorsSub +{ + my ($input, $frameworkcode, $langParam) = @_; + + my $retHash; + my $lang; + my $indicatorsLanguages = GetLanguagesIndicators(); + if ($langParam && binarySearch($langParam, $indicatorsLanguages)) { + $lang = $langParam; + } elsif ($input->param('lang') && binarySearch($input->param('lang'), $indicatorsLanguages)) { + $lang = $input->param('lang'); + } else { + $lang = 'en'; + } + my ($frameworkcodeRet, $data) = GetValuesIndicatorFrameWork($frameworkcode, undef, $lang); + if ($data) { + $retHash = {}; + my $tagfield; + my $ind; + my $var; + my $random; + my $found; + my $nonEmptySubfield; + my $pattern; + my $hasIndicator = 0; + my @params = $input->param(); + foreach $var (@params) { + if ($var =~ /^tag_([0-9]{3})_indicator([12])_([0-9]+)$/) { + $tagfield = $1; + $ind = $2; + $random = '[0-9_]*(?:' . $3 . ')?'; + if ($data->{$tagfield} && @{$data->{$tagfield}}) { + $hasIndicator = 0; + # check if exists this indicator in the framework + for (@{$data->{$tagfield}}) { + if ($ind == $_->{ind}) { + $hasIndicator = 1; + last; + } + } + next unless ($hasIndicator); + $found = 0; + # look for some subfield filled and if so check indicator + $nonEmptySubfield = 0; + $pattern = 'tag_' . $tagfield . '_subfield_[a-z0-9]_' . $random; + foreach my $value (@params) { + if ($value =~ /^$pattern/ && $input->param($value) ne '') { + $nonEmptySubfield = 1; + last; + } + } + # check if exists the value for the indicator + if ($nonEmptySubfield) { + for (@{$data->{$tagfield}}) { + if ($ind == $_->{ind} && ($_->{ind_value} eq $input->param($var) || $input->param($var) eq '' || $input->param($var) eq ' ')) { + $found = 1; + last; + } + } + # incorrect value + $retHash->{$tagfield}->{$ind} = $input->param($var) unless ($found); + } + } + } + } + $retHash = undef unless (scalar(keys %$retHash)); + } + return $retHash; +}#CheckValueIndicatorsSub + + + + +1; +__END__ + +=head1 AUTHOR + +Koha Development Team + +=cut + diff --git a/admin/biblio_framework.pl b/admin/biblio_framework.pl index f2c147e..983f390 100755 --- a/admin/biblio_framework.pl +++ b/admin/biblio_framework.pl @@ -27,6 +27,7 @@ use CGI; use C4::Context; use C4::Auth; use C4::Output; +use C4::Indicators; sub StringSearch { my $dbh = C4::Context->dbh; @@ -55,6 +56,16 @@ $template->param( script_name => $script_name); $template->param(($op||'else') => 1); my $dbh = C4::Context->dbh; + + +# get framework list for cloning indicators +my $frameworks = GetFrameworks($frameworkcode); +unshift @$frameworks, {frameworkcode => 'Default', frameworktext => 'Default'}; +$template->param( + frameworkloop => $frameworks +); + + ################## ADD_FORM ################################## # called by default. Used to create form to add or modify a record if ($op eq 'add_form') { @@ -79,6 +90,11 @@ if ($op eq 'add_form') { if ($input->param('modif')) { my $sth=$dbh->prepare("UPDATE biblio_framework SET frameworktext=? WHERE frameworkcode=?"); $sth->execute($input->param('frameworktext'),$input->param('frameworkcode')); + #Clone indicators from a framework + if($input->param('indicators') && DelIndicatorsFramework($input->param('frameworkcode'))) { + my $frameworkBase = ($input->param('indicators') eq 'Default')?'':$input->param('indicators'); + CloneIndicatorsFramework($frameworkBase, $input->param('frameworkcode')); + } } else { my $sth=$dbh->prepare("INSERT into biblio_framework (frameworkcode,frameworktext) values (?,?)"); $sth->execute($input->param('frameworkcode'),$input->param('frameworktext')); diff --git a/admin/marc_indicators_structure.pl b/admin/marc_indicators_structure.pl new file mode 100755 index 0000000..9e7fbc7 --- /dev/null +++ b/admin/marc_indicators_structure.pl @@ -0,0 +1,151 @@ +#!/usr/bin/perl + + +# Copyright 2010-2011 Spanish Minister of Culture +# +# This file is part of Koha. +# +# Koha is free software; you can redistribute it and/or modify it under the +# terms of the GNU General Public License as published by the Free Software +# Foundation; either version 2 of the License, or (at your option) any later +# version. +# +# Koha is distributed in the hope that it will be useful, but WITHOUT ANY +# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +# A PARTICULAR PURPOSE. See the GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License along +# with Koha; if not, write to the Free Software Foundation, Inc., +# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + +use strict; +use CGI; +use C4::Indicators; +use C4::Context; +use C4::Output; +use C4::Auth; +use C4::Biblio; +use Data::Dumper; + + + +my $input = new CGI; + +my ( $template, $borrowernumber, $cookie ) = get_template_and_user( + { + template_name => "admin/marc_indicators_structure.tmpl", + query => $input, + type => "intranet", + authnotrequired => 0, + flagsrequired => { parameters => 1 }, + debug => 1, + } +); + +my $frameworkcode = $input->param('frameworkcode'); +my $op = $input->param('op'); +my $tagfield = $input->param('tagfield'); + +# Get the languages associated with indicators +my $indicatorsLanguages = GetLanguagesIndicators(); + +# Is our language is defined on the indicators? +my $lang; +if ($input->param('lang') && binarySearch($input->param('lang'), $indicatorsLanguages)) { + $lang = $input->param('lang'); +} elsif (binarySearch($template->param('lang'), $indicatorsLanguages)) { + $lang = $template->param('lang'); +} else { + $lang = 'en'; +} + +my $dataInd; +my $id_indicator; +my $strError = ''; + +if ($input->request_method() eq "GET") { + if ($op eq 'mod') { + ($id_indicator, $dataInd) = GetValuesIndicator(undef, $tagfield, $frameworkcode, $lang); + } else { + $op = 'add'; + } +} elsif ($input->request_method() eq "POST") { + if ($op eq 'add') { + my $inserted = 0; + $id_indicator = AddIndicator($tagfield, $frameworkcode); + if ($id_indicator) { + $inserted++; + my $id_indicator_value; + my $counter; + for ($input->param()) { + if ($_ =~ /^ind_value_([0-9]+)$/ && ($counter = $1) && $input->param('ind_' . $counter) =~ /^([12])$/) { + $id_indicator_value = AddIndicatorValue($id_indicator, $tagfield, $frameworkcode, $1, $input->param($_), $input->param('ind_desc_' . $counter), $lang); + $inserted++ if ($id_indicator_value); + } + } + } + if ($inserted) { + $op = 'mod'; + $strError = 'Insertion OK'; + ($id_indicator, $dataInd) = GetValuesIndicator($id_indicator, $tagfield, $frameworkcode, $lang); + } else { + $strError = 'Insertion failed'; + } + } elsif ($op eq 'mod') { + $id_indicator = $input->param('id_indicator'); + ($id_indicator, $dataInd) = GetValuesIndicator($id_indicator, $tagfield, $frameworkcode, $lang); + my $indRepeated = {}; + my $indId = {}; + my $id_indicator_value; + my $counter; + for ($input->param()) { + if ($_ =~ /^id_indicator_([0-9]+)$/ && ($counter = $1) && $input->param('ind_' . $counter) =~ /^([12])$/) { + $indRepeated->{$counter} = $input->param($_); + $indId->{$input->param($_)} = $input->param($_); + ModIndicatorValue($input->param($_), $input->param('ind_value_' . $counter), $input->param('ind_desc_' . $counter), $lang, $input->param('ind_' . $counter)); + } elsif ($_ =~ /^ind_value_([0-9]+)$/ && ($counter = $1) && !exists($indRepeated->{$counter}) && $input->param('ind_' . $counter) =~ /^([12])$/) { + $id_indicator_value = AddIndicatorValue($id_indicator, $tagfield, $frameworkcode, $1, $input->param($_), $input->param('ind_desc_' . $counter), $lang); + $indId->{$id_indicator_value} = $id_indicator_value if ($id_indicator_value); + } + } + foreach (@$dataInd) { + unless (exists($indId->{$_->{id_indicator_value}})) { + DelIndicatorValue($_->{id_indicator_value}); + $id_indicator_value = $_->{id_contenido}; + } + } + unless ($id_indicator_value) { + $strError = 'Update OK.'; + } else { + $strError = 'Update failed.'; + } + @$dataInd = undef; + ($id_indicator, $dataInd) = GetValuesIndicator($id_indicator, $tagfield, $frameworkcode, $lang); + } +} + + +if ($dataInd) { + my $i = 1; + for (@$dataInd) { + $_->{numInd} = $i; + $i++; + } +} + + +$template->param(frameworkcode => $frameworkcode, + strError => $strError, + op => $op, + lang => $lang, + tagfield => $tagfield, + numInd => ($dataInd)?scalar(@$dataInd):0, + BIG_LOOP => $dataInd, +); + + +output_html_with_http_headers $input, $cookie, $template->output; +# print Dumper $dataInd; +# print $strError; +# print $lang; + diff --git a/admin/marctagstructure.pl b/admin/marctagstructure.pl index 92e0d99..57e91ed 100755 --- a/admin/marctagstructure.pl +++ b/admin/marctagstructure.pl @@ -26,6 +26,7 @@ use C4::Koha; use C4::Context; use C4::Output; use C4::Context; +use C4::Indicators; # retrieve parameters @@ -199,6 +200,10 @@ if ($op eq 'add_form') { my $sth2 = $dbh->prepare("DELETE FROM marc_subfield_structure WHERE tagfield=? AND frameworkcode=?"); $sth1->execute($searchfield, $frameworkcode); $sth2->execute($searchfield, $frameworkcode); + # Manage Indicators, delete indicators from framework + if (int($searchfield) >= 10) { + DelIndicator(undef, $searchfield, $frameworkcode); + } } $template->param( searchfield => $searchfield, @@ -263,6 +268,8 @@ if ($op eq 'add_form') { $row_data{mandatory} = $results[$i]->{'mts_mandatory'}; $row_data{authorised_value} = $results[$i]->{'mts_authorised_value'}; $row_data{subfield_link} = "marc_subfields_structure.pl?op=add_form&tagfield=".$results[$i]->{'mts_tagfield'}."&frameworkcode=".$frameworkcode; + # Show link to manage indicators for a field + $row_data{indicator_link} = (int($results[$i]->{'mts_tagfield'}) >= 10)?"marc_indicators_structure.pl?op=mod&tagfield=".$results[$i]->{'mts_tagfield'}."&frameworkcode=".$frameworkcode:''; $row_data{edit} = "$script_name?op=add_form&searchfield=" .$results[$i]->{'mts_tagfield'}."&frameworkcode=".$frameworkcode; $row_data{delete} = "$script_name?op=delete_confirm&searchfield=" .$results[$i]->{'mts_tagfield'}."&frameworkcode=".$frameworkcode; $j=$i; @@ -302,6 +309,8 @@ if ($op eq 'add_form') { $row_data{mandatory} = $results->[$i]{'mandatory'}; $row_data{authorised_value} = $results->[$i]{'authorised_value'}; $row_data{subfield_link} = "marc_subfields_structure.pl?tagfield=" .$results->[$i]{'tagfield'}."&frameworkcode=".$frameworkcode; + # Show link to manage indicators for a field + $row_data{indicator_link} = (int($results->[$i]{'tagfield'}) >= 10)?"marc_indicators_structure.pl?op=mod&tagfield=".$results->[$i]{'tagfield'}."&frameworkcode=".$frameworkcode:''; $row_data{edit} = "$script_name?op=add_form&searchfield=" .$results->[$i]{'tagfield'}."&frameworkcode=".$frameworkcode; $row_data{delete} = "$script_name?op=delete_confirm&searchfield=".$results->[$i]{'tagfield'}."&frameworkcode=".$frameworkcode; push(@loop_data, \%row_data); @@ -325,6 +334,7 @@ if ($op eq 'add_form') { } } #---- END $OP eq DEFAULT + output_html_with_http_headers $input, $cookie, $template->output; # @@ -361,5 +371,9 @@ sub duplicate_framework { while ( my ($frameworkcode, $tagfield, $tagsubfield, $liblibrarian, $libopac, $repeatable, $mandatory, $kohafield, $tab, $authorised_value, $thesaurus_category, $value_builder, $seealso,$hidden) = $sth->fetchrow) { $sth_insert->execute($newframeworkcode, $tagfield, $tagsubfield, $liblibrarian, $libopac, $repeatable, $mandatory, $kohafield, $tab, $authorised_value, $thesaurus_category, $value_builder, $seealso, $hidden); } + # Manage Indicators, clone the indicators from the parent of the new framework + if ($input->param("clone_indicators") eq "1") { + CloneIndicatorsFramework($oldframeworkcode, $newframeworkcode); + } } diff --git a/cataloguing/addbiblio.pl b/cataloguing/addbiblio.pl index d2a3841..2f162df 100755 --- a/cataloguing/addbiblio.pl +++ b/cataloguing/addbiblio.pl @@ -35,6 +35,7 @@ use C4::Branch; # XXX subfield_is_koha_internal_p use C4::ClassSource; use C4::ImportBatch; use C4::Charset; +use C4::Indicators; use Date::Calc qw(Today); use MARC::File::USMARC; @@ -913,11 +914,29 @@ if ($biblionumber) { #------------------------------------------------------------------------------------- if ( $op eq "addbiblio" ) { #------------------------------------------------------------------------------------- + my ($duplicatebiblionumber,$duplicatetitle); + my $retWrongInd; # variable to store the indicators with incorrect values + # Check whether the value of the indicators are correct or do not add/modify the biblio and show the form again + # Do not check if the record comes from a Z3959 Search or from an Import + if ((C4::Context->preference("CheckValueIndicators") || C4::Context->preference("DisplayPluginValueIndicators")) && !$z3950 && !$breedingid) { + $retWrongInd = CheckValueIndicatorsSub($input, $frameworkcode, $template->param('lang')); + if ($retWrongInd) { + my @params = $input->param(); + $record = TransformHtmlToMarc( \@params , $input ); + $duplicatebiblionumber = 1; # modify the variable (even it's not a duplicate) to not enter the next if block + $is_a_modif = 1; # do not want FindDuplicate + $input->param('confirm_not_duplicate', '0'); # modify to not enter the next if clause + my @wrongInd = (); + map { push @wrongInd, {tagfield => $_, ind1 => $retWrongInd->{$_}->{1}, ind2 => $retWrongInd->{$_}->{2}}; } keys %$retWrongInd; + $template->param(wrongInd => \@wrongInd); + } + } + # getting html input my @params = $input->param(); $record = TransformHtmlToMarc( \@params , $input ); # check for a duplicate - my ($duplicatebiblionumber,$duplicatetitle) = FindDuplicate($record) if (!$is_a_modif); + ($duplicatebiblionumber,$duplicatetitle) = FindDuplicate($record) if (!$is_a_modif); my $confirm_not_duplicate = $input->param('confirm_not_duplicate'); # it is not a duplicate (determined either by Koha itself or by user checking it's not a duplicate) if ( !$duplicatebiblionumber or $confirm_not_duplicate ) { @@ -970,6 +989,7 @@ if ( $op eq "addbiblio" ) { } } else { # it may be a duplicate, warn the user and do nothing + $duplicatebiblionumber = 0 if ($retWrongInd); # reset duplicatebiblionumber to the original value build_tabs ($template, $record, $dbh,$encoding,$input); $template->param( biblionumber => $biblionumber, @@ -1029,4 +1049,9 @@ $template->param( itemtype => $frameworkcode, ); +$template->param( + DisplayPluginValueIndicators => C4::Context->preference("DisplayPluginValueIndicators"), + CheckValueIndicators => (!$z3950 && !$breedingid)?(C4::Context->preference("CheckValueIndicators") | C4::Context->preference("DisplayPluginValueIndicators")):0 +); + output_html_with_http_headers $input, $cookie, $template->output; diff --git a/cataloguing/indicators_ajax.pl b/cataloguing/indicators_ajax.pl new file mode 100755 index 0000000..ba6b16a --- /dev/null +++ b/cataloguing/indicators_ajax.pl @@ -0,0 +1,121 @@ +#!/usr/bin/perl -w + + +# Copyright 2010-2011 Spanish Minister of Culture +# +# This file is part of Koha. +# +# Koha is free software; you can redistribute it and/or modify it under the +# terms of the GNU General Public License as published by the Free Software +# Foundation; either version 2 of the License, or (at your option) any later +# version. +# +# Koha is distributed in the hope that it will be useful, but WITHOUT ANY +# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +# A PARTICULAR PURPOSE. See the GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License along +# with Koha; if not, write to the Free Software Foundation, Inc., +# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + + +use strict; +use XML::LibXML; +use CGI; +use C4::Indicators; +use IO::Handle; + + +my $cgi = new CGI; +my $strXml = ''; +my $doc; +my $root; + +eval { + $doc = XML::LibXML::Document->new('1.0', 'UTF-8'); +}; +if ($@) { + $doc = undef; + $strXml = '' . chr(10); +} + +if ($cgi->request_method() eq "POST" || $cgi->request_method() eq "GET") { + + my $frameworkcode = $cgi->param('frameworkcode'); + if ($doc) { + $root = $doc->createElement('Framework'); + $root->setAttribute('frameworkcode', $frameworkcode); + $doc->addChild($root); + } else { + $strXml .= '' . chr(10); + } + + my $params = $cgi->Vars; + my @tagfields; + @tagfields = split("\0", $params->{'tagfields'}) if $params->{'tagfields'}; + + my $indicatorsLanguages = GetLanguagesIndicators(); + my $lang; + if ($cgi->param('lang') && binarySearch($cgi->param('lang'), $indicatorsLanguages)) { + $lang = $cgi->param('lang'); + } else { + $lang = 'en'; + } + + my ($frameworkcodeRet, $data) = GetValuesIndicatorFrameWork($frameworkcode, \@tagfields, $lang); + if ($data) { + my $elementFields; + if ($doc) { + $elementFields = $doc->createElement('Fields'); + $root->addChild($elementFields); + } else { + $strXml .= '' . chr(10); + } + my $tagfield; + my $elementField; + for $tagfield (sort keys %$data) { + if ($doc) { + $elementField = $doc->createElement('Field'); + $elementField->setAttribute('tag', $tagfield); + $elementFields->addChild($elementField); + } else { + $strXml .= '' . chr(10); + } + if (@{$data->{$tagfield}}) { + my $elementInd; + my $dataUnique = {}; + for (@{$data->{$tagfield}}) { + unless (exists($dataUnique->{$_->{ind}}->{$_->{ind_value}})) { + $dataUnique->{$_->{ind}}->{$_->{ind_value}} = 1; + if ($doc) { + $elementInd = $doc->createElement('Indicator'); + $elementInd->setAttribute('ind', $_->{ind}); + $elementInd->appendText($_->{ind_value}); + $elementField->addChild($elementInd); + } else { + $strXml .= '' . $_->{ind_value} . '' . chr(10); + } + } + } + } + $strXml .= '' . chr(10) unless ($doc); + } + $strXml .= '' . chr(10) unless ($doc); + } + $strXml .= ''; +} else { + if ($doc) { + $root = $doc->createElement('Error'); + $doc->addChild($root); + } else { + $strXml .= '' . chr(10); + } +} +if ($doc) { + $strXml = $doc->toString(0); +} +STDOUT->autoflush(1); +print "Content-type: application/xml\n\n"; +print $strXml; +close(STDOUT); +exit; diff --git a/cataloguing/marc21_indicators.pl b/cataloguing/marc21_indicators.pl new file mode 100755 index 0000000..0668999 --- /dev/null +++ b/cataloguing/marc21_indicators.pl @@ -0,0 +1,103 @@ +#!/usr/bin/perl + + +# Copyright 2010-2011 Spanish Minister of Culture +# +# This file is part of Koha. +# +# Koha is free software; you can redistribute it and/or modify it under the +# terms of the GNU General Public License as published by the Free Software +# Foundation; either version 2 of the License, or (at your option) any later +# version. +# +# Koha is distributed in the hope that it will be useful, but WITHOUT ANY +# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +# A PARTICULAR PURPOSE. See the GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License along +# with Koha; if not, write to the Free Software Foundation, Inc., +# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + +use strict; +use CGI; +use C4::Indicators; +use C4::Context; +use C4::Output; +use C4::Auth; +use C4::Biblio; + + + +my $input = new CGI; +my $biblionumber = $input->param('biblionumber'); +my $frameworkcode = $input->param('frameworkcode'); + + +my ( $template, $loggedinuser, $cookie ) = get_template_and_user( + { + template_name => "cataloguing/marc21_indicators.tmpl", + query => $input, + type => "intranet", + authnotrequired => 0, + } +); + + +# Values of indicators as filled by user +my %tagfields = (); +foreach my $var ($input->param()) { + if ($var =~ /^tag_([0-9]{3})_indicator([12])_[0-9]+$/) { + $tagfields{$1}{$2}{value} = $input->param($var) if (defined($input->param($var)) && $input->param($var) ne '#'); + $tagfields{$1}{$2}{field} = $var; + } +} + + +# Get data from biblio +if ($biblionumber) { + my $record = GetMarcBiblio($biblionumber); + $template->param( title => $record->title()); +} + +# Get the languages associated with indicators +my $indicatorsLanguages = GetLanguagesIndicators(); + +# Is our language is defined on the indicators? +my $lang; +if ($input->param('lang') && binarySearch($input->param('lang'), $indicatorsLanguages)) { + $lang = $input->param('lang'); +} elsif (binarySearch($template->param('lang'), $indicatorsLanguages)) { + $lang = $template->param('lang'); +} else { + $lang = 'en'; +} + +my @INDICATORS_LOOP; +my @tagfields = keys %tagfields; + +# Get predefined values for indicators on a framework, tagfields and language +my ($frameworkcodeRet, $data) = GetValuesIndicatorFrameWork($frameworkcode, \@tagfields, $lang); +if ($data) { + my $tagfield; + for $tagfield (sort keys %$data) { + my $dataField = GetDataFieldMarc($tagfield, $frameworkcode); + if (exists($tagfields{$tagfield}) || @{$data->{$tagfield}}) { + my $hashRef = {tagfield=> $tagfield, + desc => $dataField->{liblibrarian}?$dataField->{liblibrarian}:$dataField->{libopac}, + current_value_1 => exists($tagfields{$tagfield}{1}{value})?$tagfields{$tagfield}{1}{value}:'', + current_value_2 => exists($tagfields{$tagfield}{2}{value})?$tagfields{$tagfield}{2}{value}:'', + current_field_1 => exists($tagfields{$tagfield}{1})?$tagfields{$tagfield}{1}{field}:'', + current_field_2 => exists($tagfields{$tagfield}{2})?$tagfields{$tagfield}{2}{field}:'', + data => $data->{$tagfield}}; + push @INDICATORS_LOOP, $hashRef; + } + } +} + +$template->param(biblionumber => $biblionumber, + INDICATORS_LOOP => \@INDICATORS_LOOP, + indicatorsLanguages => $indicatorsLanguages, + frameworkcode => $frameworkcode + ); + +output_html_with_http_headers $input, $cookie, $template->output; diff --git a/installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_indicators.sql b/installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_indicators.sql new file mode 100755 index 0000000..9b02ad5 --- /dev/null +++ b/installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_indicators.sql @@ -0,0 +1,84 @@ + +-- +-- Table structure for table marc_indicators +-- + + +DROP TABLE IF EXISTS marc_indicators CASCADE; +CREATE TABLE marc_indicators ( + id_indicator SERIAL PRIMARY KEY, + frameworkcode varchar(4) default '', + tagfield varchar(3) NOT NULL default '' +); +CREATE UNIQUE INDEX marc_indicators_frameworkcode ON marc_indicators (frameworkcode,tagfield); + + +-- +-- Table structure for table marc_indicators_values +-- + +DROP TABLE IF EXISTS marc_indicators_values CASCADE; +CREATE TABLE marc_indicators_values ( + ind_value char(1) NOT NULL default '' PRIMARY KEY +); + +INSERT INTO marc_indicators_values VALUES (''),('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9'),('a'),('b'),('c'),('d'),('e'),('f'),('g'),('h'),('i'),('j'),('k'),('l'),('m'),('n'),('o'),('p'),('q'),('r'),('s'),('t'),('u'),('v'),('w'),('x'),('y'),('z'); + + +-- +-- Table structure for table marc_indicators_value +-- + +DROP TABLE IF EXISTS marc_indicators_value CASCADE; +CREATE TABLE marc_indicators_value ( + id_indicator_value SERIAL PRIMARY KEY, + id_indicator integer NOT NULL REFERENCES marc_indicators (id_indicator) ON DELETE CASCADE, + ind varchar(1) NOT NULL, + ind_value char(1) NOT NULL REFERENCES marc_indicators_values (ind_value) ON DELETE CASCADE, + CHECK ( ind IN ('1', '2')) +); +CREATE INDEX marc_indicators_value_id_indicator ON marc_indicators_value (id_indicator); +CREATE INDEX marc_indicators_value_ind_value ON marc_indicators_value (ind_value); + + +-- +-- Table structure for table marc_indicators_desc +-- + +DROP TABLE IF EXISTS marc_indicators_desc CASCADE; +CREATE TABLE marc_indicators_desc ( + id_indicator_value integer NOT NULL REFERENCES marc_indicators_value (id_indicator_value) ON DELETE CASCADE, + lang varchar(25) NOT NULL default 'en', + ind_desc text, + PRIMARY KEY (id_indicator_value,lang) +); +CREATE INDEX marc_indicators_desc_lang ON marc_indicators_desc (lang); + + + +--- ****************************************** +--- Values for Indicators for Default Framework +--- ****************************************** +-- +-- Dumping data for table marc_indicators +-- + + +INSERT INTO marc_indicators VALUES (1,'','010'),(11,'','013'),(20,'','015'),(29,'','016'),(38,'','017'),(47,'','018'),(56,'','020'),(66,'','022'),(76,'','024'),(85,'','025'),(94,'','026'),(103,'','027'),(112,'','028'),(121,'','030'),(130,'','031'),(139,'','032'),(148,'','033'),(157,'','034'),(166,'','035'),(175,'','036'),(184,'','037'),(193,'','038'),(202,'','040'),(211,'','041'),(220,'','042'),(229,'','043'),(238,'','044'),(247,'','045'),(256,'','046'),(265,'','047'),(274,'','048'),(283,'','050'),(293,'','051'),(302,'','052'),(311,'','055'),(320,'','060'),(329,'','061'),(338,'','066'),(347,'','070'),(356,'','071'),(365,'','072'),(374,'','074'),(383,'','080'),(392,'','082'),(401,'','084'),(410,'','086'),(419,'','088'),(428,'','100'),(438,'','110'),(447,'','111'),(456,'','130'),(465,'','210'),(474,'','222'),(483,'','240'),(492,'','242'),(501,'','245'),(511,'','246'),(520,'','247'),(529,'','250'),(539,'','254'),(548,'','255'),(557,'','256'),(566,'','257'),(575,'','258'),(584,'','260'),(594,'','263'),(603,'','270'),(612,'','300'),(622,'','306'),(631,'','307'),(640,'','310'),(649,'','321'),(658,'','340'),(667,'','342'),(676,'','343'),(685,'','351'),(694,'','352'),(703,'','355'),(712,'','357'),(721,'','362'),(730,'','365'),(739,'','366'),(748,'','490'),(757,'','500'),(767,'','501'),(776,'','502'),(785,'','504'),(794,'','505'),(803,'','506'),(812,'','507'),(821,'','508'),(830,'','510'),(839,'','511'),(848,'','513'),(857,'','514'),(866,'','515'),(875,'','516'),(884,'','518'),(893,'','520'),(902,'','521'),(911,'','522'),(920,'','524'),(929,'','525'),(938,'','526'),(947,'','530'),(956,'','533'),(965,'','534'),(974,'','535'),(983,'','536'),(992,'','538'),(1001,'','540'),(1010,'','541'),(1019,'','544'),(1028,'','546'),(1037,'','547'),(1046,'','550'),(1055,'','552'),(1064,'','555'),(1073,'','556'),(1082,'','561'),(1091,'','562'),(1100,'','563'),(1109,'','565'),(1118,'','567'),(1127,'','580'),(1136,'','581'),(1145,'','583'),(1154,'','584'),(1163,'','585'),(1172,'','586'),(1181,'','600'),(1190,'','610'),(1199,'','611'),(1208,'','630'),(1217,'','648'),(1226,'','650'),(1235,'','651'),(1244,'','653'),(1253,'','654'),(1262,'','655'),(1271,'','656'),(1280,'','657'),(1289,'','658'),(1298,'','662'),(1307,'','700'),(1316,'','710'),(1325,'','711'),(1334,'','720'),(1343,'','730'),(1352,'','740'),(1361,'','752'),(1370,'','753'),(1379,'','754'),(1388,'','760'),(1397,'','762'),(1406,'','765'),(1415,'','767'),(1424,'','770'),(1433,'','772'),(1442,'','773'),(1451,'','774'),(1460,'','775'),(1469,'','776'),(1478,'','777'),(1487,'','780'),(1496,'','785'),(1505,'','786'),(1514,'','787'),(1523,'','800'),(1532,'','810'),(1541,'','811'),(1550,'','830'),(1559,'','841'),(1568,'','842'),(1577,'','843'),(1586,'','844'),(1595,'','845'),(1604,'','850'),(1613,'','852'),(1622,'','853'),(1631,'','854'),(1640,'','855'),(1649,'','856'),(1658,'','863'),(1667,'','864'),(1676,'','865'),(1685,'','866'),(1694,'','867'),(1703,'','868'),(1712,'','876'),(1721,'','877'),(1730,'','878'),(1739,'','880'),(1748,'','886'),(1757,'','887'); + + +-- +-- Dumping data for table marc_indicators_value +-- + + +INSERT INTO marc_indicators_value VALUES (1,1,'1',''),(2,1,'2',''),(21,1,'1',''),(22,1,'2',''),(41,11,'1',''),(42,11,'2',''),(59,11,'1',''),(60,11,'2',''),(77,20,'1',''),(78,20,'2',''),(95,20,'1',''),(96,20,'2',''),(113,29,'1',''),(114,29,'2',''),(131,29,'1',''),(132,29,'2',''),(149,29,'1','7'),(158,38,'1',''),(159,38,'2',''),(176,38,'1',''),(177,38,'2',''),(194,47,'1',''),(195,47,'2',''),(212,47,'1',''),(213,47,'2',''),(230,56,'1',''),(231,56,'2',''),(250,56,'1',''),(251,56,'2',''),(270,66,'1',''),(271,66,'2',''),(290,66,'1',''),(291,66,'2',''),(310,66,'1','0'),(320,66,'1','1'),(330,76,'1',''),(331,76,'2',''),(348,76,'1','0'),(349,76,'2',''),(366,76,'1','1'),(367,76,'2','0'),(384,76,'1','2'),(385,76,'2','1'),(402,76,'1','3'),(411,76,'1','4'),(420,76,'1','7'),(429,76,'1','8'),(438,85,'1',''),(439,85,'2',''),(456,85,'1',''),(457,85,'2',''),(474,94,'1',''),(475,94,'2',''),(492,94,'1',''),(493,94,'2',''),(510,103,'1',''),(511,103,'2',''),(528,103,'1',''),(529,103,'2',''),(546,112,'1',''),(547,112,'2',''),(564,112,'1','0'),(565,112,'2','0'),(582,112,'1','1'),(583,112,'2','1'),(600,112,'1','2'),(601,112,'2','2'),(618,112,'1','3'),(619,112,'2','3'),(636,112,'1','4'),(645,112,'1','5'),(654,121,'1',''),(655,121,'2',''),(672,121,'1',''),(673,121,'2',''),(690,130,'1',''),(691,130,'2',''),(708,130,'1',''),(709,130,'2',''),(726,139,'1',''),(727,139,'2',''),(744,139,'1',''),(745,139,'2',''),(762,148,'1',''),(763,148,'2',''),(780,148,'1',''),(781,148,'2',''),(798,148,'1','0'),(799,148,'2','0'),(816,148,'1','1'),(817,148,'2','1'),(834,148,'1','2'),(835,148,'2','2'),(852,157,'1',''),(853,157,'2',''),(870,157,'1','0'),(871,157,'2',''),(888,157,'1','1'),(889,157,'2','0'),(906,157,'1','3'),(907,157,'2','1'),(924,166,'1',''),(925,166,'2',''),(942,166,'1',''),(943,166,'2',''),(960,175,'1',''),(961,175,'2',''),(978,175,'1',''),(979,175,'2',''),(996,184,'1',''),(997,184,'2',''),(1014,184,'1',''),(1015,184,'2',''),(1032,193,'1',''),(1033,193,'2',''),(1050,193,'1',''),(1051,193,'2',''),(1068,202,'1',''),(1069,202,'2',''),(1086,202,'1',''),(1087,202,'2',''),(1104,211,'1',''),(1105,211,'2',''),(1122,211,'1','0'),(1123,211,'2',''),(1140,211,'1','1'),(1141,211,'2','7'),(1158,220,'1',''),(1159,220,'2',''),(1176,220,'1',''),(1177,220,'2',''),(1194,229,'1',''),(1195,229,'2',''),(1212,229,'1',''),(1213,229,'2',''),(1230,238,'1',''),(1231,238,'2',''),(1248,238,'1',''),(1249,238,'2',''),(1266,247,'1',''),(1267,247,'2',''),(1284,247,'1',''),(1285,247,'2',''),(1302,247,'1','0'),(1311,247,'1','1'),(1320,247,'1','2'),(1329,256,'1',''),(1330,256,'2',''),(1347,256,'1',''),(1348,256,'2',''),(1365,265,'1',''),(1366,265,'2',''),(1383,265,'1',''),(1384,265,'2',''),(1401,274,'1',''),(1402,274,'2',''),(1419,274,'1',''),(1420,274,'2',''),(1437,283,'1',''),(1438,283,'2',''),(1457,283,'1',''),(1458,283,'2','0'),(1477,283,'1','0'),(1478,283,'2','4'),(1497,283,'1','1'),(1507,293,'1',''),(1508,293,'2',''),(1525,293,'1',''),(1526,293,'2',''),(1543,302,'1',''),(1544,302,'2',''),(1561,302,'1',''),(1562,302,'2',''),(1579,302,'1','1'),(1588,302,'1','7'),(1597,311,'1',''),(1598,311,'2',''),(1615,311,'1',''),(1616,311,'2','0'),(1633,311,'1','0'),(1634,311,'2','1'),(1651,311,'1','1'),(1652,311,'2','2'),(1669,311,'2','3'),(1678,311,'2',''),(1687,311,'2','5'),(1696,311,'2','6'),(1705,311,'2','7'),(1714,311,'2','8'),(1723,311,'2','9'),(1732,320,'1',''),(1733,320,'2',''),(1750,320,'1',''),(1751,320,'2','0'),(1768,320,'1','0'),(1769,320,'2','4'),(1786,320,'1','1'),(1795,329,'1',''),(1796,329,'2',''),(1813,329,'1',''),(1814,329,'2',''),(1831,338,'1',''),(1832,338,'2',''),(1849,338,'1',''),(1850,338,'2',''),(1867,347,'1',''),(1868,347,'2',''),(1885,347,'1','0'),(1886,347,'2',''),(1903,347,'1','1'),(1912,356,'1',''),(1913,356,'2',''),(1930,356,'1',''),(1931,356,'2',''),(1948,365,'1',''),(1949,365,'2',''),(1966,365,'1',''),(1967,365,'2',''),(1984,365,'2','7'),(1993,374,'1',''),(1994,374,'2',''),(2011,374,'1',''),(2012,374,'2',''),(2029,383,'1',''),(2030,383,'2',''),(2047,383,'1',''),(2048,383,'2',''),(2065,392,'1',''),(2066,392,'2',''),(2083,392,'1','0'),(2084,392,'2',''),(2101,392,'1','1'),(2102,392,'2','0'),(2119,392,'2','4'),(2128,401,'1',''),(2129,401,'2',''),(2146,401,'1',''),(2147,401,'2',''),(2164,410,'1',''),(2165,410,'2',''),(2182,410,'1',''),(2183,410,'2',''),(2200,410,'1','0'),(2209,410,'1','1'),(2218,419,'1',''),(2219,419,'2',''),(2236,419,'1',''),(2237,419,'2',''),(2254,428,'1',''),(2255,428,'2',''),(2274,428,'1','0'),(2275,428,'2',''),(2294,428,'1','1'),(2304,428,'1','3'),(2314,438,'1',''),(2315,438,'2',''),(2332,438,'1','0'),(2333,438,'2',''),(2350,438,'1',''),(2359,438,'1','2'),(2368,447,'1',''),(2369,447,'2',''),(2386,447,'1','0'),(2387,447,'2',''),(2404,447,'1',''),(2413,447,'1','2'),(2422,456,'1',''),(2423,456,'2',''),(2440,456,'1','0'),(2441,456,'2',''),(2458,456,'1','1'),(2467,456,'1','2'),(2476,456,'1','3'),(2485,456,'1','4'),(2494,456,'1','5'),(2503,456,'1','6'),(2512,456,'1','7'),(2521,456,'1','8'),(2530,456,'1','9'),(2539,465,'1',''),(2540,465,'2',''),(2557,465,'1','0'),(2558,465,'2',''),(2575,465,'1','1'),(2576,465,'2','0'),(2593,474,'1',''),(2594,474,'2',''),(2611,474,'1',''),(2612,474,'2','0'),(2629,474,'2','1'),(2638,474,'2','2'),(2647,474,'2','3'),(2656,474,'2','4'),(2665,474,'2','5'),(2674,474,'2','6'),(2683,474,'2','7'),(2692,474,'2','8'),(2701,474,'2','9'),(2710,483,'1',''),(2711,483,'2',''),(2728,483,'1','0'),(2729,483,'2','0'),(2746,483,'1','1'),(2747,483,'2','1'),(2764,483,'2','2'),(2773,483,'2','3'),(2782,483,'2','4'),(2791,483,'2','5'),(2800,483,'2','6'),(2809,483,'2','7'),(2818,483,'2','8'),(2827,483,'2','9'),(2836,492,'1',''),(2837,492,'2',''),(2854,492,'1','0'),(2855,492,'2','0'),(2872,492,'1','1'),(2873,492,'2','1'),(2890,492,'2','2'),(2899,492,'2','3'),(2908,492,'2','4'),(2917,492,'2','5'),(2926,492,'2','6'),(2935,492,'2','7'),(2944,492,'2','8'),(2953,492,'2','9'),(2962,501,'1',''),(2963,501,'2',''),(2982,501,'1','0'),(2983,501,'2','0'),(3002,501,'1','1'),(3003,501,'2','1'),(3022,501,'2','2'),(3032,501,'2','3'),(3042,501,'2','4'),(3052,501,'2','5'),(3062,501,'2','6'),(3072,501,'2','7'),(3082,501,'2','8'),(3092,501,'2','9'),(3102,511,'1',''),(3103,511,'2',''),(3120,511,'1','0'),(3121,511,'2',''),(3138,511,'1','1'),(3139,511,'2','0'),(3156,511,'1','2'),(3157,511,'2','1'),(3174,511,'1','3'),(3175,511,'2','2'),(3192,511,'2','3'),(3201,511,'2','4'),(3210,511,'2','5'),(3219,511,'2','6'),(3228,511,'2','7'),(3237,511,'2','8'),(3246,520,'1',''),(3247,520,'2',''),(3264,520,'1','0'),(3265,520,'2','0'),(3282,520,'1','1'),(3283,520,'2','1'),(3300,529,'1',''),(3301,529,'2',''),(3320,529,'1',''),(3321,529,'2',''),(3340,539,'1',''),(3341,539,'2',''),(3358,539,'1',''),(3359,539,'2',''),(3376,548,'1',''),(3377,548,'2',''),(3394,548,'1',''),(3395,548,'2',''),(3412,557,'1',''),(3413,557,'2',''),(3430,557,'1',''),(3431,557,'2',''),(3448,566,'1',''),(3449,566,'2',''),(3466,566,'1',''),(3467,566,'2',''),(3484,575,'1',''),(3485,575,'2',''),(3502,575,'1',''),(3503,575,'2',''),(3520,584,'1',''),(3521,584,'2',''),(3540,584,'1',''),(3541,584,'2',''),(3560,584,'1','2'),(3570,584,'1',''),(3580,594,'1',''),(3581,594,'2',''),(3598,594,'1',''),(3599,594,'2',''),(3616,603,'1',''),(3617,603,'2',''),(3634,603,'1',''),(3635,603,'2',''),(3652,603,'1','1'),(3653,603,'2','0'),(3670,603,'1','2'),(3671,603,'2','7'),(3688,612,'1',''),(3689,612,'2',''),(3708,612,'1',''),(3709,612,'2',''),(3728,622,'1',''),(3729,622,'2',''),(3746,622,'1',''),(3747,622,'2',''),(3764,631,'1',''),(3765,631,'2',''),(3782,631,'1',''),(3783,631,'2',''),(3800,631,'1','8'),(3809,640,'1',''),(3810,640,'2',''),(3827,640,'1',''),(3828,640,'2',''),(3845,649,'1',''),(3846,649,'2',''),(3863,649,'1',''),(3864,649,'2',''),(3881,658,'1',''),(3882,658,'2',''),(3899,658,'1',''),(3900,658,'2',''),(3917,667,'1',''),(3918,667,'2',''),(3935,667,'1','0'),(3936,667,'2','0'),(3953,667,'1','1'),(3954,667,'2','1'),(3971,667,'2','2'),(3980,667,'2','3'),(3989,667,'2','4'),(3998,667,'2','5'),(4007,667,'2','6'),(4016,667,'2','7'),(4025,667,'2','8'),(4034,676,'1',''),(4035,676,'2',''),(4052,676,'1',''),(4053,676,'2',''),(4070,685,'1',''),(4071,685,'2',''),(4088,685,'1',''),(4089,685,'2',''),(4106,694,'1',''),(4107,694,'2',''),(4124,694,'1',''),(4125,694,'2',''),(4142,703,'1',''),(4143,703,'2',''),(4160,703,'1','0'),(4161,703,'2',''),(4178,703,'1','1'),(4187,703,'1','2'),(4196,703,'1','3'),(4205,703,'1','4'),(4214,703,'1','5'),(4223,703,'1','8'),(4232,712,'1',''),(4233,712,'2',''),(4250,712,'1',''),(4251,712,'2',''),(4268,721,'1',''),(4269,721,'2',''),(4286,721,'1','0'),(4287,721,'2',''),(4304,721,'1','1'),(4313,730,'1',''),(4314,730,'2',''),(4331,730,'1',''),(4332,730,'2',''),(4349,739,'1',''),(4350,739,'2',''),(4367,739,'1',''),(4368,739,'2',''),(4385,748,'1',''),(4386,748,'2',''),(4403,748,'1','0'),(4404,748,'2',''),(4421,748,'1','1'),(4430,757,'1',''),(4431,757,'2',''),(4450,757,'1',''),(4451,757,'2',''),(4470,767,'1',''),(4471,767,'2',''),(4488,767,'1',''),(4489,767,'2',''),(4506,776,'1',''),(4507,776,'2',''),(4524,776,'1',''),(4525,776,'2',''),(4542,785,'1',''),(4543,785,'2',''),(4560,785,'1',''),(4561,785,'2',''),(4578,794,'1',''),(4579,794,'2',''),(4596,794,'1','0'),(4597,794,'2',''),(4614,794,'1','1'),(4615,794,'2','0'),(4632,794,'1','2'),(4641,794,'1','8'),(4650,803,'1',''),(4651,803,'2',''),(4668,803,'1',''),(4669,803,'2',''),(4686,803,'1','0'),(4695,803,'1','1'),(4704,812,'1',''),(4705,812,'2',''),(4722,812,'1',''),(4723,812,'2',''),(4740,821,'1',''),(4741,821,'2',''),(4758,821,'1',''),(4759,821,'2',''),(4776,830,'1',''),(4777,830,'2',''),(4794,830,'1','0'),(4795,830,'2',''),(4812,830,'1','1'),(4821,830,'1','2'),(4830,830,'1','3'),(4839,830,'1','4'),(4848,839,'1',''),(4849,839,'2',''),(4866,839,'1','0'),(4867,839,'2',''),(4884,839,'1','1'),(4893,848,'1',''),(4894,848,'2',''),(4911,848,'1',''),(4912,848,'2',''),(4929,857,'1',''),(4930,857,'2',''),(4947,857,'1',''),(4948,857,'2',''),(4965,866,'1',''),(4966,866,'2',''),(4983,866,'1',''),(4984,866,'2',''),(5001,875,'1',''),(5002,875,'2',''),(5019,875,'1',''),(5020,875,'2',''),(5037,875,'1','8'),(5046,884,'1',''),(5047,884,'2',''),(5064,884,'1',''),(5065,884,'2',''),(5082,893,'1',''),(5083,893,'2',''),(5100,893,'1',''),(5101,893,'2',''),(5118,893,'1','0'),(5127,893,'1','1'),(5136,893,'1','2'),(5145,893,'1','4'),(5154,893,'1','3'),(5163,893,'1','8'),(5172,902,'1',''),(5173,902,'2',''),(5190,902,'1',''),(5191,902,'2',''),(5208,902,'1','0'),(5217,902,'1','1'),(5226,902,'1','2'),(5235,902,'1','3'),(5244,902,'1','4'),(5253,902,'1','8'),(5262,911,'1',''),(5263,911,'2',''),(5280,911,'1',''),(5281,911,'2',''),(5298,911,'1','8'),(5307,920,'1',''),(5308,920,'2',''),(5325,920,'1',''),(5326,920,'2',''),(5343,920,'1','8'),(5352,929,'1',''),(5353,929,'2',''),(5370,929,'1',''),(5371,929,'2',''),(5388,938,'1',''),(5389,938,'2',''),(5406,938,'1','0'),(5407,938,'2',''),(5424,938,'1','8'),(5433,947,'1',''),(5434,947,'2',''),(5451,947,'1',''),(5452,947,'2',''),(5469,956,'1',''),(5470,956,'2',''),(5487,956,'1',''),(5488,956,'2',''),(5505,965,'1',''),(5506,965,'2',''),(5523,965,'1',''),(5524,965,'2',''),(5541,974,'1',''),(5542,974,'2',''),(5559,974,'1','1'),(5560,974,'2',''),(5577,974,'1','2'),(5586,983,'1',''),(5587,983,'2',''),(5604,983,'1',''),(5605,983,'2',''),(5622,992,'1',''),(5623,992,'2',''),(5640,992,'1',''),(5641,992,'2',''),(5658,1001,'1',''),(5659,1001,'2',''),(5676,1001,'1',''),(5677,1001,'2',''),(5694,1010,'1',''),(5695,1010,'2',''),(5712,1010,'1',''),(5713,1010,'2',''),(5730,1019,'1',''),(5731,1019,'2',''),(5748,1019,'1',''),(5749,1019,'2',''),(5766,1019,'1','0'),(5775,1019,'1','1'),(5784,1028,'1',''),(5785,1028,'2',''),(5802,1028,'1',''),(5803,1028,'2',''),(5820,1037,'1',''),(5821,1037,'2',''),(5838,1037,'1',''),(5839,1037,'2',''),(5856,1046,'1',''),(5857,1046,'2',''),(5874,1046,'1',''),(5875,1046,'2',''),(5892,1055,'1',''),(5893,1055,'2',''),(5910,1055,'1',''),(5911,1055,'2',''),(5928,1064,'1',''),(5929,1064,'2',''),(5946,1064,'2',''),(5955,1064,'1','8'),(5964,1073,'1',''),(5965,1073,'2',''),(5982,1073,'2',''),(5991,1073,'1','8'),(6000,1082,'1',''),(6001,1082,'2',''),(6018,1082,'1',''),(6019,1082,'2',''),(6036,1091,'1',''),(6037,1091,'2',''),(6054,1091,'1',''),(6055,1091,'2',''),(6072,1100,'1',''),(6073,1100,'2',''),(6090,1100,'1',''),(6091,1100,'2',''),(6108,1109,'1',''),(6109,1109,'2',''),(6126,1109,'1',''),(6127,1109,'2',''),(6144,1109,'1','0'),(6153,1109,'1','8'),(6162,1118,'1',''),(6163,1118,'2',''),(6180,1118,'1',''),(6181,1118,'2',''),(6198,1118,'1','8'),(6207,1127,'1',''),(6208,1127,'2',''),(6225,1127,'1',''),(6226,1127,'2',''),(6243,1136,'1',''),(6244,1136,'2',''),(6261,1136,'1',''),(6262,1136,'2',''),(6279,1136,'1','8'),(6288,1145,'1',''),(6289,1145,'2',''),(6306,1145,'1',''),(6307,1145,'2',''),(6324,1154,'1',''),(6325,1154,'2',''),(6342,1154,'1',''),(6343,1154,'2',''),(6360,1163,'1',''),(6361,1163,'2',''),(6378,1163,'1',''),(6379,1163,'2',''),(6396,1172,'1',''),(6397,1172,'2',''),(6414,1172,'1',''),(6415,1172,'2',''),(6432,1172,'1','8'),(6441,1181,'1',''),(6442,1181,'2',''),(6459,1181,'1','0'),(6460,1181,'2',''),(6477,1181,'1','1'),(6478,1181,'2','1'),(6495,1181,'1','2'),(6496,1181,'2','2'),(6513,1181,'2','3'),(6522,1181,'2','4'),(6531,1181,'2','5'),(6540,1181,'2','6'),(6549,1181,'2','7'),(6558,1190,'1',''),(6559,1190,'2',''),(6576,1190,'1','0'),(6577,1190,'2','0'),(6594,1190,'1','1'),(6595,1190,'2','1'),(6612,1190,'1','2'),(6613,1190,'2','2'),(6630,1190,'2','3'),(6639,1190,'2','4'),(6648,1190,'2','5'),(6657,1190,'2','6'),(6666,1190,'2','7'),(6675,1199,'1',''),(6676,1199,'2',''),(6693,1199,'1','0'),(6694,1199,'2','0'),(6711,1199,'1','1'),(6712,1199,'2','1'),(6729,1199,'1','2'),(6730,1199,'2','2'),(6747,1199,'2','3'),(6756,1199,'2','4'),(6765,1199,'2','5'),(6774,1199,'2','6'),(6783,1199,'2','7'),(6792,1208,'1',''),(6793,1208,'2',''),(6810,1208,'1','0'),(6811,1208,'2','0'),(6828,1208,'1','1'),(6829,1208,'2','1'),(6846,1208,'1','2'),(6847,1208,'2','2'),(6864,1208,'1','3'),(6865,1208,'2','3'),(6882,1208,'1','4'),(6883,1208,'2','4'),(6900,1208,'1','5'),(6901,1208,'2','5'),(6918,1208,'1','6'),(6919,1208,'2','6'),(6936,1208,'1','7'),(6937,1208,'2','7'),(6954,1208,'1','8'),(6963,1208,'1','9'),(6972,1217,'1',''),(6973,1217,'2',''),(6990,1217,'1',''),(6991,1217,'2','0'),(7008,1217,'2','1'),(7017,1217,'2','2'),(7026,1217,'2','3'),(7035,1217,'2','4'),(7044,1217,'2','5'),(7053,1217,'2','6'),(7062,1217,'2','7'),(7071,1226,'1',''),(7072,1226,'2',''),(7089,1226,'1',''),(7090,1226,'2','0'),(7107,1226,'1','0'),(7108,1226,'2','1'),(7125,1226,'1','1'),(7126,1226,'2','2'),(7143,1226,'1','2'),(7144,1226,'2','3'),(7161,1226,'2','4'),(7170,1226,'2','5'),(7179,1226,'2','6'),(7188,1226,'2','7'),(7197,1235,'1',''),(7198,1235,'2',''),(7215,1235,'1',''),(7216,1235,'2','0'),(7233,1235,'2','1'),(7242,1235,'2','2'),(7251,1235,'2','3'),(7260,1235,'2','4'),(7269,1235,'2','5'),(7278,1235,'2','6'),(7287,1235,'2','7'),(7296,1244,'1',''),(7297,1244,'2',''),(7314,1244,'1',''),(7315,1244,'2',''),(7332,1244,'1','0'),(7333,1244,'2','0'),(7350,1244,'1','1'),(7351,1244,'2','1'),(7368,1244,'1','2'),(7369,1244,'2','2'),(7386,1244,'2','3'),(7395,1244,'2','4'),(7404,1244,'2','5'),(7413,1244,'2','6'),(7422,1253,'1',''),(7423,1253,'2',''),(7440,1253,'1',''),(7441,1253,'2',''),(7458,1253,'1','0'),(7467,1253,'1','1'),(7476,1253,'1','2'),(7485,1262,'1',''),(7486,1262,'2',''),(7503,1262,'1',''),(7504,1262,'2','0'),(7521,1262,'1','0'),(7522,1262,'2','1'),(7539,1262,'2','2'),(7548,1262,'2','3'),(7557,1262,'2','4'),(7566,1262,'2','5'),(7575,1262,'2','6'),(7584,1262,'2','7'),(7593,1271,'1',''),(7594,1271,'2',''),(7611,1271,'1',''),(7612,1271,'2','7'),(7629,1280,'1',''),(7630,1280,'2',''),(7647,1280,'1',''),(7648,1280,'2','7'),(7665,1289,'1',''),(7666,1289,'2',''),(7683,1289,'1',''),(7684,1289,'2',''),(7701,1298,'1',''),(7702,1298,'2',''),(7719,1298,'1',''),(7720,1298,'2',''),(7737,1307,'1',''),(7738,1307,'2',''),(7755,1307,'1','0'),(7756,1307,'2',''),(7773,1307,'1','1'),(7774,1307,'2','2'),(7791,1307,'1','3'),(7800,1316,'1',''),(7801,1316,'2',''),(7818,1316,'1','0'),(7819,1316,'2',''),(7836,1316,'1','1'),(7837,1316,'2','2'),(7854,1316,'1','2'),(7863,1325,'1',''),(7864,1325,'2',''),(7881,1325,'1','0'),(7882,1325,'2',''),(7899,1325,'1','1'),(7900,1325,'2','2'),(7917,1325,'1','2'),(7926,1334,'1',''),(7927,1334,'2',''),(7944,1334,'1',''),(7945,1334,'2',''),(7962,1334,'1','1'),(7971,1334,'1','2'),(7980,1343,'1',''),(7981,1343,'2',''),(7998,1343,'1','0'),(7999,1343,'2',''),(8016,1343,'1','1'),(8017,1343,'2','2'),(8034,1343,'1','2'),(8043,1343,'1','3'),(8052,1343,'1','4'),(8061,1343,'1','5'),(8070,1343,'1','6'),(8079,1343,'1','7'),(8088,1343,'1','8'),(8097,1343,'1','9'),(8106,1352,'1',''),(8107,1352,'2',''),(8124,1352,'1','0'),(8125,1352,'2',''),(8142,1352,'1','1'),(8143,1352,'2','2'),(8160,1352,'1','2'),(8169,1352,'1','3'),(8178,1352,'1','4'),(8187,1352,'1','5'),(8196,1352,'1','6'),(8205,1352,'1','7'),(8214,1352,'1','8'),(8223,1352,'1','9'),(8232,1361,'1',''),(8233,1361,'2',''),(8250,1361,'1',''),(8251,1361,'2',''),(8268,1370,'1',''),(8269,1370,'2',''),(8286,1370,'1',''),(8287,1370,'2',''),(8304,1379,'1',''),(8305,1379,'2',''),(8322,1379,'1',''),(8323,1379,'2',''),(8340,1388,'1',''),(8341,1388,'2',''),(8358,1388,'1','0'),(8359,1388,'2',''),(8376,1388,'1','1'),(8377,1388,'2','8'),(8394,1397,'1',''),(8395,1397,'2',''),(8412,1397,'1','0'),(8413,1397,'2',''),(8430,1397,'1','1'),(8431,1397,'2','8'),(8448,1406,'1',''),(8449,1406,'2',''),(8466,1406,'1','0'),(8467,1406,'2',''),(8484,1406,'1','1'),(8485,1406,'2','8'),(8502,1415,'1',''),(8503,1415,'2',''),(8520,1415,'1','0'),(8521,1415,'2',''),(8538,1415,'1','1'),(8539,1415,'2','8'),(8556,1424,'1',''),(8557,1424,'2',''),(8574,1424,'1','0'),(8575,1424,'2',''),(8592,1424,'1','1'),(8593,1424,'2','8'),(8610,1433,'1',''),(8611,1433,'2',''),(8628,1433,'1','0'),(8629,1433,'2',''),(8646,1433,'1','1'),(8647,1433,'2','0'),(8664,1433,'2','8'),(8673,1442,'1',''),(8674,1442,'2',''),(8691,1442,'1','0'),(8692,1442,'2',''),(8709,1442,'1','1'),(8710,1442,'2','8'),(8727,1451,'1',''),(8728,1451,'2',''),(8745,1451,'1','0'),(8746,1451,'2',''),(8763,1451,'1','1'),(8764,1451,'2','8'),(8781,1460,'1',''),(8782,1460,'2',''),(8799,1460,'1','0'),(8800,1460,'2',''),(8817,1460,'1','1'),(8818,1460,'2','8'),(8835,1469,'1',''),(8836,1469,'2',''),(8853,1469,'1','0'),(8854,1469,'2',''),(8871,1469,'1','1'),(8872,1469,'2','8'),(8889,1478,'1',''),(8890,1478,'2',''),(8907,1478,'1','0'),(8908,1478,'2',''),(8925,1478,'1','1'),(8926,1478,'2','8'),(8943,1487,'1',''),(8944,1487,'2',''),(8961,1487,'1','0'),(8962,1487,'2','0'),(8979,1487,'1','1'),(8980,1487,'2','1'),(8997,1487,'2','2'),(9006,1487,'2','3'),(9015,1487,'2',''),(9024,1487,'2','5'),(9033,1487,'2','6'),(9042,1487,'2','7'),(9051,1496,'1',''),(9052,1496,'2',''),(9069,1496,'1','0'),(9070,1496,'2','0'),(9087,1496,'1','1'),(9088,1496,'2','1'),(9105,1496,'2','2'),(9114,1496,'2','3'),(9123,1496,'2','4'),(9132,1496,'2','5'),(9141,1496,'2','6'),(9150,1496,'2','7'),(9159,1496,'2','8'),(9168,1505,'1',''),(9169,1505,'2',''),(9186,1505,'1','0'),(9187,1505,'2',''),(9204,1505,'1','1'),(9205,1505,'2','8'),(9222,1514,'1',''),(9223,1514,'2',''),(9240,1514,'1','0'),(9241,1514,'2',''),(9258,1514,'1','1'),(9259,1514,'2','8'),(9276,1523,'1',''),(9277,1523,'2',''),(9294,1523,'1','0'),(9295,1523,'2',''),(9312,1523,'1','1'),(9321,1523,'1','2'),(9330,1532,'1',''),(9331,1532,'2',''),(9348,1532,'1','0'),(9349,1532,'2',''),(9366,1532,'1','1'),(9375,1532,'1','2'),(9384,1541,'2',''),(9393,1541,'1','0'),(9394,1541,'2',''),(9411,1541,'1','1'),(9420,1541,'1','2'),(9429,1550,'1',''),(9430,1550,'2',''),(9447,1550,'1',''),(9448,1550,'2','0'),(9465,1550,'2','1'),(9474,1550,'2','2'),(9483,1550,'2','3'),(9492,1550,'2','4'),(9501,1550,'2','5'),(9510,1550,'2','6'),(9519,1550,'2','7'),(9528,1550,'2','8'),(9537,1550,'2','9'),(9546,1559,'1',''),(9547,1559,'2',''),(9564,1559,'1',''),(9565,1559,'2',''),(9582,1568,'1',''),(9583,1568,'2',''),(9600,1568,'1',''),(9601,1568,'2',''),(9618,1577,'1',''),(9619,1577,'2',''),(9636,1577,'1',''),(9637,1577,'2',''),(9654,1586,'1',''),(9655,1586,'2',''),(9672,1586,'1',''),(9673,1586,'2',''),(9690,1595,'1',''),(9691,1595,'2',''),(9708,1595,'1',''),(9709,1595,'2',''),(9726,1604,'1',''),(9727,1604,'2',''),(9744,1604,'1',''),(9745,1604,'2',''),(9762,1613,'1',''),(9763,1613,'2',''),(9780,1613,'1',''),(9781,1613,'2',''),(9798,1613,'1','0'),(9799,1613,'2','0'),(9816,1613,'1','1'),(9817,1613,'2','1'),(9834,1613,'1','2'),(9835,1613,'2','2'),(9852,1613,'1','3'),(9861,1613,'1','4'),(9870,1613,'1','5'),(9879,1613,'1','6'),(9888,1613,'1','7'),(9897,1613,'1','8'),(9906,1622,'1',''),(9907,1622,'2',''),(9924,1622,'1','0'),(9925,1622,'2','0'),(9942,1622,'1','1'),(9943,1622,'2','1'),(9960,1622,'1','2'),(9961,1622,'2','2'),(9978,1622,'1','3'),(9979,1622,'2','3'),(9996,1631,'1',''),(9997,1631,'2',''),(10014,1631,'1','0'),(10015,1631,'2','0'),(10032,1631,'1','1'),(10033,1631,'2','1'),(10050,1631,'1','2'),(10051,1631,'2','2'),(10068,1631,'1','3'),(10069,1631,'2','3'),(10086,1640,'1',''),(10087,1640,'2',''),(10104,1640,'1',''),(10105,1640,'2',''),(10122,1649,'1',''),(10123,1649,'2',''),(10140,1649,'1',''),(10141,1649,'2',''),(10158,1649,'1','0'),(10159,1649,'2','0'),(10176,1649,'1','1'),(10177,1649,'2','1'),(10194,1649,'1','2'),(10195,1649,'2','2'),(10212,1649,'1','3'),(10213,1649,'2','8'),(10230,1649,'1','4'),(10239,1649,'1','7'),(10248,1658,'1',''),(10249,1658,'2',''),(10266,1658,'1',''),(10267,1658,'2',''),(10284,1658,'1','3'),(10285,1658,'2','0'),(10302,1658,'1','4'),(10303,1658,'2','1'),(10320,1658,'1','5'),(10321,1658,'2','2'),(10338,1658,'2','3'),(10347,1658,'2','4'),(10356,1667,'1',''),(10357,1667,'2',''),(10374,1667,'1',''),(10375,1667,'2',''),(10392,1667,'1','3'),(10393,1667,'2','0'),(10410,1667,'1','4'),(10411,1667,'2','1'),(10428,1667,'1','5'),(10429,1667,'2','2'),(10446,1667,'2','3'),(10455,1667,'2','4'),(10464,1676,'1',''),(10465,1676,'2',''),(10482,1676,'1',''),(10483,1676,'2',''),(10500,1676,'1','4'),(10501,1676,'2','1'),(10518,1676,'1','5'),(10519,1676,'2','3'),(10536,1685,'1',''),(10537,1685,'2',''),(10554,1685,'1',''),(10555,1685,'2','0'),(10572,1685,'1','3'),(10573,1685,'2','1'),(10590,1685,'1','4'),(10591,1685,'2','2'),(10608,1685,'1','5'),(10609,1685,'2','7'),(10626,1694,'1',''),(10627,1694,'2',''),(10644,1694,'1',''),(10645,1694,'2','0'),(10662,1694,'1','3'),(10663,1694,'2','1'),(10680,1694,'1','4'),(10681,1694,'2','2'),(10698,1694,'1','5'),(10699,1694,'2','7'),(10716,1703,'1',''),(10717,1703,'2',''),(10734,1703,'1',''),(10735,1703,'2','0'),(10752,1703,'1','3'),(10753,1703,'2','1'),(10770,1703,'1','4'),(10771,1703,'2','2'),(10788,1703,'1','5'),(10789,1703,'2','7'),(10806,1712,'1',''),(10807,1712,'2',''),(10824,1712,'1',''),(10825,1712,'2',''),(10842,1721,'1',''),(10843,1721,'2',''),(10860,1721,'1',''),(10861,1721,'2',''),(10878,1730,'1',''),(10879,1730,'2',''),(10896,1730,'1',''),(10897,1730,'2',''),(10914,1739,'1',''),(10915,1739,'2',''),(10932,1748,'1',''),(10933,1748,'2',''),(10950,1748,'1','0'),(10951,1748,'2',''),(10968,1748,'1','1'),(10977,1748,'1','2'),(10986,1757,'1',''),(10987,1757,'2',''),(11004,1757,'1',''),(11005,1757,'2',''); + + +-- +-- Dumping data for table marc_indicators_desc +-- + +INSERT INTO marc_indicators_desc VALUES (1,'en','Undefined'),(2,'en','Undefined'),(21,'en','Undefined'),(22,'en','Undefined'),(41,'en','Undefined'),(42,'en','Undefined'),(59,'en','Undefined'),(60,'en','Undefined'),(77,'en','Undefined'),(78,'en','Undefined'),(95,'en','Undefined'),(96,'en','Undefined'),(113,'en','National bibliographic agency'),(114,'en','Undefined'),(131,'en','Library and Archives Canada'),(132,'en','Undefined'),(149,'en','Source specified in subfield $2. Used when the source of the control number is indicated by a code in subfield $2. Codes from : MARC Code List for Organizations'),(158,'en','Undefined'),(159,'en','Undefined'),(176,'en','Undefined'),(177,'en','Undefined'),(194,'en','Undefined'),(195,'en','Undefined'),(212,'en','Undefined'),(213,'en','Undefined'),(230,'en','Undefined'),(231,'en','Undefined'),(250,'en','Undefined'),(251,'en','Undefined'),(270,'en','Level of international interest'),(271,'en','Undefined'),(290,'en','No level specified'),(291,'en','Undefined'),(310,'en','Continuing resource of international interest'),(320,'en','Continuing resource not of international interest'),(330,'en','Type of standard number or code'),(331,'en','Difference indicator'),(348,'en','International Standard Recording Code'),(349,'en','No information provided'),(366,'en','Universal Product Code'),(367,'en','No difference'),(384,'en','International Standard Music Number'),(385,'en','Difference'),(402,'en','International Article Number'),(411,'en','Serial Item and Contribution Identifier'),(420,'en','Source specified in sufield $2'),(429,'en','Unspecified type of starndard number or code'),(438,'en','Undefined'),(439,'en','Undefined'),(456,'en','Undefined'),(457,'en','Undefined'),(474,'en','Undefined'),(475,'en','Undefined'),(492,'en','Undefined'),(493,'en','Undefined'),(510,'en','Undefined'),(511,'en','Undefined'),(528,'en','Undefined'),(529,'en','Undefined'),(546,'en','Type of publisher number'),(547,'en','Note/added entry controller'),(564,'en','Issue number. Number used to indentify the issue designation, or serial identifiation, assigned by a publisher to a specific sound recording, side of a sound recording, or performance on a sound recording or to a group of sound recording issued as a set.'),(565,'en','No note, no added entry'),(582,'en','Matrix number. Master from witch the specific recording was pressed.'),(583,'en','Note, added entry'),(600,'en','Plate number. Assigned by a publisher to a specific music publication.'),(601,'en','Note, no added entry'),(618,'en','Other music number'),(619,'en','No note, added entry'),(636,'en','Videorecording number'),(645,'en','Other publisher number'),(654,'en','Undefined'),(655,'en','Undefined'),(672,'en','Undefined'),(673,'en','Undefined'),(690,'en','Undefined'),(691,'en','Undefined'),(708,'en','Undefined'),(709,'en','#- Undefined'),(726,'en','Undefined'),(727,'en','Undefined'),(744,'en','# -Undefined'),(745,'en','Undefined'),(762,'en','Type of date in subfield $a'),(763,'en','Type of event'),(780,'en','No date information'),(781,'en','No information provided'),(798,'en','Single date'),(799,'en','Capture. Pertains to the recording of sound, the filming of visual images, the making or producing of a item, or other form of creation of an item'),(816,'en','Multiple single dates'),(817,'en','Broadcast. Pertains to the broadcasting (i.e., transmission) or re-boardcasting of sound or visual images.'),(834,'en','Range of dates'),(835,'en','Finding. Pertains to the finding of a naturally ocurring object.'),(852,'en','Type of scale Specifies the type of scale information given'),(853,'en','Type of ring'),(870,'en','Scale indeterminable/No scale recorded. Used when no representative fraction is given in field 255.'),(871,'en','Not applicable'),(888,'en','Single scale'),(889,'en','Outer ring'),(906,'en','Range of scales'),(907,'en','Exclusion ring'),(924,'en','Undefined'),(925,'en','Undefined'),(942,'en','Undefined'),(943,'en','Undefined'),(960,'en','Undefined'),(961,'en','Undefined'),(978,'en','Undefined'),(979,'en','Undefined'),(996,'en','Undefined'),(997,'en','Undefined'),(1014,'en','# -Undefined'),(1015,'en','Undefined'),(1032,'en','Undefined'),(1033,'en','Undefined'),(1050,'en','# -Undefined'),(1051,'en','Undefined'),(1068,'en','Undefined'),(1069,'en','Undefined'),(1086,'en','Undefined'),(1087,'en','Undefined'),(1104,'en','Translation indication'),(1105,'en','Source of code'),(1122,'en','Item not a translation/ does not include a translation'),(1123,'en','MARC language code'),(1140,'en','Item is or includes a translation'),(1141,'en','Source specified in subfield $2'),(1158,'en','Undefined'),(1159,'en','Undefined'),(1176,'en','Undefined'),(1177,'en','Undefined'),(1194,'en','Undefined'),(1195,'en','Undefined'),(1212,'en','Undefined'),(1213,'en','Undefined'),(1230,'en','Undefined'),(1231,'en','Undefined'),(1248,'en','Undefined'),(1249,'en','Undefined'),(1266,'en','Type of time period in subfield $b or $c'),(1267,'en','Undefined'),(1284,'en','Subfield $b or $c not present'),(1285,'en','Undefined'),(1302,'en','Single date/time'),(1311,'en','Multiple sigle dates/times. Multiple $b and/or $c subfields are present, each containing a date/time.'),(1320,'en','Range of dates/times. Two $b and/or $c subfields are present and contain a range of dates/times'),(1329,'en','Undefined'),(1330,'en','Undefined'),(1347,'en','Undefined'),(1348,'en','Undefined'),(1365,'en','Undefined'),(1366,'en','Undefined'),(1383,'en','# -Undefined'),(1384,'en','Undefined'),(1401,'en','Undefined'),(1402,'en','Undefined'),(1419,'en','Undefined'),(1420,'en','Undefined'),(1437,'en','Existence in LC collection'),(1438,'en','Source of call number'),(1457,'en','No information provided. Used for all call numbers assigned by agencies other than the Library of Congress'),(1458,'en','Assigned by LC. Used when an institution is transcribing from lC cataloging copy.'),(1477,'en','Item is in LC. Other agencies should use this value when transcribing from LC cataloging copy on which the call number is neither enclosed within brackets nor preceded by a Maltese cross'),(1478,'en','Assigned by agency other than LC.'),(1497,'en','Item is not in LC. Used by other agencies when transcribing from LC copy on the call number appears in brackets or is preceded by a Maltese cross. Brackets that customarily surround call numbers for items not in LC are not carried in the MARC record; they may be generated for display.'),(1507,'en','Undefined'),(1508,'en','Undefined'),(1525,'en','Undefined'),(1526,'en','Undefined'),(1543,'en','Code source'),(1544,'en','Undefined'),(1561,'en','Library of Congress Classification'),(1562,'en','Undefined'),(1579,'en','U.S. Dept. of Defense Classification'),(1588,'en','Source specified in subfield $2'),(1597,'en','Existence in LAC collection'),(1598,'en','Type, completeness, source of class/call number'),(1615,'en','Information not provided. Used in any record input by an institution other than LAC.'),(1616,'en','LC - based call number assigned by LAC'),(1633,'en','Work held by LAC'),(1634,'en','Complete LC class number assigned by LAC'),(1651,'en','Work not held by LAC'),(1652,'en','Incomplete LC class number asigned by LAC'),(1669,'en','LC- based call number assigned by the contibuting library'),(1678,'en','4 -Complete LC class number assigned by the contributing library'),(1687,'en','Incomplete LC class number assigned by de contributing library'),(1696,'en','Other call number assigned by LAC'),(1705,'en','Other class number assigned by LAC'),(1714,'en','Other call number assigned by the contributing library'),(1723,'en','Other class number assigned by the contributing library'),(1732,'en','Existence in NLM collection'),(1733,'en','Source of call number'),(1750,'en','# -No information provided. Used for call numbers assigned by an organization other than NLM'),(1751,'en','Assigned by NLM'),(1768,'en','Item is in NLM'),(1769,'en','Assigned by agency other than NLM'),(1786,'en','Item is not in NLM'),(1795,'en','Undefined'),(1796,'en','Undefined'),(1813,'en','Undefined'),(1814,'en','Undefined'),(1831,'en','Undefined'),(1832,'en','Undefined'),(1849,'en','# -Undefined'),(1850,'en','Undefined'),(1867,'en','Existence in NAL collection'),(1868,'en','Undefined'),(1885,'en','Item is in NAL'),(1886,'en','Undefined'),(1903,'en','Item is not in NAL'),(1912,'en','Undefined'),(1913,'en','Undefined'),(1930,'en','Undefined'),(1931,'en','# -Undefined'),(1948,'en','Undefined'),(1949,'en','Code source'),(1966,'en','Undefined'),(1967,'en','0 -NAL subject category code list'),(1984,'en','Source specified in subfield $2'),(1993,'en','Undefined'),(1994,'en','Undefined'),(2011,'en','Undefined'),(2012,'en','# -Undefined'),(2029,'en','Undefined'),(2030,'en','Undefined'),(2047,'en','Undefined'),(2048,'en','Undefined'),(2065,'en','Type of edition'),(2066,'en','Source of classification number'),(2083,'en','Full edition'),(2084,'en','No information provided'),(2101,'en','Abridged edition'),(2102,'en','Assigned by LC. May be used by organizations transcribing from LC copy'),(2119,'en','Assigned by agency other than LC'),(2128,'en','Undefined'),(2129,'en','Undefined'),(2146,'en','Undefined'),(2147,'en','Undefined'),(2164,'en','Number source'),(2165,'en','Undefined'),(2182,'en','Source specified in subfield $2. Classification number other than the U.S. or Canadian scheme'),(2183,'en','Undefined'),(2200,'en','Superintendent of Documents Classification System. Assigned by the U.S. Government Printing Office. Supt.of Docs.no.: may be generated for display'),(2209,'en','Government of Canada Publications: Outline of Classification'),(2218,'en','Undefined'),(2219,'en','Undefined'),(2236,'en','Undefined'),(2237,'en','# -Undefined'),(2254,'en','Type of personal name entry element'),(2255,'en','Undefined'),(2274,'en','Forename. Forename or a name consisting of words, initials, letters,etc., that are formatted in direc order'),(2275,'en','Undefined'),(2294,'en','Surname. Single or multiple surname formatted in inverted order or a single name without forenames that is known to be a surname.'),(2304,'en','Family name. Name represents a family, clan, dynasty, house, or other such group and may be formatted in direct or inverted order.'),(2314,'en','Type of corporate name entry element'),(2315,'en','Undefined'),(2332,'en','Inverted name. Corporate name begins with a personal name in inverted order.'),(2333,'en','Undefined'),(2350,'en','1- Jurisdiction name. Name of a jurisdiction that is also an ecclesiastical entity or is a jurisdiction name under which a corporate name or a title of a work is entered.'),(2359,'en','Name in direct order.'),(2368,'en','Type of meeting name entry element'),(2369,'en','Undefined'),(2386,'en','Inverted name. Meeting name begins with a personal name in inverted order.'),(2387,'en','Undefined'),(2404,'en','1 -Jurisdiction name. Jurisdiction name under which a meeting name is entered'),(2413,'en','Name in direct order'),(2422,'en','Nonfiling characters'),(2423,'en','Undefined'),(2440,'en','Number of nonfiling characters'),(2441,'en','Undefined'),(2458,'en','Number of nonfiling characters'),(2467,'en','Number of nonfiling characters'),(2476,'en','Number of nonfiling characters'),(2485,'en','Number of nonfiling characters'),(2494,'en','Number of nonfiling characters'),(2503,'en','Number of nonfiling characters'),(2512,'en','Number of nonfiling characters'),(2521,'en','Number of nonfiling characters'),(2530,'en','Number of nonfiling characters'),(2539,'en','Title added entry'),(2540,'en','Type'),(2557,'en','No added entry'),(2558,'en','Abbreviated key title'),(2575,'en','Added entry'),(2576,'en','Other abbreviated title'),(2593,'en','Undefined'),(2594,'en','Nonfiling characters'),(2611,'en','Undefined'),(2612,'en','No nonfiling characters'),(2629,'en','Number of nonfiling characters'),(2638,'en','Number of nonfiling characters'),(2647,'en','Number of nonfiling characters'),(2656,'en','Number of nonfiling characters'),(2665,'en','Number of nonfiling characters'),(2674,'en','Number of nonfiling characters'),(2683,'en','Number of nonfiling characters'),(2692,'en','Number of nonfiling characters'),(2701,'en','Number of nonfiling characters'),(2710,'en','Uniform title printed or displayed'),(2711,'en','Nonfiling characters'),(2728,'en','Not printed or displayed'),(2729,'en','Number of nonfiling characters'),(2746,'en','Printed or displayed'),(2747,'en','Number of nonfiling characters'),(2764,'en','Number of nonfiling characters'),(2773,'en','Number of nonfiling characters'),(2782,'en','Number of nonfiling characters'),(2791,'en','Number of nonfiling characters'),(2800,'en','Number of nonfiling characters'),(2809,'en','Number of nonfiling characters'),(2818,'en','Number of nonfiling characters'),(2827,'en','Number of nonfiling characters'),(2836,'en','Title added entry'),(2837,'en','Nonfiling characters'),(2854,'en','No added entry'),(2855,'en','No nonfiling characters'),(2872,'en','Added entry'),(2873,'en','Number of nonfiling characters'),(2890,'en','Number of nonfiling characters'),(2899,'en','Number of nonfiling characters'),(2908,'en','Number of nonfiling characters'),(2917,'en','Number of nonfiling characters'),(2926,'en','Number of nonfiling characters'),(2935,'en','Number of nonfiling characters'),(2944,'en','Number of nonfiling characters'),(2953,'en','Number of nonfiling characters'),(2962,'en','Title added entry'),(2963,'en','Nonfiling characters'),(2982,'en','No added entry. No title added entry is made, either because no title added entry is desired or because the title added entry is not traced the same as the title in field 245'),(2983,'en','No nonfiling characters'),(3002,'en','Added entry. Desired title added entry is the same as the title in field 245'),(3003,'en','Number of nonfiling characters'),(3022,'en','Number of nonfiling characters'),(3032,'en','Number of nonfiling characters'),(3042,'en','Number of nonfiling characters'),(3052,'en','Number of nonfiling characters'),(3062,'en','Number of nonfiling characters'),(3072,'en','Number of nonfiling characters'),(3082,'en','Number of nonfiling characters'),(3092,'en','Number of nonfiling characters'),(3102,'en','Note/added entry controller'),(3103,'en','Type of title'),(3120,'en','Note, no added entry'),(3121,'en','No type specified'),(3138,'en','Note, added entry'),(3139,'en','Portion of title'),(3156,'en','No note, no added entry'),(3157,'en','Parallel title'),(3174,'en','No note, added entry'),(3175,'en','Distintictive title'),(3192,'en','Other title'),(3201,'en','Cover title'),(3210,'en','Added title page title'),(3219,'en','Caption title'),(3228,'en','Running title'),(3237,'en','Spine title'),(3246,'en','Title added entry'),(3247,'en','Note controller'),(3264,'en','No added entry'),(3265,'en','Display note'),(3282,'en','Added entry'),(3283,'en','Do not display note'),(3300,'en','Undefined'),(3301,'en','Undefined'),(3320,'en','Undefined'),(3321,'en','Undefined'),(3340,'en','Undefined'),(3341,'en','Undefined'),(3358,'en','Undefined'),(3359,'en','Undefined'),(3376,'en','Undefined'),(3377,'en','Undefined'),(3394,'en','Undefined'),(3395,'en','Undefined'),(3412,'en','Undefined'),(3413,'en','Undefined'),(3430,'en','Undefined'),(3431,'en','Undefined'),(3448,'en','Undefined'),(3449,'en','Undefined'),(3466,'en','Undefined'),(3467,'en','Undefined'),(3484,'en','Undefined'),(3485,'en','Undefined'),(3502,'en','Undefined'),(3503,'en','Undefined'),(3520,'en','Sequence of publishing statements'),(3521,'en','Undefined'),(3540,'en','Not applicable/ No information provided/ Earliest available publisher'),(3541,'en','Undefined'),(3560,'en','Intervening publisher'),(3570,'en','3- Current/latest publisher'),(3580,'en','Undefined'),(3581,'en','Undefined'),(3598,'en','# -Undefined'),(3599,'en','# -Undefined'),(3616,'en','Level'),(3617,'en','Type of address'),(3634,'en','No level specified'),(3635,'en','No type specified'),(3652,'en','Primary'),(3653,'en','Mailing'),(3670,'en','Secondary'),(3671,'en','Type specified in subfield $i'),(3688,'en','Undefined'),(3689,'en','Undefined'),(3708,'en','# -Undefined'),(3709,'en','# -Undefined'),(3728,'en','Undefined'),(3729,'en','Undefined'),(3746,'en','Undefined'),(3747,'en','Undefined'),(3764,'en','Display constant controller'),(3765,'en','Undefined'),(3782,'en','Hours'),(3783,'en','Undefined'),(3800,'en','No display constant generated'),(3809,'en','Undefined'),(3810,'en','Undefined'),(3827,'en','Undefined'),(3828,'en','Undefined'),(3845,'en','Undefined'),(3846,'en','Undefined'),(3863,'en','Undefined'),(3864,'en','Undefined'),(3881,'en','Undefined'),(3882,'en','Undefined'),(3899,'en','Undefined'),(3900,'en','Undefined'),(3917,'en','Geospatial reference dimension'),(3918,'en','Geospatial reference method'),(3935,'en','Horizontal coordinate system'),(3936,'en','Geographic'),(3953,'en','Vertical coordinate system'),(3954,'en','Map projection'),(3971,'en','Grid coordinate system'),(3980,'en','Local planar'),(3989,'en','Local'),(3998,'en','Geodentic model'),(4007,'en','Altitude'),(4016,'en','Method specified in $2'),(4025,'en','Depth'),(4034,'en','Undefined'),(4035,'en','Undefined'),(4052,'en','# -Undefined'),(4053,'en','# -Undefined'),(4070,'en','Undefined'),(4071,'en','Undefined'),(4088,'en','Undefined'),(4089,'en','Undefined'),(4106,'en','Undefined'),(4107,'en','Undefined'),(4124,'en','Undefined'),(4125,'en','# -Undefined'),(4142,'en','Controlled element'),(4143,'en','Undefined'),(4160,'en','Document'),(4161,'en','Undefined'),(4178,'en','Title'),(4187,'en','Abstract'),(4196,'en','Contents note'),(4205,'en','Author'),(4214,'en','Record'),(4223,'en','None of the above'),(4232,'en','Undefined'),(4233,'en','Undefined'),(4250,'en','# -Undefined'),(4251,'en','Undefined'),(4268,'en','Format of date'),(4269,'en','Undefined'),(4286,'en','Formatted style'),(4287,'en','Undefined'),(4304,'en','Unformatted note'),(4313,'en','Undefined'),(4314,'en','Undefined'),(4331,'en','Undefined'),(4332,'en','Undefined'),(4349,'en','Undefined'),(4350,'en','Undefined'),(4367,'en','Undefined'),(4368,'en','Undefined'),(4385,'en','Series tracing policy'),(4386,'en','Undefined'),(4403,'en','Series not traced'),(4404,'en','Undefined'),(4421,'en','Series traced'),(4430,'en','Undefined'),(4431,'en','Undefined'),(4450,'en','Undefined'),(4451,'en','Undefined'),(4470,'en','Undefined'),(4471,'en','Undefined'),(4488,'en','Undefined'),(4489,'en','Undefined'),(4506,'en','Undefined'),(4507,'en','Undefined'),(4524,'en','Undefined'),(4525,'en','Undefined'),(4542,'en','Undefined'),(4543,'en','Undefined'),(4560,'en','Undefined'),(4561,'en','Undefined'),(4578,'en','Display constant controller'),(4579,'en','Level of content designation'),(4596,'en','Contents'),(4597,'en','Basic'),(4614,'en','Incomplete contents'),(4615,'en','Enhanced'),(4632,'en','Partial contents'),(4641,'en','No display constant generated'),(4650,'en','Restriction'),(4651,'en','Undefined'),(4668,'en','No information provided'),(4669,'en','Undefined'),(4686,'en','No restrictions'),(4695,'en','Restrictions apply'),(4704,'en','Undefined'),(4705,'en','Undefined'),(4722,'en','Undefined'),(4723,'en','Undefined'),(4740,'en','Undefined'),(4741,'en','Undefined'),(4758,'en','Undefined'),(4759,'en','Undefined'),(4776,'en','Coverage/location in source'),(4777,'en','Undefined'),(4794,'en','Coverage unknown'),(4795,'en','Undefined'),(4812,'en','Coverage complete'),(4821,'en','Coverage is selective'),(4830,'en','Location in source not given'),(4839,'en','Location in source given'),(4848,'en','Display constant controller'),(4849,'en','Undefined'),(4866,'en','No display constant generated'),(4867,'en','Undefined'),(4884,'en','Cast'),(4893,'en','Undefined'),(4894,'en','Undefined'),(4911,'en','# -Undefined'),(4912,'en','Undefined'),(4929,'en','Undefined'),(4930,'en','Undefined'),(4947,'en','Undefined'),(4948,'en','Undefined'),(4965,'en','Undefined'),(4966,'en','Undefined'),(4983,'en','Undefined'),(4984,'en','Undefined'),(5001,'en','Display constant controller'),(5002,'en','Undefined'),(5019,'en','Type of file'),(5020,'en','Undefined'),(5037,'en','No display constant generated'),(5046,'en','Undefined'),(5047,'en','Undefined'),(5064,'en','Undefined'),(5065,'en','Undefined'),(5082,'en','Display constant controller'),(5083,'en','Undefined'),(5100,'en','Summary'),(5101,'en','Undefined'),(5118,'en','Subject'),(5127,'en','Review'),(5136,'en','Scope and content'),(5145,'en','Content advice'),(5154,'en','Abstract'),(5163,'en','No display constant generated'),(5172,'en','Display constant controller'),(5173,'en','Undefined'),(5190,'en','Audience'),(5191,'en','Undefined'),(5208,'en','Reading grade level'),(5217,'en','Interest age level'),(5226,'en','Interest grade level'),(5235,'en','Special audience characteristics'),(5244,'en','Motivation/interest level'),(5253,'en','No display constant generated'),(5262,'en','Display constant controller'),(5263,'en','Undefined'),(5280,'en','Geographic coverage'),(5281,'en','Undefined'),(5298,'en','No display constant generated'),(5307,'en','Display constant controller'),(5308,'en','Undefined'),(5325,'en','Cite as'),(5326,'en','Undefined'),(5343,'en','No display constant generated'),(5352,'en','Undefined'),(5353,'en','Undefined'),(5370,'en','# -Undefined'),(5371,'en','Undefined'),(5388,'en','Display constant controller'),(5389,'en','Undefined'),(5406,'en','Reading program'),(5407,'en','Undefined'),(5424,'en','No display constant generated'),(5433,'en','Undefined'),(5434,'en','Undefined'),(5451,'en','Undefined'),(5452,'en','Undefined'),(5469,'en','Undefined'),(5470,'en','Undefined'),(5487,'en','# -Undefined'),(5488,'en','Undefined'),(5505,'en','Undefined'),(5506,'en','Undefined'),(5523,'en','Undefined'),(5524,'en','Undefined'),(5541,'en','Custodial role'),(5542,'en','Undefined'),(5559,'en','Holder of originals'),(5560,'en','Undefined'),(5577,'en','Holder of duplicates'),(5586,'en','Undefined'),(5587,'en','Undefined'),(5604,'en','# -Undefined'),(5605,'en','Undefined'),(5622,'en','Undefined'),(5623,'en','Undefined'),(5640,'en','Undefined'),(5641,'en','Undefined'),(5658,'en','Undefined'),(5659,'en','Undefined'),(5676,'en','Undefined'),(5677,'en','Undefined'),(5694,'en','Undefined'),(5695,'en','Undefined'),(5712,'en','# -Undefined'),(5713,'en','Undefined'),(5730,'en','Relationship'),(5731,'en','Undefined'),(5748,'en','No information provided'),(5749,'en','Undefined'),(5766,'en','Associated materials. Other materials identified in the note have the same provenance but reside in a different repository'),(5775,'en','Related materials. Other materials identified in the note share of activity, reside in the same repository, but have different provenance.'),(5784,'en','Undefined'),(5785,'en','Undefined'),(5802,'en','Undefined'),(5803,'en','Undefined'),(5820,'en','Undefined'),(5821,'en','Undefined'),(5838,'en','Undefined'),(5839,'en','Undefined'),(5856,'en','Undefined'),(5857,'en','Undefined'),(5874,'en','Undefined'),(5875,'en','Undefined'),(5892,'en','Undefined'),(5893,'en','Undefined'),(5910,'en','Undefined'),(5911,'en','Undefined'),(5928,'en','Display constant controller'),(5929,'en','Undefined'),(5946,'en','Undefined'),(5955,'en','No display constant generated'),(5964,'en','Display constant controller'),(5965,'en','Undefined'),(5982,'en','Undefined'),(5991,'en','No display constant generated'),(6000,'en','Undefined'),(6001,'en','Undefined'),(6018,'en','# -Undefined'),(6019,'en','Undefined'),(6036,'en','Undefined'),(6037,'en','Undefined'),(6054,'en','# -Undefined'),(6055,'en','Undefined'),(6072,'en','Undefined'),(6073,'en','Undefined'),(6090,'en','Undefined'),(6091,'en','Undefined'),(6108,'en','Display constant controller'),(6109,'en','Undefined'),(6126,'en','File size'),(6127,'en','Undefined'),(6144,'en','Case file characteristics'),(6153,'en','No display constant generated'),(6162,'en','Display constant controller'),(6163,'en','Undefined'),(6180,'en','Methodology'),(6181,'en','# -Undefined'),(6198,'en','No display constant generated'),(6207,'en','Undefined'),(6208,'en','Undefined'),(6225,'en','# -Undefined'),(6226,'en','Undefined'),(6243,'en','Display constant controller'),(6244,'en','Undefined'),(6261,'en','Publications'),(6262,'en','Undefined'),(6279,'en','No display constant generated'),(6288,'en','Undefined'),(6289,'en','Undefined'),(6306,'en','# -Undefined'),(6307,'en','Undefined'),(6324,'en','Undefined'),(6325,'en','Undefined'),(6342,'en','Undefined'),(6343,'en','Undefined'),(6360,'en','Undefined'),(6361,'en','Undefined'),(6378,'en','Undefined'),(6379,'en','# -Undefined'),(6396,'en','Display constant controller'),(6397,'en','Undefined'),(6414,'en','Awards'),(6415,'en','Undefined'),(6432,'en','No display constant generated'),(6441,'en','Type of personal name entry element'),(6442,'en','Thesaurus'),(6459,'en','Forename'),(6460,'en','0 -Library of Congress Subject Headings'),(6477,'en','Surname.'),(6478,'en','LC subject headings for children''s literature.'),(6495,'en','Family Name'),(6496,'en','Medical Subject Headings. '),(6513,'en','National Agricultural Library subject authority file'),(6522,'en','Source not specified'),(6531,'en','Canadian Subject Headings'),(6540,'en','Repertoire de vedettes-matiere'),(6549,'en','Source specified in subfield $2'),(6558,'en','Type of corporate name entry element'),(6559,'en','Thesaurus'),(6576,'en','Inverted name'),(6577,'en','Library of Congress Subject Headings'),(6594,'en','Juridistion name'),(6595,'en','LC subject headings for children''s literature.'),(6612,'en','Name in direct order'),(6613,'en','Medical Subject Headings.'),(6630,'en','National Agricultural Library subject authority file'),(6639,'en','Source not specified'),(6648,'en','Canadian Subject Headings'),(6657,'en','Repertoire de vedettes-matiere. '),(6666,'en','Source specified in subfield $2'),(6675,'en','Type of meeting name entry element'),(6676,'en','Thesaurus'),(6693,'en','Inverted name'),(6694,'en','Library of Congress Subject Headings'),(6711,'en','Juridistion name'),(6712,'en','LC subject headings for children''s literature. '),(6729,'en','Name in direct order'),(6730,'en','Medical Subject Headings. '),(6747,'en','National Agricultural Library subject authority file'),(6756,'en','Source not specified'),(6765,'en','Canadian Subject Headings'),(6774,'en','Repertoire de vedettes-matiere'),(6783,'en','Source specified in subfield $2'),(6792,'en','Nonfiling characters'),(6793,'en','Thesaurus'),(6810,'en','Number of nonfiling characters'),(6811,'en','Library of Congress Subject Headings'),(6828,'en','Number of nonfiling characters'),(6829,'en','LC subject headings for children''s literature. '),(6846,'en','Number of nonfiling characters'),(6847,'en','Medical Subject Headings. '),(6864,'en','Number of nonfiling characters'),(6865,'en','National Agricultural Library subject authority file'),(6882,'en','Number of nonfiling characters'),(6883,'en','Source not specified'),(6900,'en','Number of nonfiling characters'),(6901,'en','Canadian Subject Headings'),(6918,'en','Number of nonfiling characters'),(6919,'en','Repertoire de vedettes-matiere'),(6936,'en','Number of nonfiling characters'),(6937,'en','Source specified in subfield $2'),(6954,'en','Number of nonfiling characters'),(6963,'en','Number of nonfiling characters'),(6972,'en','Undefined'),(6973,'en','Thesaurus'),(6990,'en','Undefined'),(6991,'en','Library of Congress Subject Headings'),(7008,'en','LC subject headings for children''s literature. '),(7017,'en','Medical Subject Headings. '),(7026,'en','National Agricultural Library subject authority file'),(7035,'en','Source not specified'),(7044,'en','Canadian Subject Headings'),(7053,'en','Repertoire de vedettes-matiere'),(7062,'en','Source specified in subfield $2'),(7071,'en','Level of subject'),(7072,'en','Thesaurus'),(7089,'en','No information provided'),(7090,'en','Library of Congress Subject Headings'),(7107,'en','No level specified'),(7108,'en','LC subject headings for children''s literature. '),(7125,'en','Primary'),(7126,'en','Medical Subject Headings. '),(7143,'en','Secondary'),(7144,'en','National Agricultural Library subject authority file'),(7161,'en','Source not specified'),(7170,'en','Canadian Subject Headings'),(7179,'en','Repertoire de vedettes-matiere'),(7188,'en','Source specified in subfield $2'),(7197,'en','Undefined'),(7198,'en','Thesaurus'),(7215,'en','Undefined'),(7216,'en','Library of Congress Subject Headings'),(7233,'en','LC subject headings for children''s literature. '),(7242,'en','Medical Subject Headings. '),(7251,'en','National Agricultural Library subject authority file'),(7260,'en','Source not specified'),(7269,'en','Canadian Subject Headings'),(7278,'en','Repertoire de vedettes-matiere'),(7287,'en','Source specified in subfield $2'),(7296,'en','Level of index term'),(7297,'en','Type of term or name'),(7314,'en','No information provided'),(7315,'en','No information provided'),(7332,'en','No level specified'),(7333,'en','Topical term'),(7350,'en','Primary'),(7351,'en','Personal name'),(7368,'en','Secondary'),(7369,'en','Corporate name'),(7386,'en','Meeting name'),(7395,'en','Chronological term'),(7404,'en','Geographic name'),(7413,'en','Genre/form term'),(7422,'en','Level of subject'),(7423,'en','Undefined'),(7440,'en','No information provided'),(7441,'en','Undefined'),(7458,'en','No level specified'),(7467,'en','Primary'),(7476,'en','Secondary'),(7485,'en','Type of heading'),(7486,'en','Thesaurus'),(7503,'en','Basic'),(7504,'en','Library of Congress Subject Headings'),(7521,'en','Faceted'),(7522,'en','LC subject headings for children''s literature. '),(7539,'en','Medical Subject Headings. '),(7548,'en','National Agricultural Library subject authority file'),(7557,'en','Source not specified'),(7566,'en','Canadian Subject Headings'),(7575,'en','Repertoire de vedettes-matiere'),(7584,'en','Source specified in subfield $2'),(7593,'en','Undefined'),(7594,'en','Source of term'),(7611,'en','Undefined'),(7612,'en','Source specified in subfield $2'),(7629,'en','Undefined'),(7630,'en','Source of term'),(7647,'en','Undefined'),(7648,'en','Source specified in subfield $2'),(7665,'en','Undefined'),(7666,'en','Undefined'),(7683,'en','Undefined'),(7684,'en','Undefined'),(7701,'en','Undefined'),(7702,'en','Undefined'),(7719,'en','Undefined'),(7720,'en','Undefined'),(7737,'en','Type of personal name entry element'),(7738,'en','Type of added entry'),(7755,'en','Forename'),(7756,'en','No information provided'),(7773,'en','Surname.'),(7774,'en','Analytical entry'),(7791,'en','Family name'),(7800,'en','Type or corporate name entry element'),(7801,'en','Type of added entry'),(7818,'en','Inverted name'),(7819,'en','No information provided'),(7836,'en','Juridistion name'),(7837,'en','Analytical entry'),(7854,'en','Name in direct order'),(7863,'en','Type of meeting name entry element'),(7864,'en','Type of added entry'),(7881,'en','Inverted name'),(7882,'en','No information provided'),(7899,'en','Juridistion name'),(7900,'en','Analytical entry'),(7917,'en','Name in direct order'),(7926,'en','Type of name'),(7927,'en','Undefined'),(7944,'en','Not specified'),(7945,'en','Undefined'),(7962,'en','Personal'),(7971,'en','Other'),(7980,'en','Nonfiling characters'),(7981,'en','Type of added entry'),(7998,'en','Number of nonfiling characters'),(7999,'en','No information provided'),(8016,'en','Number of nonfiling characters'),(8017,'en','Analytical entry'),(8034,'en','Number of nonfiling characters'),(8043,'en','Number of nonfiling characters'),(8052,'en','Number of nonfiling characters'),(8061,'en','Number of nonfiling characters'),(8070,'en','Number of nonfiling characters'),(8079,'en','Number of nonfiling characters'),(8088,'en','Number of nonfiling characters'),(8097,'en','Number of nonfiling characters'),(8106,'en','Nonfiling characters'),(8107,'en','Type of added entry'),(8124,'en','No nonfiling characters'),(8125,'en','No information provided'),(8142,'en','Number of nonfiling characters'),(8143,'en','Analytical entry'),(8160,'en','Number of nonfiling characters'),(8169,'en','Number of nonfiling characters'),(8178,'en','Number of nonfiling characters'),(8187,'en','Number of nonfiling characters'),(8196,'en','Number of nonfiling characters'),(8205,'en','Number of nonfiling characters'),(8214,'en','Number of nonfiling characters'),(8223,'en','Number of nonfiling characters'),(8232,'en','Undefined'),(8233,'en','Undefined'),(8250,'en','Undefined'),(8251,'en','Undefined'),(8268,'en','Undefined'),(8269,'en','Undefined'),(8286,'en','Undefined'),(8287,'en','Undefined'),(8304,'en','Undefined'),(8305,'en','Undefined'),(8322,'en','Undefined'),(8323,'en','Undefined'),(8340,'en','Note controller'),(8341,'en','Display constant controller'),(8358,'en','Display note'),(8359,'en','Main series'),(8376,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8377,'en','No display constant generated'),(8394,'en','Note controller'),(8395,'en','Display constant controller'),(8412,'en','Display note'),(8413,'en','Has subseries'),(8430,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8431,'en','No display constant generated'),(8448,'en','Note controller'),(8449,'en','Display constant controller'),(8466,'en','Display note'),(8467,'en','Translation of'),(8484,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8485,'en','No display constant generated'),(8502,'en','Note controller'),(8503,'en','Display constant controller'),(8520,'en','Display note'),(8521,'en','Translated as'),(8538,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8539,'en','No display constant generated'),(8556,'en','Note controller'),(8557,'en','Display constant controller'),(8574,'en','Display note'),(8575,'en','Has supplement'),(8592,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8593,'en','No display constant generated'),(8610,'en','Note controller'),(8611,'en','Display constant controller'),(8628,'en','Display note'),(8629,'en','Supplement to'),(8646,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8647,'en','Parent'),(8664,'en','No display constant generated'),(8673,'en','Note controller'),(8674,'en','Display constant controller'),(8691,'en','Display note'),(8692,'en','In'),(8709,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8710,'en','No display constant generated'),(8727,'en','Note controller'),(8728,'en','Display constant controller'),(8745,'en','Display note'),(8746,'en','Constituent unit'),(8763,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8764,'en','No display constant generated'),(8781,'en','Note controller'),(8782,'en','Display constant controller'),(8799,'en','Display note'),(8800,'en','Other edition available'),(8817,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8818,'en','No display constant generated'),(8835,'en','Note controller'),(8836,'en','Display constant controller'),(8853,'en','Display note'),(8854,'en','Available in another form'),(8871,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8872,'en','No display constant generated'),(8889,'en','Note controller'),(8890,'en','Display constant controller'),(8907,'en','Display note'),(8908,'en','Issued with'),(8925,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8926,'en','No display constant generated'),(8943,'en','Note controller'),(8944,'en','Type of relationship'),(8961,'en','Display note'),(8962,'en','Continues'),(8979,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8980,'en','Continues in part'),(8997,'en','Supersedes'),(9006,'en','Supersedes in part'),(9015,'en','4 -Formed by the union of ... and ...'),(9024,'en','Absorbed'),(9033,'en','Absorbed in part'),(9042,'en','Separated from'),(9051,'en','Note controller'),(9052,'en','Type of relationship'),(9069,'en','Display note'),(9070,'en','Continued by'),(9087,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(9088,'en','Continued in part by'),(9105,'en','Superseded in part by'),(9114,'en','Superseded in part by'),(9123,'en','Absorbed by'),(9132,'en','Absorbed in part by'),(9141,'en','Split into... and ...'),(9150,'en','Merged with ... To form...'),(9159,'en','Changed back to'),(9168,'en','Note controller'),(9169,'en','Display constant controller'),(9186,'en','Display note'),(9187,'en','Data source'),(9204,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(9205,'en','No display constant generated'),(9222,'en','Note controller'),(9223,'en','Display constant controller'),(9240,'en','Display note'),(9241,'en','Related item'),(9258,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(9259,'en','No display constant generated'),(9276,'en','Type of personal name entry element'),(9277,'en','Undefined'),(9294,'en','Forename'),(9295,'en','Undefined'),(9312,'en','Surname.'),(9321,'en','Family Name'),(9330,'en','Type of corporate name entry element'),(9331,'en','Undefined'),(9348,'en','Inverted name'),(9349,'en','Undefined'),(9366,'en','Juridistion name'),(9375,'en','Name in direct order'),(9384,'en','Undefined'),(9393,'en','Inverted name'),(9394,'en','Undefined'),(9411,'en','Juridistion name'),(9420,'en','Name in direct order'),(9429,'en','Undefined'),(9430,'en','Nonfiling characters'),(9447,'en','Undefined'),(9448,'en','No nonfiling characters'),(9465,'en','Number of nonfiling characters'),(9474,'en','Number of nonfiling characters'),(9483,'en','Number of nonfiling characters'),(9492,'en','Number of nonfiling characters'),(9501,'en','Number of nonfiling characters'),(9510,'en','Number of nonfiling characters'),(9519,'en','Number of nonfiling characters'),(9528,'en','Number of nonfiling characters'),(9537,'en','Number of nonfiling characters'),(9546,'en','Undefined'),(9547,'en','Undefined'),(9564,'en','Undefined'),(9565,'en','Undefined'),(9582,'en','Undefined'),(9583,'en','Undefined'),(9600,'en','Undefined'),(9601,'en','# -Undefined'),(9618,'en','Undefined'),(9619,'en','Undefined'),(9636,'en','Undefined'),(9637,'en','Undefined'),(9654,'en','Undefined'),(9655,'en','Undefined'),(9672,'en','Undefined'),(9673,'en','Undefined'),(9690,'en','Undefined'),(9691,'en','Undefined'),(9708,'en','Undefined'),(9709,'en','# -Undefined'),(9726,'en','Undefined'),(9727,'en','Undefined'),(9744,'en','Undefined'),(9745,'en','Undefined'),(9762,'en','Shelving scheme'),(9763,'en','Shelving order'),(9780,'en','No information provided'),(9781,'en','No information provided'),(9798,'en','Library of Congress classification'),(9799,'en','Not enumeration'),(9816,'en','Dewey Decimal classification'),(9817,'en','Primary enumeration'),(9834,'en','National Library of Medicine classification'),(9835,'en','Alternative enumeration'),(9852,'en','Superintendent of Document classification'),(9861,'en','Shelving control number'),(9870,'en','Title'),(9879,'en','Shelved separately'),(9888,'en','Source specified in subfield $2'),(9897,'en','Other scheme'),(9906,'en','Compressibility and expandability'),(9907,'en','Caption evaluation'),(9924,'en','Cannot compress or expand'),(9925,'en','Captions verified; all levels present'),(9942,'en','Can compress but not expand'),(9943,'en','Captions verified; all levels may not be present'),(9960,'en','Can compress or expand'),(9961,'en','Captions unverified; all levels present'),(9978,'en','Unknown'),(9979,'en','Captions unverified; all levels may not be present'),(9996,'en','Compressibility and expandability'),(9997,'en','Caption evaluation'),(10014,'en','Cannot compress or expand'),(10015,'en','Captions verified; all levels present'),(10032,'en','Can compress but not expand'),(10033,'en','Captions verified; all levels may not be present'),(10050,'en','Can compress or expand'),(10051,'en','Captions unverified; all levels present'),(10068,'en','Unknown'),(10069,'en','Captions unverified; all levels may not be present'),(10086,'en','Undefined'),(10087,'en','Undefined'),(10104,'en','Undefined'),(10105,'en','Undefined'),(10122,'en','Access method'),(10123,'en','Relationship'),(10140,'en','No information provided'),(10141,'en','No information provided'),(10158,'en','E-mail'),(10159,'en','Resource'),(10176,'en','FTP'),(10177,'en','Version of resource'),(10194,'en','Remote login (Telnet)'),(10195,'en','Related resource'),(10212,'en','Dial-up'),(10213,'en','No display constant generated'),(10230,'en','HTTP'),(10239,'en','Method specidied in subfield $2.'),(10248,'en','Field encoding level'),(10249,'en','Form of holdings'),(10266,'en','No information provided'),(10267,'en','No information provided'),(10284,'en','Holdings level 3'),(10285,'en','Compressed'),(10302,'en','Holdings level 4'),(10303,'en','Uncompressed'),(10320,'en','Holdings level 4 with piece designation'),(10321,'en','Compressed, use textual display'),(10338,'en','Uncompressed, use textual display'),(10347,'en','Item (s) not published'),(10356,'en','Field encoding level'),(10357,'en','Form of holdings'),(10374,'en','No information provided'),(10375,'en','No information provided'),(10392,'en','Holdings level 3'),(10393,'en','Compressed'),(10410,'en','Holdings level 4'),(10411,'en','Uncompressed'),(10428,'en','Holdings level 4 with piece designation'),(10429,'en','Compressed, use textual display'),(10446,'en','Uncompressed, use textual display'),(10455,'en','Item (s) not published'),(10464,'en','Field encoding level'),(10465,'en','Form of holdings'),(10482,'en','No information provided'),(10483,'en','No information provided'),(10500,'en','Holdings level 4'),(10501,'en','Uncompressed'),(10518,'en','Holdings level 4 with piece designation'),(10519,'en','Uncompressed, use textual display'),(10536,'en','Field encoding level'),(10537,'en','Type of notation'),(10554,'en','No information provided'),(10555,'en','Non-stardard'),(10572,'en','Holdings level 3'),(10573,'en','ANSI/NISO Z39.71 or ISO 10324'),(10590,'en','Holdings level 4'),(10591,'en','ANSI Z39.42'),(10608,'en','Holdings level 4 with piece designation'),(10609,'en','Source specified in subfield $2'),(10626,'en','Field encoding level'),(10627,'en','Type of notation'),(10644,'en','No information provided'),(10645,'en','Non-stardard'),(10662,'en','Holdings level 3'),(10663,'en','ANSI/NISO Z39.71 or ISO 10324'),(10680,'en','Holdings level 4'),(10681,'en','ANSI Z39.42'),(10698,'en','Holdings level 4 with piece designation'),(10699,'en','Source specified in subfield $2'),(10716,'en','Field encoding level'),(10717,'en','Type of notation'),(10734,'en','No information provided'),(10735,'en','Non-stardard'),(10752,'en','Holdings level 3'),(10753,'en','ANSI/NISO Z39.71 or ISO 10324'),(10770,'en','Holdings level 4'),(10771,'en','ANSI Z39.42'),(10788,'en','Holdings level 4 with piece designation'),(10789,'en','Source specified in subfield $2'),(10806,'en','Undefined'),(10807,'en','Undefined'),(10824,'en','Undefined'),(10825,'en','Undefined'),(10842,'en','Undefined'),(10843,'en','Undefined'),(10860,'en','Undefined'),(10861,'en','Undefined'),(10878,'en','Undefined'),(10879,'en','Undefined'),(10896,'en','Undefined'),(10897,'en','Undefined'),(10914,'en','Appropriate indicator as available in associated field'),(10915,'en','Appropriate indicator as available in associated field'),(10932,'en','Type of field'),(10933,'en','Undefined'),(10950,'en','Leader'),(10951,'en','Undefined'),(10968,'en','Variable control fields (002 -009)'),(10977,'en','Variable data fields (010 - 999)'),(10986,'en','Undefined'),(10987,'en','Undefined'),(11004,'en','Undefined'),(11005,'en','Undefined'); + +ALTER TABLE marc_indicators ADD CONSTRAINT marc_indicators_frameworkcode_fkey FOREIGN KEY (frameworkcode) REFERENCES biblio_framework (frameworkcode) ON DELETE CASCADE; diff --git a/installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_indicators.txt b/installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_indicators.txt new file mode 100755 index 0000000..870ad32 --- /dev/null +++ b/installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_indicators.txt @@ -0,0 +1 @@ +Default MARC 21 indicators values. diff --git a/installer/data/Pg/kohastructure.sql b/installer/data/Pg/kohastructure.sql old mode 100644 new mode 100755 index 12967dc..1626d03 --- a/installer/data/Pg/kohastructure.sql +++ b/installer/data/Pg/kohastructure.sql @@ -1670,4 +1670,62 @@ PRIMARY KEY (limitId) ); +-- +-- Table structure for table marc_indicators +-- + + +DROP TABLE IF EXISTS marc_indicators CASCADE; +CREATE TABLE marc_indicators ( + id_indicator SERIAL PRIMARY KEY, + frameworkcode varchar(4) default '' REFERENCES biblio_framework (frameworkcode) ON DELETE CASCADE, + tagfield varchar(3) NOT NULL default '' +); +CREATE UNIQUE INDEX marc_indicators_frameworkcode ON marc_indicators (frameworkcode,tagfield); + + +-- +-- Table structure for table marc_indicators_values +-- + +DROP TABLE IF EXISTS marc_indicators_values CASCADE; +CREATE TABLE marc_indicators_values ( + ind_value char(1) NOT NULL default '' PRIMARY KEY +); + +INSERT INTO marc_indicators_values VALUES (''),('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9'),('a'),('b'),('c'),('d'),('e'),('f'),('g'),('h'),('i'),('j'),('k'),('l'),('m'),('n'),('o'),('p'),('q'),('r'),('s'),('t'),('u'),('v'),('w'),('x'),('y'),('z'); + + +-- +-- Table structure for table marc_indicators_value +-- + +DROP TABLE IF EXISTS marc_indicators_value CASCADE; +CREATE TABLE marc_indicators_value ( + id_indicator_value SERIAL PRIMARY KEY, + id_indicator integer NOT NULL REFERENCES marc_indicators (id_indicator) ON DELETE CASCADE, + ind varchar(1) NOT NULL, + ind_value char(1) NOT NULL REFERENCES marc_indicators_values (ind_value) ON DELETE CASCADE, + CHECK ( ind IN ('1', '2')) +); +CREATE INDEX marc_indicators_value_id_indicator ON marc_indicators_value (id_indicator); +CREATE INDEX marc_indicators_value_ind_value ON marc_indicators_value (ind_value); + + +-- +-- Table structure for table marc_indicators_desc +-- + +DROP TABLE IF EXISTS marc_indicators_desc CASCADE; +CREATE TABLE marc_indicators_desc ( + id_indicator_value integer NOT NULL REFERENCES marc_indicators_value (id_indicator_value) ON DELETE CASCADE, + lang varchar(25) NOT NULL default 'en', + ind_desc text, + PRIMARY KEY (id_indicator_value,lang) +); +CREATE INDEX marc_indicators_desc_lang ON marc_indicators_desc (lang); + + + + --commit; diff --git a/installer/data/mysql/de-DE/mandatory/sysprefs.sql b/installer/data/mysql/de-DE/mandatory/sysprefs.sql index a38a08b..5324bf9 100755 --- a/installer/data/mysql/de-DE/mandatory/sysprefs.sql +++ b/installer/data/mysql/de-DE/mandatory/sysprefs.sql @@ -309,4 +309,6 @@ INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Display856uAsImage','OFF','Display the URI in the 856u field as an image, the corresponding Staff Client XSLT option must be on','OFF|Details|Results|Both','Choice'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsField','','The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).',NULL,'free'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsSeparator','','The string to use to separate subfields in alternate holdings displays.',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('CheckValueIndicators','0','Check the values of the indicators in cataloguing','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('DisplayPluginValueIndicators','0','Display a plugin with the correct values of indicators for fields in cataloguing','','YesNo'); diff --git a/installer/data/mysql/en/mandatory/sysprefs.sql b/installer/data/mysql/en/mandatory/sysprefs.sql index e3977a8..ddadc62 100755 --- a/installer/data/mysql/en/mandatory/sysprefs.sql +++ b/installer/data/mysql/en/mandatory/sysprefs.sql @@ -309,4 +309,5 @@ INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Display856uAsImage','OFF','Display the URI in the 856u field as an image, the corresponding Staff Client XSLT option must be on','OFF|Details|Results|Both','Choice'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsField','','The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).',NULL,'free'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsSeparator','','The string to use to separate subfields in alternate holdings displays.',NULL,'free'); - +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('CheckValueIndicators','0','Check the values of the indicators in cataloguing','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('DisplayPluginValueIndicators','0','Display a plugin with the correct values of indicators for fields in cataloguing','','YesNo'); diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_indicators.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_indicators.sql new file mode 100755 index 0000000..956ad07 --- /dev/null +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_indicators.sql @@ -0,0 +1,106 @@ +SET FOREIGN_KEY_CHECKS = 0; + +-- +-- Table structure for table `marc_indicators` +-- + +CREATE TABLE IF NOT EXISTS `marc_indicators` ( + `id_indicator` int(11) unsigned NOT NULL auto_increment, + `frameworkcode` varchar(4) default '', + `tagfield` varchar(3) NOT NULL default '', + PRIMARY KEY (`id_indicator`), + UNIQUE KEY `frameworkcode` (`frameworkcode`,`tagfield`), + CONSTRAINT `marc_indicators_ibfk_1` FOREIGN KEY (`frameworkcode`) REFERENCES `biblio_framework` (`frameworkcode`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +-- +-- Table structure for table `marc_indicators_values` +-- + +CREATE TABLE IF NOT EXISTS `marc_indicators_values` ( + `ind_value` char(1) NOT NULL default '', + PRIMARY KEY (`ind_value`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +TRUNCATE `marc_indicators_values`; + +INSERT IGNORE INTO `marc_indicators_values` VALUES (''),('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9'),('a'),('b'),('c'),('d'),('e'),('f'),('g'),('h'),('i'),('j'),('k'),('l'),('m'),('n'),('o'),('p'),('q'),('r'),('s'),('t'),('u'),('v'),('w'),('x'),('y'),('z'); + + +-- +-- Table structure for table `marc_indicators_value` +-- + +CREATE TABLE IF NOT EXISTS `marc_indicators_value` ( + `id_indicator_value` int(11) unsigned NOT NULL auto_increment, + `id_indicator` int(11) unsigned NOT NULL, + `ind` enum('1','2') NOT NULL, + `ind_value` char(1) NOT NULL, + PRIMARY KEY (`id_indicator_value`), + KEY `id_indicator` (`id_indicator`), + KEY `ind_value` (`ind_value`), + CONSTRAINT `marc_indicators_value_ibfk_2` FOREIGN KEY (`ind_value`) REFERENCES `marc_indicators_values` (`ind_value`) ON DELETE CASCADE, + CONSTRAINT `marc_indicators_value_ibfk_1` FOREIGN KEY (`id_indicator`) REFERENCES `marc_indicators` (`id_indicator`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +-- +-- Table structure for table `marc_indicators_desc` +-- + +CREATE TABLE IF NOT EXISTS `marc_indicators_desc` ( + `id_indicator_value` int(11) unsigned NOT NULL, + `lang` varchar(25) NOT NULL default 'en', + `ind_desc` mediumtext, + PRIMARY KEY (`id_indicator_value`,`lang`), + KEY `lang` (`lang`), + CONSTRAINT `marc_indicators_desc_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `language_descriptions` (`lang`) ON DELETE CASCADE, + CONSTRAINT `marc_indicators_desc_ibfk_1` FOREIGN KEY (`id_indicator_value`) REFERENCES `marc_indicators_value` (`id_indicator_value`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +-- ****************************************** +-- Values for Indicators for Default Framework +-- ****************************************** + +TRUNCATE `marc_indicators_desc`; +TRUNCATE `marc_indicators_value`; +TRUNCATE `marc_indicators`; + + +-- +-- Dumping data for table marc_indicators +-- + +LOCK TABLES marc_indicators WRITE; +/*!40000 ALTER TABLE marc_indicators DISABLE KEYS */; +INSERT INTO marc_indicators VALUES (1,'','010'),(11,'','013'),(20,'','015'),(29,'','016'),(38,'','017'),(47,'','018'),(56,'','020'),(66,'','022'),(76,'','024'),(85,'','025'),(94,'','026'),(103,'','027'),(112,'','028'),(121,'','030'),(130,'','031'),(139,'','032'),(148,'','033'),(157,'','034'),(166,'','035'),(175,'','036'),(184,'','037'),(193,'','038'),(202,'','040'),(211,'','041'),(220,'','042'),(229,'','043'),(238,'','044'),(247,'','045'),(256,'','046'),(265,'','047'),(274,'','048'),(283,'','050'),(293,'','051'),(302,'','052'),(311,'','055'),(320,'','060'),(329,'','061'),(338,'','066'),(347,'','070'),(356,'','071'),(365,'','072'),(374,'','074'),(383,'','080'),(392,'','082'),(401,'','084'),(410,'','086'),(419,'','088'),(428,'','100'),(438,'','110'),(447,'','111'),(456,'','130'),(465,'','210'),(474,'','222'),(483,'','240'),(492,'','242'),(501,'','245'),(511,'','246'),(520,'','247'),(529,'','250'),(539,'','254'),(548,'','255'),(557,'','256'),(566,'','257'),(575,'','258'),(584,'','260'),(594,'','263'),(603,'','270'),(612,'','300'),(622,'','306'),(631,'','307'),(640,'','310'),(649,'','321'),(658,'','340'),(667,'','342'),(676,'','343'),(685,'','351'),(694,'','352'),(703,'','355'),(712,'','357'),(721,'','362'),(730,'','365'),(739,'','366'),(748,'','490'),(757,'','500'),(767,'','501'),(776,'','502'),(785,'','504'),(794,'','505'),(803,'','506'),(812,'','507'),(821,'','508'),(830,'','510'),(839,'','511'),(848,'','513'),(857,'','514'),(866,'','515'),(875,'','516'),(884,'','518'),(893,'','520'),(902,'','521'),(911,'','522'),(920,'','524'),(929,'','525'),(938,'','526'),(947,'','530'),(956,'','533'),(965,'','534'),(974,'','535'),(983,'','536'),(992,'','538'),(1001,'','540'),(1010,'','541'),(1019,'','544'),(1028,'','546'),(1037,'','547'),(1046,'','550'),(1055,'','552'),(1064,'','555'),(1073,'','556'),(1082,'','561'),(1091,'','562'),(1100,'','563'),(1109,'','565'),(1118,'','567'),(1127,'','580'),(1136,'','581'),(1145,'','583'),(1154,'','584'),(1163,'','585'),(1172,'','586'),(1181,'','600'),(1190,'','610'),(1199,'','611'),(1208,'','630'),(1217,'','648'),(1226,'','650'),(1235,'','651'),(1244,'','653'),(1253,'','654'),(1262,'','655'),(1271,'','656'),(1280,'','657'),(1289,'','658'),(1298,'','662'),(1307,'','700'),(1316,'','710'),(1325,'','711'),(1334,'','720'),(1343,'','730'),(1352,'','740'),(1361,'','752'),(1370,'','753'),(1379,'','754'),(1388,'','760'),(1397,'','762'),(1406,'','765'),(1415,'','767'),(1424,'','770'),(1433,'','772'),(1442,'','773'),(1451,'','774'),(1460,'','775'),(1469,'','776'),(1478,'','777'),(1487,'','780'),(1496,'','785'),(1505,'','786'),(1514,'','787'),(1523,'','800'),(1532,'','810'),(1541,'','811'),(1550,'','830'),(1559,'','841'),(1568,'','842'),(1577,'','843'),(1586,'','844'),(1595,'','845'),(1604,'','850'),(1613,'','852'),(1622,'','853'),(1631,'','854'),(1640,'','855'),(1649,'','856'),(1658,'','863'),(1667,'','864'),(1676,'','865'),(1685,'','866'),(1694,'','867'),(1703,'','868'),(1712,'','876'),(1721,'','877'),(1730,'','878'),(1739,'','880'),(1748,'','886'),(1757,'','887'); +/*!40000 ALTER TABLE marc_indicators ENABLE KEYS */; +UNLOCK TABLES; + + +-- +-- Dumping data for table marc_indicators_value +-- + + +LOCK TABLES marc_indicators_value WRITE; +/*!40000 ALTER TABLE marc_indicators_value DISABLE KEYS */; +INSERT INTO marc_indicators_value VALUES (1,1,'1',''),(2,1,'2',''),(21,1,'1',''),(22,1,'2',''),(41,11,'1',''),(42,11,'2',''),(59,11,'1',''),(60,11,'2',''),(77,20,'1',''),(78,20,'2',''),(95,20,'1',''),(96,20,'2',''),(113,29,'1',''),(114,29,'2',''),(131,29,'1',''),(132,29,'2',''),(149,29,'1','7'),(158,38,'1',''),(159,38,'2',''),(176,38,'1',''),(177,38,'2',''),(194,47,'1',''),(195,47,'2',''),(212,47,'1',''),(213,47,'2',''),(230,56,'1',''),(231,56,'2',''),(250,56,'1',''),(251,56,'2',''),(270,66,'1',''),(271,66,'2',''),(290,66,'1',''),(291,66,'2',''),(310,66,'1','0'),(320,66,'1','1'),(330,76,'1',''),(331,76,'2',''),(348,76,'1','0'),(349,76,'2',''),(366,76,'1','1'),(367,76,'2','0'),(384,76,'1','2'),(385,76,'2','1'),(402,76,'1','3'),(411,76,'1','4'),(420,76,'1','7'),(429,76,'1','8'),(438,85,'1',''),(439,85,'2',''),(456,85,'1',''),(457,85,'2',''),(474,94,'1',''),(475,94,'2',''),(492,94,'1',''),(493,94,'2',''),(510,103,'1',''),(511,103,'2',''),(528,103,'1',''),(529,103,'2',''),(546,112,'1',''),(547,112,'2',''),(564,112,'1','0'),(565,112,'2','0'),(582,112,'1','1'),(583,112,'2','1'),(600,112,'1','2'),(601,112,'2','2'),(618,112,'1','3'),(619,112,'2','3'),(636,112,'1','4'),(645,112,'1','5'),(654,121,'1',''),(655,121,'2',''),(672,121,'1',''),(673,121,'2',''),(690,130,'1',''),(691,130,'2',''),(708,130,'1',''),(709,130,'2',''),(726,139,'1',''),(727,139,'2',''),(744,139,'1',''),(745,139,'2',''),(762,148,'1',''),(763,148,'2',''),(780,148,'1',''),(781,148,'2',''),(798,148,'1','0'),(799,148,'2','0'),(816,148,'1','1'),(817,148,'2','1'),(834,148,'1','2'),(835,148,'2','2'),(852,157,'1',''),(853,157,'2',''),(870,157,'1','0'),(871,157,'2',''),(888,157,'1','1'),(889,157,'2','0'),(906,157,'1','3'),(907,157,'2','1'),(924,166,'1',''),(925,166,'2',''),(942,166,'1',''),(943,166,'2',''),(960,175,'1',''),(961,175,'2',''),(978,175,'1',''),(979,175,'2',''),(996,184,'1',''),(997,184,'2',''),(1014,184,'1',''),(1015,184,'2',''),(1032,193,'1',''),(1033,193,'2',''),(1050,193,'1',''),(1051,193,'2',''),(1068,202,'1',''),(1069,202,'2',''),(1086,202,'1',''),(1087,202,'2',''),(1104,211,'1',''),(1105,211,'2',''),(1122,211,'1','0'),(1123,211,'2',''),(1140,211,'1','1'),(1141,211,'2','7'),(1158,220,'1',''),(1159,220,'2',''),(1176,220,'1',''),(1177,220,'2',''),(1194,229,'1',''),(1195,229,'2',''),(1212,229,'1',''),(1213,229,'2',''),(1230,238,'1',''),(1231,238,'2',''),(1248,238,'1',''),(1249,238,'2',''),(1266,247,'1',''),(1267,247,'2',''),(1284,247,'1',''),(1285,247,'2',''),(1302,247,'1','0'),(1311,247,'1','1'),(1320,247,'1','2'),(1329,256,'1',''),(1330,256,'2',''),(1347,256,'1',''),(1348,256,'2',''),(1365,265,'1',''),(1366,265,'2',''),(1383,265,'1',''),(1384,265,'2',''),(1401,274,'1',''),(1402,274,'2',''),(1419,274,'1',''),(1420,274,'2',''),(1437,283,'1',''),(1438,283,'2',''),(1457,283,'1',''),(1458,283,'2','0'),(1477,283,'1','0'),(1478,283,'2','4'),(1497,283,'1','1'),(1507,293,'1',''),(1508,293,'2',''),(1525,293,'1',''),(1526,293,'2',''),(1543,302,'1',''),(1544,302,'2',''),(1561,302,'1',''),(1562,302,'2',''),(1579,302,'1','1'),(1588,302,'1','7'),(1597,311,'1',''),(1598,311,'2',''),(1615,311,'1',''),(1616,311,'2','0'),(1633,311,'1','0'),(1634,311,'2','1'),(1651,311,'1','1'),(1652,311,'2','2'),(1669,311,'2','3'),(1678,311,'2',''),(1687,311,'2','5'),(1696,311,'2','6'),(1705,311,'2','7'),(1714,311,'2','8'),(1723,311,'2','9'),(1732,320,'1',''),(1733,320,'2',''),(1750,320,'1',''),(1751,320,'2','0'),(1768,320,'1','0'),(1769,320,'2','4'),(1786,320,'1','1'),(1795,329,'1',''),(1796,329,'2',''),(1813,329,'1',''),(1814,329,'2',''),(1831,338,'1',''),(1832,338,'2',''),(1849,338,'1',''),(1850,338,'2',''),(1867,347,'1',''),(1868,347,'2',''),(1885,347,'1','0'),(1886,347,'2',''),(1903,347,'1','1'),(1912,356,'1',''),(1913,356,'2',''),(1930,356,'1',''),(1931,356,'2',''),(1948,365,'1',''),(1949,365,'2',''),(1966,365,'1',''),(1967,365,'2',''),(1984,365,'2','7'),(1993,374,'1',''),(1994,374,'2',''),(2011,374,'1',''),(2012,374,'2',''),(2029,383,'1',''),(2030,383,'2',''),(2047,383,'1',''),(2048,383,'2',''),(2065,392,'1',''),(2066,392,'2',''),(2083,392,'1','0'),(2084,392,'2',''),(2101,392,'1','1'),(2102,392,'2','0'),(2119,392,'2','4'),(2128,401,'1',''),(2129,401,'2',''),(2146,401,'1',''),(2147,401,'2',''),(2164,410,'1',''),(2165,410,'2',''),(2182,410,'1',''),(2183,410,'2',''),(2200,410,'1','0'),(2209,410,'1','1'),(2218,419,'1',''),(2219,419,'2',''),(2236,419,'1',''),(2237,419,'2',''),(2254,428,'1',''),(2255,428,'2',''),(2274,428,'1','0'),(2275,428,'2',''),(2294,428,'1','1'),(2304,428,'1','3'),(2314,438,'1',''),(2315,438,'2',''),(2332,438,'1','0'),(2333,438,'2',''),(2350,438,'1',''),(2359,438,'1','2'),(2368,447,'1',''),(2369,447,'2',''),(2386,447,'1','0'),(2387,447,'2',''),(2404,447,'1',''),(2413,447,'1','2'),(2422,456,'1',''),(2423,456,'2',''),(2440,456,'1','0'),(2441,456,'2',''),(2458,456,'1','1'),(2467,456,'1','2'),(2476,456,'1','3'),(2485,456,'1','4'),(2494,456,'1','5'),(2503,456,'1','6'),(2512,456,'1','7'),(2521,456,'1','8'),(2530,456,'1','9'),(2539,465,'1',''),(2540,465,'2',''),(2557,465,'1','0'),(2558,465,'2',''),(2575,465,'1','1'),(2576,465,'2','0'),(2593,474,'1',''),(2594,474,'2',''),(2611,474,'1',''),(2612,474,'2','0'),(2629,474,'2','1'),(2638,474,'2','2'),(2647,474,'2','3'),(2656,474,'2','4'),(2665,474,'2','5'),(2674,474,'2','6'),(2683,474,'2','7'),(2692,474,'2','8'),(2701,474,'2','9'),(2710,483,'1',''),(2711,483,'2',''),(2728,483,'1','0'),(2729,483,'2','0'),(2746,483,'1','1'),(2747,483,'2','1'),(2764,483,'2','2'),(2773,483,'2','3'),(2782,483,'2','4'),(2791,483,'2','5'),(2800,483,'2','6'),(2809,483,'2','7'),(2818,483,'2','8'),(2827,483,'2','9'),(2836,492,'1',''),(2837,492,'2',''),(2854,492,'1','0'),(2855,492,'2','0'),(2872,492,'1','1'),(2873,492,'2','1'),(2890,492,'2','2'),(2899,492,'2','3'),(2908,492,'2','4'),(2917,492,'2','5'),(2926,492,'2','6'),(2935,492,'2','7'),(2944,492,'2','8'),(2953,492,'2','9'),(2962,501,'1',''),(2963,501,'2',''),(2982,501,'1','0'),(2983,501,'2','0'),(3002,501,'1','1'),(3003,501,'2','1'),(3022,501,'2','2'),(3032,501,'2','3'),(3042,501,'2','4'),(3052,501,'2','5'),(3062,501,'2','6'),(3072,501,'2','7'),(3082,501,'2','8'),(3092,501,'2','9'),(3102,511,'1',''),(3103,511,'2',''),(3120,511,'1','0'),(3121,511,'2',''),(3138,511,'1','1'),(3139,511,'2','0'),(3156,511,'1','2'),(3157,511,'2','1'),(3174,511,'1','3'),(3175,511,'2','2'),(3192,511,'2','3'),(3201,511,'2','4'),(3210,511,'2','5'),(3219,511,'2','6'),(3228,511,'2','7'),(3237,511,'2','8'),(3246,520,'1',''),(3247,520,'2',''),(3264,520,'1','0'),(3265,520,'2','0'),(3282,520,'1','1'),(3283,520,'2','1'),(3300,529,'1',''),(3301,529,'2',''),(3320,529,'1',''),(3321,529,'2',''),(3340,539,'1',''),(3341,539,'2',''),(3358,539,'1',''),(3359,539,'2',''),(3376,548,'1',''),(3377,548,'2',''),(3394,548,'1',''),(3395,548,'2',''),(3412,557,'1',''),(3413,557,'2',''),(3430,557,'1',''),(3431,557,'2',''),(3448,566,'1',''),(3449,566,'2',''),(3466,566,'1',''),(3467,566,'2',''),(3484,575,'1',''),(3485,575,'2',''),(3502,575,'1',''),(3503,575,'2',''),(3520,584,'1',''),(3521,584,'2',''),(3540,584,'1',''),(3541,584,'2',''),(3560,584,'1','2'),(3570,584,'1',''),(3580,594,'1',''),(3581,594,'2',''),(3598,594,'1',''),(3599,594,'2',''),(3616,603,'1',''),(3617,603,'2',''),(3634,603,'1',''),(3635,603,'2',''),(3652,603,'1','1'),(3653,603,'2','0'),(3670,603,'1','2'),(3671,603,'2','7'),(3688,612,'1',''),(3689,612,'2',''),(3708,612,'1',''),(3709,612,'2',''),(3728,622,'1',''),(3729,622,'2',''),(3746,622,'1',''),(3747,622,'2',''),(3764,631,'1',''),(3765,631,'2',''),(3782,631,'1',''),(3783,631,'2',''),(3800,631,'1','8'),(3809,640,'1',''),(3810,640,'2',''),(3827,640,'1',''),(3828,640,'2',''),(3845,649,'1',''),(3846,649,'2',''),(3863,649,'1',''),(3864,649,'2',''),(3881,658,'1',''),(3882,658,'2',''),(3899,658,'1',''),(3900,658,'2',''),(3917,667,'1',''),(3918,667,'2',''),(3935,667,'1','0'),(3936,667,'2','0'),(3953,667,'1','1'),(3954,667,'2','1'),(3971,667,'2','2'),(3980,667,'2','3'),(3989,667,'2','4'),(3998,667,'2','5'),(4007,667,'2','6'),(4016,667,'2','7'),(4025,667,'2','8'),(4034,676,'1',''),(4035,676,'2',''),(4052,676,'1',''),(4053,676,'2',''),(4070,685,'1',''),(4071,685,'2',''),(4088,685,'1',''),(4089,685,'2',''),(4106,694,'1',''),(4107,694,'2',''),(4124,694,'1',''),(4125,694,'2',''),(4142,703,'1',''),(4143,703,'2',''),(4160,703,'1','0'),(4161,703,'2',''),(4178,703,'1','1'),(4187,703,'1','2'),(4196,703,'1','3'),(4205,703,'1','4'),(4214,703,'1','5'),(4223,703,'1','8'),(4232,712,'1',''),(4233,712,'2',''),(4250,712,'1',''),(4251,712,'2',''),(4268,721,'1',''),(4269,721,'2',''),(4286,721,'1','0'),(4287,721,'2',''),(4304,721,'1','1'),(4313,730,'1',''),(4314,730,'2',''),(4331,730,'1',''),(4332,730,'2',''),(4349,739,'1',''),(4350,739,'2',''),(4367,739,'1',''),(4368,739,'2',''),(4385,748,'1',''),(4386,748,'2',''),(4403,748,'1','0'),(4404,748,'2',''),(4421,748,'1','1'),(4430,757,'1',''),(4431,757,'2',''),(4450,757,'1',''),(4451,757,'2',''),(4470,767,'1',''),(4471,767,'2',''),(4488,767,'1',''),(4489,767,'2',''),(4506,776,'1',''),(4507,776,'2',''),(4524,776,'1',''),(4525,776,'2',''),(4542,785,'1',''),(4543,785,'2',''),(4560,785,'1',''),(4561,785,'2',''),(4578,794,'1',''),(4579,794,'2',''),(4596,794,'1','0'),(4597,794,'2',''),(4614,794,'1','1'),(4615,794,'2','0'),(4632,794,'1','2'),(4641,794,'1','8'),(4650,803,'1',''),(4651,803,'2',''),(4668,803,'1',''),(4669,803,'2',''),(4686,803,'1','0'),(4695,803,'1','1'),(4704,812,'1',''),(4705,812,'2',''),(4722,812,'1',''),(4723,812,'2',''),(4740,821,'1',''),(4741,821,'2',''),(4758,821,'1',''),(4759,821,'2',''),(4776,830,'1',''),(4777,830,'2',''),(4794,830,'1','0'),(4795,830,'2',''),(4812,830,'1','1'),(4821,830,'1','2'),(4830,830,'1','3'),(4839,830,'1','4'),(4848,839,'1',''),(4849,839,'2',''),(4866,839,'1','0'),(4867,839,'2',''),(4884,839,'1','1'),(4893,848,'1',''),(4894,848,'2',''),(4911,848,'1',''),(4912,848,'2',''),(4929,857,'1',''),(4930,857,'2',''),(4947,857,'1',''),(4948,857,'2',''),(4965,866,'1',''),(4966,866,'2',''),(4983,866,'1',''),(4984,866,'2',''),(5001,875,'1',''),(5002,875,'2',''),(5019,875,'1',''),(5020,875,'2',''),(5037,875,'1','8'),(5046,884,'1',''),(5047,884,'2',''),(5064,884,'1',''),(5065,884,'2',''),(5082,893,'1',''),(5083,893,'2',''),(5100,893,'1',''),(5101,893,'2',''),(5118,893,'1','0'),(5127,893,'1','1'),(5136,893,'1','2'),(5145,893,'1','4'),(5154,893,'1','3'),(5163,893,'1','8'),(5172,902,'1',''),(5173,902,'2',''),(5190,902,'1',''),(5191,902,'2',''),(5208,902,'1','0'),(5217,902,'1','1'),(5226,902,'1','2'),(5235,902,'1','3'),(5244,902,'1','4'),(5253,902,'1','8'),(5262,911,'1',''),(5263,911,'2',''),(5280,911,'1',''),(5281,911,'2',''),(5298,911,'1','8'),(5307,920,'1',''),(5308,920,'2',''),(5325,920,'1',''),(5326,920,'2',''),(5343,920,'1','8'),(5352,929,'1',''),(5353,929,'2',''),(5370,929,'1',''),(5371,929,'2',''),(5388,938,'1',''),(5389,938,'2',''),(5406,938,'1','0'),(5407,938,'2',''),(5424,938,'1','8'),(5433,947,'1',''),(5434,947,'2',''),(5451,947,'1',''),(5452,947,'2',''),(5469,956,'1',''),(5470,956,'2',''),(5487,956,'1',''),(5488,956,'2',''),(5505,965,'1',''),(5506,965,'2',''),(5523,965,'1',''),(5524,965,'2',''),(5541,974,'1',''),(5542,974,'2',''),(5559,974,'1','1'),(5560,974,'2',''),(5577,974,'1','2'),(5586,983,'1',''),(5587,983,'2',''),(5604,983,'1',''),(5605,983,'2',''),(5622,992,'1',''),(5623,992,'2',''),(5640,992,'1',''),(5641,992,'2',''),(5658,1001,'1',''),(5659,1001,'2',''),(5676,1001,'1',''),(5677,1001,'2',''),(5694,1010,'1',''),(5695,1010,'2',''),(5712,1010,'1',''),(5713,1010,'2',''),(5730,1019,'1',''),(5731,1019,'2',''),(5748,1019,'1',''),(5749,1019,'2',''),(5766,1019,'1','0'),(5775,1019,'1','1'),(5784,1028,'1',''),(5785,1028,'2',''),(5802,1028,'1',''),(5803,1028,'2',''),(5820,1037,'1',''),(5821,1037,'2',''),(5838,1037,'1',''),(5839,1037,'2',''),(5856,1046,'1',''),(5857,1046,'2',''),(5874,1046,'1',''),(5875,1046,'2',''),(5892,1055,'1',''),(5893,1055,'2',''),(5910,1055,'1',''),(5911,1055,'2',''),(5928,1064,'1',''),(5929,1064,'2',''),(5946,1064,'2',''),(5955,1064,'1','8'),(5964,1073,'1',''),(5965,1073,'2',''),(5982,1073,'2',''),(5991,1073,'1','8'),(6000,1082,'1',''),(6001,1082,'2',''),(6018,1082,'1',''),(6019,1082,'2',''),(6036,1091,'1',''),(6037,1091,'2',''),(6054,1091,'1',''),(6055,1091,'2',''),(6072,1100,'1',''),(6073,1100,'2',''),(6090,1100,'1',''),(6091,1100,'2',''),(6108,1109,'1',''),(6109,1109,'2',''),(6126,1109,'1',''),(6127,1109,'2',''),(6144,1109,'1','0'),(6153,1109,'1','8'),(6162,1118,'1',''),(6163,1118,'2',''),(6180,1118,'1',''),(6181,1118,'2',''),(6198,1118,'1','8'),(6207,1127,'1',''),(6208,1127,'2',''),(6225,1127,'1',''),(6226,1127,'2',''),(6243,1136,'1',''),(6244,1136,'2',''),(6261,1136,'1',''),(6262,1136,'2',''),(6279,1136,'1','8'),(6288,1145,'1',''),(6289,1145,'2',''),(6306,1145,'1',''),(6307,1145,'2',''),(6324,1154,'1',''),(6325,1154,'2',''),(6342,1154,'1',''),(6343,1154,'2',''),(6360,1163,'1',''),(6361,1163,'2',''),(6378,1163,'1',''),(6379,1163,'2',''),(6396,1172,'1',''),(6397,1172,'2',''),(6414,1172,'1',''),(6415,1172,'2',''),(6432,1172,'1','8'),(6441,1181,'1',''),(6442,1181,'2',''),(6459,1181,'1','0'),(6460,1181,'2',''),(6477,1181,'1','1'),(6478,1181,'2','1'),(6495,1181,'1','2'),(6496,1181,'2','2'),(6513,1181,'2','3'),(6522,1181,'2','4'),(6531,1181,'2','5'),(6540,1181,'2','6'),(6549,1181,'2','7'),(6558,1190,'1',''),(6559,1190,'2',''),(6576,1190,'1','0'),(6577,1190,'2','0'),(6594,1190,'1','1'),(6595,1190,'2','1'),(6612,1190,'1','2'),(6613,1190,'2','2'),(6630,1190,'2','3'),(6639,1190,'2','4'),(6648,1190,'2','5'),(6657,1190,'2','6'),(6666,1190,'2','7'),(6675,1199,'1',''),(6676,1199,'2',''),(6693,1199,'1','0'),(6694,1199,'2','0'),(6711,1199,'1','1'),(6712,1199,'2','1'),(6729,1199,'1','2'),(6730,1199,'2','2'),(6747,1199,'2','3'),(6756,1199,'2','4'),(6765,1199,'2','5'),(6774,1199,'2','6'),(6783,1199,'2','7'),(6792,1208,'1',''),(6793,1208,'2',''),(6810,1208,'1','0'),(6811,1208,'2','0'),(6828,1208,'1','1'),(6829,1208,'2','1'),(6846,1208,'1','2'),(6847,1208,'2','2'),(6864,1208,'1','3'),(6865,1208,'2','3'),(6882,1208,'1','4'),(6883,1208,'2','4'),(6900,1208,'1','5'),(6901,1208,'2','5'),(6918,1208,'1','6'),(6919,1208,'2','6'),(6936,1208,'1','7'),(6937,1208,'2','7'),(6954,1208,'1','8'),(6963,1208,'1','9'),(6972,1217,'1',''),(6973,1217,'2',''),(6990,1217,'1',''),(6991,1217,'2','0'),(7008,1217,'2','1'),(7017,1217,'2','2'),(7026,1217,'2','3'),(7035,1217,'2','4'),(7044,1217,'2','5'),(7053,1217,'2','6'),(7062,1217,'2','7'),(7071,1226,'1',''),(7072,1226,'2',''),(7089,1226,'1',''),(7090,1226,'2','0'),(7107,1226,'1','0'),(7108,1226,'2','1'),(7125,1226,'1','1'),(7126,1226,'2','2'),(7143,1226,'1','2'),(7144,1226,'2','3'),(7161,1226,'2','4'),(7170,1226,'2','5'),(7179,1226,'2','6'),(7188,1226,'2','7'),(7197,1235,'1',''),(7198,1235,'2',''),(7215,1235,'1',''),(7216,1235,'2','0'),(7233,1235,'2','1'),(7242,1235,'2','2'),(7251,1235,'2','3'),(7260,1235,'2','4'),(7269,1235,'2','5'),(7278,1235,'2','6'),(7287,1235,'2','7'),(7296,1244,'1',''),(7297,1244,'2',''),(7314,1244,'1',''),(7315,1244,'2',''),(7332,1244,'1','0'),(7333,1244,'2','0'),(7350,1244,'1','1'),(7351,1244,'2','1'),(7368,1244,'1','2'),(7369,1244,'2','2'),(7386,1244,'2','3'),(7395,1244,'2','4'),(7404,1244,'2','5'),(7413,1244,'2','6'),(7422,1253,'1',''),(7423,1253,'2',''),(7440,1253,'1',''),(7441,1253,'2',''),(7458,1253,'1','0'),(7467,1253,'1','1'),(7476,1253,'1','2'),(7485,1262,'1',''),(7486,1262,'2',''),(7503,1262,'1',''),(7504,1262,'2','0'),(7521,1262,'1','0'),(7522,1262,'2','1'),(7539,1262,'2','2'),(7548,1262,'2','3'),(7557,1262,'2','4'),(7566,1262,'2','5'),(7575,1262,'2','6'),(7584,1262,'2','7'),(7593,1271,'1',''),(7594,1271,'2',''),(7611,1271,'1',''),(7612,1271,'2','7'),(7629,1280,'1',''),(7630,1280,'2',''),(7647,1280,'1',''),(7648,1280,'2','7'),(7665,1289,'1',''),(7666,1289,'2',''),(7683,1289,'1',''),(7684,1289,'2',''),(7701,1298,'1',''),(7702,1298,'2',''),(7719,1298,'1',''),(7720,1298,'2',''),(7737,1307,'1',''),(7738,1307,'2',''),(7755,1307,'1','0'),(7756,1307,'2',''),(7773,1307,'1','1'),(7774,1307,'2','2'),(7791,1307,'1','3'),(7800,1316,'1',''),(7801,1316,'2',''),(7818,1316,'1','0'),(7819,1316,'2',''),(7836,1316,'1','1'),(7837,1316,'2','2'),(7854,1316,'1','2'),(7863,1325,'1',''),(7864,1325,'2',''),(7881,1325,'1','0'),(7882,1325,'2',''),(7899,1325,'1','1'),(7900,1325,'2','2'),(7917,1325,'1','2'),(7926,1334,'1',''),(7927,1334,'2',''),(7944,1334,'1',''),(7945,1334,'2',''),(7962,1334,'1','1'),(7971,1334,'1','2'),(7980,1343,'1',''),(7981,1343,'2',''),(7998,1343,'1','0'),(7999,1343,'2',''),(8016,1343,'1','1'),(8017,1343,'2','2'),(8034,1343,'1','2'),(8043,1343,'1','3'),(8052,1343,'1','4'),(8061,1343,'1','5'),(8070,1343,'1','6'),(8079,1343,'1','7'),(8088,1343,'1','8'),(8097,1343,'1','9'),(8106,1352,'1',''),(8107,1352,'2',''),(8124,1352,'1','0'),(8125,1352,'2',''),(8142,1352,'1','1'),(8143,1352,'2','2'),(8160,1352,'1','2'),(8169,1352,'1','3'),(8178,1352,'1','4'),(8187,1352,'1','5'),(8196,1352,'1','6'),(8205,1352,'1','7'),(8214,1352,'1','8'),(8223,1352,'1','9'),(8232,1361,'1',''),(8233,1361,'2',''),(8250,1361,'1',''),(8251,1361,'2',''),(8268,1370,'1',''),(8269,1370,'2',''),(8286,1370,'1',''),(8287,1370,'2',''),(8304,1379,'1',''),(8305,1379,'2',''),(8322,1379,'1',''),(8323,1379,'2',''),(8340,1388,'1',''),(8341,1388,'2',''),(8358,1388,'1','0'),(8359,1388,'2',''),(8376,1388,'1','1'),(8377,1388,'2','8'),(8394,1397,'1',''),(8395,1397,'2',''),(8412,1397,'1','0'),(8413,1397,'2',''),(8430,1397,'1','1'),(8431,1397,'2','8'),(8448,1406,'1',''),(8449,1406,'2',''),(8466,1406,'1','0'),(8467,1406,'2',''),(8484,1406,'1','1'),(8485,1406,'2','8'),(8502,1415,'1',''),(8503,1415,'2',''),(8520,1415,'1','0'),(8521,1415,'2',''),(8538,1415,'1','1'),(8539,1415,'2','8'),(8556,1424,'1',''),(8557,1424,'2',''),(8574,1424,'1','0'),(8575,1424,'2',''),(8592,1424,'1','1'),(8593,1424,'2','8'),(8610,1433,'1',''),(8611,1433,'2',''),(8628,1433,'1','0'),(8629,1433,'2',''),(8646,1433,'1','1'),(8647,1433,'2','0'),(8664,1433,'2','8'),(8673,1442,'1',''),(8674,1442,'2',''),(8691,1442,'1','0'),(8692,1442,'2',''),(8709,1442,'1','1'),(8710,1442,'2','8'),(8727,1451,'1',''),(8728,1451,'2',''),(8745,1451,'1','0'),(8746,1451,'2',''),(8763,1451,'1','1'),(8764,1451,'2','8'),(8781,1460,'1',''),(8782,1460,'2',''),(8799,1460,'1','0'),(8800,1460,'2',''),(8817,1460,'1','1'),(8818,1460,'2','8'),(8835,1469,'1',''),(8836,1469,'2',''),(8853,1469,'1','0'),(8854,1469,'2',''),(8871,1469,'1','1'),(8872,1469,'2','8'),(8889,1478,'1',''),(8890,1478,'2',''),(8907,1478,'1','0'),(8908,1478,'2',''),(8925,1478,'1','1'),(8926,1478,'2','8'),(8943,1487,'1',''),(8944,1487,'2',''),(8961,1487,'1','0'),(8962,1487,'2','0'),(8979,1487,'1','1'),(8980,1487,'2','1'),(8997,1487,'2','2'),(9006,1487,'2','3'),(9015,1487,'2',''),(9024,1487,'2','5'),(9033,1487,'2','6'),(9042,1487,'2','7'),(9051,1496,'1',''),(9052,1496,'2',''),(9069,1496,'1','0'),(9070,1496,'2','0'),(9087,1496,'1','1'),(9088,1496,'2','1'),(9105,1496,'2','2'),(9114,1496,'2','3'),(9123,1496,'2','4'),(9132,1496,'2','5'),(9141,1496,'2','6'),(9150,1496,'2','7'),(9159,1496,'2','8'),(9168,1505,'1',''),(9169,1505,'2',''),(9186,1505,'1','0'),(9187,1505,'2',''),(9204,1505,'1','1'),(9205,1505,'2','8'),(9222,1514,'1',''),(9223,1514,'2',''),(9240,1514,'1','0'),(9241,1514,'2',''),(9258,1514,'1','1'),(9259,1514,'2','8'),(9276,1523,'1',''),(9277,1523,'2',''),(9294,1523,'1','0'),(9295,1523,'2',''),(9312,1523,'1','1'),(9321,1523,'1','2'),(9330,1532,'1',''),(9331,1532,'2',''),(9348,1532,'1','0'),(9349,1532,'2',''),(9366,1532,'1','1'),(9375,1532,'1','2'),(9384,1541,'2',''),(9393,1541,'1','0'),(9394,1541,'2',''),(9411,1541,'1','1'),(9420,1541,'1','2'),(9429,1550,'1',''),(9430,1550,'2',''),(9447,1550,'1',''),(9448,1550,'2','0'),(9465,1550,'2','1'),(9474,1550,'2','2'),(9483,1550,'2','3'),(9492,1550,'2','4'),(9501,1550,'2','5'),(9510,1550,'2','6'),(9519,1550,'2','7'),(9528,1550,'2','8'),(9537,1550,'2','9'),(9546,1559,'1',''),(9547,1559,'2',''),(9564,1559,'1',''),(9565,1559,'2',''),(9582,1568,'1',''),(9583,1568,'2',''),(9600,1568,'1',''),(9601,1568,'2',''),(9618,1577,'1',''),(9619,1577,'2',''),(9636,1577,'1',''),(9637,1577,'2',''),(9654,1586,'1',''),(9655,1586,'2',''),(9672,1586,'1',''),(9673,1586,'2',''),(9690,1595,'1',''),(9691,1595,'2',''),(9708,1595,'1',''),(9709,1595,'2',''),(9726,1604,'1',''),(9727,1604,'2',''),(9744,1604,'1',''),(9745,1604,'2',''),(9762,1613,'1',''),(9763,1613,'2',''),(9780,1613,'1',''),(9781,1613,'2',''),(9798,1613,'1','0'),(9799,1613,'2','0'),(9816,1613,'1','1'),(9817,1613,'2','1'),(9834,1613,'1','2'),(9835,1613,'2','2'),(9852,1613,'1','3'),(9861,1613,'1','4'),(9870,1613,'1','5'),(9879,1613,'1','6'),(9888,1613,'1','7'),(9897,1613,'1','8'),(9906,1622,'1',''),(9907,1622,'2',''),(9924,1622,'1','0'),(9925,1622,'2','0'),(9942,1622,'1','1'),(9943,1622,'2','1'),(9960,1622,'1','2'),(9961,1622,'2','2'),(9978,1622,'1','3'),(9979,1622,'2','3'),(9996,1631,'1',''),(9997,1631,'2',''),(10014,1631,'1','0'),(10015,1631,'2','0'),(10032,1631,'1','1'),(10033,1631,'2','1'),(10050,1631,'1','2'),(10051,1631,'2','2'),(10068,1631,'1','3'),(10069,1631,'2','3'),(10086,1640,'1',''),(10087,1640,'2',''),(10104,1640,'1',''),(10105,1640,'2',''),(10122,1649,'1',''),(10123,1649,'2',''),(10140,1649,'1',''),(10141,1649,'2',''),(10158,1649,'1','0'),(10159,1649,'2','0'),(10176,1649,'1','1'),(10177,1649,'2','1'),(10194,1649,'1','2'),(10195,1649,'2','2'),(10212,1649,'1','3'),(10213,1649,'2','8'),(10230,1649,'1','4'),(10239,1649,'1','7'),(10248,1658,'1',''),(10249,1658,'2',''),(10266,1658,'1',''),(10267,1658,'2',''),(10284,1658,'1','3'),(10285,1658,'2','0'),(10302,1658,'1','4'),(10303,1658,'2','1'),(10320,1658,'1','5'),(10321,1658,'2','2'),(10338,1658,'2','3'),(10347,1658,'2','4'),(10356,1667,'1',''),(10357,1667,'2',''),(10374,1667,'1',''),(10375,1667,'2',''),(10392,1667,'1','3'),(10393,1667,'2','0'),(10410,1667,'1','4'),(10411,1667,'2','1'),(10428,1667,'1','5'),(10429,1667,'2','2'),(10446,1667,'2','3'),(10455,1667,'2','4'),(10464,1676,'1',''),(10465,1676,'2',''),(10482,1676,'1',''),(10483,1676,'2',''),(10500,1676,'1','4'),(10501,1676,'2','1'),(10518,1676,'1','5'),(10519,1676,'2','3'),(10536,1685,'1',''),(10537,1685,'2',''),(10554,1685,'1',''),(10555,1685,'2','0'),(10572,1685,'1','3'),(10573,1685,'2','1'),(10590,1685,'1','4'),(10591,1685,'2','2'),(10608,1685,'1','5'),(10609,1685,'2','7'),(10626,1694,'1',''),(10627,1694,'2',''),(10644,1694,'1',''),(10645,1694,'2','0'),(10662,1694,'1','3'),(10663,1694,'2','1'),(10680,1694,'1','4'),(10681,1694,'2','2'),(10698,1694,'1','5'),(10699,1694,'2','7'),(10716,1703,'1',''),(10717,1703,'2',''),(10734,1703,'1',''),(10735,1703,'2','0'),(10752,1703,'1','3'),(10753,1703,'2','1'),(10770,1703,'1','4'),(10771,1703,'2','2'),(10788,1703,'1','5'),(10789,1703,'2','7'),(10806,1712,'1',''),(10807,1712,'2',''),(10824,1712,'1',''),(10825,1712,'2',''),(10842,1721,'1',''),(10843,1721,'2',''),(10860,1721,'1',''),(10861,1721,'2',''),(10878,1730,'1',''),(10879,1730,'2',''),(10896,1730,'1',''),(10897,1730,'2',''),(10914,1739,'1',''),(10915,1739,'2',''),(10932,1748,'1',''),(10933,1748,'2',''),(10950,1748,'1','0'),(10951,1748,'2',''),(10968,1748,'1','1'),(10977,1748,'1','2'),(10986,1757,'1',''),(10987,1757,'2',''),(11004,1757,'1',''),(11005,1757,'2',''); +/*!40000 ALTER TABLE marc_indicators_value ENABLE KEYS */; +UNLOCK TABLES; + + +-- +-- Dumping data for table marc_indicators_desc +-- + +LOCK TABLES marc_indicators_desc WRITE; +/*!40000 ALTER TABLE marc_indicators_desc DISABLE KEYS */; +INSERT INTO marc_indicators_desc VALUES (1,'en','Undefined'),(2,'en','Undefined'),(21,'en','Undefined'),(22,'en','Undefined'),(41,'en','Undefined'),(42,'en','Undefined'),(59,'en','Undefined'),(60,'en','Undefined'),(77,'en','Undefined'),(78,'en','Undefined'),(95,'en','Undefined'),(96,'en','Undefined'),(113,'en','National bibliographic agency'),(114,'en','Undefined'),(131,'en','Library and Archives Canada'),(132,'en','Undefined'),(149,'en','Source specified in subfield $2. Used when the source of the control number is indicated by a code in subfield $2. Codes from : MARC Code List for Organizations'),(158,'en','Undefined'),(159,'en','Undefined'),(176,'en','Undefined'),(177,'en','Undefined'),(194,'en','Undefined'),(195,'en','Undefined'),(212,'en','Undefined'),(213,'en','Undefined'),(230,'en','Undefined'),(231,'en','Undefined'),(250,'en','Undefined'),(251,'en','Undefined'),(270,'en','Level of international interest'),(271,'en','Undefined'),(290,'en','No level specified'),(291,'en','Undefined'),(310,'en','Continuing resource of international interest'),(320,'en','Continuing resource not of international interest'),(330,'en','Type of standard number or code'),(331,'en','Difference indicator'),(348,'en','International Standard Recording Code'),(349,'en','No information provided'),(366,'en','Universal Product Code'),(367,'en','No difference'),(384,'en','International Standard Music Number'),(385,'en','Difference'),(402,'en','International Article Number'),(411,'en','Serial Item and Contribution Identifier'),(420,'en','Source specified in sufield $2'),(429,'en','Unspecified type of starndard number or code'),(438,'en','Undefined'),(439,'en','Undefined'),(456,'en','Undefined'),(457,'en','Undefined'),(474,'en','Undefined'),(475,'en','Undefined'),(492,'en','Undefined'),(493,'en','Undefined'),(510,'en','Undefined'),(511,'en','Undefined'),(528,'en','Undefined'),(529,'en','Undefined'),(546,'en','Type of publisher number'),(547,'en','Note/added entry controller'),(564,'en','Issue number. Number used to indentify the issue designation, or serial identifiation, assigned by a publisher to a specific sound recording, side of a sound recording, or performance on a sound recording or to a group of sound recording issued as a set.'),(565,'en','No note, no added entry'),(582,'en','Matrix number. Master from witch the specific recording was pressed.'),(583,'en','Note, added entry'),(600,'en','Plate number. Assigned by a publisher to a specific music publication.'),(601,'en','Note, no added entry'),(618,'en','Other music number'),(619,'en','No note, added entry'),(636,'en','Videorecording number'),(645,'en','Other publisher number'),(654,'en','Undefined'),(655,'en','Undefined'),(672,'en','Undefined'),(673,'en','Undefined'),(690,'en','Undefined'),(691,'en','Undefined'),(708,'en','Undefined'),(709,'en','#- Undefined'),(726,'en','Undefined'),(727,'en','Undefined'),(744,'en','# -Undefined'),(745,'en','Undefined'),(762,'en','Type of date in subfield $a'),(763,'en','Type of event'),(780,'en','No date information'),(781,'en','No information provided'),(798,'en','Single date'),(799,'en','Capture. Pertains to the recording of sound, the filming of visual images, the making or producing of a item, or other form of creation of an item'),(816,'en','Multiple single dates'),(817,'en','Broadcast. Pertains to the broadcasting (i.e., transmission) or re-boardcasting of sound or visual images.'),(834,'en','Range of dates'),(835,'en','Finding. Pertains to the finding of a naturally ocurring object.'),(852,'en','Type of scale Specifies the type of scale information given'),(853,'en','Type of ring'),(870,'en','Scale indeterminable/No scale recorded. Used when no representative fraction is given in field 255.'),(871,'en','Not applicable'),(888,'en','Single scale'),(889,'en','Outer ring'),(906,'en','Range of scales'),(907,'en','Exclusion ring'),(924,'en','Undefined'),(925,'en','Undefined'),(942,'en','Undefined'),(943,'en','Undefined'),(960,'en','Undefined'),(961,'en','Undefined'),(978,'en','Undefined'),(979,'en','Undefined'),(996,'en','Undefined'),(997,'en','Undefined'),(1014,'en','# -Undefined'),(1015,'en','Undefined'),(1032,'en','Undefined'),(1033,'en','Undefined'),(1050,'en','# -Undefined'),(1051,'en','Undefined'),(1068,'en','Undefined'),(1069,'en','Undefined'),(1086,'en','Undefined'),(1087,'en','Undefined'),(1104,'en','Translation indication'),(1105,'en','Source of code'),(1122,'en','Item not a translation/ does not include a translation'),(1123,'en','MARC language code'),(1140,'en','Item is or includes a translation'),(1141,'en','Source specified in subfield $2'),(1158,'en','Undefined'),(1159,'en','Undefined'),(1176,'en','Undefined'),(1177,'en','Undefined'),(1194,'en','Undefined'),(1195,'en','Undefined'),(1212,'en','Undefined'),(1213,'en','Undefined'),(1230,'en','Undefined'),(1231,'en','Undefined'),(1248,'en','Undefined'),(1249,'en','Undefined'),(1266,'en','Type of time period in subfield $b or $c'),(1267,'en','Undefined'),(1284,'en','Subfield $b or $c not present'),(1285,'en','Undefined'),(1302,'en','Single date/time'),(1311,'en','Multiple sigle dates/times. Multiple $b and/or $c subfields are present, each containing a date/time.'),(1320,'en','Range of dates/times. Two $b and/or $c subfields are present and contain a range of dates/times'),(1329,'en','Undefined'),(1330,'en','Undefined'),(1347,'en','Undefined'),(1348,'en','Undefined'),(1365,'en','Undefined'),(1366,'en','Undefined'),(1383,'en','# -Undefined'),(1384,'en','Undefined'),(1401,'en','Undefined'),(1402,'en','Undefined'),(1419,'en','Undefined'),(1420,'en','Undefined'),(1437,'en','Existence in LC collection'),(1438,'en','Source of call number'),(1457,'en','No information provided. Used for all call numbers assigned by agencies other than the Library of Congress'),(1458,'en','Assigned by LC. Used when an institution is transcribing from lC cataloging copy.'),(1477,'en','Item is in LC. Other agencies should use this value when transcribing from LC cataloging copy on which the call number is neither enclosed within brackets nor preceded by a Maltese cross'),(1478,'en','Assigned by agency other than LC.'),(1497,'en','Item is not in LC. Used by other agencies when transcribing from LC copy on the call number appears in brackets or is preceded by a Maltese cross. Brackets that customarily surround call numbers for items not in LC are not carried in the MARC record; they may be generated for display.'),(1507,'en','Undefined'),(1508,'en','Undefined'),(1525,'en','Undefined'),(1526,'en','Undefined'),(1543,'en','Code source'),(1544,'en','Undefined'),(1561,'en','Library of Congress Classification'),(1562,'en','Undefined'),(1579,'en','U.S. Dept. of Defense Classification'),(1588,'en','Source specified in subfield $2'),(1597,'en','Existence in LAC collection'),(1598,'en','Type, completeness, source of class/call number'),(1615,'en','Information not provided. Used in any record input by an institution other than LAC.'),(1616,'en','LC - based call number assigned by LAC'),(1633,'en','Work held by LAC'),(1634,'en','Complete LC class number assigned by LAC'),(1651,'en','Work not held by LAC'),(1652,'en','Incomplete LC class number asigned by LAC'),(1669,'en','LC- based call number assigned by the contibuting library'),(1678,'en','4 -Complete LC class number assigned by the contributing library'),(1687,'en','Incomplete LC class number assigned by de contributing library'),(1696,'en','Other call number assigned by LAC'),(1705,'en','Other class number assigned by LAC'),(1714,'en','Other call number assigned by the contributing library'),(1723,'en','Other class number assigned by the contributing library'),(1732,'en','Existence in NLM collection'),(1733,'en','Source of call number'),(1750,'en','# -No information provided. Used for call numbers assigned by an organization other than NLM'),(1751,'en','Assigned by NLM'),(1768,'en','Item is in NLM'),(1769,'en','Assigned by agency other than NLM'),(1786,'en','Item is not in NLM'),(1795,'en','Undefined'),(1796,'en','Undefined'),(1813,'en','Undefined'),(1814,'en','Undefined'),(1831,'en','Undefined'),(1832,'en','Undefined'),(1849,'en','# -Undefined'),(1850,'en','Undefined'),(1867,'en','Existence in NAL collection'),(1868,'en','Undefined'),(1885,'en','Item is in NAL'),(1886,'en','Undefined'),(1903,'en','Item is not in NAL'),(1912,'en','Undefined'),(1913,'en','Undefined'),(1930,'en','Undefined'),(1931,'en','# -Undefined'),(1948,'en','Undefined'),(1949,'en','Code source'),(1966,'en','Undefined'),(1967,'en','0 -NAL subject category code list'),(1984,'en','Source specified in subfield $2'),(1993,'en','Undefined'),(1994,'en','Undefined'),(2011,'en','Undefined'),(2012,'en','# -Undefined'),(2029,'en','Undefined'),(2030,'en','Undefined'),(2047,'en','Undefined'),(2048,'en','Undefined'),(2065,'en','Type of edition'),(2066,'en','Source of classification number'),(2083,'en','Full edition'),(2084,'en','No information provided'),(2101,'en','Abridged edition'),(2102,'en','Assigned by LC. May be used by organizations transcribing from LC copy'),(2119,'en','Assigned by agency other than LC'),(2128,'en','Undefined'),(2129,'en','Undefined'),(2146,'en','Undefined'),(2147,'en','Undefined'),(2164,'en','Number source'),(2165,'en','Undefined'),(2182,'en','Source specified in subfield $2. Classification number other than the U.S. or Canadian scheme'),(2183,'en','Undefined'),(2200,'en','Superintendent of Documents Classification System. Assigned by the U.S. Government Printing Office. Supt.of Docs.no.: may be generated for display'),(2209,'en','Government of Canada Publications: Outline of Classification'),(2218,'en','Undefined'),(2219,'en','Undefined'),(2236,'en','Undefined'),(2237,'en','# -Undefined'),(2254,'en','Type of personal name entry element'),(2255,'en','Undefined'),(2274,'en','Forename. Forename or a name consisting of words, initials, letters,etc., that are formatted in direc order'),(2275,'en','Undefined'),(2294,'en','Surname. Single or multiple surname formatted in inverted order or a single name without forenames that is known to be a surname.'),(2304,'en','Family name. Name represents a family, clan, dynasty, house, or other such group and may be formatted in direct or inverted order.'),(2314,'en','Type of corporate name entry element'),(2315,'en','Undefined'),(2332,'en','Inverted name. Corporate name begins with a personal name in inverted order.'),(2333,'en','Undefined'),(2350,'en','1- Jurisdiction name. Name of a jurisdiction that is also an ecclesiastical entity or is a jurisdiction name under which a corporate name or a title of a work is entered.'),(2359,'en','Name in direct order.'),(2368,'en','Type of meeting name entry element'),(2369,'en','Undefined'),(2386,'en','Inverted name. Meeting name begins with a personal name in inverted order.'),(2387,'en','Undefined'),(2404,'en','1 -Jurisdiction name. Jurisdiction name under which a meeting name is entered'),(2413,'en','Name in direct order'),(2422,'en','Nonfiling characters'),(2423,'en','Undefined'),(2440,'en','Number of nonfiling characters'),(2441,'en','Undefined'),(2458,'en','Number of nonfiling characters'),(2467,'en','Number of nonfiling characters'),(2476,'en','Number of nonfiling characters'),(2485,'en','Number of nonfiling characters'),(2494,'en','Number of nonfiling characters'),(2503,'en','Number of nonfiling characters'),(2512,'en','Number of nonfiling characters'),(2521,'en','Number of nonfiling characters'),(2530,'en','Number of nonfiling characters'),(2539,'en','Title added entry'),(2540,'en','Type'),(2557,'en','No added entry'),(2558,'en','Abbreviated key title'),(2575,'en','Added entry'),(2576,'en','Other abbreviated title'),(2593,'en','Undefined'),(2594,'en','Nonfiling characters'),(2611,'en','Undefined'),(2612,'en','No nonfiling characters'),(2629,'en','Number of nonfiling characters'),(2638,'en','Number of nonfiling characters'),(2647,'en','Number of nonfiling characters'),(2656,'en','Number of nonfiling characters'),(2665,'en','Number of nonfiling characters'),(2674,'en','Number of nonfiling characters'),(2683,'en','Number of nonfiling characters'),(2692,'en','Number of nonfiling characters'),(2701,'en','Number of nonfiling characters'),(2710,'en','Uniform title printed or displayed'),(2711,'en','Nonfiling characters'),(2728,'en','Not printed or displayed'),(2729,'en','Number of nonfiling characters'),(2746,'en','Printed or displayed'),(2747,'en','Number of nonfiling characters'),(2764,'en','Number of nonfiling characters'),(2773,'en','Number of nonfiling characters'),(2782,'en','Number of nonfiling characters'),(2791,'en','Number of nonfiling characters'),(2800,'en','Number of nonfiling characters'),(2809,'en','Number of nonfiling characters'),(2818,'en','Number of nonfiling characters'),(2827,'en','Number of nonfiling characters'),(2836,'en','Title added entry'),(2837,'en','Nonfiling characters'),(2854,'en','No added entry'),(2855,'en','No nonfiling characters'),(2872,'en','Added entry'),(2873,'en','Number of nonfiling characters'),(2890,'en','Number of nonfiling characters'),(2899,'en','Number of nonfiling characters'),(2908,'en','Number of nonfiling characters'),(2917,'en','Number of nonfiling characters'),(2926,'en','Number of nonfiling characters'),(2935,'en','Number of nonfiling characters'),(2944,'en','Number of nonfiling characters'),(2953,'en','Number of nonfiling characters'),(2962,'en','Title added entry'),(2963,'en','Nonfiling characters'),(2982,'en','No added entry. No title added entry is made, either because no title added entry is desired or because the title added entry is not traced the same as the title in field 245'),(2983,'en','No nonfiling characters'),(3002,'en','Added entry. Desired title added entry is the same as the title in field 245'),(3003,'en','Number of nonfiling characters'),(3022,'en','Number of nonfiling characters'),(3032,'en','Number of nonfiling characters'),(3042,'en','Number of nonfiling characters'),(3052,'en','Number of nonfiling characters'),(3062,'en','Number of nonfiling characters'),(3072,'en','Number of nonfiling characters'),(3082,'en','Number of nonfiling characters'),(3092,'en','Number of nonfiling characters'),(3102,'en','Note/added entry controller'),(3103,'en','Type of title'),(3120,'en','Note, no added entry'),(3121,'en','No type specified'),(3138,'en','Note, added entry'),(3139,'en','Portion of title'),(3156,'en','No note, no added entry'),(3157,'en','Parallel title'),(3174,'en','No note, added entry'),(3175,'en','Distintictive title'),(3192,'en','Other title'),(3201,'en','Cover title'),(3210,'en','Added title page title'),(3219,'en','Caption title'),(3228,'en','Running title'),(3237,'en','Spine title'),(3246,'en','Title added entry'),(3247,'en','Note controller'),(3264,'en','No added entry'),(3265,'en','Display note'),(3282,'en','Added entry'),(3283,'en','Do not display note'),(3300,'en','Undefined'),(3301,'en','Undefined'),(3320,'en','Undefined'),(3321,'en','Undefined'),(3340,'en','Undefined'),(3341,'en','Undefined'),(3358,'en','Undefined'),(3359,'en','Undefined'),(3376,'en','Undefined'),(3377,'en','Undefined'),(3394,'en','Undefined'),(3395,'en','Undefined'),(3412,'en','Undefined'),(3413,'en','Undefined'),(3430,'en','Undefined'),(3431,'en','Undefined'),(3448,'en','Undefined'),(3449,'en','Undefined'),(3466,'en','Undefined'),(3467,'en','Undefined'),(3484,'en','Undefined'),(3485,'en','Undefined'),(3502,'en','Undefined'),(3503,'en','Undefined'),(3520,'en','Sequence of publishing statements'),(3521,'en','Undefined'),(3540,'en','Not applicable/ No information provided/ Earliest available publisher'),(3541,'en','Undefined'),(3560,'en','Intervening publisher'),(3570,'en','3- Current/latest publisher'),(3580,'en','Undefined'),(3581,'en','Undefined'),(3598,'en','# -Undefined'),(3599,'en','# -Undefined'),(3616,'en','Level'),(3617,'en','Type of address'),(3634,'en','No level specified'),(3635,'en','No type specified'),(3652,'en','Primary'),(3653,'en','Mailing'),(3670,'en','Secondary'),(3671,'en','Type specified in subfield $i'),(3688,'en','Undefined'),(3689,'en','Undefined'),(3708,'en','# -Undefined'),(3709,'en','# -Undefined'),(3728,'en','Undefined'),(3729,'en','Undefined'),(3746,'en','Undefined'),(3747,'en','Undefined'),(3764,'en','Display constant controller'),(3765,'en','Undefined'),(3782,'en','Hours'),(3783,'en','Undefined'),(3800,'en','No display constant generated'),(3809,'en','Undefined'),(3810,'en','Undefined'),(3827,'en','Undefined'),(3828,'en','Undefined'),(3845,'en','Undefined'),(3846,'en','Undefined'),(3863,'en','Undefined'),(3864,'en','Undefined'),(3881,'en','Undefined'),(3882,'en','Undefined'),(3899,'en','Undefined'),(3900,'en','Undefined'),(3917,'en','Geospatial reference dimension'),(3918,'en','Geospatial reference method'),(3935,'en','Horizontal coordinate system'),(3936,'en','Geographic'),(3953,'en','Vertical coordinate system'),(3954,'en','Map projection'),(3971,'en','Grid coordinate system'),(3980,'en','Local planar'),(3989,'en','Local'),(3998,'en','Geodentic model'),(4007,'en','Altitude'),(4016,'en','Method specified in $2'),(4025,'en','Depth'),(4034,'en','Undefined'),(4035,'en','Undefined'),(4052,'en','# -Undefined'),(4053,'en','# -Undefined'),(4070,'en','Undefined'),(4071,'en','Undefined'),(4088,'en','Undefined'),(4089,'en','Undefined'),(4106,'en','Undefined'),(4107,'en','Undefined'),(4124,'en','Undefined'),(4125,'en','# -Undefined'),(4142,'en','Controlled element'),(4143,'en','Undefined'),(4160,'en','Document'),(4161,'en','Undefined'),(4178,'en','Títle'),(4187,'en','Abstract'),(4196,'en','Contents note'),(4205,'en','Author'),(4214,'en','Record'),(4223,'en','None of the above'),(4232,'en','Undefined'),(4233,'en','Undefined'),(4250,'en','# -Undefined'),(4251,'en','Undefined'),(4268,'en','Format of date'),(4269,'en','Undefined'),(4286,'en','Formatted style'),(4287,'en','Undefined'),(4304,'en','Unformatted note'),(4313,'en','Undefined'),(4314,'en','Undefined'),(4331,'en','Undefined'),(4332,'en','Undefined'),(4349,'en','Undefined'),(4350,'en','Undefined'),(4367,'en','Undefined'),(4368,'en','Undefined'),(4385,'en','Series tracing policy'),(4386,'en','Undefined'),(4403,'en','Series not traced'),(4404,'en','Undefined'),(4421,'en','Series traced'),(4430,'en','Undefined'),(4431,'en','Undefined'),(4450,'en','Undefined'),(4451,'en','Undefined'),(4470,'en','Undefined'),(4471,'en','Undefined'),(4488,'en','Undefined'),(4489,'en','Undefined'),(4506,'en','Undefined'),(4507,'en','Undefined'),(4524,'en','Undefined'),(4525,'en','Undefined'),(4542,'en','Undefined'),(4543,'en','Undefined'),(4560,'en','Undefined'),(4561,'en','Undefined'),(4578,'en','Display constant controller'),(4579,'en','Level of content designation'),(4596,'en','Contents'),(4597,'en','Basic'),(4614,'en','Incomplete contents'),(4615,'en','Enhanced'),(4632,'en','Partial contents'),(4641,'en','No display constant generated'),(4650,'en','Restriction'),(4651,'en','Undefined'),(4668,'en','No information provided'),(4669,'en','Undefined'),(4686,'en','No restrictions'),(4695,'en','Restrictions apply'),(4704,'en','Undefined'),(4705,'en','Undefined'),(4722,'en','Undefined'),(4723,'en','Undefined'),(4740,'en','Undefined'),(4741,'en','Undefined'),(4758,'en','Undefined'),(4759,'en','Undefined'),(4776,'en','Coverage/location in source'),(4777,'en','Undefined'),(4794,'en','Coverage unknown'),(4795,'en','Undefined'),(4812,'en','Coverage complete'),(4821,'en','Coverage is selective'),(4830,'en','Location in source not given'),(4839,'en','Location in source given'),(4848,'en','Display constant controller'),(4849,'en','Undefined'),(4866,'en','No display constant generated'),(4867,'en','Undefined'),(4884,'en','Cast'),(4893,'en','Undefined'),(4894,'en','Undefined'),(4911,'en','# -Undefined'),(4912,'en','Undefined'),(4929,'en','Undefined'),(4930,'en','Undefined'),(4947,'en','Undefined'),(4948,'en','Undefined'),(4965,'en','Undefined'),(4966,'en','Undefined'),(4983,'en','Undefined'),(4984,'en','Undefined'),(5001,'en','Display constant controller'),(5002,'en','Undefined'),(5019,'en','Type of file'),(5020,'en','Undefined'),(5037,'en','No display constant generated'),(5046,'en','Undefined'),(5047,'en','Undefined'),(5064,'en','Undefined'),(5065,'en','Undefined'),(5082,'en','Display constant controller'),(5083,'en','Undefined'),(5100,'en','Summary'),(5101,'en','Undefined'),(5118,'en','Subject'),(5127,'en','Review'),(5136,'en','Scope and content'),(5145,'en','Content advice'),(5154,'en','Abstract'),(5163,'en','No display constant generated'),(5172,'en','Display constant controller'),(5173,'en','Undefined'),(5190,'en','Audience'),(5191,'en','Undefined'),(5208,'en','Reading grade level'),(5217,'en','Interest age level'),(5226,'en','Interest grade level'),(5235,'en','Special audience characteristics'),(5244,'en','Motivation/interest level'),(5253,'en','No display constant generated'),(5262,'en','Display constant controller'),(5263,'en','Undefined'),(5280,'en','Geographic coverage'),(5281,'en','Undefined'),(5298,'en','No display constant generated'),(5307,'en','Display constant controller'),(5308,'en','Undefined'),(5325,'en','Cite as'),(5326,'en','Undefined'),(5343,'en','No display constant generated'),(5352,'en','Undefined'),(5353,'en','Undefined'),(5370,'en','# -Undefined'),(5371,'en','Undefined'),(5388,'en','Display constant controller'),(5389,'en','Undefined'),(5406,'en','Reading program'),(5407,'en','Undefined'),(5424,'en','No display constant generated'),(5433,'en','Undefined'),(5434,'en','Undefined'),(5451,'en','Undefined'),(5452,'en','Undefined'),(5469,'en','Undefined'),(5470,'en','Undefined'),(5487,'en','# -Undefined'),(5488,'en','Undefined'),(5505,'en','Undefined'),(5506,'en','Undefined'),(5523,'en','Undefined'),(5524,'en','Undefined'),(5541,'en','Custodial role'),(5542,'en','Undefined'),(5559,'en','Holder of originals'),(5560,'en','Undefined'),(5577,'en','Holder of duplicates'),(5586,'en','Undefined'),(5587,'en','Undefined'),(5604,'en','# -Undefined'),(5605,'en','Undefined'),(5622,'en','Undefined'),(5623,'en','Undefined'),(5640,'en','Undefined'),(5641,'en','Undefined'),(5658,'en','Undefined'),(5659,'en','Undefined'),(5676,'en','Undefined'),(5677,'en','Undefined'),(5694,'en','Undefined'),(5695,'en','Undefined'),(5712,'en','# -Undefined'),(5713,'en','Undefined'),(5730,'en','Relationship'),(5731,'en','Undefined'),(5748,'en','No information provided'),(5749,'en','Undefined'),(5766,'en','Associated materials. Other materials identified in the note have the same provenance but reside in a different repository'),(5775,'en','Related materials. Other materials identified in the note share of activity, reside in the same repository, but have different provenance.'),(5784,'en','Undefined'),(5785,'en','Undefined'),(5802,'en','Undefined'),(5803,'en','Undefined'),(5820,'en','Undefined'),(5821,'en','Undefined'),(5838,'en','Undefined'),(5839,'en','Undefined'),(5856,'en','Undefined'),(5857,'en','Undefined'),(5874,'en','Undefined'),(5875,'en','Undefined'),(5892,'en','Undefined'),(5893,'en','Undefined'),(5910,'en','Undefined'),(5911,'en','Undefined'),(5928,'en','Display constant controller'),(5929,'en','Undefined'),(5946,'en','Undefined'),(5955,'en','No display constant generated'),(5964,'en','Display constant controller'),(5965,'en','Undefined'),(5982,'en','Undefined'),(5991,'en','No display constant generated'),(6000,'en','Undefined'),(6001,'en','Undefined'),(6018,'en','# -Undefined'),(6019,'en','Undefined'),(6036,'en','Undefined'),(6037,'en','Undefined'),(6054,'en','# -Undefined'),(6055,'en','Undefined'),(6072,'en','Undefined'),(6073,'en','Undefined'),(6090,'en','Undefined'),(6091,'en','Undefined'),(6108,'en','Display constant controller'),(6109,'en','Undefined'),(6126,'en','File size'),(6127,'en','Undefined'),(6144,'en','Case file characteristics'),(6153,'en','No display constant generated'),(6162,'en','Display constant controller'),(6163,'en','Undefined'),(6180,'en','Methodology'),(6181,'en','# -Undefined'),(6198,'en','No display constant generated'),(6207,'en','Undefined'),(6208,'en','Undefined'),(6225,'en','# -Undefined'),(6226,'en','Undefined'),(6243,'en','Display constant controller'),(6244,'en','Undefined'),(6261,'en','Publications'),(6262,'en','Undefined'),(6279,'en','No display constant generated'),(6288,'en','Undefined'),(6289,'en','Undefined'),(6306,'en','# -Undefined'),(6307,'en','Undefined'),(6324,'en','Undefined'),(6325,'en','Undefined'),(6342,'en','Undefined'),(6343,'en','Undefined'),(6360,'en','Undefined'),(6361,'en','Undefined'),(6378,'en','Undefined'),(6379,'en','# -Undefined'),(6396,'en','Display constant controller'),(6397,'en','Undefined'),(6414,'en','Awards'),(6415,'en','Undefined'),(6432,'en','No display constant generated'),(6441,'en','Type of personal name entry element'),(6442,'en','Thesaurus'),(6459,'en','Forename'),(6460,'en','0 -Library of Congress Subject Headings'),(6477,'en','Surname.'),(6478,'en','LC subject headings for children\'s literature.'),(6495,'en','Family Name'),(6496,'en','Medical Subject Headings. '),(6513,'en','National Agricultural Library subject authority file'),(6522,'en','Source not specified'),(6531,'en','Canadian Subject Headings'),(6540,'en','Répertoire de vedettes-matière'),(6549,'en','Source specified in subfield $2'),(6558,'en','Type of corporate name entry element'),(6559,'en','Thesaurus'),(6576,'en','Inverted name'),(6577,'en','Library of Congress Subject Headings'),(6594,'en','Juridistion name'),(6595,'en','LC subject headings for children\'s literature.'),(6612,'en','Name in direct order'),(6613,'en','Medical Subject Headings.'),(6630,'en','National Agricultural Library subject authority file'),(6639,'en','Source not specified'),(6648,'en','Canadian Subject Headings'),(6657,'en','Répertoire de vedettes-matière. '),(6666,'en','Source specified in subfield $2'),(6675,'en','Type of meeting name entry element'),(6676,'en','Thesaurus'),(6693,'en','Inverted name'),(6694,'en','Library of Congress Subject Headings'),(6711,'en','Juridistion name'),(6712,'en','LC subject headings for children\'s literature. '),(6729,'en','Name in direct order'),(6730,'en','Medical Subject Headings. '),(6747,'en','National Agricultural Library subject authority file'),(6756,'en','Source not specified'),(6765,'en','Canadian Subject Headings'),(6774,'en','Répertoire de vedettes-matière'),(6783,'en','Source specified in subfield $2'),(6792,'en','Nonfiling characters'),(6793,'en','Thesaurus'),(6810,'en','Number of nonfiling characters'),(6811,'en','Library of Congress Subject Headings'),(6828,'en','Number of nonfiling characters'),(6829,'en','LC subject headings for children\'s literature. '),(6846,'en','Number of nonfiling characters'),(6847,'en','Medical Subject Headings. '),(6864,'en','Number of nonfiling characters'),(6865,'en','National Agricultural Library subject authority file'),(6882,'en','Number of nonfiling characters'),(6883,'en','Source not specified'),(6900,'en','Number of nonfiling characters'),(6901,'en','Canadian Subject Headings'),(6918,'en','Number of nonfiling characters'),(6919,'en','Répertoire de vedettes-matière'),(6936,'en','Number of nonfiling characters'),(6937,'en','Source specified in subfield $2'),(6954,'en','Number of nonfiling characters'),(6963,'en','Number of nonfiling characters'),(6972,'en','Undefined'),(6973,'en','Thesaurus'),(6990,'en','Undefined'),(6991,'en','Library of Congress Subject Headings'),(7008,'en','LC subject headings for children\'s literature. '),(7017,'en','Medical Subject Headings. '),(7026,'en','National Agricultural Library subject authority file'),(7035,'en','Source not specified'),(7044,'en','Canadian Subject Headings'),(7053,'en','Répertoire de vedettes-matière'),(7062,'en','Source specified in subfield $2'),(7071,'en','Level of subject'),(7072,'en','Thesaurus'),(7089,'en','No information provided'),(7090,'en','Library of Congress Subject Headings'),(7107,'en','No level specified'),(7108,'en','LC subject headings for children\'s literature. '),(7125,'en','Primary'),(7126,'en','Medical Subject Headings. '),(7143,'en','Secondary'),(7144,'en','National Agricultural Library subject authority file'),(7161,'en','Source not specified'),(7170,'en','Canadian Subject Headings'),(7179,'en','Répertoire de vedettes-matière'),(7188,'en','Source specified in subfield $2'),(7197,'en','Undefined'),(7198,'en','Thesaurus'),(7215,'en','Undefined'),(7216,'en','Library of Congress Subject Headings'),(7233,'en','LC subject headings for children\'s literature. '),(7242,'en','Medical Subject Headings. '),(7251,'en','National Agricultural Library subject authority file'),(7260,'en','Source not specified'),(7269,'en','Canadian Subject Headings'),(7278,'en','Répertoire de vedettes-matière'),(7287,'en','Source specified in subfield $2'),(7296,'en','Level of index term'),(7297,'en','Type of term or name'),(7314,'en','No information provided'),(7315,'en','No information provided'),(7332,'en','No level specified'),(7333,'en','Topical term'),(7350,'en','Primary'),(7351,'en','Personal name'),(7368,'en','Secondary'),(7369,'en','Corporate name'),(7386,'en','Meeting name'),(7395,'en','Chronological term'),(7404,'en','Geographic name'),(7413,'en','Genre/form term'),(7422,'en','Level of subject'),(7423,'en','Undefined'),(7440,'en','No information provided'),(7441,'en','Undefined'),(7458,'en','No level specified'),(7467,'en','Primary'),(7476,'en','Secondary'),(7485,'en','Type of heading'),(7486,'en','Thesaurus'),(7503,'en','Basic'),(7504,'en','Library of Congress Subject Headings'),(7521,'en','Faceted'),(7522,'en','LC subject headings for children\'s literature. '),(7539,'en','Medical Subject Headings. '),(7548,'en','National Agricultural Library subject authority file'),(7557,'en','Source not specified'),(7566,'en','Canadian Subject Headings'),(7575,'en','Répertoire de vedettes-matière'),(7584,'en','Source specified in subfield $2'),(7593,'en','Undefined'),(7594,'en','Source of term'),(7611,'en','Undefined'),(7612,'en','Source specified in subfield $2'),(7629,'en','Undefined'),(7630,'en','Source of term'),(7647,'en','Undefined'),(7648,'en','Source specified in subfield $2'),(7665,'en','Undefined'),(7666,'en','Undefined'),(7683,'en','Undefined'),(7684,'en','Undefined'),(7701,'en','Undefined'),(7702,'en','Undefined'),(7719,'en','Undefined'),(7720,'en','Undefined'),(7737,'en','Type of personal name entry element'),(7738,'en','Type of added entry'),(7755,'en','Forename'),(7756,'en','No information provided'),(7773,'en','Surname.'),(7774,'en','Analytical entry'),(7791,'en','Family name'),(7800,'en','Type or corporate name entry element'),(7801,'en','Type of added entry'),(7818,'en','Inverted name'),(7819,'en','No information provided'),(7836,'en','Juridistion name'),(7837,'en','Analytical entry'),(7854,'en','Name in direct order'),(7863,'en','Type of meeting name entry element'),(7864,'en','Type of added entry'),(7881,'en','Inverted name'),(7882,'en','No information provided'),(7899,'en','Juridistion name'),(7900,'en','Analytical entry'),(7917,'en','Name in direct order'),(7926,'en','Type of name'),(7927,'en','Undefined'),(7944,'en','Not specified'),(7945,'en','Undefined'),(7962,'en','Personal'),(7971,'en','Other'),(7980,'en','Nonfiling characters'),(7981,'en','Type of added entry'),(7998,'en','Number of nonfiling characters'),(7999,'en','No information provided'),(8016,'en','Number of nonfiling characters'),(8017,'en','Analytical entry'),(8034,'en','Number of nonfiling characters'),(8043,'en','Number of nonfiling characters'),(8052,'en','Number of nonfiling characters'),(8061,'en','Number of nonfiling characters'),(8070,'en','Number of nonfiling characters'),(8079,'en','Number of nonfiling characters'),(8088,'en','Number of nonfiling characters'),(8097,'en','Number of nonfiling characters'),(8106,'en','Nonfiling characters'),(8107,'en','Type of added entry'),(8124,'en','No nonfiling characters'),(8125,'en','No information provided'),(8142,'en','Number of nonfiling characters'),(8143,'en','Analytical entry'),(8160,'en','Number of nonfiling characters'),(8169,'en','Number of nonfiling characters'),(8178,'en','Number of nonfiling characters'),(8187,'en','Number of nonfiling characters'),(8196,'en','Number of nonfiling characters'),(8205,'en','Number of nonfiling characters'),(8214,'en','Number of nonfiling characters'),(8223,'en','Number of nonfiling characters'),(8232,'en','Undefined'),(8233,'en','Undefined'),(8250,'en','Undefined'),(8251,'en','Undefined'),(8268,'en','Undefined'),(8269,'en','Undefined'),(8286,'en','Undefined'),(8287,'en','Undefined'),(8304,'en','Undefined'),(8305,'en','Undefined'),(8322,'en','Undefined'),(8323,'en','Undefined'),(8340,'en','Note controller'),(8341,'en','Display constant controller'),(8358,'en','Display note'),(8359,'en','Main series'),(8376,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8377,'en','No display constant generated'),(8394,'en','Note controller'),(8395,'en','Display constant controller'),(8412,'en','Display note'),(8413,'en','Has subseries'),(8430,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8431,'en','No display constant generated'),(8448,'en','Note controller'),(8449,'en','Display constant controller'),(8466,'en','Display note'),(8467,'en','Translation of'),(8484,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8485,'en','No display constant generated'),(8502,'en','Note controller'),(8503,'en','Display constant controller'),(8520,'en','Display note'),(8521,'en','Translated as'),(8538,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8539,'en','No display constant generated'),(8556,'en','Note controller'),(8557,'en','Display constant controller'),(8574,'en','Display note'),(8575,'en','Has supplement'),(8592,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8593,'en','No display constant generated'),(8610,'en','Note controller'),(8611,'en','Display constant controller'),(8628,'en','Display note'),(8629,'en','Supplement to'),(8646,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8647,'en','Parent'),(8664,'en','No display constant generated'),(8673,'en','Note controller'),(8674,'en','Display constant controller'),(8691,'en','Display note'),(8692,'en','In'),(8709,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8710,'en','No display constant generated'),(8727,'en','Note controller'),(8728,'en','Display constant controller'),(8745,'en','Display note'),(8746,'en','Constituent unit'),(8763,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8764,'en','No display constant generated'),(8781,'en','Note controller'),(8782,'en','Display constant controller'),(8799,'en','Display note'),(8800,'en','Other edition available'),(8817,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8818,'en','No display constant generated'),(8835,'en','Note controller'),(8836,'en','Display constant controller'),(8853,'en','Display note'),(8854,'en','Available in another form'),(8871,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8872,'en','No display constant generated'),(8889,'en','Note controller'),(8890,'en','Display constant controller'),(8907,'en','Display note'),(8908,'en','Issued with'),(8925,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8926,'en','No display constant generated'),(8943,'en','Note controller'),(8944,'en','Type of relationship'),(8961,'en','Display note'),(8962,'en','Continues'),(8979,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(8980,'en','Continues in part'),(8997,'en','Supersedes'),(9006,'en','Supersedes in part'),(9015,'en','4 -Formed by the union of ... and …'),(9024,'en','Absorbed'),(9033,'en','Absorbed in part'),(9042,'en','Separated from'),(9051,'en','Note controller'),(9052,'en','Type of relationship'),(9069,'en','Display note'),(9070,'en','Continued by'),(9087,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(9088,'en','Continued in part by'),(9105,'en','Superseded in part by'),(9114,'en','Superseded in part by'),(9123,'en','Absorbed by'),(9132,'en','Absorbed in part by'),(9141,'en','Split into… and …'),(9150,'en','Merged with ... To form...'),(9159,'en','Changed back to'),(9168,'en','Note controller'),(9169,'en','Display constant controller'),(9186,'en','Display note'),(9187,'en','Data source'),(9204,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(9205,'en','No display constant generated'),(9222,'en','Note controller'),(9223,'en','Display constant controller'),(9240,'en','Display note'),(9241,'en','Related item'),(9258,'en','Do not display note. Textual note is contained in field 580 (Linking Entry Complexity Note)'),(9259,'en','No display constant generated'),(9276,'en','Type of personal name entry element'),(9277,'en','Undefined'),(9294,'en','Forename'),(9295,'en','Undefined'),(9312,'en','Surname.'),(9321,'en','Family Name'),(9330,'en','Type of corporate name entry element'),(9331,'en','Undefined'),(9348,'en','Inverted name'),(9349,'en','Undefined'),(9366,'en','Juridistion name'),(9375,'en','Name in direct order'),(9384,'en','Undefined'),(9393,'en','Inverted name'),(9394,'en','Undefined'),(9411,'en','Juridistion name'),(9420,'en','Name in direct order'),(9429,'en','Undefined'),(9430,'en','Nonfiling characters'),(9447,'en','Undefined'),(9448,'en','No nonfiling characters'),(9465,'en','Number of nonfiling characters'),(9474,'en','Number of nonfiling characters'),(9483,'en','Number of nonfiling characters'),(9492,'en','Number of nonfiling characters'),(9501,'en','Number of nonfiling characters'),(9510,'en','Number of nonfiling characters'),(9519,'en','Number of nonfiling characters'),(9528,'en','Number of nonfiling characters'),(9537,'en','Number of nonfiling characters'),(9546,'en','Undefined'),(9547,'en','Undefined'),(9564,'en','Undefined'),(9565,'en','Undefined'),(9582,'en','Undefined'),(9583,'en','Undefined'),(9600,'en','Undefined'),(9601,'en','# -Undefined'),(9618,'en','Undefined'),(9619,'en','Undefined'),(9636,'en','Undefined'),(9637,'en','Undefined'),(9654,'en','Undefined'),(9655,'en','Undefined'),(9672,'en','Undefined'),(9673,'en','Undefined'),(9690,'en','Undefined'),(9691,'en','Undefined'),(9708,'en','Undefined'),(9709,'en','# -Undefined'),(9726,'en','Undefined'),(9727,'en','Undefined'),(9744,'en','Undefined'),(9745,'en','Undefined'),(9762,'en','Shelving scheme'),(9763,'en','Shelving order'),(9780,'en','No information provided'),(9781,'en','No information provided'),(9798,'en','Library of Congress classification'),(9799,'en','Not enumeration'),(9816,'en','Dewey Decimal classification'),(9817,'en','Primary enumeration'),(9834,'en','National Library of Medicine classification'),(9835,'en','Alternative enumeration'),(9852,'en','Superintendent of Document classification'),(9861,'en','Shelving control number'),(9870,'en','Title'),(9879,'en','Shelved separately'),(9888,'en','Source specified in subfield $2'),(9897,'en','Other scheme'),(9906,'en','Compressibility and expandability'),(9907,'en','Caption evaluation'),(9924,'en','Cannot compress or expand'),(9925,'en','Captions verified; all levels present'),(9942,'en','Can compress but not expand'),(9943,'en','Captions verified; all levels may not be present'),(9960,'en','Can compress or expand'),(9961,'en','Captions unverified; all levels present'),(9978,'en','Unknown'),(9979,'en','Captions unverified; all levels may not be present'),(9996,'en','Compressibility and expandability'),(9997,'en','Caption evaluation'),(10014,'en','Cannot compress or expand'),(10015,'en','Captions verified; all levels present'),(10032,'en','Can compress but not expand'),(10033,'en','Captions verified; all levels may not be present'),(10050,'en','Can compress or expand'),(10051,'en','Captions unverified; all levels present'),(10068,'en','Unknown'),(10069,'en','Captions unverified; all levels may not be present'),(10086,'en','Undefined'),(10087,'en','Undefined'),(10104,'en','Undefined'),(10105,'en','Undefined'),(10122,'en','Access method'),(10123,'en','Relationship'),(10140,'en','No information provided'),(10141,'en','No information provided'),(10158,'en','E-mail'),(10159,'en','Resource'),(10176,'en','FTP'),(10177,'en','Version of resource'),(10194,'en','Remote login (Telnet)'),(10195,'en','Related resource'),(10212,'en','Dial-up'),(10213,'en','No display constant generated'),(10230,'en','HTTP'),(10239,'en','Method specidied in subfield $2.'),(10248,'en','Field encoding level'),(10249,'en','Form of holdings'),(10266,'en','No information provided'),(10267,'en','No information provided'),(10284,'en','Holdings level 3'),(10285,'en','Compressed'),(10302,'en','Holdings level 4'),(10303,'en','Uncompressed'),(10320,'en','Holdings level 4 with piece designation'),(10321,'en','Compressed, use textual display'),(10338,'en','Uncompressed, use textual display'),(10347,'en','Item (s) not published'),(10356,'en','Field encoding level'),(10357,'en','Form of holdings'),(10374,'en','No information provided'),(10375,'en','No information provided'),(10392,'en','Holdings level 3'),(10393,'en','Compressed'),(10410,'en','Holdings level 4'),(10411,'en','Uncompressed'),(10428,'en','Holdings level 4 with piece designation'),(10429,'en','Compressed, use textual display'),(10446,'en','Uncompressed, use textual display'),(10455,'en','Item (s) not published'),(10464,'en','Field encoding level'),(10465,'en','Form of holdings'),(10482,'en','No information provided'),(10483,'en','No information provided'),(10500,'en','Holdings level 4'),(10501,'en','Uncompressed'),(10518,'en','Holdings level 4 with piece designation'),(10519,'en','Uncompressed, use textual display'),(10536,'en','Field encoding level'),(10537,'en','Type of notation'),(10554,'en','No information provided'),(10555,'en','Non-stardard'),(10572,'en','Holdings level 3'),(10573,'en','ANSI/NISO Z39.71 or ISO 10324'),(10590,'en','Holdings level 4'),(10591,'en','ANSI Z39.42'),(10608,'en','Holdings level 4 with piece designation'),(10609,'en','Source specified in subfield $2'),(10626,'en','Field encoding level'),(10627,'en','Type of notation'),(10644,'en','No information provided'),(10645,'en','Non-stardard'),(10662,'en','Holdings level 3'),(10663,'en','ANSI/NISO Z39.71 or ISO 10324'),(10680,'en','Holdings level 4'),(10681,'en','ANSI Z39.42'),(10698,'en','Holdings level 4 with piece designation'),(10699,'en','Source specified in subfield $2'),(10716,'en','Field encoding level'),(10717,'en','Type of notation'),(10734,'en','No information provided'),(10735,'en','Non-stardard'),(10752,'en','Holdings level 3'),(10753,'en','ANSI/NISO Z39.71 or ISO 10324'),(10770,'en','Holdings level 4'),(10771,'en','ANSI Z39.42'),(10788,'en','Holdings level 4 with piece designation'),(10789,'en','Source specified in subfield $2'),(10806,'en','Undefined'),(10807,'en','Undefined'),(10824,'en','Undefined'),(10825,'en','Undefined'),(10842,'en','Undefined'),(10843,'en','Undefined'),(10860,'en','Undefined'),(10861,'en','Undefined'),(10878,'en','Undefined'),(10879,'en','Undefined'),(10896,'en','Undefined'),(10897,'en','Undefined'),(10914,'en','Appropriate indicator as available in associated field'),(10915,'en','Appropriate indicator as available in associated field'),(10932,'en','Type of field'),(10933,'en','Undefined'),(10950,'en','Leader'),(10951,'en','Undefined'),(10968,'en','Variable control fields (002 -009)'),(10977,'en','Variable data fields (010 - 999)'),(10986,'en','Undefined'),(10987,'en','Undefined'),(11004,'en','Undefined'),(11005,'en','Undefined'); +/*!40000 ALTER TABLE marc_indicators_desc ENABLE KEYS */; +UNLOCK TABLES; + +SET FOREIGN_KEY_CHECKS = 1; diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_indicators.txt b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_indicators.txt new file mode 100755 index 0000000..870ad32 --- /dev/null +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_indicators.txt @@ -0,0 +1 @@ +Default MARC 21 indicators values. diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql b/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql index c1a8f6d..2467f97 100755 --- a/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql @@ -311,4 +311,6 @@ INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('UseControlNumber',0,'If ON, record control number (w subfields) and control number (001) are used for linking of bibliographic records.','','YesNo'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsField','','The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).',NULL,'free'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsSeparator','','The string to use to separate subfields in alternate holdings displays.',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('CheckValueIndicators','0','Check the values of the indicators in cataloguing','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('DisplayPluginValueIndicators','0','Display a plugin with the correct values of indicators for fields in cataloguing','','YesNo'); diff --git a/installer/data/mysql/it-IT/necessari/sysprefs.sql b/installer/data/mysql/it-IT/necessari/sysprefs.sql index b9572df..1e055a8 100755 --- a/installer/data/mysql/it-IT/necessari/sysprefs.sql +++ b/installer/data/mysql/it-IT/necessari/sysprefs.sql @@ -1,6 +1,6 @@ * SQLyog Enterprise - MySQL GUI -MySQL - 5.0.51a-24+lenny2+spu1 +MySQL - 5.0.51a-24+lenny2+spu1 ********************************************************************* */ /*!40101 SET NAMES utf8 */; @@ -295,4 +295,7 @@ INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Display856uAsImage','OFF','Display the URI in the 856u field as an image, the corresponding Staff Client XSLT option must be on','OFF|Details|Results|Both','Choice'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('UseControlNumber',0,'If ON, record control number (w subfields) and control number (001) are used for linking of bibliographic records.','','YesNo'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsField','','The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).',NULL,'free'); -INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsSeparator','','The string to use to separate subfields in alternate holdings displays.',NULL,'free'); \ No newline at end of file +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsSeparator','','The string to use to separate subfields in alternate holdings displays.',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('CheckValueIndicators','0','Check the values of the indicators in cataloguing','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('DisplayPluginValueIndicators','0','Display a plugin with the correct values of indicators for fields in cataloguing','','YesNo'); + diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql old mode 100644 new mode 100755 index e3c6f42..208b9b3 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -433,6 +433,7 @@ CREATE TABLE `categories` ( -- -- Table: collections -- +DROP TABLE IF EXISTS `collections`; CREATE TABLE collections ( colId integer(11) NOT NULL auto_increment, colTitle varchar(100) NOT NULL DEFAULT '', @@ -444,6 +445,7 @@ CREATE TABLE collections ( -- -- Table: collections_tracking -- +DROP TABLE IF EXISTS `collections_tracking`; CREATE TABLE collections_tracking ( ctId integer(11) NOT NULL auto_increment, colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', @@ -2611,6 +2613,75 @@ CREATE TABLE `fieldmapping` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `marc_indicators` +-- + +DROP TABLE IF EXISTS `marc_indicators`; +CREATE TABLE `marc_indicators` ( + `id_indicator` int(11) unsigned NOT NULL auto_increment, + `frameworkcode` varchar(4) default '', + `tagfield` varchar(3) NOT NULL default '', + PRIMARY KEY (`id_indicator`), + UNIQUE KEY `frameworkcode` (`frameworkcode`,`tagfield`), + CONSTRAINT `marc_indicators_ibfk_1` FOREIGN KEY (`frameworkcode`) REFERENCES `biblio_framework` (`frameworkcode`) ON DELETE CASCADE +) ENGINE=InnoDB AUTO_INCREMENT=1775 DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `marc_indicators_desc` +-- + +DROP TABLE IF EXISTS `marc_indicators_desc`; +CREATE TABLE `marc_indicators_desc` ( + `id_indicator_value` int(11) unsigned NOT NULL, + `lang` varchar(25) NOT NULL default 'en', + `ind_desc` mediumtext, + PRIMARY KEY (`id_indicator_value`,`lang`), + KEY `lang` (`lang`), + CONSTRAINT `marc_indicators_desc_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `language_descriptions` (`lang`) ON DELETE CASCADE, + CONSTRAINT `marc_indicators_desc_ibfk_1` FOREIGN KEY (`id_indicator_value`) REFERENCES `marc_indicators_value` (`id_indicator_value`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `marc_indicators_value` +-- + +DROP TABLE IF EXISTS `marc_indicators_value`; +CREATE TABLE `marc_indicators_value` ( + `id_indicator_value` int(11) unsigned NOT NULL auto_increment, + `id_indicator` int(11) unsigned NOT NULL, + `ind` enum('1','2') NOT NULL, + `ind_value` char(1) NOT NULL, + PRIMARY KEY (`id_indicator_value`), + KEY `id_indicator` (`id_indicator`), + KEY `ind_value` (`ind_value`), + CONSTRAINT `marc_indicators_value_ibfk_2` FOREIGN KEY (`ind_value`) REFERENCES `marc_indicators_values` (`ind_value`) ON DELETE CASCADE, + CONSTRAINT `marc_indicators_value_ibfk_1` FOREIGN KEY (`id_indicator`) REFERENCES `marc_indicators` (`id_indicator`) ON DELETE CASCADE +) ENGINE=InnoDB AUTO_INCREMENT=22196 DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `marc_indicators_values` +-- + +DROP TABLE IF EXISTS `marc_indicators_values`; +CREATE TABLE `marc_indicators_values` ( + `ind_value` char(1) NOT NULL default '', + PRIMARY KEY (`ind_value`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +-- +-- Dumping data for table `marc_indicators_values` +-- + +LOCK TABLES `marc_indicators_values` WRITE; +/*!40000 ALTER TABLE `marc_indicators_values` DISABLE KEYS */; +INSERT INTO `marc_indicators_values` VALUES (''),('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9'),('a'),('b'),('c'),('d'),('e'),('f'),('g'),('h'),('i'),('j'),('k'),('l'),('m'),('n'),('o'),('p'),('q'),('r'),('s'),('t'),('u'),('v'),('w'),('x'),('y'),('z'); +/*!40000 ALTER TABLE `marc_indicators_values` ENABLE KEYS */; +UNLOCK TABLES; + + + /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; diff --git a/installer/data/mysql/pl-PL/mandatory/sysprefs.sql b/installer/data/mysql/pl-PL/mandatory/sysprefs.sql index 88ddc40..c3bee36 100755 --- a/installer/data/mysql/pl-PL/mandatory/sysprefs.sql +++ b/installer/data/mysql/pl-PL/mandatory/sysprefs.sql @@ -308,3 +308,6 @@ INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Display856uAsImage','OFF','Display the URI in the 856u field as an image, the corresponding Staff Client XSLT option must be on','OFF|Details|Results|Both','Choice'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsField','','The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).',NULL,'free'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsSeparator','','The string to use to separate subfields in alternate holdings displays.',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('CheckValueIndicators','0','Check the values of the indicators in cataloguing','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('DisplayPluginValueIndicators','0','Display a plugin with the correct values of indicators for fields in cataloguing','','YesNo'); + diff --git a/installer/data/mysql/ru-RU/mandatory/system_preferences_full_optimal_for_install_only.sql b/installer/data/mysql/ru-RU/mandatory/system_preferences_full_optimal_for_install_only.sql index 72842cd..5ce92d8 100755 --- a/installer/data/mysql/ru-RU/mandatory/system_preferences_full_optimal_for_install_only.sql +++ b/installer/data/mysql/ru-RU/mandatory/system_preferences_full_optimal_for_install_only.sql @@ -363,3 +363,6 @@ INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Display856uAsImage','OFF','Display the URI in the 856u field as an image, the corresponding Staff Client XSLT option must be on','OFF|Details|Results|Both','Choice'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsField','','The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).',NULL,'free'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsSeparator','','The string to use to separate subfields in alternate holdings displays.',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('CheckValueIndicators','0','Check the values of the indicators in cataloguing','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('DisplayPluginValueIndicators','0','Display a plugin with the correct values of indicators for fields in cataloguing','','YesNo'); + diff --git a/installer/data/mysql/uk-UA/mandatory/system_preferences_full_optimal_for_install_only.sql b/installer/data/mysql/uk-UA/mandatory/system_preferences_full_optimal_for_install_only.sql index 2d7d887..53b9eee 100755 --- a/installer/data/mysql/uk-UA/mandatory/system_preferences_full_optimal_for_install_only.sql +++ b/installer/data/mysql/uk-UA/mandatory/system_preferences_full_optimal_for_install_only.sql @@ -387,4 +387,8 @@ INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACDisplay856uAsImage','OFF','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','OFF|Details|Results|Both','Choice'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Display856uAsImage','OFF','Display the URI in the 856u field as an image, the corresponding Staff Client XSLT option must be on','OFF|Details|Results|Both','Choice'); INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsField','','The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).',NULL,'free'); -INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsSeparator','','The string to use to separate subfields in alternate holdings displays.',NULL,'free'); \ No newline at end of file +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsSeparator','','The string to use to separate subfields in alternate holdings displays.',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AlternateHoldingsSeparator','','The string to use to separate subfields in alternate holdings displays.',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('CheckValueIndicators','0','Check the values of the indicators in cataloguing','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('DisplayPluginValueIndicators','0','Display a plugin with the correct values of indicators for fields in cataloguing','','YesNo'); + diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 7729a7e..647fa25 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -4209,6 +4209,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } + $DBversion = '3.03.00.042'; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do("ALTER TABLE `items` DROP INDEX `itemsstocknumberidx`;"); @@ -4285,6 +4286,62 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { SetVersion($DBversion); } +$DBversion = '3.03.00.XXX'; #FIXME +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + my %info; + $info{'dbname'} = C4::Context->config("database"); + $info{'dbms'} = ( C4::Context->config("db_scheme") ? C4::Context->config("db_scheme") : "mysql" ); + $info{'hostname'} = C4::Context->config("hostname"); + $info{'port'} = C4::Context->config("port"); + $info{'user'} = C4::Context->config("user"); + $info{'password'} = C4::Context->config("pass"); + + my $intranetdir = C4::Context->intranetdir; + my $path = ($intranetdir =~ /^(.+?)\/intranet\/cgi-bin/)?$1:$intranetdir; + $path .= "/installer/data/$info{dbms}/en/marcflavour/marc21/"; + my $filename; + my $error; + my $strcmd; + if ( $info{'dbms'} eq 'mysql' ) { + my $cmd = qx(which mysql 2>/dev/null || whereis mysql 2>/dev/null); + chomp($cmd); + $cmd = $1 if ($cmd && $cmd =~ /^(.+)[\r\n]+$/); + $cmd = 'mysql' if (!$cmd || !-x $cmd); + $strcmd = "$cmd " + . ( $info{'hostname'} ? " -h $info{hostname} " : "" ) + . ( $info{'port'} ? " -P $info{port} " : "" ) + . ( $info{'user'} ? " -u $info{user} " : "" ) + . ( $info{'password'} ? " -p'$info{password}'" : "" ) + . ' ' . $info{dbname} . ' '; + $filename = $path . 'mandatory/marc21_indicators.sql'; + $error = qx($strcmd --default-character-set=utf8 <$filename 2>&1 1>/dev/null) if (-r $filename); + } elsif ( $info{'dbms'} eq 'Pg' ) { + my $cmd = qx(which psql 2>/dev/null || whereis psql 2>/dev/null); + chomp($cmd); + $cmd = $1 if ($cmd && $cmd =~ /^(.+)[\r\n]+$/); + $cmd = 'psql' if (!$cmd || !-x $cmd); + $strcmd = "$cmd " + . ( $info{'hostname'} ? " -h $info{hostname} " : "" ) + . ( $info{'port'} ? " -p $info{port} " : "" ) + . ( $info{'user'} ? " -U $info{user} " : "" ) + . ' ' . $info{dbname} . ' '; + $filename = $path . 'mandatory/marc21_indicators.sql'; + $error = qx($strcmd -f $filename 2>&1 1>/dev/null); + } + unless ($error) { + print "Upgrade to $DBversion done (New tables and data from $path for indicators functionality)\n"; + $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('CheckValueIndicators','0','Check the values of the indicators in cataloguing','','YesNo');"); + print "Upgrade to $DBversion done (Add syspref to check the values of the indicators)\n"; + $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('DisplayPluginValueIndicators','0','Display a plugin with the correct values of indicators for fields in cataloguing','','YesNo');"); + print "Upgrade to $DBversion done (Add syspref to display a plugin with the allowed values of indicators)\n"; + SetVersion ($DBversion); + } else { + print "Error executing: $strcmd upon $filename $error"; + } +} + + + =head1 FUNCTIONS =head2 DropAllForeignKeys($table) diff --git a/koha-tmpl/intranet-tmpl/prog/en/css/staff-global.css b/koha-tmpl/intranet-tmpl/prog/en/css/staff-global.css index c211507..69885ff 100755 --- a/koha-tmpl/intranet-tmpl/prog/en/css/staff-global.css +++ b/koha-tmpl/intranet-tmpl/prog/en/css/staff-global.css @@ -1988,4 +1988,16 @@ fieldset.rows+h3 {clear:both;padding-top:.5em;} .importing .importing_msg { padding-left: 10px; padding-bottom: 10px; -} \ No newline at end of file +} +form#f_pop ul { + list-style-type: none; +} +form#f_pop ul li { + list-style-type: none; + padding-top: 10px; + font-family: tahoma, verdana, arial; + font-size: 12px; +} +form#f_pop table { + float: left; +} diff --git a/koha-tmpl/intranet-tmpl/prog/en/js/indicators.js b/koha-tmpl/intranet-tmpl/prog/en/js/indicators.js new file mode 100755 index 0000000..79b70c6 --- /dev/null +++ b/koha-tmpl/intranet-tmpl/prog/en/js/indicators.js @@ -0,0 +1,442 @@ + + // Block for check validity of value indicators + + // Check value of indicator and change messages to indicate validity + function checkValueInd(id, ind, field) + { + var obj = $("#" + id); + var valueInd = obj.val(); + var name = field + "_" + ind + "_"; + var indOther = (ind == 1)?2:1; + var valueIndOther = $("#" + field + "_ind" + indOther).val(); + var nameOther = field + "_" + indOther + "_"; + var ok = false; + var okBoth = 0; + var form = obj.closest("form"); + var $inputs = form.find("input:hidden"); + if ($inputs.length > 0) { + var i = 0; + $inputs.each(function() { + if ($(this).attr('name').indexOf(name) >= 0 && valueInd == $(this).val()) { + ok = true; + okBoth++; + i++; + } else if ($(this).attr('name').indexOf(nameOther) >= 0 && valueIndOther == $(this).val()) { + i++; + okBoth++; + } + if (i == 2) return; + }); + var a_usevalue = $("#" + field + "_btn_usevalue_" + ind); + var a_usevalue_3 = $("#" + field + "_btn_usevalue_3"); + if (ok) { + obj.prev("label").attr("title", "User Value for Indicator " + ind + " is valid"); + obj.attr("title", "User Value for Indicator " + ind + " is valid"); + obj.css("backgroundColor", ""); + if (a_usevalue && a_usevalue_3) { + a_usevalue.attr('title', "Use this value and close the window"); + a_usevalue.val("Use and Close"); + if (okBoth == 2) { + a_usevalue_3.attr('title', 'Use these values and close the window'); + a_usevalue_3.val('Use both and Close'); + } else { + a_usevalue_3.attr('title', "Can't Use these values until they're correct"); + a_usevalue_3.val("Can't Use these values until they're correct"); + } + } + } else { + obj.prev("label").attr("title", "User Value for Indicator " + ind + " not is valid"); + obj.attr("title", "User Value for Indicator " + ind + " is not valid"); + obj.css("backgroundColor", "yellow"); + if (a_usevalue && a_usevalue_3) { + a_usevalue.attr('title', "Can't Use this value until is correct"); + a_usevalue.val("Can't Use this value until is correct"); + a_usevalue_3.attr('title', "Can't Use these values until they're correct"); + a_usevalue_3.val("Can't Use these values until they're correct"); + } + } + } else ok = true; + return ok; + }//checkValueInd + + + // Change the value on the opener windows + function changeValueInd(value, ind, field, openerField1, openerField2) + { + var openerField = (ind == 1)?openerField1:openerField2; + var name = field + "_ind" + ind; + var form = $("#f_pop"); + var $inputs = $('#f_pop input:text[name=' + name + ']'); + $inputs.each(function() { + $(this).val(value); + if (checkValueInd($(this).attr("id"), ind, field) && opener) { + for (var j=0; j < opener.document.f.elements.length; j++) { + if (opener.document.f.elements[j].name == openerField) { + opener.document.f.elements[j].value = value; + opener.document.f.elements[j].style.backgroundColor = ""; + break; + } + } + } + return; + }); + }//changeValueInd + + + // Fill in the opener form the value of the indicator + function useValue(ind, field, openerField, close) + { + var obj = $("#" + field + "_ind" + ind); + if (obj) { + var value = obj.val(); + if (checkValueInd(obj.attr("id"), ind, field)) { + if (opener) { + for (var j=0; j < opener.document.f.elements.length; j++) { + if (opener.document.f.elements[j].name == openerField) { + opener.document.f.elements[j].value = value; + break; + } + } + if (close) window.close(); + } + return true; + } else { + var obja = $("#" + field + "_btn_usevalue_" + ind); + if (obja) obja.attr('title', "Value " + value + " invalid for indicator " + ind); + alert("Value " + value + " invalid for indicator " + ind); + } + } + return false; + }//useValue + + + // Fill in the opener form the values + function useValues(field, openerField1, openerField2) + { + if (useValue(1, field, openerField1, false) && useValue(2, field, openerField2, false)) { + if (opener) window.close(); + } + }//useValues + + + // Launch the popup for the field with the current values + function launchPopupValueIndicators(frameworkcode, tag, index, random) + { + var ind1 = "tag_" + tag + "_indicator1_" + index + random; + var ind2 = "tag_" + tag + "_indicator2_" + index + random; + var objInd1 = $("input:text[name^='" + ind1 + "']"); + var objInd2 = $("input:text[name^='" + ind2 + "']"); + if (objInd1 || objInd2) { + var strParam = ""; + if (objInd1 != undefined) strParam += "&" + ind1 + "=" + ((objInd1.val())?objInd1.val():escape("#")); + if (objInd2 != undefined) strParam += "&" + ind2 + "=" + ((objInd2.val())?objInd2.val():escape("#")); + if (arguments.length == 5) { + window.open("/cgi-bin/koha/cataloguing/marc21_indicators.pl?biblionumber=" + arguments[4] + "&frameworkcode=" + frameworkcode + strParam, "valueindicators",'width=740,height=450,location=yes,toolbar=no,scrollbars=yes,resize=yes'); + } else { + window.open("/cgi-bin/koha/cataloguing/marc21_indicators.pl?frameworkcode=" + frameworkcode + strParam, "valueindicators",'width=740,height=450,location=yes,toolbar=no,scrollbars=yes,resize=yes'); + } + } + }//launchPopupValueIndicators + + + var xmlDocInd; + var tagFields; + var errorAjax = false; + + // Look for the value indicator for a frameworkcode + function send_ajax_indicators(frameworkcode) + { + $.ajax({ + type: "POST", + url: "/cgi-bin/koha/cataloguing/indicators_ajax.pl", + dataType: "xml", + async: true, + "data": {frameworkcode: frameworkcode}, + "success": (arguments.length == 1)?receive_ok_indicators:receive_ok_indicators_for_opener + }); + $("*").ajaxError(function(evt, request, settings){ + if (!errorAjax) { + alert("AJAX error: receiving data from " + settings.url); + errorAjax = true; + } + }); + }//send_ajax_indicators + + + function receive_ok_indicators(data, textStatus) + { + xmlDocInd = data.documentElement; + getTagFields(); + }//receive_ok_indicators + + + // Called from the plugin to reload the xml data in the opener, so you can make changes in the framework's indicators + // and validate the biblio record without reloading the page and losing the data of the form. + function receive_ok_indicators_for_opener(data, textStatus) + { + window.opener.xmlDocInd = data.documentElement; + getTagFields(true); + window.opener.tagFields = tagFields; + location.reload(); + }//receive_ok_indicators + + + // Get all input elements for indicators and store them on associative array for rapid accessing + function getTagFields() + { + tagFields = new Array(); + var form = (arguments.length == 1)?window.opener.document.f:document.f; + var name; + var tag; + for (var i=0; i < form.elements.length; i++) { + name = form.elements[i].name; + if (name.indexOf("tag_") == 0 && name.indexOf("_indicator") > 0) { + tag = name.substr(4,3); + tagFields[tag] = true; + } + } + }//getTagFields + + + // Traverse the indicators xml data to check against fields in the form + function checkValidIndFramework() + { + var strErrorInd = ""; + var numError = -1; + if (xmlDocInd != undefined) { + if (xmlDocInd.nodeName == "Error") { + } else { + if (xmlDocInd.nodeName == "Framework" && xmlDocInd.nodeType == 1 && xmlDocInd.hasChildNodes()) { + var nodeFields = xmlDocInd.getElementsByTagName('Fields')[0]; + if (nodeFields && nodeFields.nodeType == 1 && nodeFields.hasChildNodes()) { + var nodeField = nodeFields.firstChild; + var tag; + var i = 1; + while (nodeField != null) { + if (nodeField.nodeType == 1) { + tag = nodeField.attributes.getNamedItem("tag").nodeValue; + if (nodeField.hasChildNodes()) { + var objFieldsInd; + var arrObj = search_koha_field(tag); + if (arrObj != undefined && arrObj.length > 0) { + for (var z = 0; z < arrObj.length; z++) { + objFieldsInd = arrObj[z]; + if (objFieldsInd != undefined && (objFieldsInd.ind1 != undefined || objFieldsInd.ind2 != undefined)) { + for (var j = 1; j <= 2; j++) { + var objInd; + if (j == 1 && objFieldsInd.ind1 != undefined) objInd = objFieldsInd.ind1; + else if (j == 2 && objFieldsInd.ind2 != undefined) objInd = objFieldsInd.ind2; + if (objInd != undefined) { + var valueInd = objInd.val(); + if (!checkValidIndField(j, valueInd, nodeField)) { + strErrorInd += "The value \"" + valueInd + "\" is not valid for indicator " + j + " on tag " + tag + ". "; + numError++; + if (numError > 0 && (numError + 1) % 2 == 0) strErrorInd += "\n"; + objInd.css("backgroundColor", "yellow"); + } else { + objInd.css("backgroundColor" ,""); + } + } + } + } + } + } + } + } + nodeField = nodeField.nextSibling; + i++; + } + } + } + } + } + return strErrorInd; + }//checkValidIndFramework + + + // Check a value from an indicator against a node from the xml + function checkValidIndField(ind, valueInd, nodeField) + { + try { + var hasNodeInd = false; + var nodeInd = nodeField.firstChild; + while (nodeInd != null) { + if (nodeInd.nodeType == 1 && (nodeInd.getAttributeNode("ind") || nodeInd.hasAttribute("ind"))) { + if (nodeInd.getAttribute("ind") == ind) { + hasNodeInd = true; + // return as valid if value is ok or is empty or is a blank + if (nodeInd.hasChildNodes() && nodeInd.firstChild.nodeValue == valueInd) return true; + else if (valueInd == "" || valueInd == " ") return true; + } + } + nodeInd = nodeInd.nextSibling; + } + // Return as valid if there's not a set of values for this indicator in this field + if (!hasNodeInd) return true; + } catch (e) { + //alert("An exception occurred in the script. Error name: " + e.name + ". Error message: " + e.message); + } + return false; + }//checkValidIndField + + + // Class for store both indicators values + function FieldIndicatorObject() + { + }//IndicatorObject + + FieldIndicatorObject.prototype = { + ind1: undefined, + ind2: undefined + } + + // Search for the input text of the indicators for a tag in the form + function search_koha_field(tag) + { + var resArr; + if (tagFields != undefined && (tagFields[tag] == undefined || !tagFields[tag])) { + return resArr; + } + resArr = new Array(); + var indTag = "tag_" + tag + "_indicator"; + var lengthIndTag = indTag.length; + var pos; + var ind1 = false; + var ind2 = false; + var obj; + var name; + var $inputs = $('input:text[name^="' + indTag + '"]'); + $inputs.each(function() { + name = $(this).attr('name'); + if ((pos = name.indexOf(indTag)) >= 0) { + if (!ind1 && !ind2) { + obj = new FieldIndicatorObject(); + } + if (name.charAt(pos + lengthIndTag) == 1) { + ind1 = true; + obj.ind1 = $(this); + } else { + ind2 = true; + obj.ind2 = $(this); + } + if (ind1 && ind2 && obj.ind1 != undefined && obj.ind2 != undefined) { + ind1 = false; + ind2 = false; + resArr.push(obj); + } + } + }); + return resArr; + }//search_koha_field + + + + // Block for dynamic HTML management of value indicators + + + // Delete indicator block + function delete_ind_value(id) + { + $('#ul_' + id).remove(); + }//delete_ind_value + + + // Hide or show the indicator block + function hideShowBlock(a, ind) + { + var ul_in = $("#ul_in_" + ind); + if (ul_in.css('display') == "none") { + ul_in.css('display', "block"); + a.title = "Hide: " + a.innerHTML; + } else { + ul_in.css('display', "none"); + a.title = "Show: " + a.innerHTML; + } + }//hideShowBlock + + + // Change label to indicate whether is indicator 1 or 2 + function changeLabelInd(ind, obj) + { + var a_in = $('#a_in_' + ind); + if (!(obj.value == '1' || obj.value == '2')) { + obj.value = ''; + a_in.html(ind + ' - Indicator ' + obj.value); + } + a_in.html(ind + ' - Indicator ' + obj.value); + }//changeLabelInd + + + // Check whether the value is correct + function checkValueIndCompleteSet(ind, obj) + { + var rege = new RegExp("^[abcdefghijklmnopqrstuvwxyz0123456789 ]$"); + if (rege.test(obj.value) || obj.value == "") { + obj.title = "Value \"" + obj.value + "\" for Indicator " + ind + " is valid"; + obj.style.backgroundColor = ""; + } else { + obj.title = "Value \"" + obj.value + "\" for Indicator " + ind + " is not valid (abcdefghijklmnopqrstuvwxyz0123456789 )"; + obj.style.backgroundColor = "yellow"; + } + }//checkValueIndCompleteSet + + + // Add indicator block + function add_ind_value() + { + var list = $('#marc_indicators_structure'); + if (list) { + numInd++; + var ul = $("
    "); + + var li = $('
  1. '); + li.text('\u00a0'); + ul.append(li); + + lli = $('
  2. '); + var bold = $(''); + li.append(bold); + var a = $(""); + a.text(numInd + " - Indicator"); + bold.append(a); + ul.append(li); + + li = $("
  3. "); + ul.append(li); + var ul2 = $("
      "); + li.append(ul2); + + var li2 = $('
    1. '); + label = $("
    2. '); + label = $("
    3. '); + label = $("
    4. +
    5. + )" /> +
    6. +
    +
  4. +
+ + +
+ + +
+ + + + + + + + diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/marctagstructure.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/marctagstructure.tmpl old mode 100644 new mode 100755 index 032a6df..d4ce914 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/marctagstructure.tmpl +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/marctagstructure.tmpl @@ -127,6 +127,8 @@ $(document).ready(function() { +
+ @@ -183,6 +185,7 @@ $(document).ready(function() { Mandatory Auth value Subfields + Indicators Edit Delete @@ -196,12 +199,13 @@ $(document).ready(function() { YesNo
">subfields + ">indicators ">Edit ">Delete   - +

Tab: | $ , repeatable, Mandatory, See , , , @@ -219,6 +223,7 @@ $(document).ready(function() { YesNo ">Subfields + ">Indicators ">Edit ">Delete diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref old mode 100644 new mode 100755 index 4fc1305..7630e16 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref @@ -84,6 +84,12 @@ Cataloging: annual: generated in the form <year>-0001, <year>-0002. hbyymmincr: generated in the form <branchcode>yymm0001. "OFF": not generated automatically. + - + - pref: CheckValueIndicators + choices: + yes: Check + no: "Don't check" + - the values of the indicators against the defined values of the indicators for a framework when saving a biblio record. Display: - - 'Separate multiple displayed authors, series or subjects with ' @@ -131,4 +137,10 @@ Cataloging: yes: Hide no: "Don't hide" - items marked as suppressed from OPAC search results. Note that you must have the Suppress index set up in Zebra and at least one suppressed item, or your searches will be broken. + - + - pref: DisplayPluginValueIndicators + choices: + yes: "Don't hide" + no: Hide + - the link next to the indicator field to open a plugin to show the correct values of the indicator for this field and framework. If CheckValueIndicators is disabled and this variable is enabled it will check the values as well, i.e., it includes the CheckValueIndicators functionality. diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbiblio.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbiblio.tmpl old mode 100644 new mode 100755 index ba59280..28d7721 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbiblio.tmpl +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbiblio.tmpl @@ -2,6 +2,9 @@ Koha › Cataloging › <!-- TMPL_IF NAME="biblionumber" -->Editing <!-- TMPL_VAR NAME="title" escape="html" --> (Record Number <!-- TMPL_VAR name="biblionumber" -->)<!-- TMPL_ELSE -->Add MARC Record<!-- /TMPL_IF --> + + + + + + + +

+
+
+
+

Cataloging › Editing Indicators for (Record Number )Indicators for Add MARC Record

+
+
    + +
  • Field :

  • + +
  • + _ind1" id="_ind1" value="" size="1" maxlength="1" class="input_ind" /> + _btn_usevalue_1" title="Use this value and close the window" class="btn_usevalue" value="Use and Close" /> +
  • +
  • + _ind2" id="_ind2" value="" size="1" maxlength="1" class="input_ind" /> + + _btn_usevalue_2" title="Use this value and close the window" class="btn_usevalue" value="Use and Close" /> +
  • +
  • _btn_usevalue_3" title="Use these values and close the window" class="btn_usevalue3" value="Use both and Close" />  Close
  • +
  • Reload validation in opener
  • + +
  • Predefined values

  • +
  • +
      +
    • + +
    • +
    •  
    • +
    • + +
    • +
    •  
    • +
    • _view_table" class="view_table">View values as a table
    • +
    •  
    • +
    • + _table_ind_values" class="table_ind_values"> + + + + + + + + + + + + + + __" id="__" value="" /> + + + +
      IndicatorDescriptionValueAction
      ""', , '', '', '');" title="Use this value on indicator for field ">Use this value
      +
    • +
    +
  • + +
  • + There aren't predefined values for this field +
  • + + +
+
+
+
+
+
+ + -- 1.5.6.5