Project

General

Profile

« Previous | Next » 

Revision 4120

View differences:

inputs/MT/test/import.specimens.xml.ref
1
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>
5
            <_alt>
6
                <3>$id</3>
7
                <4>
8
                    <_merge>
9
                        <1>$institutionCode</1>
10
                        <2>
11
                            <_merge>
12
                                <1>$collectionCode</1>
13
                                <2>$collectionID</2>
14
                            </_merge>
15
                        </2>
16
                    </_merge>
17
                </4>
18
            </_alt>
19
        </authorlocationcode>
20
        <locationdetermination>
21
            <namedplace_id>
22
                <_simplifyPath>
23
                    <next>parent_id/namedplace</next>
24
                    <require>placename</require>
25
                    <path>
26
                        <namedplace>
27
                            <rank>county</rank>
28
                            <parent_id>
29
                                <namedplace>
30
                                    <rank>stateProvince</rank>
31
                                    <parent_id>
32
                                        <namedplace>
33
                                            <rank>country</rank>
34
                                            <parent_id>
35
                                                <namedplace>
36
                                                    <rank>continent</rank>
37
                                                    <placename>$continent</placename>
38
                                                </namedplace>
39
                                            </parent_id>
40
                                        </namedplace>
41
                                    </parent_id>
42
                                </namedplace>
43
                            </parent_id>
44
                        </namedplace>
45
                    </path>
46
                </_simplifyPath>
47
            </namedplace_id>
48
        </locationdetermination>
49
        <locationevent>
50
            <taxonoccurrence>
51
                <aggregateoccurrence>
52
                    <count>$individualCount</count>
53
                    <plantobservation>
54
                        <specimenreplicate>
55
                            <collectioncode_dwc>
56
                                <_merge>
57
                                    <1>$collectionCode</1>
58
                                    <2>$collectionID</2>
59
                                </_merge>
60
                            </collectioncode_dwc>
61
                            <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
62
                            <sourceaccessioncode>$id</sourceaccessioncode>
63
                        </specimenreplicate>
64
                    </plantobservation>
65
                </aggregateoccurrence>
66
                <iscultivated>
67
                    <_map>
68
                        <cultivated>t</cultivated>
69
                        <wild>f</wild>
