Details
-
Bug
-
Status: Closed (View Workflow)
-
P2
-
Resolution: Cannot Reproduce
-
None
-
None
-
0
-
Folijet Support
-
Morning Glory (R2 2022)
-
Implementation coding issue
Description
Overview: When using a static match for item status to determine whether an item should be updated or not, that Static value match does not seem to be working
Current workaround: None
Steps to Reproduce:
- Log into FOLIO-snapshot as diku_admin
- Go to Settings/Data import/Field mapping and create the following profiles:
- Field mapping profile 1
- Name: Create simple holdings
- Incoming record type: MARC Bib
- FOLIO record type: Holdings
- Statistical codes:
- Add these to existing
- Select one from the dropdown list that is probably not being used in other records
- Permanent location: Select a value from the dropdown list
- Field mapping profile 2
- Name: Create simple item
- Incoming record type: MARC Bib
- FOLIO record type: Item
- Material type: Select one from dropdown list
- Permanent loan type: Select one from the dropdown list
- Status: Select "Available" from the dropdown list
- Field mapping profile 3
- Name: Update simple item
- Incoming record type: MARC Bib
- FOLIO record type: Item
- Item notes
- Add these to existing
- Note type: Select "Note" from the dropdown list
- Note: "THIS WAS UPDATED!"
- Staff only: Mark for all affected records
- Go to Settings/Data import/Action profiles
- Create Action profile 1 (create simple holdings) and link to Field mapping profile 2
- Create Action profile 2 (create simple items) and link to Field mapping profile 2
- Create Action profile 3 (update simple items) and link to Field mapping profile 3
- Go to Settings/Data import/Match profiles
- Create Match profile 1:
- Title: Match 902$a to Item HRID
- Click Existing record: Item to match the Incoming MARC Bibliographic record to the Existing Item record
- MARC value in incoming record: Field: 902, Ind 1: *, Ind 2,: *, Subfield: a
- Match criterion: Exactly matches
- Existing item record field: Admin data: Item HRID
- Create Match profile 2:
- Title: Item status = Available
- Click Existing record: Item to match the Incoming to the Existing Item record
- Change the Incoming side of the match to Static value (submatch only)
- Incoming Static value: Text, Value: Available
- Match criterion: Exactly matches
- Existing item record field: Loan and availability: Status
- Go to Data import/Settings/Job profile
- Create Job profile 1:
- Name: Create simple instance, holdings, items
- Accepted data type: MARC
- No match profile
- Click +and add Action profile: Default - Create instance
- Click + and add Action profile: Create simple holdings
- Click + and add Action profile: Create simple item
- Create Job profile 2:
- Update item based on HRID and Status match
- Accepted data type: MARC
- Click + and add Match profile: Match 902$a to Item HRID
- For matches, click + and add Match profile: Item status = Available
- For matches, click + and add Action profile: Update simple item
- For matches, click + and add Match profile: Item status = Available
- Go to Settings/Data EXPORT/Field mapping profiles
- Create field mapping profile
- Name: Item HRID
- FOLIO record type:
- Source record storage (entire record)
- Item
- Output format: MARC
- Transformation: Item - HRID
- MARC field: 902, Ind 1: [blank], Ind 2: [blank], Subfield: $a
- Go to Settings/Data EXPORT/Job profiles
- Create a new export profile
- Name: Bibs with Item HRIDs
- Mapping profile: Select the Item HRID one created above
- Now your profiles are all set!
- Go to Data Import and upload the attached file TestItemStatusMatch.mrc
- Assign Job profile Create simple instance, holdings, items and import the file
- After the import is completed, click on the file name at the top of the log list
- Use the list of created items, and edit 3 of the item records to have a Status different from Available, by selecting the Actions/Mark as (and then select one of the item statuses in the Action list). Thus, you will have 7 items with status Available, and 3 items with a status other than Available
- Go to Inventory, and use the filter for the Holdings or Item statistical code that you selected to find the 10 records that you imported.
- In the Results list Action menu, select Actions/Save instances UUIDs
- A file of UUIDs will download to your machine
- Go to Data Export and upload that file of UUIDs
- Select the Bibs with Item HRIDs export profile
- Then in the confirmation modal, select Instances and then press Run
- Once the file appears at the top of the export log, click on the file name and the file will download to your machine
- Go to Data Import and Upload the file that you just downloaded from Data Export
- Select the profile: Update item based on HRID and Status match, and run the import
- Once completed, click on the file name at the top of the log list
- 7 items should have been updated (click on the item to confirm that the status is Available and that the note was added)
- 3 should have been discarded (click on the item to confirm that the status is something other than Available)
Expected Results:
- Items with status Available are updated
- Items without status Available are not updated
Actual Results:
- Failed the first two times, but worked the next two times
Additional Information: See attached video or screenshot
TestRail: Results
Attachments
Issue Links
- defines
-
UXPROD-3464 NFR: Data Import R2 2022 Morning Glory Support Bug work
-
- Closed
-
- relates to
-
MODDATAIMP-697 Test performance of update scenarios after removal of indexes
-
- Closed
-