View | Details | Raw Unified | Return to bug 13952
Collapse All | Expand All

(-)a/t/db_dependent/ImportExportFramework.t (-11 / +79 lines)
Lines 27-73 use Koha::Database; Link Here
27
use Koha::BiblioFrameworks;
27
use Koha::BiblioFrameworks;
28
use Koha::MarcSubfieldStructures;
28
use Koha::MarcSubfieldStructures;
29
use C4::ImportExportFramework qw( ImportFramework ExportFramework );
29
use C4::ImportExportFramework qw( ImportFramework ExportFramework );
30
use Koha::Authority::Types;
31
use Koha::Authority::Subfields;
30
32
31
my $schema  = Koha::Database->new->schema;
33
my $schema  = Koha::Database->new->schema;
32
my $builder = t::lib::TestBuilder->new;
34
my $builder = t::lib::TestBuilder->new;
33
35
34
subtest 'ImportFramework() tests' => sub {
36
subtest 'ImportFramework() tests' => sub {
35
37
36
    plan tests => 3;
38
    plan tests => 6;
37
39
38
    subtest 'CSV tests' => sub {
40
    subtest 'CSV tests for biblio frameworks' => sub {
39
        plan tests => 15;
41
        plan tests => 15;
40
42
41
        run_tests('csv');
43
        run_biblio_tests('csv');
42
44
43
        run_csv_no_quoted();
45
        run_csv_no_quoted();
44
    };
46
    };
45
47
46
    subtest 'ODS tests' => sub {
48
    subtest 'ODS tests for biblio frameworks' => sub {
47
        plan tests => 15;
49
        plan tests => 15;
48
50
49
        run_tests('ods');
51
        run_biblio_tests('ods');
50
52
51
        run_ods_new();
53
        run_ods_new();
52
    };
54
    };
53
55
54
    subtest 'XML tests' => sub {
56
    subtest 'XML tests for biblio frameworks' => sub {
55
        plan tests => 9;
57
        plan tests => 9;
56
58
57
        run_tests('xml');
59
        run_biblio_tests('xml');
58
    };
60
    };
61
62
    subtest 'CSV tests for auth frameworks' => sub {
63
        plan tests => 9;
64
65
        run_auth_tests('csv');
66
    };
67
68
    subtest 'ODS tests for auth frameworks' => sub {
69
        plan tests => 9;
70
71
        run_auth_tests('ods');
72
    };
73
74
    subtest 'XML tests for auth frameworks' => sub {
75
        plan tests => 9;
76
77
        run_auth_tests('xml');
78
    };
79
59
};
80
};
60
81
61
sub run_tests {
82
sub run_biblio_tests {
62
83
63
    my ($format) = @_;
84
    my ($format) = @_;
85
    my $type = "biblio";
64
86
65
    $schema->storage->txn_begin;
87
    $schema->storage->txn_begin;
66
88
67
    my $data_filepath = dirname(__FILE__) . "/data/frameworks/biblio_framework.$format";
89
    my $data_filepath = dirname(__FILE__) . "/data/frameworks/biblio_framework.$format";
68
    my $fw_1 = $builder->build_object({ class => 'Koha::BiblioFrameworks' });
90
    my $fw_1 = $builder->build_object({ class => 'Koha::BiblioFrameworks' });
69
91
70
    my $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id );
92
    my $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id, 0, $type );
71
    is( $result, 0, 'Import successful, no tags removed' );
93
    is( $result, 0, 'Import successful, no tags removed' );
72
94
73
    my $nb_tags = $schema->resultset('MarcTagStructure')->search({ frameworkcode => $fw_1->id })->count;
95
    my $nb_tags = $schema->resultset('MarcTagStructure')->search({ frameworkcode => $fw_1->id })->count;
