Project

General

Profile

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
                        <sourceaccessioncode>$locationID</sourceaccessioncode>
11
                        <locationevent>
12
                            <method_id><method><name>$samplingProtocol</name></method></method_id>
13
                            <project_id><project><sourceaccessioncode>$projectID</sourceaccessioncode></project></project_id>
14
                            <authoreventcode>$authorEventCode</authoreventcode>
15
                            <sourceaccessioncode>$eventID</sourceaccessioncode>
16
                            <locationevent fkey="parent_id"><sourceaccessioncode>$eventID</sourceaccessioncode></locationevent>
17
                            <obsenddate>$endDate</obsenddate>
18
                            <obsstartdate>$startDate</obsstartdate>
19
                            <soilsample>
20
                                <basesaturation_fraction><_percent_to_fraction><value>$baseSaturation_percent</value></_percent_to_fraction></basesaturation_fraction>
21
                                <cationexchangecapacity_cmol_kg>$cationExchangeCapacity_cmol_kg</cationexchangecapacity_cmol_kg>
22
                                <clay_fraction><_percent_to_fraction><value>$clay_percent</value></_percent_to_fraction></clay_fraction>
23
                                <organic_fraction><_percent_to_fraction><value>$organic_percent</value></_percent_to_fraction></organic_fraction>
24
                                <ph>$ph</ph>
25
                                <sand_fraction><_percent_to_fraction><value>$sand_percent</value></_percent_to_fraction></sand_fraction>
26
                                <silt_fraction><_percent_to_fraction><value>$silt_percent</value></_percent_to_fraction></silt_fraction>
27
                                <texture>$texture</texture>
28
                            </soilsample>
29
                        </locationevent>
30
                    </location>
31
                </path>
32
            </_simplifyPath>
33
        </path>
34
    </_setDefault>
35
</VegBIEN>
36
Inserted 8 new rows into database
(10-10/11)