Exporting foreign keys as represented value

[joe]

Hello

I am working with xlwt and trying to export a table of mine into a .xls file.  This table contains some foreign keys, and they are being exported as the id of the other table rathan than the 'name' field, which is what I want to display.  I define the foreign key fields in the table like this:

Field('owner', db.person, requires = IS_EMPTY_OR(IS_IN_DB(db, db.person, '%(name)s')), represent=lambda id, row: db.person(id).name if id else ' '),

Thanks!

[Anthony]

How are you exporting the data? The export_to_csv_file() method, for example, takes a "represent" argument -- if set to True, it will use each field's "represent" attribute to convert the values before exporting.

Anthony

[joe]

I am using xlwt to export the data (I want an excel file, and a bit more control over format).  I recently made it work, in about the most clumsy way possible (getting a row object from the referenced table, casting it into a string, and finding the substring that I want to display), but there has to be a simpler way.

Thanks!

-Joe Peacock

[Anthony]

Can you show the code you are using to get the data from the db to xlwt?

Anthony