[OPEN-ILS-GENERAL] Mobius Book Carousel Demoed at the EG Conference this year
Blake Henderson
blake at mobiusconsortium.org
Wed Jul 8 09:22:33 EDT 2015
Jesse,
It is case sensitive. You need to list your shelving locations exactly
how they are in the staff client.
-Blake-
Conducting Magic
MOBIUS
573-234-4513
877-312-3517
On 7/7/2015 5:15 PM, Jesse McCarty wrote:
>
> 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?
>
> 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?
>
> 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/20150708/4c4b75fe/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 245138 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150708/4c4b75fe/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 55614 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150708/4c4b75fe/attachment-0003.png>
More information about the Open-ils-general
mailing list