Revision 3919
Added by Aaron Marcuse-Kubitza over 12 years ago
| import.specimens.xml.ref | ||
|---|---|---|
| 218 | 218 |
<collectiondate> |
| 219 | 219 |
<_date> |
| 220 | 220 |
<date> |
| 221 |
<_alt> |
|
| 222 |
<1> |
|
| 223 |
<_date> |
|
| 224 |
<day> |
|
| 225 |
<_nullIf> |
|
| 226 |
<null>0</null> |
|
| 227 |
<type>float</type> |
|
| 228 |
<value>$conceptual_darwin_2003_1_0_DayCollected</value> |
|
| 229 |
</_nullIf> |
|
| 230 |
</day> |
|
| 231 |
<month> |
|
| 232 |
<_nullIf> |
|
| 233 |
<null>0</null> |
|
| 234 |
<type>float</type> |
|
| 235 |
<value>$conceptual_darwin_2003_1_0_MonthCollected</value> |
|
| 236 |
</_nullIf> |
|
| 237 |
</month> |
|
| 238 |
<year> |
|
| 239 |
<_nullIf> |
|
| 240 |
<null>0</null> |
|
| 241 |
<type>float</type> |
|
| 242 |
<value>$conceptual_darwin_2003_1_0_YearCollected</value> |
|
| 243 |
</_nullIf> |
|
| 244 |
</year> |
|
| 245 |
</_date> |
|
| 246 |
</1> |
|
| 247 |
</_alt> |
|
| 221 |
<_dateRangeStart> |
|
| 222 |
<value> |
|
| 223 |
<_alt> |
|
| 224 |
<1> |
|
| 225 |
<_date> |
|
| 226 |
<day> |
|
| 227 |
<_nullIf> |
|
| 228 |
<null>0</null> |
|
| 229 |
<type>float</type> |
|
| 230 |
<value>$conceptual_darwin_2003_1_0_DayCollected</value> |
|
| 231 |
</_nullIf> |
|
| 232 |
</day> |
|
| 233 |
<month> |
|
| 234 |
<_nullIf> |
|
| 235 |
<null>0</null> |
|
| 236 |
<type>float</type> |
|
| 237 |
<value>$conceptual_darwin_2003_1_0_MonthCollected</value> |
|
| 238 |
</_nullIf> |
|
| 239 |
</month> |
|
| 240 |
<year> |
|
| 241 |
<_nullIf> |
|
| 242 |
<null>0</null> |
|
| 243 |
<type>float</type> |
|
| 244 |
<value>$conceptual_darwin_2003_1_0_YearCollected</value> |
|
| 245 |
</_nullIf> |
|
| 246 |
</year> |
|
| 247 |
</_date> |
|
| 248 |
</1> |
|
| 249 |
</_alt> |
|
| 250 |
</value> |
|
| 251 |
</_dateRangeStart> |
|
| 248 | 252 |
</date> |
| 249 | 253 |
</_date> |
| 250 | 254 |
</collectiondate> |
Also available in: Unified diff
VegBIEN mappings: Wrapped dates in _date() and _dateRangeStart()/_dateRangeEnd(), to assist in importing date and date range values that PostgreSQL cannot parse. This will increase the import time, but hopefully also decrease the # of invalid values in the errors tables. (These functions can later be optimized to reduce the impact on import time.)