Activity

From 08/01/2012 to 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

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

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

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

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

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

05:02 PM Task #458: map all VegX sources to stems table: * VegX sources have been mapped to @VegCSV-VegBIEN.specimens.csv@, which for now is copied to produce the other table... Aaron Marcuse-Kubitza
03:58 PM Task #383: convert VegBank data dictionary to database comments: Have URLs to VegBank data dictionary pages for *[[VegCSV]]* terms in "*mappings/VegCSV-VegBIEN.specimens.csv*":https:... Aaron Marcuse-Kubitza
12:18 PM Task #472 (Rejected): replace accessioncodes with datasource_id+sourceaccessioncode: * If we autopopulate the sourceaccessioncode using other input data (as some mappings do already), the datasource_id+... Aaron Marcuse-Kubitza
11:59 AM Task #471 (Resolved): add make actions so new dependent maps are rebuilt automatically when their source map changes: * Currently, you have to run @make mappings/@ in addition to @make test@ after any mappings changes
* Before VegCSV,... Aaron Marcuse-Kubitza

08:39 PM Task #470 (Resolved): source terms from old versions of DwC to the DwC history page: * "DwC history page":http://rs.tdwg.org/dwc/terms/history/index.htm
* This will provide an automatic link to the des... Aaron Marcuse-Kubitza
04:27 PM Task #469 (New): give everyone their own account on vegbien: * Replaces less secure shared password
* Ideally, get PostgreSQL to use the Linux password hashes on vegbiendev:
**... Aaron Marcuse-Kubitza
04:25 PM Task #468 (Resolved): rename/delete and recreate public schema in one transaction: * This ensures that an instance of the current public schema is always available Aaron Marcuse-Kubitza

11:15 PM Task #366 (Rejected): refactor VegX: We're switching to *[[VegCSV]]*, so this is no longer necessary Aaron Marcuse-Kubitza
11:14 PM Task #332 (Rejected): switch to VegX 1.5.3: We're switching to *[[VegCSV]]* instead Aaron Marcuse-Kubitza
11:13 PM Task #467 (New): underline all to do items in meetings notes: * This will make it easy to see not only which items are done (crossed out), but also which remain Aaron Marcuse-Kubitza
09:33 PM Task #464: reverse XPaths so that they start with location instead of plantobservation or specimenreplicate: All XPaths have been reversed. However, CTFS's two test rows needed to be disabled because they require a transformat... Aaron Marcuse-Kubitza
09:24 PM Task #466 (Rejected): column-based import: avoid most exceptions by introspecting the DB structure instead of waiting for a parseable exception to be raised: Aaron Marcuse-Kubitza

08:49 PM Task #465 (New): move issue tracker comments to wiki pages to ensure version history: replace comments with:
@[Comment moved to wiki to ensure version history]@ Aaron Marcuse-Kubitza
06:45 PM Task #464: reverse XPaths so that they start with location instead of plantobservation or specimenreplicate: [Comment moved to description to ensure version history] Aaron Marcuse-Kubitza
06:44 PM Task #464 (Resolved): reverse XPaths so that they start with location instead of plantobservation or specimenreplicate: For steps to reverse, see [[XPath Reversing]] Aaron Marcuse-Kubitza
06:38 PM Task #463 (Resolved): allow an input to appear multiple times in the same map spreadsheet: Both non-derived core maps (@mappings/DwC2-VegBIEN.specimens.csv@, @VegX-VegBIEN.stems.csv@) have had @expand_braces@... Aaron Marcuse-Kubitza

06:39 PM Task #463: allow an input to appear multiple times in the same map spreadsheet: Already multi-safe:
* all line operations
* set operations:
** @union@
*** Note that if there is _any_ mapping for a... Aaron Marcuse-Kubitza
06:18 PM Task #463 (Resolved): allow an input to appear multiple times in the same map spreadsheet: * This will allow an input to map to multiple outputs without needing to use the @{}@ custom XPath syntax Aaron Marcuse-Kubitza
05:50 PM Task #462 (Resolved): name backups according to svn revision instead of or in addition to the date: Aaron Marcuse-Kubitza

06:57 AM Task #461 (New): don't display warning when nullable boolean columns are handled without using COALESCE(): ... Aaron Marcuse-Kubitza

Also available in: Atom