Revision 3919
Added by Aaron Marcuse-Kubitza over 12 years ago
| import.specimens.xml.ref | ||
|---|---|---|
| 149 | 149 |
<collectiondate> |
| 150 | 150 |
<_date> |
| 151 | 151 |
<date> |
| 152 |
<_alt> |
|
| 153 |
<0>$VerbatimCollectingDate</0> |
|
| 154 |
<1> |
|
| 155 |
<_date> |
|
| 156 |
<day> |
|
| 157 |
<_nullIf> |
|
| 158 |
<null>0</null> |
|
| 159 |
<type>float</type> |
|
| 160 |
<value>$DayCollected</value> |
|
| 161 |
</_nullIf> |
|
| 162 |
</day> |
|
| 163 |
<month> |
|
| 164 |
<_nullIf> |
|
| 165 |
<null>0</null> |
|
| 166 |
<type>float</type> |
|
| 167 |
<value>$MonthCollected</value> |
|
| 168 |
</_nullIf> |
|
| 169 |
</month> |
|
| 170 |
<year> |
|
| 171 |
<_nullIf> |
|
| 172 |
<null>0</null> |
|
| 173 |
<type>float</type> |
|
| 174 |
<value>$YearCollected</value> |
|
| 175 |
</_nullIf> |
|
| 176 |
</year> |
|
| 177 |
</_date> |
|
| 178 |
</1> |
|
| 179 |
</_alt> |
|
| 152 |
<_dateRangeStart> |
|
| 153 |
<value> |
|
| 154 |
<_alt> |
|
| 155 |
<0>$VerbatimCollectingDate</0> |
|
| 156 |
<1> |
|
| 157 |
<_date> |
|
| 158 |
<day> |
|
| 159 |
<_nullIf> |
|
| 160 |
<null>0</null> |
|
| 161 |
<type>float</type> |
|
| 162 |
<value>$DayCollected</value> |
|
| 163 |
</_nullIf> |
|
| 164 |
</day> |
|
| 165 |
<month> |
|
| 166 |
<_nullIf> |
|
| 167 |
<null>0</null> |
|
| 168 |
<type>float</type> |
|
| 169 |
<value>$MonthCollected</value> |
|
| 170 |
</_nullIf> |
|
| 171 |
</month> |
|
| 172 |
<year> |
|
| 173 |
<_nullIf> |
|
| 174 |
<null>0</null> |
|
| 175 |
<type>float</type> |
|
| 176 |
<value>$YearCollected</value> |
|
| 177 |
</_nullIf> |
|
| 178 |
</year> |
|
| 179 |
</_date> |
|
| 180 |
</1> |
|
| 181 |
</_alt> |
|
| 182 |
</value> |
|
| 183 |
</_dateRangeStart> |
|
| 180 | 184 |
</date> |
| 181 | 185 |
</_date> |
| 182 | 186 |
</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.)