Since you are passing request.vars as an argument to your function, you
must (a) define the function to accept and argument and (b) not assign
request.vars to a variable within the function body (no need for this given
that you are already passing request.vars as an argument). So, the function
definition should be:
def processdata(vars):
folder = "C:\\web2py\\application\\app\\working\\"
directory = os.path.join(folder, vars.f3)
...
Anthony
On Thursday, July 9, 2015 at 8:46:58 AM UTC-4, [email protected] wrote:
>
> I have a SQLFORM to gather some information for processing an excel file.
> The form works saving the data to the db no issue.
> I would like to be able to send the request.vars to a function to actually
> process the contents of the excel using the form data.
> The form contains file format(csv,xls,tab,xlsx etc), the tab or sheet in
> the workbook, and then the columns for the pertinent data.
>
>
> Here is what I have so far:
>
> def form1():
> record = db.table1(request.args(0))
> url = URL('download')
> form = SQLFORM(db.table1, record, fields=['f1', 'f2', 'f3', 'f4',
> 'f5', 'f6', 'f7', 'f8', 'f9', 'f10', 'f11', 'f12', 'f13'], deletable=True,
> showid=True,upload=url, formstyle='table3cols')
> if request.vars.f2 != None:
> form.vars.f1 = request.vars.f2.filename
> if form.accepts(request.vars, session):
> oncreate_event (processdata(request.vars))
> response.flash = 'The form has been successfully submitted.'
> elif form.errors:
> response.flash = 'Please correct the error(s).'
> return dict(form=form)
>
> def processdata():
> vars=request.vars
> folder = "C:\\web2py\\application\\app\\working\\"
> directory = os.path.join(folder, vars.f3)
> if not os.path.exists(directory):
> os.makedirs(directory)
>
> filepath = os.path.join(folder, vars.f3, vars.f2)
> process excel file....
>
> Thanks in advance for any assistance...
>
>
--
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.
