Project

General

Profile

Statistics
| Revision:

root @ 3204

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
  bin 3186 over 12 years Aaron Marcuse-Kubitza bin/map: by_col: Reuse existing out_db connecti...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 3203 over 12 years Aaron Marcuse-Kubitza VegBIEN: Fixing import issue related to duplica...
  lib 3197 over 12 years Aaron Marcuse-Kubitza PostgreSQL-MySQL.csv: Remove INHERITS clauses
  mappings 3203 over 12 years Aaron Marcuse-Kubitza VegBIEN: Fixing import issue related to duplica...
  schemas 3204 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: locationevent: Allow a loc...
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 10.4 KB 3156 over 12 years Aaron Marcuse-Kubitza main Makefile: python-Darwin: Added pip install...
README.TXT 2.9 KB 3133 over 12 years Aaron Marcuse-Kubitza input.Makefile: Added import/steps.by_col.sql t...
map 1.21 KB 3140 over 12 years Aaron Marcuse-Kubitza top-level map: Added support for custom public ...

Latest revisions

# Date Author Comment
3204 07/03/2012 02:10 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: locationevent: Allow a locationevent to be uniquely specified by its location (which is now datasource-scoped) and start date
3203 07/03/2012 01:26 PM Aaron Marcuse-Kubitza

VegBIEN: Fixing import issue related to duplicate entries in tables with children, where when a new table entry duplicates an existing entry, the 1:1 tables of that table and those tables' children are not merged, causing them to become orphaned. It is described in detail at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Import_issues#Merging-duplicates-with-children&gt;, including the rationale for this solution. Note that this is not a bug in column-based import, it applies to row-based import as well. This commit fixes the issue for specimenreplicate->...->location, by also mapping specimenreplicate's unique keys to location.sourceaccessioncode and setting location.datasource_id.
3202 07/03/2012 12:47 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: locationevent: Allow to be uniquely specified by location_id. This is useful for specimens data where there is one location for every locationevent.
3201 07/03/2012 12:27 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location: Added datasource_id and sourceaccessioncode so locations can be uniquely specified by the input datasource, rather than being created automatically for each locationevent
3200 07/03/2012 11:45 AM Aaron Marcuse-Kubitza

schemas/filter_ERD.csv: Add back taxondetermination->taxonoccurrence fkey because that has been replaced by a trigger in the SQL
3199 07/03/2012 11:06 AM Aaron Marcuse-Kubitza

VegBIEN: Fixing import issue related to duplicate entries in tables with children, where when a new table entry duplicates an existing entry, the 1:1 tables of that table and those tables' children are not merged, causing them to become orphaned. It is described in detail at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Import_issues#Merging-duplicates-with-children&gt;, including the rationale for this solution. Note that this is not a bug in column-based import, it applies to row-based import as well. This commit fixes the issue for specimenreplicate->taxonoccurrence.
3198 07/03/2012 07:40 AM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Updated with remaining stats from most recent import
3197 07/02/2012 03:52 PM Aaron Marcuse-Kubitza

PostgreSQL-MySQL.csv: Remove INHERITS clauses
3196 07/02/2012 02:37 PM Aaron Marcuse-Kubitza

schemas/vegbien.ERD.mwb: Fixed lines
3195 07/02/2012 02:24 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Moved in_row_ct updating to Subsetting section so the cursor's rowcount can be used directly

View all revisions | View revisions

Also available in: Atom