====== 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;
<code>
 id |           name           |           normalizer           |                                field                               
----+--------------------------+--------------------------------+---------------------------------------------------------------------
  3 | Library of Congress (LC) | asset.label_normalizer_lc      | 050ab,055ab,090abef
</code>

To what we have...
<code>
 id |           name           |           normalizer           |                                field                               
----+--------------------------+--------------------------------+---------------------------------------------------------------------
  3 | Library of Congress (LC) | asset.label_normalizer_lc      | 090abef,050ab,055ab
</code>

I used some SQL along the lines of (if I recall correctly)...

<code>
UPDATE asset.call_number_class SET field = ''090abef,050ab,055ab'
WHERE normalizer = 'asset.label_normalizer_lc'
</code>

Though in your case you might want to use something like to put the
099 before the 090...

<code>
UPDATE asset.call_number_class SET field = ''099XYZ,090abef,050ab,055ab'
WHERE normalizer = 'asset.label_normalizer_lc'
</code>