I posted it in a previous message on the list...but here it is...<br><br>#!/usr/bin/python<br><br>import MySQLdb<br>import csv<br>import sys<br><br>try:<br> db = MySQLdb.connect (host = "localhost",user = "root",passwd = "Ch33s3Monk3y",db = "xenstats")<br>
except MySQLdb.Error, e:<br> print "Error %d: %s" % (e.args[0], e.args[1])<br> sys.exit (1)<br><br>try:<br> co = db.cursor()<br> csv_data = csv.reader(file('output.txt','r'))<br> headers = csv_data.next()<br>
row = csv_data.next()<br> prefix = row[:20]<br> for i in range(20, len(row), 7):<br> next = prefix + row[i:i+7]<br><br> for row in csv_data: print next<br> co.execute("""<br> INSERT INTO stats VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);<br>
""",row)<br><br> co.close()<br><br>except MySQLdb.Error, e:<br> print "Error %d: %s" % (e.args[0], e.args[1])<br> sys.exit (1)<br><br>db.commit()<br>db.close()<br><br><div class="gmail_quote">
On Fri, Mar 21, 2008 at 1:18 PM, Kent Johnson <<a href="mailto:kent37@tds.net">kent37@tds.net</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">Spencer Parker wrote:<br>
> Okay...so I got it mostly working...it now dies with this trackback:<br>
<br>
</div>It would be helpful to see what 'it' is (i.e. your code), and also to<br>
see the actual error message as well as the traceback. We try to read<br>
minds on this group but we aren't really very good at it.<br>
<font color="#888888"><br>
Kent<br>
</font><div><div></div><div class="Wj3C7c"><br>
><br>
> Traceback (most recent call last):<br>
> File "./loadcsv.py", line 23, in ?<br>
> co.execute("""<br>
> File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line<br>
> 148, in execute<br>
> query = query % db.literal(args)<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Spencer Parker<br>_______________________________________________________<br><br>"if you can't go to heaven, may you at least die in Ireland."<br>
<br>_______________________________________________________