[Koha] Koha Digest, Vol 101, Issue 6
Quoc Uy
nguyenquocuy_1102 at yahoo.com
Wed Mar 5 02:05:42 NZDT 2014
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-request at lists.katipo.co.nz" <koha-request at lists.katipo.co.nz> wrote:
Send Koha mailing list submissions to
koha at 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-request at lists.katipo.co.nz
You can reach the person managing the list at
koha-owner at 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 <karamqubsi at gmail.com>
To: Nisreen Qabbani <nisreenqabbani at gmail.com>
Cc: koha koha <Koha at lists.katipo.co.nz>
Subject: Re: [Koha] number of bibliographic records
Message-ID:
<CAML=htYvPoVi4d57eqwgL=81QLk7QAcXY_HySBaT8tA_3QT4KA at 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 <nisreenqabbani at 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 <karamqubsi at 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 <
> > nisreenqabbani at 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 at lists.katipo.co.nz
> >> http://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >
> >
> >
> > --
> > *Karam Qubsi*
> >
> >
> >
> >
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha at 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 <nisreenqabbani at gmail.com>
To: Karam Qubsi <karamqubsi at gmail.com>
Cc: koha koha <Koha at lists.katipo.co.nz>
Subject: Re: [Koha] number of bibliographic records
Message-ID:
<CAM8WtzzYMshWOwP9U==ZNerf--zpr-00pbja57Joyybpn+GOvA at 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 <karamqubsi at 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 <nisreenqabbani at 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 <karamqubsi at 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 <
>> > nisreenqabbani at 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 at lists.katipo.co.nz
>> >> http://lists.katipo.co.nz/mailman/listinfo/koha
>> >>
>> >
>> >
>> >
>> > --
>> > *Karam Qubsi*
>>
>> >
>> >
>> >
>> >
>> _______________________________________________
>> Koha mailing list http://koha-community.org
>> Koha at 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 <oleonard at myacpl.org>
To: koha <koha at lists.katipo.co.nz>
Subject: Re: [Koha] using javascript functions with koha
Message-ID:
<CAO4qe2MBBtieN5g0-Xtoo_osDwib3S0pREG9fD_kX=CMvbvx7g at 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 <eb at efdss.org>
To: koha <koha at lists.katipo.co.nz>, Doug Kingston
<dpk at randomnotes.org>
Subject: [Koha] Vendor number in serials records
Message-ID:
<CAPdfUuyX_MyHaH2y4awonQcKUm9weZTfJx9OA+2YAFrL-kkmxQ at 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 <nengard at gmail.com>
To: Koha <Koha at lists.katipo.co.nz>
Subject: [Koha] AllowOfflineCirculation question
Message-ID:
<CAC0K6VHr-s2PLC1DO1poxSFckrbh+CLNaQN0MOD2uOzSjeZtDg at 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 <bgkriegel at gmail.com>
To: Elaine Bradtke <eb at efdss.org>
Cc: koha <koha at lists.katipo.co.nz>, Doug Kingston
<dpk at randomnotes.org>
Subject: Re: [Koha] Vendor number in serials records
Message-ID:
<CADF4kvQphn8H4fjwjifmFDAzscXwBHW_KHCf9pm74yG6jUTWDw at 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
bgkriegel at gmail.com
On Mon, Mar 3, 2014 at 4:43 PM, Elaine Bradtke <eb at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
------------------------------
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
End of Koha Digest, Vol 101, Issue 6
************************************
More information about the Koha
mailing list