[web2py] Re: Reading information from an external CSV file through SQLFORM.smartgrid

2018-10-04 Thread mostwanted
Thanks Tony On Thursday, October 4, 2018 at 3:31:11 PM UTC+2, Anthony wrote: > > Its just a standard DAL instance, specifying a SQLite memory database > (which will only live as long as the request): > > temp_db = DAL('sqlite:memory') > temp_db.define_table('my_csv_temp_table', ...) > temp_db.my_

[web2py] Re: Reading information from an external CSV file through SQLFORM.smartgrid

2018-10-04 Thread Anthony
Its just a standard DAL instance, specifying a SQLite memory database (which will only live as long as the request): temp_db = DAL('sqlite:memory') temp_db.define_table('my_csv_temp_table', ...) temp_db.my_csv_temp_table.import_from_csv_file(...) grid = SQLFORM.smartgrid(temp_db.my_csv_temp_table

[web2py] Re: Reading information from an external CSV file through SQLFORM.smartgrid

2018-10-03 Thread mostwanted
Yes it is Dave On Wednesday, October 3, 2018 at 11:10:53 PM UTC+2, Dave S wrote: > > > > On Wednesday, October 3, 2018 at 12:15:36 AM UTC-7, mostwanted wrote: >> >> Is it possible for me read information from a CSV file saved somewhere in >> my computer into my application through SQLFORM.smartgr

[web2py] Re: Reading information from an external CSV file through SQLFORM.smartgrid

2018-10-03 Thread Dave S
On Wednesday, October 3, 2018 at 12:15:36 AM UTC-7, mostwanted wrote: > > Is it possible for me read information from a CSV file saved somewhere in > my computer into my application through SQLFORM.smartgrid without uploading > the CSV file into the application? > > Regards > > Mostwanted > Ju

[web2py] Re: Reading information from an external CSV file through SQLFORM.smartgrid

2018-10-03 Thread mostwanted
I like the first suggestion* (You could import into a "sqlite:memory."), *how does it work though??? On Wednesday, October 3, 2018 at 4:13:17 PM UTC+2, Anthony wrote: > > Do you mean without importing the CSV data into a database? If so, then > no. You could import into a "sqlite:memory" dat

[web2py] Re: Reading information from an external CSV file through SQLFORM.smartgrid

2018-10-03 Thread Anthony
Do you mean without importing the CSV data into a database? If so, then no. You could import into a "sqlite:memory" database (though that will load the data on every request, as the in memory database will disappear at the end of each request). Alternatively, maybe just load the data into a temp