Installation Guide

Installation Guide

Downloading

Official releases of the 3rd Counselor can be downloaded from http://github.com/apippin/tc/downloads

Source code can be obtained via the GIT revision control system by pulling from http://github.com/apippin/tc

Dependencies

• phpgroupware http://www.manvswebapp.com/phpgroupware * Installation instructions: http://web.archive.org/web/20080515231634/http://docs.phpgroupware.org/html/install/ * the Pre setup Tasks say to enter root's password when prompted while setting up the mysql database. If you just installed mysql and haven't configured it, then the password is blank, so just press enter. The "root" in this case is mysql root, not your system root. To set the mysql root user password, run "mysqladmin -u root password <new_password>"
• mysql
• apache (or equivalent webserver)
• Python 2.6 or .Net 3.5 (for trimming MLS data dumps)
• MLS data dumps (required fields shown below)

Installing

1. Download the tgz or zip file and extract it or GIT pull the archive into your base phpgroupware directory (like /usr/share/phpgroupware/).
2. Setup the mysql table structures for the 3rd Counselor application:

  mysql -u <dbuser> -p <dbpass> < tc/sql/tc.sql

Everything I've seen shows dbpass', which I don't get because it is the database project you set up while setting up phpgroupware, not the password. I followed the directions pretty closely, so my database project is phpgroupware. 3. Point your browser to: http://www.yourdomain.com/phpgroupware/setup. The setup prog will autodetect this application. Click on the "Manage Applications" button. In the new page, scroll down until you find "tc". Select the checkbox next to it in the "install" column and then click "save". 4. From there you will need to assign this app to the users you want to have be able to use it. Go to http://www.yourdomain.com/phpgroupware and login. Enable it for each user by going to Site Admin -> User Accounts -> -> edit. Make sure the "tc" application has a checkmark next to it under "Permissions this user has" 5. Copy the setup/db_config to setup/db_config.local and change the values in .local appropriately. Check for syntax errors by running tc/bin/check_config_syntax 6. Copy the setup/tc_config to setup/tc_config.local and change the values in .local appropriately. Make sure you update the path locations for your specific installation locations: upload_target_path & application_path. Check for syntax errors by running "tc/bin/check_config_syntax" 7. Try to run tc/bin/import_ward_data & parse_ward_data scripts from the commandline to check for any missing perl library dependencies and mysql connection. Just run them without command line args. Install the right perl modules until the scripts run without any errors. 8. A graphical representation of the mysql schema used by this application can be found here: tc/sql/tc.jpg 9. Run mls/mlstrimmer.py or MLSFileTrimmer.exe to trim down the csv files and combine them into a zip file. If you run mls/mlstrimmer.py, you'll need to point it to mls/windowsGUI/MLSFileTrimmer/MLSRequiredFields.xml. If you choose to not use Organization\ class\ per\ member.mls, you'll need to remove it from MLSRequiredFields.xml (probably best to just comment it out in case you decide to use it later) 10. Click on the Admin tool in the 3rd Counselor app to import your initial set of ward data obtained from MLS. 11. Click on the Admin tool and update the Presidency Table appropriately. The most important thing at this point is to get your district leaders added for each district you have in your quorum. 12. Click on Admin app in phpgroupware (not admin page in 3rd Counselor) and the click on "Site Configuration". Modify the "Enter the title for your site*:" field to your liking. 13. I highly recommend installing phpmyadmin to view/edit/debug mysql tables related to this tool.

Requirements

The following csv files must be obtained from MLS (or a stripped down version of each csv with the fields indicated must be manually created). These files should be placed in 1 .zip file and uploaded to the application via the Admin section of the application.

Membership.csv:

• Preferred Name
• Household Phone
• Indiv ID
• HofH ID
• Street 1
• Street 2
• Full Name
• Priesthood
• HH Position
• Household E-mail
• Individual E-mail

Hometeaching.csv:

• Home Teacher 1
• Home Teacher 2
• Comp ID
• HT District
• Household
• Quorum
• Supervisor

Organization.csv:

• Indiv ID
• Indiv Name
• Organization
• Position
• Org Seq
• Sustained

Organization class per member.csv

File that contains information about which organization classes each member belongs to. We use this to determine the prospective elders assigned to HP or EQ. Import ``mls/Organization class per member.mls'' as a new report into MLS to create the csv file.

Home Teacher per Companionship.csv (file that lists home teaching stats - use all fields)

Import ``mls/Home Teacher per Companionship.mls'' as a new report into MLS to create the csv file. This file makes keeping track of home teaching stats a lot easier since it just gets the data from mls and you don't have to enter them in manually here and in mls.