- Koha - lists.katipo.co.nz

Re: [Koha] Searching by the exact barcode in cataloguing
by Owen Leonard 26 Jul '12

26 Jul '12

When replying to Koha digest emails, please don't quote the entire digest. > But I had another problem, if enter a barcode it display me the exact title > instead it display me all the titles with barcode number prefix or suffix to > my search. If you search for a specific barcode and a matching title is found, you will be shown only that title. If you search for a partial barcode for which there is no exact match you will be shown titles with similar barcodes. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 0

Re: [Koha] Searching by the exact barcode in cataloguing
by Sunil Kumar 26 Jul '12

26 Jul '12

Dear Mr. Calyx / Makeke I agree with Mr. Calyx, advance search is where you will find barcode based search of your collection. But I had another problem, if enter a barcode it display me the exact title instead it display me all the titles with barcode number prefix or suffix to my search. How to resolve this kind of issue. Thanks and Regards R Sunil Kumar Library Technologist -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 11 April 2012 21:01 To: koha(a)lists.katipo.co.nz Subject: [SPAM]- Koha Digest, Vol 78, Issue 23 Send Koha mailing list submissions to koha(a)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(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)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. Searching by the exact barcode in cataloguing (Ephraim Makeke) 2. Re: Searching by the exact barcode in cataloguing (Bob Birchall) 3. Re: Kohacon13, was: KUDOS 2012 (Bob Birchall) 4. Re: rebuild zebra prob (Ian Bays) 5. software error (shahas) 6. Re: KUDOS 2012 (Tomas Cohen Arazi) 7. Re: Kohacon13, was: KUDOS 2012 (Marijana Glavica) 8. Re: rebuild zebra prob (G. Laws) ---------------------------------------------------------------------- Message: 1 Date: Wed, 11 Apr 2012 09:11:25 +0200 From: Ephraim Makeke <makekee(a)msu.ac.zw> To: koha(a)lists.katipo.co.nz Subject: [Koha] Searching by the exact barcode in cataloguing Message-ID: <20120411091124.112077j3nrs5mfto(a)10.10.1.10> Content-Type: text/plain; charset=ISO-8859-1; DelSp="Yes"; format="flowed" Hi All For purposes of quality control, we would like our cataloguers to search an exact barcode and to get the exact record matching that barcode. Now, in the KOHA system, is there a place where we can set parameters to search by an exact barcode? Ephraim Makeke Ephraim Makeke Senior Assistant Librarian - Library ICT Midlands State University Library P. Bag 9055 Gweru Zimbabwe Tel: 263 54 260445 ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------ Message: 2 Date: Wed, 11 Apr 2012 18:28:48 +1000 From: Bob Birchall <bob(a)calyx.net.au> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Searching by the exact barcode in cataloguing Message-ID: <4F8540C0.4080100(a)calyx.net.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed On 11/04/12 17:11, Ephraim Makeke wrote: > Hi All > > For purposes of quality control, we would like our cataloguers to > search an exact barcode and to get the exact record matching that > barcode. Now, in the KOHA system, is there a place where we can set > parameters to search by an exact barcode? Hi Ephraim, On the Advanced Search page, just enter the barcode as a keyword and you should get the result you are looking for. In fact, the drop down the menu at Keyword includes 'Barcode' as a specific option. I hope this helps, Bob Birchall Calyx ------------------------------ Message: 3 Date: Wed, 11 Apr 2012 19:07:07 +1000 From: Bob Birchall <bob(a)calyx.net.au> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Kohacon13, was: KUDOS 2012 Message-ID: <4F8549BB.80001(a)calyx.net.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed On 11/04/12 00:26, Lori Bowen Ayre wrote: > Brooke, > > As you mentioned somewhere in this thread, I think it would be lovely > to have everyone come to my lovely little home town of Petaluma, CA. > We have a small Sheraton Convention Center space that would > accommodate everyone and they'd love to have us. There's also a > retreat space, Walker Ranch, that might work (but I haven't checked that one out for KohaCon). > > We have lots of great places to eat, a music venue, and its small and > manageable. One hour from both Oakland and SF airports with a direct > shuttle available to get here. Not really any public transportation > once you get here though.... And the only places to stay are the > Sheraton and the Metro and a Motel 6 or something. Although by 2014, > there may be another hotel that is in the work which should be very cool. > > Here's a nice page about Petaluma: http://www.visitpetaluma.com/ West Coast ++ Near SF? Sounds good to me. :) Bob ------------------------------ Message: 4 Date: Wed, 11 Apr 2012 09:22:27 +0100 From: Ian Bays <ian.bays(a)ptfs-europe.com> To: "G. Laws" <glawson(a)rhcl.org> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] rebuild zebra prob Message-ID: <4F853F43.2030509(a)ptfs-europe.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hi Greg, This should be the right PERL5LIB: echo $PERL5LIB /home/koha/kohaclone What does the end of the output from: perl -v give? It should be like this: %ENV: PERL5LIB="/home/koha/kohaclone" @INC: /home/koha/kohaclone /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl It will end up being something obvious. Would you need to: export PERL5LIB before using it? Good luck. Ian On 11/04/2012 00:15, G. Laws wrote: > PROB: > > $ ./rebuild_zebra.pl -a -b -z > Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl > /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 > /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 > /usr/local/lib/site_perl .) at ./rebuild_zebra.pl line 6. > BEGIN failed--compilation aborted at ./rebuild_zebra.pl line 6. > > INFO: > > running master on debian... > > $ ls -l /home/koha/kohaclone/C4/Context.pm > -rw-r--r-- 1 koha koha 33348 Apr 10 14:28 Context.pm > > > tried... > > $echo $PERL5LIB > /home/koha/kohaclone > > ...and > > $ echo $PERL5LIB > /usr/koha/kohaclone/C4 > > ...and even attempted a non-standard symlink... > > # ls -l /usr/lib/perl5/Context.pm > lrwxrwxrwx 1 root root 34 Apr 10 18:00 Context.pm -> > /usr/lib/perl5/Template/Context.pm > > ...no joy... > > > > Help? > -- Ian Bays Director of Projects, PTFS Europe Limited Content Management and Library Solutions +44 (0) 800 756 6803 (phone) +44 (0) 7774 995297 (mobile) +44 (0) 800 756 6384 (fax) skype: ian.bays email: ian.bays(a)ptfs-europe.com ------------------------------ Message: 5 Date: Wed, 11 Apr 2012 03:57:54 -0700 (PDT) From: shahas <shahas.sss(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] software error Message-ID: <1334141874749-5632466.post(a)n5.nabble.com> Content-Type: text/plain; charset=us-ascii Hi,, while saving record am getting below error.,,, Software error: Can't call method "fields" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 2245. For help, please send mail to the webmaster (webmaster@koha), giving this error message and the time and date of the error. please help me to proceed,,,, -- View this message in context: http://koha.1045719.n5.nabble.com/software-error-tp5632466p5632466.html Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ Message: 6 Date: Wed, 11 Apr 2012 10:48:42 -0300 From: Tomas Cohen Arazi <tomascohen(a)gmail.com> To: Chris Cormack <chris(a)bigballofwax.co.nz> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] KUDOS 2012 Message-ID: <CABZfb=VZ4PgTZSbsF9sooZ63BKb5m+0w0hg8rJwsrerKdnd+8Q(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 On Mon, Apr 9, 2012 at 6:23 PM, Chris Cormack <chris(a)bigballofwax.co.nz> wrote: > On 10 April 2012 09:07, G. Laws <glawson(a)rhcl.org> wrote: >> Us host KohaCon13? In St. Joseph, Missouri? After New Zealand, India >> and Scotland? >> >> Tell you what, let's all get together in Bangkok, Thailand, from June >> 1 to June 30 for KohaCon 2013. Nothing in the KohaCon charter says it >> has to be held near a Koha library, right? I can get there in mid-May >> and make all the arrangements, and stay till mid-July for cleanup. >> > > Hehe > > Seriously though, it's probably the US turn again, 2009 Plano was the > last one, so I would seriously think about a Kohacon13 in the USA. > Also there are Koha libraries in Thailand .. I think we'd have to go > to Antartica to get away from them :) I think Argentina and it's 'asado' are worth a KohaCon. Regards To+ ------------------------------ Message: 7 Date: Wed, 11 Apr 2012 17:10:37 +0200 From: Marijana Glavica <mglavica(a)ffzg.hr> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Kohacon13, was: KUDOS 2012 Message-ID: <20120411151037.GQ30889(a)mjesec.ffzg.hr> Content-Type: text/plain; charset=us-ascii Hi, We would love to host conference in Croatia sometime, but we are not sure if we should go forward with a proposal for KohaCon13 because Croatia is also in Europe and we don't know how strict is the rule about having KohaCon every year on different continent. Marijana On Tue, Apr 10, 2012 at 10:53:25AM +0100, MJ Ray wrote: > Jo wrote: > > One option you could consider is to put in a bid to host KohaCon13. > > [...] > > "Who might be interested in hosting KohaCon13? > > This is just an initial expression of interest and doesn't commit you > to anything at this point. We'd just like to know who's interested > and we'll email you when the time comes to send in actual proposals if > it looks like you may have missed the call. > > Of course, personally, I'd love it if we can decide before KohaCon12 > next June, formally pass the baton over and then try to start the > process for '14, to make it a bit easier for everyone to budget (both > as attendees and hosts!)." > > -- http://lists.katipo.co.nz/public/koha/2011-December/031479.html > > Come on, let's have some expression of interest, please! Did I see > Mexico mentioned in IRC a few days ago? > > Thanks, > -- > MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. > http://koha-community.org supporter, web and library systems developer. > In My Opinion Only: see http://mjr.towers.org.uk/email.html > Available for hire (including development) at > http://www.software.coop/ > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 8 Date: Wed, 11 Apr 2012 10:31:13 -0500 From: "G. Laws" <glawson(a)rhcl.org> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] rebuild zebra prob Message-ID: <4F85A3C1.8010600(a)rhcl.org> Content-Type: text/plain; charset=ISO-8859-1 Ian: Thanks for suggestions. 1. Did a lather, rinse, repeat this morning using what I know should be correct--PERL5LIB set to /home/koha/kohaclone, etc. I think the problem was I didn't have KOHA_CONF exported correctly. So that got me past all the error messages, and rebuild_zebra gives the appearance of running, but doesn't index anything: $ ./rebuild_zebra.pl -a -b -z -v Zebra configuration information ================================ Zebra biblio directory = /home/koha/koha-dev/var/lib/zebradb/biblios Zebra authorities directory = /home/koha/koha-dev/var/lib/zebradb/authorities Koha directory = /home/koha/kohaclone BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ ==================== exporting authority ==================== Records exported: 0 Records exported: 0 ==================== REINDEXING zebra ==================== ==================== exporting biblio ==================== Records exported: 0 Records exported: 0 ==================== REINDEXING zebra ==================== ==================== CLEANING ==================== -------------------------- This, of course, results in no book data being returned from the DB. OK, so now what should I try? Is this relevant? http://koha-community.org/faq/double-ups-search-results-clear-index-start-ag ain/ -or this? http://manual.koha-community.org/3.2/en/resetzebra.html Greg ----------------------------- On 04/11/2012 03:22 AM, Ian Bays wrote: > Hi Greg, > This should be the right PERL5LIB: > > echo $PERL5LIB > /home/koha/kohaclone > > What does the end of the output from: > perl -v > give? > > It should be like this: > %ENV: > PERL5LIB="/home/koha/kohaclone" > @INC: > /home/koha/kohaclone > /etc/perl > /usr/local/lib/perl/5.10.1 > /usr/local/share/perl/5.10.1 > /usr/lib/perl5 > /usr/share/perl5 > /usr/lib/perl/5.10 > /usr/share/perl/5.10 > /usr/local/lib/site_perl > > It will end up being something obvious. Would you need to: > export PERL5LIB > before using it? > > Good luck. > Ian > > On 11/04/2012 00:15, G. Laws wrote: >> PROB: >> >> $ ./rebuild_zebra.pl -a -b -z >> Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl >> /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 >> /usr/lib/perl5 >> /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 >> /usr/local/lib/site_perl .) at ./rebuild_zebra.pl line 6. >> BEGIN failed--compilation aborted at ./rebuild_zebra.pl line 6. >> >> INFO: >> >> running master on debian... >> >> $ ls -l /home/koha/kohaclone/C4/Context.pm >> -rw-r--r-- 1 koha koha 33348 Apr 10 14:28 Context.pm >> >> >> tried... >> >> $echo $PERL5LIB >> /home/koha/kohaclone >> >> ...and >> >> $ echo $PERL5LIB >> /usr/koha/kohaclone/C4 >> >> ...and even attempted a non-standard symlink... >> >> # ls -l /usr/lib/perl5/Context.pm >> lrwxrwxrwx 1 root root 34 Apr 10 18:00 Context.pm -> >> /usr/lib/perl5/Template/Context.pm >> >> ...no joy... >> >> >> >> Help? >> > -- Greg Lawson Rolling Hills Consolidated Library 1912 N. Belt Highway St. Joseph, MO 64506 816-232-5479 ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 78, Issue 23 ************************************

1 0

Re: [Koha] marc framework and importing records
by Sunil Kumar 26 Jul '12

26 Jul '12

Dear Nancy; Please visit the following site : http://ksrcas.pbworks.com/w/page/3809371/editingmarcframework Question : (for example the 00 fields?) will I run into a problem when I import records? Answer: better not to delete/hide the default / mandatory fields, these mandatory fields are clickable only. Won't take that much time. Question: Put another way, if I import records all from the Library of Congress for example, using the import script, will the script fail if the field is not defined in my framework? Answer: No issue, if you select the customized framework for Z39.50 search and catalogue, you will be able to store the content/biblio. You can go ahead and customize the framework and it will work very effectively for you. Feel free to revert back for any clarifications. Thanks and Regards R Sunil Kumar Library Technologist -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 20 April 2012 00:15 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 78, Issue 39 Send Koha mailing list submissions to koha(a)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(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)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: Itherm 280 receipt printers with Koha Circulation (Bernardo Gonzalez Kriegel) 2. Seeking Pacific Island Koha users (Pamela Bidwell) 3. marc framework and importing records (smurfett(a)gmail.com) 4. Custom call-number schemes (Peter Aronson) 5. Re: Koha reindex with Zebra doesn't work (Alex87) 6. Re: marc framework and importing records (MJ Ray) 7. itemcallnumber field not getting everything (Peter Aronson) 8. Re: Local call number (Joe) 9. Re: Bulk patron anonymize/delete tool (Tom Hanstra) ---------------------------------------------------------------------- Message: 1 Date: Wed, 18 Apr 2012 21:46:21 -0300 From: Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> To: Randy Smith <rsmith.lew(a)valnet.org> Cc: Koha <Koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Itherm 280 receipt printers with Koha Circulation Message-ID: <CADF4kvTvpqB+NSBnwmF8SXsr3X5c_+3rWhE6RDV6qp4-JESNkw(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Hi Randy, I think there are two problems: how to print and what to print. If you can register your thermal printer as a standard windows printer, capable to print a web page from a browser, then this link can help you: http://www.nexpresslibrary.org/go-live/configure-your-receipt-printers/ Next, what is printed in the circulation slip is basically in the file $KOHA_DIR/intranet/htdocs/intranet-tmpl/prog/en/modules/members/ moremember-print.tt that file could be tailored to your needs (logo, etc), handled with care by someone who understand html. It's a sort of html file, but not quite. It's used by Koha to generate the html of the receipt. Hope that helps -- Bernardo Gonzalez Kriegel bgkriegel(a)gmail.com On Wed, Apr 18, 2012 at 7:34 PM, Randy Smith <rsmith.lew(a)valnet.org> wrote: > Our library consortium is preparing to go live with Koha next week. We > want to print receipts for checkout, etc. using our Itherm 280 receipt > printers, but have searched in vain for any available configuration > instructions or advice. Is anyone using Itherm 280 receipt printers for > patron checkout, hold slips, etc.? Any help is greatly appreciated. > > Randy Smith > Lewiston City Library > 208. 743-6519 > ______________________________**_________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/**mailman/listinfo/koha<http://lists.katipo.co.nz/ mailman/listinfo/koha> > ------------------------------ Message: 2 Date: Thu, 19 Apr 2012 00:52:25 +0000 From: Pamela Bidwell <pamela.bidwell(a)usp.ac.fj> To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Cc: Nelson Manerara <library(a)siche.edu.sb>, Mary-Clare Ame <maryca(a)spc.int> Subject: [Koha] Seeking Pacific Island Koha users Message-ID: <574E427E49FC5D4DA99A7397F33F58880D366590(a)suvxch10mb1.usp.ac.fj> Content-Type: text/plain; charset="us-ascii" Dear Koha users, I would like to hear from users of Koha in the Pacific Islands. Many small Pacific countries struggle with extra issues when automating their libraries, such as unexpected power outages (and damaging power surges), intermittent and slow Internet access, old technology and limited IT expertise. For many Pacific libraries, Koha is their first automated system, and staff training is a real issue. Quite a few Pacific Koha projects have stalled as a result of these problems. We need to develop a supportive local community that shares knowledge and offers support. I hope to set up a smaller discussion forum for the Pacific Koha community (while still being involved in the wider Koha community discussions). The forum will talk about day to day use of Koha, answer basic questions about using the system and share resources such as training materials. I would also like to discuss regional training possibilities. Please email me at: pamela.bidwell(a)usp.ac.fj<mailto:pamela.bidwell@usp.ac.fj> if you would like to be involved. I hope to hear from you soon. Regards Pam Bidwell, Lecturer Library/Information Studies School of Education The University of the South Pacific Laucala Campus, Suva, FIJI Tel. (679) 323 2829 Fax: (679) 323 1528 Email: pamela.bidwell(a)usp.ac.fj<mailto:pamela.bidwell@usp.ac.fj> L/IS program website: www.usp.ac.fj/library_studies<http://www.usp.ac.fj/library_studies> PacLibEd discussion forum: http://staff.usp.ac.fj/mailman/listinfo/paclibed ------------------------------ Message: 3 Date: Wed, 18 Apr 2012 22:58:18 -0700 From: smurfett(a)gmail.com To: koha(a)lists.katipo.co.nz Subject: [Koha] marc framework and importing records Message-ID: <4F8FA97A.90605(a)gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hi We're a small school library and don't really need all the fields used in MARC records. But I would like to import my marc records using the import perl script. I was wondering, if I edit the BOOK MARC framework for example, and delete fields that we don't really care about (for example the 00 fields?) will I run into a problem when I import records? Put another way, if I import records all from the Library of Congress for example, using the import script, will the script fail if the field is not defined in my framework? nancy ------------------------------ Message: 4 Date: Thu, 19 Apr 2012 11:30:39 +0530 From: Peter Aronson <dgllibrary+kohalist(a)peteraronson.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] Custom call-number schemes Message-ID: <99A089FC-C895-4D84-8AD8-63DDDBF45B2C(a)peteraronson.com> Content-Type: text/plain; charset=us-ascii Hi, We're a very specialized library dealing with a very narrow range of subjects, so we've created our own classification/call-number system. I'd just like to make sure we're doing it right: We've created something like CALLNUM as an authorized values category, and then we're putting our general call number heading (e.g. BC1100) as the Authorized Value, and then "Reference--Dictionaries" as the Description and the Description (OPAC). And then we've mapped CALLNUM as a mandatory field on our Marc framework. Does it sound like we're doing this the right way? Thanks, Peter Aronson DGL Library, India ------------------------------ Message: 5 Date: Thu, 19 Apr 2012 00:19:07 -0700 (PDT) From: Alex87 <aletede87(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha reindex with Zebra doesn't work Message-ID: <1334819947287-5651065.post(a)n5.nabble.com> Content-Type: text/plain; charset=UTF-8 Hi Fr?d?ric, thank you very muche you have the reason, I have made a new installation of koha, setting the zebra indexing in unimarc and koha also in unimarc, and now i can reindex my records. Thanks and Kind Regards Alex -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-reindex-with-Zebra-doesn-t-work-tp564 2993p5651065.html Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ Message: 6 Date: Thu, 19 Apr 2012 10:18:15 +0100 From: MJ Ray <mjr(a)phonecoop.coop> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] marc framework and importing records Message-ID: <E1SKnVH-0002qg-S0(a)petrol.towers.org.uk> smurfett(a)gmail.com > We're a small school library and don't really need all the fields used in > MARC records. But I would like to import my marc records using the import > perl script. I was wondering, if I edit the BOOK MARC framework for > example, and delete fields that we don't really care about (for example the > 00 fields?) will I run into a problem when I import records? Probably not, but I think the usual way is to set up new frameworks and leave the full ones there. The import script can (must? check it!) use the default framework, which is another way out. > Put another way, if I import records all from the Library of Congress for > example, using the import script, will the script fail if the field is not > defined in my framework? I think the answer is: no, but it may behave slightly strangely when you edit the record or need you to use the default framework to edit all the fields. Nothing should break as a result of this, though. Hope that informs, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ ------------------------------ Message: 7 Date: Thu, 19 Apr 2012 15:40:59 +0530 From: Peter Aronson <dgllibrary+kohalist(a)peteraronson.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] itemcallnumber field not getting everything Message-ID: <7328ED03-FB04-47CE-8E5F-444E5FECF849(a)peteraronson.com> Content-Type: text/plain; charset=windows-1252 In Home ? Administration ? System Preferences I have specified that the field "itemcallnumber" should map the MARC subfield 099aef. However Koha only maps subfields a and e (099ae)? It is not mapping subfield f. Is this option limited to only 2 subfields? Thanks, Peter ------------------------------ Message: 8 Date: Thu, 19 Apr 2012 09:41:26 -0500 From: Joe <jbalway(a)gmail.com> To: Koha Listserv <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Local call number Message-ID: <CAKy3BNEBgN2YjXG2Toug8abLgrdsTnc2iQ1P_3YzwCDL9DwGOA(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi Paula, You need to add it to Koha's MARC Framework. #1 Login to the Staff Client Side, click on the "More" drop down menu, and choose Administration. That will bring you to the Administration page. #2 Under Catalog heading click on "MARC Bibliographic framework". This takes you to a list of the MARC Frameworks in your instance of Koha. #3 Click on the "MARC Structure" link beside the MARC Framework you want the 09X field added to. #4 Enter 09X in the "Search for tag" search box and click search. #5 Click the subfields link on the 09X tag line, then click edit subfields and at the bottom of that page you will see a link that says "display more constraints". Click on the "display more constraints" link. #6 You will need to set the "hidden" field to the correct value. -1 will make it visible in the OPAC, on the Intranet, in the editor, and will make it show up as collapsed in the editor. See this page for more details: http://manual.koha-community.org/3.6/en/catadmin.html#marcbibframeworks Sincerely, -Joe- On Wed, Apr 18, 2012 at 4:36 PM, Paula Corman <Paula.Corman(a)themim.org>wrote: > I am embarking on cataloging about 400 CD's and I want to use a locally > assigned call number. It appears from the MARC records I have examined > that libraries are using the 09X field. However, the template for the > version of Koha that this library uses does not have that option. Can > someone please tell me what to do to add this field to the Koha template? > I do not have a systems person and/or programmer who can help, so if > possible, please keep the directions simple. Thanks. > > Paula Corman | Acting Librarian | MIM-Musical Instrument Museum > 4725 East Mayo Boulevard | Phoenix, AZ 85050 | 480.478.6000 main | > 480.245.6906 direct > 480.471.8690 fax | paula.corman(a)themim.org<mailto:mary.farmer@themim.org> > | www.themim.org<http://www.themim.org> > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Joseph Alway Access Services Coordinator Chan Shun Centennial Library Southwestern Adventist University "The World's Great Literary Masterpieces. Freely Available At Your Fingertips. Project Gutenberg. The Free Digital Library." http://www.gutenberg.org ------------------------------ Message: 9 Date: Thu, 19 Apr 2012 14:48:10 -0400 From: Tom Hanstra <tom(a)nd.edu> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Bulk patron anonymize/delete tool Message-ID: <4F905DEA.4040307(a)nd.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed OK, I think I found the problem. We have a number of patrons who were created (or somehow set) the privacy setting on their accounts. This was not readily visible and not taken into account when we were trying to perform the anonymizing. Where on the OPAC can a patron set their privacy flag? I've not seen where that option can be set. Thanks, Tom On 04/17/2012 10:16 AM, Tom Hanstra wrote: > What are your other system preference values with regard to Privacy? > Perhaps we have a different combination of options in place? > > We have: > Don't Allow AnonSuggestions > Keep for EnableOpacSearchHistory > Don't allow OPAC Privacy > Allow opacreadinghistory > > Thanks, > Tom > > On 04/17/2012 03:55 AM, Chris Cormack wrote: >> On 17 April 2012 09:41, Tom Hanstra<tom(a)nd.edu> wrote: >>> 3.6.4 >>> >>> Thanks! >>> >>> Tom >> Hi Tom >> >> So I checked out 3.6.4 set up a borrower to use, and put that >> borrowernumber (17) into the anonymous patron syspref >> >> I then ran the anonymise feature and now >> >> select * from old_issues limit 3; >> +----------------+------------+------------+------------+---------------+--- ---------+-----------------+--------+----------+---------------------+------ ------+ >> | borrowernumber | itemnumber | date_due | branchcode | >> issuingbranch | returndate | lastreneweddate | return | renewals | >> timestamp | issuedate | >> +----------------+------------+------------+------------+---------------+--- ---------+-----------------+--------+----------+---------------------+------ ------+ >> | 17 | 6 | 2009-01-24 | WORK | NULL >> | 2009-01-03 | NULL | NULL | NULL | 2012-04-17 >> 19:52:30 | 2009-01-03 | >> | 17 | 2 | 2008-07-23 | WORK | NULL >> | 2009-04-19 | NULL | NULL | NULL | 2012-04-17 >> 19:52:30 | 2008-07-02 | >> | 17 | 4 | 2009-05-10 | OFFICE | NULL >> | 2009-04-19 | NULL | NULL | NULL | 2012-04-17 >> 19:52:30 | 2009-04-19 | >> +----------------+------------+------------+------------+---------------+--- ---------+-----------------+--------+----------+---------------------+------ ------+ >> >> They have all been changed to borrower 17, so it seems to be working >> fine for me >> >> I'm not sure what we are doing differently. >> >> Chris -- ------------------------------------------------------------------------ Tom Hanstra Systems Administrator Hesburgh Libraries of Notre Dame Phone: (574)631-4686 213 Hesburgh Library Email: tom(a)nd.edu Notre Dame, IN 46556 "Now, here, you see, it takes all the running you can do, to keep in the same place. If you want to get somewhere else, you must run at least twice as fast as that!" Lewis Carroll - Through the Looking Glass ------------------------------------------------------------------------ ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 78, Issue 39 ************************************

1 0

Re: [Koha] data migration from libsys to koha~
by Sunil Kumar 26 Jul '12

26 Jul '12

Dear Mr Vinod If you can send me the libsys data both .ISO format and .MRK format I can try my best to resolve the issue. (rsunil.kr(a)gmail.com) / 9686576695 Thanks and Regards R Sunil Kumar Library Technologist -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 02 May 2012 21:28 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 79, Issue 3 Send Koha mailing list submissions to koha(a)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(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)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. Adding Newspaper to Koha (diana soubra) 2. koha serch problem (vinod kumar) 3. Re: koha serch problem (Bob Birchall) 4. Re: Right To Left in Arabic KOHA (Karam Qubsi) 5. Re: data migration from libsys to koha (vinod kumar) 6. marc import (Marcel Sandow) 7. Re: marc import (Hugo Agud) 8. Upgrading koha to 3.8 (Ranadip Chandra) ---------------------------------------------------------------------- Message: 1 Date: Wed, 2 May 2012 05:29:47 +0000 From: diana soubra <tweety_dido(a)hotmail.com> To: <koha(a)lists.katipo.co.nz> Subject: [Koha] Adding Newspaper to Koha Message-ID: <BAY160-W46C7A8A623C930BAC1D681982E0(a)phx.gbl> Content-Type: text/plain; charset="iso-8859-1" Dear Koha, I have problem when adding daily newspaper or journals....I couldn't find an easy way, and when using serials I don't have such experience. If you can help me or give me a hint regarding this issue I will be more than thankful. Regards, Diana ------------------------------ Message: 2 Date: Wed, 2 May 2012 13:12:44 +0530 From: vinod kumar <vinod.kumar.trf(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] koha serch problem Message-ID: <CALkr8=+K-KKUt-ULChEpUW7D9_aZ3-ZDmK+R3fkBTbbi0GQFug(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi I am search the book on OPEC page but OPEC show this error zebra re-indexing is working how to solve please suggest me Error 404 - This error means that the link was broken and that the page doesn't exist. - To report this error, you can email the Koha Administrator<root(a)delhipubliclibrary.in> . - Use top menu bar to navigate to another part of Koha. Best Regards vinod ------------------------------ Message: 3 Date: Wed, 02 May 2012 17:48:16 +1000 From: Bob Birchall <bob(a)calyx.net.au> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] koha serch problem Message-ID: <4FA0E6C0.20608(a)calyx.net.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed On 02/05/12 17:42, vinod kumar wrote: > Hi > > I am search the book on OPEC page but OPEC show this error zebra > re-indexing is working how to solve please suggest me Error 404 > > - This error means that the link was broken and that the page doesn't > exist. This indicates that the record exists in the index but not in the mysql data base. This might arise because you have deleted a record but it has not been deleted from the index. Try a complete zebra re-build. Hope this helps, Bob Birchall Calyx ------------------------------ Message: 4 Date: Tue, 1 May 2012 10:21:16 +0300 From: Karam Qubsi <karamqubsi(a)gmail.com> To: Mason James <mtj(a)kohaaloha.com> Cc: Koha <Koha(a)lists.katipo.co.nz>, "koha-translate(a)lists.koha-community.org" <koha-translate(a)lists.koha-community.org>, "Davoodifar, H. Sam $EDU$" <H.Sam.Davoodifar(a)gov.mb.ca> Subject: Re: [Koha] Right To Left in Arabic KOHA Message-ID: <CAML=htYhG1bNtbi3sy7pikRFv3PWj6=EFwwnY6z7Vi3j0zNkqw(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi Mason, this is not clear for me , can you give us more explanation ? the po files contains strings (not) css codes so where we have to put this codes ? I almost done in make koha from right to left (by changing the css templates manually ) and it's seems to be OK when it finish . it's not just about the direction of the text all the site must be right to left ( some images must be changed like the directions of some arrows when browsing a Shelve ) so i wish you explain more to us about your idea it may make it more easy to us , in the links you provide they are talking about Pootle in general , i wish some one tell us if this available for koha too . thanks a lot. where I have to put the lang On Tue, May 1, 2012 at 2:18 AM, Mason James <mtj(a)kohaaloha.com> wrote: > > On 2012-05-1, at 9:36 AM, Karam Qubsi wrote: > >> Hi Sam, >> I think that we can create a css templates that support all the rtl >> languages and let the user select what he prefer if his language is >> ltr he will select the default one , or he will select the second >> choice rtl to support his language, but each language must be >> translated to be supported , our group is from the Arab world and we >> are working to make koha in Arabic we are working here ?: >> translate.koha-community.org/ar/36/ >> >> you can ask to open a Persian translation project and start >> translating , and when finishing you may find it easier if you find >> koha support the style from right to left :) > > > oops - i now see you have discovered the 'right-to-left' translate > option for pootle, already :) > > >> and koha 3.8 know is fully supported in search and retrieve for >> non-Latin languages . >> >> I hope you will find the best way to start your ?Persian project :) >> >> kind regards >> Karam Qubsi >> >> > -- Karam Qubsi Koha Arab translation Team http:koha.wikibrary.org Wikibrary for Arab librarians http://wikibrary.org ------------------------------ Message: 5 Date: Wed, 2 May 2012 16:20:48 +0530 From: vinod kumar <vinod.kumar.trf(a)gmail.com> To: amit bondwal <bondwal.amit(a)gmail.com> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] data migration from libsys to koha Message-ID: <CALkr8=Ke3HpmumCtW7LzOstgu1DeUhK4=oHuiQgozRw7JU-pVg(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Dear Amit sorry no idea for data migration. On Tue, Apr 24, 2012 at 1:07 PM, amit bondwal <bondwal.amit(a)gmail.com>wrote: > Dear All, > > I want to data migration from libsys to koha, > My current state is that I took backup from libsys in iso format and > convert > it in .mrk files. Now my problem is that it shows tag numbers like > 999 964 etc. When I tried to import .mrc files in koha by script > bulkmarcimport > in koha/bin/migration directory, it imported data but did not show 900 > series tags. > And it is not proper shows all information like accession numbers etc. > > That is my current status. Can anybody help me to properly tag mapping for > koha in > .mrk files. So that it can take all the data while importing properly. > > Any help will be helpfull regarding tag mapping from libsys to koha. > > Thanks in advance. > > Regards > Amit > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ Message: 6 Date: Wed, 02 May 2012 15:37:49 +0200 From: "Marcel Sandow" <MarcelSandow(a)gmx.de> To: koha(a)lists.katipo.co.nz Subject: [Koha] marc import Message-ID: <20120502133749.32340(a)gmx.net> Content-Type: text/plain; charset="utf-8" Dear Koha-List Members! presently I am working on importing a school library (>10000 records) into koha. I have a csv file with all items. The actual format is: author, title, full call number(shelf place), barcode I convert this file via marcedit into mrk, and mrc file. mrc sample: =LDR 00232nam a2200109Ia 45e0 =008 120501s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$aauthor =245 \\$atitle =952 \\$oFCN(Shelf) =952 \\$pbarcode Importing this mrc file via 'Stage marc record ...' results in a record with two items, one 952$o item and one 952$p item. I would expect to have one record with one item having the 952$o and the 952$p entry. Is this the standard behaviour? Are there any settings where I can define which mrc syntax will result in creating a new item? Is there a documentation how the import is handled? Some of my records have multiple item for one record, they look like: author, title, full call number(shelf place), barcode1 author, title, full call number(shelf place), barcode2 How should the mrc file look like to get a multiple item import with each having the 952$o entry? Maybe a marcedit forum would be the better address but maybe one of you can help how to set marcedit for converting the above mentioned csv structure into the necessary mrc file syntax?! any hints, links are welcome. Thanks all the best Marcel -- NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone! Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a ------------------------------ Message: 7 Date: Wed, 2 May 2012 15:50:49 +0200 From: Hugo Agud <hagud(a)orex.es> To: Marcel Sandow <MarcelSandow(a)gmx.de> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] marc import Message-ID: <CADT_QRQAbk4a+Ev_f9mRaOP5aTtwCphQ=PkMim+1T4QGfeiX-Q(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi You have to join the 952 fields into one...Koha ceate one item per 952 line. However you need more fields there... 952$a, $b and 952$y as minimum I think (a part of the $o and $p)... using MARCedit.. just control and select both fields... mousse: right buttom and click to join... that'sll ;) Hugo 2012/5/2 Marcel Sandow <MarcelSandow(a)gmx.de> > Dear Koha-List Members! > > presently I am working on importing a school library (>10000 records) into > koha. I have a csv file with all items. The actual format is: > > author, title, full call number(shelf place), barcode > > I convert this file via marcedit into mrk, and mrc file. > > mrc sample: > =LDR 00232nam a2200109Ia 45e0 > =008 120501s9999\\\\xx\\\\\\\\\\\\000\0\und\d > =100 \\$aauthor > =245 \\$atitle > =952 \\$oFCN(Shelf) > =952 \\$pbarcode > > Importing this mrc file via 'Stage marc record ...' results in a record > with two items, one 952$o item and one 952$p item. I would expect to have > one record with one item having the 952$o and the 952$p entry. > > Is this the standard behaviour? Are there any settings where I can define > which mrc syntax will result in creating a new item? Is there a > documentation how the import is handled? > > Some of my records have multiple item for one record, they look like: > > author, title, full call number(shelf place), barcode1 > author, title, full call number(shelf place), barcode2 > > How should the mrc file look like to get a multiple item import with each > having the 952$o entry? > > Maybe a marcedit forum would be the better address but maybe one of you > can help how to set marcedit for converting the above mentioned csv > structure into the necessary mrc file syntax?! > > any hints, links are welcome. Thanks > > all the best > > Marcel > -- > NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone! > Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)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(a)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: 8 Date: Wed, 2 May 2012 08:57:24 -0700 (PDT) From: Ranadip Chandra <ranadipchandra(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] Upgrading koha to 3.8 Message-ID: <1335974244683-5680924.post(a)n5.nabble.com> Content-Type: text/plain; charset=UTF-8 I am trying to upgrade the Koha to the version 3.8.0. I downloaded it and try to follow the steps given below : 1. sudo cd to Koha-3.8.0 2. sudo perl Makefile.PL --prev-install-log /usr/share/koha/misc/koha-install-log 3. sudo make 4. sudo make test 5. sudo make upgrade 6. Update the sources.list (/etc/apt/sources.list) to include following lines at the end of the file deb http://archive.ubuntu.com/ubuntu/ lucid main universe multiverse deb http://archive.ubuntu.com/ubuntu/ lucid-updates main universe multiverse deb http://archive.ubuntu.com/ubuntu/ lucid-security main universe multiverse 7. sudo apt-get update 8. Try to find out the missing perl module by using the command ? sudo perl koha_perl_deps.pl -m? 9. Try to install the missing perl module. While installing the following screen appears : http://koha.1045719.n5.nabble.com/file/n5680924/3.png Finally while open the koha interface browser shows the following message : Not Found The requested URL / was not found on this server. Apache/2.2.14 (Ubuntu) Server at localhost Port 8007 I checked the apache ports (/etc/apache2/ports.conf) which listens 8008 & 8007 and also changed the port numbers in koha-httpd.conf (/etc/koha/koha-httpd.conf) file. please help me. ----- Ranadip Chandra Assistant Librarian, Jadavpur University, Kolkata --700032, Email -- ranadipchandra(a)gmail.com -- View this message in context: http://koha.1045719.n5.nabble.com/Upgrading-koha-to-3-8-tp5680924.html Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 79, Issue 3 ***********************************

1 0

Re: [Koha] Unable to input MARC field
by Sunil Kumar 26 Jul '12

26 Jul '12

Dear Wilson, This will be bit technical. Step 1: Administration Step 2: MARC Framework Step 3: BKS Framework Structure (select the framework you are using). Step 4: search for MARC tag 260 Step 5: check individually all the sub fields of 260 and see the configuration. Step 6: if any field is configure especially (260$a, 260$b and 260$c) and make necessary changes. Do let me know if you need any help. Thanks and Regards R Sunil Kumar Library Technologist -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 06 June 2012 05:30 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 80, Issue 11 Send Koha mailing list submissions to koha(a)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(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)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. Unable to input MARC field (Stew Wilson) 2. Problem in importing Patron Records (Prajeesh) 3. Re: CAS Server/koha (Matthias Meusburger) 4. Re: Problem in importing Patron Records (Paul) ---------------------------------------------------------------------- Message: 1 Date: Tue, 5 Jun 2012 13:34:54 +0800 From: Stew Wilson <stewartrwilson(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] Unable to input MARC field Message-ID: <CAACR0DFK1bA=m=Q1mhppAjPFL00ZmC8za17bgV9iu9x=e8xYow(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi Everyone, I'm very much a Koha newbie, so sorry if it's a silly question: I have made myself a customised MARC framework. During this process I accidentally deleted tag 260. So I added it again as a new tag and just copied the details from the default framework. So now when I go into the edit record screen of a book I can see tag 260, but I can't add any information to it. I can see a cursor in each subfield, but I can't type anything into it. I guess this is something to do with authorities, but sadly I have no idea if this is true, or how to fix it. Is anyone able to point me in the right direction? Cheers, Stew ------------------------------ Message: 2 Date: Tue, 5 Jun 2012 15:09:19 +0530 From: Prajeesh <prajeeshb77(a)gmail.com> To: Koha <Koha(a)lists.katipo.co.nz> Subject: [Koha] Problem in importing Patron Records Message-ID: <CAD=TC1quA1tsEA4teLQY+=xJieeZo7NGK8LwR73Q0PXtysZU1w(a)mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Dear all I tried to import a .csv file to my Koha installation (version 3.06.01.000) and got the following errors. I have checked the Branch code and the Category Code. It is give correct in the .csv file. Is there any bug reported in this version regarding patron import. Please help me. The .csv file is attached. Import Patrons Import results : - 0 imported records - 0 overwritten - 0 not imported because already in borrowers table and overwrite disabled - 2 not imported because they are not in the expected format - 2 records parsed - Back to Tools<http://192.168.1.2:8000/cgi-bin/koha/tools/tools-home.pl> Feedback: - Parsing upload file patron_import BPT2011 (copy).csv - Content-Type : text/csv - Content-Disposition : form-data; name="uploadborrowers"; filename="patron_import BPT2011 (copy).csv" - headerrow : Error analysis: - Header row could not be parsed - Line 2 could not be parsed! "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" - Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" - Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" - Line 3 could not be parsed! "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" - Line 3 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" - Line 3 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" -- With Regards Prajeesh Bhaskaran Mahatma Gandhi University Library Kottayam, Kerala- 686 560 http://kerala-lis.blogspot.com/. ------------------------------ Message: 3 Date: Tue, 05 Jun 2012 10:47:22 +0100 From: Matthias Meusburger <matthias.meusburger(a)biblibre.com> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] CAS Server/koha Message-ID: <4FCDD5AA.20600(a)biblibre.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hello, The CAS Authentication (with the casAuthentication and casServerUrl sysprefs) only works for OPAC side at the moment. Is it through thoses sysprefs you tried to enable CAS ? Matthias Meusburger Le 04/06/2012 14:08, Samuel desseaux a ?crit : > Hi! > > I want to link koha to a CAS Server (only for the professionnal side). > > In the administration tool, it seems to be easy. > > > But, does koha need specific perl modules? > > I've enabled mod-proxy on apache and add this part in the virtualhost > > <IfModule mod_proxy.c> > ProxyRequests Off > > <Proxy *> > Order Allow,Deny > Allow from All > AuthName "Acces Koha" > AuthType CAS > Require valid-user ***** * * * > </Proxy> > > Beste regards > > samuel > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 4 Date: Tue, 05 Jun 2012 10:11:40 -0400 From: Paul <paul.a(a)aandc.org> To: Koha <Koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Problem in importing Patron Records Message-ID: <5.2.1.1.2.20120605100748.050f2ad8@localhost> Content-Type: text/plain; charset="us-ascii"; format=flowed At 03:09 PM 6/5/2012 +0530, Prajeesh wrote: >Dear all > >I tried to import a .csv file to my Koha installation (version 3.06.01.000) >and got the following errors. I have checked the Branch code and the >Category Code. It is give correct in the .csv file. Is there any bug >reported in this version regarding patron import. Please help me. The .csv >file is attached. The file was not attached. Did you use the default Koha format for dates as YYYY-MM-DD? From the errors, you appear to be using DD/MM/YYYY (but this could just be your sys pref for output.) Paul > Import Patrons Import results : > > - 0 imported records > - 0 overwritten > - 0 not imported because already in borrowers table and overwrite > disabled > - 2 not imported because they are not in the expected format > - 2 records parsed > - Back to Tools<http://192.168.1.2:8000/cgi-bin/koha/tools/tools-home.pl> > > Feedback: > > - Parsing upload file patron_import BPT2011 (copy).csv > - Content-Type : text/csv > - Content-Disposition : form-data; name="uploadborrowers"; > filename="patron_import BPT2011 (copy).csv" > - headerrow : > > Error analysis: > > - Header row could not be parsed > - Line 2 could not be parsed! > "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" > - Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" > - Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" > - Line 3 could not be parsed! > "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" > - Line 3 Critical field "categorycode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" > - Line 3 Critical field "branchcode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" > > > >-- >With Regards > >Prajeesh Bhaskaran > Mahatma Gandhi University Library >Kottayam, Kerala- 686 560 >http://kerala-lis.blogspot.com/. >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca> ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 80, Issue 11 ************************************

1 0

Re: [Koha] Problem in importing Patron Records
by Sunil Kumar 26 Jul '12

26 Jul '12

Dear Prajeesh, Try to de-active the mandatory field (BorrowerMandatoryField) in patron category in Global Preference and remove all the fields. Then try to upload the patron CSV files. But make sure that patron category code and branch code of the library is matching in Koha as per the CSV file. Best of luck Thanks and Regards R Sunil Kumar Library Technologist -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 06 June 2012 05:30 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 80, Issue 11 Send Koha mailing list submissions to koha(a)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(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)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. Unable to input MARC field (Stew Wilson) 2. Problem in importing Patron Records (Prajeesh) 3. Re: CAS Server/koha (Matthias Meusburger) 4. Re: Problem in importing Patron Records (Paul) ---------------------------------------------------------------------- Message: 1 Date: Tue, 5 Jun 2012 13:34:54 +0800 From: Stew Wilson <stewartrwilson(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] Unable to input MARC field Message-ID: <CAACR0DFK1bA=m=Q1mhppAjPFL00ZmC8za17bgV9iu9x=e8xYow(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi Everyone, I'm very much a Koha newbie, so sorry if it's a silly question: I have made myself a customised MARC framework. During this process I accidentally deleted tag 260. So I added it again as a new tag and just copied the details from the default framework. So now when I go into the edit record screen of a book I can see tag 260, but I can't add any information to it. I can see a cursor in each subfield, but I can't type anything into it. I guess this is something to do with authorities, but sadly I have no idea if this is true, or how to fix it. Is anyone able to point me in the right direction? Cheers, Stew ------------------------------ Message: 2 Date: Tue, 5 Jun 2012 15:09:19 +0530 From: Prajeesh <prajeeshb77(a)gmail.com> To: Koha <Koha(a)lists.katipo.co.nz> Subject: [Koha] Problem in importing Patron Records Message-ID: <CAD=TC1quA1tsEA4teLQY+=xJieeZo7NGK8LwR73Q0PXtysZU1w(a)mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Dear all I tried to import a .csv file to my Koha installation (version 3.06.01.000) and got the following errors. I have checked the Branch code and the Category Code. It is give correct in the .csv file. Is there any bug reported in this version regarding patron import. Please help me. The .csv file is attached. Import Patrons Import results : - 0 imported records - 0 overwritten - 0 not imported because already in borrowers table and overwrite disabled - 2 not imported because they are not in the expected format - 2 records parsed - Back to Tools<http://192.168.1.2:8000/cgi-bin/koha/tools/tools-home.pl> Feedback: - Parsing upload file patron_import BPT2011 (copy).csv - Content-Type : text/csv - Content-Disposition : form-data; name="uploadborrowers"; filename="patron_import BPT2011 (copy).csv" - headerrow : Error analysis: - Header row could not be parsed - Line 2 could not be parsed! "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" - Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" - Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" - Line 3 could not be parsed! "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" - Line 3 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" - Line 3 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" -- With Regards Prajeesh Bhaskaran Mahatma Gandhi University Library Kottayam, Kerala- 686 560 http://kerala-lis.blogspot.com/. ------------------------------ Message: 3 Date: Tue, 05 Jun 2012 10:47:22 +0100 From: Matthias Meusburger <matthias.meusburger(a)biblibre.com> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] CAS Server/koha Message-ID: <4FCDD5AA.20600(a)biblibre.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hello, The CAS Authentication (with the casAuthentication and casServerUrl sysprefs) only works for OPAC side at the moment. Is it through thoses sysprefs you tried to enable CAS ? Matthias Meusburger Le 04/06/2012 14:08, Samuel desseaux a ?crit : > Hi! > > I want to link koha to a CAS Server (only for the professionnal side). > > In the administration tool, it seems to be easy. > > > But, does koha need specific perl modules? > > I've enabled mod-proxy on apache and add this part in the virtualhost > > <IfModule mod_proxy.c> > ProxyRequests Off > > <Proxy *> > Order Allow,Deny > Allow from All > AuthName "Acces Koha" > AuthType CAS > Require valid-user ***** * * * > </Proxy> > > Beste regards > > samuel > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 4 Date: Tue, 05 Jun 2012 10:11:40 -0400 From: Paul <paul.a(a)aandc.org> To: Koha <Koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Problem in importing Patron Records Message-ID: <5.2.1.1.2.20120605100748.050f2ad8@localhost> Content-Type: text/plain; charset="us-ascii"; format=flowed At 03:09 PM 6/5/2012 +0530, Prajeesh wrote: >Dear all > >I tried to import a .csv file to my Koha installation (version 3.06.01.000) >and got the following errors. I have checked the Branch code and the >Category Code. It is give correct in the .csv file. Is there any bug >reported in this version regarding patron import. Please help me. The .csv >file is attached. The file was not attached. Did you use the default Koha format for dates as YYYY-MM-DD? From the errors, you appear to be using DD/MM/YYYY (but this could just be your sys pref for output.) Paul > Import Patrons Import results : > > - 0 imported records > - 0 overwritten > - 0 not imported because already in borrowers table and overwrite > disabled > - 2 not imported because they are not in the expected format > - 2 records parsed > - Back to Tools<http://192.168.1.2:8000/cgi-bin/koha/tools/tools-home.pl> > > Feedback: > > - Parsing upload file patron_import BPT2011 (copy).csv > - Content-Type : text/csv > - Content-Disposition : form-data; name="uploadborrowers"; > filename="patron_import BPT2011 (copy).csv" > - headerrow : > > Error analysis: > > - Header row could not be parsed > - Line 2 could not be parsed! > "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" > - Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" > - Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" > - Line 3 could not be parsed! > "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" > - Line 3 Critical field "categorycode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" > - Line 3 Critical field "branchcode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" > > > >-- >With Regards > >Prajeesh Bhaskaran > Mahatma Gandhi University Library >Kottayam, Kerala- 686 560 >http://kerala-lis.blogspot.com/. >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca> ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 80, Issue 11 ************************************

1 0

Re: [Koha] How to bulk delete the patrons after expiry of membership
by Sunil Kumar 26 Jul '12

26 Jul '12

Dear Mr. Vimal, The best way to delete these records is by building a SQL Query where u select particular category and check the expiry date and then bulk delete. Thanks and Regards R Sunil Kumar Library Technologist -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 11 June 2012 05:30 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 80, Issue 16 Send Koha mailing list submissions to koha(a)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(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)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. How to bulk delete the patrons after expiry of membership (Vimal Kumar) 2. Re: Date format (Vimal Kumar) 3. Unable to update form (Stew Wilson) 4. German article on Koha (Mirko) 5. Upgrading Koha 3.4 to Koha 3.8 ?? (jp_powell) 6. Re: Upgrading Koha 3.4 to Koha 3.8 ?? (Olugbenga Adara) ---------------------------------------------------------------------- Message: 1 Date: Sun, 10 Jun 2012 11:48:06 +0530 From: Vimal Kumar <vimal0212(a)gmail.com> To: Koha-List <koha(a)lists.katipo.co.nz> Subject: [Koha] How to bulk delete the patrons after expiry of membership Message-ID: <CAEaJrwUV7KeQfe0iuknLE=QsWFyYCKimck_EDmLCOFYmZEa+5w(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Dear Friends, How to bulk delete patrons expired membership ? For example, when an academic year ends, we have to delete batch of students. How it possible? Regards -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White ------------------------------ Message: 2 Date: Sun, 10 Jun 2012 11:56:13 +0530 From: Vimal Kumar <vimal0212(a)gmail.com> To: Koha-List <koha(a)lists.katipo.co.nz>, sandeep bhavsar <sandeep.bhavsar(a)gmail.com> Subject: Re: [Koha] Date format Message-ID: <CAEaJrwUt4+CKh7-ocd0Z-E0ur9y_ppaTgMv9+n=2Cr_ZZgpdNg(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Dear Sandeep, Another solution is change date format in Koha to YYYY-MM-DD. Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White ------------------------------ Message: 3 Date: Sun, 10 Jun 2012 19:03:33 +0800 From: Stew Wilson <stewartrwilson(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] Unable to update form Message-ID: <CAACR0DH9MW7qukLVygJqMnNMJ-bjkcwNppFCwg9h0ykEsDXMhQ(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi everyone, I am very new to Koha - and this seems like a question which is often asked, but I have not yet found a comprehensible response! I tried editing my own MARC framework. This worked well, until I accidentally deleted a tag that I wanted to keep. So, I added it as a new tag, and copy-pasted the information from the existing tag in the default framework. This added fine and looks no different from the information in the default framework. However, when I now try to input information into that tag as I'm adding a new record, I am unable to enter anything in the box. The cursor is there, but nothing is entered in the field. I have a feeling that this something to do with authorities - but I wouldn't know where to start! Is someone able to point me in the right direction? Thanks, Stew ------------------------------ Message: 4 Date: Sun, 10 Jun 2012 17:21:12 +0200 From: Mirko <5p4m(a)gmx.de> To: Koha-List <koha(a)lists.katipo.co.nz> Subject: [Koha] German article on Koha Message-ID: <4FD4BB68.4030403(a)gmx.de> Content-Type: text/plain; charset=ISO-8859-15 It may or may not be of interest that the newsletter of "Arbeitskreis der Sprachenzentren" (June 2012) contains an article on Koha. It is written in German and can be found here: http://www.aks-web.de/newsletter/ - Mirko ------------------------------ Message: 5 Date: Sun, 10 Jun 2012 09:01:06 -0700 (PDT) From: jp_powell <nice2odie(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] Upgrading Koha 3.4 to Koha 3.8 ?? Message-ID: <1339344066745-5715857.post(a)n5.nabble.com> Content-Type: text/plain; charset=us-ascii What is the best and easiest way to upgrade Koha 3.4 to Koha 3.8 running on Debian Squeeze? The key here is NOT to lose the data in the database tables. I am hoping that there are MySQL scripts to move data around if there are table differences between the 3.4 and 3.8. Thank you. jp -- View this message in context: http://koha.1045719.n5.nabble.com/Upgrading-Koha-3-4-to-Koha-3-8-tp5715857.h tml Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ Message: 6 Date: Sun, 10 Jun 2012 09:08:29 -0700 (PDT) From: Olugbenga Adara <gbengaadara(a)yahoo.com> To: koha(a)lists.katipo.co.nz, jp_powell <nice2odie(a)gmail.com> Subject: Re: [Koha] Upgrading Koha 3.4 to Koha 3.8 ?? Message-ID: <1339344509.85103.YahooMailClassic(a)web161002.mail.bf1.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Hello Jp, --- On Sun, 6/10/12, jp_powell <nice2odie(a)gmail.com> wrote: > What is the best and easiest way to > upgrade Koha 3.4 to Koha 3.8 running on > Debian Squeeze? > > The key here is NOT to lose the data in the database > tables.? I am hoping > that there are MySQL scripts to move data around if there > are table > differences between the 3.4 and 3.8. /listinfo/koha > I am not sure whether this will work for 3.8 since i have not tested it. But what i do for 3.4 (or 3.2 though that involves running another script after upgrade) to 3.6 is to install 3.6 normally. then delete the 3.6 database and repalce with a dump from 3.4. On a login to the staff client, koha automatically senses the older database and upgrades to 3.6. Hope that helps. Olugbenga Adara ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 80, Issue 16 ************************************

1 0

Reply: Insert records in mysql
by Sunil Kumar 26 Jul '12

26 Jul '12

Dear Viviane; You have to MASTER in database management. There are 100s of table and most importantly bibliographic of one library items goes into different table. And it is very hard to track down all the table and building foreign key, etc, etc. Thanks and Regards R Sunil Kumar Library Technologist -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 03 July 2012 22:31 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 81, Issue 6 Send Koha mailing list submissions to koha(a)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(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)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: i need your help on installing koha (themneks) 2. Re: I NEED HELP ON INSTALLING KOHA (MJ Ray) 3. Re: i need your help on installing koha (David Nind) 4. Cataloguing Items with Multiple Parts (Joel Harbottle) 5. Re: Cataloguing Items with Multiple Parts (Nicole Engard) 6. Insert records in mysql (Viviane Ventura) 7. Check In - Check out multiple items. (Laquerre, Anthony) 8. [discussion] Privacy issue (bug 3280) (Paul Poulain) 9. Re: Insert records in mysql (Robin Sheat) 10. Re: [Koha-devel] [discussion] Privacy issue (bug 3280) (Chris Cormack) ---------------------------------------------------------------------- Message: 1 Date: Tue, 3 Jul 2012 03:21:10 -0700 (PDT) From: themneks <jmasibo(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] i need your help on installing koha Message-ID: <1341310870263-5718352.post(a)n5.nabble.com> Content-Type: text/plain; charset=us-ascii Thanks alot Mirko koha version am trying to install is koha 3.02.04 debian version is debian 6.0.5 am just new to linux and koha too so i was using this guide http://www.blazingmoon.org/news/2008/12/install-koha-on-ubuntu-part-4-koha/ any help will be appreciated thanks -- View this message in context: http://koha.1045719.n5.nabble.com/i-need-your-help-on-installing-koha-tp5718 333p5718352.html Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ Message: 2 Date: Tue, 03 Jul 2012 11:33:01 +0100 From: MJ Ray <mjr(a)phonecoop.coop> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] I NEED HELP ON INSTALLING KOHA Message-ID: <E1Sm0Pk-0002TF-Vm(a)petrol.towers.org.uk> jackymasibo wrote: > i am trying to install koha on a debian pc and when i run apt get > update i get the following error messages > > Err http://ftp.indexdata.dk indexdata/sarge/released Sources > 404 Not Found http://www.debian.org/releases/sarge/ says Debian GNU/Linux 3.1 (a.k.a. sarge) was released on 6th of June, 2005. The new release includes many major changes, described in our press release and the Release Notes. Debian GNU/Linux 3.1 has been superseded by Debian GNU/Linux 4.0 ("etch"). Security updates have been discontinued as of the end of March 2008. indexdata no longer support a 7-year-old version that was end-of-lifed over 4 years ago. Sorry but it's upgrade time. Try http://www.debian.org/releases/stable/ which is currently version 6.0 Hope that helps, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ ------------------------------ Message: 3 Date: Tue, 3 Jul 2012 23:19:15 +1200 From: David Nind <david.nind(a)gmail.com> To: themneks <jmasibo(a)gmail.com> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] i need your help on installing koha Message-ID: <CAK5OMPcqc8q=XMhEXj9A2AN0pxHwc+-qs4ojYYZCVUc-8i_6kg(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi. > koha version am trying to install is koha 3.02.04 > This is an older version of Koha (released in October 2010). Would recommend installing a newer version - 3.8.2 is the latest but is still relatively new (initial release in April, with latest update in June). You could also go with the latest 3.6 version (3.6.6 released in June). To understand the version numbering see: http://koha-community.org/about/release-schedule/ Installation instructions are included with the download - this is the best place to look initially. David Nind | david.nind(a)gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 ------------------------------ Message: 4 Date: Sun, 3 Jul 2011 23:16:32 +1000 From: Joel Harbottle <Joel.Harbottle(a)hotmail.com.au> To: <koha(a)lists.katipo.co.nz> Subject: [Koha] Cataloguing Items with Multiple Parts Message-ID: <BLU0-SMTP476788B6ECFFA67B2F5E6D7A8E90(a)phx.gbl> Content-Type: text/plain; charset="us-ascii" Hi All, I'm cataloguing an item with multiple books as part of the package. Ideally, I want to catalogue each individual book in the package and then link those Bibliographic records to a 'main' Bibliographic record for the kit/package? I used to be able to easily do this in our old ILS, but still haven't come up with a way to achieve this in Koha. Does anyone have any suggestions?? Best Wishes, Joel Joel Harbottle Library Technician Library Processing Services (Qld.) Email: Joel.Harbottle(a)hotmail.com.au ------------------------------ Message: 5 Date: Tue, 3 Jul 2012 09:46:01 -0400 From: Nicole Engard <nengard(a)gmail.com> To: Joel Harbottle <Joel.Harbottle(a)hotmail.com.au> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Cataloguing Items with Multiple Parts Message-ID: <CAC0K6VG4tyrWaAszwTmLCRKDrNZMO3cqjJBURcpg=AS4ZOK6qA(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Joel, You're talking about Analytics and Koha does have Analytics support so hopefully this will help: http://manual.koha-community.org/3.8/en/cataloging.html#cataloganalytics Nicole On Sun, Jul 3, 2011 at 9:16 AM, Joel Harbottle <Joel.Harbottle(a)hotmail.com.au> wrote: > Hi All, > > > > I'm cataloguing an item with multiple books as part of the package. > > > > Ideally, I want to catalogue each individual book in the package and then > link those Bibliographic records to a 'main' Bibliographic record for the > kit/package? > > > > I used to be able to easily do this in our old ILS, but still haven't come > up with a way to achieve this in Koha. Does anyone have any suggestions?? > > > > Best Wishes, > > Joel > > > > > > Joel Harbottle > > Library Technician > > > > Library Processing Services (Qld.) > > Email: Joel.Harbottle(a)hotmail.com.au > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 6 Date: Tue, 3 Jul 2012 13:00:01 -0300 From: Viviane Ventura <vaventura1(a)yahoo.com.br> To: koha(a)lists.katipo.co.nz Subject: [Koha] Insert records in mysql Message-ID: <CAHrHr+H8MQHSVGKXcrC2XWCJvAqHYkpJG0uJEMoLf3D1bzHG-Q(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hey, folks Can i insert records in mysql (biblio, biblioitems and items) directly? Thanks ------------------------------ Message: 7 Date: Tue, 3 Jul 2012 16:10:24 +0000 From: "Laquerre, Anthony" <Anthony.Laquerre(a)ccsr.qc.ca> To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: [Koha] Check In - Check out multiple items. Message-ID: <F680EA6566032E4E94FFBB064D4848631164312C(a)06FDSRV.fedecegeps.qc.ca> Content-Type: text/plain; charset="us-ascii" Hi everyone, We are currently looking at is a way to check in and check out a single items that link to multiple items. Here's the need : Check out : User have a box. Inside that box there is : 1 - Camera, 1- Cable, 1- Speaker. Each individual item have a barcode. What we would like to do is : If I scan the box barcode , I will at the same checkout : Camera, Cable and the speaker. On check in, we would like a smiliar process but we would need to make each item are really return... Is that possible rignt now in Koha ? If not, what do you think of the idea ? Thanks! Anthony ------------------------------ Message: 8 Date: Tue, 03 Jul 2012 18:17:24 +0200 From: Paul Poulain <paul.poulain(a)biblibre.com> To: Koha-devel(a)lists.koha-community.org, Koha-Mailinglist <Koha(a)lists.katipo.co.nz> Subject: [Koha] [discussion] Privacy issue (bug 3280) Message-ID: <4FF31B14.5040508(a)biblibre.com> Content-Type: text/plain; charset=ISO-8859-1 Hello Koha users & developers, The bug 3280 fixes a problem in cart sending in opac : the behaviour has changed, and for security reason, it will be possible only for logged-in users. A question has also been raised : we could also add the IP address of the sender in the mail that Koha sent. Do you think : 1- we could 2- we should 3- we shouldn't (and why) I start arguing = I think we should, and in France, I think it's a legal issue, you must be able to answer any legal request from a court (9-11, thank you :\ ) It's right we have the username, but the IP address is a good complement -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08 ------------------------------ Message: 9 Date: Tue, 03 Jul 2012 17:27:01 +0100 From: Robin Sheat <robin(a)catalyst.net.nz> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Insert records in mysql Message-ID: <4FF31D55.2040705(a)catalyst.net.nz> Content-Type: text/plain; charset=UTF-8 Op 03-07-12 17:00, Viviane Ventura schreef: > Hey, folks > > Can i insert records in mysql (biblio, biblioitems and items) directly? It's possible, but it's really not recommended unless the data you're putting in there comes from a very similar Koha instance. Things like creating MARC record parts is not feasible to do by hand. -- Robin Sheat Catalyst IT Ltd. ? +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D ------------------------------ Message: 10 Date: Wed, 04 Jul 2012 05:00:20 +1200 From: Chris Cormack <chrisc(a)catalyst.net.nz> To: Paul Poulain <paul.poulain(a)biblibre.com>, Koha-devel(a)lists.koha-community.org, Koha-Mailinglist <Koha(a)lists.katipo.co.nz> Subject: Re: [Koha] [Koha-devel] [discussion] Privacy issue (bug 3280) Message-ID: <09222531-3f7e-4ba3-9ab5-fddc719ebf7b(a)email.android.com> Content-Type: text/plain; charset=UTF-8 Make it a syspref, so it can work for all jurisdictions. Problem solved. Chris Paul Poulain <paul.poulain(a)biblibre.com> wrote: Hello Koha users & developers, The bug 3280 fixes a problem in cart sending in opac : the behaviour has changed, and for security reason, it will be possible only for logged-in users. A question has also been raised : we could also add the IP address of the sender in the mail that Koha sent. Do you think : 1- we could 2- we should 3- we shouldn't (and why) I start arguing = I think we should, and in France, I think it's a legal issue, you must be able to answer any legal request from a court (9-11, thank you :\ ) It's right we have the username, but the IP address is a good complement -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08 _____________________________________________ 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/ ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 81, Issue 6 ***********************************

1 0

stage marc import of records with items
by eugene jose espinoza 26 Jul '12

26 Jul '12

Good day koha users and developers. I tried koha 3.8 through Kyle Hall's wonderful virtual machine. I stage marc import a bibliographic record with attached items (marc field 952). The problem is the items are not imported. Could this be a bug? or I miss out something? thanks. EUGENE JOSE T. ESPINOZA

4 3

(no subject)
by eugene jose espinoza 26 Jul '12

26 Jul '12

good day koha users and developers. I'm trying out version 3.8 in Ubuntu 10.04. Already installed koha and it's dependencies. already run zebra indexer fast index, -x -b. My problem is that why are there no items in my catalog (OPAC and admin interface)? I'm at lost. in my previous koha installation, 3.2. to 3.6, the items for the biblios are there, but now for koha 3.8 there are none. hope you can help me with this. thank you. EUGENE JOSE T. ESPINOZA Legislative Staff Officer II House of Representatives Legislative Library Services Congressional Library Bureau Archives Assistant Salvador H. Laurel Archives

3 2