Project

General

Profile

« Previous | Next » 

Revision 6403

mappings/VegCore-VegBIEN.csv: Set the source_id col_default to the datasource name using the new _setDefault() built-in function and _env()

View differences:

test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
3
    <_setDefault id="-1">
4
        <col>source_id</col>
5
        <value><source><shortname>CTFS</shortname></source></value>
5 6
        <path>
6
            <location>
7
                <sourceaccessioncode>$PlotID</sourceaccessioncode>
8
                <locationevent>
9
                    <sourceaccessioncode>$CensusID</sourceaccessioncode>
10
                    <taxonoccurrence>
11
                        <sourceaccessioncode>$SpeciesInvID</sourceaccessioncode>
12
                        <taxondetermination>
13
                            <taxonverbatim_id>
14
                                <taxonverbatim>
15
                                    <taxonlabel_id>
16
                                        <taxonlabel>
17
                                            <matched_label_id>
7
            <_simplifyPath>
8
                <next>parent_id</next>
9
                <path>
10
                    <location>
11
                        <sourceaccessioncode>$PlotID</sourceaccessioncode>
12
                        <locationevent>
13
                            <sourceaccessioncode>$CensusID</sourceaccessioncode>
14
                            <taxonoccurrence>
15
                                <sourceaccessioncode>$SpeciesInvID</sourceaccessioncode>
16
                                <taxondetermination>
17
                                    <taxonverbatim_id>
18
                                        <taxonverbatim>
19
                                            <taxonlabel_id>
18 20
                                                <taxonlabel>
19
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
20
                                                    <taxonomicname>
21
                                                        <_join_words>
22
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
23
                                                            <2>
21
                                                    <matched_label_id>
22
                                                        <taxonlabel>
23
                                                            <source_id><source><shortname>TNRS</shortname></source></source_id>
24
                                                            <taxonomicname>
24 25
                                                                <_join_words>
25
                                                                    <2>$Genus</2>
26
                                                                    <3>$SpeciesName</3>
27
                                                                    <4>$SubSpeciesName</4>
26
                                                                    <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
27
                                                                    <2>
28
                                                                        <_join_words>
29
                                                                            <2>$Genus</2>
30
                                                                            <3>$SpeciesName</3>
31
                                                                            <4>$SubSpeciesName</4>
32
                                                                        </_join_words>
33
                                                                    </2>
28 34
                                                                </_join_words>
29
                                                            </2>
30
                                                        </_join_words>
31
                                                    </taxonomicname>
32
                                                </taxonlabel>
33
                                            </matched_label_id>
34
                                            <parent_id>
35
                                                <taxonlabel>
35
                                                            </taxonomicname>
36
                                                        </taxonlabel>
37
                                                    </matched_label_id>
36 38
                                                    <parent_id>
37 39
                                                        <taxonlabel>
38
                                                            <rank>cultivar</rank>
39 40
                                                            <parent_id>
40 41
                                                                <taxonlabel>
41
                                                                    <rank>forma</rank>
42
                                                                    <rank>cultivar</rank>
42 43
                                                                    <parent_id>
43 44
                                                                        <taxonlabel>
44
                                                                            <rank>variety</rank>
45
                                                                            <rank>forma</rank>
45 46
                                                                            <parent_id>
46 47
                                                                                <taxonlabel>
47
                                                                                    <rank>subspecies</rank>
48
                                                                                    <taxonepithet>$SubSpeciesName</taxonepithet>
48
                                                                                    <rank>variety</rank>
49 49
                                                                                    <parent_id>
50 50
                                                                                        <taxonlabel>
51
                                                                                            <rank>species</rank>
52
                                                                                            <taxonepithet>$SpeciesName</taxonepithet>
51
                                                                                            <rank>subspecies</rank>
52
                                                                                            <taxonepithet>$SubSpeciesName</taxonepithet>
53 53
                                                                                            <parent_id>
54 54
                                                                                                <taxonlabel>
55
                                                                                                    <rank>genus</rank>
56
                                                                                                    <taxonepithet>$Genus</taxonepithet>
55
                                                                                                    <rank>species</rank>
56
                                                                                                    <taxonepithet>$SpeciesName</taxonepithet>
57 57
                                                                                                    <parent_id>
58 58
                                                                                                        <taxonlabel>
59
                                                                                                            <rank>family</rank>
60
                                                                                                            <taxonepithet>$Family</taxonepithet>
59
                                                                                                            <rank>genus</rank>
60
                                                                                                            <taxonepithet>$Genus</taxonepithet>
61
                                                                                                            <parent_id>
62
                                                                                                                <taxonlabel>
63
                                                                                                                    <rank>family</rank>
64
                                                                                                                    <taxonepithet>$Family</taxonepithet>
65
                                                                                                                </taxonlabel>
66
                                                                                                            </parent_id>
61 67
                                                                                                        </taxonlabel>
62 68
                                                                                                    </parent_id>
63 69
                                                                                                </taxonlabel>
......
72 78
                                                            </parent_id>
73 79
                                                        </taxonlabel>
74 80
                                                    </parent_id>
75
                                                </taxonlabel>
76
                                            </parent_id>
77
                                            <taxonomicname>
78
                                                <_join_words>
79
                                                    <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
80
                                                    <2>
81
                                                    <taxonomicname>
81 82
                                                        <_join_words>
82
                                                            <2>$Genus</2>
83
                                                            <3>$SpeciesName</3>
84
                                                            <4>$SubSpeciesName</4>
83
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
84
                                                            <2>
85
                                                                <_join_words>
86
                                                                    <2>$Genus</2>
87
                                                                    <3>$SpeciesName</3>
88
                                                                    <4>$SubSpeciesName</4>
89
                                                                </_join_words>
90
                                                            </2>
85 91
                                                        </_join_words>
86
                                                    </2>
87
                                                </_join_words>
88
                                            </taxonomicname>
89
                                        </taxonlabel>
90
                                    </taxonlabel_id>
91
                                    <family>$Family</family>
92
                                    <genus>$Genus</genus>
93
                                    <specific_epithet>$SpeciesName</specific_epithet>
94
                                </taxonverbatim>
95
                            </taxonverbatim_id>
96
                        </taxondetermination>
97
                    </taxonoccurrence>
98
                </locationevent>
99
            </location>
92
                                                    </taxonomicname>
93
                                                </taxonlabel>
94
                                            </taxonlabel_id>
95
                                            <family>$Family</family>
96
                                            <genus>$Genus</genus>
97
                                            <specific_epithet>$SpeciesName</specific_epithet>
98
                                        </taxonverbatim>
99
                                    </taxonverbatim_id>
100
                                </taxondetermination>
101
                            </taxonoccurrence>
102
                        </locationevent>
103
                    </location>
104
                </path>
105
            </_simplifyPath>
100 106
        </path>
101
    </_simplifyPath>
107
    </_setDefault>
102 108
</VegBIEN>
103 109
Inserted 20 new rows into database

Also available in: Unified diff