Project

General

Profile

« Previous | Next » 

Revision 10090

Added by Aaron Marcuse-Kubitza over 11 years ago

added inputs/FIA/*/{VegBIEN.csv,test.xml.ref}, which are now generated by the mapping process for the joined-together tables (even though they are not used by the import, because only occurrence_all is imported)

View differences:

inputs/FIA/PLOT/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2 
locationName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
3 
locationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
4 
locationID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
5 
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 
locationID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
7 
locationName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
8 
locationID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",
9 
locationID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
10 
locationName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
11 
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
12 
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
13 
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
14 
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
15 
locationID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
16 
locationID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
17 
*COUNTYCD,,** No join mapping for *COUNTYCD **
18 
*INVYR,,** No join mapping for *INVYR **
19 
*PLOT-CONGCD,,** No join mapping for *PLOT-CONGCD **
20 
*PLOT-CREATED_BY,,** No join mapping for *PLOT-CREATED_BY **
21 
*PLOT-CREATED_DATE,,** No join mapping for *PLOT-CREATED_DATE **
22 
*PLOT-CREATED_IN_INSTANCE,,** No join mapping for *PLOT-CREATED_IN_INSTANCE **
23 
*PLOT-CTY_CN,,** No join mapping for *PLOT-CTY_CN **
24 
*PLOT-CYCLE,,** No join mapping for *PLOT-CYCLE **
25 
*PLOT-DECLINATION,,** No join mapping for *PLOT-DECLINATION **
26 
*PLOT-DESIGNCD,,** No join mapping for *PLOT-DESIGNCD **
27 
*PLOT-DESIGNCD_P2A,,** No join mapping for *PLOT-DESIGNCD_P2A **
28 
*PLOT-ECOSUBCD,,** No join mapping for *PLOT-ECOSUBCD **
29 
*PLOT-ECO_UNIT_PNW,,** No join mapping for *PLOT-ECO_UNIT_PNW **
30 
*PLOT-EMAP_HEX,,** No join mapping for *PLOT-EMAP_HEX **
31 
*PLOT-GROW_TYP_CD,,** No join mapping for *PLOT-GROW_TYP_CD **
32 
*PLOT-INTENSITY,,** No join mapping for *PLOT-INTENSITY **
33 
*PLOT-INVASIVE_SAMPLING_STATUS_CD,,** No join mapping for *PLOT-INVASIVE_SAMPLING_STATUS_CD **
34 
*PLOT-INVASIVE_SPECIMEN_RULE_CD,,** No join mapping for *PLOT-INVASIVE_SPECIMEN_RULE_CD **
35 
*PLOT-KINDCD,,** No join mapping for *PLOT-KINDCD **
36 
*PLOT-KINDCD_NC,,** No join mapping for *PLOT-KINDCD_NC **
37 
*PLOT-MACRO_BREAKPOINT_DIA,,** No join mapping for *PLOT-MACRO_BREAKPOINT_DIA **
38 
*PLOT-MANUAL,,** No join mapping for *PLOT-MANUAL **
39 
*PLOT-MICROPLOT_LOC,,** No join mapping for *PLOT-MICROPLOT_LOC **
40 
*PLOT-MODIFIED_BY,,** No join mapping for *PLOT-MODIFIED_BY **
41 
*PLOT-MODIFIED_DATE,,** No join mapping for *PLOT-MODIFIED_DATE **
42 
*PLOT-MODIFIED_IN_INSTANCE,,** No join mapping for *PLOT-MODIFIED_IN_INSTANCE **
43 
*PLOT-MORT_TYP_CD,,** No join mapping for *PLOT-MORT_TYP_CD **
44 
*PLOT-NF_PLOT_NONSAMPLE_REASN_CD,,** No join mapping for *PLOT-NF_PLOT_NONSAMPLE_REASN_CD **
45 
*PLOT-NF_PLOT_STATUS_CD,,** No join mapping for *PLOT-NF_PLOT_STATUS_CD **
46 
*PLOT-NF_SAMPLING_STATUS_CD,,** No join mapping for *PLOT-NF_SAMPLING_STATUS_CD **
47 
*PLOT-P2PANEL,,** No join mapping for *PLOT-P2PANEL **
48 
*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD,,** No join mapping for *PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD **
49 
*PLOT-P2VEG_SAMPLING_STATUS_CD,,** No join mapping for *PLOT-P2VEG_SAMPLING_STATUS_CD **
50 
*PLOT-P3PANEL,,** No join mapping for *PLOT-P3PANEL **
51 
*PLOT-PLOT_NONSAMPLE_REASN_CD,,** No join mapping for *PLOT-PLOT_NONSAMPLE_REASN_CD **
52 
*PLOT-PLOT_STATUS_CD,,** No join mapping for *PLOT-PLOT_STATUS_CD **
53 
*PLOT-PREV_PLT_CN,,** No join mapping for *PLOT-PREV_PLT_CN **
54 
*PLOT-QA_STATUS,,** No join mapping for *PLOT-QA_STATUS **
55 
*PLOT-RDDISTCD,,** No join mapping for *PLOT-RDDISTCD **
56 
*PLOT-REMPER,,** No join mapping for *PLOT-REMPER **
57 
*PLOT-SAMP_METHOD_CD,,** No join mapping for *PLOT-SAMP_METHOD_CD **
58 
*PLOT-SRV_CN,,** No join mapping for *PLOT-SRV_CN **
59 
*PLOT-SUBCYCLE,,** No join mapping for *PLOT-SUBCYCLE **
60 
*PLOT-SUBPANEL,,** No join mapping for *PLOT-SUBPANEL **
61 
*PLOT-SUBP_EXAMINE_CD,,** No join mapping for *PLOT-SUBP_EXAMINE_CD **
62 
*PLOT-TOPO_POSITION_PNW,,** No join mapping for *PLOT-TOPO_POSITION_PNW **
63 
*PLOT-WATERCD,,** No join mapping for *PLOT-WATERCD **
64 
*PLOT-row_num,,** No join mapping for *PLOT-row_num **
65 
*STATECD,,** No join mapping for *STATECD **
66 
*UNITCD,,** No join mapping for *UNITCD **
67 
day,,** No join mapping for day **
68 
elevation_ft,,** No join mapping for elevation_ft **
69 
month,,** No join mapping for month **
70 
year,,** No join mapping for year **
inputs/FIA/PLOT/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>FIA</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <authorlocationcode>$locationName</authorlocationcode>
11 
                        <sourceaccessioncode>$locationID</sourceaccessioncode>
12 
                        <locationplace>
13 
                            <place_id>
14 
                                <place>
15 
                                    <coordinates_id>
16 
                                        <coordinates>
17 
                                            <latitude_deg>
18 
                                                <_nullIf>
19 
                                                    <null>0</null>
20 
                                                    <type>float</type>
21 
                                                    <value>$decimalLatitude</value>
22 
                                                </_nullIf>
23 
                                            </latitude_deg>
24 
                                            <longitude_deg>
25 
                                                <_nullIf>
26 
                                                    <null>0</null>
27 
                                                    <type>float</type>
28 
                                                    <value>$decimalLongitude</value>
29 
                                                </_nullIf>
30 
                                            </longitude_deg>
31 
                                        </coordinates>
32 
                                    </coordinates_id>
33 
                                    <matched_place_id>
34 
                                        <place>
35 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
36 
                                            <coordinates_id>
37 
                                                <coordinates>
38 
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
39 
                                                    <latitude_deg>
40 
                                                        <_nullIf>
41 
                                                            <null>0</null>
42 
                                                            <type>float</type>
43 
                                                            <value>$decimalLatitude</value>
44 
                                                        </_nullIf>
45 
                                                    </latitude_deg>
46 
                                                    <longitude_deg>
47 
                                                        <_nullIf>
48 
                                                            <null>0</null>
49 
                                                            <type>float</type>
50 
                                                            <value>$decimalLongitude</value>
51 
                                                        </_nullIf>
52 
                                                    </longitude_deg>
53 
                                                </coordinates>
54 
                                            </coordinates_id>
55 
                                        </place>
56 
                                    </matched_place_id>
57 
                                </place>
58 
                            </place_id>
59 
                        </locationplace>
60 
                    </location>
61 
                </path>
62 
            </_simplifyPath>
63 
        </path>
64 
    </_setDefault>
65 
</VegBIEN>
66 
Inserted 10 new rows into database
inputs/FIA/COUNTY/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2 
county,/location/locationplace/*_id/place/county,
3 
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
4 
*COUNTY-CN,,** No join mapping for *COUNTY-CN **
5 
*COUNTY-CREATED_BY,,** No join mapping for *COUNTY-CREATED_BY **
6 
*COUNTY-CREATED_DATE,,** No join mapping for *COUNTY-CREATED_DATE **
7 
*COUNTY-CREATED_IN_INSTANCE,,** No join mapping for *COUNTY-CREATED_IN_INSTANCE **
8 
*COUNTY-MODIFIED_BY,,** No join mapping for *COUNTY-MODIFIED_BY **
9 
*COUNTY-MODIFIED_DATE,,** No join mapping for *COUNTY-MODIFIED_DATE **
10 
*COUNTY-MODIFIED_IN_INSTANCE,,** No join mapping for *COUNTY-MODIFIED_IN_INSTANCE **
11 
*COUNTY-row_num,,** No join mapping for *COUNTY-row_num **
12 
*COUNTYCD,,** No join mapping for *COUNTYCD **
13 
*STATECD,,** No join mapping for *STATECD **
14 
*UNITCD,,** No join mapping for *UNITCD **
inputs/FIA/COUNTY/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>FIA</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <locationplace>
11 
                            <place_id>
12 
                                <place>
13 
                                    <county>$county</county>
14 
                                    <matched_place_id>
15 
                                        <place>
16 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
17 
                                            <county>$county</county>
18 
                                        </place>
19 
                                    </matched_place_id>
20 
                                </place>
21 
                            </place_id>
22 
                        </locationplace>
23 
                    </location>
24 
                </path>
25 
            </_simplifyPath>
26 
        </path>
27 
    </_setDefault>
28 
</VegBIEN>
29 
Inserted 6 new rows into database
inputs/FIA/REF_PLANT_DICTIONARY/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>FIA</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <locationevent>
11 
                            <taxonoccurrence>
12 
                                <taxondetermination>
13 
                                    <taxonverbatim_id>
14 
                                        <taxonverbatim>
15 
                                            <taxonlabel_id>
16 
                                                <taxonlabel>
17 
                                                    <parent_id>
18 
                                                        <taxonlabel>
19 
                                                            <parent_id>
20 
                                                                <taxonlabel>
21 
                                                                    <rank>cultivar</rank>
22 
                                                                    <parent_id>
23 
                                                                        <taxonlabel>
24 
                                                                            <rank>forma</rank>
25 
                                                                            <taxonepithet>$forma</taxonepithet>
26 
                                                                            <parent_id>
27 
                                                                                <taxonlabel>
28 
                                                                                    <rank>variety</rank>
29 
                                                                                    <taxonepithet>$variety</taxonepithet>
30 
                                                                                    <parent_id>
31 
                                                                                        <taxonlabel>
32 
                                                                                            <rank>subspecies</rank>
33 
                                                                                            <taxonepithet>$subspecies</taxonepithet>
34 
                                                                                            <parent_id>
35 
                                                                                                <taxonlabel>
36 
                                                                                                    <rank>species</rank>
37 
                                                                                                    <taxonepithet>$specificEpithet</taxonepithet>
38 
                                                                                                    <parent_id>
39 
                                                                                                        <taxonlabel>
40 
                                                                                                            <rank>genus</rank>
41 
                                                                                                            <taxonepithet>$genus</taxonepithet>
42 
                                                                                                            <parent_id>
43 
                                                                                                                <taxonlabel>
44 
                                                                                                                    <rank>family</rank>
45 
                                                                                                                    <taxonepithet>$family</taxonepithet>
46 
                                                                                                                </taxonlabel>
47 
                                                                                                            </parent_id>
48 
                                                                                                        </taxonlabel>
49 
                                                                                                    </parent_id>
50 
                                                                                                </taxonlabel>
51 
                                                                                            </parent_id>
52 
                                                                                        </taxonlabel>
53 
                                                                                    </parent_id>
54 
                                                                                </taxonlabel>
55 
                                                                            </parent_id>
56 
                                                                        </taxonlabel>
57 
                                                                    </parent_id>
58 
                                                                </taxonlabel>
59 
                                                            </parent_id>
60 
                                                        </taxonlabel>
61 
                                                    </parent_id>
62 
                                                    <taxonomicname>
63 
                                                        <_merge_prefix>
64 
                                                            <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>
65 
                                                            <value>
66 
                                                                <_alt>
67 
                                                                    <1>$scientificName</1>
68 
                                                                    <2>
69 
                                                                        <_alt>
70 
                                                                            <1>$taxonName</1>
71 
                                                                            <2>
72 
                                                                                <_join_words>
73 
                                                                                    <2><_filter_genus><value>$genus</value></_filter_genus></2>
74 
                                                                                    <3>$specificEpithet</3>
75 
                                                                                    <4>$subspecies</4>
76 
                                                                                    <6>
77 
                                                                                        <_join_words>
78 
                                                                                            <1>var. </1>
79 
                                                                                            <2>$variety</2>
80 
                                                                                        </_join_words>
81 
                                                                                    </6>
82 
                                                                                    <7>
83 
                                                                                        <_join_words>
84 
                                                                                            <1>fm. </1>
85 
                                                                                            <2>$forma</2>
86 
                                                                                        </_join_words>
87 
                                                                                    </7>
88 
                                                                                </_join_words>
89 
                                                                            </2>
90 
                                                                        </_alt>
91 
                                                                    </2>
92 
                                                                </_alt>
93 
                                                            </value>
94 
                                                        </_merge_prefix>
95 
                                                    </taxonomicname>
96 
                                                </taxonlabel>
97 
                                            </taxonlabel_id>
98 
                                            <family>$family</family>
99 
                                            <genus>$genus</genus>
100 
                                            <specific_epithet>$specificEpithet</specific_epithet>
101 
                                            <taxonname>$taxonName</taxonname>
102 
                                            <taxonomicname>$scientificName</taxonomicname>
103 
                                        </taxonverbatim>
104 
                                    </taxonverbatim_id>
105 
                                </taxondetermination>
106 
                            </taxonoccurrence>
107 
                        </locationevent>
108 
                    </location>
109 
                </path>
110 
            </_simplifyPath>
111 
        </path>
112 
    </_setDefault>
113 
</VegBIEN>
114 
Inserted 10 new rows into database
inputs/FIA/REF_PLANT_DICTIONARY/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
3 
taxonName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
4 
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=forma]/taxonepithet",
5 
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=variety]/taxonepithet",
6 
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
7 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
8 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
9 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
10 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,
11 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1,
12 
taxonName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1,
13 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_filter_genus/value,
14 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
15 
subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4,
16 
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
17 
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
18 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
19 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
20 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
21 
taxonName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
22 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname,
23 
*F_PREFIX,,** No join mapping for *F_PREFIX **
24 
*GENERA_BINOMIAL_AUTHOR,,** No join mapping for *GENERA_BINOMIAL_AUTHOR **
25 
*PLANT_SYMBOL,,** No join mapping for *PLANT_SYMBOL **
26 
*PLANT_SYMBOL_TYPE,,** No join mapping for *PLANT_SYMBOL_TYPE **
27 
*QUADRINOMIAL_AUTHOR,,** No join mapping for *QUADRINOMIAL_AUTHOR **
28 
*REF_PLANT_DICTIONARY-CATEGORY,,** No join mapping for *REF_PLANT_DICTIONARY-CATEGORY **
29 
*REF_PLANT_DICTIONARY-CN,,** No join mapping for *REF_PLANT_DICTIONARY-CN **
30 
*REF_PLANT_DICTIONARY-CREATED_BY,,** No join mapping for *REF_PLANT_DICTIONARY-CREATED_BY **
31 
*REF_PLANT_DICTIONARY-CREATED_DATE,,** No join mapping for *REF_PLANT_DICTIONARY-CREATED_DATE **
32 
*REF_PLANT_DICTIONARY-CREATED_IN_INSTANCE,,** No join mapping for *REF_PLANT_DICTIONARY-CREATED_IN_INSTANCE **
33 
*REF_PLANT_DICTIONARY-DURATION,,** No join mapping for *REF_PLANT_DICTIONARY-DURATION **
34 
*REF_PLANT_DICTIONARY-MODIFIED_BY,,** No join mapping for *REF_PLANT_DICTIONARY-MODIFIED_BY **
35 
*REF_PLANT_DICTIONARY-MODIFIED_DATE,,** No join mapping for *REF_PLANT_DICTIONARY-MODIFIED_DATE **
36 
*REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE **
37 
*REF_PLANT_DICTIONARY-NEW_SCIENTIFIC_NAME,,** No join mapping for *REF_PLANT_DICTIONARY-NEW_SCIENTIFIC_NAME **
38 
*REF_PLANT_DICTIONARY-NEW_SYMBOL,,** No join mapping for *REF_PLANT_DICTIONARY-NEW_SYMBOL **
39 
*REF_PLANT_DICTIONARY-NOTES,,** No join mapping for *REF_PLANT_DICTIONARY-NOTES **
40 
*REF_PLANT_DICTIONARY-STATE_AND_PROVINCE,,** No join mapping for *REF_PLANT_DICTIONARY-STATE_AND_PROVINCE **
41 
*REF_PLANT_DICTIONARY-STATE_DISTRIBUTION,,** No join mapping for *REF_PLANT_DICTIONARY-STATE_DISTRIBUTION **
42 
*REF_PLANT_DICTIONARY-US_NATIVITY,,** No join mapping for *REF_PLANT_DICTIONARY-US_NATIVITY **
43 
*REF_PLANT_DICTIONARY-row_num,,** No join mapping for *REF_PLANT_DICTIONARY-row_num **
44 
*SSP_PREFIX,,** No join mapping for *SSP_PREFIX **
45 
*SUBVAR,,** No join mapping for *SUBVAR **
46 
*SUBVARIETY,,** No join mapping for *SUBVARIETY **
47 
*TRINOMIAL_AUTHOR,,** No join mapping for *TRINOMIAL_AUTHOR **
48 
*VAR_PREFIX,,** No join mapping for *VAR_PREFIX **
49 
*XGENUS,,** No join mapping for *XGENUS **
50 
*XSPECIES,,** No join mapping for *XSPECIES **
51 
*XSUBSPECIES,,** No join mapping for *XSUBSPECIES **
52 
*XVARIETY,,** No join mapping for *XVARIETY **
53 
taxonGrowthForm,,** No join mapping for taxonGrowthForm **
54 
vernacularName,,** No join mapping for vernacularName **
inputs/FIA/REF_UNIT/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2 
*REF_UNIT-CREATED_BY,,** No join mapping for *REF_UNIT-CREATED_BY **
3 
*REF_UNIT-CREATED_DATE,,** No join mapping for *REF_UNIT-CREATED_DATE **
4 
*REF_UNIT-CREATED_IN_INSTANCE,,** No join mapping for *REF_UNIT-CREATED_IN_INSTANCE **
5 
*REF_UNIT-MEANING,,** No join mapping for *REF_UNIT-MEANING **
6 
*REF_UNIT-MODIFIED_BY,,** No join mapping for *REF_UNIT-MODIFIED_BY **
7 
*REF_UNIT-MODIFIED_DATE,,** No join mapping for *REF_UNIT-MODIFIED_DATE **
8 
*REF_UNIT-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_UNIT-MODIFIED_IN_INSTANCE **
9 
*REF_UNIT-row_num,,** No join mapping for *REF_UNIT-row_num **
10 
*STATECD,,** No join mapping for *STATECD **
11 
*UNITCD,,** No join mapping for *UNITCD **
inputs/FIA/REF_UNIT/test.xml.ref
1 
Put template:
2 
<VegBIEN/>Inserted 0 new rows into database
inputs/FIA/COND/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2 
locationName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
3 
authorEventCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",
4 
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
5 
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
6 
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
7 
locationName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
8 
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authoreventcode",
9 
authorEventCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
10 
locationName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
11 
slopeAspect,/location/slopeaspect_deg/_alt/1/_compass/value,
12 
slopeGradient,/location/slopegradient_fraction/_alt/1,
13 
*COND-ADFORCD,,** No join mapping for *COND-ADFORCD **
14 
*COND-ADMIN_WITHDRAWN_CD,,** No join mapping for *COND-ADMIN_WITHDRAWN_CD **
15 
*COND-ALSTK,,** No join mapping for *COND-ALSTK **
16 
*COND-ALSTKCD,,** No join mapping for *COND-ALSTKCD **
17 
*COND-BALIVE,,** No join mapping for *COND-BALIVE **
18 
*COND-CANOPY_CVR_SAMPLE_METHOD_CD,,** No join mapping for *COND-CANOPY_CVR_SAMPLE_METHOD_CD **
19 
*COND-CARBON_DOWN_DEAD,,** No join mapping for *COND-CARBON_DOWN_DEAD **
20 
*COND-CARBON_LITTER,,** No join mapping for *COND-CARBON_LITTER **
21 
*COND-CARBON_SOIL_ORG,,** No join mapping for *COND-CARBON_SOIL_ORG **
22 
*COND-CARBON_STANDING_DEAD,,** No join mapping for *COND-CARBON_STANDING_DEAD **
23 
*COND-CARBON_UNDERSTORY_AG,,** No join mapping for *COND-CARBON_UNDERSTORY_AG **
24 
*COND-CARBON_UNDERSTORY_BG,,** No join mapping for *COND-CARBON_UNDERSTORY_BG **
25 
*COND-CN,,** No join mapping for *COND-CN **
26 
*COND-CONDPROP_UNADJ,,** No join mapping for *COND-CONDPROP_UNADJ **
27 
*COND-COND_NONSAMPLE_REASN_CD,,** No join mapping for *COND-COND_NONSAMPLE_REASN_CD **
28 
*COND-COND_STATUS_CD,,** No join mapping for *COND-COND_STATUS_CD **
29 
*COND-CREATED_BY,,** No join mapping for *COND-CREATED_BY **
30 
*COND-CREATED_DATE,,** No join mapping for *COND-CREATED_DATE **
31 
*COND-CREATED_IN_INSTANCE,,** No join mapping for *COND-CREATED_IN_INSTANCE **
32 
*COND-CYCLE,,** No join mapping for *COND-CYCLE **
33 
*COND-DSTRBCD1,,** No join mapping for *COND-DSTRBCD1 **
34 
*COND-DSTRBCD2,,** No join mapping for *COND-DSTRBCD2 **
35 
*COND-DSTRBCD3,,** No join mapping for *COND-DSTRBCD3 **
36 
*COND-DSTRBYR1,,** No join mapping for *COND-DSTRBYR1 **
37 
*COND-DSTRBYR2,,** No join mapping for *COND-DSTRBYR2 **
38 
*COND-DSTRBYR3,,** No join mapping for *COND-DSTRBYR3 **
39 
*COND-FIRE_SRS,,** No join mapping for *COND-FIRE_SRS **
40 
*COND-FLDAGE,,** No join mapping for *COND-FLDAGE **
41 
*COND-FLDSZCD,,** No join mapping for *COND-FLDSZCD **
42 
*COND-FLDTYPCD,,** No join mapping for *COND-FLDTYPCD **
43 
*COND-FORINDCD,,** No join mapping for *COND-FORINDCD **
44 
*COND-FORTYPCD,,** No join mapping for *COND-FORTYPCD **
45 
*COND-FORTYPCDCALC,,** No join mapping for *COND-FORTYPCDCALC **
46 
*COND-GRAZING_SRS,,** No join mapping for *COND-GRAZING_SRS **
47 
*COND-GROUND_LAND_CLASS_PNW,,** No join mapping for *COND-GROUND_LAND_CLASS_PNW **
48 
*COND-GSSTK,,** No join mapping for *COND-GSSTK **
49 
*COND-GSSTKCD,,** No join mapping for *COND-GSSTKCD **
50 
*COND-HABTYPCD1_DESCR_PUB_CD,,** No join mapping for *COND-HABTYPCD1_DESCR_PUB_CD **
51 
*COND-HABTYPCD2,,** No join mapping for *COND-HABTYPCD2 **
52 
*COND-HABTYPCD2_DESCR_PUB_CD,,** No join mapping for *COND-HABTYPCD2_DESCR_PUB_CD **
53 
*COND-HABTYPCD2_PUB_CD,,** No join mapping for *COND-HABTYPCD2_PUB_CD **
54 
*COND-HARVEST_TYPE1_SRS,,** No join mapping for *COND-HARVEST_TYPE1_SRS **
55 
*COND-HARVEST_TYPE2_SRS,,** No join mapping for *COND-HARVEST_TYPE2_SRS **
56 
*COND-HARVEST_TYPE3_SRS,,** No join mapping for *COND-HARVEST_TYPE3_SRS **
57 
*COND-INDUSTRIALCD_FIADB,,** No join mapping for *COND-INDUSTRIALCD_FIADB **
58 
*COND-LAND_USE_SRS,,** No join mapping for *COND-LAND_USE_SRS **
59 
*COND-LIVE_CANOPY_CVR_PCT,,** No join mapping for *COND-LIVE_CANOPY_CVR_PCT **
60 
*COND-LIVE_MISSING_CANOPY_CVR_PCT,,** No join mapping for *COND-LIVE_MISSING_CANOPY_CVR_PCT **
61 
*COND-MACRPROP_UNADJ,,** No join mapping for *COND-MACRPROP_UNADJ **
62 
*COND-MAPDEN,,** No join mapping for *COND-MAPDEN **
63 
*COND-MICRPROP_UNADJ,,** No join mapping for *COND-MICRPROP_UNADJ **
64 
*COND-MIXEDCONFCD,,** No join mapping for *COND-MIXEDCONFCD **
65 
*COND-MODIFIED_BY,,** No join mapping for *COND-MODIFIED_BY **
66 
*COND-MODIFIED_DATE,,** No join mapping for *COND-MODIFIED_DATE **
67 
*COND-MODIFIED_IN_INSTANCE,,** No join mapping for *COND-MODIFIED_IN_INSTANCE **
68 
*COND-NBR_LIVE_STEMS,,** No join mapping for *COND-NBR_LIVE_STEMS **
69 
*COND-NF_COND_NONSAMPLE_REASN_CD,,** No join mapping for *COND-NF_COND_NONSAMPLE_REASN_CD **
70 
*COND-NF_COND_STATUS_CD,,** No join mapping for *COND-NF_COND_STATUS_CD **
71 
*COND-OPERABILITY_SRS,,** No join mapping for *COND-OPERABILITY_SRS **
72 
*COND-OWNCD,,** No join mapping for *COND-OWNCD **
73 
*COND-OWNGRPCD,,** No join mapping for *COND-OWNGRPCD **
74 
*COND-OWNSUBCD,,** No join mapping for *COND-OWNSUBCD **
75 
*COND-PHYSCLCD,,** No join mapping for *COND-PHYSCLCD **
76 
*COND-PLANT_STOCKABILITY_FACTOR_PNW,,** No join mapping for *COND-PLANT_STOCKABILITY_FACTOR_PNW **
77 
*COND-PLT_CN,,** No join mapping for *COND-PLT_CN **
78 
*COND-PRESNFCD,,** No join mapping for *COND-PRESNFCD **
79 
*COND-PROP_BASIS,,** No join mapping for *COND-PROP_BASIS **
80 
*COND-RESERVCD,,** No join mapping for *COND-RESERVCD **
81 
*COND-RESERVCD_FLD,,** No join mapping for *COND-RESERVCD_FLD **
82 
*COND-SIBASE,,** No join mapping for *COND-SIBASE **
83 
*COND-SICOND,,** No join mapping for *COND-SICOND **
84 
*COND-SISP,,** No join mapping for *COND-SISP **
85 
*COND-SITECLCD,,** No join mapping for *COND-SITECLCD **
86 
*COND-SITECLCDEST,,** No join mapping for *COND-SITECLCDEST **
87 
*COND-SITECL_METHOD,,** No join mapping for *COND-SITECL_METHOD **
88 
*COND-SITETREE_TREE,,** No join mapping for *COND-SITETREE_TREE **
89 
*COND-SOIL_ROOTING_DEPTH_PNW,,** No join mapping for *COND-SOIL_ROOTING_DEPTH_PNW **
90 
*COND-STAND_STRUCTURE_SRS,,** No join mapping for *COND-STAND_STRUCTURE_SRS **
91 
*COND-STDAGE,,** No join mapping for *COND-STDAGE **
92 
*COND-STDORGCD,,** No join mapping for *COND-STDORGCD **
93 
*COND-STDORGSP,,** No join mapping for *COND-STDORGSP **
94 
*COND-STDSZCD,,** No join mapping for *COND-STDSZCD **
95 
*COND-STND_COND_CD_PNWRS,,** No join mapping for *COND-STND_COND_CD_PNWRS **
96 
*COND-STND_STRUC_CD_PNWRS,,** No join mapping for *COND-STND_STRUC_CD_PNWRS **
97 
*COND-STUMP_CD_PNWRS,,** No join mapping for *COND-STUMP_CD_PNWRS **
98 
*COND-SUBCYCLE,,** No join mapping for *COND-SUBCYCLE **
99 
*COND-SUBPPROP_UNADJ,,** No join mapping for *COND-SUBPPROP_UNADJ **
100 
*COND-TRTCD1,,** No join mapping for *COND-TRTCD1 **
101 
*COND-TRTCD2,,** No join mapping for *COND-TRTCD2 **
102 
*COND-TRTCD3,,** No join mapping for *COND-TRTCD3 **
103 
*COND-TRTYR1,,** No join mapping for *COND-TRTYR1 **
104 
*COND-TRTYR2,,** No join mapping for *COND-TRTYR2 **
105 
*COND-TRTYR3,,** No join mapping for *COND-TRTYR3 **
106 
*COND-VOL_LOC_GRP,,** No join mapping for *COND-VOL_LOC_GRP **
107 
*COND-row_num,,** No join mapping for *COND-row_num **
108 
*COUNTYCD,,** No join mapping for *COUNTYCD **
109 
*HABTYPCD,,** No join mapping for *HABTYPCD **
110 
*HABTYP_PUB_CD,,** No join mapping for *HABTYP_PUB_CD **
111 
*INVYR,,** No join mapping for *INVYR **
112 
*STATECD,,** No join mapping for *STATECD **
113 
*UNITCD,,** No join mapping for *UNITCD **
inputs/FIA/COND/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>FIA</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <authorlocationcode>$locationName</authorlocationcode>
11 
                        <locationevent><authoreventcode>$authorEventCode</authoreventcode></locationevent>
12 
                        <slopeaspect_deg><_compass><value>$slopeAspect</value></_compass></slopeaspect_deg>
13 
                        <slopegradient_fraction>$slopeGradient</slopegradient_fraction>
14 
                    </location>
15 
                </path>
16 
            </_simplifyPath>
17 
        </path>
18 
    </_setDefault>
19 
</VegBIEN>
20 
Inserted 3 new rows into database
inputs/FIA/REF_SPECIES/test.xml.ref
1 
Put template:
2 
<VegBIEN/>Inserted 0 new rows into database
inputs/FIA/REF_SPECIES/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2 
*PLANT_SYMBOL,,** No join mapping for *PLANT_SYMBOL **
3 
*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT,,** No join mapping for *REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT **
4 
*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT_CIT,,** No join mapping for *REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT_CIT **
5 
*REF_SPECIES-BARK_VOL_PCT,,** No join mapping for *REF_SPECIES-BARK_VOL_PCT **
6 
*REF_SPECIES-BARK_VOL_PCT_CIT,,** No join mapping for *REF_SPECIES-BARK_VOL_PCT_CIT **
7 
*REF_SPECIES-CARIBBEAN,,** No join mapping for *REF_SPECIES-CARIBBEAN **
8 
*REF_SPECIES-COMMON_NAME,,** No join mapping for *REF_SPECIES-COMMON_NAME **
9 
*REF_SPECIES-CORE,,** No join mapping for *REF_SPECIES-CORE **
10 
*REF_SPECIES-CREATED_BY,,** No join mapping for *REF_SPECIES-CREATED_BY **
11 
*REF_SPECIES-CREATED_DATE,,** No join mapping for *REF_SPECIES-CREATED_DATE **
12 
*REF_SPECIES-CREATED_IN_INSTANCE,,** No join mapping for *REF_SPECIES-CREATED_IN_INSTANCE **
13 
*REF_SPECIES-CWD_DECAY_RATIO1,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO1 **
14 
*REF_SPECIES-CWD_DECAY_RATIO2,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO2 **
15 
*REF_SPECIES-CWD_DECAY_RATIO3,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO3 **
16 
*REF_SPECIES-CWD_DECAY_RATIO4,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO4 **
17 
*REF_SPECIES-CWD_DECAY_RATIO5,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO5 **
18 
*REF_SPECIES-C_SPGRPCD,,** No join mapping for *REF_SPECIES-C_SPGRPCD **
19 
*REF_SPECIES-DWM_CARBON_RATIO,,** No join mapping for *REF_SPECIES-DWM_CARBON_RATIO **
20 
*REF_SPECIES-EAST,,** No join mapping for *REF_SPECIES-EAST **
21 
*REF_SPECIES-EXISTS_IN_NCRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_NCRS **
22 
*REF_SPECIES-EXISTS_IN_NERS,,** No join mapping for *REF_SPECIES-EXISTS_IN_NERS **
23 
*REF_SPECIES-EXISTS_IN_PNWRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_PNWRS **
24 
*REF_SPECIES-EXISTS_IN_RMRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_RMRS **
25 
*REF_SPECIES-EXISTS_IN_SRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_SRS **
26 
*REF_SPECIES-E_SPGRPCD,,** No join mapping for *REF_SPECIES-E_SPGRPCD **
27 
*REF_SPECIES-FOREST_TYPE_SPGRPCD,,** No join mapping for *REF_SPECIES-FOREST_TYPE_SPGRPCD **
28 
*REF_SPECIES-GENUS,,** No join mapping for *REF_SPECIES-GENUS **
29 
*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_FOLIAGE_RATIO_B1 **
30 
*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_FOLIAGE_RATIO_B2 **
31 
*REF_SPECIES-JENKINS_ROOT_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_ROOT_RATIO_B1 **
32 
*REF_SPECIES-JENKINS_ROOT_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_ROOT_RATIO_B2 **
33 
*REF_SPECIES-JENKINS_SAPLING_ADJUSTMENT,,** No join mapping for *REF_SPECIES-JENKINS_SAPLING_ADJUSTMENT **
34 
*REF_SPECIES-JENKINS_SPGRPCD,,** No join mapping for *REF_SPECIES-JENKINS_SPGRPCD **
35 
*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_STEM_BARK_RATIO_B1 **
36 
*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_STEM_BARK_RATIO_B2 **
37 
*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B1 **
38 
*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B2 **
39 
*REF_SPECIES-JENKINS_TOTAL_B1,,** No join mapping for *REF_SPECIES-JENKINS_TOTAL_B1 **
40 
*REF_SPECIES-JENKINS_TOTAL_B2,,** No join mapping for *REF_SPECIES-JENKINS_TOTAL_B2 **
41 
*REF_SPECIES-MAJOR_SPGRPCD,,** No join mapping for *REF_SPECIES-MAJOR_SPGRPCD **
42 
*REF_SPECIES-MANUAL_END,,** No join mapping for *REF_SPECIES-MANUAL_END **
43 
*REF_SPECIES-MANUAL_START,,** No join mapping for *REF_SPECIES-MANUAL_START **
44 
*REF_SPECIES-MC_PCT_GREEN_BARK,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_BARK **
45 
*REF_SPECIES-MC_PCT_GREEN_BARK_CIT,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_BARK_CIT **
46 
*REF_SPECIES-MC_PCT_GREEN_WOOD,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_WOOD **
47 
*REF_SPECIES-MC_PCT_GREEN_WOOD_CIT,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_WOOD_CIT **
48 
*REF_SPECIES-MODIFIED_BY,,** No join mapping for *REF_SPECIES-MODIFIED_BY **
49 
*REF_SPECIES-MODIFIED_DATE,,** No join mapping for *REF_SPECIES-MODIFIED_DATE **
50 
*REF_SPECIES-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_SPECIES-MODIFIED_IN_INSTANCE **
51 
*REF_SPECIES-PACIFIC,,** No join mapping for *REF_SPECIES-PACIFIC **
52 
*REF_SPECIES-P_SPGRPCD,,** No join mapping for *REF_SPECIES-P_SPGRPCD **
53 
*REF_SPECIES-RAILE_STUMP_DIB_B1,,** No join mapping for *REF_SPECIES-RAILE_STUMP_DIB_B1 **
54 
*REF_SPECIES-RAILE_STUMP_DIB_B2,,** No join mapping for *REF_SPECIES-RAILE_STUMP_DIB_B2 **
55 
*REF_SPECIES-RAILE_STUMP_DOB_B1,,** No join mapping for *REF_SPECIES-RAILE_STUMP_DOB_B1 **
56 
*REF_SPECIES-SFTWD_HRDWD,,** No join mapping for *REF_SPECIES-SFTWD_HRDWD **
57 
*REF_SPECIES-SITETREE,,** No join mapping for *REF_SPECIES-SITETREE **
58 
*REF_SPECIES-SPECIES,,** No join mapping for *REF_SPECIES-SPECIES **
59 
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO1,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO1 **
60 
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO2,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO2 **
61 
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO3,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO3 **
62 
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO4,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO4 **
63 
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO5,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO5 **
64 
*REF_SPECIES-STOCKING_SPGRPCD,,** No join mapping for *REF_SPECIES-STOCKING_SPGRPCD **
65 
*REF_SPECIES-ST_EXISTS_IN_NCRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_NCRS **
66 
*REF_SPECIES-ST_EXISTS_IN_NERS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_NERS **
67 
*REF_SPECIES-ST_EXISTS_IN_PNWRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_PNWRS **
68 
*REF_SPECIES-ST_EXISTS_IN_RMRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_RMRS **
69 
*REF_SPECIES-ST_EXISTS_IN_SRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_SRS **
70 
*REF_SPECIES-SUBSPECIES,,** No join mapping for *REF_SPECIES-SUBSPECIES **
71 
*REF_SPECIES-VARIETY,,** No join mapping for *REF_SPECIES-VARIETY **
72 
*REF_SPECIES-WEST,,** No join mapping for *REF_SPECIES-WEST **
73 
*REF_SPECIES-WOODLAND,,** No join mapping for *REF_SPECIES-WOODLAND **
74 
*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT **
75 
*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT_CIT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT_CIT **
76 
*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT **
77 
*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT_CIT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT_CIT **
78 
*REF_SPECIES-W_SPGRPCD,,** No join mapping for *REF_SPECIES-W_SPGRPCD **
79 
*REF_SPECIES-row_num,,** No join mapping for *REF_SPECIES-row_num **
80 
*SPCD,,** No join mapping for *SPCD **
inputs/FIA/TREE/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>FIA</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <parent_id><location><authorlocationcode>$locationName</authorlocationcode></location></parent_id>
11 
                        <authorlocationcode>$subplot</authorlocationcode>
12 
                        <locationevent>
13 
                            <parent_id>
14 
                                <locationevent>
15 
                                    <location_id>
16 
                                        <location>
17 
                                            <authorlocationcode>
18 
                                                <_if name="if subplot">
19 
                                                    <cond>$subplot</cond>
20 
                                                    <then>$locationName</then>
21 
                                                </_if>
22 
                                            </authorlocationcode>
23 
                                        </location>
24 
                                    </location_id>
25 
                                    <authoreventcode>$authorEventCode</authoreventcode>
26 
                                </locationevent>
27 
                            </parent_id>
28 
                            <taxonoccurrence>
29 
                                <aggregateoccurrence>
30 
                                    <plantobservation>
31 
                                        <authorplantcode>$individualCode</authorplantcode>
32 
                                        <sourceaccessioncode>$individualObservationID</sourceaccessioncode>
33 
                                        <stemobservation>
34 
                                            <diameterbreastheight_m><_in_to_m><value>$diameterBreastHeight_in</value></_in_to_m></diameterbreastheight_m>
35 
                                            <height_m><_ft_to_m><value>$height_ft</value></_ft_to_m></height_m>
36 
                                        </stemobservation>
37 
                                    </plantobservation>
38 
                                </aggregateoccurrence>
39 
                                <authortaxoncode>$individualCode</authortaxoncode>
40 
                                <sourceaccessioncode>$individualObservationID</sourceaccessioncode>
41 
                            </taxonoccurrence>
42 
                        </locationevent>
43 
                    </location>
44 
                </path>
45 
            </_simplifyPath>
46 
        </path>
47 
    </_setDefault>
48 
</VegBIEN>
49 
Inserted 13 new rows into database
inputs/FIA/TREE/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2 
subplot,"/location/_if[@name=""if subplot""]/cond/_exists",
3 
locationName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
4 
authorEventCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",
5 
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 
subplot,/location/authorlocationcode,
7 
individualObservationID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
8 
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
9 
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
10 
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
11 
subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/2",
12 
locationName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
13 
subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/2",
14 
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authoreventcode",
15 
individualCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,
16 
individualObservationID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode/_first/1,
17 
diameterBreastHeight_in,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_in_to_m/value,
18 
height_ft,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m/_ft_to_m/value,
19 
authorEventCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
20 
locationName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
21 
individualObservationID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_if[@name=""if individual""]/cond/_exists",
22 
individualCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/1",
23 
individualObservationID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
24 
individualObservationID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else/_first/1",
25 
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
26 
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
27 
*BOLEHT,,** No join mapping for *BOLEHT **
28 
*COUNTYCD,,** No join mapping for *COUNTYCD **
29 
*INVYR,,** No join mapping for *INVYR **
30 
*SPCD,,** No join mapping for *SPCD **
31 
*STATECD,,** No join mapping for *STATECD **
32 
*TREE-ACTUALHT,,** No join mapping for *TREE-ACTUALHT **
33 
*TREE-AGENTCD,,** No join mapping for *TREE-AGENTCD **
34 
*TREE-AZIMUTH,,** No join mapping for *TREE-AZIMUTH **
35 
*TREE-BFSND,,** No join mapping for *TREE-BFSND **
36 
*TREE-BHAGE,,** No join mapping for *TREE-BHAGE **
37 
*TREE-BORED_CD_PNWRS,,** No join mapping for *TREE-BORED_CD_PNWRS **
38 
*TREE-CARBON_AG,,** No join mapping for *TREE-CARBON_AG **
39 
*TREE-CARBON_BG,,** No join mapping for *TREE-CARBON_BG **
40 
*TREE-CCLCD,,** No join mapping for *TREE-CCLCD **
41 
*TREE-CDENCD,,** No join mapping for *TREE-CDENCD **
42 
*TREE-CDIEBKCD,,** No join mapping for *TREE-CDIEBKCD **
43 
*TREE-CFSND,,** No join mapping for *TREE-CFSND **
44 
*TREE-CLIGHTCD,,** No join mapping for *TREE-CLIGHTCD **
45 
*TREE-CPOSCD,,** No join mapping for *TREE-CPOSCD **
46 
*TREE-CR,,** No join mapping for *TREE-CR **
47 
*TREE-CREATED_BY,,** No join mapping for *TREE-CREATED_BY **
48 
*TREE-CREATED_DATE,,** No join mapping for *TREE-CREATED_DATE **
49 
*TREE-CREATED_IN_INSTANCE,,** No join mapping for *TREE-CREATED_IN_INSTANCE **
50 
*TREE-CULL,,** No join mapping for *TREE-CULL **
51 
*TREE-CULLBF,,** No join mapping for *TREE-CULLBF **
52 
*TREE-CULLCF,,** No join mapping for *TREE-CULLCF **
53 
*TREE-CULLDEAD,,** No join mapping for *TREE-CULLDEAD **
54 
*TREE-CULLFORM,,** No join mapping for *TREE-CULLFORM **
55 
*TREE-CULLMSTOP,,** No join mapping for *TREE-CULLMSTOP **
56 
*TREE-CULL_FLD,,** No join mapping for *TREE-CULL_FLD **
57 
*TREE-CVIGORCD,,** No join mapping for *TREE-CVIGORCD **
58 
*TREE-CYCLE,,** No join mapping for *TREE-CYCLE **
59 
*TREE-DAMLOC1,,** No join mapping for *TREE-DAMLOC1 **
60 
*TREE-DAMLOC1_PNWRS,,** No join mapping for *TREE-DAMLOC1_PNWRS **
61 
*TREE-DAMLOC2,,** No join mapping for *TREE-DAMLOC2 **
62 
*TREE-DAMLOC2_PNWRS,,** No join mapping for *TREE-DAMLOC2_PNWRS **
63 
*TREE-DAMSEV1,,** No join mapping for *TREE-DAMSEV1 **
64 
*TREE-DAMSEV2,,** No join mapping for *TREE-DAMSEV2 **
65 
*TREE-DAMTYP1,,** No join mapping for *TREE-DAMTYP1 **
66 
*TREE-DAMTYP2,,** No join mapping for *TREE-DAMTYP2 **
67 
*TREE-DECAYCD,,** No join mapping for *TREE-DECAYCD **
68 
*TREE-DIACALC,,** No join mapping for *TREE-DIACALC **
69 
*TREE-DIACHECK,,** No join mapping for *TREE-DIACHECK **
70 
*TREE-DIACHECK_PNWRS,,** No join mapping for *TREE-DIACHECK_PNWRS **
71 
*TREE-DIAHTCD,,** No join mapping for *TREE-DIAHTCD **
72 
*TREE-DIEBACK_SEVERITY_SRS,,** No join mapping for *TREE-DIEBACK_SEVERITY_SRS **
73 
*TREE-DISEASE_SRS,,** No join mapping for *TREE-DISEASE_SRS **
74 
*TREE-DIST,,** No join mapping for *TREE-DIST **
75 
*TREE-DMG_AGENT1_CD_PNWRS,,** No join mapping for *TREE-DMG_AGENT1_CD_PNWRS **
76 
*TREE-DMG_AGENT2_CD_PNWRS,,** No join mapping for *TREE-DMG_AGENT2_CD_PNWRS **
77 
*TREE-DMG_AGENT3_CD_PNWRS,,** No join mapping for *TREE-DMG_AGENT3_CD_PNWRS **
78 
*TREE-DRYBIO_BG,,** No join mapping for *TREE-DRYBIO_BG **
79 
*TREE-DRYBIO_BOLE,,** No join mapping for *TREE-DRYBIO_BOLE **
80 
*TREE-DRYBIO_SAPLING,,** No join mapping for *TREE-DRYBIO_SAPLING **
81 
*TREE-DRYBIO_STUMP,,** No join mapping for *TREE-DRYBIO_STUMP **
82 
*TREE-DRYBIO_TOP,,** No join mapping for *TREE-DRYBIO_TOP **
83 
*TREE-DRYBIO_WDLD_SPP,,** No join mapping for *TREE-DRYBIO_WDLD_SPP **
84 
*TREE-FGROWBFSL,,** No join mapping for *TREE-FGROWBFSL **
85 
*TREE-FGROWCFAL,,** No join mapping for *TREE-FGROWCFAL **
86 
*TREE-FGROWCFGS,,** No join mapping for *TREE-FGROWCFGS **
87 
*TREE-FMORTBFSL,,** No join mapping for *TREE-FMORTBFSL **
88 
*TREE-FMORTCFAL,,** No join mapping for *TREE-FMORTCFAL **
89 
*TREE-FMORTCFGS,,** No join mapping for *TREE-FMORTCFGS **
90 
*TREE-FORMCL,,** No join mapping for *TREE-FORMCL **
91 
*TREE-FREMVBFSL,,** No join mapping for *TREE-FREMVBFSL **
92 
*TREE-FREMVCFAL,,** No join mapping for *TREE-FREMVCFAL **
93 
*TREE-FREMVCFGS,,** No join mapping for *TREE-FREMVCFGS **
94 
*TREE-GROWBFSL,,** No join mapping for *TREE-GROWBFSL **
95 
*TREE-GROWCFAL,,** No join mapping for *TREE-GROWCFAL **
96 
*TREE-GROWCFGS,,** No join mapping for *TREE-GROWCFGS **
97 
*TREE-HRDWD_CLUMP_CD,,** No join mapping for *TREE-HRDWD_CLUMP_CD **
98 
*TREE-HTCALC,,** No join mapping for *TREE-HTCALC **
99 
*TREE-HTCD,,** No join mapping for *TREE-HTCD **
100 
*TREE-HTDMP,,** No join mapping for *TREE-HTDMP **
101 
*TREE-MIST_CL_CD,,** No join mapping for *TREE-MIST_CL_CD **
102 
*TREE-MIST_CL_CD_PNWRS,,** No join mapping for *TREE-MIST_CL_CD_PNWRS **
103 
*TREE-MODIFIED_BY,,** No join mapping for *TREE-MODIFIED_BY **
104 
*TREE-MODIFIED_DATE,,** No join mapping for *TREE-MODIFIED_DATE **
105 
*TREE-MODIFIED_IN_INSTANCE,,** No join mapping for *TREE-MODIFIED_IN_INSTANCE **
106 
*TREE-MORTBFSL,,** No join mapping for *TREE-MORTBFSL **
107 
*TREE-MORTCD,,** No join mapping for *TREE-MORTCD **
108 
*TREE-MORTCFAL,,** No join mapping for *TREE-MORTCFAL **
109 
*TREE-MORTCFGS,,** No join mapping for *TREE-MORTCFGS **
110 
*TREE-MORTYR,,** No join mapping for *TREE-MORTYR **
111 
*TREE-P2A_GRM_FLG,,** No join mapping for *TREE-P2A_GRM_FLG **
112 
*TREE-PLT_CN,,** No join mapping for *TREE-PLT_CN **
113 
*TREE-PREVCOND,,** No join mapping for *TREE-PREVCOND **
114 
*TREE-PREVDIA,,** No join mapping for *TREE-PREVDIA **
115 
*TREE-PREV_PNTN_SRS,,** No join mapping for *TREE-PREV_PNTN_SRS **
116 
*TREE-PREV_STATUS_CD,,** No join mapping for *TREE-PREV_STATUS_CD **
117 
*TREE-PREV_TRE_CN,,** No join mapping for *TREE-PREV_TRE_CN **
118 
*TREE-PREV_WDLDSTEM,,** No join mapping for *TREE-PREV_WDLDSTEM **
119 
*TREE-RECONCILECD,,** No join mapping for *TREE-RECONCILECD **
120 
*TREE-REMVBFSL,,** No join mapping for *TREE-REMVBFSL **
121 
*TREE-REMVCFAL,,** No join mapping for *TREE-REMVCFAL **
122 
*TREE-REMVCFGS,,** No join mapping for *TREE-REMVCFGS **
123 
*TREE-ROUGHCULL,,** No join mapping for *TREE-ROUGHCULL **
124 
*TREE-SALVCD,,** No join mapping for *TREE-SALVCD **
125 
*TREE-SAWHT,,** No join mapping for *TREE-SAWHT **
126 
*TREE-SEVERITY1A_CD_PNWRS,,** No join mapping for *TREE-SEVERITY1A_CD_PNWRS **
127 
*TREE-SEVERITY1B_CD_PNWRS,,** No join mapping for *TREE-SEVERITY1B_CD_PNWRS **
128 
*TREE-SEVERITY1_CD_PNWRS,,** No join mapping for *TREE-SEVERITY1_CD_PNWRS **
129 
*TREE-SEVERITY2A_CD_PNWRS,,** No join mapping for *TREE-SEVERITY2A_CD_PNWRS **
130 
*TREE-SEVERITY2B_CD_PNWRS,,** No join mapping for *TREE-SEVERITY2B_CD_PNWRS **
131 
*TREE-SEVERITY2_CD_PNWRS,,** No join mapping for *TREE-SEVERITY2_CD_PNWRS **
132 
*TREE-SEVERITY3_CD_PNWRS,,** No join mapping for *TREE-SEVERITY3_CD_PNWRS **
133 
*TREE-SITREE,,** No join mapping for *TREE-SITREE **
134 
*TREE-SPGRPCD,,** No join mapping for *TREE-SPGRPCD **
135 
*TREE-STANDING_DEAD_CD,,** No join mapping for *TREE-STANDING_DEAD_CD **
136 
*TREE-STATUSCD,,** No join mapping for *TREE-STATUSCD **
137 
*TREE-STOCKING,,** No join mapping for *TREE-STOCKING **
138 
*TREE-SUBCYCLE,,** No join mapping for *TREE-SUBCYCLE **
139 
*TREE-TOTAGE,,** No join mapping for *TREE-TOTAGE **
140 
*TREE-TPAGROW_UNADJ,,** No join mapping for *TREE-TPAGROW_UNADJ **
141 
*TREE-TPAMORT_UNADJ,,** No join mapping for *TREE-TPAMORT_UNADJ **
142 
*TREE-TPAREMV_UNADJ,,** No join mapping for *TREE-TPAREMV_UNADJ **
143 
*TREE-TPA_UNADJ,,** No join mapping for *TREE-TPA_UNADJ **
144 
*TREE-TRANSCD,,** No join mapping for *TREE-TRANSCD **
145 
*TREE-TREECLCD,,** No join mapping for *TREE-TREECLCD **
146 
*TREE-TREECLCD_NCRS,,** No join mapping for *TREE-TREECLCD_NCRS **
147 
*TREE-TREECLCD_NERS,,** No join mapping for *TREE-TREECLCD_NERS **
148 
*TREE-TREECLCD_RMRS,,** No join mapping for *TREE-TREECLCD_RMRS **
149 
*TREE-TREECLCD_SRS,,** No join mapping for *TREE-TREECLCD_SRS **
150 
*TREE-TREEGRCD,,** No join mapping for *TREE-TREEGRCD **
151 
*TREE-TREEHISTCD,,** No join mapping for *TREE-TREEHISTCD **
152 
*TREE-UNCRCD,,** No join mapping for *TREE-UNCRCD **
153 
*TREE-UNKNOWN_DAMTYP1_PNWRS,,** No join mapping for *TREE-UNKNOWN_DAMTYP1_PNWRS **
154 
*TREE-UNKNOWN_DAMTYP2_PNWRS,,** No join mapping for *TREE-UNKNOWN_DAMTYP2_PNWRS **
155 
*TREE-VOLBFGRS,,** No join mapping for *TREE-VOLBFGRS **
156 
*TREE-VOLBFNET,,** No join mapping for *TREE-VOLBFNET **
157 
*TREE-VOLCFGRS,,** No join mapping for *TREE-VOLCFGRS **
158 
*TREE-VOLCFNET,,** No join mapping for *TREE-VOLCFNET **
159 
*TREE-VOLCFSND,,** No join mapping for *TREE-VOLCFSND **
160 
*TREE-VOLCSGRS,,** No join mapping for *TREE-VOLCSGRS **
161 
*TREE-VOLCSNET,,** No join mapping for *TREE-VOLCSNET **
162 
*TREE-WDLDSTEM,,** No join mapping for *TREE-WDLDSTEM **
163 
*TREE-row_num,,** No join mapping for *TREE-row_num **
164 
*UNITCD,,** No join mapping for *UNITCD **
inputs/FIA/REF_HABTYP_DESCRIPTION/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>FIA</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <locationevent>
11 
                            <commclass>
12 
                                <commdetermination>
13 
                                    <commconcept_id>
14 
                                        <commconcept>
15 
                                            <commname_id><commname><commname>$communityID</commname></commname></commname_id>
16 
                                            <commdescription>$communityName</commdescription>
17 
                                        </commconcept>
18 
                                    </commconcept_id>
19 
                                </commdetermination>
20 
                            </commclass>
21 
                        </locationevent>
22 
                    </location>
23 
                </path>
24 
            </_simplifyPath>
25 
        </path>
26 
    </_setDefault>
27 
</VegBIEN>
28 
Inserted 5 new rows into database
inputs/FIA/REF_HABTYP_DESCRIPTION/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2 
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
3 
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
4 
*HABTYPCD,,** No join mapping for *HABTYPCD **
5 
*HABTYP_PUB_CD,,** No join mapping for *HABTYP_PUB_CD **
6 
*REF_HABTYP_DESCRIPTION-CREATED_BY,,** No join mapping for *REF_HABTYP_DESCRIPTION-CREATED_BY **
7 
*REF_HABTYP_DESCRIPTION-CREATED_DATE,,** No join mapping for *REF_HABTYP_DESCRIPTION-CREATED_DATE **
8 
*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,,** No join mapping for *REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE **
9 
*REF_HABTYP_DESCRIPTION-MODIFIED_BY,,** No join mapping for *REF_HABTYP_DESCRIPTION-MODIFIED_BY **
10 
*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,,** No join mapping for *REF_HABTYP_DESCRIPTION-MODIFIED_DATE **
11 
*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE **
12 
*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,,** No join mapping for *REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME **
13 
*REF_HABTYP_DESCRIPTION-VALID,,** No join mapping for *REF_HABTYP_DESCRIPTION-VALID **
14 
*REF_HABTYP_DESCRIPTION-row_num,,** No join mapping for *REF_HABTYP_DESCRIPTION-row_num **
inputs/FIA/SUBPLOT/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>FIA</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <parent_id><location><authorlocationcode>$locationName</authorlocationcode></location></parent_id>
11 
                        <authorlocationcode>$subplot</authorlocationcode>
12 
                        <sourceaccessioncode>$subplotID</sourceaccessioncode>
13 
                    </location>
14 
                </path>
15 
            </_simplifyPath>
16 
        </path>
17 
    </_setDefault>
18 
</VegBIEN>
19 
Inserted 4 new rows into database
inputs/FIA/SUBPLOT/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2 
subplot,"/location/_if[@name=""if subplot""]/cond/_exists",
3 
subplotID,"/location/_if[@name=""if subplot""]/cond/_exists",
4 
locationName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
5 
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 
subplot,/location/authorlocationcode,
7 
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
8 
subplotID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
9 
subplotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/1",
10 
subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/2",
11 
locationName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
12 
subplotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/1",
13 
subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/2",
14 
locationName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
15 
subplotID,/location/sourceaccessioncode/_first/1,
16 
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
17 
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
18 
*COUNTYCD,,** No join mapping for *COUNTYCD **
19 
*INVYR,,** No join mapping for *INVYR **
20 
*STATECD,,** No join mapping for *STATECD **
21 
*SUBPLOT-ASPECT,,** No join mapping for *SUBPLOT-ASPECT **
22 
*SUBPLOT-CONDLIST,,** No join mapping for *SUBPLOT-CONDLIST **
23 
*SUBPLOT-CREATED_BY,,** No join mapping for *SUBPLOT-CREATED_BY **
24 
*SUBPLOT-CREATED_DATE,,** No join mapping for *SUBPLOT-CREATED_DATE **
25 
*SUBPLOT-CREATED_IN_INSTANCE,,** No join mapping for *SUBPLOT-CREATED_IN_INSTANCE **
26 
*SUBPLOT-CYCLE,,** No join mapping for *SUBPLOT-CYCLE **
27 
*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD **
28 
*SUBPLOT-INVASIVE_SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-INVASIVE_SUBP_STATUS_CD **
29 
*SUBPLOT-MACRCOND,,** No join mapping for *SUBPLOT-MACRCOND **
30 
*SUBPLOT-MICRCOND,,** No join mapping for *SUBPLOT-MICRCOND **
31 
*SUBPLOT-MODIFIED_BY,,** No join mapping for *SUBPLOT-MODIFIED_BY **
32 
*SUBPLOT-MODIFIED_DATE,,** No join mapping for *SUBPLOT-MODIFIED_DATE **
33 
*SUBPLOT-MODIFIED_IN_INSTANCE,,** No join mapping for *SUBPLOT-MODIFIED_IN_INSTANCE **
34 
*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD **
35 
*SUBPLOT-NF_SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-NF_SUBP_STATUS_CD **
36 
*SUBPLOT-P2A_GRM_FLG,,** No join mapping for *SUBPLOT-P2A_GRM_FLG **
37 
*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD **
38 
*SUBPLOT-P2VEG_SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-P2VEG_SUBP_STATUS_CD **
39 
*SUBPLOT-PLT_CN,,** No join mapping for *SUBPLOT-PLT_CN **
40 
*SUBPLOT-POINT_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-POINT_NONSAMPLE_REASN_CD **
41 
*SUBPLOT-PREV_SBP_CN,,** No join mapping for *SUBPLOT-PREV_SBP_CN **
42 
*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS,,** No join mapping for *SUBPLOT-ROOT_DIS_SEV_CD_PNWRS **
43 
*SUBPLOT-SLOPE,,** No join mapping for *SUBPLOT-SLOPE **
44 
*SUBPLOT-SUBCYCLE,,** No join mapping for *SUBPLOT-SUBCYCLE **
45 
*SUBPLOT-SUBPCOND,,** No join mapping for *SUBPLOT-SUBPCOND **
46 
*SUBPLOT-SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-SUBP_STATUS_CD **
47 
*SUBPLOT-WATERDEP,,** No join mapping for *SUBPLOT-WATERDEP **
48 
*SUBPLOT-row_num,,** No join mapping for *SUBPLOT-row_num **
49 
*UNITCD,,** No join mapping for *UNITCD **
inputs/FIA/REF_RESEARCH_STATION/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>FIA</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <locationplace>
11 
                            <place_id>
12 
                                <place>
13 
                                    <matched_place_id>
14 
                                        <place>
15 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
16 
                                            <stateprovince>$stateProvince</stateprovince>
17 
                                        </place>
18 
                                    </matched_place_id>
19 
                                    <stateprovince>$stateProvince</stateprovince>
20 
                                </place>
21 
                            </place_id>
22 
                        </locationplace>
23 
                    </location>
24 
                </path>
25 
            </_simplifyPath>
26 
        </path>
27 
    </_setDefault>
28 
</VegBIEN>
29 
Inserted 6 new rows into database
inputs/FIA/REF_RESEARCH_STATION/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2 
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
3 
stateProvince,/location/locationplace/*_id/place/stateprovince,
4 
*REF_RESEARCH_STATION-CREATED_BY,,** No join mapping for *REF_RESEARCH_STATION-CREATED_BY **
5 
*REF_RESEARCH_STATION-CREATED_DATE,,** No join mapping for *REF_RESEARCH_STATION-CREATED_DATE **
6 
*REF_RESEARCH_STATION-CREATED_IN_INSTANCE,,** No join mapping for *REF_RESEARCH_STATION-CREATED_IN_INSTANCE **
7 
*REF_RESEARCH_STATION-MODIFIED_BY,,** No join mapping for *REF_RESEARCH_STATION-MODIFIED_BY **
8 
*REF_RESEARCH_STATION-MODIFIED_DATE,,** No join mapping for *REF_RESEARCH_STATION-MODIFIED_DATE **
9 
*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE **
10 
*REF_RESEARCH_STATION-RS,,** No join mapping for *REF_RESEARCH_STATION-RS **
11 
*REF_RESEARCH_STATION-RSCD,,** No join mapping for *REF_RESEARCH_STATION-RSCD **
12 
*REF_RESEARCH_STATION-STATE_ABBR,,** No join mapping for *REF_RESEARCH_STATION-STATE_ABBR **
13 
*REF_RESEARCH_STATION-row_num,,** No join mapping for *REF_RESEARCH_STATION-row_num **
14 
*STATECD,,** No join mapping for *STATECD **

Also available in: Unified diff