Project

General

Profile

« Previous | Next » 

Revision 10530

inputs/SpeciesLink/: switched to new-style import, using the steps at wiki.vegpath.org/Adding_new-style_import_to_a_datasource

View differences:

test.xml.ref
9 9
                    <location>
10 10
                        <authorlocationcode>
11 11
                            <_alt>
12
                                <1>$dwc_dwcore_GlobalUniqueIdentifier</1>
12
                                <1>$occurrenceID</1>
13 13
                                <2>
14 14
                                    <_join>
15
                                        <1>$dwc_terms_institutionCode</1>
15
                                        <1>$specimenHolderInstitutions</1>
16 16
                                        <2>
17 17
                                            <_join>
18
                                                <1>$dwc_terms_collectionCode</1>
19
                                                <2>$dwc_terms_collectionID</2>
18
                                                <1>$collection</1>
19
                                                <2>$collectionURL</2>
20 20
                                            </_join>
21 21
                                        </2>
22
                                        <3>$dwc_terms_catalogNumber</3>
22
                                        <3>$accessionNumber</3>
23 23
                                    </_join>
24 24
                                </2>
25 25
                            </_alt>
26 26
                        </authorlocationcode>
27 27
                        <elevation_m>
28 28
                            <_avg>
29
                                <1>$dwc_terms_minimumElevationInMeters</1>
30
                                <2>$dwc_terms_maximumElevationInMeters</2>
29
                                <1>$minimumElevationInMeters</1>
30
                                <2>$maximumElevationInMeters</2>
31 31
                            </_avg>
32 32
                        </elevation_m>
33
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$dwc_terms_locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
33
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
34 34
                        <locationevent>
35 35
                            <taxonoccurrence>
36 36
                                <aggregateoccurrence>
......
40 40
                                                <_nullIf>
41 41
                                                    <null>0</null>
42 42
                                                    <type>float</type>
43
                                                    <value>$dwc_terms_day</value>
43
                                                    <value>$dayCollected</value>
44 44
                                                </_nullIf>
45 45
                                            </day>
46 46
                                            <month>
47 47
                                                <_nullIf>
48 48
                                                    <null>0</null>
49 49
                                                    <type>float</type>
50
                                                    <value>$dwc_terms_month</value>
50
                                                    <value>$monthCollected</value>
51 51
                                                </_nullIf>
52 52
                                            </month>
53 53
                                            <year>
54 54
                                                <_nullIf>
55 55
                                                    <null>0</null>
56 56
                                                    <type>float</type>
57
                                                    <value>$dwc_terms_year</value>
57
                                                    <value>$yearCollected</value>
58 58
                                                </_nullIf>
59 59
                                            </year>
60 60
                                        </_date>
61 61
                                    </collectiondate>
62
                                    <count>$dwc_terms_individualCount</count>
63
                                    <notes>$dwc_terms_occurrenceRemarks</notes>
62
                                    <count>$individualCount</count>
63
                                    <notes>$occurrenceRemarks</notes>
64 64
                                    <plantobservation>
65 65
                                        <authorplantcode>$collectorNumber</authorplantcode>
66 66
                                        <definedvalue fkey="tablerecord_id">
......
70 70
                                                    <userdefinedname>sex</userdefinedname>
71 71
                                                </userdefined>
72 72
                                            </userdefined_id>
73
                                            <definedvalue>$dwc_terms_sex</definedvalue>
73
                                            <definedvalue>$sex</definedvalue>
74 74
                                        </definedvalue>
75 75
                                        <specimenreplicate>
76
                                            <catalognumber_dwc>$dwc_terms_catalogNumber</catalognumber_dwc>
76
                                            <catalognumber_dwc>$accessionNumber</catalognumber_dwc>
77 77
                                            <collectioncode_dwc>
78 78
                                                <_alt>
79
                                                    <1>$dwc_terms_collectionCode</1>
80
                                                    <2>$dwc_terms_collectionID</2>
79
                                                    <1>$collection</1>
80
                                                    <2>$collectionURL</2>
81 81
                                                </_alt>
82 82
                                            </collectioncode_dwc>
83 83
                                            <collectionnumber>$collectorNumber</collectionnumber>
