NOW CONFIRMED TO WORK WITH VERSION 1.9.1!
Below you will find the initial instructions for modifying the osTicket files and database. The rest of the Reports 6.0 MOD is available via donation. For a $10 donation you will receive version 6.1 and any future revisions to version 6.x. For $15 or more you will be given access to all future releases. Anyone making a donation will receive full email support.
Thank you everyone and I look forward to your input into future releases!
Demo now online! I’ll try to get some more data added to this as soon as I can.
Note regarding demo. The database for this will be restored every day so we don’t get a bunch of crap loading up in it from anyway goofing around, etc. Also the staff table is restored every single minute, so don’t bother making extra users, etc
NOTE: If you are running any versions from 2.3 to 4.1 the “Replies per Staff” report is WRONG. I strongly suggest you upgrade to 4.2+
Ok, so after being on the osTicket forum since July 2009 I’ve noticed that one big MOD that everyone wants and never fully gets is reporting. The following is my stab at it.
This MOD has been implemented and tested on 1.7ST through 1.8.1, please let me know if you run into any issues.
Should you have any questions or issues please email scott.m.rowley (at) gmail (dot) com, this is where I’m mostly likely to see the email immediately.
Requirements: MySQL 5
pChart (for use with emailed reports) requires the GD and FreeType PHP extensions.
All files and directories should be owned by the user the web server is running as (such as apache / www-data)
Note: Reports v2.4+ is compatible with Internet Explorer.
Please note that the header file is now included in the zip file
In order to use the “Report Settings” (admin) page then you’ll need to add a new table to your database and then fill it with initial data, make sure and change the table prefix (ost_) if you are not using the default.
CREATE TABLE `ost_reports` ( `3d` TINYINT NOT NULL , `graphWidth` INT NOT NULL , `graphHeight` INT NOT NULL , `resolution` VARCHAR( 255 ) NOT NULL , `viewable` VARCHAR( 255 ) NOT NULL ) ENGINE = MYISAM ;
INSERT INTO `ost_reports` (`3d`, `graphWidth`, `graphHeight`, `resolution`, `viewable`) VALUES ('1', '400', '240', 'hours', 'admins');
Add the REPORTS_TABLE constant to
Once you’ve donated you should be receiving instructions to download the zip file. Extract all files to the scp/ directory and set all directories to 0755 and all files to 0644. Please also move the included file “include/staff/header.inc.php” to ROOT_INSTALL/include/staff/header.inc.php”
- Scheduled email reports
- Average time to initial response.
- Sorting by column title
- Language Support
The reports MOD is being used all over the world! Here’s a map of where Reports 6.x is being used today! (Note that this is only 6.x and not previous versions which would be a much MUCH larger map spread).
View Reports 6.0 in a larger map
Ensure your php.ini has short tags set to on
Check that your files and folders are accessible to the user running your webserver (such as www-data)
For researching issues it’s best to start looking in the error_log, this should give additional information as to the root cause of any issue being encountered.