[Wactclc-alma] Overlap P and P

Mon Aug 31 09:00:40 PDT 2020

Wade,

The overlap reports were discussed in one of the ELUNA Knowledge Days sessions. You can find the overlap reports here.

https://analytics12-na.alma.exlibrisgroup.com/analytics/saw.dll?catalog#%7B%22location%22%3A%22%2Fshared%2FAlma%2FTitles%2FReports%22%7D

I was not able to figure out a way to sort the list by title and physical material type. For example: We have 'Without Pity' on dvd and on VHS. We would likely be able to withdraw the VHS copy if we verified that the dvd copy is in our stacks. I simply wanted to run a report on overlapping dvd and VHS titles. After I thought about it, I began to wonder if it would be good to also include if we had overlapping titles within VHS, DVD and electronic resources. One of the canned overlap reports is supposed to be able to check for P, D, and E duplicates. Does anyone have experience with using these overlap / canned reports? It seems to me like the canned reports are supposed to be there to save staff time, but in the end, folks end up having to create their reports from scratch.

Thanks for your help.

Colleen

________________________________
From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> on behalf of Guidry, Wade <WadeG at bigbend.edu>
Sent: Friday, August 28, 2020 1:22 PM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] Overlap P and P

Colleen,

Here’s a short list of titles I found in CPTC that have both DVD and VHS.

I got to this list by using this simple item report I created:

/shared/Community/Reports/Consortia/WACTCLC/Weeding/Simple Item report for use with Excel Pivot Tables

Then exporting the data to Excel and creating a pivot table<https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576>.

You can find pivot tables in Excel under the ‘Insert’ menu. A pivot table just lets you summarize a table of data.

It’s a generally useful tool, and one maybe I can demo on Tuesday.

The analytics report above looks just at ‘DVD’ and ‘Video Cassette’ material type items in the AudioVisual location. But you could adjust the criteria to include another locations or material types.

Also, since the different material types look to be on separate title records, this technique won’t catch duplicates if the titles used in the two records are not exactly the same.

And the band played on

Endocrine signs & symptoms

Life under pressure

Medical terminology

Needlestick prevention stick to safety /

Skin deep

Taboo.

The Art of listening

The Circulatory system

The Digestive system

The incredible human body

The miracle of life

The Skeletal system

The Universe within

Warnings from the ice

Without pity a film about abilities /

Wade Guidry

WACTCLC

Library Consortium Services Manager

wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>

http://www.wactclc.org<http://www.wactclc.org/>

509.760.4474

Pronouns: he/him/his

From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of Guidry, Wade
Sent: Friday, August 28, 2020 9:25 AM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] Overlap P and P

CAUTION: Originated outside our network. Do not click links or open attachments unless you validate the sender.

I’m not familiar with the canned reports you are looking at. But overlap reports are typically targeted at finding bibliographic record duplicates. That is, 2 or more title records in a catalog with the same bibliographic (not item-level) data.

Trying to find duplicates at the item level is trickier, since items are basically duplicate records “by design”. Item records associated with the same title (or at least, the same holding) are usually expected to be duplicates.

Can you give an example of two items that you are trying to identify as duplicates with different material types?

With that info, I could take a closer look.

It might end up being simpler to use holding information. But I’d need to see the records to recommend the best approach.

Wade Guidry

WACTCLC

Library Consortium Services Manager

wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>

http://www.wactclc.org<http://www.wactclc.org/>

509.760.4474

Pronouns: he/him/his

From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of McGaughey, Colleen
Sent: Thursday, August 27, 2020 1:30 PM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] Overlap P and P

I am unfamiliar with doing pivot tables. I will have to look into this more next week. It seems like this information should be possible in the existing canned overlap reports.

________________________________

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> on behalf of McGaughey, Colleen <Colleen.McGaughey at cptc.edu<mailto:Colleen.McGaughey at cptc.edu>>
Sent: Wednesday, August 26, 2020 3:09 PM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [Wactclc-alma] Overlap P and P

I have been trying to run an overlap analytic report to see what titles we have on VHS that we also might have on DVD. The Alma Overlap report uses Titles, and unfortunately the only material type available in this overlap report is Bibliographic material type. This means when I go to filter the list, I am unable to select video cassette and DVD. I am only able to select Visual Material. Does anyone know how to work around this?

At some point, I would actually like to include Electronic inventory, but for now, I just wanted to get an idea of what we might have on VHS can that safely be withdrawn from our collection.

Thanks!

Colleen

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200831/69e4e1e2/attachment-0002.html>