Revision 11098
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/VegBank/import_order.txt | ||
|---|---|---|
| 7 | 7 |
stemcount_ |
| 8 | 8 |
stemlocation_ |
| 9 | 9 |
taxon_observation.** |
| 10 |
observationcontributor_ |
|
| inputs/VegBank/observationcontributor_/create.sql | ||
|---|---|---|
| 1 |
SELECT * |
|
| 2 |
FROM observationcontributor |
|
| 3 |
LEFT JOIN party USING (party_id) |
|
| inputs/VegBank/observationcontributor_/header.csv | ||
|---|---|---|
| 1 |
party_id,observationcontributor_id,observation_id,role_id,contributiondate,salutation,givenname,middlename,surname,organizationname,currentname_id,contactinstructions,email,partytype,partypublic,party_d_obscount,accessioncode |
|
| inputs/VegBank/observationcontributor_/postprocess.sql | ||
|---|---|---|
| 1 |
SELECT util.search_path_append('util');
|
|
| 2 |
|
|
| 3 |
|
|
| 4 |
SELECT mk_derived_col((:table_str, 'event__participant'), |
|
| 5 |
$$_join_words(event__participant__name__first::text, event__participant__name__middle::text, event__participant__name__last::text)$$) |
|
| 6 |
; -- runtime: 1 s ("Time: 1265.039 ms") @starscream
|
|
| inputs/VegBank/observationcontributor_/run | ||
|---|---|---|
| 1 |
#!/bin/bash -e |
|
| 2 |
. "$(dirname "${BASH_SOURCE[0]}")"/../table.run
|
|
| 0 | 3 | |
| inputs/VegBank/observationcontributor_/map.csv | ||
|---|---|---|
| 1 |
VegBank,VegCore,Filter,Comments |
|
| 2 |
party_id,*party_id,, |
|
| 3 |
observationcontributor_id,*observationcontributor_id,, |
|
| 4 |
observation_id,eventID,, |
|
| 5 |
role_id,*role_id,, |
|
| 6 |
contributiondate,*contributiondate,, |
|
| 7 |
salutation,*salutation,, |
|
| 8 |
givenname,event__participant__name__first,, |
|
| 9 |
middlename,event__participant__name__middle,, |
|
| 10 |
surname,event__participant__name__last,, |
|
| 11 |
organizationname,*organizationname,, |
|
| 12 |
currentname_id,*currentname_id,, |
|
| 13 |
contactinstructions,*contactinstructions,, |
|
| 14 |
email,*email,, |
|
| 15 |
partytype,*partytype,, |
|
| 16 |
partypublic,*partypublic,, |
|
| 17 |
party_d_obscount,*party_d_obscount,, |
|
| 18 |
accessioncode,*accessioncode,, |
|
| inputs/VegBank/observationcontributor_/VegBIEN.csv | ||
|---|---|---|
| 1 |
link ../../../mappings/VegCore-VegBIEN.csv |
|
| 0 | 2 | |
| inputs/VegBank/observationcontributor_/test.xml.ref | ||
|---|---|---|
| 1 |
Put template: |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>VegBank.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationevent> |
|
| 11 |
<sourceaccessioncode>$eventID</sourceaccessioncode> |
|
| 12 |
<locationeventcontributor><party_id><party><fullname>$event__participant</fullname></party></party_id></locationeventcontributor> |
|
| 13 |
</locationevent> |
|
| 14 |
</location> |
|
| 15 |
</path> |
|
| 16 |
</_simplifyPath> |
|
| 17 |
</path> |
|
| 18 |
</_setDefault> |
|
| 19 |
</VegBIEN> |
|
| 20 |
Inserted 4 new rows into database |
|
| inputs/VegBank/observationcontributor_/new_terms.csv | ||
|---|---|---|
| 1 |
observation_id,eventID,, |
|
| 2 |
givenname,event__participant__name__first,, |
|
| 3 |
middlename,event__participant__name__middle,, |
|
| 4 |
surname,event__participant__name__last,, |
|
| inputs/VegBank/observationcontributor_/unmapped_terms.csv | ||
|---|---|---|
| 1 |
*party_id |
|
| 2 |
*observationcontributor_id |
|
| 3 |
*role_id |
|
| 4 |
*contributiondate |
|
| 5 |
*salutation |
|
| 6 |
event__participant__name__first |
|
| 7 |
event__participant__name__middle |
|
| 8 |
event__participant__name__last |
|
| 9 |
*organizationname |
|
| 10 |
*currentname_id |
|
| 11 |
*contactinstructions |
|
| 12 |
|
|
| 13 |
*partytype |
|
| 14 |
*partypublic |
|
| 15 |
*party_d_obscount |
|
| 16 |
*accessioncode |
|
Also available in: Unified diff
added inputs/VegBank/observationcontributor_/