Lines 78-84 sub run_tests { Link Here
78
100
79
    # bad file tests
101
    # bad file tests
80
    my $fw_2 = $builder->build_object({ class => 'Koha::BiblioFrameworks' });
102
    my $fw_2 = $builder->build_object({ class => 'Koha::BiblioFrameworks' });
81
    $result = C4::ImportExportFramework::ImportFramework( '', $fw_2->id );
103
    $result = C4::ImportExportFramework::ImportFramework( '', $fw_2->id, 0, $type );
82
104
83
    is( $result, -1, 'Bad file makes it return -1' );
105
    is( $result, -1, 'Bad file makes it return -1' );
84
106
Lines 91-97 sub run_tests { Link Here
91
    # framework overwrite
113
    # framework overwrite
92
    $data_filepath = dirname(__FILE__) . "/data/frameworks/biblio_framework_smaller.$format";
114
    $data_filepath = dirname(__FILE__) . "/data/frameworks/biblio_framework_smaller.$format";
93
115
94
    $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id );
116
    $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id, 0, $type );
95
    is( $result, 5, 'Smaller fw import successful, 4 tags removed' );
117
    is( $result, 5, 'Smaller fw import successful, 4 tags removed' );
96
118
97
    $nb_tags = $schema->resultset('MarcTagStructure')->search({ frameworkcode => $fw_1->id })->count;
119
    $nb_tags = $schema->resultset('MarcTagStructure')->search({ frameworkcode => $fw_1->id })->count;
Lines 167-169 sub run_ods_new { Link Here
167
189
168
    $schema->storage->txn_rollback;
190
    $schema->storage->txn_rollback;
169
};
191
};
192
193
sub run_auth_tests {
194
195
    my ($format) = @_;
196
    my $type = "authority";
197
198
    $schema->storage->txn_begin;
199
200
    my $data_filepath = dirname(__FILE__) . "/data/frameworks/auth_type.$format";
201
    my $fw_1 = $builder->build_object({ class => 'Koha::Authority::Types' });
202
203
    my $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id, '', $type );
204
    is( $result, 0, 'Import successful, no tags removed' );
205
206
    my $nb_tags = $schema->resultset('AuthTagStructure')->search({ authtypecode => $fw_1->id })->count;
207
    is( $nb_tags, 6, "6 tags should have been imported" );
208
209
    my $nb_subfields = Koha::Authority::Subfields->search({ authtypecode => $fw_1->id })->count;
210
    is( $nb_subfields, 8, "8 subfields should have been imported" );
211
212
    # bad file tests
213
    my $fw_2 = $builder->build_object({ class => 'Koha::Authority::Types' });
214
    $result = C4::ImportExportFramework::ImportFramework( '', $fw_2->id, '', $type );
215
216
    is( $result, -1, 'Bad file makes it return -1' );
217
218
    $nb_tags = $schema->resultset('AuthTagStructure')->search({ authtypecode => $fw_2->id })->count;
219
    is( $nb_tags, 0, "0 tags should have been imported" );
220
221
    $nb_subfields = Koha::Authority::Subfields->search({ authtypecode => $fw_2->id })->count;
222
    is( $nb_subfields, 0, "0 subfields should have been imported" );
223
224
    # framework overwrite
225
    $data_filepath = dirname(__FILE__) . "/data/frameworks/auth_type_smaller.$format";
226
227
    $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id, '', $type );
228
    is( $result, 8, 'Smaller fw import successful, 6 tags removed' );
229
230
    $nb_tags = $schema->resultset('AuthTagStructure')->search({ authtypecode => $fw_1->id })->count;
231
    is( $nb_tags, 3, "3 tags should have been imported" );
232
233
    $nb_subfields = Koha::Authority::Subfields->search({ authtypecode => $fw_1->id })->count;
234
    is( $nb_subfields, 3, "3 subfields should have been imported" );
235
236
    $schema->storage->txn_rollback;
