Are you not receiving any of my attachments by email? -Thadeus
On Tue, Jan 5, 2010 at 2:35 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: > waiting for the patch by email.... > > On Jan 5, 12:13 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: >> 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 >> >> athttp://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. > > > >
-- 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.