Did you see http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#CSV--one-Table-at-a-time-?
db.mytable.import_from_csv(open(filename, 'r')) Also, if you go to the table's page in appadmin and scroll to the bottom, there is an import button that allows you to import a CSV file. Anthony On Thursday, October 29, 2015 at 7:48:23 PM UTC-4, Bill Lugg wrote: > > I have a CSV file with more than 1,800 records that I'd like to load into > one of the SQLite tables in my web2py applications. Is there an easy way > to do this in web2py that I'm missing? I haven't been able to find > anything in the searches I've done so far. > > Thanks. > Bill Lugg > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
