[Wactclc-alma] Analytics for weeding physical items

Mon Aug 24 14:53:13 PDT 2020

Hi Wade,

The type of report you suggested is what I did... Just add title, item barcode, publication date, last loan date, date created, without any filters. Once I saw what the data looked like, I started to add filters to the report. This is how I normally run reports anyway.

Kristi, I did use the physical items subject area on the analytic report. I think that most of our items have been coded correctly. When I first started, I became aware that some of our VHS tapes had the material type "Other". I was able to fix a lot of them, but some of them remain unchanged, as I couldn't get them to display in a query, or if I searched the barcode/title the item could not be located, yet they showed up in my analytic report.

I need to take some time to look over the reports I created last week to see if I can figure out why I got no results, and why the columns won't sort. I have been out of the office since Thursday, so I need to refresh my memory as to what's going on with these reports.

Colleen

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

I’d suggest starting with a simpler report.

Just add title, item barcode, publication date, last loan date, date created, without any filters, and just see what your date looks like.

Once you see what your data looks like, you can decide how best to filter to achieve your goal.

Be aware, you may also have a lot of items with  last loan dates of NULL (things that have never been checked out).

To list those, you may need to set a filter of last loan date is NULL.

Wade Guidry

Library Consortium Services Manager, WACTCLC

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

(509) 760-4474

http://www.wactclc.org

From: Wactclc-alma <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>
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<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: 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

[https://attachments.office.net/owa/Colleen.McGaughey%40cptc.edu/service.svc/s/GetAttachmentThumbnail?id=AAMkADY4YzlhMTY0LTE2OGMtNGI1Ny05ODIxLTU2NTliZjU0NDcxNwBGAAAAAAD2tm2g6xpzQZnn2Ci%2BnPgiBwBIQ6NGGWjtQKdI9Hm8QsuDAAAAQDANAAAi%2BOHfBRgZR4%2BjeLaz4gMrAACyRAorAAABEgAQAA5ACBTDfYFEuFLefQsNIZQ%3D&thumbnailType=2&owa=outlook.office.com&scriptVer=2020081002.06&X-OWA-CANARY=h6cps3d7pES8sTju6DyLPFAms2x2SNgYg-iQdkwChZ6bPu6R15gfq_IFMKEoZEjoCKIBGPRPD2c.&token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjU2MzU4ODUyMzRCOTI1MkRERTAwNTc2NkQ5RDlGMjc2NTY1RjYzRTIiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJWaldJVWpTNUpTM2VBRmRtMmRueWRsWmZZLUkifQ.eyJvcmlnaW4iOiJodHRwczovL291dGxvb2sub2ZmaWNlLmNvbSIsInVjIjoiNjY4Mjk4NDIzZjY5NGExN2I2NDQwOTU3ODRlMzA5YjQiLCJzaWduaW5fc3RhdGUiOiJbXCJrbXNpXCJdIiwidmVyIjoiRXhjaGFuZ2UuQ2FsbGJhY2suVjEiLCJhcHBjdHhzZW5kZXIiOiJPd2FEb3dubG9hZEA4YWNhODUzNy03YzlhLTQyNDgtOTMxYS1iMmFlMmU4NWRlZGQiLCJpc3NyaW5nIjoiV1ciLCJhcHBjdHgiOiJ7XCJtc2V4Y2hwcm90XCI6XCJvd2FcIixcInByaW1hcnlzaWRcIjpcIlMtMS01LTIxLTIzMzMwNjI2NjktNzY5NTA4OTMyLTM4MDM0MzAzMC0yMzM1NjU2OFwiLFwicHVpZFwiOlwiMTE1MzgwMTExNjE5MTE2MzgzNlwiLFwib2lkXCI6XCI4ZmRkYzg3MC0wMmMyLTQ0NmYtOTNhYi1kOTU0N2VhOWQ5NGRcIixcInNjb3BlXCI6XCJPd2FEb3dubG9hZFwifSIsIm5iZiI6MTU5ODMwNTI3MSwiZXhwIjoxNTk4MzA1ODcxLCJpc3MiOiIwMDAwMDAwMi0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDBAOGFjYTg1MzctN2M5YS00MjQ4LTkzMWEtYjJhZTJlODVkZWRkIiwiYXVkIjoiMDAwMDAwMDItMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL2F0dGFjaG1lbnRzLm9mZmljZS5uZXRAOGFjYTg1MzctN2M5YS00MjQ4LTkzMWEtYjJhZTJlODVkZWRkIiwiaGFwcCI6Im93YSJ9.hREvNrYFvczemjXR-Z2hp0IJL0VgEldBy6HbB5Qyp2LTQyJ-PJzvotjS0E1wcto7OfOUombfyGJkyqNQ3qWSWckKhQzzAhw9t602ogpTfCoYXF3xhRue5f1m6jX7PH8e4nOM0Yirp4NVf8fnSAL_ID5KeN_FRZp1_Bq9q-uxNS8Iolbsj03R0SgnRU9Lb9y-p95Y0OYXu1ZUznL67ahSkzKk7aP63Qvzi73aI-SMI5sai9UCXAhE5pXzqzWnujzvpkhkG8Sr4q1fR46qt1-_W9KkMlPFivf60KeNlh7uUwUYOujfl8vbg4oqZ9zjb0QYIYM1Umt7i4Y6yDTc-Ef7xA&animation=true]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200824/cc1fbd36/attachment-0002.html>