84 84
                                            <institution_id>
85 85
                                                <sourcelist>
86
                                                    <name>$dwc_terms_institutionCode</name>
86
                                                    <name>$specimenHolderInstitutions</name>
87 87
                                                    <sourcename>
88 88
                                                        <name>
89 89
                                                            <_split>
90 90
                                                                <separator>[,;] *</separator>
91
                                                                <value>$dwc_terms_institutionCode</value>
91
                                                                <value>$specimenHolderInstitutions</value>
92 92
                                                            </_split>
93 93
                                                        </name>
94 94
                                                    </sourcename>
95 95
                                                </sourcelist>
96 96
                                            </institution_id>
97
                                            <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
97
                                            <sourceaccessioncode>$occurrenceID</sourceaccessioncode>
98 98
                                        </specimenreplicate>
99 99
                                    </plantobservation>
100 100
                                </aggregateoccurrence>
101
                                <collector_id><party><fullname>$dwc_terms_recordedBy</fullname></party></collector_id>
102
                                <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
101
                                <collector_id><party><fullname>$recordedBy</fullname></party></collector_id>
102
                                <sourceaccessioncode>$occurrenceID</sourceaccessioncode>
103 103
                                <taxondetermination>
104
                                    <party_id><party><fullname>$dwc_terms_identifiedBy</fullname></party></party_id>
104
                                    <party_id><party><fullname>$identifiedBy</fullname></party></party_id>
105 105
                                    <taxonverbatim_id>
106 106
                                        <taxonverbatim>
107 107
                                            <taxonlabel_id>
......
120 120
                                                                                    <parent_id>
121 121
                                                                                        <taxonlabel>
122 122
                                                                                            <rank>subspecies</rank>
123
                                                                                            <taxonepithet>$conceptual_darwin_2003_1_0_Subspecies</taxonepithet>
123
                                                                                            <taxonepithet>$subspecies</taxonepithet>
124 124
                                                                                            <parent_id>
125 125
                                                                                                <taxonlabel>
126 126
                                                                                                    <rank>species</rank>
127
                                                                                                    <taxonepithet>$dwc_terms_specificEpithet</taxonepithet>
127
                                                                                                    <taxonepithet>$specificEpithet</taxonepithet>
128 128
                                                                                                    <parent_id>
129 129
                                                                                                        <taxonlabel>
130 130
                                                                                                            <rank>genus</rank>
131
                                                                                                            <taxonepithet>$dwc_terms_genus</taxonepithet>
131
                                                                                                            <taxonepithet>$genus</taxonepithet>
132 132
                                                                                                            <parent_id>
133 133
                                                                                                                <taxonlabel>
134 134
                                                                                                                    <rank>family</rank>
135
                                                                                                                    <taxonepithet>$dwc_terms_family</taxonepithet>
135
                                                                                                                    <taxonepithet>$family</taxonepithet>
136 136
                                                                                                                    <parent_id>
137 137
                                                                                                                        <taxonlabel>
138 138
                                                                                                                            <rank>order</rank>
139
                                                                                                                            <taxonepithet>$dwc_terms_order</taxonepithet>
139
                                                                                                                            <taxonepithet>$order</taxonepithet>
140 140
                                                                                                                            <parent_id>
141 141
                                                                                                                                <taxonlabel>
142 142
                                                                                                                                    <rank>class</rank>
143
                                                                                                                                    <taxonepithet>$dwc_terms_class</taxonepithet>
143
                                                                                                                                    <taxonepithet>$class</taxonepithet>
144 144
                                                                                                                                    <parent_id>
145 145
                                                                                                                                        <taxonlabel>
146 146
                                                                                                                                            <rank>phylum</rank>
147
                                                                                                                                            <taxonepithet>$dwc_terms_phylum</taxonepithet>
147
                                                                                                                                            <taxonepithet>$phylum</taxonepithet>
148 148
                                                                                                                                            <parent_id>
149 149
                                                                                                                                                <taxonlabel>
150 150
                                                                                                                                                    <rank>kingdom</rank>
151
                                                                                                                                                    <taxonepithet>$dwc_terms_kingdom</taxonepithet>