237
};
(-)a/t/db_dependent/data/frameworks/auth_type.csv (+21 lines)
Line 0 Link Here
1
"authtypecode","tagfield","liblibrarian","libopac","repeatable","mandatory","authorised_value"
2
"TEST","000","LEADER","LEADER","0","1",""
3
"TEST","001","CONTROL NUMBER","CONTROL NUMBER","0","1",""
4
"TEST","003","CONTROL NUMBER IDENTIFIER","CONTROL NUMBER IDENTIFIER","0","1",""
5
"TEST","005","DATE AND TIME OF LATEST TRANSACTION","DATE AND TIME OF LATEST TRANSACTION","0","1",""
6
"TEST","008","FIXED-LENGTH DATA ELEMENTS","FIXED-LENGTH DATA ELEMENTS","0","1",""
7
"TEST","010","LIBRARY OF CONGRESS CONTROL NUMBER","LIBRARY OF CONGRESS CONTROL NUMBER","0","0",""
8
9
"#-#","#-#","#-#","#-#","#-#","#-#","#-#"
10
11
"authtypecode","tagfield","tagsubfield","liblibrarian","libopac","repeatable","mandatory","tab","authorised_value","value_builder","seealso","isurl","hidden","linkid","kohafield","frameworkcode","defaultvalue"
12
"TEST","000","@","fixed length control field","fixed length control field","0","1","0","","marc21_leader_authorities.pl","","0","0","0","","",""
13
"TEST","001","@","control field","control field","0","0","0","","","","0","0","0","auth_header.authid","",""
14
"TEST","003","@","control field","control field","0","1","0","","marc21_orgcode.pl","","0","0","0","","",""
15
"TEST","005","@","control field","control field","0","1","0","","marc21_field_005.pl","","0","0","0","","",""
16
"TEST","008","@","fixed length control field","fixed length control field","0","1","0","","marc21_field_008_authorities.pl","","0","0","0","","",""
17
"TEST","010","8","Field link and sequence number","Field link and sequence number","1","0","0","","","","0","0","0","","",""
18
"TEST","010","a","LC control number","LC control number","0","0","0","","","","0","0","0","","",""
19
"TEST","010","z","Canceled/invalid LC control number","Canceled/invalid LC control number","1","0","0","","","","0","0","0","","",""
20
21
"#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#"
(-)a/t/db_dependent/data/frameworks/auth_type.xml (+28 lines)
Line 0 Link Here
1
<?xml version="1.0" encoding="UTF-8"?>
2
<?mso-application progid="Excel.Sheet"?>
3
<Workbook xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
4
5
<Styles>
6
 <Style ss:ID="Default" ss:Name="Normal">
7
  <Alignment ss:Vertical="Bottom"/>
8
  <Borders/>
9
  <Font/>
10
  <Interior/>
11
  <NumberFormat/>
12
  <Protection/>
13
 </Style>
14
 <Style ss:ID="s27">
15
   <Font x:Family="Swiss" ss:Color="#0000FF" ss:Bold="1"/>
16
 </Style>
17
 <Style ss:ID="s21">
18
  <NumberFormat ss:Format="yyyy\-mm\-dd"/>
19
 </Style>
20
 <Style ss:ID="s22">
21
  <NumberFormat ss:Format="yyyy\-mm\-dd\ hh:mm:ss"/>
22
 </Style>
23
 <Style ss:ID="s23">
24
  <NumberFormat ss:Format="hh:mm:ss"/>
25
 </Style>
