Project

General

Profile

« Previous | Next » 

Revision 6403

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>VegBank</shortname></source></value>
5 6
        <path>
6
            <location>
7
                <sourceaccessioncode>$plot_id</sourceaccessioncode>
8
                <locationevent>
9
                    <method_id><method><name>$methodnarrative</name></method></method_id>
10
                    <project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id>
11
                    <authoreventcode>$authorobscode</authoreventcode>
12
                    <sourceaccessioncode>$observation_id</sourceaccessioncode>
13
                    <obsenddate>$obsenddate</obsenddate>
14
                    <obsstartdate>$obsstartdate</obsstartdate>
15
                    <soilobs>
16
                        <basesaturation_fraction><_percent_to_fraction><value>$basesaturation</value></_percent_to_fraction></basesaturation_fraction>
17
                        <cationexchangecapacity_cmol_kg>$exchangecapacity</cationexchangecapacity_cmol_kg>
18
                        <clay_fraction><_percent_to_fraction><value>$soilclay</value></_percent_to_fraction></clay_fraction>
19
                        <organic_fraction><_percent_to_fraction><value>$soilorganic</value></_percent_to_fraction></organic_fraction>
20
                        <ph>$soilph</ph>
21
                        <sand_fraction><_percent_to_fraction><value>$soilsand</value></_percent_to_fraction></sand_fraction>
22
                        <silt_fraction><_percent_to_fraction><value>$soilsilt</value></_percent_to_fraction></silt_fraction>
23
                        <texture>$soiltexture</texture>
24
                    </soilobs>
25
                </locationevent>
26
            </location>
7
            <_simplifyPath>
8
                <next>parent_id</next>
9
                <path>
10
                    <location>
11
                        <sourceaccessioncode>$plot_id</sourceaccessioncode>
12
                        <locationevent>
13
                            <method_id><method><name>$methodnarrative</name></method></method_id>
14
                            <project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id>
15
                            <authoreventcode>$authorobscode</authoreventcode>
16
                            <sourceaccessioncode>$observation_id</sourceaccessioncode>
17
                            <obsenddate>$obsenddate</obsenddate>
18
                            <obsstartdate>$obsstartdate</obsstartdate>
19
                            <soilobs>
20
                                <basesaturation_fraction><_percent_to_fraction><value>$basesaturation</value></_percent_to_fraction></basesaturation_fraction>
21
                                <cationexchangecapacity_cmol_kg>$exchangecapacity</cationexchangecapacity_cmol_kg>
22
                                <clay_fraction><_percent_to_fraction><value>$soilclay</value></_percent_to_fraction></clay_fraction>
23
                                <organic_fraction><_percent_to_fraction><value>$soilorganic</value></_percent_to_fraction></organic_fraction>
24
                                <ph>$soilph</ph>
25
                                <sand_fraction><_percent_to_fraction><value>$soilsand</value></_percent_to_fraction></sand_fraction>
26
                                <silt_fraction><_percent_to_fraction><value>$soilsilt</value></_percent_to_fraction></silt_fraction>
27
                                <texture>$soiltexture</texture>
28
                            </soilobs>
29
                        </locationevent>
30
                    </location>
31
                </path>
32
            </_simplifyPath>
27 33
        </path>
28
    </_simplifyPath>
34
    </_setDefault>
29 35
</VegBIEN>
30 36
Inserted 10 new rows into database

Also available in: Unified diff