Yes I see it now. Thanks.
def import_and_sync(): form = FORM(INPUT(_type='file', _name='data'), INPUT(_type='submit')) if form.accepts(request.vars): db.import_from_csv_file(form.vars.data.file,unique=False) # for every table for table in db.tables: # for every uuid, delete all but the latest items = db(db[table].id>0).select(db[table].id, db[table].uuid, orderby=db[table].modified_on, groupby=db[table].uuid) for item in items: db((db[table].uuid==item.uuid)&\ (db[table].id!=item.id)).delete() return dict(form=form) On 5/30/11 2:20 PM, pbreit wrote:
Something like this: http://web2py.com/book/default/chapter/06?search=csv#Exporting-and-Importing-Data