There must be something in the request that indicates you want csv or tsv.
If it's in the request.args, for example, something like this would work:
if 'csv' not in request.args and 'tsv' not in request.args:
db.inventory.cpu_status.represent = lambda cpu_status, row: SPAN(
...
On Wednesday, April 16, 2014 12:58:12 PM UTC-4, John Fraser wrote:
>
> Is there an easy way to strip HTML markup from SQLFORM.grid's CSV/TSV
> export? I realize I probably need to create a custom export function, but
> curious if there is an argument or a one liner that would do the trick. Or
> is there a better way to format the display?
>
> I have the following controller function:
>
> @auth.requires_login()
> def index():
> response.title = 'Computer Inventory'
> db.inventory.id.readable = False
> db.inventory.cpu_status.represent = lambda cpu_status, row: \
> SPAN(row.cpu_status,
> _style='text-transform: uppercase; font-weight: bold;
> padding:5px; color: %s; background-color: %s' %
> ('black' if row.cpu_status == 'Staged' else 'white','red' if
> row.cpu_status == 'Repair' else 'gold'
> if row.cpu_status == 'Staged' else 'green' if row.cpu_status
> == 'In Use' else 'black'))
> grid = SQLFORM.grid(db.inventory, csv=True)
> return locals()
>
>
> When I export as CSV/TSV (as displayed to the user) all values for
> db.inventory.cpu_status are wrapped in SPAN tags for example:
>
> <span style='text-transform: uppercase; font-weight: bold; padding:5px;
> color: white; background-color: black'>VALUE</span>
>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
