search

billgraziano / CsvDataReader

Fast streaming CSV file reader for PowerShell impleted as a DataReader.
40 stars 22 forks source link

Quotes around headers breaks column mapping #7

Open joesuffceren opened 9 years ago

joesuffceren commented 9 years ago

If I attempt to import a CSV with a header row of: "DisplayName","PrimarySMTPAddress" then an error is thrown: Exception calling "WriteToServer" with "1" argument(s): "The given ColumnName 'DisplayName' does not match up with any column in data source."

This can be worked around by using ""DisplayName"" in the column mapping, but it would be preferable for the same optional text qualifier logic that is used for the data rows to be used for the header rows as well. My source for this CSV puts double quotes around every single cell whether it is a header or data cell.

I am using the compiled DLL you provided in "releases." I did not compile my own.

krishnase commented 7 years ago

does it support Text Qualifer logic...