Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>HVAA</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <authorlocationcode>

                            <_alt>

                                <1>$symbiotaId</1>

                                <2>

                                    <_join>

                                        <1>$institutionCode</1>

                                        <2>$collectionCode</2>

                                        <3>$catalogNumber</3>

                                    </_join>

                                </2>

                            </_alt>

                        </authorlocationcode>

                        <accessconditions>$rights</accessconditions>

                        <accesslevel>$accessRights</accesslevel>

                        <elevation_m>

                            <_alt>

                                <1>

                                    <_units>

                                        <to>m</to>

                                        <to></to>

                                        <value>$verbatimElevation</value>

                                    </_units>

                                </1>

                                <2>

                                    <_avg>

                                        <1>$minimumElevationInMeters</1>

                                        <2>$maximumElevationInMeters</2>

                                    </_avg>

                                </2>

                            </_alt>

                        </elevation_m>

                        <iscultivated>

                            <_locationnarrative_is_cultivated>

                                <locationnarrative>

                                    <_join>

                                        <1>$locality</1>

                                        <3>$habitat</3>

                                    </_join>

                                </locationnarrative>

                            </_locationnarrative_is_cultivated>

                        </iscultivated>

                        <locationevent>

                            <method_id><method><name>$samplingProtocol</name></method></method_id>

                            <obsenddate><_dateRangeEnd><value>$eventDate</value></_dateRangeEnd></obsenddate>

                            <obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate>

                            <taxonoccurrence>

                                <aggregateoccurrence>

                                    <count>$individualCount</count>

                                    <notes>

                                        <_merge>

                                            <1>$occurrenceRemarks</1>

                                            <2>$dynamicProperties</2>

                                        </_merge>

                                    </notes>

                                    <plantobservation>

                                        <authorplantcode>

                                            <_alt>

                                                <0>$fieldNumber</0>

                                                <1>$recordNumber</1>

                                            </_alt>

                                        </authorplantcode>

                                        <definedvalue fkey="tablerecord_id">

                                            <userdefined_id>

                                                <userdefined>

                                                    <tablename>plantobservation</tablename>

                                                    <userdefinedname>sex</userdefinedname>

                                                </userdefined>

                                            </userdefined_id>

                                            <definedvalue>$sex</definedvalue>

                                        </definedvalue>

                                        <reproductivecondition>$reproductiveCondition</reproductivecondition>

                                        <specimenreplicate>

                                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>

                                            <collectioncode_dwc>$collectionCode</collectioncode_dwc>

                                            <collectionnumber>

                                                <_alt>

                                                    <0>$fieldNumber</0>

                                                    <1>$recordNumber</1>

                                                </_alt>

                                            </collectionnumber>

                                            <institution_id>

                                                <sourcelist>

                                                    <name>$institutionCode</name>

                                                    <sourcename>

                                                        <name>

                                                            <_split>

                                                                <separator>[,;] *</separator>

                                                                <value>$institutionCode</value>

                                                            </_split>

                                                        </name>

                                                    </sourcename>

                                                </sourcelist>

                                            </institution_id>

                                            <sourceaccessioncode>$symbiotaId</sourceaccessioncode>

                                        </specimenreplicate>

                                    </plantobservation>

                                </aggregateoccurrence>

                                <collector_id><party><fullname>$recordedBy</fullname></party></collector_id>

                                <iscultivated>

                                    <_map>

                                        <cultivated>t</cultivated>

                                        <wild>f</wild>

                                        <*></*>

                                        <value>$establishmentMeans</value>

                                    </_map>

                                </iscultivated>

                                <isnative>

                                    <_map>

                                        <native>t</native>

                                        <exotic>f</exotic>

                                        <*></*>

                                        <value>$establishmentMeans</value>

                                    </_map>

                                </isnative>

                                <sourceaccessioncode>$symbiotaId</sourceaccessioncode>

                                <taxondetermination>

                                    <party_id><party><fullname>$identifiedBy</fullname></party></party_id>

                                    <taxonverbatim_id>

                                        <taxonverbatim>

                                            <taxonlabel_id>

                                                <taxonlabel>

                                                    <parent_id>

                                                        <taxonlabel>

                                                            <rank>$taxonRank</rank>

                                                            <parent_id>

                                                                <taxonlabel>

                                                                    <rank>cultivar</rank>

                                                                    <parent_id>

                                                                        <taxonlabel>

                                                                            <rank>forma</rank>

                                                                            <parent_id>

                                                                                <taxonlabel>

                                                                                    <rank>variety</rank>

                                                                                    <parent_id>

                                                                                        <taxonlabel>

                                                                                            <rank>subspecies</rank>

                                                                                            <parent_id>

                                                                                                <taxonlabel>

                                                                                                    <rank>species</rank>

                                                                                                    <taxonepithet>$specificEpithet</taxonepithet>

                                                                                                    <parent_id>

                                                                                                        <taxonlabel>

                                                                                                            <rank>genus</rank>

                                                                                                            <taxonepithet>$genus</taxonepithet>

                                                                                                            <parent_id>

                                                                                                                <taxonlabel>

                                                                                                                    <rank>family</rank>

                                                                                                                    <taxonepithet>$family</taxonepithet>

                                                                                                                </taxonlabel>

                                                                                                            </parent_id>

                                                                                                        </taxonlabel>

                                                                                                    </parent_id>

                                                                                                </taxonlabel>

                                                                                            </parent_id>

                                                                                        </taxonlabel>

                                                                                    </parent_id>

                                                                                </taxonlabel>

                                                                            </parent_id>

                                                                        </taxonlabel>

                                                                    </parent_id>

                                                                </taxonlabel>

                                                            </parent_id>

                                                            <taxonepithet>$infraspecificEpithet</taxonepithet>

                                                        </taxonlabel>

                                                    </parent_id>

                                                    <rank>$taxonRank</rank>

                                                    <taxonomicname>

                                                        <_merge_prefix>

                                                            <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>

                                                            <value>

                                                                <_alt>

                                                                    <1>$scientificName</1>

                                                                    <2>

                                                                        <_join_words>

                                                                            <1>

                                                                                <_join_words>

                                                                                    <2>$genus</2>

                                                                                    <3>$specificEpithet</3>

                                                                                    <5>

                                                                                        <_join_words>

                                                                                            <1>

                                                                                                <_if name="if has infraspecificEpithet">

                                                                                                    <cond>$infraspecificEpithet</cond>

                                                                                                    <then>$taxonRank</then>

                                                                                                </_if>

                                                                                            </1>

                                                                                            <2>$infraspecificEpithet</2>

                                                                                        </_join_words>

                                                                                    </5>

                                                                                </_join_words>

                                                                            </1>

                                                                            <2>$scientificNameAuthorship</2>

                                                                        </_join_words>

                                                                    </2>

                                                                </_alt>

                                                            </value>

                                                        </_merge_prefix>

                                                    </taxonomicname>

                                                </taxonlabel>

                                            </taxonlabel_id>

                                            <author>$scientificNameAuthorship</author>

                                            <family>$family</family>

                                            <genus>$genus</genus>

                                            <specific_epithet>$specificEpithet</specific_epithet>

                                            <taxonomicname>$scientificName</taxonomicname>

                                            <verbatimrank>$taxonRank</verbatimrank>

                                        </taxonverbatim>

                                    </taxonverbatim_id>

                                    <determinationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></determinationdate>

                                    <notes>$taxonRemarks</notes>

                                    <taxonfit>$identificationQualifier</taxonfit>

                                </taxondetermination>

                            </taxonoccurrence>

                        </locationevent>

                        <locationnarrative>

                            <_merge>

                                <1>$locality</1>

                                <3>

                                    <_label>

                                        <label>habitat</label>

                                        <value>$habitat</value>

                                    </_label>

                                </3>

                                <4>$locationRemarks</4>

                            </_merge>

                        </locationnarrative>

                        <locationplace>

                            <place_id>

                                <place>

                                    <coordinates_id>

                                        <coordinates>

                                            <coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>

                                            <footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc>

                                            <latitude_deg>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$decimalLatitude</value>

                                                </_nullIf>

                                            </latitude_deg>

                                            <longitude_deg>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$decimalLongitude</value>

                                                </_nullIf>

                                            </longitude_deg>

                                            <verbatimcoordinates>$verbatimCoordinates</verbatimcoordinates>

                                        </coordinates>

                                    </coordinates_id>

                                    <country>$country</country>

                                    <county>$county</county>

                                    <matched_place_id>

                                        <place>

                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>

                                            <coordinates_id>

                                                <coordinates>

                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>

                                                    <latitude_deg>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>$decimalLatitude</value>

                                                        </_nullIf>

                                                    </latitude_deg>

                                                    <longitude_deg>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>$decimalLongitude</value>

                                                        </_nullIf>

                                                    </longitude_deg>

                                                </coordinates>

                                            </coordinates_id>

                                            <country>$country</country>

                                            <county>$county</county>

                                            <stateprovince>$stateProvince</stateprovince>

                                        </place>

                                    </matched_place_id>

                                    <stateprovince>$stateProvince</stateprovince>

                                </place>

                            </place_id>

                        </locationplace>

                        <verbatimelevation>$verbatimElevation</verbatimelevation>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 39 new rows into database