Project

General

Profile

« Previous | Next » 

Revision 3203

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>MT</organizationname></party></datasource_id>
4 5
        <locationevent_id>
5 6
            <locationevent>
6 7
                <location_id>
7 8
                    <location>
9
                        <datasource_id><party><organizationname>MT</organizationname></party></datasource_id>
8 10
                        <locationdetermination>
9 11
                            <namedplace_id>
10 12
                                <namedplace>
......
14 16
                            </namedplace_id>
15 17
                        </locationdetermination>
16 18
                        <locationnarrative>Canada</locationnarrative>
19
                        <sourceaccessioncode>1</sourceaccessioncode>
17 20
                    </location>
18 21
                </location_id>
19 22
            </locationevent>
20 23
        </locationevent_id>
21
        <collectioncode_dwc>MT</collectioncode_dwc>
24
        <collectionnumber>urn:lsid:biocol.org:col:14437</collectionnumber>
22 25
        <taxondetermination>
23 26
            <isoriginal>true</isoriginal>
24 27
            <iscurrent>true</iscurrent>
......
40 43
                </plantconcept>
41 44
            </plantconcept_id>
42 45
        </taxondetermination>
43
        <datasource_id><party><organizationname>MT</organizationname></party></datasource_id>
44
        <collectionnumber>urn:lsid:biocol.org:col:14437</collectionnumber>
46
        <collectioncode_dwc>MT</collectioncode_dwc>
45 47
        <institution_id><party><organizationname>Universit&#233; de Montr&#233;al Biodiversity Centre</organizationname></party></institution_id>
46 48
        <sourceaccessioncode>1</sourceaccessioncode>
47 49
    </specimenreplicate>
48 50
    <specimenreplicate id="1">
51
        <datasource_id><party><organizationname>MT</organizationname></party></datasource_id>
49 52
        <locationevent_id>
50 53
            <locationevent>
51 54
                <location_id>
52 55
                    <location>
56
                        <datasource_id><party><organizationname>MT</organizationname></party></datasource_id>
53 57
                        <locationdetermination>
54 58
                            <namedplace_id>
55 59
                                <namedplace>
......
59 63
                            </namedplace_id>
60 64
                        </locationdetermination>
61 65
                        <locationnarrative>Canada</locationnarrative>
66
                        <sourceaccessioncode>2</sourceaccessioncode>
62 67
                    </location>
63 68
                </location_id>
64 69
            </locationevent>
65 70
        </locationevent_id>
66
        <collectioncode_dwc>MT</collectioncode_dwc>
71
        <collectionnumber>urn:lsid:biocol.org:col:14437</collectionnumber>
67 72
        <taxondetermination>
68 73
            <isoriginal>true</isoriginal>
69 74
            <iscurrent>true</iscurrent>
......
85 90
                </plantconcept>
86 91
            </plantconcept_id>
87 92
        </taxondetermination>
88
        <datasource_id><party><organizationname>MT</organizationname></party></datasource_id>
89
        <collectionnumber>urn:lsid:biocol.org:col:14437</collectionnumber>
93
        <collectioncode_dwc>MT</collectioncode_dwc>
90 94
        <institution_id><party><organizationname>Universit&#233; de Montr&#233;al Biodiversity Centre</organizationname></party></institution_id>
91 95
        <sourceaccessioncode>2</sourceaccessioncode>
92 96
    </specimenreplicate>

Also available in: Unified diff