Project

General

Profile

« Previous | Next » 

Revision 6449

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/FIA/import_order.txt: Fixed bug where FIA_COND_unique needed to be explicitly included in import_order.txt now that we're using import_order.txt to import the Source metadata table before the data tables

View differences:

inputs/FIA/import_order.txt
1 1 
Source
2 
FIA_COND_unique
2 3 
Organism
inputs/FIA/FIA_COND_unique/VegBIEN.csv
1 
FIA,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 2 
PLT_CN,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
3 3 
PLT_CN,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
4 4 
PLT_CN,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
5 
oldgrowth,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/else/_alt/1/_not/value",
5 
oldgrowth,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/1/_not/value",
6 6 
PLT_CN,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",
7 7 
PLT_CN,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
8 8 
oldgrowth,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/1/_not/value",
inputs/FIA/FIA_COND_unique/test.xml.ref
1 1 
Put template:
2 2 
<VegBIEN>
3 
    <_simplifyPath id="-1">
4 
        <next>parent_id</next>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>FIA</shortname></source></source_id>
5 5 
        <path>
6 
            <location>
7 
                <sourceaccessioncode>$PLT_CN</sourceaccessioncode>
8 
                <iscultivated><_not><value>$oldgrowth</value></_not></iscultivated>
9 
            </location>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <sourceaccessioncode>$PLT_CN</sourceaccessioncode>
11 
                        <iscultivated><_not><value>$oldgrowth</value></_not></iscultivated>
12 
                    </location>
13 
                </path>
14 
            </_simplifyPath>
10 15 
        </path>
11 
    </_simplifyPath>
16 
    </_setDefault>
12 17 
</VegBIEN>
13 18 
Inserted 3 new rows into database

Also available in: Unified diff