Record Sets

record_sets_new Record Sets

Both Simple Search and Query may return groups of records. These returns can be named and saved as a Record Set, by clicking the record set(Record Set) button in the results bar.

The default permissions that Specify ships with allow Guest users to View the record sets, but not modify, add or delete them. All other users can use record sets in their entirety.

Creating a Record Set

Record Sets are created from the records in a results window of a Query or Simple Search. From within the results window:

  • Click a single record, then click the record set(Record Set) button to create a record set with a single record.
  • Command (for Mac) or Cntl (for PC) + click several records, then click the record set(Record Set) button to create a record set that includes the selected records.
  • Click the record set(Record Set) button without selecting any records, (or click the Select All button at the bottom of the results,) to create a record set from all the records.

Adding records to a Record Set

Drop a record set onto another record set to merge them. Any duplicate records will be automatically removed.

Records can be added to a record set by selecting them from a results window and clicking the record set (Record Set) button at the bottom of the results. The Choose a Record Set dialog will appear:

  • Select a record set name in the list and click the OK button to add the selected records to the existing record set.
  • Click the New button to create a new record set
  • Click Cancel to close the dialog.

Or, select the records to enable the record set (Record Set) button, then drag the button to an existing record set on the side bar to add the records to the existing record set. The existing record set and the new records must be from the same table to be compatible. As the button is dragged toward the side bar any existing record sets that can accept the new records will display a colored band.

New record sets can also be created by selecting one or multiple records within a record set and clicking the record set (Record Set) button from the results bar at the top of the results work space.

 

Using Record Sets

Record Sets can also be dragged and dropped on other side bar items. Slightly drag the record set within the side bar, and any form, Interaction or Plugin that can accept the record set, will display a colored outline. When the record set has been dragged to the correct spot over the side bar item a triangle will appear within the outline. Items that can accept a record set will vary depending on the record set type. For example:

  • In Data Entry the record set type must match the form type to open the records. For example, a Collecting Event record set dropped on the Collecting Event side bar button will open a Collecting Event form that includes all the records in the record set. The records can then be stepped through using the navigation control at the bottom of the form.
  • In Interactions a Collection Object record set can be dropped on a Loan, Gift or Information Request. This will activate a dialog for choosing Prep Types from the record set to include in the Loan, Gift or Information Request.
  • In Plugins a Locality record set can be dropped on GEOLocate to georeference the records, or on Google Earth to plot the records on a map.

Record Set Context Menu

Right-button-click on a record set to perform the following functions:

  • Rename activates a text field for the record set name in the side bar. Type the new name into the text field, then type the Return key to deactivate the text field.
  • Delete will delete the record set and remove it from the side bar.
  • View opens a new results window listing the records in the set. The record set view will not be a duplicate of the original search results window, but is meant to provide a list of the records in the record set. The results window status bar offers additional functionality.
whitespace
Button Function
record_sets_new_20 Create a new record set by selecting records and clicking the Record Set button.
data entry Open records in form view.
export Export the grid to MS Excel.
print Print the results Grid.

Records can also be selected within the window and added to another record set by clicking the record set (Record Set) button at the bottom of the results window and choosing a record set from the resulting dialog or dragging the record set(Record Set) button and dropping it on the desired record set in the side bar.

Export a Record Set

Specify users can export a record set through the WorkBench. The record set will export as an Excel spreadsheet. Exporting a Record Set is a three-step process:

  • Create a mapping for the Record Set/Data Set or identifying a mapping to reuse
  • Create a Data Set from a Record Set
  • Export the Data Set

The export is performed in the Specify WorkBench. To open the WorkBench click on the workbench (WorkBench) button.

Before a Record Set can be converted to a Data Set, a mapping must exist. If a Data Set already exists with the same fields required by the record set you may skip this step and go to Create a Data Set from Record Set. If a Data Set with a duplicate mapping does not exist, then a mapping must be created by creating a Data Set.

Create a Mapping/Data Set

  1. Click the NewDataSet16x16New Data Set button on the side bar.

A mapping 'maps' the tables and fields from the Specify schema to the columns they will occupy in the data set. A Help page for creating a mapping can be found in the New Data Set documentation.

Once the Data Set mapping has been created and saved as a Data Set, it will appear on the side bar.

 

Create a Data Set from a Record Set

  1. Click the newCreate Data Set from Record Set button
  2. Choose a record set from the dialog and click the OK button

The next dialog lists the available data sets.

  1. Choose the data set/mapping that you require.
  2. Click the OK button.

In the next dialog name the new Data Set.

Note: When the Data Set opens the validation for invalid fields will be turned on. If the data set contains catalog number they will be marked as invalid and highlighted in red because Specify recognizes them as duplicates. The validation can be turned off by unchecking the Highlight Invalid Cells checkbox in the validation panel at the bottom of the work space.

validation_screen

Validation Panel

Note: The mapping of a Data Set that was created from a record set may not be edited.

Export the Data Set

Now you may export the Data Set by clicking the ExportDataSet16x16 Export Data Set button. A Help page for exporting a Data Set can be found in the Export Data Set documentation.