Field Details for the Spreadsheet Ingest
Last Updated, July 3, 2023.
| Field Name | Required Field | Validated Field | Delimiters Allowed | Subdelimiters Allowed | Field Details |
|---|---|---|---|---|---|
| ID* | Yes | Yes | NA | NA | Always start with one and number consecutively to the last row of the spreadsheet which includes metadata for ingest. |
| member_of | No | NA | NA | Refers to number in the ID column. Used to identify parent repository item for a new repository item when its parent is being ingested at the same time. | |
| member_of_existing_entity_id | No | NA | NA | Use the Drupal NODE ID of the parent repository item when ingesting additional repository items to a repository item that is already in the system Use EITHER colums A & B OR Columns B & C but NEVER ALL THREE. | |
| publish* | Yes | Yes | NA | NA | Defaults to 'Y'. Value must be either 'Y' or 'N' to set the object as published (Y) or not published (N) on ingest. |
| model* | Yes | Yes | NA | NA |
This is the "Content Type" that defines the behaviors, derivatives, and viewers of the repository item. Accepted values include: Audio |
| held_by* | Yes | Yes | NA | NA | This is the name of the owning organization for this object. The name of the organization must be in the system for this to field to be valid. Can verify the name using the Add Content form which includes a drop down menu for this field. |
| title* | Yes | Yes | ^^ | | |
keys: |
| Syntax for spreadsheet is: title|type|title_non_sort|title_part_name|title_part_number|supplied Example: My title|alternative||this is a non sort title|this is a subtitle|this is a title part name|this is a title part number|yes |
|||||
| rights_statement* | Yes | Yes | NA | NA |
Values in this column must one of the following based on rightsstatement.org. If you are created a collection utilize RIGHTS DETERMINED AT ITEM LEVEL. COPYRIGHT NOT EVALUATED |
| digital_file | No | No | NA | NA | Path to the file to be ingested. Reqiuired for: Audio, Binary, Image, Page, and Video models. |
| media_use | No | Yes | NA | NA |
Indicates the use of the media in the system. Reqiuired for: Audio, Binary, Image, Page, and Video models.Original File is the option most frequently used as it enables derivatives to be generated upon ingest. Options include: Extracted Text |
| digital_origin | No | Yes | NA | NA |
Valid values include: None |
| use_and_reproduction | No | No | NA | NA | Text description of the use and reproduction for the object. |
| creative_commons | No | Yes | NA | NA |
Must be one of the following terms for Creative Commons licenses:
|
| resource_type | No | Yes | NA | NA |
The following values are valid for this field: Collection |
| description | No | No | NA | NA | A narrative description of the item. NO HTML code can be included in the description. |
| local_identifier | No | No | ^^ | NA | Any identification that is unique to the organization and/or object that helps to manage the item. |
| Example: 425objectIdentifier789^^MyObjectInventoryNumber2347891 | |||||
| persons | No | No | ^^ | | | keys: - name - role An agent, e.g. person or organization, with a specific relationship to the item being catalogued. The 'name' is a new or existing name in the 'Persons' taxonomy^^ the 'role' must be on of the available relations listed in the drupal field configuration for field_linked_agent. The list of options is extensive so check the Add Repository |
| organizations | No | No | ^^ | | | keys: - name - role An agent, e.g. person or organization, with a specific relationship to the item being catalogued. The 'name' is a new or existing name in the 'Persons' taxonomy^^ the 'role' must be on of the available relations listed in the drupal field configuration for field_linked_agent. The list of available values for roles is too long to sanely list in this documentation, so it's best to just look that up in the field configuration of the site being used. |
| language | No | No | ^^ | NA | Term(s) in the 'Language' taxonomy. (Can be existing or new terms) |
| genre | No | No | ^^ | NA | Term(s) in the 'Genre' taxonomy (Can be existing or new terms) |
| subject | No | No | ^^ | | | Term(s) in the 'Subject' taxonomy. (Can be existing or new terms) |
| temporal_subject | No | No | ^^ | NA | Term(s) in the 'Temporal' taxonomy. (Can be existing or new terms) |
| geographic_subject | No | No | ^^ | NA | Term(s) in the 'Geographic' taxonomy. (Can be existing or new terms) |
| coordinates | No | No | ^^ | | | Enter either in decimal (51.47879) or sexagesimal format (51° 28' 43.644"). For subdelimited pieces use the following mapping: latitude|longitude |
| origin_information | No | No | ^^ | | | The sequence of subfields is as follows (use a pipe | with no spaces to populate the subfields correctly: event_type|place|date_created|date_issued|date_captured|date_valid| date_modified|other_date|copyright_date|publisher|edition|issuance|frequency All 'date' fields must be EDTF. Valid values for 'issuance' are: monographic single unit multipart monograph continuing serial integrating resource |
| extent | No | No | ^^ | NA | Size or duration of a resource |
| notes | No | ^^ | | | keys: - note_type - note Valid values for note_type: acquisition action additional physical form bibliography biographical/historical creation/production credits date/sequential designation exhibitions funding language numbering original location ownership performers preferred citation provenance publications reproduction statement of responsibility system details thesis venue version identification |
|
| family_name | No | A new or existing family name | |||