- Koha - lists.katipo.co.nz

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

koha 3.8 on debian 6.0.2 missing items
by eugene jose espinoza 26 Jul '12

26 Jul '12

Good day! I freshly installed koha 3.8 (the latest version) in Debian 6.0.2 through Virtualbox. I imported mysql data into the database which were gotten from previous koha installations (virtual machines of Kyle Hall Koha versions 3.2 then Koha 3.6). The problem I'm getting is that there are no physical items on the (bibliographic) records when in fact there was in the previous KOha versions. I've tried all stuffs like run misc/maintenance/remove_items_from_biblioitems.pl --run I got this error message: Use of uninitialized value $cn_item in concatenation (.) or string at /usr/share/koha/lib/C4/ClassSortRoutine.pm line 118. Use of uninitialized value $cn_class in concatenation (.) or string at /usr/share/koha/lib/C4/ClassSortRoutine.pm line 118. Use of uninitialized value $cn_item in concatenation (.) or string at /usr/share/koha/lib/C4/ClassSortRoutine.pm line 118. .Use of uninitialized value $cn_class in concatenation (.) or string at /usr/share/koha/lib/C4/ClassSortRoutine.pm line 118. Use of uninitialized value $cn_item in concatenation (.) or string at /usr/share/koha/lib/C4/ClassSortRoutine.pm line 118. Use of uninitialized value $cn_class in concatenation (.) or string at /usr/share/koha/lib/C4/ClassSortRoutine.pm line 118. Use of uninitialized value $cn_item in concatenation (.) or string at /usr/share/koha/lib/C4/ClassSortRoutine.pm line 118. .No biblionumber tag for framework "LAWS" at /usr/share/koha/lib/C4/Biblio.pm line 3103. then run rebuildzebra and got this error message: error retrieving biblio 79032 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 485. error retrieving biblio 79033 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 485. 17:09:44-02/07 zebraidx(2768) [warn] MARC: Bad offsets in data. Skipping rest 17:09:44-02/07 zebraidx(2768) [warn] Record didn't contain match fields in (bib1,Local-number) Thanks and long live KOha! EUGENE ESPINOZA

2 1

Re: [Koha] Authority indexing
by Marcel de Rooy 25 Jul '12

25 Jul '12

Hi, Below a fragment from a discussion on authority indexing on the dev list. As a developer, I would like to get some specific librarian feedback on this list. > Another thought to add to the discussion: If we need the difference between searching through main headings, all subfields and main headings $a only, why do we not present these four identical options in opac and staff? It seems overkill to me, but please speak up if you need one of the two ! Do you (your library) make good use of searching authorities in staff client? There are three searches there. Note that the first one ("Search authorities") only looks in heading $a subfields. Do you need the difference when searching authorities between $a only or all subfields? Would you need the other one: headings, all subfields? Hope I am being clear enough .. Thanks, Marcel

4 3

Koha space usage
by rfblanchard 25 Jul '12

25 Jul '12

Hi, I'm doing some investigation into the space usage on my server and noticed the following take the most space: 7.0 G *********************** ./var/lib/mysql 8.6 G ************************ ./var/lib/koha/kohapei/biblios/register 9.3 G ************************ ./var/lib/koha/kohapei/biblios/shadow The first folder is the database. Questions: 1) are the 'register' and 'shadow' directories and the files within generated during the zebra indexing? 2) is it normal for these directories to each be bigger than the size of the entire koha database? 3) do these directories continue to grow with each reindex? 4) should I do anything to reduce the size of these directories? Thanks for any input Ryan -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-space-usage-tp5721170.html Sent from the Koha-general mailing list archive at Nabble.com.

2 1

languages mixed up in koha 3.8
by w4＠online.de 25 Jul '12

25 Jul '12

dear list, i am new to koha. i installed it yesterday to do some testing. i have two languages installed. once i changed to german and back to english, the contents of menues stay in german. switching again doesn't help. the logs don't show any error messages. do you have an idea, what's wrong there? thanx! bio

2 2

Sandbox servers provided by BibLibre
by Paul Poulain 25 Jul '12

25 Jul '12

Hello, On the wiki page, you can see that the wiki page dealing with sandboxes provided by BibLibre now present 6 sandboxes (3 UNIMARC and 3 MARC21), instead of 9 The reason is: * there was only a few use of the sandboxes, 6 publicly open should be enough * we have found some volunteers in France to dedicate time to testing (for example, one of them promised to dedicate half a day every week). So we have decided to dedicate them a specific/named sandbox. previous testN.sandbox.biblibre.com have been reclycled If you see URL with french cheese in the name of some comment (http://camembert.sandbox.biblibre.com) you'll know it's a "recycled" sandbox (complete spoiler = the 1st letter of the cheese being also the 1st letter of the 1st name of the volunteer. In this case : Camembert = Corinne. You'll also have Pelardon for Pierre and Serac for Sonia. New ones should be coming with Mathilde, Leila, and hopefully some others) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0