26
</Styles>
27
28
<Worksheet ss:Name="auth_tag_structure"><ss:Table><ss:Row><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">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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">005</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">DATE AND TIME OF LATEST TRANSACTION</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">DATE AND TIME OF LATEST TRANSACTION</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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">008</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">FIXED-LENGTH DATA ELEMENTS</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">FIXED-LENGTH DATA ELEMENTS</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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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:Row></ss:Table></Worksheet><Worksheet ss:Name="auth_subfield_structure"><ss:Table><ss:Row><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">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">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">value_builder</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">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">linkid</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">frameworkcode</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">defaultvalue</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_leader_authorities.pl</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="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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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="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="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">auth_header.authid</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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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="Number">0</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="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="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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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="Number">0</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="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="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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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="Number">0</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_authorities.pl</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="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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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="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="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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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="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="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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">TEST</ss:Data></ss:Cell><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="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="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:Row></ss:Table></Worksheet></Workbook>
(-)a/t/db_dependent/data/frameworks/auth_type_smaller.csv (+13 lines)
Line 0 Link Here
1
"authtypecode","tagfield","liblibrarian","libopac","repeatable","mandatory","authorised_value"
2
"","000","LEADER","LEADER","0","1",""
3
"","001","CONTROL NUMBER","CONTROL NUMBER","0","1",""
4
"","003","CONTROL NUMBER IDENTIFIER","CONTROL NUMBER IDENTIFIER","0","1",""
5
6
"#-#","#-#","#-#","#-#","#-#","#-#","#-#"
7
8
"authtypecode","tagfield","tagsubfield","liblibrarian","libopac","repeatable","mandatory","tab","authorised_value","value_builder","seealso","isurl","hidden","linkid","kohafield","frameworkcode","defaultvalue"
9
"","000","@","fixed length control field","fixed length control field","0","1","0","","marc21_leader_authorities.pl","","0","0","0","","",""
10
"","001","@","control field","control field","0","0","0","","","","0","0","0","auth_header.authid","",""
11
"","003","@","control field","control field","0","1","0","","marc21_orgcode.pl","","0","0","0","","",""
12
13
"#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#","#-#"
(-)a/t/db_dependent/data/frameworks/auth_type_smaller.xml (-1 / +28 lines)
Line 0 Link Here
0
- 
1
<?xml version="1.0" encoding="UTF-8"?>
2
<?mso-application progid="Excel.Sheet"?>
3
<Workbook xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
4
5
<Styles>
6
 <Style ss:ID="Default" ss:Name="Normal">
7
  <Alignment ss:Vertical="Bottom"/>
8
  <Borders/>
9
  <Font/>
10
  <Interior/>
11
  <NumberFormat/>
12
  <Protection/>
13
 </Style>
14
 <Style ss:ID="s27">
15
  <Font x:Family="Swiss" ss:Color="#0000FF" ss:Bold="1"/>
16
 </Style>
17
 <Style ss:ID="s21">
18
  <NumberFormat ss:Format="yyyy\-mm\-dd"/>
19
 </Style>
20
 <Style ss:ID="s22">
21
  <NumberFormat ss:Format="yyyy\-mm\-dd\ hh:mm:ss"/>
22
 </Style>
23
 <Style ss:ID="s23">
24
  <NumberFormat ss:Format="hh:mm:ss"/>
25
 </Style>
26
</Styles>
27
28
<Worksheet ss:Name="auth_tag_structure"><ss:Table><ss:Row><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">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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">T_SMALL</ss:Data></ss:Cell><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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">T_SMALL</ss:Data></ss:Cell><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">1</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">T_SMALL</ss:Data></ss:Cell><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:Row></ss:Table></Worksheet><Worksheet ss:Name="auth_subfield_structure"><ss:Table><ss:Row><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">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">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">value_builder</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">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">linkid</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">frameworkcode</ss:Data></ss:Cell><ss:Cell ss:StyleID="s27"><ss:Data ss:Type="String">defaultvalue</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">T_SMALL</ss:Data></ss:Cell><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="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">#</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">marc21_leader_authorities.pl</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="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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">T_SMALL</ss:Data></ss:Cell><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="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="Number">0</ss:Data></ss:Cell><ss:Cell><ss:Data ss:Type="String">auth_header.authid</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:Row><ss:Row><ss:Cell><ss:Data ss:Type="String">T_SMALL</ss:Data></ss:Cell><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="Number">0</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="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="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:Row></ss:Table></Worksheet></Workbook>

Return to bug 13952