DataBinder: FormatException column details about sylvan HOT 5 CLOSED

Just pushed Sylvan.Data 0.2.0-b0001 to nuget: https://www.nuget.org/packages/Sylvan.Data/0.2.0-b0001
You'll need to catch Sylvan.Data.DataBinderException which now has an Ordinal property. The InnerException will be the FormatException that you previously caught. Let me know if that works for you and it will be included in the final 0.2.0 release.

from sylvan.

        fileStream.Seek(0, SeekOrigin.Begin);
        var csvDataReaderOptions = new CsvDataReaderOptions()
        {
            Schema = new ImportCsvSchema().Schema
        };
        using var streamReader = new StreamReader(fileStream, Encoding.UTF8, leaveOpen: true);
        using var csvReader = CsvDataReader.Create(streamReader, csvDataReaderOptions) ;
        var binder = DataBinder.Create<TParseResult>(csvReader, new DataBinderOptions() { BindingMode = DataBindingMode.AllColumns });
        while (csvReader.Read())
        {
            try
            {
                binder.Bind(csvReader, parseResult);
            }
            catch (FormatException exception)
            {
                // TODO: Figure out which column was being parsed/bound
            }
        }

columns are mostly strings, but a few DateTimes and Decimals as follows:
new Column.Builder( nameof(CsvParseResult.Date), typeof(DateTime), allowNull: true).Build(),
new Column.Builder( nameof(CsvParseResult.Amount), typeof(decimal), allowNull: true).Build(),

Short of manually trying to parse the columns I know could have issues, I haven't found a way to get what I need from the reader, binder, or exception states.

from sylvan.

Unfortunately, there isn't currently a way to discover which column has the error. This is something I've been meaning to add though, so this is a good reminder that I need to implement it.

from sylvan.

Holy smokes, that was quick! Thank you kindly, it was exactly what I needed.

from sylvan.

If you've found these libraries useful, give it a star, helps other people find it.

from sylvan.