private void buttonExtExcel_Click(object sender, EventArgs e)
{
Forms.ExportForm frm = new Forms.ExportForm();
frm.Init(new string[] { "All",
"Stars only",
"Planets only", //2
"Exploration List Stars", //3
"Exploration List Planets", //4
"Ring Scans", //5
});
if (frm.ShowDialog(FindForm()) == DialogResult.OK)
{
BaseUtils.CSVWrite csv = new BaseUtils.CSVWrite();
csv.SetCSVDelimiter(frm.Comma);
try
{
if (frm.SelectedIndex == 5)
{
var saaentries = JournalEntry.GetByEventType(JournalTypeEnum.SAASignalsFound, EDCommander.CurrentCmdrID, frm.StartTimeUTC, frm.EndTimeUTC).ConvertAll(x => (JournalSAASignalsFound)x);
var scanentries = JournalEntry.GetByEventType(JournalTypeEnum.Scan, EDCommander.CurrentCmdrID, frm.StartTimeUTC, frm.EndTimeUTC).ConvertAll(x => (JournalScan)x);
BaseUtils.CSVWriteGrid grd = new BaseUtils.CSVWriteGrid();
grd.SetCSVDelimiter(frm.Comma);
string[] headers1 = { "", "", "", "", "", "",
"Icy Ring", "", "", "", "", "","", "", "", "",
"Rocky", "", "", "", "", "","", "",
"Metal Rich", "", "", "", "",
"Metalic", "", "", "", "",
"Other" };
string[] headers2 = { "Time", "BodyName", "Ring Types", "Mass MT", "Inner Rad (ls)", "Outer Rad (ls)",
// icy ring
"Water", "Liquid Oxygen", "Methanol Mono", "Methane", "Bromellite", "Grandidierite", "Low Temp Diamonds","Void Opals", "Alexandrite", "Tritium",
// rocky
"Bauxite", "Indite", "Alexandrite", "Monazite", "Musgravite", "Benitoite", "Serendibite", "Rhodplumsite",
// metal rich
"Rhodplumsite", "Serendibite", "Platinum", "Monazite", "Painite",
// metalic
"Rhodplumsite", "Serendibite", "Platinum", "Monazite", "Painite",
// others
"Geological", "Biological", "Thargoid", "Human", "Guardian", };
string[] fdname = { "Water", "LiquidOxygen", "methanolmonohydratecrystals", "MethaneClathrate", // icy
"Bromellite", "Grandidierite", "lowtemperaturediamond", "Opal",
"Alexandrite", "Tritium",
"Bauxite", "Indite", "Alexandrite", "Monazite", "Musgravite","Benitoite", "Serendibite", "Rhodplumsite", // rocky
"Rhodplumsite", "Serendibite", "Platinum", "Monazite", "Painite", // metal rich
"Rhodplumsite", "Serendibite", "Platinum", "Monazite", "Painite", // metalic
"$SAA_SignalType_Geological;", "$SAA_SignalType_Biological;", "$SAA_SignalType_Thargoid;", "$SAA_SignalType_Human;","$SAA_SignalType_Guardian;" };
grd.GetLineHeader = (row) => { return(row == 1 ? headers2 : row == 0 ? headers1 : null); };
grd.GetLineStatus = (row) =>
{
if (row < saaentries.Count)
{
for (int rp = row + 1; rp < saaentries.Count; rp++)
{
if (saaentries[rp].BodyName == saaentries[row].BodyName && (saaentries[rp].EventTimeUTC - saaentries[row].EventTimeUTC) < new TimeSpan(30, 0, 0, 0))
{
return(CSVWriteGrid.LineStatus.Skip); // if matches one in front, and its less than 30 days from it, ignore
}
}
return(CSVWriteGrid.LineStatus.OK);
}
else
{
return(CSVWriteGrid.LineStatus.EOF);
}
};
grd.GetLine = (r) =>
{
var entry = saaentries[r];
string signals = string.Join(",", entry.Signals.Select(x => x.Type_Localised));
JournalScan scanof = scanentries.Find(x => x.FindRing(entry.BodyName) != null);
bool showrocky = true, showmr = true, showmetalic = true, showicy = true; // only used if item appears more than once below
string ringtype = "", mass = "", innerrad = "", outerrad = "";
if (scanof != null)
{
var ri = scanof.FindRing(entry.BodyName);
ringtype = ri.RingClassNormalised();
if (ringtype.Contains("metalic", StringComparison.InvariantCultureIgnoreCase))
{
showicy = showrocky = showmr = false;
}
else if (ringtype.Contains("Metal", StringComparison.InvariantCultureIgnoreCase))
{
showicy = showrocky = showmetalic = false;
}
else if (ringtype.Contains("rocky", StringComparison.InvariantCultureIgnoreCase))
{
showicy = showmetalic = showmr = false;
}
else if (ringtype.Contains("icy", StringComparison.InvariantCultureIgnoreCase))
{
showrocky = showmetalic = showmr = false;
}
mass = ri.MassMT.ToStringInvariant();
innerrad = (ri.InnerRad / JournalScan.oneLS_m).ToStringInvariant("N3");
outerrad = (ri.OuterRad / JournalScan.oneLS_m).ToStringInvariant("N3");
}
//string sig = string.Join(",", entry.Signals.Select(x=>x.Type)); // debug
return(new object[] { EDDConfig.Instance.ConvertTimeToSelectedFromUTC(entry.EventTimeUTC), entry.BodyName, ringtype,
mass, innerrad, outerrad,
entry.ContainsStr(fdname[0]), entry.ContainsStr(fdname[1]), entry.ContainsStr(fdname[2]), entry.ContainsStr(fdname[3]),
entry.ContainsStr(fdname[4]), entry.ContainsStr(fdname[5]), entry.ContainsStr(fdname[6]), entry.ContainsStr(fdname[7]),
entry.ContainsStr(fdname[8], showicy), entry.ContainsStr(fdname[9]),
// "Bauxite","Indite","Alexandrite","Monazite", // rocky
entry.ContainsStr(fdname[10]), entry.ContainsStr(fdname[11]), entry.ContainsStr(fdname[12], showrocky), entry.ContainsStr(fdname[13], showrocky),
// "Musgravite","Benitoite","Serendibite","Rhodplumsite", // rocky
entry.ContainsStr(fdname[14]), entry.ContainsStr(fdname[15]), entry.ContainsStr(fdname[16], showrocky), entry.ContainsStr(fdname[17], showrocky),
// "Rhodplumsite","Serendibite","Platinum","Monazite","Painite", // metal rich
entry.ContainsStr(fdname[18], showmr), entry.ContainsStr(fdname[19], showmr), entry.ContainsStr(fdname[20], showmr), entry.ContainsStr(fdname[21], showmr), entry.ContainsStr(fdname[22], showmr),
// "Rhodplumsite","Serendibite","Platinum","Monazite","Painite", // metalic
entry.ContainsStr(fdname[23], showmetalic), entry.ContainsStr(fdname[24], showmetalic), entry.ContainsStr(fdname[25], showmetalic), entry.ContainsStr(fdname[26], showmetalic), entry.ContainsStr(fdname[27], showmetalic),
entry.ContainsStr(fdname[28]), entry.ContainsStr(fdname[29]), entry.ContainsStr(fdname[30]), entry.ContainsStr(fdname[31]), entry.ContainsStr(fdname[32]), });
};
grd.WriteGrid(frm.Path, frm.AutoOpen, FindForm());
}
else
{
using (System.IO.StreamWriter writer = new System.IO.StreamWriter(frm.Path))
{
List <JournalScan> scans = null;
if (frm.SelectedIndex < 3)
{
var entries = JournalEntry.GetByEventType(JournalTypeEnum.Scan, EDCommander.CurrentCmdrID, frm.StartTimeUTC, frm.EndTimeUTC);
scans = entries.ConvertAll(x => (JournalScan)x);
}
else
{
ExplorationSetClass currentExplorationSet = new ExplorationSetClass();
string file = currentExplorationSet.DialogLoad(FindForm());
if (file != null)
{
scans = new List <JournalScan>();
foreach (string system in currentExplorationSet.Systems)
{
ISystem sys = SystemCache.FindSystem(system);
if (sys != null)
{
var jl = EDSMClass.GetBodiesList(sys);
List <JournalScan> sysscans = jl.Item1;
if (sysscans != null)
{
scans.AddRange(sysscans);
}
}
}
}
else
{
return;
}
}
bool ShowStars = frm.SelectedIndex < 2 || frm.SelectedIndex == 3;
bool ShowPlanets = frm.SelectedIndex == 0 || frm.SelectedIndex == 2 || frm.SelectedIndex == 4;
bool ShowBeltClusters = frm.SelectedIndex == 0;
List <JournalSAAScanComplete> mappings = ShowPlanets ?
JournalEntry.GetByEventType(JournalTypeEnum.SAAScanComplete, EDCommander.CurrentCmdrID, frm.StartTimeUTC, frm.EndTimeUTC).ConvertAll(x => (JournalSAAScanComplete)x)
: null;
if (frm.IncludeHeader)
{
// Write header
writer.Write(csv.Format("Time"));
writer.Write(csv.Format("BodyName"));
writer.Write(csv.Format("Estimated Value"));
writer.Write(csv.Format("DistanceFromArrivalLS"));
writer.Write(csv.Format("WasMapped"));
writer.Write(csv.Format("WasDiscovered"));
if (ShowStars)
{
writer.Write(csv.Format("StarType"));
writer.Write(csv.Format("StellarMass"));
writer.Write(csv.Format("AbsoluteMagnitude"));
writer.Write(csv.Format("Age MY"));
writer.Write(csv.Format("Luminosity"));
}
writer.Write(csv.Format("Radius"));
writer.Write(csv.Format("RotationPeriod"));
writer.Write(csv.Format("SurfaceTemperature"));
if (ShowPlanets)
{
writer.Write(csv.Format("TidalLock"));
writer.Write(csv.Format("TerraformState"));
writer.Write(csv.Format("PlanetClass"));
writer.Write(csv.Format("Atmosphere"));
writer.Write(csv.Format("Iron"));
writer.Write(csv.Format("Silicates"));
writer.Write(csv.Format("SulphurDioxide"));
writer.Write(csv.Format("CarbonDioxide"));
writer.Write(csv.Format("Nitrogen"));
writer.Write(csv.Format("Oxygen"));
writer.Write(csv.Format("Water"));
writer.Write(csv.Format("Argon"));
writer.Write(csv.Format("Ammonia"));
writer.Write(csv.Format("Methane"));
writer.Write(csv.Format("Hydrogen"));
writer.Write(csv.Format("Helium"));
writer.Write(csv.Format("Volcanism"));
writer.Write(csv.Format("SurfaceGravity"));
writer.Write(csv.Format("SurfacePressure"));
writer.Write(csv.Format("Landable"));
writer.Write(csv.Format("EarthMasses"));
writer.Write(csv.Format("IcePercent"));
writer.Write(csv.Format("RockPercent"));
writer.Write(csv.Format("MetalPercent"));
}
// Common orbital param
writer.Write(csv.Format("SemiMajorAxis"));
writer.Write(csv.Format("Eccentricity"));
writer.Write(csv.Format("OrbitalInclination"));
writer.Write(csv.Format("Periapsis"));
writer.Write(csv.Format("OrbitalPeriod"));
writer.Write(csv.Format("AxialTilt"));
if (ShowPlanets)
{
writer.Write(csv.Format("Carbon"));
writer.Write(csv.Format("Iron"));
writer.Write(csv.Format("Nickel"));
writer.Write(csv.Format("Phosphorus"));
writer.Write(csv.Format("Sulphur"));
writer.Write(csv.Format("Arsenic"));
writer.Write(csv.Format("Chromium"));
writer.Write(csv.Format("Germanium"));
writer.Write(csv.Format("Manganese"));
writer.Write(csv.Format("Selenium"));
writer.Write(csv.Format("Vanadium"));
writer.Write(csv.Format("Zinc"));
writer.Write(csv.Format("Zirconium"));
writer.Write(csv.Format("Cadmium"));
writer.Write(csv.Format("Mercury"));
writer.Write(csv.Format("Molybdenum"));
writer.Write(csv.Format("Niobium"));
writer.Write(csv.Format("Tin"));
writer.Write(csv.Format("Tungsten"));
writer.Write(csv.Format("Antimony"));
writer.Write(csv.Format("Polonium"));
writer.Write(csv.Format("Ruthenium"));
writer.Write(csv.Format("Technetium"));
writer.Write(csv.Format("Tellurium"));
writer.Write(csv.Format("Yttrium"));
}
writer.WriteLine();
}
foreach (JournalScan je in scans)
{
JournalScan scan = je as JournalScan;
if ((je.IsPlanet && ShowPlanets) || (je.IsStar && ShowStars) || (je.IsBeltCluster && ShowBeltClusters))
{
if (je.IsPlanet)
{
var mapping = mappings?.FirstOrDefault(m => m.BodyID == scan.BodyID && m.BodyName == scan.BodyName);
if (mapping != null)
{
scan.SetMapped(true, mapping.ProbesUsed <= mapping.EfficiencyTarget);
}
}
writer.Write(csv.Format(EDDConfig.Instance.ConvertTimeToSelectedFromUTC(scan.EventTimeUTC)));
writer.Write(csv.Format(scan.BodyName));
writer.Write(csv.Format(scan.EstimatedValue));
writer.Write(csv.Format(scan.DistanceFromArrivalLS));
writer.Write(csv.Format(scan.WasMapped));
writer.Write(csv.Format(scan.WasDiscovered));
if (ShowStars)
{
writer.Write(csv.Format(scan.StarType));
writer.Write(csv.Format((scan.nStellarMass.HasValue) ? scan.nStellarMass.Value : 0));
writer.Write(csv.Format((scan.nAbsoluteMagnitude.HasValue) ? scan.nAbsoluteMagnitude.Value : 0));
writer.Write(csv.Format((scan.nAge.HasValue) ? scan.nAge.Value : 0));
writer.Write(csv.Format(scan.Luminosity));
}
writer.Write(csv.Format(scan.nRadius.HasValue ? scan.nRadius.Value : 0));
writer.Write(csv.Format(scan.nRotationPeriod.HasValue ? scan.nRotationPeriod.Value : 0));
writer.Write(csv.Format(scan.nSurfaceTemperature.HasValue ? scan.nSurfaceTemperature.Value : 0));
if (ShowPlanets)
{
writer.Write(csv.Format(scan.nTidalLock.HasValue ? scan.nTidalLock.Value : false));
writer.Write(csv.Format((scan.TerraformState != null) ? scan.TerraformState : ""));
writer.Write(csv.Format((scan.PlanetClass != null) ? scan.PlanetClass : ""));
writer.Write(csv.Format((scan.Atmosphere != null) ? scan.Atmosphere : ""));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Iron")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Silicates")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("SulphurDioxide")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("CarbonDioxide")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Nitrogen")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Oxygen")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Water")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Argon")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Ammonia")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Methane")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Hydrogen")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Helium")));
writer.Write(csv.Format((scan.Volcanism != null) ? scan.Volcanism : ""));
writer.Write(csv.Format(scan.nSurfaceGravity.HasValue ? scan.nSurfaceGravity.Value : 0));
writer.Write(csv.Format(scan.nSurfacePressure.HasValue ? scan.nSurfacePressure.Value : 0));
writer.Write(csv.Format(scan.nLandable.HasValue ? scan.nLandable.Value : false));
writer.Write(csv.Format((scan.nMassEM.HasValue) ? scan.nMassEM.Value : 0));
writer.Write(csv.Format(scan.GetCompositionPercent("Ice")));
writer.Write(csv.Format(scan.GetCompositionPercent("Rock")));
writer.Write(csv.Format(scan.GetCompositionPercent("Metal")));
}
// Common orbital param
writer.Write(csv.Format(scan.nSemiMajorAxis.HasValue ? scan.nSemiMajorAxis.Value : 0));
writer.Write(csv.Format(scan.nEccentricity.HasValue ? scan.nEccentricity.Value : 0));
writer.Write(csv.Format(scan.nOrbitalInclination.HasValue ? scan.nOrbitalInclination.Value : 0));
writer.Write(csv.Format(scan.nPeriapsis.HasValue ? scan.nPeriapsis.Value : 0));
writer.Write(csv.Format(scan.nOrbitalPeriod.HasValue ? scan.nOrbitalPeriod.Value : 0));
writer.Write(csv.Format(scan.nAxialTilt.HasValue ? scan.nAxialTilt : null));
if (ShowPlanets)
{
writer.Write(csv.Format(scan.GetMaterial("Carbon")));
writer.Write(csv.Format(scan.GetMaterial("Iron")));
writer.Write(csv.Format(scan.GetMaterial("Nickel")));
writer.Write(csv.Format(scan.GetMaterial("Phosphorus")));
writer.Write(csv.Format(scan.GetMaterial("Sulphur")));
writer.Write(csv.Format(scan.GetMaterial("Arsenic")));
writer.Write(csv.Format(scan.GetMaterial("Chromium")));
writer.Write(csv.Format(scan.GetMaterial("Germanium")));
writer.Write(csv.Format(scan.GetMaterial("Manganese")));
writer.Write(csv.Format(scan.GetMaterial("Selenium")));
writer.Write(csv.Format(scan.GetMaterial("Vanadium")));
writer.Write(csv.Format(scan.GetMaterial("Zinc")));
writer.Write(csv.Format(scan.GetMaterial("Zirconium")));
writer.Write(csv.Format(scan.GetMaterial("Cadmium")));
writer.Write(csv.Format(scan.GetMaterial("Mercury")));
writer.Write(csv.Format(scan.GetMaterial("Molybdenum")));
writer.Write(csv.Format(scan.GetMaterial("Niobium")));
writer.Write(csv.Format(scan.GetMaterial("Tin")));
writer.Write(csv.Format(scan.GetMaterial("Tungsten")));
writer.Write(csv.Format(scan.GetMaterial("Antimony")));
writer.Write(csv.Format(scan.GetMaterial("Polonium")));
writer.Write(csv.Format(scan.GetMaterial("Ruthenium")));
writer.Write(csv.Format(scan.GetMaterial("Technetium")));
writer.Write(csv.Format(scan.GetMaterial("Tellurium")));
writer.Write(csv.Format(scan.GetMaterial("Yttrium")));
}
writer.WriteLine();
}
}
writer.Close();
}
if (frm.AutoOpen)
{
System.Diagnostics.Process.Start(frm.Path);
}
}
}
catch
{
ExtendedControls.MessageBoxTheme.Show(FindForm(), "Failed to write to " + frm.Path, "Export Failed", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
private void buttonExtExcel_Click(object sender, EventArgs e)
{
Forms.ExportForm frm = new Forms.ExportForm();
frm.Init(new string[] { "All", "Stars only",
"Planets only", //2
"Exploration List Stars", //3
"Exploration List Planets", //4
"Sold Exploration Data", // 5
});
if (frm.ShowDialog(FindForm()) == DialogResult.OK)
{
BaseUtils.CSVWrite csv = new BaseUtils.CSVWrite();
csv.SetCSVDelimiter(frm.Comma);
try
{
using (System.IO.StreamWriter writer = new System.IO.StreamWriter(frm.Path))
{
if (frm.SelectedIndex == 5)
{
int count;
List <HistoryEntry> data = HistoryList.FilterByJournalEvent(discoveryform.history.ToList(), "Sell Exploration Data", out count);
data = (from he in data where he.EventTimeLocal >= frm.StartTime && he.EventTimeLocal <= frm.EndTime orderby he.EventTimeUTC descending select he).ToList();
List <HistoryEntry> scans = HistoryList.FilterByJournalEvent(discoveryform.history.ToList(), "Scan", out count);
if (frm.IncludeHeader)
{
writer.Write(csv.Format("Time"));
writer.Write(csv.Format("System"));
writer.Write(csv.Format("Star type"));
writer.Write(csv.Format("Planet type", false));
writer.WriteLine();
}
foreach (HistoryEntry he in data)
{
JournalSellExplorationData jsed = he.journalEntry as JournalSellExplorationData;
if (jsed == null || jsed.Discovered == null)
{
continue;
}
foreach (String system in jsed.Discovered)
{
writer.Write(csv.Format(jsed.EventTimeLocal));
writer.Write(csv.Format(system));
EDStar star = EDStar.Unknown;
EDPlanet planet = EDPlanet.Unknown_Body_Type;
foreach (HistoryEntry scanhe in scans)
{
JournalScan scan = scanhe.journalEntry as JournalScan;
if (scan.BodyName.Equals(system, StringComparison.OrdinalIgnoreCase))
{
star = scan.StarTypeID;
planet = scan.PlanetTypeID;
break;
}
}
writer.Write(csv.Format((star != EDStar.Unknown) ? Enum.GetName(typeof(EDStar), star) : ""));
writer.Write(csv.Format((planet != EDPlanet.Unknown_Body_Type) ? Enum.GetName(typeof(EDPlanet), planet) : "", false));
writer.WriteLine();
}
}
}
else
{
List <JournalScan> scans = null;
if (frm.SelectedIndex < 3)
{
var entries = JournalEntry.GetByEventType(JournalTypeEnum.Scan, EDCommander.CurrentCmdrID, frm.StartTime, frm.EndTime);
scans = entries.ConvertAll(x => (JournalScan)x);
}
else
{
ExplorationSetClass currentExplorationSet = new ExplorationSetClass();
string file = currentExplorationSet.DialogLoad(FindForm());
if (file != null)
{
scans = new List <JournalScan>();
foreach (string system in currentExplorationSet.Systems)
{
ISystem sys = SystemCache.FindSystem(system);
if (sys != null)
{
List <JournalScan> sysscans = EDSMClass.GetBodiesList(sys.EDSMID);
if (sysscans != null)
{
scans.AddRange(sysscans);
}
}
}
}
else
{
return;
}
}
bool ShowStars = frm.SelectedIndex < 2 || frm.SelectedIndex == 3;
bool ShowPlanets = frm.SelectedIndex == 0 || frm.SelectedIndex == 2 || frm.SelectedIndex == 4;
List <JournalSAAScanComplete> mappings = ShowPlanets ?
JournalEntry.GetByEventType(JournalTypeEnum.SAAScanComplete, EDCommander.CurrentCmdrID, frm.StartTime, frm.EndTime)
.ConvertAll(x => (JournalSAAScanComplete)x)
: null;
if (frm.IncludeHeader)
{
// Write header
writer.Write(csv.Format("Time"));
writer.Write(csv.Format("BodyName"));
writer.Write(csv.Format("Estimated Value"));
writer.Write(csv.Format("DistanceFromArrivalLS"));
writer.Write(csv.Format("WasMapped"));
writer.Write(csv.Format("WasDiscovered"));
if (ShowStars)
{
writer.Write(csv.Format("StarType"));
writer.Write(csv.Format("StellarMass"));
writer.Write(csv.Format("AbsoluteMagnitude"));
writer.Write(csv.Format("Age MY"));
writer.Write(csv.Format("Luminosity"));
}
writer.Write(csv.Format("Radius"));
writer.Write(csv.Format("RotationPeriod"));
writer.Write(csv.Format("SurfaceTemperature"));
if (ShowPlanets)
{
writer.Write(csv.Format("TidalLock"));
writer.Write(csv.Format("TerraformState"));
writer.Write(csv.Format("PlanetClass"));
writer.Write(csv.Format("Atmosphere"));
writer.Write(csv.Format("Iron"));
writer.Write(csv.Format("Silicates"));
writer.Write(csv.Format("SulphurDioxide"));
writer.Write(csv.Format("CarbonDioxide"));
writer.Write(csv.Format("Nitrogen"));
writer.Write(csv.Format("Oxygen"));
writer.Write(csv.Format("Water"));
writer.Write(csv.Format("Argon"));
writer.Write(csv.Format("Ammonia"));
writer.Write(csv.Format("Methane"));
writer.Write(csv.Format("Hydrogen"));
writer.Write(csv.Format("Helium"));
writer.Write(csv.Format("Volcanism"));
writer.Write(csv.Format("SurfaceGravity"));
writer.Write(csv.Format("SurfacePressure"));
writer.Write(csv.Format("Landable"));
writer.Write(csv.Format("EarthMasses"));
writer.Write(csv.Format("IcePercent"));
writer.Write(csv.Format("RockPercent"));
writer.Write(csv.Format("MetalPercent"));
}
// Common orbital param
writer.Write(csv.Format("SemiMajorAxis"));
writer.Write(csv.Format("Eccentricity"));
writer.Write(csv.Format("OrbitalInclination"));
writer.Write(csv.Format("Periapsis"));
writer.Write(csv.Format("OrbitalPeriod"));
writer.Write(csv.Format("AxialTilt"));
if (ShowPlanets)
{
writer.Write(csv.Format("Carbon"));
writer.Write(csv.Format("Iron"));
writer.Write(csv.Format("Nickel"));
writer.Write(csv.Format("Phosphorus"));
writer.Write(csv.Format("Sulphur"));
writer.Write(csv.Format("Arsenic"));
writer.Write(csv.Format("Chromium"));
writer.Write(csv.Format("Germanium"));
writer.Write(csv.Format("Manganese"));
writer.Write(csv.Format("Selenium"));
writer.Write(csv.Format("Vanadium"));
writer.Write(csv.Format("Zinc"));
writer.Write(csv.Format("Zirconium"));
writer.Write(csv.Format("Cadmium"));
writer.Write(csv.Format("Mercury"));
writer.Write(csv.Format("Molybdenum"));
writer.Write(csv.Format("Niobium"));
writer.Write(csv.Format("Tin"));
writer.Write(csv.Format("Tungsten"));
writer.Write(csv.Format("Antimony"));
writer.Write(csv.Format("Polonium"));
writer.Write(csv.Format("Ruthenium"));
writer.Write(csv.Format("Technetium"));
writer.Write(csv.Format("Tellurium"));
writer.Write(csv.Format("Yttrium"));
}
writer.WriteLine();
}
foreach (JournalScan je in scans)
{
JournalScan scan = je as JournalScan;
if (ShowPlanets == true && !string.IsNullOrEmpty(scan.PlanetClass))
{
var mapping = mappings?.FirstOrDefault(m => m.BodyID == scan.BodyID);
if (mapping != null)
{
scan.SetMapped(true, mapping.ProbesUsed <= mapping.EfficiencyTarget);
}
}
if (ShowPlanets == false) // Then only show stars.
{
if (String.IsNullOrEmpty(scan.StarType))
{
continue;
}
}
if (ShowStars == false) // Then only show planets
{
if (String.IsNullOrEmpty(scan.PlanetClass))
{
continue;
}
}
writer.Write(csv.Format(scan.EventTimeUTC));
writer.Write(csv.Format(scan.BodyName));
writer.Write(csv.Format(scan.EstimatedValue));
writer.Write(csv.Format(scan.DistanceFromArrivalLS));
writer.Write(csv.Format(scan.WasMapped));
writer.Write(csv.Format(scan.WasDiscovered));
if (ShowStars)
{
writer.Write(csv.Format(scan.StarType));
writer.Write(csv.Format((scan.nStellarMass.HasValue) ? scan.nStellarMass.Value : 0));
writer.Write(csv.Format((scan.nAbsoluteMagnitude.HasValue) ? scan.nAbsoluteMagnitude.Value : 0));
writer.Write(csv.Format((scan.nAge.HasValue) ? scan.nAge.Value : 0));
writer.Write(csv.Format(scan.Luminosity));
}
writer.Write(csv.Format(scan.nRadius.HasValue ? scan.nRadius.Value : 0));
writer.Write(csv.Format(scan.nRotationPeriod.HasValue ? scan.nRotationPeriod.Value : 0));
writer.Write(csv.Format(scan.nSurfaceTemperature.HasValue ? scan.nSurfaceTemperature.Value : 0));
if (ShowPlanets)
{
writer.Write(csv.Format(scan.nTidalLock.HasValue ? scan.nTidalLock.Value : false));
writer.Write(csv.Format((scan.TerraformState != null) ? scan.TerraformState : ""));
writer.Write(csv.Format((scan.PlanetClass != null) ? scan.PlanetClass : ""));
writer.Write(csv.Format((scan.Atmosphere != null) ? scan.Atmosphere : ""));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Iron")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Silicates")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("SulphurDioxide")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("CarbonDioxide")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Nitrogen")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Oxygen")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Water")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Argon")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Ammonia")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Methane")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Hydrogen")));
writer.Write(csv.Format(scan.GetAtmosphereComponent("Helium")));
writer.Write(csv.Format((scan.Volcanism != null) ? scan.Volcanism : ""));
writer.Write(csv.Format(scan.nSurfaceGravity.HasValue ? scan.nSurfaceGravity.Value : 0));
writer.Write(csv.Format(scan.nSurfacePressure.HasValue ? scan.nSurfacePressure.Value : 0));
writer.Write(csv.Format(scan.nLandable.HasValue ? scan.nLandable.Value : false));
writer.Write(csv.Format((scan.nMassEM.HasValue) ? scan.nMassEM.Value : 0));
writer.Write(csv.Format(scan.GetCompositionPercent("Ice")));
writer.Write(csv.Format(scan.GetCompositionPercent("Rock")));
writer.Write(csv.Format(scan.GetCompositionPercent("Metal")));
}
// Common orbital param
writer.Write(csv.Format(scan.nSemiMajorAxis.HasValue ? scan.nSemiMajorAxis.Value : 0));
writer.Write(csv.Format(scan.nEccentricity.HasValue ? scan.nEccentricity.Value : 0));
writer.Write(csv.Format(scan.nOrbitalInclination.HasValue ? scan.nOrbitalInclination.Value : 0));
writer.Write(csv.Format(scan.nPeriapsis.HasValue ? scan.nPeriapsis.Value : 0));
writer.Write(csv.Format(scan.nOrbitalPeriod.HasValue ? scan.nOrbitalPeriod.Value : 0));
writer.Write(csv.Format(scan.nAxialTilt.HasValue ? scan.nAxialTilt : null));
if (ShowPlanets)
{
writer.Write(csv.Format(scan.GetMaterial("Carbon")));
writer.Write(csv.Format(scan.GetMaterial("Iron")));
writer.Write(csv.Format(scan.GetMaterial("Nickel")));
writer.Write(csv.Format(scan.GetMaterial("Phosphorus")));
writer.Write(csv.Format(scan.GetMaterial("Sulphur")));
writer.Write(csv.Format(scan.GetMaterial("Arsenic")));
writer.Write(csv.Format(scan.GetMaterial("Chromium")));
writer.Write(csv.Format(scan.GetMaterial("Germanium")));
writer.Write(csv.Format(scan.GetMaterial("Manganese")));
writer.Write(csv.Format(scan.GetMaterial("Selenium")));
writer.Write(csv.Format(scan.GetMaterial("Vanadium")));
writer.Write(csv.Format(scan.GetMaterial("Zinc")));
writer.Write(csv.Format(scan.GetMaterial("Zirconium")));
writer.Write(csv.Format(scan.GetMaterial("Cadmium")));
writer.Write(csv.Format(scan.GetMaterial("Mercury")));
writer.Write(csv.Format(scan.GetMaterial("Molybdenum")));
writer.Write(csv.Format(scan.GetMaterial("Niobium")));
writer.Write(csv.Format(scan.GetMaterial("Tin")));
writer.Write(csv.Format(scan.GetMaterial("Tungsten")));
writer.Write(csv.Format(scan.GetMaterial("Antimony")));
writer.Write(csv.Format(scan.GetMaterial("Polonium")));
writer.Write(csv.Format(scan.GetMaterial("Ruthenium")));
writer.Write(csv.Format(scan.GetMaterial("Technetium")));
writer.Write(csv.Format(scan.GetMaterial("Tellurium")));
writer.Write(csv.Format(scan.GetMaterial("Yttrium")));
}
writer.WriteLine();
}
}
writer.Close();
if (frm.AutoOpen)
{
System.Diagnostics.Process.Start(frm.Path);
}
}
}
catch
{
ExtendedControls.MessageBoxTheme.Show(FindForm(), "Failed to write to " + frm.Path, "Export Failed", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
override public bool ToCSV(string filename)
{
try
{
using (StreamWriter writer = new StreamWriter(filename))
{
if (IncludeHeader)
{
// Write header
writer.Write("Time" + delimiter);
writer.Write("BodyName" + delimiter);
writer.Write("DistanceFromArrivalLS" + delimiter);
if (ShowStars)
{
writer.Write("StarType" + delimiter);
writer.Write("StellarMass" + delimiter);
writer.Write("AbsoluteMagnitude" + delimiter);
writer.Write("Age MY" + delimiter);
}
writer.Write("Radius" + delimiter);
writer.Write("RotationPeriod" + delimiter);
writer.Write("SurfaceTemperature" + delimiter);
if (ShowPlanets)
{
writer.Write("TidalLock" + delimiter);
writer.Write("TerraformState" + delimiter);
writer.Write("PlanetClass" + delimiter);
writer.Write("Atmosphere" + delimiter);
writer.Write("Volcanism" + delimiter);
writer.Write("SurfaceGravity" + delimiter);
writer.Write("SurfacePressure" + delimiter);
writer.Write("Landable" + delimiter);
writer.Write("EarthMasses" + delimiter);
}
// Common orbital param
writer.Write("SemiMajorAxis" + delimiter);
writer.Write("Eccentricity" + delimiter);
writer.Write("OrbitalInclination" + delimiter);
writer.Write("Periapsis" + delimiter);
writer.Write("OrbitalPeriod" + delimiter);
if (ShowPlanets)
{
writer.Write("Carbon" + delimiter);
writer.Write("Iron" + delimiter);
writer.Write("Nickel" + delimiter);
writer.Write("Phosphorus" + delimiter);
writer.Write("Sulphur" + delimiter);
writer.Write("Arsenic" + delimiter);
writer.Write("Chromium" + delimiter);
writer.Write("Germanium" + delimiter);
writer.Write("Manganese" + delimiter);
writer.Write("Selenium" + delimiter);
writer.Write("Vanadium" + delimiter);
writer.Write("Zinc" + delimiter);
writer.Write("Zirconium" + delimiter);
writer.Write("Cadmium" + delimiter);
writer.Write("Mercury" + delimiter);
writer.Write("Molybdenum" + delimiter);
writer.Write("Niobium" + delimiter);
writer.Write("Tin" + delimiter);
writer.Write("Tungsten" + delimiter);
writer.Write("Antimony" + delimiter);
writer.Write("Polonium" + delimiter);
writer.Write("Ruthenium" + delimiter);
writer.Write("Technetium" + delimiter);
writer.Write("Tellurium" + delimiter);
writer.Write("Yttrium" + delimiter);
}
writer.WriteLine();
}
foreach (JournalScan je in scans)
{
JournalScan scan = je as JournalScan;
if (ShowPlanets == false) // Then only show stars.
{
if (String.IsNullOrEmpty(scan.StarType))
{
continue;
}
}
if (ShowStars == false) // Then only show planets
{
if (String.IsNullOrEmpty(scan.PlanetClass))
{
continue;
}
}
writer.Write(MakeValueCsvFriendly(scan.EventTimeUTC));
writer.Write(MakeValueCsvFriendly(scan.BodyName));
writer.Write(MakeValueCsvFriendly(scan.DistanceFromArrivalLS));
if (ShowStars)
{
writer.Write(MakeValueCsvFriendly(scan.StarType));
writer.Write(MakeValueCsvFriendly((scan.nStellarMass.HasValue) ? scan.nStellarMass.Value : 0));
writer.Write(MakeValueCsvFriendly((scan.nAbsoluteMagnitude.HasValue) ? scan.nAbsoluteMagnitude.Value : 0));
writer.Write(MakeValueCsvFriendly((scan.nAge.HasValue) ? scan.nAge.Value : 0));
}
writer.Write(MakeValueCsvFriendly(scan.nRadius.HasValue ? scan.nRadius.Value : 0));
writer.Write(MakeValueCsvFriendly(scan.nRotationPeriod.HasValue ? scan.nRotationPeriod.Value : 0));
writer.Write(MakeValueCsvFriendly(scan.nSurfaceTemperature.HasValue ? scan.nSurfaceTemperature.Value : 0));
if (ShowPlanets)
{
writer.Write(MakeValueCsvFriendly(scan.nTidalLock.HasValue ? scan.nTidalLock.Value : false));
writer.Write(MakeValueCsvFriendly((scan.TerraformState != null)? scan.TerraformState : ""));
writer.Write(MakeValueCsvFriendly((scan.PlanetClass != null)? scan.PlanetClass : ""));
writer.Write(MakeValueCsvFriendly((scan.Atmosphere != null)? scan.Atmosphere : ""));
writer.Write(MakeValueCsvFriendly((scan.Volcanism != null)? scan.Volcanism : ""));
writer.Write(MakeValueCsvFriendly(scan.nSurfaceGravity.HasValue ? scan.nSurfaceGravity.Value : 0));
writer.Write(MakeValueCsvFriendly(scan.nSurfacePressure.HasValue ? scan.nSurfacePressure.Value : 0));
writer.Write(MakeValueCsvFriendly(scan.nLandable.HasValue ? scan.nLandable.Value : false));
writer.Write(MakeValueCsvFriendly((scan.nMassEM.HasValue) ? scan.nMassEM.Value : 0));
}
// Common orbital param
writer.Write(MakeValueCsvFriendly(scan.nSemiMajorAxis.HasValue ? scan.nSemiMajorAxis.Value : 0));
writer.Write(MakeValueCsvFriendly(scan.nEccentricity.HasValue ? scan.nEccentricity.Value : 0));
writer.Write(MakeValueCsvFriendly(scan.nOrbitalInclination.HasValue ? scan.nOrbitalInclination.Value : 0));
writer.Write(MakeValueCsvFriendly(scan.nPeriapsis.HasValue ? scan.nPeriapsis.Value : 0));
writer.Write(MakeValueCsvFriendly(scan.nOrbitalPeriod.HasValue ? scan.nOrbitalPeriod.Value : 0));
if (ShowPlanets)
{
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Carbon")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Iron")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Nickel")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Phosphorus")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Sulphur")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Arsenic")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Chromium")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Germanium")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Manganese")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Selenium")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Vanadium")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Zinc")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Zirconium")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Cadmium")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Mercury")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Molybdenum")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Niobium")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Tin")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Tungsten")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Antimony")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Polonium")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Ruthenium")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Technetium")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Tellurium")));
writer.Write(MakeValueCsvFriendly(scan.GetMaterial("Yttrium")));
}
writer.WriteLine();
}
}
return(true);
}
catch (IOException)
{
EDDiscovery.Forms.MessageBoxTheme.Show(String.Format("Is file {0} open?", filename), "Export Scan",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}