The best way to export openerp data to csv file using python

Question

Which is the best to way to export openerp data to csv/xls file using python so that i can schedule it in openerp( i cant use the client side exporting)?

• using csv python package
• using xlwt python package
• or any other package?

And also how can I dynamically provide the path and name to save this newly created csv file

Answer 1

Well their are certain ways like

• using csv python package
  • In this case you can take advantage of the export_data service which will automatically produce csv for you, you can use with Scheduler(cron job ) or even you can write script for it.
• using xlwt python package
  • This will be over head for you read all data then process then produce csv while first opption already yours 90% of your job.