[OPEN-ILS-GENERAL] List of new items in catalog and how to get them on to your web page
Vince Giordano
vgiordano at juniatalibrary.org
Thu Jul 28 13:13:33 EDT 2016
We have our website through Google and have a Google gadget set up to do
this. We run a report in Evergreen to get the record ID's of the new items
and then simply copy and paste those ID's into the gadget.
Here is a straightforward tutorial made by our district tech staff:
https://docs.google.com/document/d/1dXQ0gDHJBIW0iygMv3t7SC9W50syHTqvpsSE03TzfYc/edit
[image: photo]
<http://twitter.com/JuniataCoLib> <http://www.instagram.com/juniatacounty/>
<http://Public Profilehttps://www.linkedin.com/in/vince-giordano-1bb2a672>
<http://www.pinterest.com/jocindar/>
Vince Giordano
Director, Juniata County Library
717-436-6378 // www.facebook.com/juniatapubliclibrary // 498 Jefferson St -
Mifflintown, PA 17059
On Thu, Jul 28, 2016 at 12:00 PM, <
open-ils-general-request at list.georgialibraries.org> wrote:
> Send Open-ils-general mailing list submissions to
> open-ils-general at list.georgialibraries.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>
> http://libmail.georgialibraries.org/mailman/listinfo/open-ils-general
> or, via email, send a message with subject or body 'help' to
> open-ils-general-request at list.georgialibraries.org
>
> You can reach the person managing the list at
> open-ils-general-owner at list.georgialibraries.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Open-ils-general digest..."
>
>
> Today's Topics:
>
> 1. Re: Reports (Mike Rylander)
> 2. List of new items in catalog and how to get them on to your
> web page (Mina Edmondson)
> 3. Re: List of new items in catalog and how to get them on to
> your web page (Chauncey Montgomery)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 27 Jul 2016 13:28:05 -0400
> From: Mike Rylander <mrylander at gmail.com>
> To: Evergreen Discussion Group
> <open-ils-general at list.georgialibraries.org>
> Subject: Re: [OPEN-ILS-GENERAL] Reports
> Message-ID:
> <CAO8ar==
> RoVOoiCxpz8P0LXrVQo7B9Z_iHQdhnm78uoWeL4HgEg at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Stuart,
>
> They're stored in the table called action.hold_request_cancel_cause:
>
> =# select * from action.hold_request_cancel_cause;
> id | label
> ----+-----------------------
> 1 | Untargeted expiration
> 2 | Hold Shelf expiration
> 3 | Patron via phone
> 4 | Patron in person
> 5 | Staff forced
> 6 | Patron via OPAC
> 7 | Patron via SIP
> (7 rows)
>
> >From a recent stock load.
>
> HTH,
>
> --
> Mike Rylander
> | President
> | Equinox Software, Inc. / Open Your Library
> | phone: 1-877-OPEN-ILS (673-6457)
> | email: miker at esilibrary.com
> | web: http://www.esilibrary.com
>
>
> On Wed, Jul 27, 2016 at 1:09 PM, Forrest, Stuart <sforrest at bcgov.net>
> wrote:
> > Beth
> >
> >
> >
> > Thanks, that is what I was missing. Where can I get a list of all the
> > possible values for this field?
> >
> >
> >
> > Thanks
> >
> > Stuart
> >
> >
> >
> >
> ================================================================================
> >
> > Stuart Forrest PhD
> >
> > Library Systems Specialist
> >
> > Beaufort County Library
> >
> > 843 255 6450
> >
> > sforrest at bcgov.net
> >
> >
> >
> > http://www.beaufortcountylibrary.org
> >
> >
> >
> > For Leisure, For Learning, For Life
> >
> >
> >
> >
> >
> >
> >
> > From: Open-ils-general
> > [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
> > Willis, Beth
> > Sent: Wednesday, July 27, 2016 12:57 PM
> > To: Evergreen Discussion Group
> > Subject: Re: [OPEN-ILS-GENERAL] Reports
> >
> >
> >
> > Hi,
> >
> >
> >
> > Change the value for the "Cause ID" filter to 5 to limit to "Staff
> forced"
> > holds.
> >
> >
> >
> > On Tue, Jul 26, 2016 at 5:35 PM, Justin Bryant
> > <jbryant at clarendoncountylibrary.com> wrote:
> >
> > I attached two screenshots, let me know if you need any more!
> >
> >
> >
> > On 2016-07-26 4:25 pm, Elizabeth Davis wrote:
> >
> > Hello Justin,
> >
> > I would love to see this template you are referring to. Would you be
> > able to share it either via screenshots or a documentation of it?
> >
> > Thanks!
> >
> > Elizabeth Davis
> > Head of Digital Services
> > Scranton Public Library
> > 500 Vine Street
> > Scranton, PA 18509
> > 570-348-3000 ext. 3050
> > edavis at albright.org
> >
> >
> >
> > -----Original Message-----
> > From: Open-ils-general
> > [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf
> > Of Justin Bryant
> > Sent: Tuesday, July 26, 2016 2:11 PM
> > To: Evergreen Discussion Group <
> open-ils-general at list.georgialibraries.org>
> > Subject: Re: [OPEN-ILS-GENERAL] Reports
> >
> > This isn't a complete solution, but maybe it'll put you closer.
> >
> > If you go to SCLENDS shared folder, and Circulation, there's a report
> > template called "List of Patron Cancelled holds on Holds Shelf". This
> > report can be used to show items not on the Hold Shelf too. If you
> > clone the report and go to base filters, it has the 'Cause ID' as "6".
> > If you can determine what number equals staff cancellation, you'll
> > have your report. I've no idea which number that'd be tho'.
> >
> > On 2016-07-26 11:15, Forrest, Stuart wrote:
> >
> > Hi
> >
> > Does anyone know of a report I can use to list all of the holds
> > cancelled by staff in a certain period?
> >
> > Thanks
> >
> > Stuart
> >
> > ======================================================================
> > ==========
> >
> >
> > Stuart Forrest PhD
> >
> > Library Systems Specialist
> >
> > Beaufort County Library
> >
> > 843 255 6450
> >
> > sforrest at bcgov.net
> >
> > http://www.beaufortcountylibrary.org [1]
> >
> > For Leisure, For Learning, For Life
> >
> >
> >
> > Links:
> > ------
> > [1] http://www.beaufortcountylibrary.org/
> >
> >
> >
> >
> >
> > --
> >
> > Beth Willis
> > Digital & Catalog Librarian
> > NOBLE, Inc.
> > 26 Cherry Hill Drive
> > Danvers, MA 01923
>
>
> ------------------------------
>
> Message: 2
> Date: Thu, 28 Jul 2016 13:46:36 +0000
> From: Mina Edmondson <medmondson at yorklibraries.org>
> To: "'open-ils-general at list.georgialibraries.org'"
> <open-ils-general at list.georgialibraries.org>
> Subject: [OPEN-ILS-GENERAL] List of new items in catalog and how to
> get them on to your web page
> Message-ID:
> <9C819AB9B9575641A455170829ADAA77AE429D6C at Mail.yorklibraries.org>
> Content-Type: text/plain; charset="utf-8"
>
> I recall that someone at EV16 mentioned a report that they run on a
> routine basis that lists all the new items recently added to their catalog.
> This report is used to generate a feed to their web page that shows the
> title, author, book cover and links back to the item in the catalog.
>
> York County Libraries in Pennsylvania has been using a third party vendor
> to complete this process and is interested in doing this internally with
> our new website up grade.
>
> Does anyone have the report available and the coding needed to do the
> integration? I would like to feed this information to our website developer
> or at least make the connection.
>
> Mina C. Edmondson
> District Consultant
> York/Adams District
> medmondson at yorklibraries.org
>
> 717-849-6961- Office
> 717-916-0490- Cell
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160728/9a1bc6c6/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 3
> Date: Thu, 28 Jul 2016 10:48:23 -0400
> From: Chauncey Montgomery <chauncey at yourcl.org>
> To: open-ils-general at list.georgialibraries.org
> Subject: Re: [OPEN-ILS-GENERAL] List of new items in catalog and how
> to get them on to your web page
> Message-ID: <6a7e2120-a2b8-a70c-7384-1fee5fee1a1d at yourcl.org>
> Content-Type: text/plain; charset=windows-1252; format=flowed
>
> Mina,
>
> We use a process that was shared with us by the by the Branch District
> Library, <https://www.branchdistrictlibrary.org/>, years ago. It is
> based on a report that shows items added in the last X days.
>
> Following are details of the report:
>
> The report is based on the Item source.
>
> Displayed Fields:
> Item -> Call Number/Volume -> Bib Record -> Simple Record Extracts ->
> Title Proper (normalized) : data type is text; field transform is Raw Data
> Item -> Call Number/Volume -> Bib Record -> Simple Record Extracts ->
> Author (normalized) : data type is text; field transform is Raw Data
> Item -> Call Number/Volume -> Bib Record -> Simple Record Extracts ->
> Publication Year (normalized) : data type is int; field transform is Raw
> Data
> Item -> Call Number/Volume -> Bib Record -> Simple Record Extracts ->
> Record ID : data type is id; field transform is Raw Data
> Item -> Call Number/Volume -> Bib Record -> Simple Record Extracts ->
> ISBN : data type is text; field transform is Raw Data
> Item -> Call Number/Volume -> Call Number Label : data type is text;
> field transform is Raw Data
> Item -> Creation Date/Time : data type is timestamp; field transform is
> Date
> Item -> Circulating Library : data type is text; field transform is Raw
> Data
> Item -> Shelving Location : data type is text; field transform is Raw Data
>
> Base Filters:
> Item -> Creation Date/Time : field transform is Date; operator is Between
> Item -> Circulating Library : field transform is Raw Data; Operator is
> In list
>
> We then export the list to a csv file and put it on the server with a
> php file. Details on the original php can be found at
> <
> https://www.branchdistrictlibrary.org/professional/mieg_new_items_files/new_items_0.3.php.txt
> >.
>
> Here is what Branch District's list looks like:
> <https://www.branchdistrictlibrary.org/new>
>
> We hacked it a bit to shows summaries from the MARC record when you
> mouse over the cover image. Here is ours:
> <http://community.lib.oh.us/collections/?page=new>
>
> I'm sure I've missed some details or mistyped something, so let me know
> if you need more information.
>
> Cheers.
> CM
>
>
> On 07/28/2016 09:46 AM, Mina Edmondson wrote:
> > I recall that someone at EV16 mentioned a report that they run on a
> > routine basis that lists all the new items recently added to their
> > catalog. This report is used to generate a feed to their web page that
> > shows the title, author, book cover and links back to the item in the
> > catalog.
> >
> >
> >
> > York County Libraries in Pennsylvania has been using a third party
> > vendor to complete this process and is interested in doing this
> > internally with our new website up grade.
> >
> >
> >
> > Does anyone have the report available and the coding needed to do the
> > integration? I would like to feed this information to our website
> > developer or at least make the connection.
> >
> >
> >
> > Mina C. Edmondson
> >
> > District Consultant
> >
> > York/Adams District
> >
> > medmondson at yorklibraries.org
> >
> >
> >
> > 717-849-6961- Office
> >
> > 717-916-0490- Cell
> >
> >
> >
> >
> >
>
>
> End of Open-ils-general Digest, Vol 121, Issue 32
> *************************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160728/e5574726/attachment-0001.html>
More information about the Open-ils-general
mailing list