[Koha] Improving the advanced search form

Mason James mtj at kohaaloha.com
Fri Oct 26 01:00:31 NZDT 2012


On 2012-10-25, at 5:27 PM, Sunil Kumar wrote:

> Dear All, 
> 
> I agree with the same, I always had problem in advance search especially for
> the barcode based search.
> 
> Even if I select the barcode as search option and enter the specific barcode
> number, Koha opac always show all the titles wherever that specific number
> is entered. But other that the barcode number. 


hmm, i just tested this on Koha 3.8.5

it works fine for me...


ps: edit your email, before replying to digest messages

> 
> Is there any solution for the same?
> 
> Thanks and Regards
> 
> R Sunil Kumar
> Library Technologist
> 
> 
> 
> 
> -----Original Message-----
> From: koha-bounces at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
> koha-request at lists.katipo.co.nz
> Sent: 25 October 2012 09:53
> To: koha at lists.katipo.co.nz
> Subject: Koha Digest, Vol 84, Issue 46
> 
> 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. Improving the advanced search form (Srikanth Dhondi)
>   2. Re: Improving the advanced search form (Chris Cormack)
>   3. Re: Improving the advanced search form (Gay Richards)
>   4. Re: Data Migration (Dennis Njuguna) (Sunil Kumar)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Thu, 25 Oct 2012 14:55:31 +1300
> From: Srikanth Dhondi <srikanth at catalyst.net.nz>
> To: koha at lists.katipo.co.nz
> Subject: [Koha] Improving the advanced search form
> Message-ID: <50889C13.9080505 at catalyst.net.nz>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> Hi there,
> 
> I am currently working on improving accessibility of koha opac site with our
> accessibility expert.
> One of the things we noticed is that the advanced search option is not only
> confusing for blind users but also even for normal users.
> 
> I have noticed the following issues with it:
> 
> 1) By default the Fewer Options option is selected, which is not obvious to
> the normal users until they click on More Options.
> 
> 2) The layout could be a lot better, in particular the Fewer Options search
> form is quite abstract in what it does.
> 
> For example, the default boolean operator is AND which is not obvious to
> even normal user.
> 
> In my opinion, layout similar to the one http://kea.massey.ac.nz/search/X,
> is better.
> 
> Looking forward to your comments/feedback.
> 
> Srikanth
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Thu, 25 Oct 2012 15:03:21 +1300
> From: Chris Cormack <chris at bigballofwax.co.nz>
> To: Srikanth Dhondi <srikanth at catalyst.net.nz>
> Cc: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Improving the advanced search form
> Message-ID:
> 	<CA+95qVR9P0U4Wynn2p0PWP3Wb37J+7SSiMu1xjvZs1kbq=9=nw at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
> 
> On 25 October 2012 14:55, Srikanth Dhondi <srikanth at catalyst.net.nz> wrote:
>> Hi there,
>> 
>> I am currently working on improving accessibility of koha opac site 
>> with our accessibility expert.
>> One of the things we noticed is that the advanced search option is not 
>> only confusing for blind users but also even for normal users.
>> 
>> I have noticed the following issues with it:
>> 
>> 1) By default the Fewer Options option is selected, which is not 
>> obvious to the normal users until they click on More Options.
>> 
>> 2) The layout could be a lot better, in particular the Fewer Options 
>> search form is quite abstract in what it does.
>> 
>> For example, the default boolean operator is AND which is not obvious 
>> to even normal user.
>> 
>> In my opinion, layout similar to the one 
>> http://kea.massey.ac.nz/search/X, is better.
>> 
> I'm going to disagree and say that site is horrid :)
> 
> Maybe others will have different opinions though.
> 
> Chris
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Thu, 25 Oct 2012 02:45:24 +0000
> From: Gay Richards <g.richards at auckland.ac.nz>
> To: 'Chris Cormack' <chris at bigballofwax.co.nz>, Srikanth Dhondi
> 	<srikanth at catalyst.net.nz>
> Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Improving the advanced search form
> Message-ID:
> 	
> <AB44DEB8CF4F784F90EBCDBBD9B817376D7E2714 at uxcn10-5.UoA.auckland.ac.nz>
> Content-Type: text/plain; charset="us-ascii"
> 
> Agree advanced search could and should be improved, but don't like example
> suggested.
> 
> I generallly like the "look: of the Koha advanced search page. The problem
> (apart from any accessibility issues) is that some functions don't work as
> one might expect - as outlined below. Also:
> 
> We would like to turn off or limit languages to onees that are actually
> available in our catalog.
> 
> The Search for additional content types is really misleading as it relies on
> codes from marc field 008 which may or may not have been used.
> I'm sure I have other issues with this screen and I would be keen to discuss
> any improvements further. We support anything that makes it more accessible
> too.  Gay
> 
> -----Original Message-----
> From: koha-bounces at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Chris Cormack
> Sent: Thursday, 25 October 2012 3:03 p.m.
> To: Srikanth Dhondi
> Cc: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Improving the advanced search form
> 
> On 25 October 2012 14:55, Srikanth Dhondi <srikanth at catalyst.net.nz> wrote:
>> Hi there,
>> 
>> I am currently working on improving accessibility of koha opac site 
>> with our accessibility expert.
>> One of the things we noticed is that the advanced search option is not 
>> only confusing for blind users but also even for normal users.
>> 
>> I have noticed the following issues with it:
>> 
>> 1) By default the Fewer Options option is selected, which is not 
>> obvious to the normal users until they click on More Options.
>> 
>> 2) The layout could be a lot better, in particular the Fewer Options 
>> search form is quite abstract in what it does.
>> 
>> For example, the default boolean operator is AND which is not obvious 
>> to even normal user.
>> 
>> In my opinion, layout similar to the one 
>> http://kea.massey.ac.nz/search/X, is better.
>> 
> I'm going to disagree and say that site is horrid :)
> 
> Maybe others will have different opinions though.
> 
> Chris
> _______________________________________________
> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> ------------------------------
> 
> Message: 4
> Date: Thu, 25 Oct 2012 09:52:23 +0530
> From: "Sunil Kumar" <sunil.kumar at ecoleglobal.com>
> To: <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Data Migration (Dennis Njuguna)
> Message-ID: <000301cdb268$57b958c0$072c0a40$@kumar at ecoleglobal.com>
> Content-Type: text/plain;	charset="us-ascii"
> 
> Dear Dennis, 
> 
> I believe you are missing MARC tag 952 series, 952 is the local tags which
> contain all the information about the holding. For example.
> 
> 952$8$9$a$b$c$g$h$p$y
> $8 is for collection code
> $9 is for biblio number
> $a is for permanent location
> $b is for current location
> $c is for shelf location
> $g is for purchase price (you can include the vendor name, location and
> invoice details also here) $h is for volume details of the resources mainly
> it is used for the journal/magazine/periodicals $p is for the barcode $y is
> for the item type
> 
> Once you have all the required information in 952 series you can convert the
> file into marc format and upload the same to koha, as the standard process. 
> 
> Thanks and Regards
> 
> R Sunil Kumar
> Library Technologist
> 
> 
> 
> -----Original Message-----
> From: koha-bounces at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
> koha-request at lists.katipo.co.nz
> Sent: 25 October 2012 03:21
> To: koha at lists.katipo.co.nz
> Subject: Koha Digest, Vol 84, Issue 45
> 
> 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: Data Migration (Dennis Njuguna)
>   2. Re: Data Migration (Mohamed zalabany)
>   3. Problems upgrading to 3.8 (Ramon Andi?ach)
>   4. Re: Problems upgrading to 3.8 (Hugo Agud)
>   5. Email. (Estel Porras)
>   6. Help needed with report - how to extract subtitle and
>      edition? (Elaine Bradtke)
>   7. Re: Help needed with report - how to extract subtitle and
>      edition? (mh_zalabany at hotmail.com)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 24 Oct 2012 12:17:39 +0300
> From: Dennis Njuguna <cknjuguna at gmail.com>
> To: Mohamed zalabany <mh_zalabany at hotmail.com>
> Cc: koha list <koha at lists.katipo.co.nz>,	"manny_tamayao at sil.org"
> 	<manny_tamayao at sil.org>
> Subject: Re: [Koha] Data Migration
> Message-ID:
> 	<CAH0M1x-AbcrEvvzfvOL9oJ4nE7NMD0o4-UytqTUa0LfGxyOyAA at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
> 
> it is marc compliant, but when I take it to marcedit i view the file but I
> cannot see/view the barcode, if I import the marc into koha I can only
> import the biblios records, no holdings.
> 
> 
> 
> On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany
> <mh_zalabany at hotmail.com>wrote:
> 
>> Hello
>> conversion from mandarin M3 will be easy if your version is supporting 
>> Marc 21 for holding you need to know what is the local field that the 
>> system uses to put the items information and edit the record by MARC 
>> edit to change the tag of the item field to
>> (952) koha local field for item information
>> 
>> *
>> *
>> 
>> *
>> *
>> 
>> *Mohamed El Zalabaitny*
>> **
>> *Integrated library systems consultant*
>> 
>> Zalabany Knowledge Systems Team?
>> For Libraries and Information systems Development and support 
>> mh_zalabany at hotmail.com
>> Mobile: 0111291444
>> 
>> **
>> 
>> 
>> ------------------------------
>> Date: Tue, 23 Oct 2012 17:08:09 +0300
>> Subject: Re: [Koha] Data Migration
>> From: cknjuguna at gmail.com
>> To: mh_zalabany at hotmail.com
>> CC: manny_tamayao at sil.org; koha at lists.katipo.co.nz
>> 
>> 
>> Hello Mohamed what about data migration from mandarin M3 especially 
>> the holdings?
>> 
>> On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany 
>> <mh_zalabany at hotmail.com
>>> wrote:
>> 
>> 
>> i have a big experience in data conversion but unfortunately i don't 
>> know MAELISA library systemso could you tell us is the data is MARC 
>> format i what format and send me a sample of data
>> 
>> 
>> 
>> Mohamed El ZalabanyIntegrated library systems consultant
>> 
>> Zalabany Knowledge Systems Team?
>> For Libraries and Information systems Development and support 
>> mh_zalabany at hotmail.com
>> Mobile: 202-0111291444
>> 
>> 
>> 
>>> From: manny_tamayao at sil.org
>>> To: koha at lists.katipo.co.nz
>>> Date: Tue, 23 Oct 2012 10:21:40 +0800
>>> Subject: [Koha] Data Migration
>>> 
>>> Good day to all,
>>> 
>>> 
>>> 
>>> I'm Manny from Manila and in the process of data migration of the 
>>> library from "MAELISA" to KOHA.
>>> 
>>> Is there anyone who had done this process or has a script that may help?
>>> 
>>> 
>>> 
>>> Salamat
>>> 
>>> 
>>> 
>>> Manny Tamayao
>>> 
>>> Librarian/Archivist
>>> 
>>> SIL Philippines
>>> 
>>> skype: mannytamayao
>>> 
>>> mobile: 09152822329
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz 
>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>> 
>> _______________________________________________
>> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz 
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>> 
>> 
>> 
>> 
>> --
>> 
>> Dennis K. Njuguna
>> 
>> 
> 
> 
> -- 
> 
> Dennis K. Njuguna
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Wed, 24 Oct 2012 09:38:15 +0000
> From: Mohamed zalabany <mh_zalabany at hotmail.com>
> To: <cknjuguna at gmail.com>
> Cc: koha list <koha at lists.katipo.co.nz>,	"manny_tamayao at sil.org"
> 	<manny_tamayao at sil.org>
> Subject: Re: [Koha] Data Migration
> Message-ID: <BLU165-W49D11BF288626BB715E85597780 at phx.gbl>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> 
> 
> I think there is option to export item data with MARC record
> 
> 
> Mohamed El ZalabanyIntegrated library systems consultant
> 
> Zalabany Knowledge Systems Team?
> For Libraries and Information systems Development and support
> mh_zalabany at hotmail.com
> Mobile: 0111291444
> 
> 
> 
> Date: Wed, 24 Oct 2012 12:17:39 +0300
> Subject: Re: [Koha] Data Migration
> From: cknjuguna at gmail.com
> To: mh_zalabany at hotmail.com
> CC: manny_tamayao at sil.org; koha at lists.katipo.co.nz
> 
> 
> it is marc compliant, but when I take it to marcedit i view the file but I
> cannot see/view the barcode, if I import the marc into koha I can only
> import the biblios records, no holdings.
> 
> 
> 
> 
> On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany <mh_zalabany at hotmail.com>
> wrote:
> 
> 
> 
> 
> 
> Hello
> conversion from mandarin M3 will be easy if your version is supporting Marc
> 21 for holding you need to know what is the local field that the system uses
> to put the items information and edit the record by MARC edit to change the
> tag of the item field to (952) koha local field for item information
> 
> 
> 
> 
> Mohamed El Zalabaitny
> Integrated library systems consultant
> 
> Zalabany Knowledge Systems Team?
> For Libraries and Information systems Development and support
> 
> mh_zalabany at hotmail.com
> Mobile: 0111291444
> 
> 
> 
> 
> Date: Tue, 23 Oct 2012 17:08:09 +0300
> Subject: Re: [Koha] Data Migration
> From: cknjuguna at gmail.com
> To: mh_zalabany at hotmail.com
> 
> CC: manny_tamayao at sil.org; koha at lists.katipo.co.nz
> 
> Hello Mohamed what about data migration from mandarin M3 especially the
> holdings?
> 
> 
> On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany <mh_zalabany at hotmail.com>
> wrote:
> 
> 
> 
> i have a big experience in data conversion but unfortunately i don't know
> MAELISA library systemso could you tell us is the data is MARC format i what
> format and send me a sample of data
> 
> 
> 
> 
> 
> 
> 
> Mohamed El ZalabanyIntegrated library systems consultant
> 
> 
> 
> Zalabany Knowledge Systems Team?
> 
> For Libraries and Information systems Development and support
> 
> mh_zalabany at hotmail.com
> 
> Mobile: 202-0111291444
> 
> 
> 
> 
> 
> 
> 
>> From: manny_tamayao at sil.org
> 
>> To: koha at lists.katipo.co.nz
> 
>> Date: Tue, 23 Oct 2012 10:21:40 +0800
> 
>> Subject: [Koha] Data Migration
> 
>> 
> 
>> Good day to all,
> 
>> 
> 
>> 
> 
>> 
> 
>> I'm Manny from Manila and in the process of data migration of the 
>> library
> 
>> from "MAELISA" to KOHA.
> 
>> 
> 
>> Is there anyone who had done this process or has a script that may help?
> 
>> 
> 
>> 
> 
>> 
> 
>> Salamat
> 
>> 
> 
>> 
> 
>> 
> 
>> Manny Tamayao
> 
>> 
> 
>> Librarian/Archivist
> 
>> 
> 
>> SIL Philippines
> 
>> 
> 
>> skype: mannytamayao
> 
>> 
> 
>> mobile: 09152822329
> 
>> 
> 
>> 
> 
>> 
> 
>> 
> 
>> 
> 
>> 
> 
>> 
> 
>> 
> 
>> 
> 
>> 
> 
>> 
> 
>> _______________________________________________
> 
>> Koha mailing list  http://koha-community.org
> 
>> Koha at lists.katipo.co.nz
> 
>> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> 
> _______________________________________________
> 
> Koha mailing list  http://koha-community.org
> 
> Koha at lists.katipo.co.nz
> 
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> 
> -- 
> 
> Dennis K. Njuguna
> 
> 		 	   		  
> 
> 
> -- 
> 
> Dennis K. Njuguna
> 
> 		 	   		  
> 
> ------------------------------
> 
> Message: 3
> Date: Wed, 24 Oct 2012 23:46:00 +0800
> From: Ramon Andi?ach <custard at westnet.com.au>
> To: koha at lists.katipo.co.nz
> Subject: [Koha] Problems upgrading to 3.8
> Message-ID: <96D8A573-0DC3-478B-BA5C-CBD5FD9974A5 at westnet.com.au>
> Content-Type: text/plain; charset=us-ascii
> 
> Hi,
> 
> This is going sound pathetic, and stupid, but I'm in need of some guidance.
> It has been quite some time since I've tried to use koha.
> 
> I've been upgrading my koha from 3.00 towards 3.8 via the tarball method.
> 
> I was attempting to be good, and going in smallish steps so 3.00 to 3.02 to
> 3.04 to 3.06 and then to 3.8.
> 
> In between each upgrade I was trying a few searches to make sure that the
> books end of the db was intact and then backing up the DB.
> 
> After the 3.06 step it seemed to be working.
> 
> But, after the 3.8 step suddenly most of the books seem to have vanished.
> 
> I'd put it down to noticing in the upgrade notes some extra steps that I
> didn't see in the 3.6 or 3.4 notes (the ones about removing the duplicated
> item details). So I dropped the DB and reloaded the backup from the 3.6 step
> and tried without these steps.
> 
> I've also now tried the original backup too, without success.
> 
> I'm not sure at this point if it's the items that have vanished or the
> records too. Yes, I have run rebuild_zebra -b -r as the koha user (several
> times no luck).
> 
> So I suppose I'm looking for guidance on
> a) working out what is going on.
> b) how to get normality back again.
> 
> -ramon.
> 
> ------------------------------
> 
> Message: 4
> Date: Wed, 24 Oct 2012 18:01:53 +0200
> From: Hugo Agud <hagud at orex.es>
> To: Ramon Andi?ach <custard at westnet.com.au>
> Cc: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Problems upgrading to 3.8
> Message-ID:
> 	<CADT_QRTsaDrrye_Ux-To_JkjQZk=eT3QN_b1UEoEPSg1N_k64Q at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
> 
> Hi Ramon
> 
> Do not worry it happens to a lot of people ... take a look on this
> 
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8665
> 
> Kindest Regards
> 
> 2012/10/24 Ramon Andi?ach <custard at westnet.com.au>
> 
>> Hi,
>> 
>> This is going sound pathetic, and stupid, but I'm in need of some 
>> guidance. It has been quite some time since I've tried to use koha.
>> 
>> I've been upgrading my koha from 3.00 towards 3.8 via the tarball method.
>> 
>> I was attempting to be good, and going in smallish steps so 3.00 to
>> 3.02 to 3.04 to 3.06 and then to 3.8.
>> 
>> In between each upgrade I was trying a few searches to make sure that 
>> the books end of the db was intact and then backing up the DB.
>> 
>> After the 3.06 step it seemed to be working.
>> 
>> But, after the 3.8 step suddenly most of the books seem to have vanished.
>> 
>> I'd put it down to noticing in the upgrade notes some extra steps that 
>> I didn't see in the 3.6 or 3.4 notes (the ones about removing the 
>> duplicated item details). So I dropped the DB and reloaded the backup 
>> from the 3.6 step and tried without these steps.
>> 
>> I've also now tried the original backup too, without success.
>> 
>> I'm not sure at this point if it's the items that have vanished or the 
>> records too. Yes, I have run rebuild_zebra -b -r as the koha user 
>> (several times no luck).
>> 
>> So I suppose I'm looking for guidance on
>> a) working out what is going on.
>> b) how to get normality back again.
>> 
>> -ramon.
>> _______________________________________________
>> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz 
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>> 
> 
> 
> 
> -- 
> 
> *Hugo Agud - Orex Digital *
> 
> *www.orex.es*
> 
> *
> *
> 
> Director
> 
> Avenida Sarri? 29 ? 08029 Barcelona <http://twitter.com/OrexDigital>
> :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539
> 33 30
> hagud at orex.es ? http://www.orex.es/
> 
> 
> 
> No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
> implica la tala de 15 ?rboles y el consumo de 250.000 litros de agua.
> 
> 
> 
> Aviso de confidencialidad
> Este mensaje contiene informaci?n que puede ser CONFIDENCIAL y/o de USO
> RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni est?
> autorizado a recibirlo por el remitente), no est? autorizado a copiar,
> reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje
> por error, por favor, notif?quenoslo inmediatamente y b?rrelo de su sistema.
> 
> 
> ------------------------------
> 
> Message: 5
> Date: Wed, 24 Oct 2012 10:11:18 -0700 (PDT)
> From: Estel Porras <orlib at yahoo.com>
> To: Koha community <koha at lists.katipo.co.nz>
> Subject: [Koha] Email.
> Message-ID:
> 	<1351098678.37956.YahooMailNeo at web125305.mail.ne1.yahoo.com>
> Content-Type: text/plain; charset=iso-8859-1
> 
> Just wanted to thank all the very helpful folks here. You guys rock!
> 
> ?
> ?Have a great day, ~Estel~
> Orland Free Library
> 333 Mill St.
> Orland CA. 95963
> [530]865-1640
> 
> ------------------------------
> 
> Message: 6
> Date: Wed, 24 Oct 2012 22:23:41 +0100
> From: Elaine Bradtke <eb at efdss.org>
> To: koha <koha at lists.katipo.co.nz>
> Subject: [Koha] Help needed with report - how to extract subtitle and
> 	edition?
> Message-ID:
> 	<CAPdfUux1_GHutDqzKJrr-F+3DPU0fwCH8LYrfKiGmwtbEM5DHw at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
> 
> I'm trying to catch duplicate items in data before I upload it (ISBN won't
> help in this case). In order to do that I've written a report to list the
> books currently in Koha, and will compare them with my external files.
> However, if I can't include the subtitle (MARC 245 b) I will get too many
> false positives (we have lots of things with the same title, but different
> subtitles)
> It would also help if I could  also have the 250 a (edition)
> 
> 
> This is what I have:
> SELECT
> 
> biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit
> ems.place,biblioitems.publishercode,biblioitems.isbn
> FROM items
> LEFT JOIN biblioitems on
> (items.biblioitemnumber=biblioitems.biblioitemnumber)
> LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)
> WHERE items.itype='BK' AND items.holdingbranch='VWML'
> ORDER BY biblio.author asc
> 
> 
> This works fine, but doesn't include the 245 b or the 250 a  Can anyone
> help?
> --
> 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: 7
> Date: Wed, 24 Oct 2012 23:51:10 +0200
> From: mh_zalabany at hotmail.com <mh_zalabany at hotmail.com>
> To: eb at efdss.org,"koha" <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Help needed with report - how to extract subtitle
> 	and	edition?
> Message-ID: <BLU0-SMTP34294835DD8881E4738D9DE97780 at phx.gbl>
> Content-Type: text/plain; charset="utf-8"
> 
> I think in this case you need to make the report using the xml field in
> biblio items table because the rest of sub fields you will find there
> 
> Sent from my HTC
> 
> ----- Reply message -----
> From: "Elaine Bradtke" <eb at efdss.org>
> To: "koha" <koha at lists.katipo.co.nz>
> Subject: [Koha] Help needed with report - how to extract subtitle and
> edition?
> Date: Wed, Oct 24, 2012 11:23 pm
> 
> 
> I'm trying to catch duplicate items in data before I upload it (ISBN won't
> help in this case). In order to do that I've written a report to list the
> books currently in Koha, and will compare them with my external files.
> However, if I can't include the subtitle (MARC 245 b) I will get too many
> false positives (we have lots of things with the same title, but different
> subtitles)
> It would also help if I could  also have the 250 a (edition)
> 
> 
> This is what I have:
> SELECT
> 
> biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit
> ems.place,biblioitems.publishercode,biblioitems.isbn
> FROM items
> LEFT JOIN biblioitems on
> (items.biblioitemnumber=biblioitems.biblioitemnumber)
> LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)
> WHERE items.itype='BK' AND items.holdingbranch='VWML'
> ORDER BY biblio.author asc
> 
> 
> This works fine, but doesn't include the 245 b or the 250 a  Can anyone
> help?
> -- 
> 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 84, Issue 45
> ************************************
> 
> 
> 
> ------------------------------
> 
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> End of Koha Digest, Vol 84, Issue 46
> ************************************
> 
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha



More information about the Koha mailing list