[Wactclc-alma] Analytics for weeding physical items

Thu Aug 13 13:38:59 PDT 2020

Well, I *think* the Begin Publication Date might be from the MARC 008 field. (Date1 Fixed Field in OCLC Connexion)  It might also be a special field that Ex Libris creates for Alma Analytics by using some kind of script to edit the Publication Date field in the MARC 260$c. Like so many things with Alma, who the heck knows. ;)

Kirsti

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Guidry, Wade
Sent: Thursday, August 13, 2020 11:56
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] Analytics for weeding physical items

Quick update on this sample report I emailed about this morning…

Thanks to Melinda Martin’s suggestion from Spokane Colleges, I added the ‘Begin Publication Date’ to the analysis.

The ‘Begin Publication Date’ is taken from the MARC 008 fixed fields, and so is much cleaner and more normalized, and much more suitable for sorting that ‘Publication date’.

Wade Guidry
WACTCLC
Library Consortium Services Manager
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
http://www.wactclc.org<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org%2F&data=02%7C01%7C%7Cf272619d039e4210c7d108d83fba870e%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637329417645874003&sdata=2WkzI5pVd9KTFJvi%2FWuGyGvPpwxmhPEONUNp3D94ENA%3D&reserved=0>
509.760.4474

Pronouns: he/him/his

From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of Guidry, Wade
Sent: Thursday, August 13, 2020 9:00 AM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] Analytics for weeding physical items

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

I created a simple inventory report that can be used as a starting point for a weeding report.

I created the report from the ‘Physical Items’ subject area.

The one caveat that applies to the report, and any other report that contains publication date, is that sorting by publication date is subject to error, because publication dates in MARC records vary in how that are entered and presented.

You can find my report at:

/shared/Community/Reports/Consortia/WACTCLC/Weeding/Simple Weeding Report

You can copy / paste the report into your local analytics folder with the icons highlighted below. (Please don’t edit the  version in the community folder.)

[cid:image001.png at 01D67177.173981E0]

Wade Guidry
Library Consortium Services Manager, WACTCLC
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
http://www.wactclc.org<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org%2F&data=02%7C01%7C%7Cf272619d039e4210c7d108d83fba870e%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637329417645883958&sdata=YBpez%2BH0om7%2FDKGf%2Fv%2BI%2FRbflJ8U66l2iY7DjOQv%2Beg%3D&reserved=0>

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of McGaughey, Colleen
Sent: Wednesday, August 12, 2020 2:55 PM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] Analytics for weeding physical items

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

Thanks Wade,

I took off the criteria for Creation Date, and included Publication Date instead. I am still getting a lot fewer results than anticipated.

If I run my revised report, where I added Publication Date, there are only 13 items on the report. If I run the canned report as is (creation date; last loaned), we have over 11,000 items that haven't circulated since 2015. So, I am clearly missing something.

Colleen

________________________________
From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> on behalf of Guidry, Wade <WadeG at bigbend.edu<mailto:WadeG at bigbend.edu>>
Sent: Wednesday, August 12, 2020 12:22 PM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] Analytics for weeding physical items

Creation date is the date the item was created in Alma, or possibly in another system, if the items were migrated into Alma.

So, it’s not likely that you’ll see creation dates from the 50’s.

You’re probably wanting to filter by publication date? If so, you’ll want to look at the attributes on the title, rather than the item.

Wade Guidry

WACTCLC

Library Consortium Services Manager

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

http://www.wactclc.org<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org%2F&data=02%7C01%7C%7Cf272619d039e4210c7d108d83fba870e%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637329417645883958&sdata=YBpez%2BH0om7%2FDKGf%2Fv%2BI%2FRbflJ8U66l2iY7DjOQv%2Beg%3D&reserved=0>

509.760.4474

Pronouns: he/him/his

From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of McGaughey, Colleen
Sent: Wednesday, August 12, 2020 11:05 AM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [Wactclc-alma] Analytics for weeding physical items

I used the canned analytic report for determining physical weeds, and edited some of the filters. I know that I should be getting more results back, so I am wondering what I could be doing wrong. Below is a screen shot of the filters.

I know that we still have material in our collection that was created in the 1950s. So, I am trying to capture those items, plus show any items that have not been loaned since 2015. I put my report in the shared reports folder under CPTC. Could someone please tell me what I am missing or doing wrong?

Thanks,
Colleen

[cid:image002.png at 01D67177.173981E0]
CAUTION: This email originated outside of the Seattle Colleges’ email system. Do not click links or open attachments unless you recognize the sender and know the content is safe. Questions? Contact IT Services at x6333 (Central), x3630 (North), x5844 (South) or email ITHelp at seattlecolleges.edu<mailto:ITHelp at seattlecolleges.edu>.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200813/64151a79/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 37057 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200813/64151a79/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 47211 bytes
Desc: image002.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200813/64151a79/attachment-0005.png>