Uploaded image for project: 'data-import-processing-core'
  1. data-import-processing-core
  2. MODDICORE-80

Cannot match on eAccess URI field

    XMLWordPrintable

Details

    • Folijet Sprint 95, Folijet Sprint 96
    • 3
    • Folijet
    • Q2 2020 Hot Fix #2
    • Lehigh, MO State, Simmons, University of Chicago

    Description

      Overview: Cannot match on an eAccess URI field

      Current workaround: None, would have to search for records and update them manually, one by one

      Steps to Reproduce:

      1. Log into FOLIO-snapshot as diku_admin
      2. Go to Settings/Data import
      3. Create field mapping profile 1
        • Name: Create instance
        • Incoming record type: MARC Bib
        • FOLIO record type: Instance
        • Cataloged date: ###TODAY###
      4. Create field mapping profile 2
        • Name: Create e-holdings
        • Incoming record type: MARC Bib
        • FOLIO record type: Holdings
        • Permanent location: "Online (E)"
        • Electronic access:
          • Add these to existing
          • Relationship: "Resource"
          • URI: 856$u
          • Link text: 856$z
      5. Create field mapping profile 3
        • Name: Update e-holdings
        • Incoming record type: MARC Bib
        • FOLIO record type: Holdings
        • Suppress from discovery: Mark for all affected records
        • Call number type: Other scheme (from dropdown list)
        • Call number: "ONLINE"
      6. Create action profile 1
        • Name: Create instance
        • Action: Create
        • FOLIO record type: Instance
        • Link to Field mapping profile 1 (create instance)
      7. Create action profile 2
        • Name: Create e-holdings
        • Action: Create
        • FOLIO record type: Holdings
        • Link to Field mapping profile 2 (Create e-holdings)
      8. Create action profile 3
        • Name: Update e-holdings
        • Action: Replace
        • FOLIO record type: Holdings
        • Link to Field mapping profile 3 (Update e-holdings)
      9. Create match profile 1
        • Name: 856u to Holdings URI
        • Incoming record: MARC Bib
        • Existing records: Holdings
        • Incoming Bib
          • Field: 856
          • Ind 1: 4
          • Ind 2: 0
          • Subfield: u
        • Exactly matches
        • Existing holdings record field: Electronic access: URI
      10. Create job profile 1
        • Name: Create instance and e-holdings
        • Accepted data type: MARC
        • No match
        • Action: Create instance
        • Action: Create e-holdings
      11. Create job profile 2
        • Name: Update e-holdings
        • Accepted data type: MARC
        • Match: 856u to holdings URI
        • For matches, Action: Update e-holdings
        • For non-matches: No action
      12. Go to Data Import and upload the attached file: Match on URL.mrc
      13. Select the job Create instance and e-holdings and import the file
      14. Go to Inventory and search for the Instance HRID that was just created
      15. View the associated holdings, and check that the Electronic access/URI field filled in
      16. Go to Data Import and upload the attached file: Match on URL.mrc
      17. This time, select the job Update e-holdings and import the file
      18. Go to Inventory and search for the Instance HRID that was previously created
      19. View the associated holdings, and see if it has been updated (suppressed from discovery, has a call number of ONLINE)
      20. NOTE: Make sure not to create multiple holdings with the same URI, since that would result in multiple matches for the URI, which could mess up the update action

      Expected Results: The match on URI works and the holdings record is updated

      Actual Results: I don't think the match works, and the holdings is definitely not updated

      Additional Information: See attached video and MARC file

      From Christie Thomas: Using the URI as a match point would open up any number of workflows, not just ETL.

      TestRail: Results

        Attachments

          1. MarciveSample.mrc
            7 kB
          2. Match on holdings URI.mp4
            7.77 MB
          3. Match on URL.mrc
            5 kB
          4. Match on URL3.mrc
            2 kB
          5. SmallerFoDSGFrev.mrc
            51 kB
          6. Testing URL match.mp4
            2.16 MB

          Issue Links

            Activity

              People

                Kateryna Senchenko Kateryna Senchenko
                abreaux Ann-Marie Breaux
                Ann-Marie Breaux Ann-Marie Breaux
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases