project_id,projectname,projectdescription,startdate,stopdate,d_obscount,d_lastplotaddeddate,accessioncode

#!/bin/bash -e

. "$(dirname "${BASH_SOURCE[0]}")"/../table.run

VegBank,VegCore,Filter,Comments

project_id,projectID,,

projectname,projectName,,

projectdescription,*project--projectdescription,,

startdate,projectStartDate,,

stopdate,projectEndDate,,

d_obscount,*project--d_obscount,,

d_lastplotaddeddate,*project--d_lastplotaddeddate,,

accessioncode,*project--accessioncode,,

link ../../../mappings/VegCore-VegBIEN.csv

<!--put template-->

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>VegBank.new</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <locationevent>

                            <project_id>

                                <project>

                                    <projectname>$projectName</projectname>

                                    <sourceaccessioncode>$projectID</sourceaccessioncode>

                                    <startdate>$projectStartDate</startdate>

                                    <stopdate>$projectEndDate</stopdate>

                                </project>

                            </project_id>

                        </locationevent>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 3 new rows into database

projectdescription,*project--projectdescription,,

stopdate,projectEndDate,,

d_obscount,*project--d_obscount,,

d_lastplotaddeddate,*project--d_lastplotaddeddate,,

accessioncode,*project--accessioncode,,

*project--projectdescription

*project--d_obscount

*project--d_lastplotaddeddate

*project--accessioncode