Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing 'Id' CSV column in CSV file #307

Open
mathishuettl opened this issue Dec 13, 2023 · 2 comments
Open

Missing 'Id' CSV column in CSV file #307

mathishuettl opened this issue Dec 13, 2023 · 2 comments

Comments

@mathishuettl
Copy link

mathishuettl commented Dec 13, 2023

Hello,

I'm brad new to this lib, but I'm getting the following error:

ChoETL.ChoMissingCSVColumnException: "Missing 'Id' CSV column in CSV file."

This is how my test.txt looks like:

"Id","Name"
"1","Tom"
"2","Carl"
"3","Mark"

My Poco

public partial class Account
{
    public string Id { get; set; }
    public string Name { get; set; }
}
foreach (var rec in new ChoCSVReader<Account>(rootDir + @"\test.txt").WithFirstLineHeader().QuoteAllFields())
{
    Debug.WriteLine("name:" + rec.Name);
}

And also the Console doesn't show up the Name

Questions:

  • My input files comes in that format (with quotes and comma) - how can I make this work?
  • What if my input file doesn't have an ID, instead the column is called AccountID or something like this?
@Cinchoo
Copy link
Owner

Cinchoo commented Dec 13, 2023

As CSV comes with quoted field values, pls set MayHaveQuotedFields to the parser to handle it.

Here is sample fiddle: https://dotnetfiddle.net/cgX2Ld

@mathishuettl
Copy link
Author

Same problem:
https://we.tl/t-Rkp9UZ1Zo9

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants