Hi!
First: This is my first try to build a "real" application in web2py and
python, i'm new to both but like it very much (i'm coming from bash/awk/sed)
I receive following error when trying to export a SQLFORM.grid to TSV
(Excel compatible), but CSV works
Traceback (most recent call last):
File "/home/gniemetz/webapps/web2py/web2py/gluon/restricted.py", line 209, in
restricted
exec ccode in environment
File
"/home/gniemetz/webapps/web2py/web2py/applications/tauchbuch/controllers/default.py"
<https://web2py.niemetz.it/admin/default/edit/tauchbuch/controllers/default.py>,
line 78, in <module>
File "/home/gniemetz/webapps/web2py/web2py/gluon/globals.py", line 185, in
<lambda>
self._caller = lambda f: f()
File "/home/gniemetz/webapps/web2py/web2py/gluon/tools.py", line 2783, in f
return action(*a, **b)
File
"/home/gniemetz/webapps/web2py/web2py/applications/tauchbuch/controllers/default.py"
<https://web2py.niemetz.it/admin/default/edit/tauchbuch/controllers/default.py>,
line 22, in index
grid =
SQLFORM.grid(db.Logbuch,fields=[db.Logbuch.Datum,db.Logbuch.Kurs,db.Logbuch.Thema,db.Logbuch.Kommentar],maxtextlength=50)
File "/home/gniemetz/webapps/web2py/web2py/gluon/sqlhtml.py", line 1858, in
grid
raise HTTP(200, oExp.export(),**response.headers)
File "/home/gniemetz/webapps/web2py/web2py/gluon/sqlhtml.py", line 2627, in
export
records = self.represented()
File "/home/gniemetz/webapps/web2py/web2py/gluon/sqlhtml.py", line 2594, in
represented
value = field.represent(value, record)
TypeError: <lambda>() takes exactly 1 argument (2 given)
This is my model (a bit complicated, maybe there's room for improvement)
db.define_table('KFZ',
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Auto','string',length=30,label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Car')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Kennzeichen','string',length=10,label=T
<https://web2py.niemetz.it/examples/global/vars/T>('License plate')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('KM','integer',label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Mileage')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('gueltig_bis','date',label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Expired')),
format='%(Auto)s %(Kennzeichen)s'
)
db.define_table('Themen',
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Thema','string',length=30,label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Topic')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('gueltig_bis','date',label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Expired')),
format='%(Thema)s'
)
db.define_table('KM_Gelder',
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Tarif','decimal(3,2)',requires=IS_DECIMAL_IN_RANGE
<https://web2py.niemetz.it/examples/global/vars/IS_DECIMAL_IN_RANGE>(dot=','),label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Mileage Cost')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('gueltig_bis','date',label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Expired')),
format=lambda row: str('%(Tarif)s' % row if row else
'').replace('.',',').replace(',00',',-')
)
from datetime import datetime, date
query = ((db.KM_Gelder.gueltig_bis == None))
db.define_table('Logbuch',
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Datum','date',requires=IS_DATE
<https://web2py.niemetz.it/examples/global/vars/IS_DATE>(format='%Y-%m-%d'),label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Date')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Kurs','string',length=50,label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Course')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Beginn','time',requires=IS_TIME
<https://web2py.niemetz.it/examples/global/vars/IS_TIME>(),label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Start'),represent=lambda
row: row.strftime('%H:%M')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Ende','time',requires=IS_TIME
<https://web2py.niemetz.it/examples/global/vars/IS_TIME>(),label=T
<https://web2py.niemetz.it/examples/global/vars/T>('End'),represent=lambda row:
row.strftime('%H:%M')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Thema',db.Themen,label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Topic')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Teilnehmer','integer',label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Number of participants')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Kosten','decimal(7,2)',requires=IS_DECIMAL_IN_RANGE
<https://web2py.niemetz.it/examples/global/vars/IS_DECIMAL_IN_RANGE>(dot=','),label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Cost of
participants'),represent=lambda row: str('€ %s' % row if row else
'').replace('.',',').replace(',00',',-')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Erloese','decimal(7,2)',requires=IS_DECIMAL_IN_RANGE
<https://web2py.niemetz.it/examples/global/vars/IS_DECIMAL_IN_RANGE>(dot=','),label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Revenues'),compute=lambda
row: row['Teilnehmer']*row['Kosten'],represent=lambda row: SPAN
<https://web2py.niemetz.it/examples/global/vars/SPAN>(str('€ %s' % row if row
else '').replace('.',',').replace(',00',',-'),_style='color: green')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('KM_Beginn','integer',label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Mileage
Start'),represent=lambda row: str('{:,}
km'.format(row)).replace(',','*').replace('.',',').replace('*','.')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('KM_Ende','integer',label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Mileage
End'),represent=lambda row: str('{:,}
km'.format(row)).replace(',','*').replace('.',',').replace('*','.')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Sum_Zeit','time',label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Hours
Summary'),compute=lambda row:
datetime.combine(date.today(),row['Ende'])-datetime.combine(date.today(),row['Beginn']),requires=IS_TIME
<https://web2py.niemetz.it/examples/global/vars/IS_TIME>(),represent=lambda
row: row.strftime('%H:%M')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Sum_KM','integer',label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Mileage
Summary'),compute=lambda row: row['KM_Ende']-row['KM_Beginn'],represent=lambda
row: str('{:,}
km'.format(row)).replace(',','*').replace('.',',').replace('*','.')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('KM_Geld',db.KM_Gelder,label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Mileage
Cost'),requires=IS_IN_DB
<https://web2py.niemetz.it/examples/global/vars/IS_IN_DB>(db(query),'KM_Gelder.id',db.KM_Gelder._format),represent=lambda
id: str('€ %(Tarif)s' % db.KM_Gelder(id) if db.KM_Gelder(id) else
'').replace('.',',').replace(',00',',-')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Autokosten','decimal(7,2)',label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Mileage Summary
Cost'),compute=lambda row:
(row['KM_Ende']-row['KM_Beginn'])*db.KM_Gelder(row['KM_Geld']).Tarif,represent=lambda
row: SPAN <https://web2py.niemetz.it/examples/global/vars/SPAN>(str('€ %s' %
row if row else '').replace('.',',').replace(',00',',-'),_style='color: red')),
Field
<https://web2py.niemetz.it/examples/global/vars/Field>('Kommentar','string',length=200,label=T
<https://web2py.niemetz.it/examples/global/vars/T>('Comment'))
)
db.Logbuch.id.readable=db.Logbuch.id.writeable=False
and this is the controller
@auth.requires_login()
def index():
#response.flash = T('Welcome to your divebook!')
grid = SQLFORM
<https://web2py.niemetz.it/examples/global/vars/SQLFORM>.grid(db.Logbuch,fields=[db.Logbuch.Datum,db.Logbuch.Kurs,db.Logbuch.Thema,db.Logbuch.Kommentar],maxtextlength=50)
return locals()
What's going wrong here?
Thanks for your efforts
regards
Gerd
--
