Hi Uche:<div><br></div><div> Its my opinion that you coud do this easily with lxml for the XML part. Just Google "Python LXML"</div><div><br></div><div> Look at this page <a href="http://codespeak.net/lxml/tutorial.html">http://codespeak.net/lxml/tutorial.html</a></div>
<div> </div><div> The txt file is easy to handle with the split(',') command.</div><div><br></div><div> The thing I don't know what you are talking it's about sending the XML to a SQL Database, it's easier to handle the text file in SQL bulk insert command, etc..</div>
<div><br></div><div>Regards,</div><div>Jose Rivera<br><br><div class="gmail_quote">On Tue, Jul 21, 2009 at 12:19 PM, uche <span dir="ltr"><<a href="mailto:uraniumore238@gmail.com">uraniumore238@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi All,<br>
<br>
I am developing a python parsing program. This program takes two<br>
inputs a comma dilimeted txt file and an xml file, which represents<br>
the structure of the datafile. I am using python minidom to read in<br>
the xml file and create a tree structure in an object file. The next<br>
thing to do is to insert the data into the respective fields of the<br>
tree. Once I am done, I'd like to send this object to an sql database.<br>
Has anyone attempted to do this ? Is there an example code online that<br>
I can reference to ? ... More specifically what code will allow me to<br>
combine the data and tree structure into a complete object that I can<br>
use to populate the sql database ?<br>
<br>
Thanks.<br>
_______________________________________________<br>
XML-SIG maillist - <a href="mailto:XML-SIG@python.org">XML-SIG@python.org</a><br>
<a href="http://mail.python.org/mailman/listinfo/xml-sig" target="_blank">http://mail.python.org/mailman/listinfo/xml-sig</a><br>
</blockquote></div><br></div>