Thanks Nicole. I think I've still got something wrong. Our framework didn't have a 008 field so I created one. Now when I'm editing a record I have the "..." next to the field and when I click on it I am able to enter the 3-character language code in 35-37. But whenever I try to search by Language I am getting "No Results found." On a side note, we were wondering if our patrons would have to use the 3-character code when searching in the OPAC. We want them to be able to enter "French" for example. Would that work? Thank you, Melisa On Thu, Sep 17, 2009 at 7:17 PM, Nicole Engard <nengard@gmail.com> wrote:

This is pulling from the language coded in the leader - http://www.oclc.org/bibformats/en/fixedfield/default.shtm

...

Hello,

On the OPAC Advanced Search page one of the search options on the drop down list is "Language." Our collection contains a lot of foreign language films and it was my understanding we could use this field to search for all films in a particular language. Does anyone know the MARC tag that links to

...

search field? I've tried different ones, but have been unable to find

2009/9/17 Melisa Canales <mcanales29@gmail.com>: this the

...

right one. Or maybe my understanding of the search field is incorrect...

Thank you, Melisa Canales

_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

The list of 3-letter codes for this field is rather extensive: http://www.loc.gov/marc/languages/langhome.html But I suppose it wouldn't be too difficult to add a drop-down field for advance search that at least covers some of the major languages: Language Code English eng French fre German ger Greek grc Italian ita Latin lat Multiple (text in more than one language) mul Portuguese por Russian rus Spanish spa Undetermined und Items with no text (e.g. instrumental music scores, all illustrated Blank (from http://tinyurl.com/kpupn4 ) That would append "ln:[3-letter code]" to your search. For example: http://hartford.waldo.kohalibrary.com/cgi-bin/koha/opac-search.pl?q=monde+an... Thanks, -- Ben 2009/9/21 Kohn, Karen <kohnk@arcadia.edu>:

I am having the same problem.  A faculty member just asked the other day for a list of books in certain languages, so I was glad to see Melisa’s question.   I’d like to figure out if this is a bug, or if there’s something I can do as an administrator (i.e., not a coder) to fix it.  If anyone knows of a workaround for now, that would be good, too.

Thanks.

Karen Kohn

Collection Development Manager

Landman Library

Arcadia University

450 S. Easton Road

Glenside, PA  19038

ph: 215-572-8528

fax: 215-572-0240

From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Melisa Canales Sent: Friday, September 18, 2009 12:17 PM To: Nicole Engard Cc: koha Subject: Re: [Koha] How to search by Language on OPAC?

Thanks Nicole.  I think I've still got something wrong.  Our framework didn't have a 008 field so I created one.  Now when I'm editing a record I have the "..." next to the field and when I click on it I am able to enter the 3-character language code in 35-37.  But whenever I try to search by Language I am getting "No Results found."

On a side note, we were wondering if our patrons would have to use the 3-character code when searching in the OPAC.  We want them to be able to enter "French" for example.  Would that work?

Thank you, Melisa

On Thu, Sep 17, 2009 at 7:17 PM, Nicole Engard <nengard@gmail.com> wrote:

This is pulling from the language coded in the leader - http://www.oclc.org/bibformats/en/fixedfield/default.shtm

2009/9/17 Melisa Canales <mcanales29@gmail.com>:

...

Hello,

On the OPAC Advanced Search page one of the search options on the drop down list is "Language."  Our collection contains a lot of foreign language films and it was my understanding we could use this field to search for all films in a particular language.  Does anyone know the MARC tag that links to this search field?  I've tried different ones, but have been unable to find the right one.  Or maybe my understanding of the search field is incorrect...

Thank you, Melisa Canales

...

_______________________________________________ Koha mailing list 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

ln:[language code] does not work as it also picks up the original language of a translation, language of movie subtitles, & probably a few more. So ln:fre picks up works translated from French into English ... not the desired effect. Cab Vinton, Director Sanbornton Public Library Sanbornton, NH

