I have a question, too -- has anyone done SQL training?

https://knowledge.exlibrisgroup.com/Alma/Release_Notes/2022/Alma_2022_Release_Notes?mon=202202BASE

Abby, SQL is on my list of things I'd like to find time to learn more about 😬 Haven't really used it since Voyager days.

Abby and Amy - I've been contemplating taking a course in SQL!

Nice! I'm thinking it would help a lot with Analytics, just wasn't sure what others' experiences were.

Good question Abby. I'm interested in responses too. I suspect that the Alma context means there are only certain aspects that will be relevant to us from full-on SQL courses. But knowing so little, I don't even know what the relevant parts are. Probably mostly focused on constructing valid queries?

When I went to ELUNA a few years ago (Spokane?) librarians were enhancing their analytics in cool ways with SQL and regular expressions.

Does anyone have an inventory report they really like?

Ryer, is there a specific element of inventory you are looking for? New books, weeding, etc?

We're looking to do shelf inventory and weeding. Pretty basic info. I got pretty close with my own report, which started with physical item info, but then fulfillment info seems like a separate things. (Just been a little while for me)

I had a weeding report with filter, but it got messed up in our move (unsure how). Going to tweak it this month, but have found it useful for weeding/circ. It's really basic, though.

It seems like the overlap analysis never quite provides the info I need. I was trying to compare a new collection to our entire collection

But I could only compare one database.

But not all of PQ for example

I could add stuff but then it errors

Excel formula - vlookup

Ryer I remember creating a report for one of our librarians for weeding that included bibliographic info but also browse and loan counts, for a specified call number range. Is that what you're looking for?

Melinda - that's weird and too bad. Hope it isn't too bad to re-create.

Amy - Others would love to see that report. Share?

https://www.youtube.com/watch?v=v0MRscM0Flk

Amy - that does sound about what I'm thinking. Some basic bib info - barcode, title, pub date. Plus some fulfillment info - like check outs. I've gotten really close, but wasn't quite everything I wanted yet.

Amy - did you build yours or did you use something from the community?

I think I made mine. I will take a look after the meeting and email you...

Thank you Amy. That would be helpful. Before I reinvent the wheel here.

I'm not seeing it in my reports, hopefully I didn't lose it a while back. Will keep looking.

I intend to sign up for OCLC MD services update once I get a better handle on ctcLink.

Ryer, I have a report that I think is similar to Amy's. The report also highlights all the books that have been checked out in the last 5 years so that they are easier to spot as you go down the list.

FYIYour library’s holdings in WorldCat enable people to find items in your collections through WorldCat.org—connecting from popular websites like Google Books, Wikipedia, and Goodreads—and other OCLC services like WorldCat Discovery, FirstSearch, WorldShare Interlibrary Loan, and Connexion.Does WorldCat present the best view of your library?Accurate holdings in WorldCat are vital to ensure people can find and access all resources currently available in your collections. Up-to-date holdings also ensure they see your latest acquisitions, without viewing items you no longer own.Update holdings for free through June 2022.You can now use a new, streamlined process to update WorldCat holdings at no additional charge with your current OCLC subscriptions. When you send your library’s complete MARC 21 catalog data, the process matches your records with WorldCat and:• Adds holdings to matching WorldCat records• Removes inaccurate WorldCat holdings• Adds new records when a matching record is not avail

If you want to participate in the OCLC Streamlined Holdings Registration, whiltelist this email address-- simpleholdings@oclc.org

Did anyone else attend the OCLC Cataloging Community meeting last Friday? Big topics were DEI in cataloging and WorldShare Records management

You'll need to submit your MARC records to OCLC within 2 weeks of submitting the request to participate

Ryer I found my report. It displays Location, Publication Date, Permanent Call Number, Title, Number of Loans (in house), Number of Loans (Not in House). And filtered by "Lifecycle is equal to Active" and "Permanent Call Number is between xxx and yyy"

And you'll have to crosswalk the XML file to MRC using MarcEdit

Yes, Kirsti, they talked about the short timeline.

I'm excited that they can add our OCLC tag for Ebook Central permanent titles

Does anyone know what is involved in sending them the bib records? How do you export the entire database?

Lynn-- You create a Logical set of all your bibliographic records (or all your bibliographic records that contain an 035 with "(OCoLC)")

So there is no limit on the number of titles that a set can handle?

@Kirsti,

We had 33K, it took 12 minutes because it was just an export, not a change, I think

There kind of is, but it's at numbers much larger than we typically have in our collections. Like, Harvard has issues with size limitations

It looks like a job has been set up to publish incremental changes on a weekly basis. Whether that is working, I have not yet investigated.

(At SCC)

in 2018 I did original cataloging for some environmental reports in Grays Harbor. I think they said they can add those to the OCLC db

MARCEdit is wonderful!

^^totally!! I'm such a nerd, I am so excited to be using it again!

Good point, Wade, on ILL for ebooks

I feel so all powerful using MarcEdit!!

Thanks @Amy. Is yours a fulfillment report? I'm having a problem getting call numbers on a fulfillment report. Otherwise I am able to get the info I'm expecting. Tried item call number, but it's empty. In other reports I found barcodes within holding info. Feel like I'm missing something obvious.

Just use your powers for good, Lynn ;)

Ryer, are you LC or dewey?

Dewey

Don't recommend.

Is anyone here using Okta at their college?

SPSCC is using Okta.

Lesley - we're moving to Okta at some point soon.

We had several issues with Open Athens regarding our streaming video access and it was 4x more expensive

@lily, are y'all planning to use that in the library at some point too?

Ryer- Call numbers are in the Loan Details folder in a Fulfillment Analysis

@Lesley: yes. we're already running our ezproxy through Okta.

Gotcha!

I think Seattle's IT dept. is implementing Okta this coming fall. Maybe?

A-ha! Thanks Kirsti. Knew it just wasn't where I expected.

https://www.lirn.net/

https://www.lirn.net/products-and-services/lirn-services/lirn-proxy/

Re streamlined holdings project . . . Are there any reasons that a library would not want to go forward with this project?

Heading to an 11AM -- thanks!

We hadn't updated or added things in years

https://help.oclc.org/Metadata_Services/WorldShare_Collection_Manager?sl=en

Thank you all!

Thank you!

Thanks all!

Thanks, everyone

Thank you all. This has been a very helpfull meeting!

Have a great day, everyone!