Project

General

Profile

« Previous | Next » 

Revision 6994

Added by Aaron Marcuse-Kubitza about 12 years ago

README.TXT: Data import: Replaced $version with <version> where it needs to be manually filled in

View differences:

README.TXT
71 71 
        make backups/analytical_aggregate.$version.csv.md5/test
72 72 
        Check that "OK" is printed next to the filename
73 73 
        In the bien_web DB:
74 
            Create the analytical_aggregate_$version table using its schema
74 
            Create the analytical_aggregate_<version> table using its schema
75 75 
                in schemas/vegbien.my.sql
76 76 
        env table=analytical_aggregate_$version bin/publish_analytical_db \
77 77 
            backups/analytical_aggregate.$version.csv
78 78 
    If desired, record the import times in inputs/import.stats.xls:
79 79 
        Open inputs/import.stats.xls
80 80 
        Insert a copy of the leftmost Column-based column group before it
81 
        bin/import_date inputs/{.,}*/*/logs/$version.log.sql
81 
        bin/import_date inputs/{.,}*/*/logs/<version>.log.sql
82 82 
        Update the import date in the upper-right corner
83 
        bin/import_times inputs/{.,}*/*/logs/$version.log.sql
83 
        bin/import_times inputs/{.,}*/*/logs/<version>.log.sql
84 84 
        Paste the output over the # Rows/Time columns, making sure that the
85 85 
            row counts match up with the previous import's row counts
86 86 
        If the row counts do not match up, insert or reorder rows as needed

Also available in: Unified diff