Order import: fix product identifier problem with 028 field

Description

Overview:
1. If an order field mapping profile has a mapping for Product identifier that includes multiple MARC subfields, the resulting value in the POL needs to include all those subfields.
2. If an order fields mapping profile has a mapping for Product identifier, but that field does not exist in the incoming MARC record, then the Product identifier and the Product identifier type in the resulting POL should be blank (i.e. should not be created)

Current workaround: None, except users can manually edit the Product identifier data after POL creation

Steps to Reproduce:

  1. Log into FOLIO-snapshot-load as diku_admin

  2. Go to Settings/Data import/Field mapping profiles

  3. Create and save the following field mapping profile

    • Name: Test multiple MARC subfield mappings

    • Incoming record type: MARC Bibliographic

    • FOLIO record type: Order

    • Purchase order status: "Pending"

    • Vendor: look up and assign GOBI

    • Title: 245$a " " 245$b " " 245$h

    • Contributors

      • Click the Add contributor button

      • Contributor: 100$a " " 100$c " " 100$q " " 100$d

      • Contributor type: Select "Personal name" from the dropdown list

    • Product identifiers

      • Click the Add product identifier button

      • Product ID: 028$a " " 028$b

      • Qualifier: [blank]

      • Product ID type: select "Publisher or distributor number" from the dropdown list

    • Acquisition method: Select any value from the dropdown list

    • Order format: Select "Physical resource" from the dropdown list

    • Receiving workflow: Select "Synchronized" from the dropdown list

    • Physical unit price: "1"

    • Quantity physical: "1"

    • Currency: Select "USD" from the dropdown list

    • Physical resource details/Create inventory: Select "None" from the dropdown list

  4. Create an Action profile for creating orders and link to the above field mapping profile

  5. Create a Job profile for creating orders and link to the above Action profile

  6. Import the attached file Order multiple subfields.mrc

  7. Click on the completed file name to view the log

  8. Click on each "Created" link to view each POL

  9. Check the Product identifier section of each POL

Expected Results:
1. If multiple subfields are mapped into the Product ID field, they should all display, with any default value in between, e.g. with a mapping of 028$a " " 028$b and a value of 028$a12345$btest, the POL's Product identifier should be 12345 test
2. If there is a MARC mapping for Product ID in the field mapping profile, but that MARC field/subfield does not exist in the incoming MARC record, neither the Product ID nor the Product ID type should be populated in the POL

Actual Results:
1. Sometimes 028$a and $b both populate into the same Product ID field (see record 3 - The dream of Jubal), sometimes they populate in different Product ID fields (see record 2 - The best of Ella), and sometimes the $b doesn't populate at all (see record 1 - Ella & Basie)
2. If there is no 028 field in the incoming MARC record, a Product ID field is created with a blank value and Product ID type of Publisher or distributor number (see records 4 - Colour-music and 5 - Henry and Emma)

Additional Information: See attached video and sample MARC file

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

2
  • 15 Feb 2023, 06:12 AM
  • 15 Feb 2023, 06:12 AM

defines

has to be done before

relates to

Checklist

hide

TestRail: Results

Activity

Show:

Ann-Marie BreauxMarch 28, 2023 at 5:08 AM

Oleksii PetrenkoMarch 24, 2023 at 3:06 PM

Deployed to Orchid bf env. Please proceed with verification

Ann-Marie BreauxMarch 13, 2023 at 7:28 PM

Hi Tested on Snapshot, and all looks good - thank you! Moving to Awaiting release

Mariia AloshynaFebruary 15, 2023 at 2:32 PM

Hi this one looks like BE to me, could you take a look, please?

Ann-Marie BreauxFebruary 15, 2023 at 6:50 AM

Hi I created 3 bugs that relate to the Product Identifier field of the POL. I'm not sure if they are UI or BE, and I think they may be inter-related. Please review them when you get a chance. Details for each field mapping profile and sample files attached to all 3. (https://folio-org.atlassian.net/browse/UIDATIMP-1377#icft=UIDATIMP-1377, https://folio-org.atlassian.net/browse/UIDATIMP-1378#icft=UIDATIMP-1378, https://folio-org.atlassian.net/browse/UIDATIMP-1379#icft=UIDATIMP-1379) Also, all 3 have job profiles in Snapshot right now, if you want to play with any of them. Thank you!

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Folijet

Fix versions

Release

Orchid (R1 2023) Bug Fix

RCA Group

Lack of testing

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created February 15, 2023 at 5:37 AM
Updated March 28, 2023 at 5:08 AM
Resolved March 13, 2023 at 7:28 PM
TestRail: Cases
TestRail: Runs

Flag notifications