X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=doc%2Finstall.txt;h=284da64769fb3f82c4b75359c8535312ebed196b;hb=refs%2Fheads%2Fmsi;hp=4ae8d9c7cf45a12d12ab2832877201e485a955a2;hpb=00bebcfcee1d94b6c3dd7cc051224e5f77ea2674;p=eq%2F.git diff --git a/doc/install.txt b/doc/install.txt index 4ae8d9c..284da64 100644 --- a/doc/install.txt +++ b/doc/install.txt @@ -24,6 +24,7 @@ Dependencies 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 @@ -48,6 +49,12 @@ Installing 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: eq/sql/eq.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 EQ app to import your initial set of ward data obtained from MLS into the EQ application. 9) Click on the Admin tool and update the EQ Presidency Table appropriately. @@ -59,18 +66,22 @@ 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 + should be placed in 1 .zip file and uploaded to the application via the Admin section of the EQ Tools 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 @@ -78,6 +89,8 @@ Requirements Comp ID HT District Household + Quorum + Supervisor Organization.csv: Indiv ID @@ -87,3 +100,11 @@ Requirements Org Seq Sustained + EQ Prospective Elders.csv + Optional file that lists the prospective elders for which the EQ has stewardship. + Use this file if you want them listed in the PPI/attendence/etc lists + import mls/EQ\ Prospective\ Elders.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. +