I've got some csv files which need to be imported to a table. However the import_from_csv_file function doesn't seem to work because the files can (and almost always do) contain errors and to the best of my knowledge that function cannot fix errors on the fly. Anyway, I decided to write my own csv reading function which puts each line into a list and then uses update_or_insert to get each line into the db.
The problem I'm having is there are two csv files for each entry in the table (think product_inspection_1.csv and product_inspection_2.csv, matched by serial #), and when using update_or_insert the inspection 2 results can overwrite the inspection 1 results and vice versa. Is there a way using update_or_insert to conditionally update a column in a row? Something like: if col_1: only update col_2 if col_2: only update col_1 I've been able to get something working by using an insert, catching an exception when the serial #s conflict, and then selectively updating the columns which need updating. But it's kind of like a moped: it gets the job done but you wouldn't your friends to see you using it. Does update_or_insert have this capability? Is there another function which might do this in a more concise manner? David -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
