Data II Home | PeopleSoft Stats | Instructions | Load Average | Contact Us

How to install the statistics database and application script:

Unix AIX

What do you have to have?
  • MySQL database server (optionally you can edit scripts to use a different RDBMS), Apache, PHP. Also for java reports we chose KavaChart from ve.com. You can use simple tables or anything else.
    You can use a different RDBMS, different web server, or application server language (ColdFusion, Microsoft ASP, JSP, CGI, Perl etc.). Changes are minimal. As shown MySQL, Apache, and PHP are open source and FREE.
    1. Download the server scripts
    2. create a MySQL database and grant security. Use 'conn.php' to provide connection information.
    3. create the stats table as shown in table.schema
    4. Establish a maintenance schedule where you may want to delete some data (use for example: delete from stats where to_days(now()) - to_days(Sent) > 8; to keep only 8 days of detailed data). You can keep the peak results in a history table. MySQL will store a lot of data very efficiently.
    5. Finally install the client script using instructions (your can skip downloading the client file...)
    If you run into problems contact us at support@dataii.com and we could arrange consulting sessions.