Andrew Milton wrote:

+-------[ Garry Saddington ]---------------------- | 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.

The try/except block should prevent the script from failing when calling the ZSQL method (assuming your indenting *is* correct in the python script [look for mixed tabs/spaces, since in the email some of your indents are 8 and some are 4]). No all correct - Thunderbird not allowing me to edit the text.

Your other option is to do transaction sub-commits manually (there's plenty of google links for how to do this).

You probably can't do this directly from a python script, you'll have to setup an External Method to do it (or alter the security for the transaction machinery).

Yes, thanks I thought that was the problem. I've already sorted it with external methods. Garry