[Wactclc-alma] Has anyone used the Purdue Shelf Inventory API?

[George Babcock]

Hi all,

For inventory purposes, I think that the easiest way to find items out of
range and nonexisting barcodes is to use the Shelf Report function in Alma
(Resources>Manage Inventory>Shelf Report).  But this cannot find items
within the range that are badly misshelved.

With a lot of experimenting , the inventory that I did last year actually
worked to find:

1. missing items
2. items out of range
3. nonexisting barcodes
4. items in range that were badly mishelved.

First I scanned the barcodes of items on the shelf.  I also created an
analytics report that gave me a shelf list in call number order.  Then, I
used Excel's and its MATCH formula to find the first three bullet points.
Example: =MATCH(C2,$A$2:$A$1759,0) here Excel tries to match the barcode in
cell C2 in the list of all barcodes in cells A2 through A1759.  Then do a
reverse search:  =MATCH(A2,$C$2:$C$1759,0).  To find items that were badly
misshelved, I just compared the order of canned barcodes to the order of
shelf list barcodes.

I have attached one of my Excel spreadsheet from last years inventory and
can speak briefly about this tomorrow.

George

On Mon, May 21, 2018 at 3:15 PM, Stephanie Levesen <
Stephanie.Levesen at skagit.edu> wrote:

> I went to a session at ELUNA that dealt with inventorying the collection.
> It might be similar to George’s procedure because the college that
> presented used an Excel spreadsheet.
>
>
>
> I downloaded the session’s powerpoint that goes through what they did and
> also has procedures/process at the end of it.  I’ve attached it to this
> email for you to take a look in case you’re interested.
>
>
>
> Thanks,
>
> Stephanie
>
>
>
> Stephanie Levesen
>
> Periodicals/ILLs/Circulation
>
> Norwood Cole Library
>
> Skagit Valley College
>
> 2405 E College Way
>
> Mount Vernon, WA  98273
>
>
>
> 360-416-7659
>
>
>
> *From:* Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> *On Behalf Of *Guidry,
> Wade
> *Sent:* Monday, May 21, 2018 12:33 PM
> *To:* WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
> *Subject:* Re: [Wactclc-alma] Has anyone used the Purdue Shelf Inventory
> API?
>
>
>
> Good question, Laura.
>
>
>
> I’m not familiar with that Purdue code, but I’ll take a look, and see if
> it’s something I could set up as a consortial tool.
>
>
>
> Meanwhile, if I’m not mistaken, George at Edmonds has developed an Excel
> only approach to doing something similar (particularly, wrt identifying
> mishelved items).
>
>
>
> Maybe on tomorrow’s 10am call, if George is amenable and available, he can
> describe Edmonds’s current approach.
>
>
>
>
>
>
>
>
>
> Wade Guidry
>
> Library Consortium Services Manager, WACTCLC
>
> wadeg at bigbend.edu
>
> (509) 760-4474
>
>
>
>
>
> *From:* Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu
> <wactclc-alma-bounces at lists.ctc.edu>] *On Behalf Of *Staley, Laura
> *Sent:* Monday, May 21, 2018 10:12 AM
> *To:* WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
> *Subject:* [Wactclc-alma] Has anyone used the Purdue Shelf Inventory API?
>
>
>
> We are thinking of doing a collection inventory this summer.
>
>
>
> We have checked out the Alma shelf list procedure - Managing Physical Item
> Inventory Using Shelf Reporting – discussed here:  https://knowledge.
> exlibrisgroup.com/Alma/Product_Documentation/010Alma_
> Online_Help_(English)/040Resource_Management/050Inventory/040Managing_
> Physical_Resources  It works for most of our collections, but it’s not
> lovely.
>
>
>
> But what we’d really like to use is the Purdue API, discussed here:
> https://developers.exlibrisgroup.com/blog/Shelf-Inventory-using-Alma-APIs
>
>
>
> And we are wondering if anyone has tried this out in our environment, and
> if so, how hard was it to set up, and how did it work?  (And if you set it
> up and have a procedure, we’d love to see it.)
>
>
> Thanks,
>
>
>
> Laura Staley
>
> Media Librarian
>
> [image: RTC 2012 new logo email signature]
>
> 3000 NE 4th St. Renton, WA 98056
>
> Phone: (425) 235-2331 Ext. 5679 <%28425%29%20235-2331%20x5679>
>
> Email: lstaley at RTC.edu |RTC.edu
>
>
>
>
>
>
>



-- 
George Babcock
Library Acquisitions
Edmonds Community College
20000 68th Ave. W
Lynnwood, WA  98036
425-640-1855
george.babcock at email.edcc.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20180521/046e1a15/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2680 bytes
Desc: not available
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20180521/046e1a15/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Shelf List Main S--DONE.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 440571 bytes
Desc: not available
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20180521/046e1a15/attachment-0002.xlsx>