[OPEN-ILS-GENERAL] Mobius Book Carousel Demoed at the EG Conference this year
Brent Mills
brent at hoodriverlibrary.org
Tue Jul 7 14:56:11 EDT 2015
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
>> *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
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/6050ccd5/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/20150707/6050ccd5/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/20150707/6050ccd5/attachment-0003.png>
More information about the Open-ils-general
mailing list