I have read trough many of the discussions on here and can't find anything that would help us with the export csv. We are running version 1.9.12 and would like to export all the open tickets with some custom fields. I think it might be better if we use a sql script within php myadmin - this way it wont affect anything should there be a new update etc. We can then just create a cron job to email the csv on a daily or weekly basis.
We have 4 custom fields that we would like to include in the export:
Variable Names: practice_name, hoya_account, invoice_number1, credit_reason1
Is there anyone out there that can help us with this issue. Maybe you already have a sql script with the basics in there that we can just take and edit etc. Any help would be greatly appreciated.
