Project

General

Profile

« Previous | Next » 

Revision 3199

VegBIEN: Fixing import issue related to duplicate entries in tables with children, where when a new table entry duplicates an existing entry, the 1:1 tables of that table and those tables' children are not merged, causing them to become orphaned. It is described in detail at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Import_issues#Merging-duplicates-with-children&gt;, including the rationale for this solution. Note that this is not a bug in column-based import, it applies to row-based import as well. This commit fixes the issue for specimenreplicate->taxonoccurrence.

View differences:

VegBIEN.specimens.xml.ref
1 1
<?xml version="1.0" ?>
2 2
<VegBIEN>
3 3
    <specimenreplicate id="0">
4
        <taxonoccurrence_id>
5
            <taxonoccurrence>
6
                <locationevent_id>
7
                    <locationevent>
8
                        <location_id>
9
                            <location>
10
                                <locationdetermination>
11
                                    <namedplace_id>
12
                                        <namedplace>
13
                                            <rank>country</rank>
14
                                            <placename>French Guiana</placename>
15
                                        </namedplace>
16
                                    </namedplace_id>
17
                                    <latitude>4.933333333</latitude>
18
                                    <longitude>-52.33333333</longitude>
19
                                </locationdetermination>
20
                                <locationnarrative>Cayenne, Ile de Cayenne</locationnarrative>
21
                                <centerlatitude>4.933333333</centerlatitude>
22
                                <centerlongitude>-52.33333333</centerlongitude>
23
                            </location>
24
                        </location_id>
25
                        <obsstartdate>1969-09-21</obsstartdate>
26
                        <obsenddate/>
27
                    </locationevent>
28
                </locationevent_id>
29
                <taxondetermination>
30
                    <role>identifier</role>
31
                    <determinationdate>1979-01-01</determinationdate>
32
                    <iscurrent>true</iscurrent>
33
                    <party_id>
34
                        <party>
35
                            <givenname>Wasshausen,</givenname>
36
                            <middlename></middlename>
37
                            <surname>D.C.</surname>
38
                        </party>
39
                    </party_id>
40
                    <isoriginal>true</isoriginal>
41
                    <plantconcept_id>
42
                        <plantconcept>
43
                            <plantname_id>
4
        <locationevent_id>
5
            <locationevent>
6
                <location_id>
7
                    <location>
8
                        <locationdetermination>
9
                            <namedplace_id>
10
                                <namedplace>
11
                                    <rank>country</rank>
12
                                    <placename>French Guiana</placename>
13
                                </namedplace>
14
                            </namedplace_id>
15
                            <latitude>4.933333333</latitude>
16
                            <longitude>-52.33333333</longitude>
17
                        </locationdetermination>
18
                        <locationnarrative>Cayenne, Ile de Cayenne</locationnarrative>
19
                        <centerlatitude>4.933333333</centerlatitude>
20
                        <centerlongitude>-52.33333333</centerlongitude>
21
                    </location>
22
                </location_id>
23
                <obsstartdate>1969-09-21</obsstartdate>
24
                <obsenddate/>
25
            </locationevent>
26
        </locationevent_id>
27
        <taxondetermination>
28
            <role>identifier</role>
29
            <determinationdate>1979-01-01</determinationdate>
30
            <iscurrent>true</iscurrent>
31
            <party_id>
32
                <party>
33
                    <givenname>Wasshausen,</givenname>
34
                    <middlename></middlename>
35
                    <surname>D.C.</surname>
36
                </party>
37
            </party_id>
38
            <isoriginal>true</isoriginal>
39
            <plantconcept_id>
40
                <plantconcept>
41
                    <plantname_id>
42
                        <plantname>
43
                            <rank>genus</rank>
44
                            <plantname>Justicia pectoralis</plantname>
45
                            <parent_id>
44 46
                                <plantname>
45
                                    <rank>genus</rank>
46
                                    <plantname>Justicia pectoralis</plantname>
47
                                    <parent_id>
48
                                        <plantname>
49
                                            <rank>family</rank>
50
                                            <plantname>Acanthaceae</plantname>
51
                                        </plantname>
52
                                    </parent_id>
47
                                    <rank>family</rank>
48
                                    <plantname>Acanthaceae</plantname>
53 49
                                </plantname>
54
                            </plantname_id>
55
                        </plantconcept>
56
                    </plantconcept_id>
57
                </taxondetermination>
58
                <verbatimcollectorname>Burgot, S.J.</verbatimcollectorname>
59
            </taxonoccurrence>
60
        </taxonoccurrence_id>
50
                            </parent_id>
51
                        </plantname>
52
                    </plantname_id>