70
                        <*></*>
71
                        <value>$establishmentMeans</value>
72
                    </_map>
73
                </iscultivated>
74
                <isnative>
75
                    <_map>
76
                        <native>t</native>
77
                        <exotic>f</exotic>
78
                        <*></*>
79
                        <value>$establishmentMeans</value>
80
                    </_map>
81
                </isnative>
82
                <taxondetermination>
83
                    <isoriginal>true</isoriginal>
84
                    <role>identifier</role>
85
                    <plantconcept_id>
86
                        <plantconcept>
87
                            <plantname_id>
88
                                <_simplifyPath>
89
                                    <next>parent_id/plantname</next>
90
                                    <require>plantname</require>
91
                                    <path>
92
                                        <plantname>
93
                                            <rank>binomial</rank>
94
                                            <parent_id>
95
                                                <plantname>
96
                                                    <rank>authority</rank>
97
                                                    <parent_id>
98
                                                        <plantname>
99
                                                            <rank>subspecies</rank>
100
                                                            <parent_id>
101
                                                                <plantname>
102
                                                                    <rank>species</rank>
103
                                                                    <parent_id>
104
                                                                        <plantname>
105
                                                                            <rank>genus</rank>
106
                                                                            <plantname>$genus</plantname>
107
                                                                            <parent_id>
108
                                                                                <plantname>
109
                                                                                    <rank>family</rank>
110
                                                                                    <plantname>$family</plantname>
111
                                                                                </plantname>
112
                                                                            </parent_id>
113
                                                                        </plantname>
114
                                                                    </parent_id>
115
                                                                </plantname>
116
                                                            </parent_id>
117
                                                        </plantname>
118
                                                    </parent_id>
119
                                                </plantname>
120
                                            </parent_id>
121
                                        </plantname>
122
                                    </path>
123
                                </_simplifyPath>
124
                            </plantname_id>
125
                        </plantconcept>
126
                    </plantconcept_id>
127
                </taxondetermination>
128
            </taxonoccurrence>
129
        </locationevent>
130
        <locationnarrative>$locality</locationnarrative>
131
    </location>
132
</VegBIEN>
133
Inserted 22 new rows into database
inputs/XAL/test/import.specimens.xml.ref
1
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>
5
            <_merge>
6
                <1>$InstitutionCode</1>
7
                <2>$CollectionCode</2>
8
                <3>$CatalogNumber</3>
9
            </_merge>
10
        </authorlocationcode>
11
        <elevation>
12
            <_avg>
13
                <max>
14
                    <_units>
15
                        <default>m</default>
16
                        <to>m</to>
17
                        <to></to>
18
                        <value>
19
                            <_replace>
20
                                <\bca\.?></\bca\.?>
21
                                <value>$MaximumElevation</value>
22
                            </_replace>
23
                        </value>
24
                    </_units>
25
                </max>
26
                <min>
27
                    <_units>
28
                        <default>m</default>
29
                        <to>m</to>
30
                        <to></to>
31
                        <value>
32
                            <_rangeStart>
33
                                <value>
34
                                    <_replace>
35
                                        <\bca\.?></\bca\.?>
36
                                        <value>$MinimumElevation</value>
37
                                    </_replace>
38
                                </value>
39
                            </_rangeStart>
40
                        </value>
41
                    </_units>
42
                </min>
43
            </_avg>
44
        </elevation>
45
        <elevationrange>
46
            <_range>
47
                <from>
48
                    <_units>
49
                        <default>m</default>
50
                        <to>m</to>
51
                        <to></to>
52
                        <value>
53
                            <_rangeStart>
54
                                <value>
55
                                    <_replace>
56
                                        <\bca\.?></\bca\.?>
57
                                        <value>$MinimumElevation</value>
58
                                    </_replace>
59
                                </value>
60
                            </_rangeStart>
61
                        </value>
62
                    </_units>
63
                </from>
64
                <to>
65
                    <_units>
66
                        <default>m</default>
67
                        <to>m</to>
68
                        <to></to>
69
                        <value>
70
                            <_alt>
71
                                <1>
72
                                    <_replace>
73
                                        <\bca\.?></\bca\.?>
74
                                        <value>$MaximumElevation</value>
75
                                    </_replace>
76
                                </1>
77
                                <2>
78
                                    <_rangeEnd>
79
                                        <value>
80
                                            <_replace>
81
                                                <\bca\.?></\bca\.?>
82
                                                <value>$MinimumElevation</value>
83
                                            </_replace>
84
                                        </value>
85
                                    </_rangeEnd>
86
                                </2>
87
                            </_alt>
88
                        </value>
89
                    </_units>
90
                </to>
91
            </_range>
92
        </elevationrange>
93
        <locationdetermination>
94
            <coordsaccuracy><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy>
95
            <latitude>
96
                <_nullIf>
97
                    <null>0</null>
98
                    <type>float</type>
99
                    <value>$Latitude</value>
100
                </_nullIf>
101
            </latitude>
102
            <longitude>
103
                <_nullIf>
104
                    <null>0</null>
105
                    <type>float</type>
106
                    <value>$Longitude</value>
107
                </_nullIf>
108
            </longitude>
109
            <namedplace_id>
110
                <_simplifyPath>
111
                    <next>parent_id/namedplace</next>
112
                    <require>placename</require>
113
                    <path>
114
                        <namedplace>
115
                            <rank>county</rank>
116
                            <placename>$County</placename>
117
                            <parent_id>
118
                                <namedplace>
119
                                    <rank>stateProvince</rank>
120
                                    <placename>$StateProvince</placename>
121
                                    <parent_id>
122
                                        <namedplace>
123
                                            <rank>country</rank>
124
                                            <placename>$Country</placename>
125
                                            <parent_id>
126
                                                <namedplace>
127
                                                    <rank>continent</rank>
128
                                                    <placename>$ContinentOcean</placename>
129
                                                </namedplace>
130
                                            </parent_id>
131
                                        </namedplace>
132
                                    </parent_id>
133
                                </namedplace>
134
                            </parent_id>
135
                        </namedplace>
136
                    </path>
137
                </_simplifyPath>
138
            </namedplace_id>
139
        </locationdetermination>
140
        <locationevent>
141
            <obsenddate>
142
                <_date>
143
                    <date>
144
                        <_dateRangeEnd>
145
                            <value>
146
                                <_date>
147
                                    <day>
148
                                        <_nullIf>
149
                                            <null>0</null>
150
                                            <type>float</type>
151
                                            <value>$DayCollected</value>
152
                                        </_nullIf>
153
                                    </day>
154
                                    <month>
155
                                        <_nullIf>
156
                                            <null>0</null>
157
                                            <type>float</type>
158
                                            <value>$MonthCollected</value>
159
                                        </_nullIf>
160
                                    </month>
161
                                    <year>
162
                                        <_nullIf>
163
                                            <null>0</null>
164
                                            <type>float</type>
165
                                            <value>$YearCollected</value>
166
                                        </_nullIf>
167
                                    </year>
168
                                </_date>
169
                            </value>
170
                        </_dateRangeEnd>
171
                    </date>
172
                </_date>
173
            </obsenddate>
174
            <obsstartdate>
175
                <_date>
176
                    <date>
177
                        <_dateRangeStart>
178
                            <value>
179
                                <_date>
180
                                    <day>
181
                                        <_nullIf>
182
                                            <null>0</null>
183
                                            <type>float</type>
184
                                            <value>$DayCollected</value>
185
                                        </_nullIf>
186
                                    </day>
187
                                    <month>
188
                                        <_nullIf>
189
                                            <null>0</null>
190
                                            <type>float</type>
191
                                            <value>$MonthCollected</value>
192
                                        </_nullIf>
193
                                    </month>
194
                                    <year>
195
                                        <_nullIf>
196
                                            <null>0</null>
197
                                            <type>float</type>
198
                                            <value>$YearCollected</value>
199
                                        </_nullIf>
200
                                    </year>
201
                                </_date>
202
                            </value>
203
                        </_dateRangeStart>
204
                    </date>
205
                </_date>
206
            </obsstartdate>
207
            <taxonoccurrence>
208
                <aggregateoccurrence>
209
                    <collectiondate>
210
                        <_date>
211
                            <date>
212
                                <_date>
213
                                    <day>
214
                                        <_nullIf>
215
                                            <null>0</null>
216
                                            <type>float</type>
217
                                            <value>$DayCollected</value>
218
                                        </_nullIf>
219
                                    </day>
220
                                    <month>
221
                                        <_nullIf>
222
                                            <null>0</null>
223
                                            <type>float</type>
224
                                            <value>$MonthCollected</value>
225
                                        </_nullIf>
226
                                    </month>
227
                                    <year>
228
                                        <_nullIf>
229
                                            <null>0</null>
230
                                            <type>float</type>
231
                                            <value>$YearCollected</value>
232
                                        </_nullIf>
233
                                    </year>
234
                                </_date>
235
                            </date>
236
                        </_date>
237
                    </collectiondate>
238
                    <count>$IndividualCount</count>
239
                    <notes>$Notes</notes>
240
                    <plantobservation>
241
                        <collectionnumber>
242
                            <_alt>
243
                                <1>$CollectorNumber</1>
244
                                <2>$FieldNumber</2>
245
                            </_alt>
246
                        </collectionnumber>
247
                        <definedvalue fkey="tablerecord_id">
248
                            <userdefined_id>
249
                                <userdefined>
250
                                    <tablename>plantobservation</tablename>
251
                                    <userdefinedname>sex</userdefinedname>
252
                                </userdefined>
253
                            </userdefined_id>
254
                            <definedvalue>$Sex</definedvalue>
255
                        </definedvalue>
256
                        <specimenreplicate>
257
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
258
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
259
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
260
                        </specimenreplicate>
261
                    </plantobservation>
262
                </aggregateoccurrence>
263
                <authortaxoncode>
264
                    <_alt>
265
                        <1>
266
                            <_alt>
267
                                <1>$CollectorNumber</1>
268
                                <2>$FieldNumber</2>
269
                            </_alt>
270
                        </1>
271
                        <2>$ScientificName</2>
272
                    </_alt>
273
                </authortaxoncode>
274
                <taxondetermination>
275
                    <isoriginal>true</isoriginal>
276
                    <role>identifier</role>
277
                    <party_id>
278
                        <party>
279
                            <givenname><_namePart><first>$IdentifiedBy</first></_namePart></givenname>
280
                            <middlename><_namePart><middle>$IdentifiedBy</middle></_namePart></middlename>
281
                            <surname><_namePart><last>$IdentifiedBy</last></_namePart></surname>
282
                        </party>
283
                    </party_id>
284
                    <plantconcept_id>
285
                        <plantconcept>
286
                            <plantname_id>
287
                                <_simplifyPath>
288
                                    <next>parent_id/plantname</next>
289
                                    <require>plantname</require>
290
                                    <path>
291
                                        <plantname>
292
                                            <rank>binomial</rank>
293
                                            <plantname>$ScientificName</plantname>
294
                                            <parent_id>
295
                                                <plantname>
296
                                                    <rank>authority</rank>
297
                                                    <plantname>$ScientificNameAuthor</plantname>
298
                                                    <parent_id>
299
                                                        <plantname>
300
                                                            <rank>subspecies</rank>
301
                                                            <plantname>$Subspecies</plantname>
302
                                                            <parent_id>
303
                                                                <plantname>
304
                                                                    <rank>species</rank>
305
                                                                    <plantname>$Species</plantname>
306
                                                                    <parent_id>
307
                                                                        <plantname>
308
                                                                            <rank>genus</rank>
309
                                                                            <plantname>$Genus</plantname>
310
                                                                            <parent_id>
311
                                                                                <plantname>
312
                                                                                    <rank>family</rank>
313
                                                                                    <plantname>$Family</plantname>
314
                                                                                    <parent_id>
315
                                                                                        <plantname>
316
                                                                                            <rank>order</rank>
317
                                                                                            <plantname>$Order</plantname>
318
                                                                                            <parent_id>
319
                                                                                                <plantname>
320
                                                                                                    <rank>class</rank>
321
                                                                                                    <plantname>$Class</plantname>
322
                                                                                                    <parent_id>
323
                                                                                                        <plantname>
324
                                                                                                            <rank>subkingdom</rank>
325
                                                                                                            <plantname>$Phylum</plantname>
326
                                                                                                            <parent_id>
327
                                                                                                                <plantname>
328
                                                                                                                    <rank>kingdom</rank>
329
                                                                                                                    <plantname>$Kingdom</plantname>
330
                                                                                                                </plantname>
331
                                                                                                            </parent_id>
332
                                                                                                        </plantname>
333
                                                                                                    </parent_id>
334
                                                                                                </plantname>
335
                                                                                            </parent_id>
336
                                                                                        </plantname>
337
                                                                                    </parent_id>
338
                                                                                </plantname>
339
                                                                            </parent_id>
340
                                                                        </plantname>
341
                                                                    </parent_id>
342
                                                                </plantname>
343
                                                            </parent_id>
344
                                                        </plantname>
345
                                                    </parent_id>
346
                                                </plantname>
347
                                            </parent_id>
348
                                        </plantname>
349
                                    </path>
350
                                </_simplifyPath>
351
                            </plantname_id>
352
                        </plantconcept>
353
                    </plantconcept_id>
354
                    <determinationdate>
355
                        <_date>
356
                            <date>
357
                                <_dateRangeStart>
358
                                    <value>
359
                                        <_date>
360
                                            <day>
361
                                                <_nullIf>
362
                                                    <null>0</null>
363
                                                    <type>float</type>
364
                                                    <value>$DayIdentified</value>
365
                                                </_nullIf>
366
                                            </day>
367
                                            <month>
368
                                                <_nullIf>
369
                                                    <null>0</null>
370
                                                    <type>float</type>
371
                                                    <value>$MonthIdentified</value>
372
                                                </_nullIf>
373
                                            </month>
374
                                            <year>
375
                                                <_nullIf>
376
                                                    <null>0</null>
377
                                                    <type>float</type>
378
                                                    <value>$YearIdentified</value>
379
                                                </_nullIf>
380
                                            </year>
381
                                        </_date>
382
                                    </value>
383
                                </_dateRangeStart>
384
                            </date>
385
                        </_date>
386
                    </determinationdate>
387
                </taxondetermination>
388
                <verbatimcollectorname>$Collector</verbatimcollectorname>
389
                <voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher>
390
            </taxonoccurrence>
391
            <waterdepth>
392
                <_avg>
393
                    <max>
394
                        <_units>
395
                            <default>m</default>
396
                            <to>m</to>
397
                            <to></to>
398
                            <value>
399
                                <_replace>
400
                                    <\bca\.?></\bca\.?>
401
                                    <value>$MaximumDepth</value>
402
                                </_replace>
403
                            </value>
404
                        </_units>
405
                    </max>
406
                    <min>
407
                        <_units>
408
                            <default>m</default>
409
                            <to>m</to>
410
                            <to></to>
411
                            <value>
412
                                <_replace>
413
                                    <\bca\.?></\bca\.?>
414
                                    <value>$MinimumDepth</value>
415
                                </_replace>
416
                            </value>
417
                        </_units>
418
                    </min>
419
                </_avg>
420
            </waterdepth>
421
        </locationevent>
422
        <locationnarrative>$Locality</locationnarrative>
423
    </location>
424
</VegBIEN>
425
Inserted 47 new rows into database
inputs/NY/test/import.specimens.xml.ref
1
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>
5
            <_alt>
6
                <3>$UniqueNYInternalRecordNumber</3>
7
                <4>
8
                    <_merge>
9
                        <1>$InstitutionCode</1>
10
                        <2>$CollectionCode</2>
11
                        <3>$CatalogNumber</3>
12
                    </_merge>
13
                </4>
14
            </_alt>
15
        </authorlocationcode>
16
        <elevation>
17
            <_avg>
18
                <max>
19
                    <_units>
20
                        <default>m</default>
21
                        <to>m</to>
22
                        <to></to>
23
                        <value>
24
                            <_replace>
25
                                <\bca\.?></\bca\.?>
26
                                <value>$MaximumElevation</value>
27
                            </_replace>
28
                        </value>
29
                    </_units>
30
                </max>
31
                <min>
32
                    <_units>
33
                        <default>m</default>
34
                        <to>m</to>
35
                        <to></to>
36
                        <value>
37
                            <_rangeStart>
38
                                <value>
39
                                    <_replace>
40
                                        <\bca\.?></\bca\.?>
41
                                        <value>
42
                                            <_nullIf>
43
                                                <null>.</null>
44
                                                <value>$MinimumElevation</value>
45
                                            </_nullIf>
46
                                        </value>
47
                                    </_replace>
48
                                </value>
49
                            </_rangeStart>
50
                        </value>
51
                    </_units>
52
                </min>
53
            </_avg>
54
        </elevation>
55
        <elevationrange>
56
            <_range>
57
                <from>
58
                    <_units>
59
                        <default>m</default>
60
                        <to>m</to>
61
                        <to></to>
62
                        <value>
63
                            <_rangeStart>
64
                                <value>
65
                                    <_replace>
66
                                        <\bca\.?></\bca\.?>
67
                                        <value>
68
                                            <_nullIf>
69
                                                <null>.</null>
70
                                                <value>$MinimumElevation</value>
71
                                            </_nullIf>
72
                                        </value>
73
                                    </_replace>
74
                                </value>
75
                            </_rangeStart>
76
                        </value>
77
                    </_units>
78
                </from>
79
                <to>
80
                    <_units>
81
                        <default>m</default>
82
                        <to>m</to>
83
                        <to></to>
84
                        <value>
85
                            <_alt>
86
                                <1>
87
                                    <_replace>
88
                                        <\bca\.?></\bca\.?>
89
                                        <value>$MaximumElevation</value>
90
                                    </_replace>
91
                                </1>
92
                                <2>
93
                                    <_rangeEnd>
94
                                        <value>
95
                                            <_replace>
96
                                                <\bca\.?></\bca\.?>
97
                                                <value>
98
                                                    <_nullIf>
99
                                                        <null>.</null>
100
                                                        <value>$MinimumElevation</value>
101
                                                    </_nullIf>
102
                                                </value>
103
                                            </_replace>
104
                                        </value>
105
                                    </_rangeEnd>
106
                                </2>
107
                            </_alt>
108
                        </value>
109
                    </_units>
110
                </to>
111
            </_range>
112
        </elevationrange>
113
        <locationdetermination>
114
            <coordsaccuracy><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy>
115
            <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
116
            <latitude>
117
                <_nullIf>
118
                    <null>0</null>
119
                    <type>float</type>
120
                    <value>$Latitude</value>
121
                </_nullIf>
122
            </latitude>
123
            <longitude>
124
                <_nullIf>
125
                    <null>0</null>
126
                    <type>float</type>
127
                    <value>$Longitude</value>
128
                </_nullIf>
129
            </longitude>
130
            <namedplace_id>
131
                <_simplifyPath>
132
                    <next>parent_id/namedplace</next>
133
                    <require>placename</require>
134
                    <path>
135
                        <namedplace>
136
                            <rank>county</rank>
137
                            <placename>$County</placename>
138
                            <parent_id>
139
                                <namedplace>
140
                                    <rank>stateProvince</rank>
141
                                    <placename>$StateProvince</placename>
142
                                    <parent_id>
143
                                        <namedplace>
144
                                            <rank>country</rank>
145
                                            <placename>$Country</placename>
146
                                            <parent_id>
147
                                                <namedplace>
148
                                                    <rank>continent</rank>
149
                                                    <placename>$ContinentOcean</placename>
150
                                                </namedplace>
151
                                            </parent_id>
152
                                        </namedplace>
153
                                    </parent_id>
154
                                </namedplace>
155
                            </parent_id>
156
                        </namedplace>
157
                    </path>
158
                </_simplifyPath>
159
            </namedplace_id>
160
        </locationdetermination>
161
        <locationevent>
162
            <obsenddate>
163
                <_date>
164
                    <date>
165
                        <_dateRangeEnd>
166
                            <value>
167
                                <_date>
168
                                    <day>
169
                                        <_nullIf>
170
                                            <null>0</null>
171
                                            <type>float</type>
172
                                            <value>$DayCollected</value>
173
                                        </_nullIf>
174
                                    </day>
175
                                    <month>
176
                                        <_nullIf>
177
                                            <null>0</null>
178
                                            <type>float</type>
179
                                            <value>$MonthCollected</value>
180
                                        </_nullIf>
181
                                    </month>
182
                                    <year>
183
                                        <_nullIf>
184
                                            <null>0</null>
185
                                            <type>float</type>
186
                                            <value>$YearCollected</value>
187
                                        </_nullIf>
188
                                    </year>
189
                                </_date>
190
                            </value>
191
                        </_dateRangeEnd>
192
                    </date>
193
                </_date>
194
            </obsenddate>
195
            <obsstartdate>
196
                <_date>
197
                    <date>
198
                        <_dateRangeStart>
199
                            <value>
200
                                <_date>
201
                                    <day>
202
                                        <_nullIf>
203
                                            <null>0</null>
204
                                            <type>float</type>
205
                                            <value>$DayCollected</value>
206
                                        </_nullIf>
207
                                    </day>
208
                                    <month>
209
                                        <_nullIf>
210
                                            <null>0</null>
211
                                            <type>float</type>
212
                                            <value>$MonthCollected</value>
213
                                        </_nullIf>
214
                                    </month>
215
                                    <year>
216
                                        <_nullIf>
217
                                            <null>0</null>
218
                                            <type>float</type>
219
                                            <value>$YearCollected</value>
220
                                        </_nullIf>
221
                                    </year>
222
                                </_date>
223
                            </value>
224
                        </_dateRangeStart>
225
                    </date>
226
                </_date>
227
            </obsstartdate>
228
            <taxonoccurrence>
229
                <aggregateoccurrence>
230
                    <collectiondate>
231
                        <_date>
232
                            <date>
233
                                <_date>
234
                                    <day>
235
                                        <_nullIf>
236
                                            <null>0</null>
237
                                            <type>float</type>
238
                                            <value>$DayCollected</value>
239
                                        </_nullIf>
240
                                    </day>
241
                                    <month>
242
                                        <_nullIf>
243
                                            <null>0</null>
244
                                            <type>float</type>
245
                                            <value>$MonthCollected</value>
246
                                        </_nullIf>
247
                                    </month>
248
                                    <year>
249
                                        <_nullIf>
250
                                            <null>0</null>
251
                                            <type>float</type>
252
                                            <value>$YearCollected</value>
253
                                        </_nullIf>
254
                                    </year>
255
                                </_date>
256
                            </date>
257
                        </_date>
258
                    </collectiondate>
259
                    <count>$IndividualCount</count>
260
                    <notes>
261
                        <_merge>
262
                            <1>$Notes</1>
263
                            <2>
264
                                <_label>
265
                                    <label>plant fungus</label>
266
                                    <value>$PlantFungusDescription</value>
267
                                </_label>
268
                            </2>
269
                        </_merge>
270
                    </notes>
271
                    <plantobservation>
272
                        <collectionnumber>
273
                            <_alt>
274
                                <1>$CollectorNumber</1>
275
                                <2>$FieldNumber</2>
276
                            </_alt>
277
                        </collectionnumber>
278
                        <definedvalue fkey="tablerecord_id">
279
                            <userdefined_id>
280
                                <userdefined>
281
                                    <tablename>plantobservation</tablename>
282
                                    <userdefinedname>sex</userdefinedname>
283
                                </userdefined>
284
                            </userdefined_id>
285
                            <definedvalue>$Sex</definedvalue>
286
                        </definedvalue>
287
                        <specimenreplicate>
288
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
289
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
290
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
291
                            <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
292
                        </specimenreplicate>
293
                    </plantobservation>
294
                </aggregateoccurrence>
295
                <authortaxoncode>
296
                    <_alt>
297
                        <1>
298
                            <_alt>
299
                                <1>$CollectorNumber</1>
300
                                <2>$FieldNumber</2>
301
                            </_alt>
302
                        </1>
303
                        <2>$ScientificName</2>
304
                    </_alt>
305
                </authortaxoncode>
306
                <taxondetermination>
307
                    <isoriginal>true</isoriginal>
308
                    <role>identifier</role>
309
                    <party_id>
310
                        <party>
311
                            <givenname><_namePart><first>$IdentifiedBy</first></_namePart></givenname>
312
                            <middlename><_namePart><middle>$IdentifiedBy</middle></_namePart></middlename>
313
                            <surname><_namePart><last>$IdentifiedBy</last></_namePart></surname>
314
                        </party>
315
                    </party_id>
316
                    <plantconcept_id>
317
                        <plantconcept>
318
                            <plantname_id>
319
                                <_simplifyPath>
320
                                    <next>parent_id/plantname</next>
321
                                    <require>plantname</require>
322
                                    <path>
323
                                        <plantname>
324
                                            <rank>binomial</rank>
325
                                            <plantname>$ScientificName</plantname>
326
                                            <parent_id>
327
                                                <plantname>
328
                                                    <rank>authority</rank>
329
                                                    <plantname>$ScientificNameAuthor</plantname>
330
                                                    <parent_id>
331
                                                        <plantname>
332
                                                            <rank>subspecies</rank>
333
                                                            <plantname>$Subspecies</plantname>
334
                                                            <parent_id>
335
                                                                <plantname>
336
                                                                    <rank>species</rank>
337
                                                                    <plantname>$Species</plantname>
338
                                                                    <parent_id>
339
                                                                        <plantname>
340
                                                                            <rank>genus</rank>
341
                                                                            <plantname>$Genus</plantname>
342
                                                                            <parent_id>
343
                                                                                <plantname>
344
                                                                                    <rank>family</rank>
345
                                                                                    <plantname>$Family</plantname>
346
                                                                                    <parent_id>
347
                                                                                        <plantname>
348
                                                                                            <rank>order</rank>
349
                                                                                            <plantname>$Order</plantname>
350
                                                                                            <parent_id>
351
                                                                                                <plantname>
352
                                                                                                    <rank>class</rank>
353
                                                                                                    <plantname>$Class</plantname>
354
                                                                                                    <parent_id>
355
                                                                                                        <plantname>
356
                                                                                                            <rank>subkingdom</rank>
357
                                                                                                            <plantname>$Phylum</plantname>
358
                                                                                                            <parent_id>
359
                                                                                                                <plantname>
360
                                                                                                                    <rank>kingdom</rank>
361
                                                                                                                    <plantname>$Kingdom</plantname>
362
                                                                                                                </plantname>
363
                                                                                                            </parent_id>
364
                                                                                                        </plantname>
365
                                                                                                    </parent_id>
366
                                                                                                </plantname>
367
                                                                                            </parent_id>
368
                                                                                        </plantname>
369
                                                                                    </parent_id>
370
                                                                                </plantname>
371
                                                                            </parent_id>
372
                                                                        </plantname>
373
                                                                    </parent_id>
374
                                                                </plantname>
375
                                                            </parent_id>
376
                                                        </plantname>
377
                                                    </parent_id>
378
                                                </plantname>
379
                                            </parent_id>
380
                                        </plantname>
381
                                    </path>
382
                                </_simplifyPath>
383
                            </plantname_id>
384
                        </plantconcept>
385
                    </plantconcept_id>
386
                    <determinationdate>
387
                        <_date>
388
                            <date>
389
                                <_dateRangeStart>
390
                                    <value>
391
                                        <_date>
392
                                            <day>
393
                                                <_nullIf>
394
                                                    <null>0</null>
395
                                                    <type>float</type>
396
                                                    <value>$DayIdentified</value>
397
                                                </_nullIf>
398
                                            </day>
399
                                            <month>
400
                                                <_nullIf>
401
                                                    <null>0</null>
402
                                                    <type>float</type>
403
                                                    <value>$MonthIdentified</value>
404
                                                </_nullIf>
405
                                            </month>
406
                                            <year>
407
                                                <_nullIf>
408
                                                    <null>0</null>
409
                                                    <type>float</type>
410
                                                    <value>$YearIdentified</value>
411
                                                </_nullIf>
412
                                            </year>
413
                                        </_date>
414
                                    </value>
415
                                </_dateRangeStart>
416
                            </date>
417
                        </_date>
418
                    </determinationdate>
419
                </taxondetermination>
420
                <verbatimcollectorname>$Collector</verbatimcollectorname>
421
                <voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher>
422
            </taxonoccurrence>
423
            <waterdepth>
424
                <_avg>
425
                    <max>
426
                        <_units>
427
                            <default>m</default>
428
                            <to>m</to>
429
                            <to></to>
430
                            <value>
431
                                <_replace>
432
                                    <\bca\.?></\bca\.?>
433
                                    <value>$MaximumDepth</value>
434
                                </_replace>
435
                            </value>
436
                        </_units>
437
                    </max>
438
                    <min>
439
                        <_units>
440
                            <default>m</default>
441
                            <to>m</to>
442
                            <to></to>
443
                            <value>
444
                                <_replace>
445
                                    <\bca\.?></\bca\.?>
446
                                    <value>$MinimumDepth</value>
447
                                </_replace>
448
                            </value>
449
                        </_units>
450
                    </min>
451
                </_avg>
452
            </waterdepth>
453
        </locationevent>
454
        <locationnarrative>
455
            <_merge>
456
                <1>
457
                    <_merge>
458
                        <1>$Locality</1>
459
                        <2>
460
                            <_label>
461
                                <label>substrate</label>
462
                                <value>$Substrate</value>
463
                            </_label>
464
                        </2>
465
                        <3>
466
                            <_label>
467
                                <label>vegetation</label>
468
                                <value>$Vegetation</value>
469
                            </_label>
470
                        </3>
471
                    </_merge>
472
                </1>
473
                <3>
474
                    <_label>
475
                        <label>habitat</label>
476
                        <value>$Habitat</value>
477
                    </_label>
478
                </3>
479
            </_merge>
480
        </locationnarrative>
481
    </location>
482
</VegBIEN>
483
Inserted 39 new rows into database
inputs/Madidi/test/import.1.organisms.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 1 new rows into database
inputs/Madidi/test/import.0.plots.xml.ref
1
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <area>$Area</area>
5
        <authorlocationcode>$Inventory name</authorlocationcode>
6
        <elevation>
7
            <_alt>
8
                <1>
9
                    <_replace>
10
                        <\bca\.?></\bca\.?>
11
                        <value>$Altitude</value>
12
                    </_replace>
13
                </1>
14
                <2>
15
                    <_avg>
16
                        <min>
17
                            <_units>
18
                                <default>m</default>
19
                                <to>m</to>
20
                                <to></to>
21
                                <value>
22
                                    <_rangeStart>
23
                                        <value>
24
                                            <_replace>
25
                                                <\bca\.?></\bca\.?>
26
                                                <value>$Minimum altitude</value>
27
                                            </_replace>
28
                                        </value>
29
                                    </_rangeStart>
30
                                </value>
31
                            </_units>
32
                        </min>
33
                    </_avg>
34
                </2>
35
            </_alt>
36
        </elevation>
37
        <elevationrange>
38
            <_range>
39
                <from>
40
                    <_units>
41
                        <default>m</default>
42
                        <to>m</to>
43
                        <to></to>
44
                        <value>
45
                            <_rangeStart>
46
                                <value>
47
                                    <_replace>
48
                                        <\bca\.?></\bca\.?>
49
                                        <value>$Minimum altitude</value>
50
                                    </_replace>
51
                                </value>
52
                            </_rangeStart>
53
                        </value>
54
                    </_units>
55
                </from>
56
                <to>
57
                    <_units>
58
                        <default>m</default>
59
                        <to>m</to>
60
                        <to></to>
61
                        <value>
62
                            <_rangeEnd>
63
                                <value>
64
                                    <_replace>
65
                                        <\bca\.?></\bca\.?>
66
                                        <value>$Minimum altitude</value>
67
                                    </_replace>
68
                                </value>
69
                            </_rangeEnd>
70
                        </value>
71
                    </_units>
72
                </to>
73
            </_range>
74
        </elevationrange>
75
        <landform>$Topographical situation</landform>
76
        <locationdetermination>
77
            <latitude>
78
                <_nullIf>
79
                    <null>0</null>
80
                    <type>float</type>
81
                    <value>
82
                        <_alt>
83
                            <1>$Latitude</1>
84
                            <2>$Latitude (DMS)</2>
85
                        </_alt>
86
                    </value>
87
                </_nullIf>
88
            </latitude>
89
            <longitude>
90
                <_nullIf>
91
                    <null>0</null>
92
                    <type>float</type>
93
                    <value>
94
                        <_alt>
95
                            <1>$Longitude</1>
96
                            <2>$Longitude (DMS)</2>
97
                        </_alt>
98
                    </value>
99
                </_nullIf>
100
            </longitude>
101
        </locationdetermination>
102
        <locationevent>
103
            <project_id>
104
                <project>
105
                    <projectname>$Expedition name</projectname>
106
                    <sourceaccessioncode>$Expedition number</sourceaccessioncode>
107
                </project>
108
            </project_id>
109
            <commclass>
110
                <commdetermination>
111
                    <commconcept_id>
112
                        <commconcept>
113
                            <commname_id><commname><commname>$Vegetation type</commname></commname></commname_id>
114
                            <commdescription>$Locality description</commdescription>
115
                        </commconcept>
116
                    </commconcept_id>
117
                </commdetermination>
118
            </commclass>
119
            <obsstartdate><_date><date><_dateRangeStart><value>$First evaluation</value></_dateRangeStart></date></_date></obsstartdate>
120
            <soilobs>
121
                <acidity>$Acidez intercambiable (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</acidity>
122
                <calcium>$Calcio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.016)</calcium>
123
                <carbon>$Carb&#243;n Org&#225;nico (WSP S-9,10&#8211;%&#8211;0.06)</carbon>
124
                <cationexchangecapacity>$CIC (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</cationexchangecapacity>
125
                <clay>$Arcilla (DIN 18 123&#8211;%&#8211;1)</clay>
126
                <conductivity>$Conductividad electrica (ASPT 6&#8211;&#181;S/cm&#8211; 1 - 10000)</conductivity>
127
                <magnesium>$Magnesio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</magnesium>
128
                <nitrogen>$Nitr&#243;geno total (ISRIC 6&#8211;%&#8211;0.0014)</nitrogen>
129
                <organic>$Materia Org&#225;nica (WSP S-9,10&#8211;%&#8211;0.1)</organic>
130
                <ph>$pH acuoso (ISRIC 4&#8211;&#8211; 1 - 14)</ph>
131
                <phosphorus>$F&#243;sforo disponible (ISRIC 14-2&#8211;mg/Kg&#8211;1.5)</phosphorus>
132
                <potassium>$Potasio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.0053)</potassium>
133
                <sand>$Arena (DIN 18 123&#8211;%&#8211;2.5)</sand>
134
                <silt>$Limo (DIN 18 123&#8211;%&#8211;1)</silt>
135
                <sodium>$Sodio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</sodium>
136
                <texture>$Textural class</texture>
137
            </soilobs>
138
        </locationevent>
139
        <locationnarrative>$Locality</locationnarrative>
140
        <notespublic>$Observaciones</notespublic>
141
        <slopeaspect>
142
            <_compass>
143
                <value>
144
                    <_alt>
145
                        <1>$Direction</1>
146
                        <2>$Orientaci&#243;n/exposicion</2>
147
                    </_alt>
148
                </value>
149
            </_compass>
150
        </slopeaspect>
151
        <slopegradient>$Slope</slopegradient>
152
        <sourceaccessioncode>$Inventory code</sourceaccessioncode>
153
    </location>
154
</VegBIEN>
155
Inserted 19 new rows into database
inputs/UNCC/test/import.specimens.xml.ref
1
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>
5
            <_alt>
6
                <3>$accession</3>
7
                <4>$herbarium</4>
8
            </_alt>
9
        </authorlocationcode>
10
        <locationdetermination>
11
            <namedplace_id>
12
                <_simplifyPath>
13
                    <next>parent_id/namedplace</next>
14
                    <require>placename</require>
15
                    <path>
16
                        <namedplace>
17
                            <rank>county</rank>
18
                            <placename>$county</placename>
19
                            <parent_id>
20
                                <namedplace>
21
                                    <rank>stateProvince</rank>
22
                                    <placename>$state</placename>
23
                                    <parent_id>
24
                                        <namedplace>
25
                                            <rank>country</rank>
26
                                            <placename>$country</placename>
27
                                        </namedplace>
28
                                    </parent_id>
29
                                </namedplace>
30
                            </parent_id>
31
                        </namedplace>
32
                    </path>
33
                </_simplifyPath>
34
            </namedplace_id>
35
        </locationdetermination>
36
        <locationevent>
37
            <obsenddate>
38
                <_date>
39
                    <date>
40
                        <_dateRangeEnd>
41
                            <value>
42
                                <_date>
43
                                    <day>
44
                                        <_nullIf>
45
                                            <null>0</null>
46
                                            <type>float</type>
47
                                            <value>$collday</value>
48
                                        </_nullIf>
49
                                    </day>
50
                                    <month>
51
                                        <_nullIf>
52
                                            <null>0</null>
53
                                            <type>float</type>
54
                                            <value>$collmonth</value>
55
                                        </_nullIf>
56
                                    </month>
57
                                    <year>
58
                                        <_nullIf>
59
                                            <null>0</null>
60
                                            <type>float</type>
61
                                            <value>$collyear</value>
62
                                        </_nullIf>
63
                                    </year>
64
                                </_date>
65
                            </value>
66
                        </_dateRangeEnd>
67
                    </date>
68
                </_date>
69
            </obsenddate>
70
            <obsstartdate>
71
                <_date>
72
                    <date>
73
                        <_dateRangeStart>
74
                            <value>
75
                                <_date>
76
                                    <day>
77
                                        <_nullIf>
78
                                            <null>0</null>
79
                                            <type>float</type>
80
                                            <value>$collday</value>
81
                                        </_nullIf>
82
                                    </day>
83
                                    <month>
84
                                        <_nullIf>
85
                                            <null>0</null>
86
                                            <type>float</type>
87
                                            <value>$collmonth</value>
88
                                        </_nullIf>
89
                                    </month>
90
                                    <year>
91
                                        <_nullIf>
92
                                            <null>0</null>
93
                                            <type>float</type>
94
                                            <value>$collyear</value>
95
                                        </_nullIf>
96
                                    </year>
97
                                </_date>
98
                            </value>
99
                        </_dateRangeStart>
100
                    </date>
101
                </_date>
102
            </obsstartdate>
103
            <taxonoccurrence>
104
                <aggregateoccurrence>
105
                    <collectiondate>
106
                        <_date>
107
                            <date>
108
                                <_date>
109
                                    <day>
110
                                        <_nullIf>
111
                                            <null>0</null>
112
                                            <type>float</type>
113
                                            <value>$collday</value>
114
                                        </_nullIf>
115
                                    </day>
116
                                    <month>
117
                                        <_nullIf>
118
                                            <null>0</null>
119
                                            <type>float</type>
120
                                            <value>$collmonth</value>
121
                                        </_nullIf>
122
                                    </month>
123
                                    <year>
124
                                        <_nullIf>
125
                                            <null>0</null>
126
                                            <type>float</type>
127
                                            <value>$collyear</value>
128
                                        </_nullIf>
129
                                    </year>
130
                                </_date>
131
                            </date>
132
                        </_date>
133
                    </collectiondate>
134
                    <notes>
135
                        <_merge>
136
                            <1>$comment1</1>
137
                            <2>$comment2</2>
138
                            <3>$comment3</3>
139
                            <4>$comment4</4>
140
                            <5>
141
                                <_label>
142
                                    <label>campus</label>
143
                                    <value>$campus</value>
144
                                </_label>
145
                            </5>
146
                            <6>
147
                                <_label>
148
                                    <label>loaned to</label>
149
                                    <value>$loanto</value>
150
                                </_label>
151
                            </6>
152
                            <7>
153
                                <_label>
154
                                    <label>in or out</label>
155
                                    <value>$inorout</value>
156
                                </_label>
157
                            </7>
158
                        </_merge>
159
                    </notes>
160
                    <plantobservation>
161
                        <collectionnumber>$collectno</collectionnumber>
162
                        <specimenreplicate>
163
                            <institution_id><party><organizationname>$herbarium</organizationname></party></institution_id>
164
                            <sourceaccessioncode>$accession</sourceaccessioncode>
165
                        </specimenreplicate>
166
                    </plantobservation>
167
                </aggregateoccurrence>
168
                <authortaxoncode>
169
                    <_alt>
170
                        <1>$collectno</1>
171
                        <2>$SciName</2>
172
                    </_alt>
173
                </authortaxoncode>
174
                <iscultivated>
175
                    <_map>
176
                        <cultivated>t</cultivated>
177
                        <wild>f</wild>
178
                        <*></*>
179
                        <value>
180
                            <_map>
181
                                <Y>cultivated</Y>
182
                                <N>wild</N>
183
                                <*></*>
184
                                <value>$cultivated</value>
185
                            </_map>
186
                        </value>
187
                    </_map>
188
                </iscultivated>
189
                <isnative>
190
                    <_map>
191
                        <native>t</native>
192
                        <exotic>f</exotic>
193
                        <*></*>
194
                        <value>
195
                            <_map>
196
                                <Y>cultivated</Y>
197
                                <N>wild</N>
198
                                <*></*>
199
                                <value>$cultivated</value>
200
                            </_map>
201
                        </value>
202
                    </_map>
203
                </isnative>
204
                <taxondetermination>
205
                    <isoriginal>true</isoriginal>
206
                    <role>identifier</role>
207
                    <plantconcept_id>
208
                        <plantconcept>
209
                            <plantname_id>
210
                                <_simplifyPath>
211
                                    <next>parent_id/plantname</next>
212
                                    <require>plantname</require>
213
                                    <path>
214
                                        <plantname>
215
                                            <rank>binomial</rank>
216
                                            <plantname>$SciName</plantname>
217
                                            <parent_id>
218
                                                <plantname>
219
                                                    <rank>authority</rank>
220
                                                    <plantname>$authors</plantname>
221
                                                    <parent_id>
222
                                                        <plantname>
223
                                                            <rank>subspecies</rank>
224
                                                            <plantname>$infraname</plantname>
225
                                                            <parent_id>
226
                                                                <plantname>
227
                                                                    <rank>species</rank>
228
                                                                    <plantname>$species</plantname>
229
                                                                    <parent_id>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff