Introduction
When loading data with Firefly Semantics CSV you may encounter the following types of errors:
TooFewFieldsTooManyFieldsInvalidQuotesMissingQuotesUndetectableDelimiter
TooFewFields
The TooFewFields error type is generated when a CSV File record contains fewer fields than there are headers. For example the dataset below does not have the purchaseCost field defined in each row:
sku, quantity, purchaseCost
sku22,2
sku33,2
TooManyFields
The TooManyFields error type is generated when a CSV File record contains more fields than there are headers. For example the first line in the dataset below has an extra column field extra0 and there is no corresponding header:
sku, quantity, purchaseCost
sku22,2, 200, extra0
sku33,2, 200, extra1
InvalidQuotes
In the below sample the comma and the quote characters have been flipped (,"), causing the InvalidQuotes error.
firstName, lastName, zip
"calvin," hobbes, 60643
MissingQuotes
The MissingdQuotes error type is generated when a field is missing a quote. For example the sku field sk22 is missing the terminating quote:
sku, quantity, purchaseCost
"sk22, 2, 30000
UndetectableDelimiter
This error could occur for example if the file loaded contains no data.