Re: [web2py] CSV Import/Export from different tables

2012-02-07 Thread Richard Vézina
Do you have to let the user do that copy/paste because they add result to kind of empty CSV/Excel spreadsheet to feed your system or you only want to move data around once? In later case you can make a request at DB level or in web2py shell... Richard On Tue, Feb 7, 2012 at 3:48 PM, Omi Chiba w

[web2py] CSV Import/Export from different tables

2012-02-07 Thread Omi Chiba
For example, I have two tables, "request" and "result". I want user to download all open request (status="1") from "request" table and upload with the result to "result" table. What's the easy way to do ? db.define_table('request', Field('subject'), Field('status', default="1"), Field