Put template:

<VegBIEN>

    <_simplifyPath id="-1">

        <next>parent_id</next>

        <path>

            <location>

                <sourceaccessioncode>$plot_id</sourceaccessioncode>

                <locationevent>

                    <method_id><method><name>$methodnarrative</name></method></method_id>

                    <project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id>

                    <authoreventcode>$authorobscode</authoreventcode>

                    <sourceaccessioncode>$observation_id</sourceaccessioncode>

                    <obsenddate>$obsenddate</obsenddate>

                    <obsstartdate>$obsstartdate</obsstartdate>

                    <soilobs>

                        <basesaturation_fraction><_percent_to_fraction><value>$basesaturation</value></_percent_to_fraction></basesaturation_fraction>

                        <cationexchangecapacity_cmol_kg>$exchangecapacity</cationexchangecapacity_cmol_kg>

                        <clay_fraction><_percent_to_fraction><value>$soilclay</value></_percent_to_fraction></clay_fraction>

                        <organic_fraction><_percent_to_fraction><value>$soilorganic</value></_percent_to_fraction></organic_fraction>

                        <ph>$soilph</ph>

                        <sand_fraction><_percent_to_fraction><value>$soilsand</value></_percent_to_fraction></sand_fraction>

                        <silt_fraction><_percent_to_fraction><value>$soilsilt</value></_percent_to_fraction></silt_fraction>

                        <texture>$soiltexture</texture>

                    </soilobs>

                </locationevent>

            </location>

        </path>

    </_simplifyPath>

</VegBIEN>

Inserted 10 new rows into database