Bug 21749: (QA follow-up) Add more tests for ImportFramework

This patch adds tests for:
- Output of ImportFramework on fields removal and error conditions (file
  not found)
- Different file format behaviour (csv, xml and ods are tested).

To test:
- Run
  $ kshell
 k$ prove t/db_dependent/ImportExportFramework.t
=> SUCCESS: All green :-D
- Sign off :-D

Note: the biblio_framework* files are based on the original one on the
patchset, and exported in 17.11 with different formats.

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>

diff --git a/t/db_dependent/ImportExportFramework.t b/t/db_dependent/ImportExportFramework.t
index de096cc..8189183 100644 (file)
--- a/t/db_dependent/ImportExportFramework.t
+++ b/t/db_dependent/ImportExportFramework.t
@@ -1,34 +1,100 @@
 #!/usr/bin/perl
 
+# 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 3 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, see <http://www.gnu.org/licenses>.
+
 use Modern::Perl;
-use Test::More tests => 3;
+
+use Test::More tests => 1;
+
+use t::lib::TestBuilder;
+
 use File::Basename qw( dirname );
 
 use Koha::Database;
 use Koha::BiblioFrameworks;
 use Koha::MarcSubfieldStructures;
-use t::lib::TestBuilder;
 use C4::ImportExportFramework;
 
-my $schema = Koha::Database->new->schema;
-$schema->storage->txn_begin;
+my $schema  = Koha::Database->new->schema;
 my $builder = t::lib::TestBuilder->new;
 
-my $data_filepath = dirname(__FILE__) . '/data/biblio_framework.csv';
+subtest 'ImportFramework() tests' => sub {
+
+    plan tests => 3;
+
+    subtest 'CSV tests' => sub {
+        plan tests => 9;
+
+        run_tests('csv');
+    };
+
+    subtest 'ODS tests' => sub {
+        plan tests => 9;
+
+        run_tests('ods');
+    };
+
+    subtest 'XML tests' => sub {
+        plan tests => 9;
+
+        run_tests('xml');
+    };
+};
+
+sub run_tests {
+
+    my ($format) = @_;
+
+    $schema->storage->txn_begin;
+
+    my $data_filepath = dirname(__FILE__) . "/data/frameworks/biblio_framework.$format";
+    my $fw_1 = $builder->build_object({ class => 'Koha::BiblioFrameworks' });
+
+    my $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id );
+    is( $result, 0, 'Import successful, no tags removed' );
+
+    my $nb_tags = $schema->resultset('MarcTagStructure')->search({ frameworkcode => $fw_1->id })->count;
+    is( $nb_tags, 4, "4 tags should have been imported" );
+
+    my $nb_subfields = Koha::MarcSubfieldStructures->search({ frameworkcode => $fw_1->id })->count;
+    is( $nb_subfields, 12, "12 subfields should have been imported" );
+
+    # bad file tests
+    my $fw_2 = $builder->build_object({ class => 'Koha::BiblioFrameworks' });
+    $result = C4::ImportExportFramework::ImportFramework( '', $fw_2->id );
+
+    is( $result, -1, 'Bad file makes it return -1' );
+
+    $nb_tags = $schema->resultset('MarcTagStructure')->search({ frameworkcode => $fw_2->id })->count;
+    is( $nb_tags, 0, "0 tags should have been imported" );
+
+    $nb_subfields = Koha::MarcSubfieldStructures->search({ frameworkcode => $fw_2->id })->count;
+    is( $nb_subfields, 0, "0 subfields should have been imported" );
 
-my $frameworkcode = '4T';
-C4::ImportExportFramework::ImportFramework($data_filepath, $frameworkcode);
+    # framework overwrite
+    $data_filepath = dirname(__FILE__) . "/data/frameworks/biblio_framework_smaller.$format";
 
-my $dbh = C4::Context->dbh;
+    $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id );
+    is( $result, 5, 'Smaller fw import successful, 4 tags removed' );
 
-# FIXME Import does not create the biblio framework
-#my $biblio_framework = Koha::BiblioFrameworks->find($frameworkcode);
-#ok( $biblio_framework );
+    $nb_tags = $schema->resultset('MarcTagStructure')->search({ frameworkcode => $fw_1->id })->count;
+    is( $nb_tags, 3, "3 tags should have been imported" );
 
