System.InvalidCastException: Unable to cast object of type 'report_engine.Models.CustomerPlanModel' to type 'System.Collections.IList' about aspnetcorecsvimportexport

[damienbod]

Hi @rcalderoni
You need to use an IList type to import the data. In your Controller, your import method should look something like this:

[HttpPost]
[Route("import")]
public IActionResult Import([FromBody]List<CustomerPlanModel> value)
{
  if (!ModelState.IsValid)
  {
                return BadRequest(ModelState);
  }
  else
  {
                List<CustomerPlanModel> data = value;
                return Ok();
  }
}

Can you check this or post your Controller import method and I can check it?

If this is ok, can you post me your Controller code for the import and also the project.json

Greetings Damien

[rcalderoni]

yep, that's what I've got as well, makes me wonder if it's a compatibility issue since I am using the latest .NET Core SDK, I'll report back if I find any fixes in that case

[HttpPost]
        [Route("import")]
        public IActionResult Import([FromBody]List<CustomerPlanModel> value)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }
            else
            {
                List<CustomerPlanModel> data = value;
                return Ok();
            }
        }

public void ConfigureServices(IServiceCollection services)
        {
            var csvFormatterOptions = new CsvFormatterOptions();

            // Add framework services.
            services.AddMvc(options =>
            {
                options.InputFormatters.Add(new CsvInputFormatter(csvFormatterOptions));
                options.OutputFormatters.Add(new CsvOutputFormatter(csvFormatterOptions));
                options.FormatterMappings.SetMediaTypeMappingForFormat("csv", MediaTypeHeaderValue.Parse("text/csv"));
            });

            services.AddTransient<IReportFilterService, ReportFilterService>();
            services.AddTransient<IReportFilterRepository, ReportFilterRepository>();
        }

[damienbod]

If your using the an older version, then it's a compatibility issue, you need to change the Activator. The code works with the actual version of ASP.NET Core.

Greetings Damien

[damienbod]

can I close this issue?

[rcalderoni]

I ultimately used a different approach because I couldn't get past this. I was using the latest version of Core, I suspect that this is still an issue but did not pursue it further.

…

On Fri, Nov 25, 2016 at 8:00 AM damienbod ***@***.***> wrote: can I close this issue? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#4 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AA8tahqcUfCD8fvrIGXJZBwJ54HBd-rdks5rBtvjgaJpZM4KUHWf> .

[damienbod]

OK, I'll check it again with Version ASP.NET Core 1.1 and if it works, I'll close the issue.

Thanks for the replay

Greetings Damien

[damienbod]

@rcalderoni

I checked this and it works without problems.

https://github.com/damienbod/AspNetCoreCsvImportExport/tree/delimiterTestComma

This was the update in ASP.NET Core version which caused this mismatch. Sorry this solution did not work for you.

Greetings Damien