X-Git-Url: http://git.pippins.net/embedvideo/.git/static/gitweb.js?a=blobdiff_plain;f=bin%2Fimport_ward_data;h=fe2cf3ed31ec2d42234d6b4cd165211b39010607;hb=3d1f26bd872559159627649482bde948420073a1;hp=7e8b7ac4787b49bd9ab57ab6122e638c37086b44;hpb=1c42e4dcbd4ebc672c7be3059a6e36ef1c9b0b74;p=eq%2F.git diff --git a/bin/import_ward_data b/bin/import_ward_data index 7e8b7ac..fe2cf3e 100755 --- a/bin/import_ward_data +++ b/bin/import_ward_data @@ -160,7 +160,7 @@ sub update_tc_indiv_table if($rows == 0) { # No existing records found for this indiv, make a new entry print " Adding new indiv: $indiv_name\n"; - $sth = $dbh->prepare("insert into tc_indiv values (NULL,'$id',\"$indiv_name\",'$year-$month-$day','$address','$phone','$email','','$hhposition','$priesthood','','1','','1','',$attending,1)"); + $sth = $dbh->prepare("insert into tc_indiv values (NULL,'$id',\"$indiv_name\",'$year-$month-$day','$address','$phone','$email','','$hhposition','$priesthood','','$default_interview_pri','','$default_interview_pri','',$attending,1)"); $sth->execute or die "-E- DB error: $DBI::errstr\n"; } elsif($rows == 1) { # An existing record was found for this indiv, update it @@ -381,7 +381,7 @@ sub update_tc_family_table if($rows == 0) { # No existing records found for this family, make a new entry print " Adding new Family: $family_name\n"; - $sth = $dbh->prepare("insert into tc_family values (NULL,$id,'$family_name','$name_id','0','0','1','',1)"); + $sth = $dbh->prepare("insert into tc_family values (NULL,$id,'$family_name','$name_id','0','0','$default_visit_pri','',1)"); $sth->execute or die "-E- DB error: $DBI::errstr\n"; } elsif($rows == 1) { # An existing record was found for this family, update it