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
> | entry=a
> | type=a
> | studentid=a
> | try:
> | 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
Zope maillist - Zope@zope.org
** No cross posts or HTML encoding! **
(Related lists -