[Evergreen-reports] Holdings Report

[Elizabeth Davis]

Hi Tony

Sorry, let me see if I explain this better.   I need a list of TCNs where library A and/or library B own a copy, but library C doesn’t.   Each library is the owning library in the record.  I can filter by owning library in the reporter, but I need instances where library C doesn’t also own a copy.  I need to find the unique TCNS that only library A and/or B own.  They are going to be looking at holds on these TCNs to see what areas of the collection where Library C could improve.

Here are some examples of instances where A or B own copies by not C.
TCN Value
Library A
Library B
Library C
32163
1
42065
1
45583
1
50211
1
53821
1
58558
1
1
59811
1
68190
1
76960
1
81830
1
85557
1
1
86275
1

Does that make more sense? It’s a tricky one to put concisely.
Elizabeth


[cid:image003.png at 01D9E25C.517E7190]Elizabeth Davis (she/her), Support & Project Management Specialist
Pennsylvania Integrated Library System (PaILS) | SPARK
(717) 256-1627 | elizabeth.davis at sparkpa.org<mailto:katherine.dannehl at sparkpa.org>
support.sparkpa.org<https://support.sparkpa.org/> | support at sparkpa.org<mailto:support at sparkpa.org>

From: Tony Miller <tony at poplarbluff.org>
Sent: Friday, September 8, 2023 1:39 PM
To: Evergreen Community Reports Email List <evergreen-reports at list.evergreen-ils.org>
Cc: Elizabeth Davis <elizabeth.davis at sparkpa.org>
Subject: Re: [Evergreen-reports] Holdings Report

I am not sure exactly if this is what you mean. You can filter by owning library if you just need from a certain library. Is the owning library on the record branch specific? You may try filtering by circulating library if not.

On Fri, Sep 8, 2023 at 12:20 PM Elizabeth Davis via Evergreen-reports <evergreen-reports at list.evergreen-ils.org<mailto:evergreen-reports at list.evergreen-ils.org>> wrote:
Hello

I’m looking to run a report to for a list of TCNs for a library system where 2 of the 3 libraries own copies, but the 3rd location doesn’t own a copy.  I’m looking for TCNs where libraries A and B are the only libraries that own copies.  I have list of TCNs and copy counts, but I’m having a hard time filtering out instances where all three libraries own copies or where library C and A or library C and B own copies.

Has anyone done this type of report or any ideas on how I can filter in either Excel/Sheets or using OpenRefine?

Thanks!

[cid:image002.png at 01D9E257.4074AA40]Elizabeth Davis (she/her), Support & Project Management Specialist
Pennsylvania Integrated Library System (PaILS) | SPARK
(717) 256-1627 | elizabeth.davis at sparkpa.org<mailto:katherine.dannehl at sparkpa.org>
support.sparkpa.org<https://support.sparkpa.org/> | support at sparkpa.org<mailto:support at sparkpa.org>

_______________________________________________
Evergreen-reports mailing list
Evergreen-reports at list.evergreen-ils.org<mailto:Evergreen-reports at list.evergreen-ils.org>
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports


--
Tony Miller
User Services Coordinator
[01]
318 North Main Street | Poplar Bluff, MO 63901
(573) 686 – 8639
Website<https://poplarbluff.org/> | Newsletter<https://poplarbluff.org/OTS.pdf> | Annual Report<https://poplarbluff.org/annualreport.html> | Digital Library<http://poplarbluff.org/downloads.html>


​​Promoting Libraries to Make Our Communities Stronger
Poplar Bluff Municipal Library District with its community partners provides and promotes equal access to reading, information, cultural and intellectual resources.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230908/067120a6/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 10034 bytes
Desc: image001.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230908/067120a6/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 5396 bytes
Desc: image003.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230908/067120a6/attachment-0003.png>