53
                </plantconcept>
54
            </plantconcept_id>
55
        </taxondetermination>
56
        <verbatimcollectorname>Burgot, S.J.</verbatimcollectorname>
61 57
        <datasource_id><party><organizationname>U</organizationname></party></datasource_id>
62 58
        <catalognumber_dwc>U  0125259</catalognumber_dwc>
59
        <collectionnumber>7</collectionnumber>
63 60
        <sourceaccessioncode>2225</sourceaccessioncode>
64
        <collectionnumber>7</collectionnumber>
65 61
    </specimenreplicate>
66 62
    <specimenreplicate id="1">
67
        <taxonoccurrence_id>
68
            <taxonoccurrence>
69
                <locationevent_id>
70
                    <locationevent>
71
                        <location_id>
72
                            <location>
73
                                <locationdetermination>
74
                                    <namedplace_id>
75
                                        <namedplace>
76
                                            <rank>country</rank>
77
                                            <placename>French Guiana</placename>
78
                                        </namedplace>
79
                                    </namedplace_id>
80
                                    <latitude>4.933333333</latitude>
81
                                    <longitude>-52.33333333</longitude>
82
                                </locationdetermination>
83
                                <locationnarrative>Cayenne, Ile de Cayenne</locationnarrative>
84
                                <centerlatitude>4.933333333</centerlatitude>
85
                                <centerlongitude>-52.33333333</centerlongitude>
86
                            </location>
87
                        </location_id>
88
                        <obsstartdate>1970-09-21</obsstartdate>
89
                        <obsenddate/>
90
                    </locationevent>
91
                </locationevent_id>
92
                <taxondetermination>
93
                    <isoriginal>true</isoriginal>
94
                    <iscurrent>true</iscurrent>
95
                    <role>identifier</role>
96
                    <plantconcept_id>
97
                        <plantconcept>
98
                            <plantname_id>
63
        <locationevent_id>
64
            <locationevent>
65
                <location_id>
66
                    <location>
67
                        <locationdetermination>
68
                            <namedplace_id>
69
                                <namedplace>
70
                                    <rank>country</rank>
71
                                    <placename>French Guiana</placename>
72
                                </namedplace>
73
                            </namedplace_id>
74
                            <latitude>4.933333333</latitude>
75
                            <longitude>-52.33333333</longitude>
76
                        </locationdetermination>
77
                        <locationnarrative>Cayenne, Ile de Cayenne</locationnarrative>
78
                        <centerlatitude>4.933333333</centerlatitude>
79
                        <centerlongitude>-52.33333333</centerlongitude>
80
                    </location>
81
                </location_id>
82
                <obsstartdate>1970-09-21</obsstartdate>
83
                <obsenddate/>
84
            </locationevent>
85
        </locationevent_id>
86
        <taxondetermination>
87
            <isoriginal>true</isoriginal>
88
            <iscurrent>true</iscurrent>
89
            <role>identifier</role>
90
            <plantconcept_id>
91
                <plantconcept>
92
                    <plantname_id>
93
                        <plantname>
94
                            <rank>genus</rank>
95
                            <plantname>Capraria biflora</plantname>
96
                            <parent_id>
99 97
                                <plantname>
100
                                    <rank>genus</rank>
101
                                    <plantname>Capraria biflora</plantname>
102
                                    <parent_id>
103
                                        <plantname>
104
                                            <rank>family</rank>
105
                                            <plantname>Scrophulariaceae</plantname>
106
                                        </plantname>
107
                                    </parent_id>
98
                                    <rank>family</rank>
99
                                    <plantname>Scrophulariaceae</plantname>
108 100
                                </plantname>
109
                            </plantname_id>
110
                        </plantconcept>
111
                    </plantconcept_id>
112
                </taxondetermination>
113
                <verbatimcollectorname>Burgot, S.J.</verbatimcollectorname>
114
            </taxonoccurrence>
115
        </taxonoccurrence_id>
101
                            </parent_id>
102
                        </plantname>
103
                    </plantname_id>
104
                </plantconcept>
105
            </plantconcept_id>
106
        </taxondetermination>
107
        <verbatimcollectorname>Burgot, S.J.</verbatimcollectorname>
116 108
        <datasource_id><party><organizationname>U</organizationname></party></datasource_id>
117 109
        <catalognumber_dwc>U  0233032</catalognumber_dwc>
110
        <collectionnumber>5</collectionnumber>
118 111
        <sourceaccessioncode>44268708</sourceaccessioncode>
119
        <collectionnumber>5</collectionnumber>
120 112
    </specimenreplicate>
121 113
</VegBIEN>

Also available in: Unified diff