<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Trying to import from a RHEL/Oracle 10g (Sirsidynix) db to a Debian/MySQL system. Any suggestions as to how to go about this?? Thank for the input. Todd Goatley</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16809" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi Todd,</FONT></DIV>
<DIV><FONT face=Arial size=2>To get the bibliographic, item and user/borrower
data you will be far better off using the SirsiDynix (is it Unicorn/Symphony?)
tools to get the data out. If you have command-line access to your old
system this will include using selcatalog, catalogdump and seluser with
dumpflatuser. Then they will need a bit of manipulation to get into the
format expected by Koha for importing bibliographic, item and borrower
data.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If you plan to take lots of datasets across then
extracting from Oracle and into Mysql sounds like a good bet.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I won't go into the detail of those commands here
but do come back if you have any specific questions.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Good luck.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Ian</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=TGoatley@washoecounty.us
href="mailto:TGoatley@washoecounty.us">Goatley, Todd</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=koha@lists.katipo.co.nz
href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, February 24, 2009 8:57
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Koha] Trying to import from a
RHEL/Oracle 10g (Sirsidynix) db to aDebian/MySQL system. Any suggestions as to
how to go aboutthis?? Thank for the input. Todd Goatley</DIV>
<DIV><BR></DIV><!-- Converted from text/rtf format --><BR>
<P><B><FONT face=Arial size=2>Trying to import from a RHEL/Oracle 10g
(Sirsidynix) db to a Debian/MySQL system. Any suggestions as to how to go
about this?? Thank for the input.</FONT></B></P><BR>
<P><FONT face=Arial size=2>Todd L. Goatley DCAS</FONT> <BR><FONT face=Arial
size=2>Washoe County Library - Spanish Springs</FONT> <BR><FONT face=Arial
size=2>7100A Pyramid Lake Highway</FONT> <BR><FONT face=Arial size=2>Sparks,
NV 89436</FONT> <BR><FONT face=Arial size=2>Email: <A
href="mailto:tgoatley@washoecounty.us">tgoatley@washoecounty.us</A></FONT>
<BR><FONT face=Arial size=2>W: 775-424-1843</FONT> <BR><FONT face=Arial
size=2>C: 775-771-3489</FONT> </P>
<P>
<HR>
<P></P>_______________________________________________<BR>Koha mailing
list<BR>Koha@lists.katipo.co.nz<BR>http://lists.katipo.co.nz/mailman/listinfo/koha<BR>
<P>
<HR>
<P></P><BR>No virus found in this incoming message.<BR>Checked by AVG -
www.avg.com <BR>Version: 8.0.237 / Virus Database: 270.11.3/1969 - Release
Date: 02/24/09 06:43:00<BR></BLOCKQUOTE></BODY></HTML>