Project

General

Profile

1
Put template:
2
<VegBIEN>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>
8
                    <_alt>
9
                        <1>$ID</1>
10
                        <2>$Barcode</2>
11
                    </_alt>
12
                </authorlocationcode>
13
                <locationdetermination>
14
                    <latitude>
15
                        <_nullIf>
16
                            <null>0</null>
17
                            <type>float</type>
18
                            <value>$Lat</value>
19
                        </_nullIf>
20
                    </latitude>
21
                    <longitude>
22
                        <_nullIf>
23
                            <null>0</null>
24
                            <type>float</type>
25
                            <value>$Long</value>
26
                        </_nullIf>
27
                    </longitude>
28
                    <namedplace_id>
29
                        <namedplace>
30
                            <rank>county</rank>
31
                            <parent_id>
32
                                <namedplace>
33
                                    <rank>stateProvince</rank>
34
                                    <parent_id>
35
                                        <namedplace>
36
                                            <rank>country</rank>
37
                                            <placename>$Country</placename>
38
                                        </namedplace>
39
                                    </parent_id>
40
                                </namedplace>
41
                            </parent_id>
42
                        </namedplace>
43
                    </namedplace_id>
44
                </locationdetermination>
45
                <locationevent>
46
                    <taxonoccurrence>
47
                        <aggregateoccurrence>
48
                            <collectiondate>
49
                                <_date>
50
                                    <day>
51
                                        <_nullIf>
52
                                            <null>0</null>
53
                                            <type>float</type>
54
                                            <value>$Colldd</value>
55
                                        </_nullIf>
56
                                    </day>
57
                                    <month>
58
                                        <_nullIf>
59
                                            <null>0</null>
60
                                            <type>float</type>
61
                                            <value>$Collmm</value>
62
                                        </_nullIf>
63
                                    </month>
64
                                    <year>
65
                                        <_nullIf>
66
                                            <null>0</null>
67
                                            <type>float</type>
68
                                            <value>$Collyy</value>
69
                                        </_nullIf>
70
                                    </year>
71
                                </_date>
72
                            </collectiondate>
73
                            <notes>$Notes</notes>
74
                            <plantobservation>
75
                                <collectionnumber>$Number</collectionnumber>
76
                                <specimenreplicate>
77
                                    <catalognumber_dwc>$Barcode</catalognumber_dwc>
78
                                    <sourceaccessioncode>$ID</sourceaccessioncode>
79
                                </specimenreplicate>
80
                            </plantobservation>
81
                        </aggregateoccurrence>
82
                        <authortaxoncode>$Number</authortaxoncode>
83
                        <taxondetermination>
84
                            <party_id>
85
                                <party>
86
                                    <givenname><_namePart><first>$Detby</first></_namePart></givenname>
87
                                    <middlename><_namePart><middle>$Detby</middle></_namePart></middlename>
88
                                    <surname><_namePart><last>$Detby</last></_namePart></surname>
89
                                </party>
90
                            </party_id>
91
                            <taxonpath_id>
92
                                <taxonpath>
93
                                    <family>$Family</family>
94
                                    <genus>$Genus</genus>
95
                                </taxonpath>
96
                            </taxonpath_id>
97
                            <determinationdate>
98
                                <_date>
99
                                    <year>
100
                                        <_nullIf>
101
                                            <null>0</null>
102
                                            <type>float</type>
103
                                            <value>$Detyy</value>
104
                                        </_nullIf>
105
                                    </year>
106
                                </_date>
107
                            </determinationdate>
108
                            <taxonfit>$cf</taxonfit>
109
                        </taxondetermination>
110
                        <verbatimcollectorname>
111
                            <_join>
112
                                <1>$Collector</1>
113
                                <2>$Addcoll</2>
114
                            </_join>
115
                        </verbatimcollectorname>
116
                    </taxonoccurrence>
117
                </locationevent>
118
                <locationnarrative>
119
                    <_merge>
120
                        <2>
121
                            <_join>
122
                                <1>
123
                                    <_label>
124
                                        <label>gazetteer</label>
125
                                        <value>
126
                                            <_join>
127
                                                <1>$Gazetteer</1>
128
                                                <2>$Newgazett</2>
129
                                            </_join>
130
                                        </value>
131
                                    </_label>
132
                                </1>
133
                                <2>$Locnotes</2>
134
                            </_join>
135
                        </2>
136
                        <3>
137
                            <_label>
138
                                <label>habitat</label>
139
                                <value>$Ecology</value>
140
                            </_label>
141
                        </3>
142
                    </_merge>
143
                </locationnarrative>
144
            </location>
145
        </path>
146
    </_simplifyPath>
147
</VegBIEN>
148
Inserted 22 new rows into database
(5-5/6)