Put template:

<VegBIEN>

        <col>source_id</col>

        <value><source><shortname>VegBank</shortname></source></value>

                <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>