HOPS Nightly Excel Reports

Key staff at hops require management reports each day to keep track of daily movements within the business. Since much of their work is based off site, they requested that the reports are generated each night and emailed to key staff members.

The reports were generated by extracting data from the HOPS MS SQL database, processing it in PHP, rendering the data to an Excel spreadsheet using PHPExcel and emailing the files out to a distribution list. The whole process is controlled by a Linux cron job.