[Zope] python help needed

Garry Saddington garry at schoolteachers.co.uk
Tue Jan 19 13:28:03 EST 2010


I am trying to upload a csv file (called data) using the following script:

i=0
d=data.readlines()
for row in d:
         i+=1
         a=row.split(',')
         if i > 1:
             subjectid=a[0]
             entry=a[1]
             type=a[2]
             studentid=a[3]
         try:
 
 
context.insertestimatesandtargets(subjectid=subjectid,entry=entry,type=type,studentid=studentid)
         except:
             continue
return "something good"

(email editor messed up indentation)

insertestimatesandtargets() is a ZSQLmethod. When the call to this 
method results in an error the script stops and not all data is 
inserted. Without an error all the data is inserted.
So how can I make this script skip over errors and continue? The reason 
is that there may already be some data in the database table that I want 
to preserve.

regards
Garry


More information about the Zope mailing list