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-boun...@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@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" <eha...@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
> eha...@georgialibraries.org
> www.georgialibraries.org
> www.georgialibraries.org/pines
>
>
>
> From: Open-ils-general
> [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
> Scott Thomas
> Sent: Wednesday, July 29, 2015 12:35 PM
> To: open-ils-general@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:sc...@albright.org> sc...@albright.org
--
Jennifer Pringle
Co-op Support
BC Libraries Cooperative
Tel: 1-888-848-9250
Email:jprin...@sitka.bclibraries.ca
Website: http://bc.libraries.coop
