Project

General

Profile

« Previous | Next » 

Revision 12960

Added by Aaron Marcuse-Kubitza almost 11 years ago

bugfix: inputs/NY/Ecatalog_all/map.csv: can't use CatalogNumber as pkey because it's not unique and not always populated. this fixes the NY NULL accessionNumbers bug (wiki.vegpath.org/Aggregating_validations_status#bugs).

View differences:

trunk/inputs/NY/Ecatalog_all/map.csv
1 1 
NY,VegCore,Filter,Comments
2 
pkey,OMIT#pkey,,"CatalogNumber, etc. is a better pkey"
3 
key,OMIT#key,,"CatalogNumber, etc. is a better pkey"
2 
pkey,dataProviderRecordID,,
3 
key,OMIT#key,,not unique between subtables. use pkey instead.
4 4 
DateLastModified,modified,,
5 5 
InstitutionCode,specimen_duplicate_institutions,,
6 6 
CollectionCode,collection,,
7 
CatalogNumber,accessionNumber,,
7 
CatalogNumber,accessionNumber,,"not unique and not always populated, so can't be used as pkey"
8 8 
ScientificName,taxonName,,
9 9 
BasisOfRecord,basisOfRecord,,
10 10 
Kingdom,kingdom,,
trunk/inputs/NY/Ecatalog_all/test.xml.ref
8 8 
                <path>
9 9 
                    <location>
10 10 
                        <authorlocationcode>
11 
                            <_join>
12 
                                <1>$specimen_duplicate_institutions</1>
13 
                                <2>$collection</2>
14 
                                <3>$accessionNumber</3>
15 
                            </_join>
11 
                            <_alt>
12 
                                <1>$dataProviderRecordID</1>
13 
                                <2>
14 
                                    <_join>
15 
                                        <1>$specimen_duplicate_institutions</1>
16 
                                        <2>$collection</2>
17 
                                        <3>$accessionNumber</3>
18 
                                    </_join>
19 
                                </2>
20 
                            </_alt>
16 21 
                        </authorlocationcode>
17 22 
                        <elevation_m>
18 23 
                            <_avg>
......
89 94 
                                                        </sourcename>
90 95 
                                                    </sourcelist>
91 96 
                                                </duplicate_institutions_sourcelist_id>
97 
                                                <sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>
92 98 
                                            </specimenreplicate>
93 99 
                                        </plantobservation>
94 100 
                                    </aggregateoccurrence>
95 101 
                                    <collector_id><party><fullname>$recordedBy</fullname></party></collector_id>
102 
                                    <sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>
96 103 
                                    <taxondetermination>
97 104 
                                        <party_id><party><fullname>$identifiedBy</fullname></party></party_id>
98 105 
                                        <taxonverbatim_id>
trunk/inputs/NY/Ecatalog_all/new_terms.csv
1 
pkey,OMIT#pkey,,"CatalogNumber, etc. is a better pkey"
2 
key,OMIT#key,,"CatalogNumber, etc. is a better pkey"
1 
pkey,dataProviderRecordID,,
2 
key,OMIT#key,,not unique between subtables. use pkey instead.
3 3 
PlantFungDescription,specimenDescription,,"PlantFung confusingly refers to the plant/fungus the specimen came from, rather than to a fungus growing on the plant"
4 4 
UniqueNYInternalRecordNumber,OMIT#UniqueNYInternalRecordNumber,,Sometimes duplicated. Omitted to avoid confusion since this is an internal-only ID.

Also available in: Unified diff