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><_date><date>$obsenddate</date></_date></obsenddate>

                    <obsstartdate><_date><date>$obsstartdate</date></_date></obsstartdate>

                    <soilobs>

                        <basesaturation_fraction>$basesaturation</basesaturation_fraction>

                        <cationexchangecapacity_cmol_kg>$exchangecapacity</cationexchangecapacity_cmol_kg>

                        <clay_fraction>$soilclay</clay_fraction>

                        <organic_fraction>$soilorganic</organic_fraction>

                        <ph>$soilph</ph>

                        <sand_fraction>$soilsand</sand_fraction>

                        <silt_fraction>$soilsilt</silt_fraction>

                        <texture>$soiltexture</texture>

                    </soilobs>

                </locationevent>

            </location>

        </path>

    </_simplifyPath>

</VegBIEN>

Inserted 9 new rows into database