-my $nb_tags = $dbh->selectrow_array(q|SELECT COUNT(*) FROM marc_tag_structure WHERE frameworkcode="4T"|);
-is( $nb_tags, 4, "4 tags should have been imported" );
+    $nb_subfields = Koha::MarcSubfieldStructures->search({ frameworkcode => $fw_1->id })->count;
+    is( $nb_subfields, 8, "8 subfields should have been imported" );
 
-my $nb_subfields =
-  Koha::MarcSubfieldStructures->search( { frameworkcode => $frameworkcode } )
-  ->count;
-is( $nb_subfields, 12, "12 subfields should have been imported" );
+    $schema->storage->txn_rollback;
+}

diff --git a/t/db_dependent/data/frameworks/biblio_framework.ods b/t/db_dependent/data/frameworks/biblio_framework.ods
new file mode 100644 (file)
index 0000000..de157be
Binary files /dev/null and b/t/db_dependent/data/frameworks/biblio_framework.ods differ

diff --git a/t/db_dependent/data/frameworks/biblio_framework.xml b/t/db_dependent/data/frameworks/biblio_framework.xml
new file mode 100644 (file)
index 0000000..b658aca
--- /dev/null
+++ b/t/db_dependent/data/frameworks/biblio_framework.xml
@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<?mso-application progid="Excel.Sheet"?>
+<Workbook xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
+
+<Styles>
+ <Style ss:ID="Default" ss:Name="Normal">
+  <Alignment ss:Vertical="Bottom"/>
+  <Borders/>
+  <Font/>
+  <Interior/>
+  <NumberFormat/>
+  <Protection/>
+ </Style>
+ <Style ss:ID="s27">
+  <Font x:Family="Swiss" ss:Color="#0000FF" ss:Bold="1"/>
+ </Style>
+ <Style ss:ID="s21">
+  <NumberFormat ss:Format="yyyy\-mm\-dd"/>
+ </Style>
+ <Style ss:ID="s22">
+  <NumberFormat ss:Format="yyyy\-mm\-dd\ hh:mm:ss"/>
+ </Style>
+ <Style ss:ID="s23">
+  <NumberFormat ss:Format="hh:mm:ss"/>
+ </Style>
+</Styles>
+
+<Worksheet ss:Name="marc_tag_structure"><ss:Table><ss:Row><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">tagfield</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">liblibrarian</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">libopac</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">repeatable</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">mandatory</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">authorised_value</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">frameworkcode</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">000</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">LEADER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">LEADER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">001</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">CONTROL NUMBER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">CONTROL NUMBER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">003</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">CONTROL NUMBER IDENTIFIER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">CONTROL NUMBER IDENTIFIER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">010</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">LIBRARY OF CONGRESS CONTROL NUMBER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">LIBRARY OF CONGRESS CONTROL NUMBER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell></ss:Row></ss:Table></Worksheet><Worksheet ss:Name="marc_subfield_structure"><ss:Table><ss:Row><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">tagfield</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">tagsubfield</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">liblibrarian</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">libopac</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">repeatable</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">mandatory</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">kohafield</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">tab</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">authorised_value</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">authtypecode</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">value_builder</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">isurl</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">hidden</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">frameworkcode</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">seealso</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">link</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">defaultvalue</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">maxlength</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">000</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_leader.pl</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">24</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">001</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">003</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_orgcode.pl</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">005</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_field_005.pl</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">006</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_field_006.pl</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">-1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">007</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_field_007.pl</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">008</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_field_008.pl</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">40</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">009</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">-6</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">010</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">8</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">Field link and sequence number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">Field link and sequence number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">-6</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">010</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">a</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">LC control number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">LC control number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">biblioitems.lccn</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">010</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">b</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">NUCMC control number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">NUCMC control number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">-1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">010</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">z</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">Canceled/invalid LC control number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">Canceled/invalid LC control number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">-1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T4</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row></ss:Table></Worksheet></Workbook>

