<HTML>
<HEAD>
<TITLE>Re: [Koha] Proprietary database import</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Check out Apatar, it’s a free “Data Mashup Tool” that allows you to drag data connectors onto a desktop (each connector has credentials associated with it) and then you can connect fields from each data connector to “mash up tools” where you can manipulate the data however you want and then output to another data connector. This includes, lookups, concatenations, extractions, etc...<BR>
<BR>
These guys make their money on custom connectors, but the list of db sources already included is pretty big.... .CSV, MySQL, Postgres, MS-SQL, Amazon S3, SalesForce, text, excel, etc...<BR>
<BR>
<a href="http://www.apatar.com">http://www.apatar.com</a><BR>
<BR>
/brian chee<BR>
<BR>
<BR>
<BR>
On 10/21/08 10:01 AM, "Damien Davis" <<a href="damien.davis@gmx.com">damien.davis@gmx.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><SPAN STYLE='font-size:11pt'><FONT FACE="Verdana, Helvetica, Arial">I have been given the task of migrating a SydneyPlus library database into a fresh koha install. Unfortunately this proprietary vendor doesn't make a smooth transitioning tool available so I'm wondering what the best way to go about this would be. I'm not very versed in Mysql and so far my only two clear ideas involve using a script to crawl the web pages of the current database to gather the information or to export the Mysql database table by table. I really don't know if either of those two things are viable and someone mentioned that I might be able to automatically generate the information from other libraries using a Z39.50 client but I'm not sure about that either. The library has eight thousand books. I appreciate any insight you guys can give me on this.<BR>
</FONT></SPAN><FONT FACE="Verdana, Helvetica, Arial"><FONT SIZE="1"><SPAN STYLE='font-size:9pt'><BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT></FONT><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_______________________________________________<BR>
Koha mailing list<BR>
<a href="Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><BR>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a><BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'><BR>
</SPAN></FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>-- <BR>
Brian Chee<BR>
University of Hawai'i at Manoa<BR>
School of Ocean and Earth Sciences and Technology (SOEST)<BR>
2525 Correa Road, HIG 500<BR>
Honolulu, HI 96822<BR>
Tel: 808-956-5797; Fax: 866-750-5948 Venali eFax<BR>
<BR>
</SPAN></FONT>
</BODY>
</HTML>