Yes I found this while I was waiting for the moderated post to be approved. I also found that you can make this happen from the appadmin interface, which is sufficient for me as I only needed to do it once.
Search works great if you find the right words to search for. It turns out the answer was right under my nose, but I just didn't find it the first time I looked. Thanks for the pointer though. Bill Lugg On Thursday, October 29, 2015 at 6:00:05 PM UTC-6, Anthony wrote: > > 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.
