The project I will be working on requires all users to import from spreadsheets, so thats not really possible.
On Wednesday, June 20, 2012 9:49:57 AM UTC-5, Richard wrote: > > Why don't use the appadmin export and import ? > > Richard > > On Wed, Jun 20, 2012 at 9:55 AM, joe wrote: > >> I want to import from a csv file, but I want to use the imported data in >> only one of my database tables, not all of them, which is how I have seen >> the examples online. Here is my code, which does not work: >> >> Model >> ------------------- >> db.define_table( >> 'upload', >> Field('name'), >> Field('email')) >> >> db.upload.name.requires = IS_NOT_EMPTY() >> db.upload.email.requires = [IS_EMAIL, IS_NOT_IN_DB(db, 'upload.email')] >> >> Controller >> ---------------------- >> def upload(): >> db.upload.import_from_csv_file('nameTest.csv') >> records = >> SQLTABLE(db().select(db.upload.ALL),headers='fieldname:capitalize') >> return dict(records=records) >> >> >> View >> ------------------ >> {{extend 'layout.html'}} >> >> >> <h2>Current data</h2> >> {{=records}} >> >> >> >> >> I know its basic, but I am just working on getting the feel for things >> before I do a bigger project. >> > >