Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 4751 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 6338 about 12 years Aaron Marcuse-Kubitza pg_dump_vegbien: non-$owners mode: Removed --no...
  config 6321 about 12 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 6364 about 12 years Aaron Marcuse-Kubitza input.Makefile: Staging tables installation: $(...
  lib 6362 about 12 years Aaron Marcuse-Kubitza Added lib/MySQL.{data,schema}.sql.make template...
  mappings 6359 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Concatenated taxo...
  schemas 6360 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_stem_view: scie...
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 12 KB 6337 about 12 years Aaron Marcuse-Kubitza root Makefile: PostgreSQL: $(postgresReload-Lin...
README.TXT 14.5 KB 6370 about 12 years Aaron Marcuse-Kubitza README.TXT: Datasource setup: Add input data fo...
map 989 Bytes 5158 about 12 years Aaron Marcuse-Kubitza root map: Removed no longer needed public schem...
new_terms.csv 30.4 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
6370 11/24/2012 01:11 AM Aaron Marcuse-Kubitza

README.TXT: Datasource setup: Add input data for each table present in the datasource: Don't add a CSV or create.sql file for tables that are in a .sql export

6369 11/24/2012 01:06 AM Aaron Marcuse-Kubitza

README.TXT: Schema changes: Sync ERD with vegbien.sql schema: Changed instructions to just select tables with arrows next to them rather than all tables, because each table that's updated will have its lines reset and the number of lines that need to be fixed should be minimized

6368 11/24/2012 01:02 AM Aaron Marcuse-Kubitza

README.TXT: Datasource setup: Accept the test cases: `make inputs/<datasrc>/test by_col=1`: Clarified that errors could indicate bugs in the VegBIEN unique constraints

6367 11/24/2012 12:59 AM Aaron Marcuse-Kubitza

README.TXT: Data import: To remake analytical DB: Added explicit public schema setting since the analytical DB is often manually remade after the public schema has been renamed. Removed warnings that certain commands must be run after running make_analytical_db, because the "remake analytical DB" instructions no longer require this.

6366 11/24/2012 12:48 AM Aaron Marcuse-Kubitza

README.TXT: Datasource setup: MySQL inputs: Added steps to export the database to a PostgreSQL-compatible .sql file, which can be directly used by the install process without the need to export each table as CSV

6365 11/24/2012 12:36 AM Aaron Marcuse-Kubitza

README.TXT: Datasource setup: Choosing a table name: Documented that for .sql exports, you must use the name of the table in the DB export, not a suggested or custom name

6364 11/24/2012 12:34 AM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: $(dbExports): Also include the files that would be generated by running _MySQL/*.make and creating the corresponding PostgreSQL translations

6363 11/24/2012 12:18 AM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: Moved .sql export downloading and translation to separate Input data retrieval section

6362 11/23/2012 11:41 PM Aaron Marcuse-Kubitza

Added lib/MySQL.{data,schema}.sql.make templates to use in datasources' _MySQL/ dirs

6361 11/23/2012 10:38 PM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Updated import times

View all revisions | View revisions

Also available in: Atom