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: [email protected] > [mailto:[email protected]] On Behalf Of > [email protected] > Sent: 25 October 2012 09:53 > To: [email protected] > Subject: Koha Digest, Vol 84, Issue 46 > > Send Koha mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: [email protected] > Subject: [Koha] Improving the advanced search form > Message-ID: <[email protected]> > 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 <[email protected]> > To: Srikanth Dhondi <[email protected]> > Cc: [email protected] > Subject: Re: [Koha] Improving the advanced search form > Message-ID: > <CA+95qVR9P0U4Wynn2p0PWP3Wb37J+7SSiMu1xjvZs1kbq=9=n...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > On 25 October 2012 14:55, Srikanth Dhondi <[email protected]> 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 <[email protected]> > To: 'Chris Cormack' <[email protected]>, Srikanth Dhondi > <[email protected]> > Cc: "[email protected]" <[email protected]> > Subject: Re: [Koha] Improving the advanced search form > Message-ID: > > <ab44deb8cf4f784f90ebcdbbd9b817376d7e2...@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: [email protected] > [mailto:[email protected]] On Behalf Of Chris Cormack > Sent: Thursday, 25 October 2012 3:03 p.m. > To: Srikanth Dhondi > Cc: [email protected] > Subject: Re: [Koha] Improving the advanced search form > > On 25 October 2012 14:55, Srikanth Dhondi <[email protected]> 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 [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > Message: 4 > Date: Thu, 25 Oct 2012 09:52:23 +0530 > From: "Sunil Kumar" <[email protected]> > To: <[email protected]> > Subject: Re: [Koha] Data Migration (Dennis Njuguna) > Message-ID: <000301cdb268$57b958c0$072c0a40$@[email protected]> > 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: [email protected] > [mailto:[email protected]] On Behalf Of > [email protected] > Sent: 25 October 2012 03:21 > To: [email protected] > Subject: Koha Digest, Vol 84, Issue 45 > > Send Koha mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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? ([email protected]) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 24 Oct 2012 12:17:39 +0300 > From: Dennis Njuguna <[email protected]> > To: Mohamed zalabany <[email protected]> > Cc: koha list <[email protected]>, "[email protected]" > <[email protected]> > Subject: Re: [Koha] Data Migration > Message-ID: > <cah0m1x-abcrevvzfvol9oj4ne7nmd0o4-uytqtua0lfgxyo...@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 > <[email protected]>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 >> [email protected] >> Mobile: 0111291444 >> >> ** >> >> >> ------------------------------ >> Date: Tue, 23 Oct 2012 17:08:09 +0300 >> Subject: Re: [Koha] Data Migration >> From: [email protected] >> To: [email protected] >> CC: [email protected]; [email protected] >> >> >> Hello Mohamed what about data migration from mandarin M3 especially >> the holdings? >> >> On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany >> <[email protected] >>> 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 >> [email protected] >> Mobile: 202-0111291444 >> >> >> >>> From: [email protected] >>> To: [email protected] >>> 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 [email protected] >>> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> _______________________________________________ >> Koha mailing list http://koha-community.org [email protected] >> 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 <[email protected]> > To: <[email protected]> > Cc: koha list <[email protected]>, "[email protected]" > <[email protected]> > Subject: Re: [Koha] Data Migration > Message-ID: <[email protected]> > 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 > [email protected] > Mobile: 0111291444 > > > > Date: Wed, 24 Oct 2012 12:17:39 +0300 > Subject: Re: [Koha] Data Migration > From: [email protected] > To: [email protected] > CC: [email protected]; [email protected] > > > 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 <[email protected]> > 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 > > [email protected] > Mobile: 0111291444 > > > > > Date: Tue, 23 Oct 2012 17:08:09 +0300 > Subject: Re: [Koha] Data Migration > From: [email protected] > To: [email protected] > > CC: [email protected]; [email protected] > > Hello Mohamed what about data migration from mandarin M3 especially the > holdings? > > > On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany <[email protected]> > 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 > > [email protected] > > Mobile: 202-0111291444 > > > > > > > >> From: [email protected] > >> To: [email protected] > >> 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 > >> [email protected] > >> http://lists.katipo.co.nz/mailman/listinfo/koha > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > [email protected] > > 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 <[email protected]> > To: [email protected] > Subject: [Koha] Problems upgrading to 3.8 > Message-ID: <[email protected]> > 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 <[email protected]> > To: Ramon Andi?ach <[email protected]> > Cc: [email protected] > Subject: Re: [Koha] Problems upgrading to 3.8 > Message-ID: > <CADT_QRTsaDrrye_Ux-To_JkjQZk=et3qn_b1ueoepsg1n_k...@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 <[email protected]> > >> 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 [email protected] >> 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 > [email protected] ? 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 <[email protected]> > To: Koha community <[email protected]> > Subject: [Koha] Email. > Message-ID: > <[email protected]> > 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 <[email protected]> > To: koha <[email protected]> > Subject: [Koha] Help needed with report - how to extract subtitle and > edition? > Message-ID: > <capdfuux1_ghutdqzkjrr-f+3dpu0fwch8lyrfkigmwtbem5...@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: [email protected] <[email protected]> > To: [email protected],"koha" <[email protected]> > Subject: Re: [Koha] Help needed with report - how to extract subtitle > and edition? > Message-ID: <[email protected]> > 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" <[email protected]> > To: "koha" <[email protected]> > 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 > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > _______________________________________________ > Koha mailing list > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 84, Issue 45 > ************************************ > > > > ------------------------------ > > _______________________________________________ > Koha mailing list > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 84, Issue 46 > ************************************ > > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
