<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2>There are a number of ways that you can accomplish
this. I am assuming you are using MySQL as the
database.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2>1) You could use this as an opportunity to write a parser /
importer in Ruby using fastercsv or similar.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2>2) Do a bulk import to MySQL as described at the following
link <A
href="http://www.modwest.com/help/kb6-253.html">http://www.modwest.com/help/kb6-253.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2>3) Setup the data file and use rake.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2>4) Find a tool that supports the bulk import to
MySQL.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2>How you approach it depends primarily on your current
need. #1 & #3 give you an opportunity to learn more about Ruby
and database interactions but #2 is probably the quickest to implement
since it should be existing functionality. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2>Note: I have not tested any of these approaches directly
with MySQL but do use the Oracle equivalent of #2
frequently.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2>Hope this helps!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2>--Bill Froelich</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207164205-20082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> instantrails-users-bounces@rubyforge.org
[mailto:instantrails-users-bounces@rubyforge.org] <B>On Behalf Of </B>Walker
Web Data<BR><B>Sent:</B> Sunday, August 19, 2007 6:18 AM<BR><B>To:</B>
Instantrails-users@rubyforge.org<BR><B>Subject:</B> [Instantrails-users]
Instead of using the command line<BR></FONT><BR></DIV>
<DIV></DIV>Instead of using the command line to, for example, insert records
individually, is it possible to use an easier way such as having a number of
records in an external file and inserting them all at once?<BR><BR>Thank
you.<BR></BLOCKQUOTE></BODY></HTML>