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

[MODSOURMAN-977] Create a standalone script to update mandatory mapping-rules change Created: 13/Apr/23  Updated: 28/Apr/23  Resolved: 24/Apr/23

Status: Closed
Project: mod-source-record-manager
Components: None
Affects versions: None
Fix versions: None
Parent: Batch Importer (Bib/Acq)

Type: Story Priority: P2
Reporter: Pavlo Smahin Assignee: Roman Chernetskyi (Inactive)
Resolution: Done Votes: 0
Labels: back-end, data-import, epam-folijet, folidemo162-163, inventory
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Defines
defines UXPROD-3840 NFR: Data Import and Inventory Techni... In Review
Relates
relates to MODSOURMAN-837 MARC bib - FOLIO instance mapping | U... Closed
relates to MODSOURMAN-924 Extend bib mapping-rules according to... Closed
Sprint: Folijet Sprint 163
Story Points: 8
Development Team: Folijet
Release: Poppy (R2 2023)
Epic Link: Batch Importer (Bib/Acq)

 Description   

Purpose
As in previous releases, in Orchid some mandatory changes were introduced to default mapping rules. As there is no mechanism exists to update mapping rules automatically during module upgrade, and it's required to have these changes done to all tenants, it was decided to create a Java-based standalone application to handle it.
Changes described on pages:
https://folio-org.atlassian.net/wiki/display/FOLIJET/MARC+Bib-to-Instance+Default+map+changes+to+support+Authority+control+feature
https://folio-org.atlassian.net/wiki/display/FOLIJET/Update+of+mapping+to+change+how+Relator+term+is+populated+on+instance+record+R1+2023+Orchid+release

Approach
1. To have app input:

  • okapi-url
  • tenantId
  • username and password of a user that has permissions to retrieve and update mapping-rules

2. An order of processing:

  1. Call GET /mapping-rules/marc-bib and get the current mapping rules
  2. Do changes for contributor mappings (do this only for fields that are described in the document) that described in https://folio-org.atlassian.net/wiki/display/FOLIJET/Update+of+mapping+to+change+how+Relator+term+is+populated+on+instance+record+R1+2023+Orchid+release
  3. Do changes for all alternativeTitles, contributors, series, and subjects mapping that exists in the mapping rules (could be detected by `target` field)
    MARC Bib-to-Instance Default map changes to support Authority control feature - Folio Development Teams - FOLIO Wiki
  4. Call PUT /mapping-rules/marc-bib with updated mapping rules

3. Test that results of updates are expected (ask to check results of both Spitfire and Folijet teams)

The repository: https://github.com/Shans-Kaluhin/folio-update-authorities could be used as a starting point: the authentification part could be reused.



 Comments   
Comment by Khalilah Gambrell [ 13/Apr/23 ]

Hey Pavlo Smahin  - how does this issue relate to https://folio-org.atlassian.net/browse/UXPROD-4082

Comment by Pavlo Smahin [ 13/Apr/23 ]

Khalilah Gambrell no relation

Comment by Ann-Marie Breaux (Inactive) [ 14/Apr/23 ]

Kateryna Senchenko and Pavlo Smahin Just to be clear on the scope of this story

  1. This covers mandatory changes to default MARC Bib-to-Instance map?
  2. Does it cover optional changes (library may or may not want the change)?
  3. Does it cover changes to the default MARC Holdings-to-Inventory holdings map?
  4. Does it cover changes to the default MARC Authority-to-Inventory authority map?
  5. It does not cover updates to all existing Inventory records after the map has been changed. That is UXPROD-4082 In Progress for authorities and UXPROD-3969 Open for instances. Is that correct?
Comment by Ann-Marie Breaux (Inactive) [ 14/Apr/23 ]

Kateryna Senchenko and Pavlo Smahin and Khalilah Gambrell Since this will be a standalone app, do we need to submit it to get clearance for inclusion in Poppy?

And should this be considered a patch release for Orchid?

Comment by Pavlo Smahin [ 14/Apr/23 ]

Ann-Marie Breaux it covers only 1st from your list. The release is not required because it will not be included in Poppy. It just a tool to help with upgrade.

Comment by Roman Chernetskyi (Inactive) [ 18/Apr/23 ]

Hi Ann-Marie Breaux I created a confluence page with script instructions CC: Pavlo Smahin Kateryna Senchenko 

Comment by Pavlo Smahin [ 19/Apr/23 ]

Verified by Spitfire. Everything works as expected.

Comment by Roman Chernetskyi (Inactive) [ 19/Apr/23 ]

Hi Sobha Duvvuri this script is ready to use

Comment by Ann-Marie Breaux (Inactive) [ 21/Apr/23 ]

Hi Sobha Duvvuri Are you OK with us closing this story?

Roman Chernetskyi Thank you for all the work and for updating the documentation

Comment by Ann-Marie Breaux (Inactive) [ 21/Apr/23 ]

Updated wiki pages:

Comment by Ann-Marie Breaux (Inactive) [ 24/Apr/23 ]

Closing this issue. Thank you for all the work, Roman Chernetskyi

Generated at Thu Feb 08 23:30:27 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.