Click here to Skip to main content
15,910,878 members
Home / Discussions / C#
   

C#

 
AnswerRe: Proper Error handling Pin
GuyThiebaut4-Sep-20 3:08
professionalGuyThiebaut4-Sep-20 3:08 
GeneralRe: Proper Error handling Pin
Exoskeletor4-Sep-20 3:23
Exoskeletor4-Sep-20 3:23 
QuestionCsvHelper, converting $0.00 to 0.00 Pin
jkirkerx3-Sep-20 12:08
professionaljkirkerx3-Sep-20 12:08 
AnswerRe: CsvHelper, converting $0.00 to 0.00 Pin
Gerry Schmitz3-Sep-20 12:55
mveGerry Schmitz3-Sep-20 12:55 
GeneralRe: CsvHelper, converting $0.00 to 0.00 Pin
jkirkerx3-Sep-20 13:20
professionaljkirkerx3-Sep-20 13:20 
AnswerGot It Pin
jkirkerx4-Sep-20 6:34
professionaljkirkerx4-Sep-20 6:34 
GeneralRe: Got It Pin
Mycroft Holmes4-Sep-20 12:15
professionalMycroft Holmes4-Sep-20 12:15 
GeneralRe: Got It Pin
jkirkerx4-Sep-20 13:54
professionaljkirkerx4-Sep-20 13:54 
AnswerI have 3 or 5 of them now, yes they need more work Pin
jkirkerx4-Sep-20 14:08
professionaljkirkerx4-Sep-20 14:08 
GeneralRe: I have 3 or 5 of them now, yes they need more work Pin
Gerry Schmitz5-Sep-20 3:58
mveGerry Schmitz5-Sep-20 3:58 
GeneralRe: I have 3 or 5 of them now, yes they need more work Pin
jkirkerx5-Sep-20 7:24
professionaljkirkerx5-Sep-20 7:24 
QuestionCsvHelper, EBay Order Csv file, not sure how to handle header with quotes and first line of commas Pin
jkirkerx2-Sep-20 13:55
professionaljkirkerx2-Sep-20 13:55 
AnswerRe: CsvHelper, EBay Order Csv file, not sure how to handle header with quotes and first line of commas Pin
OriginalGriff2-Sep-20 22:42
mveOriginalGriff2-Sep-20 22:42 
GeneralRe: CsvHelper, EBay Order Csv file, not sure how to handle header with quotes and first line of commas Pin
jkirkerx3-Sep-20 6:11
professionaljkirkerx3-Sep-20 6:11 
GeneralRe: CsvHelper, EBay Order Csv file, not sure how to handle header with quotes and first line of commas Pin
Dave Kreskowiak3-Sep-20 8:51
mveDave Kreskowiak3-Sep-20 8:51 
AnswerRe: CsvHelper, EBay Order Csv file, not sure how to handle header with quotes and first line of commas PinPopular
Richard Deeming2-Sep-20 22:50
mveRichard Deeming2-Sep-20 22:50 
GeneralRe: CsvHelper, EBay Order Csv file, not sure how to handle header with quotes and first line of commas Pin
jkirkerx3-Sep-20 6:13
professionaljkirkerx3-Sep-20 6:13 
AnswerRe: CsvHelper, EBay Order Csv file, not sure how to handle header with quotes and first line of commas Pin
Luc Pattyn3-Sep-20 1:36
sitebuilderLuc Pattyn3-Sep-20 1:36 
GeneralRe: CsvHelper, EBay Order Csv file, not sure how to handle header with quotes and first line of commas Pin
jkirkerx3-Sep-20 6:12
professionaljkirkerx3-Sep-20 6:12 
AnswerRe: CsvHelper, EBay Order Csv file, not sure how to handle header with quotes and first line of commas Pin
jkirkerx3-Sep-20 6:31
professionaljkirkerx3-Sep-20 6:31 
I took the names out of the map. Then did the readline twice to skip the comma's and header, and turned off read header.
So I can read the file and populate the model now. Just need to fix the number conversions, everything in the model is a string now. But I'm 3 steps closer now. Thanks for all the help!
namespace MarketPlace.CsvParser
{
    public class EBayCsvParser
    {
        public static async Task<List<EBayCsvImport>> Import_EBayOrderFile(string appPath)
        {
            var pOrders = new List<EBayCsvImport>();

            try
            {
                using (var reader = new StreamReader(appPath))
                {
                    using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
                    {
                        csv.Configuration.Delimiter = ",";
                        csv.Configuration.Encoding = Encoding.UTF8;
                        csv.Configuration.MissingFieldFound = null;
                        csv.Configuration.HasHeaderRecord = false;
                        csv.Configuration.HeaderValidated = null;<br />
                        csv.Configuration.CultureInfo = CultureInfo.InvariantCulture;
                        csv.Configuration.TypeConverterOptionsCache.GetOptions(typeof(decimal)).NumberStyle = NumberStyles.AllowCurrencySymbol | NumberStyles.AllowThousands;
                        csv.Configuration.PrepareHeaderForMatch = (header, index) => header.ToLower();
                        csv.Configuration.RegisterClassMap<EBayCsvImportMap>();

                        // Skip the first two lines
                        // Comma's and header
                        reader.ReadLine();
                        reader.ReadLine();

                        csv.Read();<br />
                        pOrders = csv.GetRecords<EBayCsvImport>().ToList();
                        Console.Write(pOrders);
                    }
                }
            }
            catch (Exception ex)
            {
                Console.Write(ex.Message);
            }

            await Task.Delay(100);
            return pOrders;
        }
    }
}
If it ain't broke don't fix it
Discover my world at jkirkerx.com

AnswerRe: CsvHelper, EBay Order Csv file, not sure how to handle header with quotes and first line of commas Pin
Gerry Schmitz3-Sep-20 10:23
mveGerry Schmitz3-Sep-20 10:23 
QuestionConnect POST server call with HttpListener C# Pin
jdamiancabello2-Sep-20 0:21
jdamiancabello2-Sep-20 0:21 
AnswerRe: Connect POST server call with HttpListener C# Pin
Afzaal Ahmad Zeeshan3-Sep-20 5:19
professionalAfzaal Ahmad Zeeshan3-Sep-20 5:19 
QuestionInheritance problem Pin
Croccodillo19711-Sep-20 5:22
Croccodillo19711-Sep-20 5:22 
AnswerRe: Inheritance problem Pin
Richard Deeming1-Sep-20 7:26
mveRichard Deeming1-Sep-20 7:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.