While I’ve NOT done an import, I would like to suggest to the list that those of you with some database background checkout what the folks at Apatar have put together for a data mashup tool. It’s a freebie for the connectors already provided, you only pay bucks if you need custom connectors.

Download at www.apatar.com and it’s a java based GUI tool that has LOTS of connectors to allow you to do a drag and drop data manipulation for data migration. You can also run a cron job so do the data translation in a timer environment.

/brian chee

From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Lindeman, Luanne
Sent: Tuesday, April 15, 2008 8:06 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Newbie question - importing data

Hi,

I have library data in a sql 2000 database that was the backend for an InMagic application.

Has anyone done an import of data from a sql database into Koha?  I found an article called 'Migrating to Koha ver.2.0.0" by Stephen Hedges.  He mentions that you have to get the records into ISO 2709 format.  We are no longer using InMagic so I don't know if they would have tool to help do that so I'm left with going from sql 2000 to Koha.  We also don't have anything with MARC (not a librarian so please excuse if I stated that sentence incorrectly).  I'm the dba who has been tasked with getting data from the sql 2000 database into Koha.  I'm not familiar with ISO 2709 either.

Any help in getting started would be greatly appreciated.  Is it even possible?

Thanks!

Luanne