Put template:

<VegBIEN>

    <_simplifyPath id="-1">

        <next>parent_id</next>

        <path>

            <location>

                <authorlocationcode>$Inventory name</authorlocationcode>

                <sourceaccessioncode>$Inventory code</sourceaccessioncode>

                <area_m2><_ha_to_m2><value>$Area</value></_ha_to_m2></area_m2>

                <elevation_m>

                    <_alt>

                        <1>$Altitude</1>

                        <2>

                            <_avg>

                                <max><_rangeEnd><value>$Minimum altitude</value></_rangeEnd></max>

                                <min><_rangeStart><value>$Minimum altitude</value></_rangeStart></min>

                            </_avg>

                        </2>

                    </_alt>

                </elevation_m>

                <elevationrange_m>

                    <_range>

                        <from><_rangeStart><value>$Minimum altitude</value></_rangeStart></from>

                        <to><_rangeEnd><value>$Minimum altitude</value></_rangeEnd></to>

                    </_range>

                </elevationrange_m>

                <landform>$Topographical situation</landform>

                <locationevent>

                    <project_id>

                        <project>

                            <projectname>$Expedition name</projectname>

                            <sourceaccessioncode>$Expedition number</sourceaccessioncode>

                        </project>

                    </project_id>

                    <commclass>

                        <commdetermination>

                            <commconcept_id>

                                <commconcept>

                                    <commname_id><commname><commname>$Vegetation type</commname></commname></commname_id>

                                    <commdescription>$Locality description</commdescription>

                                </commconcept>

                            </commconcept_id>

                        </commdetermination>

                    </commclass>

                    <obsenddate><_date><date><_dateRangeEnd><value>$First evaluation</value></_dateRangeEnd></date></_date></obsenddate>

                    <obsstartdate><_date><date><_dateRangeStart><value>$First evaluation</value></_dateRangeStart></date></_date></obsstartdate>

                    <soilobs>

                        <acidity_fraction><_percent_to_fraction><value>$Acidez intercambiable (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</value></_percent_to_fraction></acidity_fraction>

                        <calcium_fraction><_percent_to_fraction><value>$Calcio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.016)</value></_percent_to_fraction></calcium_fraction>

                        <carbon_fraction><_percent_to_fraction><value>$Carb&#243;n Org&#225;nico (WSP S-9,10&#8211;%&#8211;0.06)</value></_percent_to_fraction></carbon_fraction>

                        <cationexchangecapacity_cmol_kg>$CIC (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</cationexchangecapacity_cmol_kg>

                        <clay_fraction><_percent_to_fraction><value>$Arcilla (DIN 18 123&#8211;%&#8211;1)</value></_percent_to_fraction></clay_fraction>

                        <conductivity>$Conductividad electrica (ASPT 6&#8211;&#181;S/cm&#8211; 1 - 10000)</conductivity>

                        <magnesium_fraction><_percent_to_fraction><value>$Magnesio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</value></_percent_to_fraction></magnesium_fraction>

                        <nitrogen_fraction><_percent_to_fraction><value>$Nitr&#243;geno total (ISRIC 6&#8211;%&#8211;0.0014)</value></_percent_to_fraction></nitrogen_fraction>

                        <organic_fraction><_percent_to_fraction><value>$Materia Org&#225;nica (WSP S-9,10&#8211;%&#8211;0.1)</value></_percent_to_fraction></organic_fraction>

                        <ph>$pH acuoso (ISRIC 4&#8211;&#8211; 1 - 14)</ph>

                        <phosphorus_fraction><_percent_to_fraction><value>$F&#243;sforo disponible (ISRIC 14-2&#8211;mg/Kg&#8211;1.5)</value></_percent_to_fraction></phosphorus_fraction>

                        <potassium_fraction><_percent_to_fraction><value>$Potasio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.0053)</value></_percent_to_fraction></potassium_fraction>

                        <sand_fraction><_percent_to_fraction><value>$Arena (DIN 18 123&#8211;%&#8211;2.5)</value></_percent_to_fraction></sand_fraction>

                        <silt_fraction><_percent_to_fraction><value>$Limo (DIN 18 123&#8211;%&#8211;1)</value></_percent_to_fraction></silt_fraction>

                        <sodium_fraction><_percent_to_fraction><value>$Sodio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</value></_percent_to_fraction></sodium_fraction>

                        <texture>$Textural class</texture>

                    </soilobs>

                </locationevent>

                <locationnarrative>$Locality</locationnarrative>

                <locationplace>

                    <place_id>

                        <place>

                            <coordinates_id>

                                <coordinates>

                                    <latitude_deg>

                                        <_nullIf>

                                            <null>0</null>

                                            <type>float</type>

                                            <value>$Latitude</value>

                                        </_nullIf>

                                    </latitude_deg>

                                    <longitude_deg>

                                        <_nullIf>

                                            <null>0</null>

                                            <type>float</type>

                                            <value>$Longitude</value>

                                        </_nullIf>

                                    </longitude_deg>

                                    <verbatimlatitude>$Latitude (DMS)</verbatimlatitude>

                                    <verbatimlongitude>$Longitude (DMS)</verbatimlongitude>

                                </coordinates>

                            </coordinates_id>

                            <matched_place_id>

                                <place>

                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>

                                    <coordinates_id>

                                        <coordinates>

                                            <latitude_deg>$Latitude</latitude_deg>

                                            <longitude_deg>$Longitude</longitude_deg>

                                        </coordinates>

                                    </coordinates_id>

                                </place>

                            </matched_place_id>

                        </place>

                    </place_id>

                </locationplace>

                <notespublic>$Observaciones</notespublic>

                <slopeaspect_deg>

                    <_compass>

                        <value>

                            <_alt>

                                <1>$Direction</1>

                                <2>$Orientaci&#243;n/exposicion</2>

                            </_alt>

                        </value>

                    </_compass>

                </slopeaspect_deg>

                <slopegradient_fraction>$Slope</slopegradient_fraction>

                <verbatimelevation>$Minimum altitude</verbatimelevation>

            </location>

        </path>

    </_simplifyPath>

</VegBIEN>

Inserted 28 new rows into database