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!
