Put template:

<VegBIEN>

    <_simplifyPath id="-1">

        <next>parent_id</next>

        <path>

            <location>

                <authorlocationcode>

                    <_alt>

                        <1>$id</1>

                        <2>

                            <_join>

                                <1>$institutionCode</1>

                                <2>

                                    <_join>

                                        <1>$collectionCode</1>

                                        <2>$collectionID</2>

                                    </_join>

                                </2>

                                <3>$catalogNumber</3>

                            </_join>

                        </2>

                    </_alt>

                </authorlocationcode>

                <elevation_m>

                    <_replace>

                        <\bca\.?></\bca\.?>

                        <value>$verbatimElevation</value>

                    </_replace>

                </elevation_m>

                <locationcoords>

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

                </locationcoords>

                <locationevent>

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

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

                    <taxonoccurrence>

                        <aggregateoccurrence>

                            <plantobservation>

                                <collectionnumber>$recordNumber</collectionnumber>

                                <specimenreplicate>

                                    <catalognumber_dwc>$catalogNumber</catalognumber_dwc>

                                    <collectioncode_dwc>

                                        <_join>

                                            <1>$collectionCode</1>

                                            <2>$collectionID</2>

                                        </_join>

                                    </collectioncode_dwc>

                                    <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>

                                    <sourceaccessioncode>$id</sourceaccessioncode>

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <authortaxoncode>

                            <_alt>

                                <1>$recordNumber</1>

                                <2>$scientificName</2>

                            </_alt>

                        </authortaxoncode>

                        <taxondetermination>

                            <party_id>

                                <party>

                                    <givenname><_namePart><first>$identifiedBy</first></_namePart></givenname>

                                    <middlename><_namePart><middle>$identifiedBy</middle></_namePart></middlename>

                                    <surname><_namePart><last>$identifiedBy</last></_namePart></surname>

                                </party>

                            </party_id>

                            <taxonpath_id>

                                <taxonpath>

                                    <class>$class</class>

                                    <family>$family</family>

                                    <genus>$genus</genus>

                                    <kingdom>$kingdom</kingdom>

                                    <order>$order</order>

                                    <phylum>$phylum</phylum>

                                    <scientificname>$scientificName</scientificname>

                                    <scientificnameauthor>$scientificNameAuthorship</scientificnameauthor>

                                    <species>$specificEpithet</species>

                                    <subspecies>

                                        <_name>

                                            <first>$taxonRank</first>

                                            <last>$infraspecificEpithet</last>

                                        </_name>

                                    </subspecies>

                                </taxonpath>

                            </taxonpath_id>

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

                        </taxondetermination>

                        <verbatimcollectorname>$recordedBy</verbatimcollectorname>

                    </taxonoccurrence>

                </locationevent>

                <locationnarrative>

                    <_merge>

                        <1>$locality</1>

                        <3>

                            <_label>

                                <label>habitat</label>

                                <value>$habitat</value>

                            </_label>

                        </3>

                    </_merge>

                </locationnarrative>

                <locationplace>

                    <placepath_id>

                        <placepath>

                            <continent>$continent</continent>

                            <country>$country</country>

                            <county>$county</county>

                            <stateprovince>$stateProvince</stateprovince>

                        </placepath>

                    </placepath_id>

                </locationplace>

            </location>

        </path>

    </_simplifyPath>

</VegBIEN>

Inserted 25 new rows into database