I just see that it already has the function to export filtered values! nice!
>>> python csvstudio.py -i input.csv -q "year=2003 X005" -c price,quantity,revenue -r "revenue=price*quantity" -o output.csv -f csv Now I think it is easy to use the output file to import in to DAL (?) I am going try to import some spreadsheets in to my web2py apps. 2010/12/19 Bruno Rocha <rochacbr...@gmail.com> > Cool! > > would be nice to use the query functionality to get filtered data from CSV > to use with import_from_.. in DAL. > > could be used to automate the import process. > > I am trying with large files. > > > Thank you! > > > > 2010/12/18 mdipierro <mdipie...@cs.depaul.edu> > > http://csvstudio.googlecode.com/hg/csvstudio.pdf >> >> would be nice to have a web2py interface. > > > > > -- > > Bruno Rocha > http://about.me/rochacbruno/bio > -- Bruno Rocha http://about.me/rochacbruno/bio
