Create script for fixing invalid SRS instanceIDs

Description

While resolving these issues: MODSOURCE-461, MODSOURCE-480 - it seems like there are a lot of records without "instanceId"-the field in DB. Because they were imported in an unexpected way. That`s why there should be added a script which should retrieve from 999ff$i value and set it to the "instanceId"-field to DB.

Process to find invalid instances and then set the fields properly if there is a 999 ff $i, retrieve the UUID, and add to the specific column in the records_lb table. If that column is empty, user cannot View source or Edit in quickMARC

Decide if API or just a script. If an API, then add a story for a separate permission, and user can run this script on demand (not from the UI). Then A-M would need to add to the permissions spreadsheet

KS: Clarify the last point about the dedicated API for running migration script. Would it be enough to create a script and make a release note that it has to be run manually against the db after module is deployed? In order not to slow down the deployment. A-M: Yes, I think it's enough to have a script, not an endpoint

Environment

None

Potential Workaround

None

CSP Request Details

None

CSP Approved

None

CSP Rejection Details

None

Attachments

2
  • 11 Mar 2022, 08:33 AM
  • 11 Mar 2022, 08:33 AM

Checklist

hide

TestRail: Results

Activity

Show:

Ann-Marie BreauxMarch 21, 2022 at 10:00 AM

Hi and How can we test and prove this script works? We need to get some records into a problematic state where the instanceID field is blank, and then show that the script fixes them. Is that something we could show from a Folijet environment perhaps? I think it might be good to create a small video showing it, if possible. Let's discuss in the next few days. Thank you!

Ruslan LavrovMarch 15, 2022 at 8:18 PM

Hi , updated script details. Thank you!

Carole GodfreyMarch 15, 2022 at 5:10 PM

- assuming its tested I would suggest a test environment such as bugfest – this is now managed by kitfox team

Ann-Marie BreauxMarch 15, 2022 at 9:39 AM

Hi Any recommendations on how to test this script?

And and It would be good to have a wiki page that describes this script:

  • what the script does

  • earliest version of FOLIO it can be used with

  • can be run on demand

  • anything else you can think of?

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Folijet

Release

Lotus R1 2022

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created May 20, 2021 at 11:45 AM
Updated April 4, 2023 at 8:27 PM
Resolved March 21, 2022 at 10:01 AM
TestRail: Cases
TestRail: Runs

Flag notifications