I have a question about customizing searching results. I have made a MARC field (300_6) clickable with link to download ebook. How to display this field on the searching results page? And more, how can i create a new tab on opac-detail page (near tabs HOLDING and COMMENTS) to display 300_6 field above with download link. I saw in my library OPAC detail, there is a tab "Title notices" show 521b field. Thanks all! Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn & http://vietnamlib.net
On Tuesday, March 4, 2014 3:00 AM, "koha-requ...@lists.katipo.co.nz" <koha-requ...@lists.katipo.co.nz> wrote: Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-requ...@lists.katipo.co.nz You can reach the person managing the list at koha-ow...@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: number of bibliographic records (Karam Qubsi) 2. Re: number of bibliographic records (Nisreen Qabbani) 3. Re: using javascript functions with koha (Owen Leonard) 4. Vendor number in serials records (Elaine Bradtke) 5. AllowOfflineCirculation question (Nicole Engard) 6. Re: Vendor number in serials records (Bernardo Gonzalez Kriegel) ---------------------------------------------------------------------- Message: 1 Date: Mon, 3 Mar 2014 17:13:57 +0800 From: Karam Qubsi <karamqu...@gmail.com> To: Nisreen Qabbani <nisreenqabb...@gmail.com> Cc: koha koha <Koha@lists.katipo.co.nz> Subject: Re: [Koha] number of bibliographic records Message-ID: <CAML=htYvPoVi4d57eqwgL=81qlk7qacxy_hysbat8ta_3qt...@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 hi you should put the user id no. not the username . it's something like : (1 , 2 , 3 ... ) you can check the userid from the user record . Best regards On Mon, Mar 3, 2014 at 2:53 PM, Nisreen Qabbani <nisreenqabb...@gmail.com>wrote: > Have tried that > But there was a problem > After placing > > SELECT l.action, count(l.timestamp) AS 'bibs' > FROM action_logs l > LEFT JOIN borrowers p ON (p.borrowernumber=l.user) > WHERE module='CATALOGUING' > AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and > (yyyy-mm-dd)>> > AND l.info!='item' AND user=<<user no.>> > GROUP BY l.action > > > The origin of the SQL reports > And specify the date and name > Does not show results, but shows the same instructions > What is the problem > > > > On Wed, Feb 19, 2014 at 5:34 AM, Karam Qubsi <karamqu...@gmail.com> wrote: > > > Hi , > > in my library I'm using this report , and I think this is the same report > > you want : > > > > SELECT l.action, count(l.timestamp) AS 'bibs' > > FROM action_logs l > > LEFT JOIN borrowers p ON (p.borrowernumber=l.user) > > WHERE module='CATALOGUING' > > AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and > > (yyyy-mm-dd)>> > > AND l.info!='item' AND user=<<user no.>> > > GROUP BY l.action > > > > > > this report will ask you for date range and cataloger no . then the > > results would be something like this : > > > > action bibs ADD 193 DELETE 10 MODIFY 1010 > > Note : the above report is modified by me the source is here : > > http://wiki.koha-community.org/wiki/SQL_Reports_Library where the report > > name there is : > > > > - 5.83 Bib records added/deleted in time frame< > http://wiki.koha-community.org/wiki/SQL_Reports_Library#Bib_records_added.2Fdeleted_in_time_frame> > developed > > by Nicole C. Engard, ByWater Solutions > > - > > > > Best wishes . > > > > > > On Thu, Feb 13, 2014 at 11:21 PM, Nisreen Qabbani < > > nisreenqabb...@gmail.com> wrote: > > > >> Hello > >> Can you help me how to know the number of bibliographic records for each > >> employee account > >> > >> Thank you very much > >> _______________________________________________ > >> Koha mailing list http://koha-community.org > >> Koha@lists.katipo.co.nz > >> http://lists.katipo.co.nz/mailman/listinfo/koha > >> > > > > > > > > -- > > *Karam Qubsi* > > > > > > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- *Karam Qubsi* ------------------------------ Message: 2 Date: Mon, 3 Mar 2014 13:04:01 +0300 From: Nisreen Qabbani <nisreenqabb...@gmail.com> To: Karam Qubsi <karamqu...@gmail.com> Cc: koha koha <Koha@lists.katipo.co.nz> Subject: Re: [Koha] number of bibliographic records Message-ID: <CAM8WtzzYMshWOwP9U==znerf--zpr-00pbja57joyybpn+g...@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Oak Iam Going to try it Thanks Karam On Mon, Mar 3, 2014 at 12:13 PM, Karam Qubsi <karamqu...@gmail.com> wrote: > hi you should put the user id no. > not the username . > it's something like : (1 , 2 , 3 ... ) > you can check the userid from the user record . > > Best regards > > > On Mon, Mar 3, 2014 at 2:53 PM, Nisreen Qabbani > <nisreenqabb...@gmail.com>wrote: > >> Have tried that >> But there was a problem >> After placing >> >> SELECT l.action, count(l.timestamp) AS 'bibs' >> FROM action_logs l >> LEFT JOIN borrowers p ON (p.borrowernumber=l.user) >> WHERE module='CATALOGUING' >> AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and >> (yyyy-mm-dd)>> >> AND l.info!='item' AND user=<<user no.>> >> GROUP BY l.action >> >> >> The origin of the SQL reports >> And specify the date and name >> Does not show results, but shows the same instructions >> What is the problem >> >> >> >> On Wed, Feb 19, 2014 at 5:34 AM, Karam Qubsi <karamqu...@gmail.com> >> wrote: >> >> > Hi , >> > in my library I'm using this report , and I think this is the same >> report >> > you want : >> > >> > SELECT l.action, count(l.timestamp) AS 'bibs' >> > FROM action_logs l >> > LEFT JOIN borrowers p ON (p.borrowernumber=l.user) >> > WHERE module='CATALOGUING' >> > AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and >> > (yyyy-mm-dd)>> >> > AND l.info!='item' AND user=<<user no.>> >> > GROUP BY l.action >> > >> > >> > this report will ask you for date range and cataloger no . then the >> > results would be something like this : >> > >> > action bibs ADD 193 DELETE 10 MODIFY 1010 >> > Note : the above report is modified by me the source is here : >> > http://wiki.koha-community.org/wiki/SQL_Reports_Library where the >> report >> > name there is : >> > >> > - 5.83 Bib records added/deleted in time frame< >> http://wiki.koha-community.org/wiki/SQL_Reports_Library#Bib_records_added.2Fdeleted_in_time_frame> >> developed >> >> > by Nicole C. Engard, ByWater Solutions >> > - >> > >> > Best wishes . >> > >> > >> > On Thu, Feb 13, 2014 at 11:21 PM, Nisreen Qabbani < >> > nisreenqabb...@gmail.com> wrote: >> > >> >> Hello >> >> Can you help me how to know the number of bibliographic records for >> each >> >> employee account >> >> >> >> Thank you very much >> >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> >> Koha@lists.katipo.co.nz >> >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> > >> > >> > >> > -- >> > *Karam Qubsi* >> >> > >> > >> > >> > >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > > > -- > *Karam Qubsi* > > > > ------------------------------ Message: 3 Date: Mon, 3 Mar 2014 09:18:44 -0500 From: Owen Leonard <oleon...@myacpl.org> To: koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] using javascript functions with koha Message-ID: <CAO4qe2MBBtieN5g0-Xtoo_osDwib3S0pREG9fD_kX=cmvbv...@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 > Unfortunately I cam not sure where I can place them as the 'opacuserjs' only > accepts javascript embedded in: > > $(document).ready(function(){}); That isn't true. The opacuserjs preference accepts any kind of inline JavaScript you want to put in it. Anything which would normally be included inside <script> tags on your page. > Below I have posted the two functions. Do i have to create a separate > javascript file and reference it or can the fuctions be editted to work in > 'opacuserjs'? No, you can embed this code in opacuserjs. But it looks to me like the code is intended to work with an onclick event attached to an element on the page. What is the script intended to do? Do you have a working example outside of Koha? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ------------------------------ Message: 4 Date: Mon, 3 Mar 2014 19:43:02 +0000 From: Elaine Bradtke <e...@efdss.org> To: koha <koha@lists.katipo.co.nz>, Doug Kingston <d...@randomnotes.org> Subject: [Koha] Vendor number in serials records Message-ID: <capdfuuyx_myhah2y4awonqckum9weztfjx9oa+2yafrl-kk...@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 We have over 200 active serial subscriptions, and 195 different vendors (ah, the joys of an esoteric collection). The vendor information has been successfully converted and uploaded to our test site. This in turn generated vendor numbers, which have been extracted so we know which serial should link to what vendor number. It would be a simple thing to add these vendor numbers to the serials records during the conversion process prior to upload. But, unless I'm missing something, this number doesn't go into the MARC record. If it does, what field (MARC 21)? Where would the vendor number need to go in order to add the vendor number to the incoming serials records? Another table in the database? I hope this is doable, otherwise my colleague who deals with the serials is going to have a tedious job manually linking them. -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ------------------------------ Message: 5 Date: Mon, 3 Mar 2014 16:36:03 -0600 From: Nicole Engard <neng...@gmail.com> To: Koha <Koha@lists.katipo.co.nz> Subject: [Koha] AllowOfflineCirculation question Message-ID: <cac0k6vhr-s2plc1do1poxsfckrbh+clnaqn0mod2uozsjez...@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Documentation question: If I have AllowOfflineCirculation set to allow, then when I go offline what URL do I go to to circulate? Or is it the regular URL I always used for check in / check out? Thanks Nicole ------------------------------ Message: 6 Date: Mon, 3 Mar 2014 19:45:50 -0300 From: Bernardo Gonzalez Kriegel <bgkrie...@gmail.com> To: Elaine Bradtke <e...@efdss.org> Cc: koha <koha@lists.katipo.co.nz>, Doug Kingston <d...@randomnotes.org> Subject: Re: [Koha] Vendor number in serials records Message-ID: <cadf4kvqphn8h4fjwjifmfdazscxwbhw_khcf9pm74yg6jut...@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Elaine, perhaps MARC21 037 (http://www.loc.gov/marc/bibliographic/bd037.html) Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Mon, Mar 3, 2014 at 4:43 PM, Elaine Bradtke <e...@efdss.org> wrote: > We have over 200 active serial subscriptions, and 195 different vendors > (ah, the joys of an esoteric collection). The vendor information has been > successfully converted and uploaded to our test site. This in turn > generated vendor numbers, which have been extracted so we know which serial > should link to what vendor number. > It would be a simple thing to add these vendor numbers to the serials > records during the conversion process prior to upload. But, unless I'm > missing something, this number doesn't go into the MARC record. If it > does, what field (MARC 21)? > > Where would the vendor number need to go in order to add the vendor number > to the incoming serials records? Another table in the database? > > I hope this is doable, otherwise my colleague who deals with the serials is > going to have a tedious job manually linking them. > > -- > Elaine Bradtke > Data Wrangler > VWML > English Folk Dance and Song Society | http://www.efdss.org > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY > Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and > Song Society in London, England. If you wish to phone me personally, send > an e-mail first. I work off site) > -------------------------------------------------------------------------- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > --------------------------------------------------------------------------- > "Writing about music is like dancing about architecture" > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 101, Issue 6 ************************************ _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
