Put template:

<VegBIEN>

        <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>$basesaturation</basesaturation>

                        <cationexchangecapacity>$exchangecapacity</cationexchangecapacity>

                        <clay>$soilclay</clay>

                        <organic>$soilorganic</organic>

                        <ph>$soilph</ph>

                        <sand>$soilsand</sand>

                        <silt>$soilsilt</silt>

                        <texture>$soiltexture</texture>

                    </soilobs>

                </locationevent>

            </location>

        </path>

    </_simplifyPath>

Inserted 9 new rows into database