Linq to CSV error "1 or more exceptions while reading data"

Question

0.00/5 (No votes)

See more:

I got an error:

There were 1 or more exceptions while reading data using type "CSVClass". Reading file "C:\Users\admin\Desktop\Project\Project\App_Data\demo.csv".

Here are my code:

C#

if (filMyFile.PostedFile != null)
{
    HttpPostedFile myFile = filMyFile.PostedFile;
    string fname = Path.GetFileName(myFile.FileName);
    string path = Server.MapPath(Path.Combine("~/App_Data/", fname));
    myFile.SaveAs(path);

    try
    {
        CsvFileDescription cv = new CsvFileDescription
        {
            SeparatorChar = ',',
            FirstLineHasColumnNames = true,
            EnforceCsvColumnAttribute = true
        };
        CsvContext cc = new CsvContext();
        List<CSVClass> csvData = (cc.Read<CSVClass>(path, cv)).ToList();

        foreach (var ss in csvData)
        {
            // Console.WriteLine(ss._strNO + "---" + ss._strCity);
        }

    }
    catch (Exception ex)
    {
    }
}

The error happen in

C#

List<CSVClass> csvData = (cc.Read<CSVClass>(path, cv)).ToList();

My class is here:

C#

public class CSVClass
{
    [CsvColumn(FieldIndex = 0)]
    public string Survey { get; set; }
    [CsvColumn(FieldIndex = 1)]
    public string Table_name { get; set; }
    [CsvColumn(FieldIndex = 2)]
    public string Code { get; set; }
    [CsvColumn(FieldIndex = 3)]
    public string YY { get; set; }
    [CsvColumn(FieldIndex = 4)]
    public string MM { get; set; }
    [CsvColumn(FieldIndex = 5)]
    public string Desc { get; set; }
    [CsvColumn(FieldIndex = 6)]
    public string Start_Value { get; set; }
    [CsvColumn(FieldIndex = 7)]
    public string End_Value { get; set; }
    [CsvColumn(FieldIndex = 8)]
    public string Remark { get; set; }
    [CsvColumn(FieldIndex = 9)]
    public bool Is_default  { get; set; }
    [CsvColumn(FieldIndex = 10)]
    public int Order_no { get; set; }
    [CsvColumn(FieldIndex = 11)]
    public int? ParentId { get; set; }
    [CsvColumn(FieldIndex = 12)]
    public string Parent_Table { get; set; }
}

My csv:

Survey,Table_name,Code,YY,MM,Desc,Start_Value,End_Value,Remark,Is_default,Order_no,ParentId,Parent_Table
SEV,sevcodetable,00,2015,04,test,,,,1,1,,

What does it mean more exceptions? how can I fix it?

Thanks

Posted 28-Jul-15 23:28pm

Iris Shing

Updated 29-Sep-21 6:43am

Maciej Los

v3

Add a Solution

Comments

Maciej Los 29-Jul-15 6:45am

Not enough information! Please improve your qestion and add class definition.

Kornfeld Eliyahu Peter 29-Jul-15 7:16am

Maybe the data not CSV after all...

[no name] 30-Jul-15 0:23am

Stop ignoring the exceptions that you are getting would be a good start.

Iris Shing 30-Jul-15 0:29am

Sorry, I m not really understand "Stop ignoring the exceptions", I only get this exception

[no name] 30-Jul-15 1:28am

How would you know? You have an empty catch block so you are ignoring any exception that you are getting.

Iris Shing 30-Jul-15 1:43am

I add break point there, so that I can check it.
Else how can I get this exception?

[no name] 30-Jul-15 7:31am

So? Find out what the exceptions are the are being thrown. Then stop ignoring the exceptions being thrown.

sreeyush sudhakaran 5-Aug-15 6:39am

There is another good method of creating CSV files from List or collection , and converting a csv to collection See more about it here : http://sourceforge.net/projects/filehelpers/ or you can just use string csvResult = string.join(",",csvData);

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sreeyush sudhakaran · Answer 1 · 2015-08-05T00:51:00

Read From a CSV File

C#

public List<string[]> DelimeterFileToList(string strFileName,string[] aDelimeters)
{
            List<string[]> lstData = new List<string[]>();
            try
            {
                using (TextFieldParser parser = new TextFieldParser(strFileName))
                {
                    parser.Delimiters = aDelimeters;
                    while (true)
                    {
                        string[] parts = parser.ReadFields();
                        if (parts == null)
                        {
                            break;
                        }
                        lstData.Add(parts);
                    }
                }
            }
            catch (Exception ex)
            {
                //Log Exception
            }          
   return lstData;
}

Write to a CSV from List

C#

public WriteListToCSV(List<CSVClass> lstCsvClass,string FileName)
{
    var engine = new FileHelperEngine(typeof(CSVClass))
    {       
       HeaderText = typeof(CSVClass).GetCsvHeader()
    };
    if (!Directory.Exists(path.GetDirectory(FileName)))
    {
        Directory.CreateDirectory(path.GetDirectory(FileName));
    }     
       engine.WriteFile(FileName, lstCsvClass.ToArray());
       lstCsvClass.Clear();
}

Name spaces Required :

C#

using FileHelpers;
using FileHelpers.RunTime;

Member 15375990 · Answer 2 · 2021-09-29T06:43:00

It's an aggregated exception type, usually a busted column type,if you breakpoint the exception check the ineer exceptions list, you will find for example a list of errors like this:

{"Value \"0\" in line 2 has the wrong format for field or property \"ShowOnSite\" in type \"CoreWebFeed.DAL.BundleCSVProcessor\". Reading file \"C:\\Users\\jholden\\source\\repos\\CoreWebFeed\\CoreWebFeed\\DataLoading\\Bundles.csv\"."}

Linq to CSV error "1 or more exceptions while reading data"

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0