Hi. It looks as if the search by language is broken at the current (Head) version. Any search using the "Language" pulldown returns nothing. Search keyword (not language) will pick out the text of the three-character language code from the 008 fixed field and it will also search the text in the 041 "Language" tag. Note the text in the 041 should be three-character codes, all next to eachother with no spaces or punctuation. If you have two languages (say German and Hungarian = gerhun in the 041), then Koha searching as currently configured will not search them separately but will search the combined "word" (in this gace "gerhun"). In many cases you should be able to find titles with the language code set in the 008 fixed field by just searching as "keyword". However depending how you have configured fuzzy searching and the like in system preferences you may also pick up words with the same stem (eg search on "eng" also picks up "engineering" etc). Does anyone know if you can qualify a search to a particular MARC tag by entering something in the search field (eg: "fre{041}" or similar)? If it is not in bugzilla that language searching is not working it should be raised. Ian ----- Original Message ----- From: Kohn, Karen To: koha Sent: Monday, September 21, 2009 3:41 PM Subject: Re: [Koha] How to search by Language on OPAC? I am having the same problem. A faculty member just asked the other day for a list of books in certain languages, so I was glad to see Melisa's question. I'd like to figure out if this is a bug, or if there's something I can do as an administrator (i.e., not a coder) to fix it. If anyone knows of a workaround for now, that would be good, too. Thanks. Karen Kohn Collection Development Manager Landman Library Arcadia University 450 S. Easton Road Glenside, PA 19038 ph: 215-572-8528 fax: 215-572-0240 From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Melisa Canales Sent: Friday, September 18, 2009 12:17 PM To: Nicole Engard Cc: koha Subject: Re: [Koha] How to search by Language on OPAC? Thanks Nicole. I think I've still got something wrong. Our framework didn't have a 008 field so I created one. Now when I'm editing a record I have the "..." next to the field and when I click on it I am able to enter the 3-character language code in 35-37. But whenever I try to search by Language I am getting "No Results found." On a side note, we were wondering if our patrons would have to use the 3-character code when searching in the OPAC. We want them to be able to enter "French" for example. Would that work? Thank you, Melisa On Thu, Sep 17, 2009 at 7:17 PM, Nicole Engard <nengard@gmail.com> wrote: This is pulling from the language coded in the leader - http://www.oclc.org/bibformats/en/fixedfield/default.shtm 2009/9/17 Melisa Canales <mcanales29@gmail.com>:

Hello,

On the OPAC Advanced Search page one of the search options on the drop down list is "Language." Our collection contains a lot of foreign language films and it was my understanding we could use this field to search for all films in a particular language. Does anyone know the MARC tag that links to this search field? I've tried different ones, but have been unable to find the right one. Or maybe my understanding of the search field is incorrect...

Thank you, Melisa Canales

_______________________________________________ Koha mailing list 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 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.111/2386 - Release Date: 09/21/09 05:51:00

There is a bug report for this very issue - including some discussion with a developer: http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=2559 Nicole 2009/9/21 Chris Mueller <catsalsa@gmail.com>:

Using the 041 MARC field to search for works in a specific language will not return all works in your database in the specific language. Field 041 is *not* coded in all records, only in exceptions.

The MARC21 field definition/scope of the 041 field @ http://www.loc.gov/marc/bibliographic/bd041.html explains --

"Codes for languages associated with an item when the language code in field 008/35-37 of the record is insufficient to convey full information. Includes records for multilingual items, items that involve translation..."

"Used when one or more of the following conditions exist: -- The item contains more than one language... -- The item is or includes a translation -- The language of the summaries, abstracts, or accompanying material differs from the language of the main item -- The language of a table of contents differs from the language of the main item"

Example: If an item is in Spanish and is *not* a translation and has no other language in the item, the 041 field should not be coded per MARC21 standards. The only way you can retrieve such an item is through field 008/35-37.

If you do want to search the 041 -- to find translations perhaps -- there is a challenge not mentioned in this thread: "In 2001: the practice of placing multiple language codes in one subfield, e.g., $aengfreger, was made obsolete and subfields $a, $b, $d, $e, $f and $g were changed from Not-repeatable (NR) to Repeatable (R). The field was also changed from Not-repeatable (NR) to Repeatable (R) to accommodate non-MARC language codes." [same URL as above] Unless your database has only very recent imprints it's probable that you have items with 041 field coded according to the new standard as well as the old standard.

A way for patrons to search for items where the predominate language can be selected from a pick list where the language is expressed in its full form and not as a 3-character code is muy importante!

Christine Mueller Database Administrator Office of Information Technology New Mexico State Library 1209 Camino Carlos Rey Santa Fe, NM 87507 Phone: 505-476-9744 christine.mueller@state.nm.us http://www.stlib.state.nm.us/

2009/9/17 Melisa Canales <mcanales29@gmail.com>

...

Hello,

On the OPAC Advanced Search page one of the search options on the drop down list is "Language."  Our collection contains a lot of foreign language films and it was my understanding we could use this field to search for all films in a particular language.  Does anyone know the MARC tag that links to this search field?  I've tried different ones, but have been unable to find the right one.  Or maybe my understanding of the search field is incorrect...

Thank you, Melisa Canales

_______________________________________________ Koha mailing list 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

On Sep 21, 2009, at 19:37 , Chris Mueller wrote:

A way for patrons to search for items where the predominate language can be selected from a pick list where the language is expressed in its full form and not as a 3-character code is muy important

This is my opinion too. sb