Process uploaded file

[David Jobes]

I have a db table that holds the files i have uploaded, i need to then be able to process them and add the information into another db table, i have not been able to find anything on it or in any book. suggestions or ideas

[Massimo Di Pierro]

for example, let's say you want to upload text files.

db.define_table('one',Field('filename','upload'),Field('processed','boolean',default=False,writable=False))

db.define_table('two',Field('one','reference one'),Field('results','text'))

def index():

      return dict(form = SQLFORM.grid(db.one))

def process():

      rows = db(db.one.processed=False).select()

      for row in rows:

            (filename, stream) = db.one.filename.retrieve(row.filename) ### magic

            db.two.insert(one = row.id, results = stream.read())

            row.update_record(processed = True)

      return '%s records processed' % len(rows)

[David Jobes]

I will try this, i already have a python script that parsers a file and converts to dsv to then add to db, this is the script i am trying to run, once a upload a file.