stemlocation_id,stemcount_id,stemcode,stemxposition,stemyposition,stemhealth,emb_stemlocation

VegBank,VegCore,Filter,Comments

stemlocation_id,stemID,,

stemcount_id,individualID,,

stemcode,authorStemCode,,

stemxposition,organismX,,

stemyposition,organismY,,

stemhealth,stemhealth,,

emb_stemlocation,emb_stemlocation,,

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

stemcount_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,

stemcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,

stemlocation_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode,

stemxposition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,

stemyposition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,

stemcount_id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2,

emb_stemlocation,,** No join mapping for emb_stemlocation ** 

stemhealth,,** No join mapping for stemhealth ** 

Put template:

<VegBIEN>

    <_simplifyPath id="-1">

        <next>parent_id</next>

        <path>

            <location>

                <locationevent>

                    <taxonoccurrence>

                        <aggregateoccurrence>

                            <plantobservation>

                                <sourceaccessioncode>$stemcount_id</sourceaccessioncode>

                                <stemobservation>

                                    <authorstemcode>$stemcode</authorstemcode>

                                    <sourceaccessioncode>$stemlocation_id</sourceaccessioncode>

                                    <xposition_m>$stemxposition</xposition_m>

                                    <yposition_m>$stemyposition</yposition_m>

                                </stemobservation>

                            </plantobservation>

                        </aggregateoccurrence>

                        <sourceaccessioncode>$stemcount_id</sourceaccessioncode>

                    </taxonoccurrence>

                </locationevent>

            </location>

        </path>

    </_simplifyPath>

</VegBIEN>

Inserted 9 new rows into database

stemlocation_id,stemID,,

stemcount_id,individualID,,

stemcode,authorStemCode,,

stemxposition,organismX,,

stemyposition,organismY,,

stemhealth

emb_stemlocation

stemcount

stemlocation