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
_______________________________________________
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to