Revision 3919
Added by Aaron Marcuse-Kubitza over 12 years ago
| import.specimens.xml.ref | ||
|---|---|---|
| 138 | 138 |
<collectiondate> |
| 139 | 139 |
<_date> |
| 140 | 140 |
<date> |
| 141 |
<_alt> |
|
| 142 |
<1> |
|
| 143 |
<_date> |
|
| 144 |
<day> |
|
| 145 |
<_nullIf> |
|
| 146 |
<null>0</null> |
|
| 147 |
<type>float</type> |
|
| 148 |
<value>$DayCollected</value> |
|
| 149 |
</_nullIf> |
|
| 150 |
</day> |
|
| 151 |
<month> |
|
| 152 |
<_nullIf> |
|
| 153 |
<null>0</null> |
|
| 154 |
<type>float</type> |
|
| 155 |
<value>$MonthCollected</value> |
|
| 156 |
</_nullIf> |
|
| 157 |
</month> |
|
| 158 |
<year> |
|
| 159 |
<_nullIf> |
|
| 160 |
<null>0</null> |
|
| 161 |
<type>float</type> |
|
| 162 |
<value>$YearCollected</value> |
|
| 163 |
</_nullIf> |
|
| 164 |
</year> |
|
| 165 |
</_date> |
|
| 166 |
</1> |
|
| 167 |
</_alt> |
|
| 141 |
<_dateRangeStart> |
|
| 142 |
<value> |
|
| 143 |
<_alt> |
|
| 144 |
<1> |
|
| 145 |
<_date> |
|
| 146 |
<day> |
|
| 147 |
<_nullIf> |
|
| 148 |
<null>0</null> |
|
| 149 |
<type>float</type> |
|
| 150 |
<value>$DayCollected</value> |
|
| 151 |
</_nullIf> |
|
| 152 |
</day> |
|
| 153 |
<month> |
|
| 154 |
<_nullIf> |
|
| 155 |
<null>0</null> |
|
| 156 |
<type>float</type> |
|
| 157 |
<value>$MonthCollected</value> |
|
| 158 |
</_nullIf> |
|
| 159 |
</month> |
|
| 160 |
<year> |
|
| 161 |
<_nullIf> |
|
| 162 |
<null>0</null> |
|
| 163 |
<type>float</type> |
|
| 164 |
<value>$YearCollected</value> |
|
| 165 |
</_nullIf> |
|
| 166 |
</year> |
|
| 167 |
</_date> |
|
| 168 |
</1> |
|
| 169 |
</_alt> |
|
| 170 |
</value> |
|
| 171 |
</_dateRangeStart> |
|
| 168 | 172 |
</date> |
| 169 | 173 |
</_date> |
| 170 | 174 |
</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.)