Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
Library Home
Chatham's COVID-19 informational website
Archives COVID-19 Collection Project
  | | Click to open/download a PDF of Full Library Calendar in a new window2021-22 Calendar

 

LIBRARY TECHNICAL SERVICES

SQL w/ GMD splitter
SQL Report for No LOC

SET-UP
1
-Login to KOHA, then come back here and click-on assigned link:

--

2-In a different tab/window, open:
Library of Congress - basic, popular
WVU - regional eccentricities
Akron - music, media

 

3-Go Libstaff and Click on the Title at the top of the list, then Copy ISBN (or Title/author if no ISBN) from Libstaff and paste and search in LC Catalog Quick Search webpage

 

4-Scroll down and copy and the LC Classification number

  • a) Go Back to Libstaff and select EDIT/Record

    • 1-scroll down to the 050 field and paste the LC call #

    • 2-navigate to the 690 field that has  "No LOC ..." and delete the field

    • 3-Save the Record

    • 4-Click the right arrow to go to next record, repeating from Step-3 above

  • b) if no records are  found

    • Go Back to Libstaff and select EDIT/Record

      • 1-navigate to the 690 field that has  "No LOC ..." and place an "x" in front of the  "No LOC ..."  (so it looks like: xNo LOC...)

      • 2-Save the Record

      • 3-Click the right arrow to go to next record, repeating from Step-3 above


:


    Visit us on Instagram    Listen to our playlists on Spotify   Visit us on YouTube Visit us on Twitter
 

Jennie King Mellon Library | 0 Woodland Road | Pittsburgh, PA 15232 | 412-365-1670 | Maps & Directions | Site map
 

Chatham Home