151
                                                                                                                                                    <taxonepithet>$kingdom</taxonepithet>
152 152
                                                                                                                                                </taxonlabel>
153 153
                                                                                                                                            </parent_id>
154 154
                                                                                                                                        </taxonlabel>
......
171 171
                                                                    </parent_id>
172 172
                                                                </taxonlabel>
173 173
                                                            </parent_id>
174
                                                            <taxonepithet>$dwc_terms_infraspecificEpithet</taxonepithet>
174
                                                            <taxonepithet>$infraspecificEpithet</taxonepithet>
175 175
                                                        </taxonlabel>
176 176
                                                    </parent_id>
177 177
                                                    <taxonomicname>
178 178
                                                        <_merge_prefix>
179
                                                            <prefix><_taxon_family_require_std><family>$dwc_terms_family</family></_taxon_family_require_std></prefix>
179
                                                            <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>
180 180
                                                            <value>
181 181
                                                                <_alt>
182
                                                                    <1>$dwc_terms_scientificName</1>
182
                                                                    <1>$scientificName</1>
183 183
                                                                    <2>
184 184
                                                                        <_join_words>
185 185
                                                                            <1>
186 186
                                                                                <_join_words>
187
                                                                                    <2><_filter_genus><value>$dwc_terms_genus</value></_filter_genus></2>
188
                                                                                    <3>$dwc_terms_specificEpithet</3>
189
                                                                                    <4>$conceptual_darwin_2003_1_0_Subspecies</4>
190
                                                                                    <5>$dwc_terms_infraspecificEpithet</5>
187
                                                                                    <2><_filter_genus><value>$genus</value></_filter_genus></2>
188
                                                                                    <3>$specificEpithet</3>
189
                                                                                    <4>$subspecies</4>
190
                                                                                    <5>$infraspecificEpithet</5>
191 191
                                                                                </_join_words>
192 192
                                                                            </1>
193
                                                                            <2>$dwc_terms_scientificNameAuthorship</2>
193
                                                                            <2>$scientificNameAuthorship</2>
194 194
                                                                        </_join_words>
195 195
                                                                    </2>
196 196
                                                                </_alt>
......
199 199
                                                    </taxonomicname>
200 200
                                                </taxonlabel>
201 201
                                            </taxonlabel_id>
202
                                            <author>$dwc_terms_scientificNameAuthorship</author>
203
                                            <family>$dwc_terms_family</family>
204
                                            <genus>$dwc_terms_genus</genus>
205
                                            <specific_epithet>$dwc_terms_specificEpithet</specific_epithet>
206
                                            <taxonomicname>$dwc_terms_scientificName</taxonomicname>
202
                                            <author>$scientificNameAuthorship</author>
203
                                            <family>$family</family>
204
                                            <genus>$genus</genus>
205
                                            <specific_epithet>$specificEpithet</specific_epithet>
206
                                            <taxonomicname>$scientificName</taxonomicname>
207 207
                                        </taxonverbatim>
208 208
                                    </taxonverbatim_id>
209 209
                                    <determinationdate>
210 210
                                        <_alt>
211
                                            <1><_dateRangeStart><value>$dwc_terms_dateIdentified</value></_dateRangeStart></1>
211
                                            <1><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></1>
212 212
                                            <2>
213 213
                                                <_date>
214 214
                                                    <day>
215 215
                                                        <_nullIf>
216 216
                                                            <null>0</null>
217 217
                                                            <type>float</type>
218
                                                            <value>$conceptual_darwin_2003_1_0_DayIdentified</value>
218
                                                            <value>$dayIdentified</value>
219 219
                                                        </_nullIf>
220 220
                                                    </day>
221 221
                                                    <month>
222 222
                                                        <_nullIf>
223 223
                                                            <null>0</null>
224 224
                                                            <type>float</type>
225
                                                            <value>$conceptual_darwin_2003_1_0_MonthIdentified</value>
225
                                                            <value>$monthIdentified</value>
226 226
                                                        </_nullIf>
227 227
                                                    </month>
228 228
                                                    <year>
229 229
                                                        <_nullIf>
230 230
                                                            <null>0</null>
