[Koha] Reply: Insert records in mysql

Thu Jul 26 16:27:40 NZST 2012

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 at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
koha-request at lists.katipo.co.nz
Sent: 03 July 2012 22:31
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 81, Issue 6

Send Koha mailing list submissions to
	koha at lists.katipo.co.nz

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
	koha-request at lists.katipo.co.nz

You can reach the person managing the list at
	koha-owner at lists.katipo.co.nz

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Koha digest..."

Today's Topics:

   1. Re: 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 at gmail.com>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] i need your help on installing koha
Message-ID: <1341310870263-5718352.post at 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 at phonecoop.coop>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] I NEED HELP ON INSTALLING KOHA
Message-ID: <E1Sm0Pk-0002TF-Vm at 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 at gmail.com>
To: themneks <jmasibo at gmail.com>
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] i need your help on installing koha
Message-ID:
	<CAK5OMPcqc8q=XMhEXj9A2AN0pxHwc+-qs4ojYYZCVUc-8i_6kg at 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 at 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 at hotmail.com.au>
To: <koha at lists.katipo.co.nz>
Subject: [Koha] Cataloguing Items with Multiple Parts
Message-ID: <BLU0-SMTP476788B6ECFFA67B2F5E6D7A8E90 at 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 at hotmail.com.au 

------------------------------

Message: 5
Date: Tue, 3 Jul 2012 09:46:01 -0400
From: Nicole Engard <nengard at gmail.com>
To: Joel Harbottle <Joel.Harbottle at hotmail.com.au>
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Cataloguing Items with Multiple Parts
Message-ID:
	<CAC0K6VG4tyrWaAszwTmLCRKDrNZMO3cqjJBURcpg=AS4ZOK6qA at 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 at 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 at hotmail.com.au
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at 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 at yahoo.com.br>
To: koha at lists.katipo.co.nz
Subject: [Koha] Insert records in mysql
Message-ID:
	<CAHrHr+H8MQHSVGKXcrC2XWCJvAqHYkpJG0uJEMoLf3D1bzHG-Q at 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 at ccsr.qc.ca>
To: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Subject: [Koha] Check In - Check out multiple items.
Message-ID:
	<F680EA6566032E4E94FFBB064D4848631164312C at 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 at biblibre.com>
To: Koha-devel at lists.koha-community.org, 	Koha-Mailinglist
	<Koha at lists.katipo.co.nz>
Subject: [Koha] [discussion] Privacy issue (bug 3280)
Message-ID: <4FF31B14.5040508 at 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 at catalyst.net.nz>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Insert records in mysql
Message-ID: <4FF31D55.2040705 at 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 at catalyst.net.nz>
To: Paul Poulain <paul.poulain at biblibre.com>,
	Koha-devel at lists.koha-community.org,	Koha-Mailinglist
	<Koha at lists.katipo.co.nz>
Subject: Re: [Koha] [Koha-devel] [discussion] Privacy issue (bug 3280)
Message-ID: <09222531-3f7e-4ba3-9ab5-fddc719ebf7b at 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 at 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 at 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 at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

End of Koha Digest, Vol 81, Issue 6
***********************************