0
Completed

CSV Connector does not support binary values

Tony Sheehy 10 years ago in CSV connector updated by anonymous 7 years ago 4

A CSV connector configured to import a binary value fails with:

Change detection engine import all items for connector CSV Connector Example failed with reason Line 1 column 1 value of 010011010110000101101110 is not valid. Duration: 00:00:00.1406250

This was tried with a byte value, byte array value, binary value and base64 encoded string; all resulting with a message similar to the one provided above.

  • Either the validator should be updated to handle string values
  • Or an intermediate step is included where the CSV connector tries to parse the values retrieved based on the field ValueType, before creating with the Validator
  • Otherwise, a more descriptive exception should be provided denoting that this connector doesn't support that value type.

Matthew, do you think that adding Base64 encoded string support in the binary CreateValue method would make sense?

Thanks.

I have added support in the validator for base64 encoded strings.

Please confirm that this has worked for your scenario.

Thanks.

After some fixes this has been confirmed.