taking out some dumper statements for troubleshooting that I had commented out
authorRogan Hamby <rhamby@esilibrary.com>
Tue, 27 Feb 2018 16:09:29 +0000 (11:09 -0500)
committerRogan Hamby <rhamby@esilibrary.com>
Tue, 27 Feb 2018 16:09:29 +0000 (11:09 -0500)
mig-bin/mig-gsheet
mig-sql/system/tlc/030_tlc_mapping_tables.sql

index d5ee6f5..fdf0cf8 100755 (executable)
@@ -98,8 +98,6 @@ if (defined $cmd_pull) {
         my @rows = $pull_ws->rows;
         my @content;
         map { $content[$_->row - 1][$_->col - 1] = $_->content } $pull_ws->cells;
-        #print Dumper($pull_ws->cells);
-        #print Dumper(@content);
         my @tab_headers = shift @content;
         my $tab_headers_length = $#{ $tab_headers[0] };
         my @pg_headers;
@@ -170,7 +168,6 @@ if (defined $cmd_push) {
             push @content, $record;
         }
 
-        #print Dumper(@content); 
         foreach my $fillsheet (@content) {
             my $new_row = $push_ws->add_row (
                 $fillsheet
index 08418ff..525b6c2 100644 (file)
@@ -138,10 +138,9 @@ VALUES
 CREATE TABLE map_tlc_phone (
     id                  SERIAL
     ,x_count            TEXT            
+    ,legacy_phone       TEXT
+    ,evergreen_phone    TEXT
     ,note               TEXT
-    ,migrate_available  TEXT
-    ,fill_in_method     TEXT
-    ,static_value       TEXT
 );
 
 INSERT INTO gsheet_tracked_table