Revision 3919
Added by Aaron Marcuse-Kubitza over 12 years ago
| import.specimens.xml.ref | ||
|---|---|---|
| 33 | 33 |
<collectiondate> |
| 34 | 34 |
<_date> |
| 35 | 35 |
<date> |
| 36 |
<_alt> |
|
| 37 |
<1> |
|
| 38 |
<_date> |
|
| 39 |
<day> |
|
| 40 |
<_nullIf> |
|
| 41 |
<null>0</null> |
|
| 42 |
<type>float</type> |
|
| 43 |
<value>$collday</value> |
|
| 44 |
</_nullIf> |
|
| 45 |
</day> |
|
| 46 |
<month> |
|
| 47 |
<_nullIf> |
|
| 48 |
<null>0</null> |
|
| 49 |
<type>float</type> |
|
| 50 |
<value>$collmonth</value> |
|
| 51 |
</_nullIf> |
|
| 52 |
</month> |
|
| 53 |
<year> |
|
| 54 |
<_nullIf> |
|
| 55 |
<null>0</null> |
|
| 56 |
<type>float</type> |
|
| 57 |
<value>$collyear</value> |
|
| 58 |
</_nullIf> |
|
| 59 |
</year> |
|
| 60 |
</_date> |
|
| 61 |
</1> |
|
| 62 |
</_alt> |
|
| 36 |
<_dateRangeStart> |
|
| 37 |
<value> |
|
| 38 |
<_alt> |
|
| 39 |
<1> |
|
| 40 |
<_date> |
|
| 41 |
<day> |
|
| 42 |
<_nullIf> |
|
| 43 |
<null>0</null> |
|
| 44 |
<type>float</type> |
|
| 45 |
<value>$collday</value> |
|
| 46 |
</_nullIf> |
|
| 47 |
</day> |
|
| 48 |
<month> |
|
| 49 |
<_nullIf> |
|
| 50 |
<null>0</null> |
|
| 51 |
<type>float</type> |
|
| 52 |
<value>$collmonth</value> |
|
| 53 |
</_nullIf> |
|
| 54 |
</month> |
|
| 55 |
<year> |
|
| 56 |
<_nullIf> |
|
| 57 |
<null>0</null> |
|
| 58 |
<type>float</type> |
|
| 59 |
<value>$collyear</value> |
|
| 60 |
</_nullIf> |
|
| 61 |
</year> |
|
| 62 |
</_date> |
|
| 63 |
</1> |
|
| 64 |
</_alt> |
|
| 65 |
</value> |
|
| 66 |
</_dateRangeStart> |
|
| 63 | 67 |
</date> |
| 64 | 68 |
</_date> |
| 65 | 69 |
</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.)