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, < [email protected]> wrote: > Send Open-ils-general mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: Evergreen Discussion Group > <[email protected]> > Subject: Re: [OPEN-ILS-GENERAL] Reports > Message-ID: > <CAO8ar== > [email protected]> > 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: [email protected] > | web: http://www.esilibrary.com > > > On Wed, Jul 27, 2016 at 1:09 PM, Forrest, Stuart <[email protected]> > 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 > > > > [email protected] > > > > > > > > http://www.beaufortcountylibrary.org > > > > > > > > For Leisure, For Learning, For Life > > > > > > > > > > > > > > > > From: Open-ils-general > > [mailto:[email protected]] 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 > > <[email protected]> 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 > > [email protected] > > > > > > > > -----Original Message----- > > From: Open-ils-general > > [mailto:[email protected]] On Behalf > > Of Justin Bryant > > Sent: Tuesday, July 26, 2016 2:11 PM > > To: Evergreen Discussion Group < > [email protected]> > > 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 > > > > [email protected] > > > > 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 <[email protected]> > To: "'[email protected]'" > <[email protected]> > Subject: [OPEN-ILS-GENERAL] List of new items in catalog and how to > get them on to your web page > Message-ID: > <[email protected]> > 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 > [email protected] > > 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 <[email protected]> > To: [email protected] > Subject: Re: [OPEN-ILS-GENERAL] List of new items in catalog and how > to get them on to your web page > Message-ID: <[email protected]> > 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 > > > > [email protected] > > > > > > > > 717-849-6961- Office > > > > 717-916-0490- Cell > > > > > > > > > > > > > End of Open-ils-general Digest, Vol 121, Issue 32 > ************************************************* >
