No subject


Thu Nov 17 10:48:57 UTC 2005 

>From chris at katipo.co.nz Thu May  5 03:45:10 2005
Return-Path: <chris at katipo.co.nz>
Delivered-To: chris at wilbur.katipo.co.nz
Received: (qmail 359 invoked from network); 4 May 2005 15:45:10 -0000
Received: from unknown (HELO shelob.katipo.co.nz) (202.50.109.222)
  by wilbur.katipo.co.nz with SMTP; 4 May 2005 15:45:10 -0000
Received: by shelob.katipo.co.nz (Postfix, from userid 1001)
	id 50E1A7C234; Thu,  5 May 2005 03:45:10 +1200 (NZST)
X-Original-To: chris at katipo.co.nz
Delivered-To: chris at katipo.co.nz
Received: from localhost (localhost [127.0.0.1])
	by shelob.katipo.co.nz (Postfix) with ESMTP id F0E387C208;
	Thu,  5 May 2005 03:45:05 +1200 (NZST)
Received: from shelob.katipo.co.nz ([127.0.0.1])
	by localhost (staff.katipo.co.nz [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 03579-04; Thu, 5 May 2005 03:45:05 +1200 (NZST)
Received: from daddy-mx.katipo.co.nz (daddy.katipo.co.nz [202.50.109.200])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by shelob.katipo.co.nz (Postfix) with ESMTP;
	Thu,  5 May 2005 03:45:05 +1200 (NZST)
Received: from localhost (localhost.katipo.co.nz [127.0.0.1])
	by daddy-mx.katipo.co.nz (Postfix) with ESMTP id 558BCE6E88;
	Thu,  5 May 2005 03:42:44 +1200 (NZST)
Received: from daddy-mx.katipo.co.nz ([127.0.0.1])
	by localhost (daddy.katipo.co.nz [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 16932-03; Thu, 5 May 2005 03:42:42 +1200 (NZST)
Received: from localhost.katipo.co.nz (localhost.katipo.co.nz [127.0.0.1])
	by daddy-mx.katipo.co.nz (Postfix) with ESMTP;
	Thu,  5 May 2005 03:42:42 +1200 (NZST)
Received: from localhost (localhost.katipo.co.nz [127.0.0.1])
	by daddy-mx.katipo.co.nz (Postfix) with ESMTP id 82068E6E84
	for <koha at lists.katipo.co.nz>; Thu,  5 May 2005 03:42:38 +1200 (NZST)
Received: from daddy-mx.katipo.co.nz ([127.0.0.1])
	by localhost (daddy.katipo.co.nz [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 17371-01 for <koha at lists.katipo.co.nz>;
	Thu, 5 May 2005 03:42:37 +1200 (NZST)
Received: from wlpl.org (mail.wlpl.org [204.95.8.76])
	by daddy-mx.katipo.co.nz (Postfix) with ESMTP
	for <koha at lists.katipo.co.nz>; Thu,  5 May 2005 03:42:35 +1200 (NZST)
Received: from [192.168.1.152] (helo=[192.168.1.152])
	by wlpl.org with esmtp (Exim 2.12 #1) id 1DTM13-0006QS-00
	for koha at lists.katipo.co.nz; Wed, 4 May 2005 10:42:25 -0500
Received: from 127.0.0.1 (AVG SMTP 7.0.308 [266.11.3]);
	Wed, 04 May 2005 10:44:45 -0500
Message-ID: <4278EDED.507 at wlpl.org>
Date: Wed, 04 May 2005 10:44:45 -0500
From: Tim McMahon - West Liberty Public Library <tmcmahon at wlpl.org>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: koha at lists.katipo.co.nz
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at katipo.co.nz
Subject: [Koha] Convering patrons from Sagebrush Athena
X-BeenThere: koha at lists.katipo.co.nz
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Discussion list for the Koha Library system <koha.lists.katipo.co.nz>
List-Unsubscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>,
	<mailto:koha-request at lists.katipo.co.nz?subject=unsubscribe>
List-Archive: <http://lists.katipo.co.nz/pipermail/koha>
List-Post: <mailto:koha at lists.katipo.co.nz>
List-Help: <mailto:koha-request at lists.katipo.co.nz?subject=help>
List-Subscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>,
	<mailto:koha-request at lists.katipo.co.nz?subject=subscribe>
Sender: koha-bounces at lists.katipo.co.nz
Errors-To: koha-bounces at lists.katipo.co.nz
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at katipo.co.nz
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at katipo.co.nz
X-Spam-Checker-Version: SpamAssassin 3.0.2 (2004-11-16)  on 
	shelob.katipo.co.nz
X-Spam-Level: 
X-Spam-Status: No, hits=-2.6 required=5.0tests=BAYES_00 autolearn=ham 
	version=3.0.2
Status: RO
Content-Length: 1166

I'm looking for comments on my work so far.  Here is the MySQL script I 
wrote to move patron data to Koha.  I converted the dbf file from the 
Athena export to the test database in MySQL using dbf2mysql.  Let me 
know if you see anything that should be changed or could be done a 
better way.

insert into Koha.borrowers (
    cardnumber,
    surname,
    firstname,
    title,
    streetaddress,
    city,
    phone,
    emailaddress,
    altstreetaddress,
    altcity,
    altphone,
    dateenrolled,
    borrowernotes,
    expiry,
    altnotes,
    zipcode)
select patronid,
    surname,
    firstname,
    salutation,
    street1,
    concat(city,', ',provstate),
    phone,
    email,
    astreet1,
    concat(acity,', ',aprovstate),
    aphone,
    recorddate,
    message,
    expirydate,
    blockmsg,
    postalzip
from test.patrons order by patronid;

update Koha.borrowers set debarred = 1 where altnotes > "";

I set Debarred to 1 when the patron has a blocking message (saved as 
altnotes in the Athena database).
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list