diff --git a/t/db_dependent/data/frameworks/biblio_framework_smaller.csv b/t/db_dependent/data/frameworks/biblio_framework_smaller.csv
new file mode 100644 (file)
index 0000000..876410a
--- /dev/null
+++ b/t/db_dependent/data/frameworks/biblio_framework_smaller.csv
@@ -0,0 +1,18 @@
+"tagfield","liblibrarian","libopac","repeatable","mandatory","authorised_value","frameworkcode"
+"000","LEADER","LEADER","0","1","","T5"
+"001","CONTROL NUMBER","CONTROL NUMBER","0","0","","T5"
+"003","CONTROL NUMBER IDENTIFIER","CONTROL NUMBER IDENTIFIER","0","1","","T5"
+
+"#-#","#-#","#-#","#-#","#-#","#-#","#-#"
+
+"tagfield","tagsubfield","liblibrarian","libopac","repeatable","mandatory","kohafield","tab","authorised_value","authtypecode","value_builder","isurl","hidden","frameworkcode","seealso","link","defaultvalue","maxlength"
+"000","@","fixed length control field","fixed length control field","0","1","","0","","","marc21_leader.pl","0","0","T5","","","","24"
+"001","@","control field","control field","0","0","","0","","","","0","0","T5","","","","9999"
+"003","@","control field","control field","0","1","","0","","","marc21_orgcode.pl","0","0","T5","","","","9999"
+"005","@","control field","control field","0","1","","0","","","marc21_field_005.pl","0","0","T5","","","","9999"
+"007","@","fixed length control field","fixed length control field","0","0","","0","","","marc21_field_007.pl","0","0","T5","","","","9999"
+"008","@","fixed length control field","fixed length control field","0","1","","0","","","marc21_field_008.pl","0","0","T5","","","","40"
+"010","8","Field link and sequence number","Field link and sequence number","1","0","","0","","","","0","-6","T5","","","","9999"
+"010","b","NUCMC control number","NUCMC control number","1","0","","0","","","","0","-1","T5","","","","9999"
+
+"#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#"

diff --git a/t/db_dependent/data/frameworks/biblio_framework_smaller.ods b/t/db_dependent/data/frameworks/biblio_framework_smaller.ods
new file mode 100644 (file)
index 0000000..99c5642
Binary files /dev/null and b/t/db_dependent/data/frameworks/biblio_framework_smaller.ods differ

diff --git a/t/db_dependent/data/frameworks/biblio_framework_smaller.xml b/t/db_dependent/data/frameworks/biblio_framework_smaller.xml
new file mode 100644 (file)
index 0000000..cff72b8
--- /dev/null
+++ b/t/db_dependent/data/frameworks/biblio_framework_smaller.xml
@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<?mso-application progid="Excel.Sheet"?>
+<Workbook xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
+
+<Styles>
+ <Style ss:ID="Default" ss:Name="Normal">
+  <Alignment ss:Vertical="Bottom"/>
+  <Borders/>
+  <Font/>
+  <Interior/>
+  <NumberFormat/>
+  <Protection/>
+ </Style>
+ <Style ss:ID="s27">
+  <Font x:Family="Swiss" ss:Color="#0000FF" ss:Bold="1"/>
+ </Style>
+ <Style ss:ID="s21">
+  <NumberFormat ss:Format="yyyy\-mm\-dd"/>
+ </Style>
+ <Style ss:ID="s22">
+  <NumberFormat ss:Format="yyyy\-mm\-dd\ hh:mm:ss"/>
+ </Style>
+ <Style ss:ID="s23">
+  <NumberFormat ss:Format="hh:mm:ss"/>
+ </Style>
+</Styles>
+
+<Worksheet ss:Name="marc_tag_structure"><ss:Table><ss:Row><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">tagfield</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">liblibrarian</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">libopac</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">repeatable</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">mandatory</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">authorised_value</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">frameworkcode</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">000</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">LEADER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">LEADER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T5</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">001</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">CONTROL NUMBER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">CONTROL NUMBER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T5</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">003</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">CONTROL NUMBER IDENTIFIER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">CONTROL NUMBER IDENTIFIER</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T5</ss:Data></ss:Cell></ss:Row></ss:Table></Worksheet><Worksheet ss:Name="marc_subfield_structure"><ss:Table><ss:Row><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">tagfield</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">tagsubfield</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">liblibrarian</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">libopac</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">repeatable</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">mandatory</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">kohafield</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">tab</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">authorised_value</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">authtypecode</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">value_builder</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">isurl</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">hidden</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">frameworkcode</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">seealso</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">link</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">defaultvalue</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">maxlength</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">000</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_leader.pl</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T5</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">24</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">001</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T5</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">003</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_orgcode.pl</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T5</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">005</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_field_005.pl</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T5</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">007</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_field_007.pl</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T5</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">008</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">@</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">fixed length control field</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_field_008.pl</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T5</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">40</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">010</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">8</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">Field link and sequence number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">Field link and sequence number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">-6</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T5</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">010</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">b</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">NUCMC control number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">NUCMC control number</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">-1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">T5</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="Number">9999</ss:Data></ss:Cell></ss:Row></ss:Table></Worksheet></Workbook>