Thank you, Bill.<br><br><div><span class="gmail_quote">On 8/20/07, <b class="gmail_sendername">William (Bill) Froelich</b> <<a href="mailto:wfroelich@dbsnow.com">wfroelich@dbsnow.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" 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><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" 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><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" 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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.modwest.com/help/kb6-253.html</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">3) Setup the data file and use rake.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">4) Find a tool that supports the bulk import to
MySQL.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" 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><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" 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><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Hope this helps!</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">--Bill Froelich</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div><br>
<blockquote style="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr style="clear: left; margin-top: 35px;">
<font face="Tahoma" size="2"><b>From:</b> <a href="mailto:instantrails-users-bounces@rubyforge.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">instantrails-users-bounces@rubyforge.org</a>
[mailto:<a href="mailto:instantrails-users-bounces@rubyforge.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">instantrails-users-bounces@rubyforge.org</a>] <b>On Behalf Of </b>Walker
Web Data<br><b>Sent:</b> Sunday, August 19, 2007 6:18 AM<br><b>To:</b>
<a href="mailto:Instantrails-users@rubyforge.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Instantrails-users@rubyforge.org</a><br><b>Subject:</b> [Instantrails-users]
Instead of using the command line<br></font><br></div><span class="q">
<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></span></blockquote></div>
<br>_______________________________________________<br>Instantrails-users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Instantrails-users@rubyforge.org">Instantrails-users@rubyforge.org
</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://rubyforge.org/mailman/listinfo/instantrails-users" target="_blank">http://rubyforge.org/mailman/listinfo/instantrails-users</a><br></blockquote>
</div><br>