[OPEN-ILS-GENERAL] Mobius Book Carousel Demoed at the EG Conference this year

Tue Jul 7 18:15:31 EDT 2015

Thanks for the information guys.

Brent: I must be missing something on my end as I tried adding the name not in parameter as shown in your example and they still keep coming back (I removed them from the list and then would re-run the script to test). I used our shelving location for the magazines in question for the script (AND NAME NOT IN ('MAGAZINES','TEEN MAGAZINES')).

Blake: That may be a bit over my skill set at this time. The only thing I can find that resembles a log is a file named "1" after the script runs. That file looks like it just contains basic info (starting script, actual query run that shows the modifications I tried to make with Brent's information, refreshing bookbag # and an end script time).

Thanks again,

Jesse McCarty
City of Burlington
IT Technical Assistant

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Brent Mills
Sent: Tuesday, July 07, 2015 11:56 AM
To: open-ils-general at list.georgialibraries.org
Subject: Re: [OPEN-ILS-GENERAL] Mobius Book Carousel Demoed at the EG Conference this year

Jesse,

If it helps, we just did a simple NOT IN for our Magazine Copy Locations:

Example:

For updatebagNewItems:
SELECT (SELECT RECORD FROM ASSET.CALL_NUMBER WHERE ID=A.CALL_NUMBER AND RECORD>0 AND RECORD IS NOT NULL) \"REC\",CREATE_DATE::DATE
FROM ASSET.COPY  A WHERE CIRC_LIB IN($ous)
AND LOCATION IN(SELECT ID FROM ASSET.COPY_LOCATION WHERE OWNING_LIB IN($ous) AND OPAC_VISIBLE AND HOLDABLE AND CIRCULATE
AND NAME NOT IN ('MAGAZINES','PERIODICALS','ADULT MAGAZINES','CHILDREN''S MAGAZINES'))
AND OPAC_VISIBLE AND HOLDABLE AND CIRCULATE AND ID != -1::BIGINT
-Brent
On 7/7/15 10:17 AM, Blake Henderson wrote:
Jesse,

bookbag_update.pl  contains the queries that you are interested in changing. You can run them by hand using your own sql connection.

sub updatebagNewItems

sub updatebagRecentReturned

sub updatebag14daytopcirc

You can get some example queries directly out of the generated log from the script.

The subroutines contain the queries. You will need to copy those queries into your sql environment. Tweak the queries until they return what you want, then update the script with your new queries!

Keep in mind that $ous is replaced during run time. That variable will contain the comma separated list of Organizational Units that pertain to the scope of the book bag in question.

Good luck!

-Blake-

Conducting Magic

MOBIUS

573-234-4513

877-312-3517
On 7/7/2015 12:05 PM, Jesse McCarty wrote:
Is there a way to exclude specific items from the carousel, say exclude all items categorized as Serials and magazines from being added/udpated? That category seems to be our big offender on missing images and ends up the majority of the first set of images on the carousel. We removed them from the list, but once the update script runs again they are back in.

Thanks again for putting this together and helping out on the mailing list, it's a cool feature for the OPAC!

Jesse McCarty
City of Burlington
IT Technical Assistant

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Blake Henderson
Sent: Monday, June 29, 2015 7:06 PM
To: open-ils-general at list.georgialibraries.org<mailto:open-ils-general at list.georgialibraries.org>
Subject: Re: [OPEN-ILS-GENERAL] Mobius Book Carousel Demoed at the EG Conference this year

Jesse,

We have the same issue. Bibs that don't have a book jacket normally (in the OPAC), also don't have a book jacket in the carousel.

-Blake-

Conducting Magic

MOBIUS

573-234-4513

877-312-3517
On 6/29/2015 5:35 PM, Jesse McCarty wrote:
Thanks again! After adding the additional perl modules, making the recommended changes, installing an additional item with cpan and then running the script, I have everything up and running. Some items (mainly magazines) are not displaying photos of the item, but I am guessing this is an issue with our external content and not the book carousel?

[cid:image001.png at 01D0B8C3.11092590]

Jesse McCarty
City of Burlington
IT Technical Assistant

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Blake Henderson
Sent: Monday, June 29, 2015 12:43 PM
To: open-ils-general at list.georgialibraries.org<mailto:open-ils-general at list.georgialibraries.org>
Subject: Re: [OPEN-ILS-GENERAL] Mobius Book Carousel Demoed at the EG Conference this year

Jessie,

So, if you manually put something in those lists, the carousel shows them?

If you are having issues with the auto population, then you need to turn your attention to bookbag_update.pl. That perl script needs to run on a cron. It relys on a few perl custom perl modules:

Loghandler.pm
Mobiusutil.pm
DBhandler.pm

These are located in the parent directory:
https://github.com/mcoia/mobius_evergreen

You can just copy those files and put them into the same directory with bookbag_update.pl

You can comment out some of the stuff that Mobiusutil.pm is relying on:

use ZOOM;
use Net::FTP;

You can also comment out a dependency from DBhandler.pm

use DBD::Firebird;

so that you don't have to install those dependencies as they are not used for this.

The script looks at the bookbag's owner (the user that you used to create the list) and scopes the list to the owner's org unit's parent org unit. AKA the system level. If you don't want it to do that, you will need to alter the query:

SELECT ID,(SELECT PARENT_OU FROM ACTOR.ORG_UNIT WHERE ID=(SELECT HOME_OU FROM ACTOR.USR WHERE ID=A.OWNER)),DESCRIPTION FROM CONTAINER.BIBLIO_RECORD_ENTRY_BUCKET A WHERE DESCRIPTION IN(";

Change PARENT_OU to just ID if you want the list to only look at items at the branch level.

Good luck!

-Blake-

Conducting Magic

MOBIUS

573-234-4513

877-312-3517
On 6/29/2015 2:21 PM, Jesse McCarty wrote:
Blake,

Thanks for the information. Yes, I did get the code from Github and had placed all the files in the default location. After copying the .tt2 files to our /openils/var/templates_burlington/opac/parts/ folder (and editing to add the book bag #s) the three book bag titles are now appearing.

Now, the only issue is nothing is propagating into the three book bags (ones I created shown below). I created the lists with our circulation account from a web browser and all three are shared, should they be created with an admin account? Since this is not our production server, (running on slightly older data) I checked in/renewed books from my patron account via the staff client to try and get information into them, but still nothing has filled the lists. Do these book bags depend on any cron jobs to propagate?

[cid:image002.png at 01D0B8C3.11092590]

Thanks again!

Jesse McCarty
City of Burlington
IT Technical Assistant

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Blake Henderson
Sent: Monday, June 29, 2015 11:20 AM
To: open-ils-general at list.georgialibraries.org<mailto:open-ils-general at list.georgialibraries.org>
Subject: Re: [OPEN-ILS-GENERAL] Mobius Book Carousel Demoed at the EG Conference this year

Jesse,

Did you happen to get the code from Github?

https://github.com/mcoia/mobius_evergreen/tree/master/bookbag_update

There is a folder structure there intended to match the folder structure in /openilstemplat

/openils/var/web/opac/skin/default/js/carousel
and
/openils/var/web/templates/opac/parts

The various files belong to various places. If you are using a template override, book_carousel.tt2 needs to be in the base template folder otherwise the template toolkit breaks.

Be sure and edit book_carousel.tt2 and replace the numbers with your bookbag id numbers.

If you are getting nothing, then you might need to inspect the resulting html page and look for
<div id="hidden_bb_info" class="hide_me">

Check to see if that div has any content. If not, the javascript stuff isn't working. If it does, then take a careful look at your CSS. The jquery plugin jcarousel is picky about the CSS. If you just use the CSS example from Github, it should work but it never hurts to double check.

I would be happy to take a look at what you have.

-Blake-

Conducting Magic

MOBIUS

573-234-4513

877-312-3517
On 6/29/2015 11:56 AM, Jesse McCarty wrote:
Hello All,

Has anyone implemented the Book Carousel that Mobius demoed at the conference this year? (http://slides.mobiusconsortium.org/blake/bookcarousel/#/1). I have been going over the slides trying to implement this on our test server with no luck so far. I have placed the appropriate .tt2 files in their locations and created lists with our circulation account, but nothing is showing up either in the lists or on our OPAC. Are there additional instructions online somewhere that I am missing? Extra details: we have four libraries running on our system and at this point we are only looking to implement it for one.

Thanks!

Jesse McCarty
City of Burlington
IT Technical Assistant

--

Brent Mills

Systems Librarian | Sage Library System

email: brent at hoodriverlibrary.org<mailto:brent at hoodriverlibrary.org>

tickets: sagelib.org/support

desk/mobile: 541.387.5063 / 541.610.8384
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150707/9197624e/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 245138 bytes
Desc: image001.png
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150707/9197624e/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 55614 bytes
Desc: image002.png
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150707/9197624e/attachment-0003.png>