Link to existing DOs in bulk import/update

Description

Feature

As an Archivist, I would like to be able to link AOs to existing digital objects (DOs) when using the bulk import or update spreadsheets.

Background

We create digital objects during the accession process. When processing a collection, we often want to link newly-created AOs to the existing DOs created during accessioning. So far this has been a many-to-one/few relationship (all of the new AOs are linked to 1-5 existing DOs).

Top containers already display the desired behavior. For example, when uploading a bulk-import spreadsheet, “the ingester will try to find an already-created Top Container in the database” before creating a new one (source). Until today, I had assumed that the same held true of DAOs, since both are instances of AOs.

Behavior scenarios

Scenario: As an Archivist, I want to be able to link to existing DOs when importing new AOs

Given that a DO already exists

When its identifier is entered in the digital_object_id column of the AO bulk import spreadsheet

Then upon the AO’s creation, it should be linked to the DO

But a new DO should not be created

Scenario: As an Archivist, I want to be able to link to existing DOs when updating AOs in bulk

Given that a DO already exists

When its identifier is entered in the digital_object/0/digital_object_id column of an AO bulk update spreadsheet

Then the corresponding AO should be linked to the DO

But a new DO should not be created

Complexity

None

Activity

Show:

Elizabeth PetersApril 1, 2025 at 5:24 PM

Discussed at DevPri meeting 4/1/25 and recommend passing. This functionality will need to make sure that existing DOs are linked via a unique ID, since otherwise the spreadsheet is used to create new DOs.

Details

Assignee

Reporter

Priority

Harvest Time Tracking

Open Harvest Time Tracking

Created August 22, 2024 at 6:09 PM
Updated 3 days ago
Harvest Time Tracking