X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=doc%2Finstall.txt;h=bb805d36afd550d839fbac9c0fc93a334f27714e;hb=refs%2Fheads%2Fowenleonard%2Fdatabase_changes;hp=10ae9feb00df556f4d9da147ba98e2fdcf5cd08d;hpb=4c76f4fb09d5118727e9951f0edfd5fa2d9b9ccb;p=eq%2F.git diff --git a/doc/install.txt b/doc/install.txt index 10ae9fe..bb805d3 100644 --- a/doc/install.txt +++ b/doc/install.txt @@ -1,49 +1,90 @@ -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 Downloading - Can be downloaded from some url. - _________________________________________________________________ - + Can be downloaded from: + http://github.com/apippin/3rd/downloads + + It can also be obtained via the GIT revision control system by pulling from here: + (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 + 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. + 11) If you need to start with a clean slate and drop all the tc_ tables, you can do it this way: + mysql -u phpgroupware -pphpgroupware phpgroupware -e "show tables" | grep "tc_" | gawk '{print "drop table " $1 ";"}' | mysql -u phpgroupware -pphpgroupware phpgroupware 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 @@ -51,6 +92,8 @@ Requirements Comp ID HT District Household + Quorum + Supervisor Organization.csv: Indiv ID @@ -60,3 +103,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. +