Hi there, I've spent hours and tried everything under the sun, I'm new to web2py but loving the framework.
I want to be able to set the exported csv header row titles to not be "table.id, table.name etc." but rather a proper label "ID, Name" etc. This is part of the code I'm using: *from gluon.contenttype import contenttype > ** response.headers['Content-Type'] = contenttype('.csv') > ** response.headers['Content-disposition'] = 'attachment; > filename=%s_database.csv' % ( > ** request.now > ** ) > ** import csv, cStringIO > ** s = cStringIO.StringIO()* *colnames=['id','name']* *records.export_to_csv_file(s, delimiter=',', quotechar='"', > quoting=csv.QUOTE_NONNUMERIC, colnames=colnames)* *return s.getvalue()* * * The error I keep getting is something to do with an "_extra" : *Traceback (most recent call last): > ** File "/Users/Rey/Dropbox/web2py/gluon/restricted.py", line 204, in > restricted > ** exec ccode in environment > ** File > "/Users/Rey/Dropbox/web2py/applications/example/controllers/account.py", > line 187, in <module> > ** File "/Users/Rey/Dropbox/web2py/gluon/globals.py", line 172, in > <lambda> > ** self._caller = lambda f: f() > ** File > "/Users/Rey/Dropbox/web2py/applications/example/controllers/account.py", > line 183, in export > ** records.export_to_csv_file(s, delimiter=',', quotechar='"', > quoting=csv.QUOTE_NONNUMERIC, colnames=colnames) > ** File "/Users/Rey/Dropbox/web2py/gluon/dal.py", line 6669, in > export_to_csv_file > ** row.append(record._extra[col]) > ** File "/Users/Rey/Dropbox/web2py/gluon/dal.py", line 4440, in > __getattr__ > ** return self[key] > ** File "/Users/Rey/Dropbox/web2py/gluon/dal.py", line 4431, in > __getitem__ > ** return dict.__getitem__(self, key) > **KeyError: '_extra'* Version of Web2py I'm using is Version 1.99.4 (2011-12-14 14:46:14) stable Any help would be much appreciated!