Re: [web2py] Load data from sqlite file?

2012-05-11 Thread Johann Spies
On 11 May 2012 01:38, Dave  wrote:

> Any examples or suggestions on how to load data from a user-uploaded
> .sqlite database?
>
> I will have the database structure of the uploaded files ahead of time
> (they are being generated by a mobile app), so I need a way to transfer the
> data from an uploaded .sqlite file to my web2py tables.  is it possible to
> just use the uploaded file as a new dal, then transfer the data to the main
> dal, all within a function?
>
>
If the structure of the database file is compatible with your DAL setup,
try and use it as a second database.  If it does not work, open it with a
tool like SQLITEBROWSER, export the tables to csv-files and import it on
the other side.

Regards
Johann
-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)


[web2py] Load data from sqlite file?

2012-05-10 Thread Dave
Any examples or suggestions on how to load data from a user-uploaded 
.sqlite database?

I will have the database structure of the uploaded files ahead of time 
(they are being generated by a mobile app), so I need a way to transfer the 
data from an uploaded .sqlite file to my web2py tables.  is it possible to 
just use the uploaded file as a new dal, then transfer the data to the main 
dal, all within a function?

Thanks in advance,
Dave