Project

General

Profile

« Previous | Next » 

Revision 7109

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/.TNRS/public.unscrubbed_taxondetermination_view/map.csv: Set dateIdentified to _now()

View differences:

inputs/.TNRS/public.unscrubbed_taxondetermination_view/map.csv
42 42 
Warnings,*Warnings,,
43 43 
Accepted_name_lsid,*Accepted_name_lsid,,
44 44 
:computer,identificationType,,
45 
:_,dateIdentified,/_now,
45 46 
:0,taxonOccurrenceID,,Enables the taxonoccurrence CHECK constraint to pass
inputs/.TNRS/public.unscrubbed_taxondetermination_view/VegBIEN.csv
14 14 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
15 15 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
16 16 
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/2",Contains author based on matched name
17 
:_,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value/_now,
17 18 
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/rank",
18 19 
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1",
19 20 
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_nullIf:[null=Unknown]/value",
......
69 70 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
70 71 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
71 72 
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,
73 
:_,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value/_now,
72 74 
:computer,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationtype,
73 75 
taxonoccurrence_id,/location/locationevent/taxonoccurrence/taxonoccurrence_id,
74 76 
Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid **
inputs/.TNRS/public.unscrubbed_taxondetermination_view/test.xml.ref
15 15 
                                        <taxonverbatim>
16 16 
                                            <taxonlabel_id>
17 17 
                                                <taxonlabel>
18 
                                                    <creationdate><_dateRangeStart><value><_now>_</_now></value></_dateRangeStart></creationdate>
18 19 
                                                    <matched_label_id>
19 20 
                                                        <taxonlabel>
20 21 
                                                            <rank>$Accepted_name_rank</rank>
......
176 177 
                                            <verbatimrank>$Name_matched_rank</verbatimrank>
177 178 
                                        </taxonverbatim>
178 179 
                                    </taxonverbatim_id>
180 
                                    <determinationdate><_dateRangeStart><value><_now>_</_now></value></_dateRangeStart></determinationdate>
179 181 
                                    <determinationtype>computer</determinationtype>
180 182 
                                </taxondetermination>
181 183 
                                <taxonoccurrence_id>$taxonoccurrence_id</taxonoccurrence_id>

Also available in: Unified diff