Hi
I have an upload field defined in a SQLFORM.factory form as follows:
def wasptime():
from reports.payroll import wasptime
response.title = 'WASPTime Payroll Import Conversion'
form = SQLFORM.factory(
Field('importFile', 'upload', label='WASPTime File',
uploadfolder='c:/deleteme/payroll/test'),
Field('processDate', 'date', required=True,
requires=IS_DATE('%m/%d/%Y'),
label='Process Date'))
if form.process().accepted:
importFile = request.vars.importFile.file
processDate = request.vars.processDate
wasptime.payrollImport(processDate, importFile, 'testfile.csv')
return dict(form=form)
in my wasptime.payrollImport method I am trying to read through the
lines in the uploaded file using:
def payrollImport(dateWorked, f, outputFile):
for line in f.readlines():
...processing takes place here for each line in the file
but, I'm not getting any lines to print. Can't seem to find the right
way to handle this.
In addition, why do I need to specify an uploadfolder in the 'upload'
field definition in SQLFORM.factory?
Thanks
-Jim