herbariumAcronym,City,State,Country,CoordinatesVerbatim,latitude,longitude,ID,countryStd,countryID,Index_2_index,Index_3_index,Index_4_index,Index_5_index,Index_countryStd_index,Index_countryID_index

herbaria,VegCore,Filter,Comments

herbariumAcronym,institutionCode,,

City,OMIT,,"Just importing whether a datasource is a herbarium, for now"

State,OMIT,,"Just importing whether a datasource is a herbarium, for now"

Country,OMIT,,"Just importing whether a datasource is a herbarium, for now"

CoordinatesVerbatim,OMIT,,"Just importing whether a datasource is a herbarium, for now"

latitude,OMIT,,"Just importing whether a datasource is a herbarium, for now"

longitude,OMIT,,"Just importing whether a datasource is a herbarium, for now"

ID,OMIT,,"Just importing whether a datasource is a herbarium, for now"

countryStd,OMIT,,"Just importing whether a datasource is a herbarium, for now"

countryID,OMIT,,"Just importing whether a datasource is a herbarium, for now"

Index_2_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_3_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_4_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_5_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_countryStd_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_countryID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

:herbarium,referenceType,,

:specimen,observationType,,

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>herbaria</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <source>

                        <shortname>$herbariumAcronym</shortname>

                        <observationtype>specimen</observationtype>

                        <sourcetype>herbarium</sourcetype>

                    </source>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 2 new rows into database

herbaria,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

herbariumAcronym,"/_if[@name=""if specimen""]/else/source/shortname/_first/1",

:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",

:herbarium,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",

:specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",

herbariumAcronym,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then",

herbariumAcronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",

herbariumAcronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",

City,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"

CoordinatesVerbatim,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"

Country,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"

ID,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"

Index_2_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

Index_3_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

Index_4_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

Index_5_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

Index_countryID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

Index_countryStd_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

State,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"

countryID,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"

countryStd,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"

latitude,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"

longitude,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"

herbariumAcronym,institutionCode,,

City,OMIT,,"Just importing whether a datasource is a herbarium, for now"

CoordinatesVerbatim,OMIT,,"Just importing whether a datasource is a herbarium, for now"

countryStd,OMIT,,"Just importing whether a datasource is a herbarium, for now"

countryID,OMIT,,"Just importing whether a datasource is a herbarium, for now"

Index_2_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_3_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_4_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_5_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_countryStd_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_countryID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation