public void Test1()
{
var path = @"Data\DJIFlightRecord_2020-01-22_[14-00-01]-TxtLogToCsv.csv"; // "," dateTime: "2020/01/22 12:25:55.734"
//var path = @"Data\DJIFlightRecord_2020-01-22_13-25-55-verbose.csv"; // ";" dateTime:"28:52.3"
using (TextFieldParser csvParser = new TextFieldParser(path))
{
csvParser.CommentTokens = new string[] { "#" };
csvParser.SetDelimiters(new string[] { "," });
csvParser.HasFieldsEnclosedInQuotes = true;
//// Skip the row with the column names
//csvParser.ReadLine();
//var noko = File.ReadAllLines(path);
//Processing row
string[] headers = csvParser.ReadFields();
var djiHeaderDictionary = CsvUtilities.GetDjiHeaderDictionary(headers);
//foreach (string field in fields)
//{
var uavLogs = new List <UavLog>();
if (djiHeaderDictionary.Any())
{
int rowNumber = 1;
while (csvParser.PeekChars(1) != null)
{
rowNumber++;
string[] fields = csvParser.ReadFields();
var index = djiHeaderDictionary["VideoRecordTime"];
var noko = fields[index];
if (fields.Length > index && fields[index] != "0")
{
uavLogs.Add(CsvUtilities.GetUavLog(fields, djiHeaderDictionary, rowNumber));
}
}
}
string csv = String.Join(",", uavLogs);
var dictionarylog = Helpers.SplitVideosFromUavLog(uavLogs);
var video1LenghInMilliseconds = Helpers.GetVideoLenghtInMilliseconds(dictionarylog[2]);
var time = Helpers.ConvertMilisecondsToHMSmm(video1LenghInMilliseconds);
TimeSpan timeSpan = Helpers.GetTimeSpan("03:56:22");
var photolog = Helpers.GetUavLogFromVideoTimeStamp(timeSpan, dictionarylog[2]);
string filePath = null;
//foreach (var videologs in dictionarylog)
//{
// var csvVideoLogs = CsvUtilities.ToCsv(",", videologs.Value);
// var filename = $"{videologs.Value.FirstOrDefault().DateTime.ToString("yyMMdd")}_{videologs.Key}.csv";
// filePath = Path.Combine(@"C:\Temp\", filename);
// var saved = CsvUtilities.SaveCsvTofile(filePath, csvVideoLogs);
//}
filePath = Path.Combine(@"C:\Temp\", "noko.csv");
var videoInfoModels = Helpers.GetVideoInfoModels(dictionarylog);
var csvVideoLogs = CsvUtilities.ToCsv(",", videoInfoModels.ToArray());
var saved = CsvUtilities.SaveCsvTofile(filePath, csvVideoLogs);
CsvUtilities.ConvertCalssToCsv(videoInfoModels.ToArray(), filePath);
//var csvString = CsvUtilities.ToCsv(",", uavLogs);
//var saved = CsvUtilities.SaveCsvTofile(@"C:\Temp\WriteLines2.csv", csvString);
}
}
