Just make sure every record has a Field('uuid',writable=False, default=web2py_uuid()) then you can use db.export_to_csv_file from the warehouses and db.import_from_csv_field and it will update records but not add duplicates.
On Sep 30, 11:02 am, clarix <clara.ferra...@gmail.com> wrote: > Hello, > > I am developing a web2py application that is going to run in 4 > warehouses. They are not connected to the internet. > > I need to then generate a second web2py application that gathers the > information of the 4 sites into a single database with exactly the > same table layout for data analysis. > > What would be the best/easiest way to do it? > > Thanks!