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

(-)a/installer/data/mysql/sysprefs.sql (-4 / +4 lines)
Lines 89-95 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
89
('decreaseLoanHighHoldsDuration',NULL,'','Specifies a number of days that a loan is reduced to when used in conjunction with decreaseLoanHighHolds','Integer'),
89
('decreaseLoanHighHoldsDuration',NULL,'','Specifies a number of days that a loan is reduced to when used in conjunction with decreaseLoanHighHolds','Integer'),
90
('decreaseLoanHighHoldsValue',NULL,'','Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)','Integer'),
90
('decreaseLoanHighHoldsValue',NULL,'','Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)','Integer'),
91
('DefaultClassificationSource','ddc',NULL,'Default classification scheme used by the collection. E.g., Dewey, LCC, etc.','ClassSources'),
91
('DefaultClassificationSource','ddc',NULL,'Default classification scheme used by the collection. E.g., Dewey, LCC, etc.','ClassSources'),
92
('DefaultLanguageField008','','','Fill in the default language for field 008 Range 35-37 (e.g. eng, nor, ger, see <a href=\"http://www.loc.gov/marc/languages/language_code.html\">MARC Code List for Languages</a>)','Free'),
92
('DefaultLanguageField008','','','Fill in the default language for field 008 Range 35-37 of MARC21 records (e.g. eng, nor, ger, see <a href=\"http://www.loc.gov/marc/languages/language_code.html\">MARC Code List for Languages</a>)','Free'),
93
('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
93
('defaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
94
('defaultSortOrder','dsc','asc|dsc|az|za','Specify the default sort order','Choice'),
94
('defaultSortOrder','dsc','asc|dsc|az|za','Specify the default sort order','Choice'),
95
('delimiter',';',';|tabulation|,|/|\\|#||','Define the default separator character for exporting reports','Choice'),
95
('delimiter',';',';|tabulation|,|/|\\|#||','Define the default separator character for exporting reports','Choice'),
Lines 174-181 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
174
('LinkerRelink','1',NULL,'If ON the authority linker will relink headings that have previously been linked every time it runs.','YesNo'),
174
('LinkerRelink','1',NULL,'If ON the authority linker will relink headings that have previously been linked every time it runs.','YesNo'),
175
('LocalCoverImages','0','1','Display local cover images on intranet details pages.','YesNo'),
175
('LocalCoverImages','0','1','Display local cover images on intranet details pages.','YesNo'),
176
('ManInvInNoissuesCharge','1',NULL,'MANUAL_INV charges block checkouts (added to noissuescharge).','YesNo'),
176
('ManInvInNoissuesCharge','1',NULL,'MANUAL_INV charges block checkouts (added to noissuescharge).','YesNo'),
177
('MARCAuthorityControlField008','|| aca||aabn           | a|a     d',NULL,NULL,'Textarea'),
177
('MARCAuthorityControlField008','|| aca||aabn           | a|a     d',NULL,'Define the contents of MARC21 authority control field 008 position 06-39','Textarea'),
178
('MARCOrgCode','OSt','','Define MARC Organization Code - http://www.loc.gov/marc/organizations/orgshome.html','free'),
178
('MARCOrgCode','OSt','','Define MARC Organization Code for MARC21 records - http://www.loc.gov/marc/organizations/orgshome.html','free'),
179
('MaxFine',NULL,'','Maximum fine a patron can have for all late returns at one moment. Single item caps are specified in the circulation rules matrix.','Integer'),
179
('MaxFine',NULL,'','Maximum fine a patron can have for all late returns at one moment. Single item caps are specified in the circulation rules matrix.','Integer'),
180
('maxItemsInSearchResults','20',NULL,'Specify the maximum number of items to display for each result on a page of results','free'),
180
('maxItemsInSearchResults','20',NULL,'Specify the maximum number of items to display for each result on a page of results','free'),
181
('maxoutstanding','5','','maximum amount withstanding to be able make holds','Integer'),
181
('maxoutstanding','5','','maximum amount withstanding to be able make holds','Integer'),
Lines 395-401 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
395
('TrackClicks','0',NULL,'Track links clicked','Integer'),
395
('TrackClicks','0',NULL,'Track links clicked','Integer'),
396
('TransfersMaxDaysWarning','3',NULL,'Define the days before a transfer is suspected of having a problem','Integer'),
396
('TransfersMaxDaysWarning','3',NULL,'Define the days before a transfer is suspected of having a problem','Integer'),
397
('TransferWhenCancelAllWaitingHolds','0',NULL,'Transfer items when cancelling all waiting holds','YesNo'),
397
('TransferWhenCancelAllWaitingHolds','0',NULL,'Transfer items when cancelling all waiting holds','YesNo'),
398
('UNIMARCAuthorityField100','afrey50      ba0',NULL,NULL,'Textarea'),
398
('UNIMARCAuthorityField100','afrey50      ba0',NULL,'Define the contents of UNIMARC authority control field 100 position 08-35','Textarea'),
399
('UNIMARCAuthorsFacetsSeparator',', ',NULL,'UNIMARC authors facets separator','short'),
399
('UNIMARCAuthorsFacetsSeparator',', ',NULL,'UNIMARC authors facets separator','short'),
400
('UNIMARCField100Language','fre',NULL,'UNIMARC field 100 default language','short'),
400
('UNIMARCField100Language','fre',NULL,'UNIMARC field 100 default language','short'),
401
('UniqueItemFields','barcode','','Space-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table','Free'),
401
('UniqueItemFields','barcode','','Space-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table','Free'),
(-)a/installer/data/mysql/updatedatabase.pl (+21 lines)
Lines 7945-7950 if (CheckVersion($DBversion)) { Link Here
7945
    SetVersion($DBversion);
7945
    SetVersion($DBversion);
7946
}
7946
}
7947
7947
7948
$DBversion = "3.15.00.XXX";
7949
if(CheckVersion($DBversion)) {
7950
    $dbh->do(q{
7951
        UPDATE systempreferences
7952
        SET explanation = 'Define the contents of UNIMARC authority control field 100 position 08-35'
7953
        WHERE variable = "UNIMARCAuthorityField100"
7954
    });
7955
    $dbh->do(q{
7956
        UPDATE systempreferences
7957
        SET explanation = 'Define the contents of MARC21 authority control field 008 position 06-39'
7958
        WHERE variable = "MARCAuthorityControlField008"
7959
    });
7960
    $dbh->do(q{
7961
        UPDATE systempreferences
7962
        SET explanation = 'Define MARC Organization Code for MARC21 records - http://www.loc.gov/marc/organizations/orgshome.html'
7963
        WHERE variable = "MARCOrgCode"
7964
    });
7965
    print "Upgrade to $DBversion done (Bug 11611 - fix possible confusion between UNIMARC and MARC21 in some sysprefs)\n";
7966
    SetVersion($DBversion);
7967
}
7968
7948
=head1 FUNCTIONS
7969
=head1 FUNCTIONS
7949
7970
7950
=head2 TableExists($table)
7971
=head2 TableExists($table)
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/authorities.pref (-2 / +2 lines)
Lines 31-37 Authorities: Link Here
31
                  no: Do
31
                  no: Do
32
            - automatically update attached biblios when changing an authority record. If this is off, please ask your administrator to enable the merge_authority.pl cronjob.
32
            - automatically update attached biblios when changing an authority record. If this is off, please ask your administrator to enable the merge_authority.pl cronjob.
33
        -
33
        -
34
            - Use the following text for the contents of MARC authority control field 008 position 06-39 (fixed length data elements). Do NOT include the date (position 00-05).
34
            - Use the following text for the contents of MARC21 authority control field 008 position 06-39 (fixed length data elements). Do NOT include the date (position 00-05).
35
            - pref: MARCAuthorityControlField008
35
            - pref: MARCAuthorityControlField008
36
              default: "|| aca||aabn           | a|a     d"
36
              default: "|| aca||aabn           | a|a     d"
37
              type: textarea
37
              type: textarea
Lines 44-50 Authorities: Link Here
44
                  no: "Don't use"
44
                  no: "Don't use"
45
            - authority record numbers instead of text strings for searches from subject tracings.
45
            - authority record numbers instead of text strings for searches from subject tracings.
46
        -
46
        -
47
            - Use the following text for the contents of UNIMARC authority field 100 position (fixed length data elements). Do NOT include the date (position 00-05).
47
            - Use the following text for the contents of UNIMARC authority field 100 position 08-35 (fixed length data elements). Do NOT include the date (position 00-07).
48
            - pref: UNIMARCAuthorityField100
48
            - pref: UNIMARCAuthorityField100
49
              defautl: "afrey50      ba0"
49
              defautl: "afrey50      ba0"
50
              type: textarea
50
              type: textarea
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref (-4 / +3 lines)
Lines 40-46 Cataloging: Link Here
40
        -
40
        -
41
    Record Structure:
41
    Record Structure:
42
        -
42
        -
43
            - Fill in the default language for field 008 Range 35-37 (e.g. eng, nor, ger, see <a href="http://www.loc.gov/marc/languages/language_code.html">MARC Code List for Languages</a>)
43
            - Fill in the default language for field 008 Range 35-37 of MARC21 records (e.g. eng, nor, ger, see <a href="http://www.loc.gov/marc/languages/language_code.html">MARC Code List for Languages</a>)
44
            - pref: DefaultLanguageField008
44
            - pref: DefaultLanguageField008
45
            - " Empty defaults to eng."
45
            - " Empty defaults to eng."
46
        -
46
        -
Lines 61-67 Cataloging: Link Here
61
        -
61
        -
62
            - Map the MARC subfield
62
            - Map the MARC subfield
63
            - pref: itemcallnumber
63
            - pref: itemcallnumber
64
            - "to an item's callnumber. (This can contain multiple subfields to look in; for instance <code>082ab</code> would look in 082 subfields a and b.)<br />Examples: <strong>Dewey</strong>: <code>082ab</code> or <code>092ab</code>; <strong>LOC</strong>: <code>050ab</code> or <code>090ab</code>; <strong>from the item record</strong>: <code>852hi</code>"
64
            - "to an item's callnumber. (This can contain multiple subfields to look in; for instance <code>082ab</code> would look in 082 subfields a and b.)<br />Examples (for MARC21 records): <strong>Dewey</strong>: <code>082ab</code> or <code>092ab</code>; <strong>LOC</strong>: <code>050ab</code> or <code>090ab</code>; <strong>from the item record</strong>: <code>852hi</code>"
65
        -
65
        -
66
            - Display MARC subfield
66
            - Display MARC subfield
67
            - pref: AlternateHoldingsField
67
            - pref: AlternateHoldingsField
Lines 71-77 Cataloging: Link Here
71
        -
71
        -
72
            - Fill in the <a href="http://www.loc.gov/marc/organizations/orgshome.html">MARC organization code</a>
72
            - Fill in the <a href="http://www.loc.gov/marc/organizations/orgshome.html">MARC organization code</a>
73
            - pref: MARCOrgCode
73
            - pref: MARCOrgCode
74
            - by default in new MARC records (leave blank to disable).
74
            - by default in new MARC21 records (leave blank to disable).
75
        -
75
        -
76
            - When items are created, give them the temporary location of
76
            - When items are created, give them the temporary location of
77
            - pref: NewItemsDefaultLocation
77
            - pref: NewItemsDefaultLocation
78
- 

Return to bug 11611