X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=doc%2Finstall.txt;h=631af6e61fdc46517c9197d06913b444fd120029;hb=fd3f70af9523a487a5b342501a39edad2e9b1080;hp=7ccd814cd4037b9feef45568070e68892730bfe0;hpb=6297f4c1657585de3c425d6be9588db58b34955b;p=eq%2F.git diff --git a/doc/install.txt b/doc/install.txt index 7ccd814..631af6e 100644 --- a/doc/install.txt +++ b/doc/install.txt @@ -1,11 +1,11 @@ -Elders Quorum Installation Guide +3rd Counselor Installation Guide Alan Pippin - v1.0, 19 May 2005 + v1.0, 05 Jan 2008 - Steps for installing Elders Quroum app + Steps for installing 3rd Counselor app _________________________________________________________________ Getting and Installing @@ -13,41 +13,77 @@ Getting and Installing Downloading Can be downloaded from: - https://eq.pippins.net/eq.tar + http://github.com/apippin/3rd/downloads It can also be obtained via the GIT revision control system by pulling from here: - http://git.pippins.net/eq/ + (ssh) git@github.com:apippin/3rd.git + (http) https://owenleonard@github.com/apippin/3rd.git + (git - read-only) git://github.com/apippin/3rd.git + +Dependencies + + phpgroupware + mysql + apache (or equivalent webserver) + MLS data dumps (required fields shown below) + Python 2.6 or .Net 3.5 (for trimming MLS data dumps) Installing - 1) Setup the mysql table structures for the EQ application - cd eq/setup/ and run mysql -u -p < eq.sql - 2) Point your browser to: http://www.yourdomain.com/phpgroupware/setup + 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 -p < tc/sql/tc.sql + 3) Point your browser to: http://www.yourdomain.com/phpgroupware/setup The setup prog will autodetect this application. From there you will need to assign this app to the users you want to have be able to use it. - 3) Edit the LOCAL CONFIGURATION section of eq/inc/class.eq.inc.php - Make sure you update the path locations for: - upload_target_path & script_path - 4) A graphical representation of the mysql schema used by this application can - be found here: eq/sql/eq.jpg - 5) Click on the Admin tool in the EQ app to import your initial set of ward data + 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" + 4) Copy the setup/db_config to setup/db_config.local and change the values in .local appropriately. + Check for syntax errors by running eq/bin/check_config_syntax + 5) 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 + 6) 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. + 7) A graphical representation of the mysql schema used by this application can + be found here: tc/sql/tc.jpg + 8) 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 + EQ\ Prospective\ Elders.mls or Home\ Teacher\ per\ Companionship.mls, you'll need to + remove them from MLSRequiredFields.xml (probably best to just comment them out in case you + decide to use them later) + 8) Click on the Admin tool in the 3rd Counselor app to import your initial set of ward data + obtained from MLS. + 9) 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. + 10) 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 uplodaed to the application via the Admin - section of the EQ Tools application. + should be placed in 1 .zip file and uploaded to the application via the Admin + section of the application. Membership.csv: Preferred Name - Phone 1 + Household Phone Indiv ID HofH ID Street 1 Street 2 Birth Full Name + Priesthood + HH Position + Household E-mail + Individual E-mail Hometeaching.csv: Home Teacher 1 @@ -55,6 +91,8 @@ Requirements Comp ID HT District Household + Quorum + Supervisor Organization.csv: Indiv ID @@ -64,3 +102,11 @@ Requirements 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 (optional 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. +