- Koha - lists.katipo.co.nz

SQL Help - Add barcode column to SQL query that searches subject keywords
by Jorge de Cardenas 17 Aug '16

17 Aug '16

I think will work for you: SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber= ',biblionumber,'\">',biblionumber,'</a>') AS bibnumber, lcsh,* barcode* FROM (SELECT biblionumber, *barcode*, EXTRACTVALUE(marcxml,'//datafield[@tag="690"]/subfield[@code>="a"]') AS lcsh FROM biblioitems LEFT JOIN items USING(biblionumber)) AS subjects WHERE lcsh LIKE <<Enter keyword surrounded BY %>> >Hi all, > >I'm trying to get the barcodes column from the items database to display on the results page after running the following SQL query: > >SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber= ',biblionumber,'\">',biblionumber,'</a>') >AS bibnumber, lcsh >FROM >(SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="690"]/subfield[@code>="a"]') >AS lcsh FROM biblioitems) >AS subjects >WHERE lcsh >LIKE <<Enter keyword surrounded BY %>> >WHERE biblionumber.biblionumber=items.barcode > > >The above I found on the Koha SQL library, but this query only displays the biblionumber and keyword query results in 690a. I'd like to add the barcodes column to the report. Can't seem figure out how to do this in this query. Help, please :) > >Many thanks! > >C > >Craig Butosi, MA, MLIS, B Mus (Hons.) >LIBRARY SERVICES MANAGER >the royal conservatory >TELUS Centre for Performance and Learning >273 Bloor Street West >Toronto, ON M5S 1W2 >416.408.2824 x338 >www.rcmusic.ca<http://www.rcmusic.ca/ -- Jorge de Cardenas | Head Systems Administrator 3512 Darrow Road, Stow, OH 44224 330 688-3295, ext 106 | FAX 330 688-0448 | www.smfpl.org | <http://www.facebook.com/SMFPL> <http://twitter.com/smfpl> <http://pinterest.com/smfpl/boards> If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the institution.

1 0

SQL Help - Add barcode column to SQL query that searches subject keywords
by Craig Butosi 17 Aug '16

17 Aug '16

Hi all, I'm trying to get the barcodes column from the items database to display on the results page after running the following SQL query: SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',biblionumber,'</a>') AS bibnumber, lcsh FROM (SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="690"]/subfield[@code>="a"]') AS lcsh FROM biblioitems) AS subjects WHERE lcsh LIKE <<Enter keyword surrounded BY %>> WHERE biblionumber.biblionumber=items.barcode The above I found on the Koha SQL library, but this query only displays the biblionumber and keyword query results in 690a. I'd like to add the barcodes column to the report. Can't seem figure out how to do this in this query. Help, please :) Many thanks! C Craig Butosi, MA, MLIS, B Mus (Hons.) LIBRARY SERVICES MANAGER the royal conservatory TELUS Centre for Performance and Learning 273 Bloor Street West Toronto, ON M5S 1W2 416.408.2824 x338 www.rcmusic.ca<http://www.rcmusic.ca/> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.

1 0

Re: [Koha] Using perl module Koha::Contrib::Tamil koha-auth
by Pedro Amorim 16 Aug '16

16 Aug '16

Hello Frédéric ! Thank you so much for replying my questions. 1) Yes '353.9(469)(094.4)' is supposed to be an authority that was just an example - 'Wilkens, H. J.' is another example. I think they are properly indexed as I can search for those exact terms and the results are returned in the intra interface. 2) Picking up on your comment on having a malformed biblio record, I had indeed some very incomplete records with no 6XX or 7XX in them, consequently no authorities to link and I thought that may be causing the behaviour. However, on a different import with all the records having authority info to link from, the same error is occurring. I think I might have figured part of the reason for 1) to be happening. In https://github.com/fredericd/Koha-Contrib-Tamil/blob/master/lib/Koha/Contri… Some characters, namely ',', are being stripped from the value and the authorities are being saved without the ',' character. Upon running the link task, ',' is still present in the biblios so the match fails. Does that make sense? Anyway, I think that's only part of the reason because there are some other authorities throwing not found warnings without any of those chars special chars. Yet another possible reason could be encoding causing the match to fail, for example 'Ossian, Séc. 3'. Another (probably) important piece of information is I have a UNIMARC installation, is there some particular (indexing) configuration required? Please let me know if any of this makes sense. Thank you, Pedro Amorim 2016-08-13 6:55 GMT+00:00 Frédéric Demians <f.demians(a)tamil.fr>: > > 1) For many biblios, the following message is presented: > > WARNING: authority not found -- 353.9(469)(094.4) > > > But said authority indeed exists and is indexed. > > Is '353.9(469)(094.4)' supposed to be an authority? If it's not found, it > means it isn't properly indexed. > > > 2) After about 400 biblios processed (I think), it throws this error and > it > > hangs printing "405" forever: > > > > > *** unhandled exception in callback: > > *** Quantifier follows nothing in regex; marked by <-- HERE in m/* <-- > > HERE / at > > /usr/local/share/perl/5.14.2/Koha/Contrib/Tamil/Authority/Li > nkBiblioTask.pm > > line 77. > > You must have a malformed biblio record. > > Kind regards, > -- > Frédéric DEMIANS > http://www.tamil.fr/fdemians >

1 0

Re: [Koha] Koha for beginners
by King, Fred 16 Aug '16

16 Aug '16

