history:evergreen_for_academics:academic_customizations
Table of Contents
Academic Customizations
List of common academic minded Evergreen customizations
Cataloging: Changing default call number suggestion when creating a volume
- Submitted by Berklee College of Music
- April 9, 2015
By default EG suggest a Dewey based call number in a bib record when crating a new volume. Here is how to change that default to use LoC call numbers. The database table that needs to be updated is the asset.call_number_class table. You just change the order of the call numbers from 050, 055, 090 to 090, 050, 055. I found the info here:
http://list.evergreen-ils.org/pipermail/evergreen-catalogers/2012-June/000093.html
tweaking the asset.call_number_class table from stock values of…
select * from asset.call_number_class;
id | name | normalizer | field ----+--------------------------+--------------------------------+--------------------------------------------------------------------- 3 | Library of Congress (LC) | asset.label_normalizer_lc | 050ab,055ab,090abef
To what we have…
id | name | normalizer | field ----+--------------------------+--------------------------------+--------------------------------------------------------------------- 3 | Library of Congress (LC) | asset.label_normalizer_lc | 090abef,050ab,055ab
I used some SQL along the lines of (if I recall correctly)…
UPDATE asset.call_number_class SET field = ''090abef,050ab,055ab' WHERE normalizer = 'asset.label_normalizer_lc'
Though in your case you might want to use something like to put the 099 before the 090…
UPDATE asset.call_number_class SET field = ''099XYZ,090abef,050ab,055ab' WHERE normalizer = 'asset.label_normalizer_lc'
history/evergreen_for_academics/academic_customizations.txt · Last modified: 2022/02/10 13:34 by 127.0.0.1