public void Test2()
{
var path = @"Data\200122_12-28-09_1.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();
uavLogs.Add(CsvUtilities.GetUavLog(fields, djiHeaderDictionary, rowNumber));
}
}
string csv = String.Join(",", uavLogs);
var sortUavList1 = uavLogs;
sortUavList1.OrderBy(x => x.DateTime).ToList();
var sortUavList = uavLogs;
sortUavList.Sort((x, y) => DateTime.Compare(x.DateTime, y.DateTime));
TimeSpan startTimeSpan = Helpers.GetTimeSpan("00:01:00.150");
TimeSpan endTimeStamp = Helpers.GetTimeSpan("00:02:35.150");
var newUavlogs = Helpers.TrimUavLogs(sortUavList, startTimeSpan, endTimeStamp);
var filePath = Path.Combine(@"C:\Temp\", "sort_test.csv");
var csvVideoLogs = CsvUtilities.ToCsv(",", newUavlogs);
var saved = CsvUtilities.SaveCsvTofile(filePath, csvVideoLogs);
}
}
public void TestDictionaryToVideoInfoModel()
{
var path = @"Data\DJIFlightRecord_2020-01-22_[13-25-55]-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"
Dictionary <int, List <UavLog> > videosLogs;
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);
videosLogs = Helpers.SplitVideosFromUavLog(uavLogs);
}
var videoInfoModels = Helpers.GetVideoInfoModels(videosLogs);
}
public void GetUavLogFromVideoTimeStampTest()
{
List <UavLog> uavLogs = new List <UavLog>();
var path = @"Data\200122_12-28-09_1.csv"; // "," dateTime: "2020/01/22 12:25:55.734"
using (TextFieldParser csvParser = new TextFieldParser(path))
{
csvParser.CommentTokens = new string[] { "#" };
csvParser.SetDelimiters(new string[] { "," });
csvParser.HasFieldsEnclosedInQuotes = true;
string[] headers = csvParser.ReadFields();
var djiHeaderDictionary = CsvUtilities.GetHeaderDictionary(headers);
if (djiHeaderDictionary.Any())
{
int rowNumber = 1;
while (csvParser.PeekChars(1) != null)
{
rowNumber++;
string[] fields = csvParser.ReadFields();
uavLogs.Add(CsvUtilities.GetUavLog(fields, djiHeaderDictionary, rowNumber));
}
}
string csv = String.Join(",", uavLogs);
}
var sortUavList = uavLogs;
sortUavList.Sort((x, y) => DateTime.Compare(x.DateTime, y.DateTime));
//var noko = Helpers.GetfirstLog(uavLogs);
TimeSpan timeSpanp = Helpers.GetTimeSpan("12:36.15");
var sortedUavLogs = Helpers.FilterUavlosAndSort(uavLogs);
var videoLenght = Helpers.GetVideoLenghtInMilliseconds(sortedUavLogs);
var videoLengh = Helpers.ConvertMilisecondsToHMSmm(videoLenght);
if (timeSpanp.TotalMilliseconds < videoLenght)
{
var photolog = Helpers.GetUavLogFromVideoTimeStamp(timeSpanp, uavLogs);
}
else
{
}
}
public void TrimUavLogs()
{
List <UavLog> uavLogs = new List <UavLog>();
var path = @"Data\200122_12-28-09_1.csv"; // "," dateTime: "2020/01/22 12:25:55.734"
using (TextFieldParser csvParser = new TextFieldParser(path))
{
csvParser.CommentTokens = new string[] { "#" };
csvParser.SetDelimiters(new string[] { "," });
csvParser.HasFieldsEnclosedInQuotes = true;
string[] headers = csvParser.ReadFields();
var djiHeaderDictionary = CsvUtilities.GetHeaderDictionary(headers);
if (djiHeaderDictionary.Any())
{
int rowNumber = 1;
while (csvParser.PeekChars(1) != null)
{
rowNumber++;
string[] fields = csvParser.ReadFields();
uavLogs.Add(CsvUtilities.GetUavLog(fields, djiHeaderDictionary, rowNumber));
}
}
string csv = String.Join(",", uavLogs);
}
var sortUavList = uavLogs;
sortUavList.Sort((x, y) => DateTime.Compare(x.DateTime, y.DateTime));
//var noko = Helpers.GetfirstLog(uavLogs);
TimeSpan startTimeSpan = Helpers.GetTimeSpan("01:00.15");
TimeSpan endTimeStamp = Helpers.GetTimeSpan("01:36.15");
var newUavlogs = Helpers.TrimUavLogs(sortUavList, startTimeSpan, endTimeStamp);
var filePath = Path.Combine(@"C:\Temp\", "sort_test.csv");
var csvVideoLogs = CsvUtilities.ToCsv(",", newUavlogs);
var saved = CsvUtilities.SaveCsvTofile(filePath, csvVideoLogs);
}
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);
}
}
public async Task <IActionResult> GetCsvVideoLogInfo(IFormFile djiCsvLog)
{
long size = djiCsvLog.Length;
string extension = Path.GetExtension(djiCsvLog.FileName).ToLower();
if (size > 0)
{
if (extension != ".csv")
{
return(BadRequest("wrong file format"));
}
}
else
{
return(BadRequest("CSV File Not Found"));
}
List <VideoInfoModel> videoInfoModels;
using (TextFieldParser csvParser = new TextFieldParser(djiCsvLog.OpenReadStream()))
{
csvParser.CommentTokens = new string[] { "#" };
csvParser.SetDelimiters(new string[] { "," });
csvParser.HasFieldsEnclosedInQuotes = true;
//Processing row
string[] headers = csvParser.ReadFields();
var djiHeaderDictionary = CsvUtilities.GetDjiHeaderDictionary(headers);
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 && !string.IsNullOrEmpty(fields[index]) && fields[index] != "0")
{
uavLogs.Add(CsvUtilities.GetUavLog(fields, djiHeaderDictionary, rowNumber));
}
}
}
if (!uavLogs.Any())
{
return(BadRequest("No Video log found in file"));
}
var csv = String.Join(",", uavLogs);
//TODO not working
//var uavlogsSort = uavLogs.OrderBy(l => l.DateTime).ToList();
var dictionarylog = Helpers.SplitVideosFromUavLog(uavLogs);
var video1LenghInMilliseconds = Helpers.GetVideoLenghtInMilliseconds(dictionarylog.FirstOrDefault().Value);
foreach (var videologs in dictionarylog)
{
var csvVideoLogs = CsvUtilities.ToCsv(",", videologs.Value);
var filename = $"{videologs.Value.FirstOrDefault().DateTime.ToString("_yyyy-MM-dd_HH-mm-ss")}_{videologs.Key}.csv";
var saved = CsvUtilities.SaveCsvTofile(Path.Combine(@"C:\Temp\", filename), csvVideoLogs);
}
videoInfoModels = Helpers.GetVideoInfoModels(dictionarylog);
}
if (videoInfoModels != null)
{
var csvVideoInfoModels = CsvUtilities.ToCsv(",", videoInfoModels);
var fileNameWithoutExtension = Path.GetFileNameWithoutExtension(djiCsvLog.FileName);
var saved = CsvUtilities.SaveCsvTofile(Path.Combine(@"C:\Temp\", $"{fileNameWithoutExtension}_resume.csv"), csvVideoInfoModels);
return(Ok(videoInfoModels));
}
return(BadRequest("Something Went wrong"));
}
public async Task <IActionResult> TrimCsvLog(IFormFile uavLogsCsv, string startTime, string endTime)
{
long csvFilLength = uavLogsCsv.Length;
string csvFileExtension = Path.GetExtension(uavLogsCsv.FileName).ToLower();
if (csvFilLength > 0)
{
if (csvFileExtension != ".csv")
{
return(BadRequest("wrong CSV file format"));
}
}
else
{
return(BadRequest("CSV File Not Found"));
}
List <UavLog> uavLogs = new List <UavLog>();
using (TextFieldParser csvParser = new TextFieldParser(uavLogsCsv.OpenReadStream()))
{
csvParser.SetDelimiters(new string[] { "," });
csvParser.HasFieldsEnclosedInQuotes = true;
string[] headers = csvParser.ReadFields();
var djiHeaderDictionary = CsvUtilities.GetHeaderDictionary(headers);
if (djiHeaderDictionary.Any())
{
int rowNumber = 1;
while (csvParser.PeekChars(1) != null)
{
rowNumber++;
string[] fields = csvParser.ReadFields();
uavLogs.Add(CsvUtilities.GetUavLog(fields, djiHeaderDictionary, rowNumber));
}
}
string csv = String.Join(",", uavLogs);
}
var sortUavList = uavLogs;
sortUavList.Sort((x, y) => DateTime.Compare(x.DateTime, y.DateTime));
//var newUavlogs = Helpers.TrimUavLogs(sortUavList, "01:00:22", "01:36:22");
TimeSpan startTimeSpan = Helpers.GetTimeSpan(startTime);
TimeSpan endTimeSpan = Helpers.GetTimeSpan(endTime);
if (startTimeSpan == TimeSpan.Zero)
{
return(BadRequest($"cant get video start time from string '{startTime}'"));
}
if (endTimeSpan == TimeSpan.Zero)
{
return(BadRequest($"cant get video end time from string '{endTime}'"));
}
var newUavlogs = Helpers.TrimUavLogs(sortUavList, startTimeSpan, endTimeSpan);
var videoInfoModels = Helpers.GetVideoInfoModels(newUavlogs);
if (videoInfoModels != null)
{
var csvVideoInfoModels = CsvUtilities.ToCsv(",", videoInfoModels);
var fileNameWithoutExtension = Path.GetFileNameWithoutExtension(uavLogsCsv.FileName);
var saved = CsvUtilities.SaveCsvTofile(Path.Combine(@"C:\Temp\", $"{fileNameWithoutExtension}_resume.csv"), csvVideoInfoModels);
// convert string to stream
byte[] byteArray = Encoding.UTF8.GetBytes(string.Concat(csvVideoInfoModels));
var stream = new MemoryStream(byteArray);
return(File(stream, "application/octet-stream", $"{ fileNameWithoutExtension}_resume.csv"));
}
return(BadRequest("No file Created"));
}
