Field Details for the Spreadsheet Ingest

Last Updated, April 27, 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
Binary
Collection
Compound
Digital Document
Image
Newspaper
Page
Paged Content
Publication Issue
Video
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:
- title
- type
Available values for title types:
alternative
translated
uniform
abbreviated

Supplied values:
yes
no

  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
COPYRIGHT UNDETERMINED
IN COPYRIGHT
IN COPYRIGHT - EU ORPHANED WORK
IN COPYRIGHT - RIGHTS-HOLDER(S) UNLOCATABLE OR UNIDENTIFIABLE
NO COPYRIGHT - CONTRACTUAL RESTRICTIONS
NO COPYRIGHT - OTHER KNOWN LEGAL RESTRICTIONS
NO COPYRIGHT - UNITED STATES
NO KNOWN COPYRIGHT
RIGHTS DETERMINED AT ITEM LEVEL

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
Intermediate File
Original File
Preservation Master File
Service File
Thumbnail Image
Transcript
digital_origin No Yes NA NA

Valid values include:

None
born digital
reformatted digital
digitized microfilm
digitized other analog
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:

Attribution 4.0 International (CC BY 4.0)
Attribution-NoDerivatives 4.0 International (CC BY-ND 4.0)
Attribution-NonCommercial 4.0 International (CC BY-NC 4.0)
Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0)
Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0)
Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

resource_type No Yes NA NA

The following values are valid for this field:

Collection
Dataset
Image
Interactive Resource
Moving Image
Physical Object
Service
Software
Sound
Still Image
Text
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 ^^ | keys: - 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