X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig;h=83ab565911a8073f059d9f0e3ffab90d07bff3bc;hp=14b97e4d6e8d78dd1fa33e1664bb59b653e33efd;hb=9279b06588202c95ec978c72ec0ad471f5a5f7c1;hpb=e1ec5cbdfcaa209535943d47136df6321b2e31ea

diff --git a/mig b/mig
index 14b97e4..83ab565 100755
--- a/mig
+++ b/mig
@@ -65,6 +65,8 @@ Using B<mig> should go something like this:
 
 =item mig reporter --analyst "Foo Fooer" --report_title "Foo Load Analysis" #creates an asciidoc report
 
+=item mig gsheet --pull foo_tab_name OR --push foo_pg_table_name 
+
 =back
 
 =head1 COMMANDS
@@ -253,6 +255,14 @@ Holds, Actors, Bibs, Assets & Money.
 
 Allows you to override the default evergreen_staged_report.xml in the mig-xml folder.
 
+=item B<gsheet> --pull spreadsheet_tab or --push postgres_table
+
+This uses the gsheet_tracked_table and gsheet_tracked column tables to map a Google Docs Spreadsheet tabs
+with Postgres tables in the mig schema.  The spreadsheet is assumed to share the name as the mig schema. 
+Tab names must be unique.  Each spreadsheet column needs a header that matches the column name in the matching 
+table.  An oauth session key is also needed for your Google account and mig gsheet will look for it in the 
+.mig directory.
+
 =back
 
 =cut
@@ -304,6 +314,10 @@ switch($ARGV[0]) {
         Mig::die_if_no_env_migschema();
         standard_invocation(@ARGV);
     }
+    case "gsheet" {
+        Mig::die_if_no_env_migschema();
+        standard_invocation(@ARGV);
+    }
     case "remove" {
         Mig::die_if_no_env_migschema();
         standard_invocation(@ARGV);