Project

General

Profile

« Previous | Next » 

Revision 3919

Added by Aaron Marcuse-Kubitza over 12 years ago

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.)

View differences:

import.specimens.xml.ref
53 53 
                    <collectiondate>
54 54 
                        <_date>
55 55 
                            <date>
56 
                                <_alt>
57 
                                    <1>
58 
                                        <_date>
59 
                                            <day>
60 
                                                <_nullIf>
61 
                                                    <null>0</null>
62 
                                                    <type>float</type>
63 
                                                    <value>$Colldd</value>
64 
                                                </_nullIf>
65 
                                            </day>
66 
                                            <month>
67 
                                                <_nullIf>
68 
                                                    <null>0</null>
69 
                                                    <type>float</type>
70 
                                                    <value>$Collmm</value>
71 
                                                </_nullIf>
72 
                                            </month>
73 
                                            <year>
74 
                                                <_nullIf>
75 
                                                    <null>0</null>
76 
                                                    <type>float</type>
77 
                                                    <value>$Collyy</value>
78 
                                                </_nullIf>
79 
                                            </year>
80 
                                        </_date>
81 
                                    </1>
82 
                                </_alt>
56 
                                <_dateRangeStart>
57 
                                    <value>
58 
                                        <_alt>
59 
                                            <1>
60 
                                                <_date>
61 
                                                    <day>
62 
                                                        <_nullIf>
63 
                                                            <null>0</null>
64 
                                                            <type>float</type>
65 
                                                            <value>$Colldd</value>
66 
                                                        </_nullIf>
67 
                                                    </day>
68 
                                                    <month>
69 
                                                        <_nullIf>
70 
                                                            <null>0</null>
71 
                                                            <type>float</type>
72 
                                                            <value>$Collmm</value>
73 
                                                        </_nullIf>
74 
                                                    </month>
75 
                                                    <year>
76 
                                                        <_nullIf>
77 
                                                            <null>0</null>
78 
                                                            <type>float</type>
79 
                                                            <value>$Collyy</value>
80 
                                                        </_nullIf>
81 
                                                    </year>
82 
                                                </_date>
83 
                                            </1>
84 
                                        </_alt>
85 
                                    </value>
86 
                                </_dateRangeStart>
83 87 
                            </date>
84 88 
                        </_date>
85 89 
                    </collectiondate>

Also available in: Unified diff