Revision 11928
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/CVS/import_order.txt | ||
|---|---|---|
| 1 | 1 |
Source |
| 2 |
project |
|
| 2 | 3 |
plot_ |
| 3 | 4 |
observation_ |
| 4 | 5 |
stratumType |
| inputs/CVS/project/header.csv | ||
|---|---|---|
| 1 |
PROJECT_ID,projectName,projectDescription,startDate,stopDate,accessionCode,dba_src_ID,entry_projectCode,entry_projectCodeSource,entry_contactDetails,entry_eep_length,entry_eep_width,entry_eep_area,entry_eep_requiredPlots,entry_eep_projectType,entry_riverBasin_np_ID |
|
| inputs/CVS/project/run | ||
|---|---|---|
| 1 |
#!/bin/bash -e |
|
| 2 |
. "$(dirname "${BASH_SOURCE[0]}")"/../table.run
|
|
| 0 | 3 | |
| inputs/CVS/project/map.csv | ||
|---|---|---|
| 1 |
CVS,VegCore,Filter,Comments |
|
| 2 |
PROJECT_ID,projectID,, |
|
| 3 |
projectName,projectName,, |
|
| 4 |
projectDescription,*project--projectDescription,, |
|
| 5 |
startDate,projectStartDate,, |
|
| 6 |
stopDate,*project--stopDate,, |
|
| 7 |
accessionCode,*project--accessionCode,, |
|
| 8 |
dba_src_ID,*project--dba_src_ID,, |
|
| 9 |
entry_projectCode,*project--entry_projectCode,, |
|
| 10 |
entry_projectCodeSource,*project--entry_projectCodeSource,, |
|
| 11 |
entry_contactDetails,*project--entry_contactDetails,, |
|
| 12 |
entry_eep_length,*project--entry_eep_length,, |
|
| 13 |
entry_eep_width,*project--entry_eep_width,, |
|
| 14 |
entry_eep_area,*project--entry_eep_area,, |
|
| 15 |
entry_eep_requiredPlots,*project--entry_eep_requiredPlots,, |
|
| 16 |
entry_eep_projectType,*project--entry_eep_projectType,, |
|
| 17 |
entry_riverBasin_np_ID,*project--entry_riverBasin_np_ID,, |
|
| inputs/CVS/project/VegBIEN.csv | ||
|---|---|---|
| 1 |
link ../../../mappings/VegCore-VegBIEN.csv |
|
| 0 | 2 | |
| inputs/CVS/project/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CVS.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationevent> |
|
| 11 |
<project_id> |
|
| 12 |
<project> |
|
| 13 |
<projectname>$projectName</projectname> |
|
| 14 |
<sourceaccessioncode>$projectID</sourceaccessioncode> |
|
| 15 |
<startdate>$projectStartDate</startdate> |
|
| 16 |
</project> |
|
| 17 |
</project_id> |
|
| 18 |
</locationevent> |
|
| 19 |
</location> |
|
| 20 |
</path> |
|
| 21 |
</_simplifyPath> |
|
| 22 |
</path> |
|
| 23 |
</_setDefault> |
|
| 24 |
</VegBIEN> |
|
| 25 |
Inserted 3 new rows into database |
|
| inputs/CVS/project/new_terms.csv | ||
|---|---|---|
| 1 |
projectDescription,*project--projectDescription,, |
|
| 2 |
stopDate,*project--stopDate,, |
|
| 3 |
accessionCode,*project--accessionCode,, |
|
| 4 |
dba_src_ID,*project--dba_src_ID,, |
|
| 5 |
entry_projectCode,*project--entry_projectCode,, |
|
| 6 |
entry_projectCodeSource,*project--entry_projectCodeSource,, |
|
| 7 |
entry_contactDetails,*project--entry_contactDetails,, |
|
| 8 |
entry_eep_length,*project--entry_eep_length,, |
|
| 9 |
entry_eep_width,*project--entry_eep_width,, |
|
| 10 |
entry_eep_area,*project--entry_eep_area,, |
|
| 11 |
entry_eep_requiredPlots,*project--entry_eep_requiredPlots,, |
|
| 12 |
entry_eep_projectType,*project--entry_eep_projectType,, |
|
| 13 |
entry_riverBasin_np_ID,*project--entry_riverBasin_np_ID,, |
|
| inputs/CVS/project/unmapped_terms.csv | ||
|---|---|---|
| 1 |
*project--projectDescription |
|
| 2 |
*project--stopDate |
|
| 3 |
*project--accessionCode |
|
| 4 |
*project--dba_src_ID |
|
| 5 |
*project--entry_projectCode |
|
| 6 |
*project--entry_projectCodeSource |
|
| 7 |
*project--entry_contactDetails |
|
| 8 |
*project--entry_eep_length |
|
| 9 |
*project--entry_eep_width |
|
| 10 |
*project--entry_eep_area |
|
| 11 |
*project--entry_eep_requiredPlots |
|
| 12 |
*project--entry_eep_projectType |
|
| 13 |
*project--entry_riverBasin_np_ID |
|
Also available in: Unified diff
mapped inputs/CVS/project/, which includes the projectName for attribution