Hi Mehvish, and welcome to Koha. I tried to explain MARC tags to my mother last night and she fell asleep. I think that being in a hospital emergency room late at night right after a hefty dose of Dilaudid may have had something to do with it... (She'll be okay, BTW.) MARC is complicated, but makes sense after a while. Think of all the various ways you can describe a book, musical recording, film, etc. Author, publisher, year published, length, ISBN, ISSN, call number... well, you get the idea. Now give each element a number. For example, the title goes in the 245 field. The main part of the title goes into 245$a. If the book is "Arnold. The tale of a chipmunk" the second part goes into 245$somethingelseicantrememberbutmigjtbeb. Do that for every element you want to describe and you got yourself a MARC record. You don't have to do original cataloging on everything; see OCLC and Z39.50. I'm typing this on my iPhone so I'll let someone else explain those--my thumb is getting weary. One thing I love about Koha is that it's infinitely customizable (yes, literally). If you want to add or change something, you can. All the real catalogers just turned green upon reading that, but you can. I'm away from work right now and I'm astonished that I can get email at all, but I can follow up next week if you want. Have fun with Koha, Fred King Fred.king(a)medstar.net Sent with Good (www.good.com) -----Original Message----- From: Mehvish Farah [mehvishfarah(a)gmail.com<mailto:mehvishfarah@gmail.com>] Sent: Monday, August 15, 2016 01:25 PM Eastern Standard Time To: koha(a)lists.katipo.co.nz Subject: [Koha] Koha for beginners Hi, I am new to Koha and have no library science experience. I am trying to understand MARC but stuck at the terms where there are some numbers with a dollar sign and then an alphabet. What is this basically? I would be grateful if someone can help me with a book or link that helps understand these terms or library/koha terms in general or in easy comprehension. other thing that i want to know is if a book is bilingual (Spanish and English or Arabic and English) , what should i write in Lnaguage code clumn? Thanks *Mehvish* _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha 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.

2 1

customizing self check out cgi-bin/koha/sco/sco-main.pl help message
by schnydszch 16 Aug '16

16 Aug '16

I've been trying to figure out what to put in either SCOUserJS or OPACUserJS. Right now, instruction on how to use self check out can only be seen if the small help button is clicked. I'm trying to move the content of that in a more readable place, probably appending (?) in the main block (?), inspecting the elements, I see div class sco_entry, and I'm not sure that's the right selector in JQuery. Anybody who have tried putting instructions on how to use self check out that is not in SelfCheckHelpMessage which can only be read when the Help button is clicked? Can someone lead me on what to check? Or is it even possible? Appreciating your responses on my query. Cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/customizing-self-check-out-cgi-bin-koha-s… Sent from the Koha-general mailing list archive at Nabble.com.

3 6

Koha for beginners
by Mehvish Farah 16 Aug '16

16 Aug '16

Hi, I am new to Koha and have no library science experience. I am trying to understand MARC but stuck at the terms where there are some numbers with a dollar sign and then an alphabet. What is this basically? I would be grateful if someone can help me with a book or link that helps understand these terms or library/koha terms in general or in easy comprehension. other thing that i want to know is if a book is bilingual (Spanish and English or Arabic and English) , what should i write in Lnaguage code clumn? Thanks *Mehvish*

4 3

Re: [Koha] Koha for beginners
by Eric Phetteplace 16 Aug '16

16 Aug '16

Hi Mehvish, MARC is, unfortunately, a really difficult data format to understand without any library science background. The numbers are fields like author name, title statement, and subject while the letters prefixed with some symbol (often $, but ‡ is used too) is a subfield. So a 245 title field has title subfield $a, subtitle subfield $b, author statement $c, etc. The cataloging editor does link to some documentation but you can use the OCLC or Library of Congress sites to read more about field meanings: https://www.loc.gov/marc/bibliographic/ https://www.oclc.org/bibformats/en/about.html To answer your specific question about language codes, here's a quote from OCLC: - A single language code may be insufficient to describe the language of an item. If the item is multilingual or a translation, use multiple language codes. Enter the first code in Lang. Enter the multiple codes (including the first code) in field 041 (Language Code). - Use the predominant language code for a multilingual item that has two to six languages. If predominance cannot be determined, use the code that is first alphabetically. If the multilingual item has more than six languages, use the code for the language of the first title in field 245. If the item is multilingual with no predominant language and the cataloging institution has chosen not to specify a language, use code *mul*. https://www.oclc.org/bibformats/en/fixedfield/lang.html is the page where I found that. Hope that's helpful, good luck with your cataloging! Best, Eric Phetteplace Systems Librarian California College of the Arts libraries.cca.edu | vault.cca.edu 510.594.3660 2>/dev/null

1 0

Digital library
by Mehvish Farah 15 Aug '16

15 Aug '16

Can we create a digital library with Koha? I want to loan ebooks too. thanks *Mehvish*

1 0

Request to be added to the paid support directory
by Anna Bauer 15 Aug '16

15 Aug '16

Hi community! This is a request to be added to the paid support directory. Company Name: Kreablo Contact Person: Anna Bauer Contact email: anna.bauer(a)kreablo.se Website: http://kreablo.se Telephone: +46 (0)73 847 92 64 Categories: Europe, Sweden Right now we are migrating a small special library (30 000 bibliographic records, 3 000 patrons ...) from Libra to Koha. Regards /Anna -- ______________________________________ Anna Bauer Kreablo AB <http://kreablo.se/> email: anna.bauer(a)kreablo.se Cell: +46 (0)73 847 92 64 Skype: candidiabauer ______________________________________

1 0

Koha: Wipe Out of Data on Koha Demo Site- reg
by AklaEsmael 15 Aug '16

15 Aug '16

Hi, How Big is ur data? AklaEsmael

1 0