How to receive custom report in csv format when using subscription

Problem: By default custom report subscription only sends pdf file

Solution:

1) login to VMTurbo appliance (root/vmturbo)

2) vi /srv/rails/webapps/persistence/script/email_reports.rb

3) Change line 24:
return "/tmp/#{rept.title.to_s.gsub(/\W/,'')}.pdf"
to:
return "/tmp/#{rept.title.to_s.gsub(/\W/,'')}.csv"

4) Change line 32:
cmd = "curl -s -o #{custom_rept_file(rept)} http://localhost#{port}/persistence/user_reports/as_pdf/#{rept.id}"
to:
cmd = "curl -s -o #{custom_rept_file(rept)} http://localhost#{port}/persistence/user_reports/as_csv/#{rept.id}"

5) For the change to take affect:

> service persistence restart

Have more questions? Submit a request

Comments