4.1.6 Shared Record Suppression/Deletion Review

Vivian (talk | contribs)
No edit summary
 
Williamwoods (talk | contribs)
Line 13: Line 13:
# Under "Held by" filter, select your library/institution  
# Under "Held by" filter, select your library/institution  
# Under "Instance status" filter, select "Marked for deletion"  
# Under "Instance status" filter, select "Marked for deletion"  
# Review results for active/available items that need to be unmarked  
# Review results for active/available items that need to be unmarked
** What "Effective location (item)" filters are shown?  
#* What "Effective location (item)" filters are shown?
** Save Instance UUIDs for detailed review in Lists app (see below)  
#* Save Instance UUIDs for detailed review in Lists app (see below)
 
==Check for shared Instance suppression on active Holdings ==
==Check for shared Instance suppression on active Holdings ==


Line 24: Line 23:
# Under "Held by" filter, select your library/institution  
# Under "Held by" filter, select your library/institution  
# Suppression options (review results separately and/or combined)  
# Suppression options (review results separately and/or combined)  
## Under "Suppress from discovery" filter, select "Yes"  
#* Under "Suppress from discovery" filter, select "Yes"
## Under "Statistical code" filter, select "OpenRS: OpenRS_No – Suppress from OpenRS"  
#* Under "Statistical code" filter, select "OpenRS: OpenRS_No – Suppress from OpenRS"
## Under "Staff suppress" filter, select "Yes"  
#* Under "Staff suppress" filter, select "Yes"


==Check for shared Instance MARC Leader status code = d==
==Check for shared Instance MARC Leader status code = d==
Line 36: Line 35:
# Edit > Find  
# Edit > Find  
# Check "Use regular expressions"  
# Check "Use regular expressions"  
# Type =LDR  .....d
# Type <code>=LDR  .....d</code>
# Find all > Extract found records  
# Find all > Extract found records  


Line 43: Line 42:
# After selecting <span class="bookmark-start" id="_Hlk194580282"></span>the desired filters in Inventory, click Actions > Save instances UUIDs  
# After selecting <span class="bookmark-start" id="_Hlk194580282"></span>the desired filters in Inventory, click Actions > Save instances UUIDs  
# Open the CSV file in Excel  
# Open the CSV file in Excel  
# In B1, type =A1&","
# In B1, type <code>=A1&","</code>
# Autofill the formula to the end of the UUID list  
# Autofill the formula to the end of the UUID list  
# Copy the values in Column B to your clipboard  
# Copy the values in Column B to your clipboard  
Line 55: Line 54:
# Actions > Choose desired columns to show in export   
# Actions > Choose desired columns to show in export   
# Actions > Export list  
# Actions > Export list  
# Open CSV file and save as .xlsx file, and examine results using formatted table sort/filter functions
# Open CSV file and save as .xlsx file, and examine results using formatted table sort/filter functions

Revision as of 16:22, 4 April 2025



Due to the current Consortial Holding accordion bug in Folio Inventory, some shared Instances may have been suppressed or marked for deletion by one library without knowledge of active holdings at other libraries. To review if any of your titles have been accidentally suppressed or marked for deletion, here are some workflow options.

4.1.6.1 Check for shared Instance "marked for deletion" on active Holdings

  1. Go to Folio Inventory app, Instance tab
  2. Uncheck "Staff suppress" filter
  3. Under "Shared" filter, select "Yes"
  4. Under "Held by" filter, select your library/institution
  5. Under "Instance status" filter, select "Marked for deletion"
  6. Review results for active/available items that need to be unmarked
    • What "Effective location (item)" filters are shown?
    • Save Instance UUIDs for detailed review in Lists app (see below)

4.1.6.2 Check for shared Instance suppression on active Holdings

  1. Go to Folio Inventory app, Instance tab
  2. Uncheck "Staff suppress" filter
  3. Under "Shared" filter, select "Yes"
  4. Under "Held by" filter, select your library/institution
  5. Suppression options (review results separately and/or combined)
    • Under "Suppress from discovery" filter, select "Yes"
    • Under "Statistical code" filter, select "OpenRS: OpenRS_No – Suppress from OpenRS"
    • Under "Staff suppress" filter, select "Yes"

4.1.6.3 Check for shared Instance MARC Leader status code = d

  1. After selecting the desired filters in Inventory, click Actions > Save instances UUIDs
  2. Data Export app > Choose file > Default instances export job profile
  3. Select Instances UUID > Run
  4. Download and break the .mrc file in MarcEdit
  5. Edit > Find
  6. Check "Use regular expressions"
  7. Type =LDR .....d
  8. Find all > Extract found records

4.1.6.4 Detailed items review in Lists app

  1. After selecting the desired filters in Inventory, click Actions > Save instances UUIDs
  2. Open the CSV file in Excel
  3. In B1, type =A1&","
  4. Autofill the formula to the end of the UUID list
  5. Copy the values in Column B to your clipboard
  6. Go to Lists app > New
  7. Record type = Items (can repeat process selecting Holdings or Instances type if needed)
  8. Build query
  9. Field = Instance ID
  10. Operator = "in"
  11. Value = paste values from clipboard
  12. Test, run, save query
  13. Actions > Choose desired columns to show in export
  14. Actions > Export list
  15. Open CSV file and save as .xlsx file, and examine results using formatted table sort/filter functions