Order import: fix product identifier mapping problem with multiple product ID TYPES

Description

Overview: If an order fields mapping profile has a mapping for the Product identifier of ISBN (which would normally be 020$a), 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

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 Product ID types: ISBN first

    • Incoming record type: MARC Bibliographic

    • FOLIO record type: Order

    • Purchase order status: "Pending"

    • Vendor: look up and assign GOBI

    • Title: 245$a

    • Contributors

      • Click the Add contributor button

      • Contributor: 100$a

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

    • Product identifiers

      • Click the Add product identifier button

      • Product ID: 020$a

      • Qualifier: 020$q

      • Product ID type: select "ISBN" from the dropdown list

    • Then click the Add product identifier button again

      • Product ID: 028$a

      • Qualifier: [leave 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. Duplicate the above field mapping profile and make the following changes:

    • Name: Test multiple Product ID types: Pub Num first

    • Product identifiers

    • Delete the row for the ISBN product identifier (so that only the Publisher or Distributor number row remains)

    • Then click the Add product identifier button

      • Product ID: 020$a

      • Qualifier: 020$q

      • Product ID type: select "ISBN" from the dropdown list

    • Now the Pub Num product identifier row is first in the mappings and the ISBN product identifier row is second

  5. Create 2 Action profiles for creating orders and link one to each of the above Field mapping profiles

  6. Create 2 Job profiles for creating orders and link one to each of the above Action profiles

  7. Import the attached file Order multiple prod ID types.mrc twice, once with the first job profile and once with the second job profile

  8. Click on the completed file name to view the log; be sure that there is a Product identifier in the POL with identifier type "Publisher or Distributor number"

  9. Click the "Created" link for the order, and check the POL for the "Publisher or distributor number" in the Product Identifier field

Expected Results:
Using either job profile, I would expect the PO and POL to be created, with no Product ID row for ISBN (since there is no 020 in the incoming record, but with a Product ID row for Publisher or Distributor number

Actual Results:
The import errors, and no POL is created. Both error reference the ISBN.

Additional Information: See attached video and sample MARC file

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

5

Checklist

hide

TestRail: Results

Activity

Show:

Ann-Marie BreauxApril 3, 2023 at 7:31 AM

Thank you for making the changes, and for the tests!

Maksym IshchenkoMarch 31, 2023 at 4:29 PM

Hello  

Ticket verified on bugfest env, all works as expected. Agreed with the to close this ticket.

Ruslan LavrovMarch 31, 2023 at 8:11 AM

Deployed to the Orchid bugfest env moving to in bugfix review.

Ann-Marie BreauxMarch 24, 2023 at 8:03 AM

Hi all looks good now with the second scenario on Snapshot. Moving this issue to Awaiting release.

Maksym IshchenkoMarch 23, 2023 at 9:58 AM

Hello  

Checked C378900 and all looks fine now. 028 is mapping and Product ID Type is shown properly. Can see

 

Moving task to In Review column

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 6:29 AM
Updated April 3, 2023 at 7:31 AM
Resolved March 24, 2023 at 8:03 AM
TestRail: Cases
TestRail: Runs