Project

General

Profile

« Previous | Next » 

Revision 1825

Added by Aaron Marcuse-Kubitza almost 13 years ago

inputs/CTFS/maps/VegX.organisms.csv: Corrected CensusNumber input mapping

View differences:

inputs/CTFS/test/VegX.organisms.xml.ref
7 7 
                <relativeX>-79.846886</relativeX>
8 8 
                <relativeY>9.153624</relativeY>
9 9 
            </relativePlotPosition>
10 
            <simpleUserdefined>
11 
                <name>censusNo</name>
12 
                <value>1</value>
13 
            </simpleUserdefined>
10 14 
        </individualOrganismObservation>
11 15 
    </individualOrganismObservations>
12 16 
    <plotObservations>
......
20 24 
                <relativeX>-79.846913</relativeX>
21 25 
                <relativeY>9.153683</relativeY>
22 26 
            </relativePlotPosition>
27 
            <simpleUserdefined>
28 
                <name>censusNo</name>
29 
                <value>1</value>
30 
            </simpleUserdefined>
23 31 
        </individualOrganismObservation>
24 32 
    </individualOrganismObservations>
25 33 
</VegX>
inputs/CTFS/test/VegBIEN.organisms.xml.ref
11 11 
                    </stemobservation>
12 12 
                </plantobservation>
13 13 
            </plantobservation_id>
14 
            <definedvalue fkey="tablerecord_id">
15 
                <userdefined_id>
16 
                    <userdefined>
17 
                        <tablename>aggregateoccurrence</tablename>
18 
                        <userdefinedname>censusNo</userdefinedname>
19 
                    </userdefined>
20 
                </userdefined_id>
21 
                <definedvalue>1</definedvalue>
22 
            </definedvalue>
14 23 
        </aggregateoccurrence>
15 24 
    </taxonoccurrence>
16 25 
    <taxonoccurrence id="1">
......
24 33 
                    </stemobservation>
25 34 
                </plantobservation>
26 35 
            </plantobservation_id>
36 
            <definedvalue fkey="tablerecord_id">
37 
                <userdefined_id>
38 
                    <userdefined>
39 
                        <tablename>aggregateoccurrence</tablename>
40 
                        <userdefinedname>censusNo</userdefinedname>
41 
                    </userdefined>
42 
                </userdefined_id>
43 
                <definedvalue>1</definedvalue>
44 
            </definedvalue>
27 45 
        </aggregateoccurrence>
28 46 
    </taxonoccurrence>
29 47 
</VegBIEN>
inputs/CTFS/test/import.organisms.out.ref
1 
Inserted 10 new rows into database
1 
Inserted 13 new rows into database
inputs/CTFS/maps/VegX.organisms.csv
1 1 
CTFS[VegX]:/*s/individualOrganismObservation,VegX:/*s/individualOrganismObservation,Comments
2 2 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/*/relatedPlot[plotRelationship=Quadrat]/relatedPlotID,,
3 
/simpleUserdefined[name=CensusNumber]/value,/simpleUserdefined[name=censusNo]/value,
3 
/*ID->/*s/plotObservation/simpleUserdefined[name=CensusNumber]/value,/simpleUserdefined[name=censusNo]/value,
inputs/CTFS/maps/VegX.organisms.full.csv
97 97 
/simpleUserdefined[name=canopyForm]/value,/simpleUserdefined[name=canopyForm]/value
98 98 
/simpleUserdefined[name=canopyPosition]/value,/simpleUserdefined[name=canopyPosition]/value
99 99 
/simpleUserdefined[name=canopyPosition]/value,/simpleUserdefined[name=canopyPosition]/value
100 
/simpleUserdefined[name=CensusNumber]/value,/simpleUserdefined[name=censusNo]/value,
100 
/*ID->/*s/plotObservation/simpleUserdefined[name=CensusNumber]/value,/simpleUserdefined[name=censusNo]/value,
101 101 
/simpleUserdefined[name=censusNo]/value,/simpleUserdefined[name=censusNo]/value
102 102 
/simpleUserdefined[name=collectionDate]/value,/simpleUserdefined[name=collectionDate]/value
103 103 
/simpleUserdefined[name=growthForm]/value,/simpleUserdefined[name=growthForm]/value
inputs/CTFS/maps/VegBIEN.organisms.csv
85 85 
/relativePlotPosition/relativeY,/aggregateoccurrence/*_id/plantobservation/stemobservation/yposition,
86 86 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,/aggregateoccurrence/count,
87 87 
/volumeCanopy/*ID->/*s/attribute/ordinal/coverPercent,/aggregateoccurrence/cover,
88 
/simpleUserdefined[name=CensusNumber]/value,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
88 
/*ID->/*s/plotObservation/simpleUserdefined[name=CensusNumber]/value,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
89 89 
/simpleUserdefined[name=censusNo]/value,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
90 90 
/volumeCanopy/value,/aggregateoccurrence/linecover,
91 91 
/simpleUserdefined[name=growthForm]/value,/growthform,

Also available in: Unified diff