None

17 Nov 2005

      ...
From chris@katipo.co.nz Thu May  5 03:45:10 2005
Return-Path: <chris@katipo.co.nz>
Delivered-To: chris@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@katipo.co.nz
Delivered-To: chris@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@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@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@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@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@wlpl.org>
Date: Wed, 04 May 2005 10:44:45 -0500
From: Tim McMahon - West Liberty Public Library <tmcmahon@wlpl.org>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: koha@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@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@lists.katipo.co.nz?subject=unsubscribe>
List-Archive: <http://lists.katipo.co.nz/pipermail/koha>
List-Post: <mailto:koha@lists.katipo.co.nz>
List-Help: <mailto:koha-request@lists.katipo.co.nz?subject=help>
List-Subscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>,
   <mailto:koha-request@lists.katipo.co.nz?subject=subscribe>
Sender: koha-bounces@lists.katipo.co.nz
Errors-To: koha-bounces@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@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha