#+-------+--------------------+------+-----+---------+-------+
sub update_eq_aaronic_table
{
- print "-> Updating eq_aaronic table\n";
+ print "\n-> Updating eq_aaronic table\n";
# Set all records to be invalid. Only mark them as valid if they appear on the new list.
$sth = $dbh->prepare("update eq_aaronic set valid=0");
#+------------+------------------+------+-----+---------+-------+
sub update_eq_elder_table
{
- print "-> Updating eq_elder table\n";
+ print "\n-> Updating eq_elder table\n";
# Set all records to be invalid. Only mark them as valid if they appear on the new list.
$sth = $dbh->prepare("update eq_elder set valid=0");
#+--------------+------------------+------+-----+---------+-------+
sub update_eq_calling_table()
{
- print "-> Updating eq_calling table\n";
+ print "\n-> Updating eq_calling table\n";
#print "-> Organization Data Dump\n\n";
#&print_hash(\%organization_data);
{
# Districts should be created by hand. This subroutine only
# updates the supervisor's ID in each district.
- print "-> Updating eq_district table\n";
+ print "\n-> Updating eq_district table\n";
$sth = $dbh->prepare("select * from eq_district");
$sth->execute or die "-E- DB error: $DBI::errstr\n";
while($sqlhashref = $sth->fetchrow_hashref) {
#+---------------+------------------+------+-----+---------+-------+
sub update_eq_companionship_table
{
- print "-> Updating eq_companionship table\n";
+ print "\n-> Updating eq_companionship table\n";
# First, mark all existing companionships as invalid in case they have been dissolved
$sth = $dbh->prepare("update eq_companionship set valid=0");
#+---------------+------------------+------+-----+---------+-------+
sub update_eq_family_table
{
- print "-> Updating eq_family table\n";
+ print "\n-> Updating eq_family table\n";
# Set all records to be invalid. Only mark them as valid if they appear on the new list.
$sth = $dbh->prepare("update eq_family set valid=0");
$hashref = $hometeaching_data{$index};
foreach $key (keys %$hashref) {
if($hometeaching_data{$index}{'Household'} =~ /(\S+)\s+(\S+),\s+(\S+)\s+(.*)/) {
- print "I: Adjusting hometeaching match from: $hometeaching_data{$index}{'Household'} to $1, $3 $4\n";
- $hometeaching_data{$index}{'Household'} = "$1, $3 $4";
+ $a = $1; $b = $2; $c = $3; $d = $4;
+ if($family_name =~ /$a/ && $hometeaching_data{$index}{'Household'} !~ /$family_name/i) {
+ print "I: Adjusting hometeaching match from: $hometeaching_data{$index}{'Household'} to $a, $c $d\n";
+ $hometeaching_data{$index}{'Household'} = "$a, $c $d";
+ }
}
if($key =~ /Quorum/i &&
$hometeaching_data{$index}{$key} =~ /Elders/i &&
#+----------+------------------+------+-----+---------+-------+
sub update_eq_parent_table
{
- print "-> Updating eq_parent table\n";
+ print "\n-> Updating eq_parent table\n";
# Set all records to be invalid. Only mark them as valid if they appear on the new list.
$sth = $dbh->prepare("update eq_parent set valid=0");
#+----------+------------------+------+-----+---------+-------+
sub update_eq_child_table
{
- print "-> Updating eq_child table\n";
+ print "\n-> Updating eq_child table\n";
# Set all records to be invalid. Only mark them as valid if they appear on the new list.
$sth = $dbh->prepare("update eq_child set valid=0");
# Process command line options
if(defined $opt_n) { $datadir = $opt_n; }
else { $datadir = shift(@ARGV); }
-print "-> Processing all ward data files in $datadir\n";
+print "\n-> Processing all ward data files in $datadir\n";
###################################################
# Parse Ward Data Files