ProjectTRACKER Admin Guideline

The ProjectTRACKER is distributed under the GNU General Public License means this program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. ProjectTRACKER is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public Licenses for more details.

The ProjectTRACKER is developed with the CodeCharge Studio web application development framework. The generated code by CodeCharge and add-ons are written in PHP and Javascript. ProjectTRACKER was tested with PHP version 5.2 and 5.3.

Currently MS Access and MySQL are the supported databases for ProjectTRACKER. In principle CodeCarge works also with other databases, but this has not been tested. Tested versions are:

The ProjectTRACKER installation package is delivered with the MySQL database connection only.

You need a server with MySQL and a web server (e.g. Apache) running. You will get this from your internet provider or e.g. can use the XAMPP package to install this on your computer for test purposes.

The ProjectTRACKER package is delivered in a ZIP-file, which contains:

• Directory trackergpl
  • Tracker PHP, HTML, Javascript files
  • Directory FCKeditor - Copy of FCK Editor Java Script files
  • Directory doc - ProjectTRACKER import format examples
  • Directory images - Images for ProjectTRACKER
  • Directory MySQL - MySQL scripts and installation files of the ProjectTRACKER
  • Directory phplot - Copy of PHPLOT PHP files
  • Directory Styles - Styles for ProjectTRACKER
  • Directory temp and temp2 - Place for storing ProjectTRACKER temporary files
  • Directory tracker-data - Place for import / export files and configuration data of ProjectTRACKER

Extract all files with exception of MySQL and doc to your web server. Make these files visible to your web server by either copy the files to the htdocs directory, or linking to another directory via:

Alias /tracker "D:/dir/tracker/"
<Directory "D:/dir/tracker">
   AllowOverride AuthConfig
   Order allow,deny
   Allow from all
</Directory>

Protect the directories temp and tracker-data from web access e.g. via a .htaccess file moved to these directories with the content:

order allow, deny
deny from all

Take care that the directories temp, temp2 and tracker-data can we written by your web server and follow the instructions in chapter ProjectTRACKER Configuration.

The ProjectTRACKER is generated with the CodeCharge Studio development framework. You do not need this framework to run the ProjectTRACKER, the framework is only needed to further develop the ProjectTRACKER. For more details see CodeCharge Installation / Configuration.

If your are allowed, change the following parameters in the php.ini file (e.g. in D:\xampp\apache\bin\php.ini) for the used Apache / PHP server:

Generate a new MySQL database. Either use the MyISAM or InnoDB database engine (MyISAM has better performance). Use “latin1_general_ci” as standard collation for this database.

Run the SQL script (e.g. via the MySQL admin tool phpMyAdmin) from the ProjectTRACKER ZIP-file directory MySQL to setup the ProjectTRACKER database tables:

• tracker-mysql-create.sql (for mySQL InnoDB)
• tracker-mysql-create-no-inno.sql (for mySQL MyISAM)

To adapt the ProjectTRACKER to your server environment and usage needs you should check / configure a few PHP constants / variables.

The mySQL setup is defined in the file Common.php in the PHP array $CCConnectionSettings at the beginning of the file:

$CCConnectionSettings = array (
  "Connection1" => array(
      "Type" => "MySQL",
      "DBLib" => "MySQL",
      "Database" => "tracker",
      "Host" => "localhost",
      "Port" => "3306",
      "User" => "tracker",
      "Password" => "tracker",
      "Persistent" => true,
      "DateFormat" => array("yyyy", "mm", "dd"),
      "BooleanFormat" => array(1, 0, ""),
      "Uppercase" => false
  )
);

Please change only the Database, Host, Port, User, Password. Note: For security reasons you should choose at least another, secure password for your database!

The ProjectTRACKER can be configured in the file Incl_Const.php via the following PHP constants at the beginning of the file:

and the deployment related constants at the end of the file:

Values in italic font are examples.

Note: Do not change any other PHP constants or code parts of the ProjectTRACKER if your are not a ProjectTRACKER “expert” - otherwise this might lead to erroneous behavior of the ProjectTRACKER and in the worst case you might loose important data.

Note: To install ProjectTRACKER for your needs follow the instructions in the next chapter!

After executing the steps described in the above chapters start the ProjectTRACKER via the the web link, e.g. http://localhost/tracker/Menu.php, defined by your web server configuration. Execute the following steps to setup the ProjectTRACKER demo:

1. You should see the login page.
2. Login with User admin and Password admin.
3. You should see the Main Menu.
4. Select the Maint page.
5. Select one demo import-file from the ProjectTRACKER ZIP-file directory MySQL:
   • tracker-demo-2009-english.xml (for English demo - version 1.X)
   • tracker-demo-2009-german.xml (for German demo - version 1.X)
   • tracker-demo-2012-english.xml (for English demo - version 2.X)
6. Click the Import button.
7. You should see something like:
   • Import table “Location”
   • Import table “Engineer”
   • …
   • Updated Engineer summary flags
   • Updated Task summary flags
   • Updated Progam summaries
   • Updated Year related tables

Done! - You can play now with the ProjectTRACKER demo - don't forget to read the manual and have fun!

Note: Be aware that you have set the Default Year to 2009 (old demos) or 2012 (Scrum demo) to see the demo project data!

After executing the steps described in the above chapters you can start the ProjectTRACKER via the the web link, e.g. http://my-intranet-webserver/Menu.php, defined by your web server configuration. Execute the following steps to setup the ProjectTRACKER to your needs:

1. You should see the login page.
2. Login with User admin and Password admin.
3. You should see the Main Menu.
4. Select the Maint page.
5. Click the Import button without selecting anything.
6. You should see:
   • Updated Engineer summary flags
   • Updated Task summary flags
   • Updated Program summaries
   • Updated Year related tables
7. Select the Profiles page.
8. Add / change Countries, Locations / Teams and Cost Groups as needed.
9. Select the Setup page.
10. Add / delete Tracking Years and change Task Effort Groups / Task Planning Groups top level group letters as needed.
11. Select the Users page.
12. Change the admin password. Use a secure password, only you as the ProjectTRACKER admin know!
13. Add new users as needed, set also the correct access rights and Location, Cost Groups. Assign also the correct Team Visibility to the users.
14. Don't forget to activate the newly defined users!
15. Select the Programs page.
16. Add new programs as needed, set also the correct Program Visibility. Do not delete the Operations program!
17. Dont't forget to make your programs active and visible to you.
18. Select the Tasks page.
19. You should see three predefined tasks: Absence, Operations and Training. You can rename the tasks accordingly but should not delete the operations tasks!
20. Add new tasks as needed.
21. Dont't forget to make your tasks active.
22. Add Scrum user stories or tasks as described for Tasks above.

Done! - You have configured the ProjectTRACKER for your needs - carefully read the manual, start to use the ProjectTRACKER and have fun!

Please follow the instructions in the Readme file provided with the ProjectTracker upgrade.

The following components and tools licensed from third parties have been included or are used with ProjectTRACKER:

Note: Customer's use of the Third Party Software is subject to the terms and conditions imposed by the licensors of such Third Party Software, which may differ from the GPL Software License.