Ah duh, column names...
Here would be a proper fix.
colnames = kwargs.get('colnames', self.colnames)
# a proper csv starting with the column names
writer.writerow(colnames)
So
export_to_csv(..., colnames=['Field1', 'Field2', 'Field3',]
-Thadeus
On Tue, Jan 5, 2010 at 11:58 AM, Thadeus Burgess <thade...@thadeusb.com> wrote:
> ...
>
> There is a way of using the represent attribute...
>
> so export_to_csv(..., represent=True)
>
> Will use the fields represent attribute
>
> db.table.field.represent = lambda id: ....
>
> -Thadeus
>
>
>
>
>
> On Tue, Jan 5, 2010 at 10:39 AM, mdipierro <mdipie...@cs.depaul.edu> wrote:
>> as a short term trunk, you could just replace the first line in a the
>> csv file.
>>
>> On Jan 5, 10:37 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>>> Right now there is no way to customize the column names in
>>> export_to_csv_file.
>>> We could add it. do you call export_to_csv_file explicitly?
>>>
>>> On Jan 5, 10:23 am, Neveen Adel <nevo.a...@gmail.com> wrote:
>>>
>>> > I want to rename The column names to be readable to users and then i
>>> > will generate the csv report by str(family_members) so i cant use
>>> > SQLTable.
>>>
>>> > And by using
>>> > db.member.name.label = name
>>> > db.member.member_id = member ID
>>>
>>> > the columns are displayed with their names e.g: member.name and
>>> > member.membership_id
>>>
>>> > so please do you have any suggestions
>>>
>>> > Thanks
>>>
>>> > On Jan 5, 4:38 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>>>
>>> > > Please do not override family_members.colnames. This was an internal
>>> > > thing and its behavior changed in 1.72.*
>>> > > Use db.table.field.label instead or SQLTABLE(rows,headers={})
>>> > > depending on what you need.
>>>
>>> > > On Jan 5, 4:12 am, Neveen Adel <nevo.a...@gmail.com> wrote:
>>>
>>> > > > when i do the following code:
>>>
>>> > > > family_members =db(db.member.id == membership_id).select
>>> > > > (db.member.name,db.member.id)
>>> > > > family_members.colnames = ('Name ','Membership ID')
>>>
>>> > > > It cause the following error
>>> > > > ""
>>> > > > Traceback (most recent call last):
>>> > > > File
>>> > > > "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
>>> > > > restricted.py", line 184, in restricted
>>> > > > File "/home/abeer/Desktop/resources/web2py/New_version/web2py_src/
>>> > > > web2py/applications/init/views/default/updateMember.html", line 142,
>>> > > > in <module>
>>> > > > File
>>> > > > "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
>>> > > > globals.py", line 112, in write
>>> > > > File
>>> > > > "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
>>> > > > html.py", line 103, in xmlescape
>>> > > > File
>>> > > > "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
>>> > > > sql.py", line 3326, in xml
>>> > > > File
>>> > > > "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
>>> > > > sqlhtml.py", line 980, in __init__
>>> > > > File
>>> > > > "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
>>> > > > sql.py", line 621, in __getattr__
>>> > > > KeyError: '_extra'
>>>
>>> > > > ""
>>> > > > P.s. : when i commented the lone (family_members.colnames = ('Name
>>> > > > ','Membership ID')) it works fine i dont why??
>>>
>>> > > > Thanks
>>>
>>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To post to this group, send email to web...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> web2py+unsubscr...@googlegroups.com.
>> For more options, visit this group at
>> http://groups.google.com/group/web2py?hl=en.
>>
>>
>>
>>
>
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
