Batch Importer (Bib/Acq) (UXPROD-47)

[UXPROD-3729] Planning for Import of MARC Bibs to create/update multiple holdings and items Created: 27/Jun/22  Updated: 30/Nov/23  Resolved: 21/Mar/23

Status: Closed
Project: UX Product
Components: None
Affects versions: None
Fix versions: Orchid (R1 2023)
Parent: Batch Importer (Bib/Acq)

Type: New Feature Priority: P2
Reporter: Ann-Marie Breaux (Inactive) Assignee: Ann-Marie Breaux (Inactive)
Resolution: Done Votes: 0
Labels: acq-dataimp, cap-mvp-split, cataloging, consortia-ebsco, data-import, epam-folijet, job-profiles, marc-bib, marc-holdings, marcimport, match-profiles, metadatamanagement, po-mvp, quickmarc
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Defines
defines UXPROD-47 Batch Importer (Bib/Acq) Analysis Complete
is defined by MODDATAIMP-729 SPIKE: Create design for importing mu... Closed
is defined by MODDATAIMP-763 Finish design for importing Multiple ... Closed
Requires
is required by UXPROD-2741 Import of MARC Bibs to create/update ... Closed
is required by UXPROD-4079 DI Log updates for multiple holdings/... Closed
Release: Orchid (R1 2023)
Epic Link: Batch Importer (Bib/Acq)
Analysis Estimate: Large < 10 days
Analysis Estimator: Ann-Marie Breaux (Inactive)
Front End Estimate: Small < 3 days
Front End Estimator: Mariia Aloshyna
Front-End Confidence factor: 80%
Back End Estimate: Medium < 5 days
Back End Estimator: Kateryna Senchenko
Back-End Confidence factor: 80%
Development Team: Folijet
Kiwi Planning Points (DO NOT CHANGE): 40
PO Rank: 120
Rank: Chalmers (Impl Aut 2019): R5
Rank: Chicago (MVP Sum 2020): R1
Rank: Cornell (Full Sum 2021): R2
Rank: Duke (Full Sum 2021): R1
Rank: 5Colleges (Full Jul 2021): R2
Rank: FLO (MVP Sum 2020): R1
Rank: GBV (MVP Sum 2020): R4
Rank: Lehigh (MVP Summer 2020): R1
Rank: MO State (MVP June 2020): R2
Rank: TAMU (MVP Jan 2021): R2
Rank: U of AL (MVP Oct 2020): R2

 Description   

This feature does not have any development work; it is ALL planning

Planning and story-writing during Orchid so that work can be done in UXPROD-2741 Closed Poppy

This feature allows for multiple holdings and/or items to be created or edited based on data supplied in a single MARC record

Purpose: To update multiple holdings and items on the same instance, from the same imported MARC record

Important for

  • 5 Colleges Consortium
  • Spokane Public
  • Chicago
  • MARMOT Consortium

As a staff person working with data import
I want to update multiple holdings and their associated items when importing a single MARC record
So that I can use all of the holdings/items data on the MARC record properly

Scenarios

  1. Scenario 1
    • Given a MARC record with multiple holdings and item data in it
    • When importing to update holdings and items
    • Then update all relevant holdings on the same instance and update all relevant items on the appropriate holdings
    • Include any holdings and items data in the same MARC field, different subfields
    • If multiple item records are to be updated on the same holdings, repeat the holdings data in repeated MARC fields, with each item's data in a separate MARC field. Item data/subfields for multiple item records cannot be included in the same MARC field
    • See example MARC record below
  2. Scenario 2
    • Ensure this story passes Accessibility testing
  3. Scenario 3
    • Ensure automated testing coverage for this new code is 80% plus and confirm with screenshot

See attached MARC file; test load to update instance, holdings, and item to ensure the logic is working correctly.

Matching notes:

  • Match for holdings could be based on
    • Holdings HRID/UUID
    • Instance HRID/UUID plus secondary match on Holdings HRID/UUID or Location code
  • Match for item could be based on
    • Item HRID, UUID, or barcode
    • Holdings HRID/UUID plus secondary match on Item copy number

Sample record with multiple holdings/item data:

=LDR 01262nam a2200301Ia 4500
=001 ocm54341618\
=003 OCoLC
=005 20070103101904.0
=008 010330s1798\\\\enkaf\\\\\\\\\000\0\eng\d
=035
$a(Sirsi) a551407
=035
$a(Sirsi) o54341618
=049
$aDRUM
=040
$aCUD$beng$cCUD$dDRU$dMvI
=090
$aBS2095$b.S33 1798
=130 0\$aBible.$pNew Testament$lEnglish.$sScarlett.$f1798.
=245 12$aA translation of the New Testament from the original Greek /$chumbly attempted by Nathaniel Scarlett, assisted by men of piety & literature ; with notes.
=260
$aLondon :$bPrinted by T. Gillet; and sold by Nathaniel Scarlett, No. 349, near Exeter 'Change, Strand; also F. & C. Rivington, St. Paul's Church Yard,$c1798.
=300
$axi, 483, vi p., [1] folded leaf of plates :$bill. ;$c19 cm.
=500
$aEngraved t.p.
=500
$aIncludes Observations on some terms used in this translation: vi p. at end.
=510 3\$aDarlow-Moule-Herbert 1433
=700 1\$aScarlett, Nathaniel,$d1753-1802.
=740 02$aObservations on some terms used in this translation.
=945
$a34678234678246423786427$b1$hKU/CC/DI/M <===== $a = item barcode, $b = copy number, $h = holdings permanent location
=945
$a34678234678246423786428$b2$hKU/CC/DI/M
=945
$a34678234678246423786429$b1$hKU/CC/DI/A

If this record were updating holdings and items, it would do so as follows:

  • Update 1 instance, with the data in the main part of the MARC bib record
  • Update 2 holdings, 1 for permanent location KU/CC.DI/M and 1 for permanent location KU/CC/DI/A, using holdings mapping data from 945$h and the defaults in the holdings mapping profile
  • Update 3 item records, 2 linked to the holdings for KU/CC/DI/M and 1 linked to the holdings for KU/CC/DI/A, using item mapping data from 945$a, 945$b, and the defaults in the item mapping profile

NOTE: These 9xx fields and subfields are just examples. Real fields/subfields would be mapped in the field mapping profile. The key is that related holdings and item data must be in the same field, different subfields, and that item data for different items must be in separate MARC fields, not concatenated in the same MARC field.

Steps:

  • MappingManager should return JSON value - backend
  • extend mapping profile schema with param "entityPerValue" (for items and holdings) backend/UI
  • add a possibility to link item and holding in mapping profile for item (holding location: 945$h) backend/UI
  • Change Mapper interface to read "entityPerValue" fields call reader for n times per entity - backend
  • update all handlers for support list of holdings and items in the context


 Comments   
Comment by Charlotte Whitt [ 12/Sep/22 ]

Ann-Marie Breaux - do you know if this work will be accomplished for Nolana?
CC: Robert Roose Jacquie Samples

Comment by Ann-Marie Breaux (Inactive) [ 12/Sep/22 ]

Hi Charlotte Whitt For Nolana, the goal is planning, not actually accomplishing the development work. Then we're aiming to do the development in Orchid. So far, that should be on schedule. I haven't started conversations with the SMEs about it yet.

Generated at Fri Feb 09 00:34:21 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.