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-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of koha-requ...@lists.katipo.co.nz Sent: 03 July 2012 22:31 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 81, Issue 6 Send Koha mailing list submissions to koha@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-requ...@lists.katipo.co.nz You can reach the person managing the list at koha-ow...@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 <jmas...@gmail.com> To: koha@lists.katipo.co.nz Subject: Re: [Koha] i need your help on installing koha Message-ID: <1341310870263-5718352.p...@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 <m...@phonecoop.coop> To: koha@lists.katipo.co.nz Subject: Re: [Koha] I NEED HELP ON INSTALLING KOHA Message-ID: <e1sm0pk-0002tf...@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.n...@gmail.com> To: themneks <jmas...@gmail.com> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] i need your help on installing koha Message-ID: <CAK5OMPcqc8q=xmhexj9a2an0pxhwc+-qs4ojyyzcvuc-8i_...@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.n...@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.harbot...@hotmail.com.au> To: <koha@lists.katipo.co.nz> Subject: [Koha] Cataloguing Items with Multiple Parts Message-ID: <blu0-smtp476788b6ecffa67b2f5e6d7a8...@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.harbot...@hotmail.com.au ------------------------------ Message: 5 Date: Tue, 3 Jul 2012 09:46:01 -0400 From: Nicole Engard <neng...@gmail.com> To: Joel Harbottle <joel.harbot...@hotmail.com.au> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Cataloguing Items with Multiple Parts Message-ID: <CAC0K6VG4tyrWaAszwTmLCRKDrNZMO3cqjJBURcpg=as4zok...@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.harbot...@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.harbot...@hotmail.com.au > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@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 <vaventu...@yahoo.com.br> To: koha@lists.katipo.co.nz Subject: [Koha] Insert records in mysql Message-ID: <cahrhr+h8mqhsvgkxcrc2xwcjvaqhykpjg0ujemolf3d1bzh...@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.laque...@ccsr.qc.ca> To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: [Koha] Check In - Check out multiple items. Message-ID: <f680ea6566032e4e94ffbb064d48486311643...@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.poul...@biblibre.com> To: koha-de...@lists.koha-community.org, Koha-Mailinglist <Koha@lists.katipo.co.nz> Subject: [Koha] [discussion] Privacy issue (bug 3280) Message-ID: <4ff31b14.5040...@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 <ro...@catalyst.net.nz> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Insert records in mysql Message-ID: <4ff31d55.2040...@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 <chr...@catalyst.net.nz> To: Paul Poulain <paul.poul...@biblibre.com>, koha-de...@lists.koha-community.org, Koha-Mailinglist <Koha@lists.katipo.co.nz> Subject: Re: [Koha] [Koha-devel] [discussion] Privacy issue (bug 3280) Message-ID: <09222531-3f7e-4ba3-9ab5-fddc719eb...@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.poul...@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-de...@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 81, Issue 6 *********************************** _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha