Project

General

Profile

« Previous | Next » 

Revision 6403

Added by Aaron Marcuse-Kubitza over 11 years ago

mappings/VegCore-VegBIEN.csv: Set the source_id col_default to the datasource name using the new _setDefault() built-in function and _env()

View differences:

test.xml.ref
1 1 
Put template:
2 2 
<VegBIEN>
3 
    <_simplifyPath id="-1">
4 
        <next>parent_id</next>
3 
    <_setDefault id="-1">
4 
        <col>source_id</col>
5 
        <value><source><shortname>SALVIAS</shortname></source></value>
5 6 
        <path>
6 
            <location>
7 
                <locationevent>
8 
                    <taxonoccurrence>
9 
                        <aggregateoccurrence>
10 
                            <plantobservation>
7 
            <_simplifyPath>
8 
                <next>parent_id</next>
9 
                <path>
10 
                    <location>
11 
                        <locationevent>
12 
                            <taxonoccurrence>
13 
                                <aggregateoccurrence>
14 
                                    <plantobservation>
15 
                                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
16 
                                        <stemcount>$NoInd</stemcount>
17 
                                        <stemobservation>
18 
                                            <basaldiameter_m>$basal_diam</basaldiameter_m>
19 
                                            <definedvalue fkey="tablerecord_id">
20 
                                                <userdefined_id>
21 
                                                    <userdefined>
22 
                                                        <tablename>stemobservation</tablename>
23 
                                                        <userdefinedname>canopyForm</userdefinedname>
24 
                                                    </userdefined>
25 
                                                </userdefined_id>
26 
                                                <definedvalue>$stem_canopy_form</definedvalue>
27 
                                            </definedvalue>
28 
                                            <definedvalue fkey="tablerecord_id">
29 
                                                <userdefined_id>
30 
                                                    <userdefined>
31 
                                                        <tablename>stemobservation</tablename>
32 
                                                        <userdefinedname>canopyPosition</userdefinedname>
33 
                                                    </userdefined>
34 
                                                </userdefined_id>
35 
                                                <definedvalue>$stem_canopy_position</definedvalue>
36 
                                            </definedvalue>
37 
                                            <definedvalue fkey="tablerecord_id">
38 
                                                <userdefined_id>
39 
                                                    <userdefined>
40 
                                                        <tablename>stemobservation</tablename>
41 
                                                        <userdefinedname>gentryDiameter</userdefinedname>
42 
                                                    </userdefined>
43 
                                                </userdefined_id>
44 
                                                <definedvalue>$gentry_dbh</definedvalue>
45 
                                            </definedvalue>
46 
                                            <definedvalue fkey="tablerecord_id">
47 
                                                <userdefined_id>
48 
                                                    <userdefined>
49 
                                                        <tablename>stemobservation</tablename>
50 
                                                        <userdefinedname>lianaInfestation</userdefinedname>
51 
                                                    </userdefined>
52 
                                                </userdefined_id>
53 
                                                <definedvalue>$stem_liana_infestation</definedvalue>
54 
                                            </definedvalue>
55 
                                            <definedvalue fkey="tablerecord_id">
56 
                                                <userdefined_id>
57 
                                                    <userdefined>
58 
                                                        <tablename>stemobservation</tablename>
59 
                                                        <userdefinedname>notes</userdefinedname>
60 
                                                    </userdefined>
61 
                                                </userdefined_id>
62 
                                                <definedvalue>$stem_notes</definedvalue>
63 
                                            </definedvalue>
64 
                                            <diameterbreastheight_m><_cm_to_m><value>$stem_dbh</value></_cm_to_m></diameterbreastheight_m>
65 
                                            <height_m>$stem_height_m</height_m>
66 
                                            <heightfirstbranch_m>$stem_height_first_branch_m</heightfirstbranch_m>
67 
                                            <sourceaccessioncode>$stem_id</sourceaccessioncode>
