I have a PHP script that queries mySQL DB and coverts result into tab delimited, then the user can open http://xyz.com/report.php and will get prompted to open/save the Excel.
My user now needs me to generated this report on a scheduled interval ( e.g., every 10 minutes) and then have it emailed to them. This is on a hosted server.
I tried to use crontab:
1. I first tried wget: wget -O test.xls http://www.xyz.com/report.php
but got some kind of permission denied error, I searched the web and this might have something to do with not been able to write to somewhere...(linux thing)
2. I then tried lynx -dump http://www.xyz.com/report.php this worked! but I just get an email with tab delimited data in plain format, not Excel.
3. I have thought about using Spreadsheet::WriteExcel in perl or the PEAR version, but that will take a lot more work and I might have to ask the hosting company to install stuff again...
Do you have any comments on what I am trying to do? Am I doing something wrong? Am I missing something simpler?
I had to ask the host to enable crontab and wget already, on one hand I don't want to keep asking them for stuff and can't get it to work, on the other hand this looks like a pretty lame installation to began with...It seems to be a very basic/limited hosting plan)