SpeciesLink issues¶

• Table of contents
• SpeciesLink issues
  • CSV delimiters inside fields are not escaped
  • Some rows have columns shifted to the right, but CSV syntax appears valid
  • Some rows have columns shifted to the left, but CSV syntax appears valid

CSV delimiters inside fields are not escaped¶

Rows affected: ?

Sample row:

Invalid CSV	dwcoreGlobalUniqueIdentifier	dwcoreLocality	dwcoreMinimumElevationInMeters	dwcoreCollector	dwcoreSex
...de Alvarães `a Vila Nogueira.	106392687	Margem direita do rio Solimões, estrada que liga a cidade de Alvarães	a Vila Nogueira.		C. A. Cid Ferreira

Error: Field contains CSV delimiter `; columns are shifted to the right

Some rows have columns shifted to the right, but CSV syntax appears valid¶

Rows affected: up to 142

Sample row:

dwcoreGlobalUniqueIdentifier

darwin1Subspecies

darwin1ScientificNameAuthor

darwin1IdentifiedBy

darwin1YearIdentified

darwin1MonthIdentified

darwin1DayIdentified

darwin1TypeStatus

darwin1CollectorNumber

darwin1FieldNumber

darwin1Collector

darwin1YearCollected

darwin1MonthCollected

darwin1DayCollected

darwin1JulianDay

78855637

fontinaloides

Trevis.

B. Øllgaard; P. G. Windisch

1987

154-.8

R. Schmalz

1904

10

Error: Columns are shifted to the right by 1 or 2

Some rows have columns shifted to the left, but CSV syntax appears valid¶

Rows affected: 1+

Sample row:

row #	dwcoreGlobalUniqueIdentifier	dwcoreRemarks	dwcoreGenus	dwcoreSpecificEpithet	dwcoreInfraspecificEpithet	...18 columns...	geospatialDecimalLatitude	geospatialDecimalLongitude	geospatialGeodeticDatum
885	.	Fontana A.P.	0	999.9	WGS84

Error: Columns are shifted to the left by a lot; dwcoreGlobalUniqueIdentifier "." is invalid

Embedded newlines may not be escaped