68 
                                            <tag>
69 
                                                <_alt>
70 
                                                    <1>$stem_tag2</1>
71 
                                                    <2>$stem_tag1</2>
72 
                                                </_alt>
73 
                                            </tag>
74 
                                        </stemobservation>
75 
                                    </plantobservation>
76 
                                </aggregateoccurrence>
11 77 
                                <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
12 
                                <stemcount>$NoInd</stemcount>
13 
                                <stemobservation>
14 
                                    <basaldiameter_m>$basal_diam</basaldiameter_m>
15 
                                    <definedvalue fkey="tablerecord_id">
16 
                                        <userdefined_id>
17 
                                            <userdefined>
18 
                                                <tablename>stemobservation</tablename>
19 
                                                <userdefinedname>canopyForm</userdefinedname>
20 
                                            </userdefined>
21 
                                        </userdefined_id>
22 
                                        <definedvalue>$stem_canopy_form</definedvalue>
23 
                                    </definedvalue>
24 
                                    <definedvalue fkey="tablerecord_id">
25 
                                        <userdefined_id>
26 
                                            <userdefined>
27 
                                                <tablename>stemobservation</tablename>
28 
                                                <userdefinedname>canopyPosition</userdefinedname>
29 
                                            </userdefined>
30 
                                        </userdefined_id>
31 
                                        <definedvalue>$stem_canopy_position</definedvalue>
32 
                                    </definedvalue>
33 
                                    <definedvalue fkey="tablerecord_id">
34 
                                        <userdefined_id>
35 
                                            <userdefined>
36 
                                                <tablename>stemobservation</tablename>
37 
                                                <userdefinedname>gentryDiameter</userdefinedname>
38 
                                            </userdefined>
39 
                                        </userdefined_id>
40 
                                        <definedvalue>$gentry_dbh</definedvalue>
41 
                                    </definedvalue>
42 
                                    <definedvalue fkey="tablerecord_id">
43 
                                        <userdefined_id>
44 
                                            <userdefined>
45 
                                                <tablename>stemobservation</tablename>
46 
                                                <userdefinedname>lianaInfestation</userdefinedname>
47 
                                            </userdefined>
48 
                                        </userdefined_id>
49 
                                        <definedvalue>$stem_liana_infestation</definedvalue>
50 
                                    </definedvalue>
51 
                                    <definedvalue fkey="tablerecord_id">
52 
                                        <userdefined_id>
53 
                                            <userdefined>
54 
                                                <tablename>stemobservation</tablename>
55 
                                                <userdefinedname>notes</userdefinedname>
56 
                                            </userdefined>
57 
                                        </userdefined_id>
58 
                                        <definedvalue>$stem_notes</definedvalue>
59 
                                    </definedvalue>
60 
                                    <diameterbreastheight_m><_cm_to_m><value>$stem_dbh</value></_cm_to_m></diameterbreastheight_m>
61 
                                    <height_m>$stem_height_m</height_m>
62 
                                    <heightfirstbranch_m>$stem_height_first_branch_m</heightfirstbranch_m>
63 
                                    <sourceaccessioncode>$stem_id</sourceaccessioncode>
64 
                                    <tag>
65 
                                        <_alt>
66 
                                            <1>$stem_tag2</1>
67 
                                            <2>$stem_tag1</2>
68 
                                        </_alt>
69 
                                    </tag>
70 
                                </stemobservation>
71 
                            </plantobservation>
72 
                        </aggregateoccurrence>
73 
                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
74 
                    </taxonoccurrence>
75 
                </locationevent>
76 
            </location>
78 
                            </taxonoccurrence>
79 
                        </locationevent>
80 
                    </location>
81 
                </path>
82 
            </_simplifyPath>
77 83 
        </path>
78 
    </_simplifyPath>
84 
    </_setDefault>
79 85 
</VegBIEN>
80 86 
Inserted 24 new rows into database

Also available in: Unified diff