Put template:

<VegBIEN>

    <location id="-1">

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

            <obsstartdate><_date><date><_dateRangeStart><value>$obsstartdate</value></_dateRangeStart></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>

</VegBIEN>

Inserted 9 new rows into database