scientificNameID	scientificName

test_taxonomic_names,VegCore,Filter,Comments

scientificNameID,scientificNameID,,

scientificName,scientificName,,

test_taxonomic_names,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments

scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",

scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",

scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,

scientificNameID,,** No join mapping for scientificNameID ** 

Put template:

<VegBIEN>

    <_simplifyPath id="-1">

        <next>parent_id</next>

        <path>

            <location>

                <locationevent>

                    <taxonoccurrence>

                        <taxondetermination>

                            <taxonpath_id>

                                <taxonpath>

                                    <canon_taxonpath_id>

                                        <taxonpath>

                                            <datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id>

                                            <identifyingtaxonomicname>$scientificName</identifyingtaxonomicname>

                                        </taxonpath>

                                    </canon_taxonpath_id>

                                    <taxonomicname>$scientificName</taxonomicname>

                                </taxonpath>

                            </taxonpath_id>

                        </taxondetermination>

                    </taxonoccurrence>

                </locationevent>

            </location>

        </path>

    </_simplifyPath>

</VegBIEN>

Inserted 9 new rows into database

scientificNameID