- Koha-devel - lists.koha-community.org

Re: [Koha-devel] [EXTERNAL] Re: [Koha] Extracting Frequency of a Serial From metadata
by RAGHAV ARORA 04 Jul '19

04 Jul '19

Thank you so much for your prompt reply. *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031 On Wed, Jul 3, 2019 at 8:47 PM Hernandez, Heather <heather_hernandez(a)nps.gov> wrote: > Hi! > > > Even this query gives certain ambiguous values like 'SM', 'BM', 'Q', > etc. > > What do these values mean? > > My guess is that the one & two letter values are abbreviations, e.g.: > SM = Semimonthly > BM = Bimonthly > Q = Quarterly > 0 = Irregular... > > Current cataloging under RDA (Resource Description and Access) avoids > abbreviations because they can be very ambiguous and confusing, so those > abbreviations might be able to be upgraded to the full words, if that is > what those abbreviations stand for. > > There is also a place for codes for frequencies in a MARC21 record, field > 008 position 18 in Continuing Resources records: > https://www.loc.gov/marc/bibliographic/bd008s.html > Perhaps those values in your records might help? > > Cheerio! > h2 > ~~~~~~~~~~~~~~ > Heather Hernandez (she, her, hers) > Technical Services Librarian > San Francisco Maritime National Historical Park Research Center > 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 > 415-561-7032, heather_hernandez(a)nps.gov > Library catalog: http://keys.bywatersolutions.com/ >

1 0

Object for cataloguing module in action_logs
by RAGHAV ARORA 03 Jul '19

03 Jul '19

Hello everyone, According to Koha Wiki <https://wiki.koha-community.org/wiki/SQL_Reports_Library#action_logs>, the object field of action_logs will contain the itemnumber or the biblionumber for 'Cataloguing' module depending on the 'info' field. I ran the query on my database, but found that the numbers listed under object match with neither itemnumber nor biblionumber. module action object info CATALOGUING ADD 225207 biblio CATALOGUING ADD 275336 item What do these numbers mean? Thanks in advance Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

2 1

Re: [Koha-devel] Super User Records
by RAGHAV ARORA 03 Jul '19

03 Jul '19

Okay sir, I really have been getting a lot of help from many people in the mailing list, and I am really grateful. I will not cross-post unnecessarily. Thank you *-Raghav Arora* On Wed, Jul 3, 2019 at 9:33 AM Indranil Das Gupta <indradg(a)l2c2.co.in> wrote: > Dear Raghav > > Frequent mails are not an issue. Cross posting is. > > Koha power users / devs who are subscribed to both the m/l tend to get > irritated if they keep receiving two copies of every mail. That tends to > get less answers too. So it's actually counter productive. > > You seem to be poking around koha and i like that as very few Indians do > that. Thus didn't want to you to lose the support traction you are getting > :-) > > Cheers > -idg > > > > On Wed 3 Jul, 2019, 9:28 AM RAGHAV ARORA, < > f20171016(a)pilani.bits-pilani.ac.in> wrote: > >> Hello Sir, >> Thank you for the clarification. I apologize for the frequent emails and >> queries, and will keep this in mind from now on. >> >> Regards >> *Raghav Arora* >> Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering >> Contact : (+91) 9897597761, 8474975691 >> Personal Email <raghavarora999(a)yahoo.in> | University Email >> <f20171016(a)pilani.bits-pilani.ac.in> >> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub >> <https://github.com/RAraghavarora/> >> >> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ >> *Birla Institute of Technology and Science, Pilani* >> Pilani campus, >> Rajasthan-333031 >> >> >> On Tue, Jul 2, 2019 at 6:03 PM Indranil Das Gupta <indradg(a)l2c2.co.in> >> wrote: >> >>> Hi Raghav, >>> >>> Your questions are welcome. But seriously you do not need to cross post >>> *every* single query. Once in a while, and if there is genuine merit in >>> cross-posting, is fine. This is considered as bad email etiquette on >>> mailing lists. >>> >>> What you are asking for is handled by Koha's action logs. The user >>> facing interface to the action logs is found under the Tools menu as 'log >>> viewer' >>> >>> Hope this helps >>> Indranil Das Gupta >>> L2C2 Technologies >>> >>> >>> On Tue 2 Jul, 2019, 2:23 PM RAGHAV ARORA, < >>> f20171016(a)pilani.bits-pilani.ac.in> wrote: >>> >>>> Hello everyone, >>>> >>>> Is there a way I can view the activities of various admin users who >>>> have special access to the koha portals. >>>> By activities, I mainly need the record of creating/modifying patrons, >>>> adding new books, creating/modifying /modifying vendors, creating/modifying >>>> baskets, orders, subscription to journals, etc. >>>> >>>> Can this be done? >>>> >>>> Thanks in advance >>>> Regards >>>> *Raghav Arora* >>>> Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics >>>> Engineering >>>> Contact : (+91) 9897597761, 8474975691 >>>> Personal Email <raghavarora999(a)yahoo.in> | University Email >>>> <f20171016(a)pilani.bits-pilani.ac.in> >>>> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub >>>> <https://github.com/RAraghavarora/> >>>> >>>> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ >>>> *Birla Institute of Technology and Science, Pilani* >>>> Pilani campus, >>>> Rajasthan-333031 >>>> _______________________________________________ >>>> Koha-devel mailing list >>>> Koha-devel(a)lists.koha-community.org >>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>>> website : http://www.koha-community.org/ >>>> git : http://git.koha-community.org/ >>>> bugs : http://bugs.koha-community.org/ >>> >>>

