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

Data Import Update SRS duplicates protected fields on update when there is more than one of any given field - Morning Glory

    XMLWordPrintable

Details

    • 0
    • Folijet Support
    • Morning Glory R2 2022
    • University of Chicago
    • Implementation coding issue

    Description

      Overview:  For data import jobs that update the SRS MARC bibliographic record, the system protected fields are protected sometimes even when they already exist in the system. The first of any given protected field is not duplicated, but when there are multiples, there are multiples, the remaining fields are duplicated in the record. This is occurring in the Chicago environment (Juniper  Hotfix 4+) and in Kiwi Dev.
      Steps to Reproduce:

      1. Log into Kiwi Dev as diku_admin.
      2. Edit the SRS MARC record of any instance where source = MARC to add two 900 fields and one 901 field. For instance:
        1. 900 
          $aFirst 900 field.
        2. 900 
          $Second 900 field. 
        3. 901 
          $aFirst 901 field. 
      3. Go to Settings > Data Import > Field Protections and add the 900 and 901 fields as protected fields. (All indicators and subfields.)
      4. Go to Settings > Data Import and create a new Field mapping profile:
        1. Incoming record type: MARC Bibliographic.
        2. FOLIO Record Type: MARC Bibliographic.
        3. Field Mappings: Updates.
        4. Save the Field Mapping Profile.
      5. Go to Settings > Data Import and create a new Action profile:
        1. Action: Update
        2. FOLIO record type: MARC Bibliographic
        3. Associated Field Mapping Profile _ the mapping profile that was just created. 
        4. Save the profile.
      6. Go to Settings > Data Import and create a new match profile.
        1. Incoming Records: MARC Bibliographic
        2. Existing Records: MARC Bibliographic field in incoming record:
          1. Field 999
          2. Ind 1: f
          3. Ind 2: f
          4. Subfield: i
        3. Match criterion: Exactly matches
        4. Existing MARC Bibliographic Record field: 
          1. Field 999
          2. Ind 1: f
          3. Ind 2: f
          4. Subfield: i
        5. Save the profile.
      7. Go to Settings > Data Import and create a new Job profile:
        1. Choose the Match Profile just created.
          1. Under the Match profile nest the Action profile created.
        2. Save the Job profile. 
      8. Go to Inventory, search for the instance that was edited with the 900 and 901 field data. Check the box next to the record in search results and select Export Instances (MARC). 
      9. Go to the Data Export App and download the exported record. Make a change to any fields except the 900 or 901 fields. 
      10. Compile the record back into Marc and import the file n Data Import using the Job profile that was just created. 
      11. Before the import, the 900 / 901 data looks like this:
        1. 900   ‡a First 900.
          900   ‡a Second 900.
          901   ‡a First 901.
      1. After the import, the 900 / 901 data looks like this:
        1. 900   ‡a First 900.
          900   ‡a Second 900.
          900   ‡a Second 900.
          901   ‡a First 901.

      Expected Results:  The 900 and 901 fields are exactly the same as they were before the export - transform - load procedure and they are not duplicated. ** 
      Actual Results: The occurrence of any protected is not duplicated, but any subsequent occurrences are duplicated. * The second 900 field is duplicated. * 
      Additional Information:
      URL:
      Interested parties: University of Chicago

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                abreaux Ann-Marie Breaux
                christie Christie Thomas
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases