// Static Methods
public static CommaSeparatedEventReport Parse(string[] lines, ref int index)
{
CommaSeparatedEventReport commaSeparatedEventReport = new CommaSeparatedEventReport();
commaSeparatedEventReport.Firmware = new Firmware();
commaSeparatedEventReport.Header = new Header();
int triggerIndex = 0;
foreach (string line in lines)
{
if (line.Split(',').Length > 11 && line.Split(',')[11].Contains(">"))
{
commaSeparatedEventReport.TriggerIndex = triggerIndex;
}
++triggerIndex;
}
while (!lines[index].ToUpper().Contains("SEL"))
{
++index;
}
// Parse the report firmware id and checksum
commaSeparatedEventReport.Firmware.ID = lines[index].Split(',')[0].Split('=')[1].Split('"')[0];
commaSeparatedEventReport.Firmware.Checksum = Convert.ToInt32(lines[index].Split(',')[1].Replace("\"", ""), 16);
while (!lines[index].ToUpper().Contains("MONTH"))
{
++index;
}
// Parse the date
commaSeparatedEventReport.Header.EventTime = new DateTime(Convert.ToInt32(lines[++index].Split(',')[2]), Convert.ToInt32(lines[index].Split(',')[0]), Convert.ToInt32(lines[index].Split(',')[1]), Convert.ToInt32(lines[index].Split(',')[3]), Convert.ToInt32(lines[index].Split(',')[4]), Convert.ToInt32(lines[index].Split(',')[5]));
// Set rest of header
commaSeparatedEventReport.Header.SerialNumber = 0;
commaSeparatedEventReport.Header.RelayID = "";
commaSeparatedEventReport.Header.StationID = "";
while (!lines[index].ToUpper().Contains("FREQ"))
{
++index;
}
List <string> sampleStatHeader = lines[index].Split(',').ToList();
List <string> sampleStats = lines[++index].Split(',').ToList();
commaSeparatedEventReport.AverageFrequency = Convert.ToDouble(sampleStats[sampleStatHeader.FindIndex(x => x.ToUpper().Contains("FREQ"))]);
commaSeparatedEventReport.SamplesPerCycleAnalog = Convert.ToInt32(sampleStats[sampleStatHeader.FindIndex(x => x.ToUpper().Contains("SAM/CYC_A"))]);
commaSeparatedEventReport.SamplesPerCycleDigital = Convert.ToInt32(sampleStats[sampleStatHeader.FindIndex(x => x.ToUpper().Contains("SAM/CYC_D"))]);
commaSeparatedEventReport.NumberOfCycles = Convert.ToInt32(sampleStats[sampleStatHeader.FindIndex(x => x.ToUpper().Contains("NUM_OF_CYC"))]);
commaSeparatedEventReport.Event = sampleStats[sampleStatHeader.FindIndex(x => x.ToUpper().Contains("EVENT"))].Replace("/", "");
while (!lines[index].ToUpper().Contains("IA"))
{
++index;
}
commaSeparatedEventReport.AnalogSection = new AnalogSection();
string[] fields = lines[index].Split(',');
foreach (string name in fields)
{
if (name.Length < 10 && (
name.ToUpper().Contains("IA") ||
name.ToUpper().Contains("IB") ||
name.ToUpper().Contains("IC") ||
name.ToUpper().Contains("IN") ||
(!name.ToUpper().Contains("TRIG") && name.ToUpper().Contains("IG")) ||
name.ToUpper().Contains("VA") ||
name.ToUpper().Contains("VB") ||
name.ToUpper().Contains("VC") ||
name.ToUpper().Contains("VS") ||
name.ToUpper().Contains("VDC") ||
name.ToUpper().Contains("FREQ")
))
{
commaSeparatedEventReport.AnalogSection.AnalogChannels.Add(new Channel <double>());
commaSeparatedEventReport.AnalogSection.AnalogChannels[commaSeparatedEventReport.AnalogSection.AnalogChannels.Count - 1].Name = name.Split('(')[0].Trim('"');
}
}
foreach (string channel in fields[12].Split(' '))
{
if (channel != "\"")
{
commaSeparatedEventReport.AnalogSection.DigitalChannels.Add(new Channel <bool>());
commaSeparatedEventReport.AnalogSection.DigitalChannels[commaSeparatedEventReport.AnalogSection.DigitalChannels.Count - 1].Name = channel.Trim('"');
}
}
commaSeparatedEventReport.InitialReadingIndex = ++index;
int timeStepTicks = Convert.ToInt32(Math.Round(10000000.0 / commaSeparatedEventReport.AverageFrequency / commaSeparatedEventReport.SamplesPerCycleAnalog));
while (!lines[index].ToUpper().Contains("SETTINGS"))
{
int diff = commaSeparatedEventReport.TriggerIndex - index - commaSeparatedEventReport.InitialReadingIndex;
commaSeparatedEventReport.AnalogSection.TimeChannel.Samples.Add(commaSeparatedEventReport.Header.EventTime.AddTicks(-1 * timeStepTicks * diff));
commaSeparatedEventReport.AnalogSection.AnalogChannels[0].Samples.Add(Convert.ToDouble(lines[index].Split(',')[0]) * (fields[0].ToUpper().Contains("KV")? 1000 : 1));
commaSeparatedEventReport.AnalogSection.AnalogChannels[1].Samples.Add(Convert.ToDouble(lines[index].Split(',')[1]) * (fields[1].ToUpper().Contains("KV")? 1000 : 1));
commaSeparatedEventReport.AnalogSection.AnalogChannels[2].Samples.Add(Convert.ToDouble(lines[index].Split(',')[2]) * (fields[2].ToUpper().Contains("KV")? 1000 : 1));
commaSeparatedEventReport.AnalogSection.AnalogChannels[3].Samples.Add(Convert.ToDouble(lines[index].Split(',')[3]) * (fields[3].ToUpper().Contains("KV")? 1000 : 1));
commaSeparatedEventReport.AnalogSection.AnalogChannels[4].Samples.Add(Convert.ToDouble(lines[index].Split(',')[4]) * (fields[4].ToUpper().Contains("KV")? 1000 : 1));
commaSeparatedEventReport.AnalogSection.AnalogChannels[5].Samples.Add(Convert.ToDouble(lines[index].Split(',')[5]) * (fields[5].ToUpper().Contains("KV")? 1000 : 1));
commaSeparatedEventReport.AnalogSection.AnalogChannels[6].Samples.Add(Convert.ToDouble(lines[index].Split(',')[6]) * (fields[6].ToUpper().Contains("KV")? 1000 : 1));
commaSeparatedEventReport.AnalogSection.AnalogChannels[7].Samples.Add(Convert.ToDouble(lines[index].Split(',')[7]) * (fields[7].ToUpper().Contains("KV")? 1000 : 1));
commaSeparatedEventReport.AnalogSection.AnalogChannels[8].Samples.Add(Convert.ToDouble(lines[index].Split(',')[8]) * (fields[8].ToUpper().Contains("KV")? 1000 : 1));
commaSeparatedEventReport.AnalogSection.AnalogChannels[9].Samples.Add(Convert.ToDouble(lines[index].Split(',')[9]) * (fields[9].ToUpper().Contains("KV")? 1000 : 1));
commaSeparatedEventReport.AnalogSection.AnalogChannels[10].Samples.Add(Convert.ToDouble(lines[index].Split(',')[10]));
string digitals = lines[index].Split(',')[12].Replace("\"", "");
int forEachIndex = 0;
foreach (Channel <bool> channel in commaSeparatedEventReport.AnalogSection.DigitalChannels)
{
channel.Samples.Add(Convert.ToString(Convert.ToInt32(digitals[forEachIndex / 4].ToString(), 16), 2).PadLeft(4, '0')[forEachIndex % 4] == '1');
++forEachIndex;
}
++index;
}
//skip "SETTINGS" AND " LINES
if (lines[index].ToUpper() == "SETTINGS")
{
++index;
}
if (lines[index] == "\"")
{
++index;
}
EventFile.SkipBlanks(lines, ref index);
// SKIP GROUP 1 AND GROUP SETTINGS lINES
if (lines[index].ToUpper() == "GROUP 1")
{
++index;
}
if (lines[index].ToUpper() == "GROUP SETTINGS:")
{
++index;
}
commaSeparatedEventReport.GroupSetting = Settings.Parse(lines, ref index);
EventFile.SkipBlanks(lines, ref index);
++index;
commaSeparatedEventReport.ControlEquations = ControlEquation.Parse(lines, ref index);
EventFile.SkipBlanks(lines, ref index);
commaSeparatedEventReport.GlobalSetting = Settings.Parse(lines, ref index);
return(commaSeparatedEventReport);
}
public static CommaSeparatedEventReport Parse(double systemFrequency, string[] lines, ref int index)
{
CommaSeparatedEventReport commaSeparatedEventReport = new CommaSeparatedEventReport();
commaSeparatedEventReport.Firmware = new Firmware();
commaSeparatedEventReport.Header = new Header();
int triggerIndex = 0;
foreach (string line in lines)
{
if (line.Split(',').Length > 11 && line.Split(',')[11].Contains(">"))
{
commaSeparatedEventReport.TriggerIndex = triggerIndex;
}
++triggerIndex;
}
while (!lines[index].ToUpper().Contains("SEL"))
{
++index;
}
// Parse the report firmware id and checksum
commaSeparatedEventReport.Firmware.ID = lines[index].Split(',')[0].Split('=')[1].Split('"')[0];
//commaSeparatedEventReport.Firmware.Checksum = Convert.ToInt32(lines[index].Split(',')[1].Replace("\"", ""), 16);
while (!lines[index].ToUpper().Contains("MONTH"))
{
++index;
}
// Parse the date
commaSeparatedEventReport.Header.EventTime = new DateTime(Convert.ToInt32(lines[++index].Split(',')[2]), Convert.ToInt32(lines[index].Split(',')[0]), Convert.ToInt32(lines[index].Split(',')[1]), Convert.ToInt32(lines[index].Split(',')[3]), Convert.ToInt32(lines[index].Split(',')[4]), Convert.ToInt32(lines[index].Split(',')[5]));
// Set rest of header
commaSeparatedEventReport.Header.SerialNumber = 0;
commaSeparatedEventReport.Header.RelayID = "";
commaSeparatedEventReport.Header.StationID = "";
while (!lines[index].ToUpper().Contains("FREQ"))
{
++index;
}
List <string> sampleStatHeader = lines[index].Split(',').ToList();
List <string> sampleStats = lines[++index].Split(',').ToList();
commaSeparatedEventReport.AverageFrequency = Convert.ToDouble(sampleStats[sampleStatHeader.FindIndex(x => x.ToUpper().Contains("FREQ"))]);
commaSeparatedEventReport.SamplesPerCycleAnalog = Convert.ToDouble(sampleStats[sampleStatHeader.FindIndex(x => x.ToUpper().Contains("SAM/CYC_A"))]);
commaSeparatedEventReport.SamplesPerCycleDigital = Convert.ToDouble(sampleStats[sampleStatHeader.FindIndex(x => x.ToUpper().Contains("SAM/CYC_D"))]);
commaSeparatedEventReport.NumberOfCycles = Convert.ToDouble(sampleStats[sampleStatHeader.FindIndex(x => x.ToUpper().Contains("NUM_OF_CYC"))]);
commaSeparatedEventReport.Event = sampleStats[sampleStatHeader.FindIndex(x => x.ToUpper().Contains("EVENT"))].Replace("/", "");
while (!lines[index].ToUpper().Contains("IA"))
{
++index;
}
commaSeparatedEventReport.AnalogSection = new AnalogSection();
string[] fields = lines[index].Split(',');
int fieldIndex = 0;
while (fields[fieldIndex].Trim('"').ToUpper() != "TRIG")
{
commaSeparatedEventReport.AnalogSection.AnalogChannels.Add(new Channel <double>());
commaSeparatedEventReport.AnalogSection.AnalogChannels[commaSeparatedEventReport.AnalogSection.AnalogChannels.Count - 1].Name = fields[fieldIndex++].Split('(')[0].Trim('"');
}
foreach (string channel in fields[++fieldIndex].Split(' '))
{
if (channel != "\"")
{
commaSeparatedEventReport.AnalogSection.DigitalChannels.Add(new Channel <bool?>());
commaSeparatedEventReport.AnalogSection.DigitalChannels[commaSeparatedEventReport.AnalogSection.DigitalChannels.Count - 1].Name = channel.Trim('"');
}
}
commaSeparatedEventReport.InitialReadingIndex = ++index;
int timeStepTicks = Convert.ToInt32(Math.Round(10000000.0 / systemFrequency / commaSeparatedEventReport.SamplesPerCycleAnalog));
while (!lines[index].ToUpper().Contains("SETTINGS") && lines[index].ToUpper() != string.Empty)
{
int diff = commaSeparatedEventReport.TriggerIndex - index - commaSeparatedEventReport.InitialReadingIndex;
commaSeparatedEventReport.AnalogSection.TimeChannel.Samples.Add(commaSeparatedEventReport.Header.EventTime.AddTicks(-1 * timeStepTicks * diff));
int channelIndex = 0;
foreach (var analogChannel in commaSeparatedEventReport.AnalogSection.AnalogChannels)
{
analogChannel.Samples.Add(Convert.ToDouble(lines[index].Split(',')[channelIndex]) * (fields[channelIndex++].ToUpper().Contains("KV") ? 1000 : 1));
}
string digitals = lines[index].Split(',')[++channelIndex].Replace("\"", "");
int forEachIndex = 0;
foreach (Channel <bool?> channel in commaSeparatedEventReport.AnalogSection.DigitalChannels)
{
if (digitals == "" || !Regex.IsMatch(digitals, @"\A\b[0-9a-fA-F]+\b\Z"))
{
channel.Samples.Add(null);
}
else
{
channel.Samples.Add(Convert.ToString(Convert.ToInt32(digitals[forEachIndex / 4].ToString(), 16), 2).PadLeft(4, '0')[forEachIndex % 4] == '1');
}
++forEachIndex;
}
++index;
}
try
{
//skip "SETTINGS" AND " LINES
if (lines[index].ToUpper() == "SETTINGS")
{
++index;
}
if (lines[index] == "\"")
{
++index;
}
EventFile.SkipBlanks(lines, ref index);
// SKIP GROUP 1 AND GROUP SETTINGS lINES
if (lines[index].ToUpper() == "GROUP 1")
{
++index;
}
if (lines[index].ToUpper() == "GROUP SETTINGS:")
{
++index;
}
commaSeparatedEventReport.GroupSetting = Settings.Parse(lines, ref index);
EventFile.SkipBlanks(lines, ref index);
++index;
commaSeparatedEventReport.ControlEquations = ControlEquation.Parse(lines, ref index);
EventFile.SkipBlanks(lines, ref index);
commaSeparatedEventReport.GlobalSetting = Settings.Parse(lines, ref index);
}
catch (IndexOutOfRangeException)
{
if (index < lines.Length)
{
throw;
}
}
return(commaSeparatedEventReport);
}
