Please enable JavaScript to view this site.

Vernon CMS Help

Navigation: Advanced Topics > User Symbolics

Complex User Symbolics

Scroll More

Complex User Symbolics use programs called subroutines. Below is a list of subroutines and practical examples of how you could use them. The most popular User Symbolics are at the top of the table, the less frequently used are at the bottom.

Please contact us on the customer support portal for advice when creating User Symbolics.

 

Symbolic Name

Vernon CMS field types

What does it do?

Example

EXPLODE

Hierarchical Authority fields.

"Explodes" a hierarchy. It allows you to separate your authority field hierarchy onto a new line. You can also choose which part of the hierarchy will be displayed.

Reporting on an object's location will display:

Shelf 1/Room 32/ Ground Floor/ Storage/Vernon Systems Museum

 

The Explode User Symbolic allows you to change the display to:

Shelf 1

Room 32

Ground Floor

Storage

Vernon Systems Museum

 

You can choose when the hierarchy should stop. For example, instead of the full hierarchy of Shelf 1 to Vernon Systems Museum, you could display just the terms two levels higher:

Shelf 1

Room 32

Ground Floor

 

HIERARCHY

Hierarchical Authority fields.

Displays a specific part of an authority term's hierarchy.

You may only want to display the country an object was made in, not the city or suburb. So instead of seeing:

Morningside/Auckland/New Zealand

You would just see:

New Zealand

 

SUBROUTINE > EXTRACT.AMV

Tables.

"Extracts" data from a specific row in a table.

You could take only the first row of data from a table.

 

Another example is to take only data with a certain authority field.

For example, you could report on the Other ID table and only see the rows with the Other ID Type "Old Accession Number".

 

SUBROUTINE > MULTI.FIELDS

All fields.

Joins fields together into a block of text.

This field is especially helpful when your collection is online. You could combine the fields Brief Description and Credit Line to make a web description.

 

SUBROUTINE > TWO.FIELDS

All fields.

Reports on one field, but if there is no information in that field it reports on a different field.

If your collection has social history and natural history collection items, you likely use different fields. You could report on Name/Title field (social history objects) and if there was no information in that field, this user symbolic will instead report on the classification field (natural history specimens).

 

SUBROUTINE > TRUNCATE

All fields.

Shortens or "truncates" your chosen field(s) to a certain number of characters.

 

You could restrict your Brief Description in reports to 100 characters.

SUBROUTINE > FIXED.LITERAL

No Vernon CMS fields.

Adds a phrase or statement.

You could create a default statement for your institution's credit line. This way all records would have the same information.

 

SUBROUTINE > PERSON.NAME

Person Name and Identifying fields.

Customises the display of the Person or Corporation name.

The person's title, firstname, lastname and life years could be displayed.

Miss Georgia Flowers 1942-2001

SUBROUTINE > PROD.PRI.PERSON.WORK

Primary Maker field and Object One Line Display.

Lists all of the other objects that has your object's artist as the primary maker. It will list the objects by the fields chosen in your one line display.

 

Your institution has 4 Pablo Picasso paintings.

If your report contained a Pablo Picasso painting, all the other works by Picasso in your collection will also be listed.

SUBROUTINE > COSTS

Tasks and Their Costs fields.

Displays the total cost for a certain task or cost type in general or within a task.

You could see the total amount that has been spent on Photography tasks, or on exhibition purchases.

 

SUBROUTINE > OB.ME

Measurement fields.

Displays a row of data with a specific measurement type, part number or both.

 

You could report only the dimensions of an object, ignoring other measurements like diameter or weight.

ACT > CURRENT.ACT

Management Activity field.

Finds and displays the current Activity for an Object record.

 

This symbolic can also display Activity files with specific information in them or with a General Flag.

 

Usually, when you report on exhibitions objects were in, it shows the entire exhibition history. This symbolic will show just the current exhibition.

ACT > LAST.ACT

Management Activity field.

Displays the last Activity for an Object record.

Last means the record with the closing date most recently passed.

 

You could see the last Outward Loan an Object had been on.

ACT > CURRENT.ACT.BY.STATUS

Management Activity field.

 

Finds and displays all activities with a certain Procedural Status.

 

You could see all completed Condition Reports.

ACT > OB.CURR.LOC

Location field for an Activity's object(s).

Displays the current location of all the objects linked to an Activity.

 

See all the current locations of your proposed objects while planning a new exhibition.

ACT > TOTAL.VALUES

Valuation fields.

Provides the total value of all the Object records linked to the Activity record.

 

You could add up the acquisition price for all of the objects.

ACT > EXH

Exhibition Concept and Related Exhibition Venue.

Displays all the Exhibition Concepts linked to an Object's or Activity's Related Exhibition Venue.

A painting has 12 Related Exhibition Venues. However, the object has only been displayed in 2 Exhibition Concepts. This symbolic provides a list of all the Venues and the associated Exhibition Concept. For example,

the painting's Related Exhibition Venues 1-10 were part of the "Vernon Systems unveiled" exhibition, and the other 2 Related Exhibition Venues were part of the "portraiture" exhibition.

 

SUBSET

Hierarchical Authority fields.

Extract only the narrower terms of a specific term.

You may have multiple classification systems (taxonomic or nomenclature). This symbolic will let you show just the taxonomic classification, or just the nomenclature classification. You can then display this on your website as two different fields.

 

EVALVB

All fields.

Evaluates Visual Basic Script (VBScript) expressions. If no other symbolic fits your needs, this symbolic will.

 

You can learn more about Visual Basic Script on the Microsoft Developer Network (MSDN).

Here are just a few examples of what you could achieve:

- Create conditions, e.g. if there is a next higher term it will be displayed in brackets, if not, nothing will be displayed.

- Use Javascript to create expressions

- Join multiple fields together with a carriage return between each section of data

- Perform calculations based on dates or numeric fields.

 

DURATION

Location fields.

Calculates how long an object has been in a particular location or had a particular location reason or had either option within a set time frame.

You could calculate the time that an object has been on display by using this symbolic. You use the duration symbolic on just the exhibition Location Reasons, e.g. Temporary Exhibition, Permanent Exhibition.