[OPEN-ILS-GENERAL] Inventory Item

[Dan Wells]

We also do more or less exactly what Jennifer and others have outlined in more detail.  When the scanning is done, we generally pull our missing list directly from the DB, with a query something like the one listed below (adjust to suit), which we then import into Excel for staff/student searching of items.

Dan

-----------------------------------------------

COPY (
SELECT
    oils_xpath_string('//*[@tag="245"]/*[@code="a"]', bre.marc) || ' ' || COALESCE(oils_xpath_string('//*[@tag="245"]/*[@code="b"]', bre.marc), '') as title,
    oils_xpath_string('//*[@tag="100"]/*[@code="a"]', bre.marc) as author,
    acn.label,
    acp.copy_number,
    acp.barcode,
    ccs.name,
    bre.id,
    acp.create_date,
    acp.edit_date,
    acp.id,
    acn.label_sortkey
FROM asset.copy acp
JOIN asset.call_number acn ON acn.id = acp.call_number
JOIN biblio.record_entry bre ON bre.id = acn.record
JOIN config.copy_status ccs ON ccs.id = acp.status
WHERE
    NOT bre.deleted
    AND NOT acn.deleted
    AND NOT acp.deleted
    AND acp.location = 103 -- this run was only for the 4th Floor
    AND acn.label LIKE 'BS%' -- this run was for BS call numbers
    AND acp.edit_date < '2014-05-07' -- date inventory started
    AND acp.status NOT IN (1,102) -- checked out, legacy lost
    AND circ_modifier <> 'PERIODICAL' -- these don't have barcodes, so they don't get scanned
    AND barcode NOT LIKE '@@%' -- items with auto-barcodes can't be scanned
) TO '/tmp/BS_inventory_report.csv' WITH CSV;


Daniel Wells
Library Programmer/Analyst
Hekman Library, Calvin College
616.526.7133

-----Original Message-----
From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Jennifer Pringle (Project Sitka)
Sent: Wednesday, July 29, 2015 1:19 PM
To: Evergreen Discussion Group <open-ils-general at list.georgialibraries.org>
Subject: Re: [OPEN-ILS-GENERAL] Inventory Item

Several of our libraries have run inventory using the procedure we came up with:  
http://docs.sitka.bclibraries.ca/Sitka/current/html/inventory.html

I can send more details about the report templates we have set up if anyone is interested.

Jennifer


Quoting "Hardy, Elaine" <ehardy at georgialibraries.org>:

> PINES a number of years ago explored development of an inventory 
> function in Evergreen; however, our development funding was cut so 
> that we were unable to pursue it. We have not revisited the requirements.
>
>
>
> We did develop a now dated document on using existing functionality to 
> inventory. I have attached the pdf. I have not reviewed it in a few years.
>
>
>
> Elaine
>
>
>
> J. Elaine Hardy
> PINES & Collaborative Projects Manager Georgia Public Library Service
> 1800 Century Place, Ste 150
> Atlanta, Ga. 30345-4304
>
>
>
> 404.235.7128
> 404.235.7201, fax
> ehardy at georgialibraries.org
> www.georgialibraries.org
> www.georgialibraries.org/pines
>
>
>
> From: Open-ils-general
> [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
> Scott Thomas
> Sent: Wednesday, July 29, 2015 12:35 PM
> To: open-ils-general at list.georgialibraries.org
> Subject: [OPEN-ILS-GENERAL] Inventory Item
>
>
>
> We have been with EG for four months, and this is the first time this has
> come up: there does not appear to be an Inventory Item function (at least
> in 2.6.3). I am not finding a Date Inventoried field in the item record
> nor can I locate a way to inventory an item. Am I missing something
> obvious? If not, how do Evergreen libraries inventory their collections?
>
>
>
> Thank you,
> Scott
>
>
>
>
>
> Scott  Thomas, MLS
>
> Head of Information Technologies and Technical Services
>
> Scranton Public Library
>
> Lackawanna County Library System
>
> 2006 N. Main Ave.
>
> Scranton, PA 18508
>
> Ph: 570-207-2379
>
> Fx: 570-348-3020
>
> Email:  <mailto:scott at albright.org> scott at albright.org


-- 
Jennifer Pringle
Co-op Support
BC Libraries Cooperative
Tel: 1-888-848-9250
Email:jpringle at sitka.bclibraries.ca
Website: http://bc.libraries.coop