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

(-)a/t/db_dependent/ImportExportFramework.t (-11 / +79 lines)
Lines 26-31 use File::Basename qw( dirname ); Link Here
26
use Koha::Database;
26
use Koha::Database;
27
use Koha::BiblioFrameworks;
27
use Koha::BiblioFrameworks;
28
use Koha::MarcSubfieldStructures;
28
use Koha::MarcSubfieldStructures;
29
use Koha::Authority::Types;
30
use Koha::Authority::Subfields;
29
use C4::ImportExportFramework;
31
use C4::ImportExportFramework;
30
32
31
my $schema  = Koha::Database->new->schema;
33
my $schema  = Koha::Database->new->schema;
Lines 33-69 my $builder = t::lib::TestBuilder->new; Link Here
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 => 9;
41
        plan tests => 9;
40
42
41
        run_tests('csv');
43
        run_biblio_tests('csv');
42
    };
44
    };
43
45
44
    subtest 'ODS tests' => sub {
46
    subtest 'ODS tests for biblio frameworks' => sub {
45
        plan tests => 9;
47
        plan tests => 9;
46
48
47
        run_tests('ods');
49
        run_biblio_tests('ods');
48
    };
50
    };
49
51
50
    subtest 'XML tests' => sub {
52
    subtest 'XML tests for biblio frameworks' => sub {
51
        plan tests => 9;
53
        plan tests => 9;
52
54
53
        run_tests('xml');
55
        run_biblio_tests('xml');
54
    };
56
    };
57
58
    subtest 'CSV tests for auth frameworks' => sub {
59
        plan tests => 9;
60
61
        run_auth_tests('csv');
62
    };
63
64
    subtest 'ODS tests for auth frameworks' => sub {
65
        plan tests => 9;
66
67
        run_auth_tests('ods');
68
    };
69
70
    subtest 'XML tests for auth frameworks' => sub {
71
        plan tests => 9;
72
73
        run_auth_tests('xml');
74
    };
75
55
};
76
};
56
77
57
sub run_tests {
78
sub run_biblio_tests {
58
79
59
    my ($format) = @_;
80
    my ($format) = @_;
81
    my $type = "biblio";
60
82
61
    $schema->storage->txn_begin;
83
    $schema->storage->txn_begin;
62
84
63
    my $data_filepath = dirname(__FILE__) . "/data/frameworks/biblio_framework.$format";
85
    my $data_filepath = dirname(__FILE__) . "/data/frameworks/biblio_framework.$format";
64
    my $fw_1 = $builder->build_object({ class => 'Koha::BiblioFrameworks' });
86
    my $fw_1 = $builder->build_object({ class => 'Koha::BiblioFrameworks' });
65
87
66
    my $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id );
88
    my $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id, 0, $type );
67
    is( $result, 0, 'Import successful, no tags removed' );
89
    is( $result, 0, 'Import successful, no tags removed' );
68
90
69
    my $nb_tags = $schema->resultset('MarcTagStructure')->search({ frameworkcode => $fw_1->id })->count;
91
    my $nb_tags = $schema->resultset('MarcTagStructure')->search({ frameworkcode => $fw_1->id })->count;
Lines 74-80 sub run_tests { Link Here
74
96
75
    # bad file tests
97
    # bad file tests
76
    my $fw_2 = $builder->build_object({ class => 'Koha::BiblioFrameworks' });
98
    my $fw_2 = $builder->build_object({ class => 'Koha::BiblioFrameworks' });
77
    $result = C4::ImportExportFramework::ImportFramework( '', $fw_2->id );
99
    $result = C4::ImportExportFramework::ImportFramework( '', $fw_2->id, 0, $type );
78
100
79
    is( $result, -1, 'Bad file makes it return -1' );
101
    is( $result, -1, 'Bad file makes it return -1' );
80
102
Lines 87-93 sub run_tests { Link Here
87
    # framework overwrite
109
    # framework overwrite
88
    $data_filepath = dirname(__FILE__) . "/data/frameworks/biblio_framework_smaller.$format";
110
    $data_filepath = dirname(__FILE__) . "/data/frameworks/biblio_framework_smaller.$format";
89
111
90
    $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id );
112
    $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id, 0, $type );
91
    is( $result, 5, 'Smaller fw import successful, 4 tags removed' );
113
    is( $result, 5, 'Smaller fw import successful, 4 tags removed' );
92
114
93
    $nb_tags = $schema->resultset('MarcTagStructure')->search({ frameworkcode => $fw_1->id })->count;
115
    $nb_tags = $schema->resultset('MarcTagStructure')->search({ frameworkcode => $fw_1->id })->count;
Lines 98-100 sub run_tests { Link Here
98
120
99
    $schema->storage->txn_rollback;
121
    $schema->storage->txn_rollback;
100
}
122
}
123
124
sub run_auth_tests {
125
126
    my ($format) = @_;
127
    my $type = "authority";
128
129
    $schema->storage->txn_begin;
130
131
    my $data_filepath = dirname(__FILE__) . "/data/frameworks/auth_type.$format";
132
    my $fw_1 = $builder->build_object({ class => 'Koha::Authority::Types' });
133
134
    my $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id, '', $type );
135
    is( $result, 0, 'Import successful, no tags removed' );
136
137
    my $nb_tags = $schema->resultset('AuthTagStructure')->search({ authtypecode => $fw_1->id })->count;
138
    is( $nb_tags, 6, "6 tags should have been imported" );
139
140
    my $nb_subfields = Koha::Authority::Subfields->search({ authtypecode => $fw_1->id })->count;
141
    is( $nb_subfields, 8, "8 subfields should have been imported" );
142
143
    # bad file tests
144
    my $fw_2 = $builder->build_object({ class => 'Koha::Authority::Types' });
145
    $result = C4::ImportExportFramework::ImportFramework( '', $fw_2->id, '', $type );
146
147
    is( $result, -1, 'Bad file makes it return -1' );
148
149
    $nb_tags = $schema->resultset('AuthTagStructure')->search({ authtypecode => $fw_2->id })->count;
150
    is( $nb_tags, 0, "0 tags should have been imported" );
151
152
    $nb_subfields = Koha::Authority::Subfields->search({ authtypecode => $fw_2->id })->count;
153
    is( $nb_subfields, 0, "0 subfields should have been imported" );
154
155
    # framework overwrite
156
    $data_filepath = dirname(__FILE__) . "/data/frameworks/auth_type_smaller.$format";
157
158
    $result = C4::ImportExportFramework::ImportFramework( $data_filepath, $fw_1->id, '', $type );
159
    is( $result, 8, 'Smaller fw import successful, 6 tags removed' );
160
161
    $nb_tags = $schema->resultset('AuthTagStructure')->search({ authtypecode => $fw_1->id })->count;
162
    is( $nb_tags, 3, "3 tags should have been imported" );
163
164
    $nb_subfields = Koha::Authority::Subfields->search({ authtypecode => $fw_1->id })->count;
165
    is( $nb_subfields, 3, "3 subfields should have been imported" );
166
167
    $schema->storage->txn_rollback;
168
}
(-)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