[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