Feature #13262

CSV import for accession alternative identifiers

Added by Mike Cantelon 8 months ago. Updated 4 months ago.

Status:VerifiedStart date:02/18/2020
Priority:HighDue date:
Assignee:-% Done:

100%

Category:Accessions
Target version:Release 2.6.0
Google Code Legacy ID: Tested version:
Sponsored:Yes Requires documentation:

Description

This feature enhancement will extend the functionality added in feature #13254. There, we have added support for additional identifier types and values, in line with the new Canadian Archival Accession Information Standard (CAAIS) recommendations, found in element 1.2

This enhancement further extends #13254 by adding CSV import support for the three new fields - an identifier type (linked to a new taxonomy), the identifier value, and an identifier note field.

In the updated CSV, these new fields will use the following column headers:

  • alternativeIdentifiers
  • alternativeIdentifierTypes
  • alternativeIdentifierNotes

These fields are repeatable in the AtoM user interface. Correspondingly, values in these columns can be | pipe separated to include multiple values on import.


Related issues

Related to Access to Memory (AtoM) - Feature #13254: Add the ability to add multiple identifiers to accessions... Verified 02/06/2020
Related to Access to Memory (AtoM) - Feature #13265: Search support for accession alternative identifiers Verified 02/22/2020
Related to Access to Memory (AtoM) - Feature #13268: Add ability to associate accessions with physical storage Verified 02/26/2020

History

#1 Updated by Mike Cantelon 8 months ago

  • Related to Feature #13254: Add the ability to add multiple identifiers to accessions, with type and note values added

#2 Updated by Mike Cantelon 8 months ago

  • Subject changed from CSV import/export for accession alternative identifiers to CSV import for accession alternative identifiers

#3 Updated by Dan Gillean 8 months ago

  • Description updated (diff)
  • Target version set to Release 2.6.0
  • Sponsored changed from No to Yes

#4 Updated by Mike Cantelon 8 months ago

  • Assignee deleted (Mike Cantelon)

#5 Updated by Mike Cantelon 8 months ago

  • Status changed from New to Code Review

#6 Updated by Mike Cantelon 8 months ago

  • Status changed from Code Review to In progress

Re-opening PR... found minor issue.

#7 Updated by Mike Cantelon 8 months ago

  • Status changed from In progress to Code Review

#8 Updated by Dan Gillean 8 months ago

  • Related to Feature #13265: Search support for accession alternative identifiers added

#9 Updated by Mike Cantelon 8 months ago

  • Status changed from Code Review to QA/Review

#10 Updated by Mike Cantelon 8 months ago

Merged into qa/2.6.x. I've updated the example accessions with two uses of alternative identifiers.

#11 Updated by Dan Gillean 8 months ago

  • Related to Feature #13268: Add ability to associate accessions with physical storage added

#12 Updated by Steve Breker 6 months ago

Issue: checking if alt id type terms already exist in the database before creating them is not working correctly. Subsequent CSV loads will duplicate the terms.

#13 Updated by Steve Breker 6 months ago

PR: https://github.com/artefactual/atom/pull/1083
...approved by DJ.

Ready for QA.

Bug:
CSV accession import CLI task does not know which alt id type terms already exist in the database, so on import it will create any alt id type terms that occur in the import file that it thinks are new.

To Replicate:
Load the example accessions CSV noting which alt id type terms are created.
Load the CSV again
Check the alt id types in "manage taxonomies" and you will see the duplicated alt id types.

Corrected behaviour:
alt id type terms will not be duplicated when further CSVs using these terms are loaded.

#14 Updated by Dan Gillean 4 months ago

  • Status changed from QA/Review to Verified

#15 Updated by Dan Gillean 4 months ago

  • % Done changed from 0 to 100
  • Requires documentation deleted (Yes)

Also available in: Atom PDF