====== 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'