231 231
                                                            <type>float</type>
232
                                                            <value>$conceptual_darwin_2003_1_0_YearIdentified</value>
232
                                                            <value>$yearIdentified</value>
233 233
                                                        </_nullIf>
234 234
                                                    </year>
235 235
                                                </_date>
......
240 240
                            </taxonoccurrence>
241 241
                            <waterdepth_m>
242 242
                                <_avg>
243
                                    <1>$dwc_terms_minimumDepthInMeters</1>
244
                                    <2>$dwc_terms_maximumDepthInMeters</2>
243
                                    <1>$minimumDepthInMeters</1>
244
                                    <2>$maximumDepthInMeters</2>
245 245
                                </_avg>
246 246
                            </waterdepth_m>
247 247
                        </locationevent>
248
                        <locationnarrative>$dwc_terms_locality</locationnarrative>
248
                        <locationnarrative>$locality</locationnarrative>
249 249
                        <locationplace>
250 250
                            <place_id>
251 251
                                <place>
252 252
                                    <coordinates_id>
253 253
                                        <coordinates>
254
                                            <coordsaccuracy_m><_noCV><value>$dwc_terms_coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>
254
                                            <coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>
255 255
                                            <latitude_deg>
256 256
                                                <_nullIf>
257 257
                                                    <null>0</null>
258 258
                                                    <type>float</type>
259
                                                    <value>$dwc_terms_decimalLatitude</value>
259
                                                    <value>$decimalLatitude</value>
260 260
                                                </_nullIf>
261 261
                                            </latitude_deg>
262 262
                                            <longitude_deg>
263 263
                                                <_nullIf>
264 264
                                                    <null>0</null>
265 265
                                                    <type>float</type>
266
                                                    <value>$dwc_terms_decimalLongitude</value>
266
                                                    <value>$decimalLongitude</value>
267 267
                                                </_nullIf>
268 268
                                            </longitude_deg>
269
                                            <verbatimlatitude>$dwc_terms_verbatimLatitude</verbatimlatitude>
270
                                            <verbatimlongitude>$dwc_terms_verbatimLongitude</verbatimlongitude>
269
                                            <verbatimlatitude>$verbatimLatitude</verbatimlatitude>
270
                                            <verbatimlongitude>$verbatimLongitude</verbatimlongitude>
271 271
                                        </coordinates>
272 272
                                    </coordinates_id>
273
                                    <continent>$dwc_terms_continent</continent>
274
                                    <country>$dwc_terms_country</country>
275
                                    <county>$dwc_terms_county</county>
273
                                    <continent>$continent</continent>
274
                                    <country>$country</country>
275
                                    <county>$county</county>
276 276
                                    <matched_place_id>
277 277
                                        <place>
278 278
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
......
283 283
                                                        <_nullIf>
284 284
                                                            <null>0</null>
285 285
                                                            <type>float</type>
286
                                                            <value>$dwc_terms_decimalLatitude</value>
286
                                                            <value>$decimalLatitude</value>
287 287
                                                        </_nullIf>
288 288
                                                    </latitude_deg>
289 289
                                                    <longitude_deg>
290 290
                                                        <_nullIf>
291 291
                                                            <null>0</null>
292 292
                                                            <type>float</type>
293
                                                            <value>$dwc_terms_decimalLongitude</value>
293
                                                            <value>$decimalLongitude</value>
294 294
                                                        </_nullIf>
295 295
                                                    </longitude_deg>
296 296
                                                </coordinates>
297 297
                                            </coordinates_id>
298
                                            <country>$dwc_terms_country</country>
299
                                            <county>$dwc_terms_county</county>
300
                                            <stateprovince>$dwc_terms_stateProvince</stateprovince>
298
                                            <country>$country</country>
299
                                            <county>$county</county>
300
                                            <stateprovince>$stateProvince</stateprovince>
301 301
                                        </place>
302 302
                                    </matched_place_id>
303
                                    <stateprovince>$dwc_terms_stateProvince</stateprovince>
303
                                    <stateprovince>$stateProvince</stateprovince>
304 304
                                </place>
305 305
                            </place_id>
306 306
                        </locationplace>

Also available in: Unified diff