4,713
edits
Line 41: | Line 41: | ||
-- TENN-L-0000015_lg.csv has dateIdentified in the wrong format, neither verbatim, nor standard DarwinCore format: Verbatim would be: Nov. 12, 1939, DarwinCore would be: 1939-11-12, Listed is: 1939-November-12. <br> '''(Bryan''': I think excel may have imposed it's own format and changed the records. If the column type is set to "text" Excel will not transform to a new format. ) <br> ('''Ed''': The verbatimEventDate (not dateIdentified is in the correct format, but if you open file in excel it will convert the display to match program's defaults)). | -- TENN-L-0000015_lg.csv has dateIdentified in the wrong format, neither verbatim, nor standard DarwinCore format: Verbatim would be: Nov. 12, 1939, DarwinCore would be: 1939-11-12, Listed is: 1939-November-12. <br> '''(Bryan''': I think excel may have imposed it's own format and changed the records. If the column type is set to "text" Excel will not transform to a new format. ) <br> ('''Ed''': The verbatimEventDate (not dateIdentified is in the correct format, but if you open file in excel it will convert the display to match program's defaults)). | ||
<br> '''Deb''' - verified verbatimEventDate="Nov. 12, 1939 in csv --[[User:Dpaul|Dpaul]] 21:21, 13 June 2013 (EDT) | |||
<br> | |||
-- TENN-L-0000017_lg.csv omits dateIdentified, though it is on the label as 3 Feb. 1963 <br> ('''Bryan''': Agreed. Should be fixed to match the label.) <br> ('''Ed''': That is the collection date, not the dateIdentified. Format is correct in verbatimDate) | |||
<br> '''Deb''': this is a confusing label! the line begins with '''Det.''':Barbara Moore, this is followed by '''Date''': 3 Feb 1963. (A person who knows this collector's label and habits would know if the date represents collected or identified date. An outsider may very well conclude eventDate (date collected) is missing.--[[User:Dpaul|Dpaul]] 21:21, 13 June 2013 (EDT) | |||
-- TENN-L-0000019_lg.csv has 1954-Aug-8, but on the label it is "8 Aug 1954", again neither verbatim nor DarwinCore (1954-08-08). ('''Daryl)''' <br> ('''Bryan''': Agreed. Should be fixed to match the label.) | <br> | ||
-- TENN-L-0000019_lg.csv has 1954-Aug-8, but on the label it is "8 Aug 1954", again neither verbatim nor DarwinCore (1954-08-08). ('''Daryl)''' <br> ('''Bryan''': Agreed. Should be fixed to match the label.) | |||
<br> | |||
'''Deb''': in csv, dwc:verbatimEventDate=8 Aug 1954 | |||
<br> | |||
dwc:eventDate=1954-08-08 | |||
<br> | |||
dwc:dateIdentified=1954-Aug-8 | |||
<br> it's this last field that's funky and likely should be 1954-08-08 | |||
==== comma, space, period, apostrophe in verbatimCoordinates errors ==== | ==== comma, space, period, apostrophe in verbatimCoordinates errors ==== |