1 0

Super User Records
by RAGHAV ARORA 03 Jul '19

03 Jul '19

Hello everyone, Is there a way I can view the activities of various admin users who have special access to the koha portals. By activities, I mainly need the record of creating/modifying patrons, adding new books, creating/modifying /modifying vendors, creating/modifying baskets, orders, subscription to journals, etc. Can this be done? Thanks in advance Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761, 8474975691 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

2 2

18.05.14 Released
by Liz Rea 02 Jul '19

02 Jul '19

Kia ora koutou, The Koha community is pleased to announce the maintenance release of Koha version 18.05.14. This is a security release, all users of 18.05 are suggested to update to this version as soon as possible. Full release notes can be found at https://koha-community.org/18-05-14-released/ as well as download links. Thanks to Lucas Gass (previous 18.05 maintainer), Martiin Renvoize, and Chris Cormack for helping get this release out the door. Be well everyone, Liz Rea

1 0

Extracting Frequency of a Serial From metadata
by RAGHAV ARORA 02 Jul '19

02 Jul '19

Hello everyone, The SQL query to get the frequency for different serials was given on the KOHA SQL Library as : SELECT IF ( LOCATE('<datafield tag="310"', biblio_metadata.metadata) = 0 OR LOCATE('<subfield code="a">', biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)) = 0 OR LOCATE('<subfield code="a">', biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)) > LOCATE('</datafield>', biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)), '', SUBSTRING( biblio_metadata.metadata, LOCATE('<subfield code="a">', biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)) + 19, LOCATE('</subfield>', biblio_metadata.metadata, LOCATE('<subfield code="a">', biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)) + 19) - (LOCATE('<subfield code="a">',biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)) + 19) ) ) AS FREQUENCY When I run this query, it gives the output like 54/yr for some journals, which is correct, but for some, it returns something like 'M', '0', 'FN', 'SM', '#N/A', etc. Can someone please help me understand what should be the correct SQL query? Thanks in advance Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761, 8474975691 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

2 3

Re: [Koha-devel] [EXTERNAL] Re: [Koha] New Koha staff theme plugin
by Fridolin SOMERS 02 Jul '19

02 Jul '19

