Revision 6994
Added by Aaron Marcuse-Kubitza over 11 years ago
| 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
README.TXT: Data import: Replaced $version with <version> where it needs to be manually filled in