09/10/2012

06:55 PM Task #490 (New): change import.stats.xls to use field rather than row count

* This will be more accurate, because different data sources have different #s of columns, and this affects the load ... Aaron Marcuse-Kubitza

09/05/2012

08:26 AM Task #484 (Resolved): support installing staging tables directly from a MySQL export

Aaron Marcuse-Kubitza

08/31/2012

06:55 PM Task #486 (New): add unit-conversion mechanism

* This is primarily needed for DBH, plot area, and elevation/depth
* Make quantities with units be a tuple type cont... Aaron Marcuse-Kubitza

02:34 PM Task #485 (New): track data provider's citation requirements in VegBIEN

* Some providers require them to be cited on any analysis that's conducted with their data:
** "Forest Plots Databas... Aaron Marcuse-Kubitza

02:08 PM Task #483 (Rejected): rename staging table columns according to map.csv

Reinstalling staging tables whenever a mapping changes is not a good idea.
Renaming will instead continue to occur d... Aaron Marcuse-Kubitza

08/30/2012

08:49 AM Task #484 (Resolved): support installing staging tables directly from a MySQL export

* requires (re-)exporting MySQL DB with "@--compatible=postgresql@":http://dev.mysql.com/doc/refman/5.6/en/mysqldump.... Aaron Marcuse-Kubitza

08/29/2012

04:16 PM Task #483 (Resolved): rename staging table columns according to map.csv

* This will allow us to have just one VegCore-VegBIEN mapping, with each staging table already using VegCore column n... Aaron Marcuse-Kubitza

08/28/2012

06:57 PM Task #482 (New): translate README.TXT to wiki page

* This will provide easy-to-read formatting to what is currently a plain text file Aaron Marcuse-Kubitza

06:31 PM Task #464 (Resolved): reverse XPaths so that they start with location instead of plantobservation or specimenreplicate

> CTFS's two test rows needed to be disabled because they require a transformation of the new mappings
CTFS is bei... Aaron Marcuse-Kubitza

06:30 PM Task #471 (Resolved): add make actions so new dependent maps are rebuilt automatically when their source map changes

This appears to be fixed now that the primary map refactoring is done and the symlinks are gone Aaron Marcuse-Kubitza

06:29 PM Task #458 (Resolved): map all VegX sources to stems table

Aaron Marcuse-Kubitza

06:28 PM Task #452 (Resolved): add column-based import to automated testing

@make test by_col=1@ Aaron Marcuse-Kubitza

08/27/2012

05:51 PM Task #480 (Resolved): automate adding a new table to an existing datasource

@make inputs/<datasrc>/<table>/add@ Aaron Marcuse-Kubitza

08/24/2012

07:51 PM Task #480 (Resolved): automate adding a new table to an existing datasource

Aaron Marcuse-Kubitza

08/23/2012

01:44 PM Task #477 (Rejected): allow putting specimens data directly in the top level of the datasource directory

* this avoids needing to create a single @specimens@ subdir for the DwC CSV
* need to work around make's autoremoval... Aaron Marcuse-Kubitza

01:39 PM Task #476 (New): develop map spreadsheet -> header override file translation utility

* this will avoid the need to create a @map.full.csv@ and @VegBIEN.csv@ file for each table, because @mappings/Veg+-V... Aaron Marcuse-Kubitza

08/17/2012

07:20 PM Task #474 (Rejected): use svn to figure out when a map file has changed and needs to be cleaned up

* Currently, a separate @.last_cleanup@ file is used as a timestamp.
This is problematic, because whenever a map fil... Aaron Marcuse-Kubitza

08/15/2012

07:48 AM Task #473 (Resolved): use _merge instead of _alt to avoid losing source data on import

Aaron Marcuse-Kubitza

08/14/2012

10:57 PM Task #473 (Resolved): use _merge instead of _alt to avoid losing source data on import

* _alt only preserves one of several alternative fields, while _merge concatenates them
* Important: _alt is still n... Aaron Marcuse-Kubitza