Here it is : https://github.com/biblibre/koha-plugin-theme-intranet-lsd/blob/master/Scre… Spoiler : Its main purpose is to create on a test/dev server an explicit visual difference with production server Best regards, Le 19/06/2019 à 19:00, King, Fred a écrit : > I was hoping for the same thing. Looks too scary for the likes of me. :-) > > Fred King > Medical Librarian, MedStar Washington Hospital Center > fred.king(a)medstar.net > 202-877-6670 > ORCID 0000-0001-5266-0279 > MedStar Authors Catalog: http://medstarauthors.org > > Honey, courage is just a lack of options. > --Fannie Lou Hamer > > -----Original Message----- > From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of Jonathan Druart > Sent: Wednesday, June 19, 2019 11:11 AM > To: Fridolin SOMERS <fridolin.somers(a)biblibre.com> > Cc: koha-devel <koha-devel(a)lists.koha-community.org>; koha(a)lists.katipo.co.nz > Subject: [EXTERNAL] Re: [Koha] New Koha staff theme plugin > > ** ATTENTION: This email originated from outside the MedStar network. ** DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe. > > Hi Frido, > Do you have screenshots? :) > Cheers, > Jonathan > > Le mer. 19 juin 2019 à 08:42, Fridolin SOMERS <fridolin.somers(a)biblibre.com> a écrit : >> >> Hi >> >> I'm proud to give you a new Koha staff theme plugin : >> https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_biblib >> re_koha-2Dplugin-2Dtheme-2Dintranet-2Dlsd&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r >> 3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EP >> RI&m=3-g9EE1ciZ6Ju5FFNho6VUlxfYYmrVty2XHMIcVCVCU&s=FSHnmEJENDw9uUPdoiL >> wClDExUiVUxO-NGj6glk3IHs&e= >> >> You should read the README ;) >> >> Have fun XD >> >> -- >> Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - >> software and system maintainer >> _______________________________________________ >> Koha mailing list >> https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.o >> rg&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjy >> C51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=3-g9EE1ciZ6Ju5FFNho6VUlxfYYmrVty2X >> HMIcVCVCU&s=F0cZrDFCbgJo4P8KOQLIyAjy-NAHy9T2TKToxsrir5g&e= >> Koha(a)lists.katipo.co.nz >> https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.n >> z_mailman_listinfo_koha&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVx >> j8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=3-g9EE1ciZ6Ju >> 5FFNho6VUlxfYYmrVty2XHMIcVCVCU&s=LyaGIEHLxUZAUm4vtqBmrbpwLr00Kynq2w1nz >> lwqbYI&e= > _______________________________________________ > Koha mailing list https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org&d=… > Koha(a)lists.katipo.co.nz > https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mai… > > ---------------------------------------------------------------------- > MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI. > > IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. > > Help conserve valuable resources - only print this email if necessary. > > -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer

1 0

Acquisition Reports - Orders Not Recieved
by RAGHAV ARORA 30 Jun '19

30 Jun '19

Hello everyone, The following link states that orders for books that have not been received is accessed by the aqorders for which datereceived is Null: Acquisition Reports - SQL Library <https://wiki.koha-community.org/wiki/SQL_Reports_Library#Acquisition_Reports> But this SQL query also makes use of the column biblio. Will record of an item exist in the biblio and biblioitems table before that item is received by the library? I understood that biblio and biblioitems are created after catalogging a book. Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

2 1

Koha Community Newsletter: June 2019
by kohanews 29 Jun '19

29 Jun '19

The Koha Community Newsletter for June 2019 is here: https://koha-community.org/koha-community-newsletter-june-2019/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Decision Support System for library.
by RAGHAV ARORA 28 Jun '19

28 Jun '19

Hello everyone, Does anyone know of good Decision-support software that can be used for decision making for library acquisitions based on Koha database? Or any framework/model I can refer to in the direction would be really helpful. Thanks in advance. Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761, 8474975691 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

1 0