collectionspace/application — pull request #49 by rjaffe (2012-08-31 20:35:28+00:00)
Title: CSPACE-4786, CSPACE-5512: Changing default values for 14 term lists to urn format

Recent changes to app-layer master merged in, app tests pass. Please commit this.

For release notes (to be added as a comment to JIRA, as well):

NOTE that for existing deployments, this change will cause new records to save different values for default terms than existing records hold. Rather than "eng" the full urn "urn:cspace:core.collectionspace.org:vocabularies:name(languages):item:name(eng)'English'" will be stored for six fields. Rather than "usd", "urn:cspace:core.collectionspace.org:vocabularies:name(currency):item:name(USD)'US Dollar'" will be stored for seven fields. (In the course of fixing this bug, I discovered that one field had been configured twice in base-procedure-acquisition.xml; see CSPACE-5513.)

Administrators of existing deployments should update the values stored in these 13 fields, following this SQL query sample:

nuxeo=# update titletranslationsubgroup set
titletranslationlanguage='urn:cspace:core.collectionspace.org:vocabularies:name(languages):item:name(eng)''English'''
where titletranslationlanguage='eng';

A full list of affected fields and the tables/columns in which their values are stored is available.