[OPEN-ILS-GENERAL] bookbagupdate.pl

[Mike Rylander]

Jayaraj,

The error message suggests you're not including org_utils.js via a template
override, or including it too late.  Other than that, though, the evergreen
community at large won't be able to help you much, as that script is well
outside stock Evergreen, and the feature looks like it takes a good bit of
instance-specific tweaking to get working.

Sorry we can't help more...


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com


On Sat, Jul 4, 2015 at 4:52 AM, Jayaraj JR <jayaraj at iisertvm.ac.in> wrote:

>
> We have tried to implement book bag update system. We have done as per the
> instruction seen in the email discussion. We got the error message "
> Reference Error _tree_killer not found while inspecting the HTML output. I
> have checked the user book bag after running the perl script throgh
> crontab. No data (book details) is seen either in the user account book bag
> or in the OPAC home page. Kindly help to resolve the problem. The screen
> shot is attached.
>
> ----------------------------------
> Thanking You
>
> Jayaraj J R
> Library Information Assistant
> IISER Thiruvananthapuram
> Attachments area
> Preview attachment book_bag.jpg
>
> <https://mail.google.com/mail/u/0/?ui=2&ik=5c407d8536&view=att&th=14e535e0a96451ed&attid=0.2.3.0.1&disp=safe&realattid=f_ibng8sen0&zw>
>
> Included below is the log file we got after running the bookbag_update.pl
> file.
>
> 2015-07-01 17:04:45 :  ---------------- Script Starting ----------------
> 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('newitems','recentreturned','last14daytopcirc')
>
>     SELECT DISTINCT "REC" FROM
> (
> SELECT (SELECT RECORD FROM ASSET.CALL_NUMBER WHERE RECORD>0 AND RECORD IS
> NOT NULL AND
> ID=(SELECT CALL_NUMBER FROM ASSET.COPY WHERE ID=A.TARGET_COPY
> AND LOCATION IN(SELECT ID FROM ASSET.COPY_LOCATION WHERE OWNING_LIB
> IN(2,4) AND OPAC_VISIBLE AND HOLDABLE AND CIRCULATE) AND OPAC_VISIBLE AND
> HOLDABLE AND CIRCULATE AND ID != -1::BIGINT
> )) "REC",
> CHECKIN_SCAN_TIME::DATE FROM ACTION.CIRCULATION  A
> WHERE CIRC_LIB IN(2,4) AND
> CHECKIN_SCAN_TIME IS NOT NULL AND
> TARGET_COPY IN(SELECT ID FROM ASSET.COPY WHERE CALL_NUMBER IN(SELECT ID
> FROM ASSET.CALL_NUMBER WHERE RECORD>0 AND RECORD IS NOT NULL))
> ORDER BY
> CHECKIN_SCAN_TIME::DATE DESC LIMIT 200
> ) AS B
> ORDER BY "REC" DESC
> LIMIT 100
>
>      SELECT DISTINCT "REC",COUNT(*) FROM
>  (
> SELECT (SELECT RECORD FROM ASSET.CALL_NUMBER WHERE ID=(SELECT CALL_NUMBER
> FROM ASSET.COPY WHERE ID=A.TARGET_COPY) AND RECORD>0 AND RECORD IS NOT
> NULL) "REC"
> ,XACT_START::DATE
> FROM ACTION.CIRCULATION  A
> WHERE CIRC_LIB IN(2,4) AND
> (TARGET_COPY IN(SELECT ID FROM ASSET.COPY WHERE LOCATION IN(SELECT ID FROM
> ASSET.COPY_LOCATION WHERE OWNING_LIB IN(2,4) AND OPAC_VISIBLE AND HOLDABLE
> AND CIRCULATE) AND OPAC_VISIBLE AND HOLDABLE AND CIRCULATE AND ID !=
> -1::BIGINT)) AND
> XACT_START > NOW() - $$14 DAYS$$::INTERVAL
> ) AS B
> GROUP BY "REC"
> ORDER BY COUNT(*) DESC
> LIMIT 100
>
>
> SELECT * FROM
> (
>  SELECT DISTINCT "REC",
>  (SELECT MAX(CREATE_DATE::DATE) FROM ASSET.COPY WHERE CALL_NUMBER =
> (SELECT MAX(ID) FROM ASSET.CALL_NUMBER WHERE RECORD="REC")
>  AND CIRC_LIB IN(2,4)) "THEDATE"
>
>   FROM
> (
> 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(2,4)
> AND LOCATION IN(SELECT ID FROM ASSET.COPY_LOCATION WHERE OWNING_LIB
> IN(2,4) AND OPAC_VISIBLE AND HOLDABLE AND CIRCULATE) AND OPAC_VISIBLE AND
> HOLDABLE AND CIRCULATE AND ID != -1::BIGINT
> ORDER BY
> CREATE_DATE::DATE DESC LIMIT 300
> ) AS B
> ) AS C
> where C."THEDATE" IS NOT NULL
> ORDER BY C."THEDATE" DESC
> LIMIT 100
>
> 2015-07-01 17:04:46 :  ---------------- Script End ----------------
> --
> धन्यवाद ,
>
> जयराज जे आर                | Jayaraj J R
> पुस्तकालय सूचना सहायक | Library Information Assistant
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150706/3bd47253/attachment.html>