[web2py] Re: tab separated csv file
I think the import button should have a delimiter field makes things easier. On Thursday, 12 March 2009 00:08:27 UTC+8, mdipierro wrote: > > There is no configuration parameter to do so. You mat create your own > csv serializer. look into the python csv module. > > On Mar 11, 10:01 am, Marco Prosperi > wrote: > > hello everybody, > > how can I change the following function (defined in appadmin.py > > controller) so that the downloaded file has tab separated values > > instead of comma separated? Or do I have to change some settings > > somewhere? > > > > thanks in advance, > > Marco > > > > def csv(): > > import gluon.contenttype > > response.headers['Content-Type'] = \ > > gluon.contenttype.contenttype('.csv') > > db = get_database(request) > > query = get_query(request) > > if not query: > > return None > > response.headers['Content-disposition'] = \ > > 'attachment; filename=%s_%s.csv'\ > > % tuple(request.vars.query.split('.')[:2]) > > return str(db(query).select()) --
[web2py] Re: tab separated csv file
in sqlhtml there is a TSV exporter though... On Wednesday, March 11, 2009 9:08:27 AM UTC-7, mdipierro wrote: > > There is no configuration parameter to do so. You mat create your own > csv serializer. look into the python csv module. > > On Mar 11, 10:01 am, Marco Prosperi > wrote: > > hello everybody, > > how can I change the following function (defined in appadmin.py > > controller) so that the downloaded file has tab separated values > > instead of comma separated? Or do I have to change some settings > > somewhere? > > > > thanks in advance, > > Marco > > > > def csv(): > > import gluon.contenttype > > response.headers['Content-Type'] = \ > > gluon.contenttype.contenttype('.csv') > > db = get_database(request) > > query = get_query(request) > > if not query: > > return None > > response.headers['Content-disposition'] = \ > > 'attachment; filename=%s_%s.csv'\ > > % tuple(request.vars.query.split('.')[:2]) > > return str(db(query).select()) --
[web2py] Re: tab separated csv file
You could monkey-patch the dal 'rows' object __str__ by making it export as a TSV. On Wednesday, March 11, 2009 8:01:42 AM UTC-7, Marco Prosperi wrote: > > hello everybody, > how can I change the following function (defined in appadmin.py > controller) so that the downloaded file has tab separated values > instead of comma separated? Or do I have to change some settings > somewhere? > > thanks in advance, > Marco > > def csv(): > import gluon.contenttype > response.headers['Content-Type'] = \ > gluon.contenttype.contenttype('.csv') > db = get_database(request) > query = get_query(request) > if not query: > return None > response.headers['Content-disposition'] = \ > 'attachment; filename=%s_%s.csv'\ > % tuple(request.vars.query.split('.')[:2]) > return str(db(query).select()) --
[web2py] Re: tab separated csv file
Nooo. This would break other apps in the same server. I would take a patch to pass the parameter around or use the grid exporter in appadmin. On Tuesday, 8 January 2013 12:52:38 UTC-6, Derek wrote: > > You could monkey-patch the dal 'rows' object __str__ by making it export > as a TSV. > > On Wednesday, March 11, 2009 8:01:42 AM UTC-7, Marco Prosperi wrote: >> >> hello everybody, >> how can I change the following function (defined in appadmin.py >> controller) so that the downloaded file has tab separated values >> instead of comma separated? Or do I have to change some settings >> somewhere? >> >> thanks in advance, >> Marco >> >> def csv(): >> import gluon.contenttype >> response.headers['Content-Type'] = \ >> gluon.contenttype.contenttype('.csv') >> db = get_database(request) >> query = get_query(request) >> if not query: >> return None >> response.headers['Content-disposition'] = \ >> 'attachment; filename=%s_%s.csv'\ >> % tuple(request.vars.query.split('.')[:2]) >> return str(db(query).select()) > > --