Project

General

Profile

« Previous | Next » 

Revision 3203

Added by Aaron Marcuse-Kubitza over 12 years ago

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->...->location, by also mapping specimenreplicate's unique keys to location.sourceaccessioncode and setting location.datasource_id.

View differences:

VegBIEN.specimens.xml.ref
1 1 
<?xml version="1.0" ?>
2 2 
<VegBIEN>
3 3 
    <specimenreplicate id="0">
4 
        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>
4 5 
        <locationevent_id>
5 6 
            <locationevent>
6 7 
                <location_id>
7 8 
                    <location>
9 
                        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>
8 10 
                        <locationdetermination>
9 11 
                            <namedplace_id>
10 12 
                                <namedplace>
......
25 27 
                                </namedplace>
26 28 
                            </namedplace_id>
27 29 
                        </locationdetermination>
30 
                        <sourceaccessioncode>0</sourceaccessioncode>
28 31 
                    </location>
29 32 
                </location_id>
30 33 
                <obsstartdate>1994-06-25</obsstartdate>
31 34 
                <obsenddate/>
32 35 
            </locationevent>
33 36 
        </locationevent_id>
34 
        <collectioncode_dwc>NCU</collectioncode_dwc>
35 37 
        <taxondetermination>
36 38 
            <isoriginal>true</isoriginal>
37 39 
            <iscurrent>true</iscurrent>
......
47 49 
                </plantconcept>
48 50 
            </plantconcept_id>
49 51 
        </taxondetermination>
52 
        <catalognumber_dwc>NCU00090254</catalognumber_dwc>
53 
        <collectioncode_dwc>NCU</collectioncode_dwc>
50 54 
        <growthform/>
51 55 
        <iscultivated>f</iscultivated>
52 56 
        <isnative/>
53 
        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>
54 
        <catalognumber_dwc>NCU00090254</catalognumber_dwc>
55 57 
        <sourceaccessioncode>0</sourceaccessioncode>
56 58 
    </specimenreplicate>
57 59 
    <specimenreplicate id="1">
60 
        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>
58 61 
        <locationevent_id>
59 62 
            <locationevent>
60 63 
                <location_id>
61 64 
                    <location>
65 
                        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>
62 66 
                        <locationdetermination>
63 67 
                            <coordsaccuracy>1000</coordsaccuracy>
64 68 
                            <namedplace_id>
......
84 88 
                        </locationdetermination>
85 89 
                        <centerlatitude>35.1611111</centerlatitude>
86 90 
                        <centerlongitude>-79.3486111</centerlongitude>
91 
                        <sourceaccessioncode>1</sourceaccessioncode>
87 92 
                    </location>
88 93 
                </location_id>
89 94 
                <obsstartdate>1965-05-08</obsstartdate>
90 95 
                <obsenddate/>
91 96 
            </locationevent>
92 97 
        </locationevent_id>
93 
        <collectioncode_dwc>WEWO</collectioncode_dwc>
94 98 
        <taxondetermination>
95 99 
            <isoriginal>true</isoriginal>
96 100 
            <iscurrent>true</iscurrent>
......
106 110 
                </plantconcept>
107 111 
            </plantconcept_id>
108 112 
        </taxondetermination>
113 
        <collectioncode_dwc>WEWO</collectioncode_dwc>
109 114 
        <growthform/>
110 115 
        <iscultivated>f</iscultivated>
111 116 
        <isnative/>
112 
        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>
113 117 
        <sourceaccessioncode>1</sourceaccessioncode>
114 118 
    </specimenreplicate>
115 119 
</VegBIEN>

Also available in: Unified diff