private static void WriteCsv(List <WixPortfolioImportRowModel> buffer) { var CsvFactory = new CsvHelper.Factory(); var configuration = new CsvHelper.Configuration.CsvConfiguration(System.Globalization.CultureInfo.CurrentCulture); // Configure CSV reader configuration.DetectColumnCountChanges = true; configuration.HasHeaderRecord = true; configuration.IgnoreBlankLines = true; configuration.TrimOptions = CsvHelper.Configuration.TrimOptions.Trim; configuration.Delimiter = ","; configuration.IgnoreReferences = false; // Map properties of row model to field headers in CSV file configuration.RegisterClassMap <WixPortfolioImportCsvRowMap>(); var dateStamp = System.DateTime.Now.ToString("yyyy-MM-dd HHmmss"); var filename = $"{dateStamp} - Portfolio products import.csv"; using (var txtreader = new StreamWriter(filename)) { using (var csv = CsvFactory.CreateWriter(txtreader, configuration)) { csv.WriteRecords(buffer); } txtreader.Close(); } }
/// <summary> /// Read Alice's Inventory CSV to pull things not available from Finerworks API, like handleId, description, material, and size /// </summary> /// <returns></returns> public static List <AliceInventoryRowModel> ReadCsv() { var results = new List <AliceInventoryRowModel>(); var CsvFactory = new CsvHelper.Factory(); var configuration = new CsvHelper.Configuration.CsvConfiguration(System.Globalization.CultureInfo.CurrentCulture); // Configure CSV reader configuration.DetectColumnCountChanges = true; configuration.HasHeaderRecord = true; configuration.IgnoreBlankLines = true; configuration.TrimOptions = CsvHelper.Configuration.TrimOptions.Trim; configuration.Delimiter = ","; // Map properties of RegisterBulkCsvRowModel to field headers in CSV file configuration.RegisterClassMap <AliceInventoryCsvRowMap>(); using (var txtreader = new StreamReader("Inventory3.csv")) { using (var csv = CsvFactory.CreateReader(txtreader, configuration)) { // For each row in CSV file results.AddRange(csv.GetRecords <AliceInventoryRowModel>()); } txtreader.Close(); } return(results); }
static void Main(string[] args) { var csvHelper = new CsvHelper.Factory(); }