if db(db.table.id > 0).count() == 0:
db.table2.import_from_csv_file(open(open('mycsv','r'))
So it will be executed only once...
Richard
On Wed, Oct 14, 2015 at 10:48 AM, Prasad M <mprasad.vijay2...@vit.ac.in>
wrote:
> I am trying to import data from csv in web2py's SQlite databae.
> 1) First I have defined table in database.
> 2) I wrote db.table2.import_from_csv_file(open(open('mycsv','r')) this
> line .
> Both steps are in Model.
>
> But while displaying data from the same table I am getting repeated rows
> at each refresh of the page. It means each time file appends data to table.
>
> So my question is how to solve this issue?
> Exactly where to write code for import data from csv to table? This is my
> query.
> I am trying to get this from 2 days.
> Please try to answer.
> Thank you in advanced !!!!
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
