Mapping to Drop Down Values in CollectiveAccess

There are several instances when creating an import mapping spreadsheet where a value in the source data will be mapped to a drop-down list in CollectiveAccess. These fields look like:

../../../_images/acq_field.png

An example of an Acqusition Mode field in CollectiveAccess that contains a drop-down menu of associated, set values.

../../../_images/condition_field.png

An example of a Condition Container in CollectiveAccess that contains a drop-down menu of associated, set values for Condition Status.

While the drop-down lists, when selected, are displayed:

../../../_images/demo_cond_list.png

Values in the Condition drop-down list.

providence/user/import/acq_mode.png

Values in the Acquisition Mode drop-down list.

Not all CollectiveAccess systems will have metadata fields that contain drop down values (these can be configured in the Installation Profile). Examples of fields that may have drop-down lists available include condition, acquisition mode, and other fields that have a set list of values to choose from.

Drop-down value lists will have a set number of options to choose from that may describe condition or other variable descriptors about an object or item. These options will be listed in Lists and Vocabularies.

The field containing the drop-down values will have its own CA table.element code, that will be mapped in Column 3 of the import mapping spreadsheet (see Creating an Import Mapping: Overview).

If all values are the same for the field, set the Rule Type in Column 1 to Constant, and place the value from the drop-down in Column 2 of the import mapping spreadsheet:

../../../_images/constant_dropdown.png

The Condition Drop-Down List

Condition is a common example of a field that contains a drop-down list, with multiple, set descriptors. These values are pre-determined in the system itself and will vary depending on system configuration.

Source Data containing condition values might look like:

../../../_images/condition_mapp_ex.png

To find the appropriate CA table.element code for the Condition field in CollectiveAccess, follow the steps outlined in Creating an Import Mapping: Overview) and see Using Bundle Codes.

Mapping for the condition column would look like:

../../../_images/mapping_condition.png

Where the source column is 3, and the CA table.element is ca_objects.condition_description.condition_value taken from the bundle code for the Condition Status field.

A separate mapping for each value in the drop-down list is not required, nor is using a Constant value. If the values match those listed in CollectiveAccess, mapping to the correct CA table.element will automatically populate the drop-down list with the appropriate values.

As noted above, the field for Condition in CollectiveAccess is formatted as a Container, meaning that each element within the Container has a distinct bundle code for which to map source data (see below). For more about Containers, see Containers.

../../../_images/condition_field.png

The Condition field from the CollectiveAccess Demonstration system.

In the mapping, the bundle code for the Condition Status is used, which contains the drop-down list.