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
