Create a New Data Set

New Data Set

The first step in creating a new Data Set is to select the columns that will be included in the new Data Set. This is achieved by either reusing the column headings from an existing Data Set or creating one from the list of fields available in Specify.

If a Data Set exists with the same column headings, or mapping, needed for the new Data Set, simply drag the Data Set item onto the New Data Set action on the side bar. This eliminates the need to choose a Data Set from a file dialog.

Notes:

  • Data Sets have a limit of 4,000 records.
  • Data Sets that are open in the work space are disabled in the side bar. To copy the column headings from an existing Data Set it must first be closed.

To bypass the drag and drop feature, click the NewDataSet16x16 New Data Set button on the side bar. The following dialog will appear:

New Data Set

New Data Set

 

To copy a Data Set map from an existing Data Set select the Use an existing Data Set mapping button and choose the Data Set from the list provided. The Data Set Properties dialog will then open, to name and describe the new Data Set.

To choose column headings for the new Data Set, select the Create new Data Set mapping button and click 'OK'. The Data Set Mapping Editor will appear:

Data Set Mapping Editor

Data Set Mapping Editor

 

The Data Set Mapping Editor allows columns to be mapped, unmapped and reordered using the following buttons:

map Map Adds the field to the column list.
unmap Unmap Removes the field from the list of columns.
reorderup Reorder up Moves the selected field up.
reorderdown Reorder down Moves the selected field down.

 

The WorkBench provides a list of fields matching the Specify data model to use as column headings in the new Data Set. The list is organized by Data Types.

To add a column heading:

  1. Select a Data Type, the available fields will appear in the 'Specify Fields' window.
  2. Select a field
  3. Click the map (map) button

The new column heading will appear under both 'Specify Fields' and 'Data Set Columns' (as shown below).

A link icon, (linked_right), icon confirms that the Specify field is mapped to the Data Set column.

Note: A field may only map once. Specify fields that are mapped display a green check mark next to their name in the Specify field list confirming that they are in use.

Note: When importing Taxon information only use the Taxon Only Table in the mapping editor.

Note: The Agent table in the mapping editor may only be used for agent information. When uploading agent information along with collection object information use the Cataloger Title, First Name, Middle Name and Last Name fields in the Collection Object table.

 

DataSetMappingEditor2

Data Set Mapping Editor with one column added

 

Continue adding fields/columns until the 'Data Set Columns' list is complete, then click 'OK'.

Complete the new Data Set by naming and describing it:

Data Set Properties

Data Set Properties