static async void Build()
{
bool locationBuild = false;
Console.WriteLine();
Console.WriteLine("Build JSON from CSV.");
IniFile ini = new IniFile();
if (!File.Exists(iniPath))
{
File.WriteAllText(iniPath, "");
}
ini.Load(iniPath);
Console.WriteLine("Infos :");
string path = ini.GetKeyValue("Config", "OutputPath");
string lpath = ini.GetKeyValue("Config", "OutputLocationPath");
Console.WriteLine($" Output path : {path}");
Console.WriteLine($" Location output path : {lpath}");
if (File.Exists(path))
{
Console.WriteLine($" The file {path} already exists and will be updated.");
}
if (File.Exists(lpath))
{
Console.WriteLine($" The file {lpath} already exists and will be updated.");
}
Console.WriteLine();
Console.WriteLine("Converting Excel files to Csv...");
List <CsvElement> csvElements = new List <CsvElement>();
List <CsvConcept> csvConcepts = new List <CsvConcept>();
List <CsvCountry> csvCountries = new List <CsvCountry>();
List <CsvRegion> csvRegions = new List <CsvRegion>();
List <CsvPeople> csvPeoples = new List <CsvPeople>();
List <CsvProject> csvProjects = new List <CsvProject>();
List <CsvPublication> csvPublications = new List <CsvPublication>();
Console.WriteLine("Reading data from csv documents...");
string str = "";
string name = "";
Dictionary <string, string> dic = new Dictionary <string, string>();
// Converts all excel files found in config.ini to csv files, in a temporary dir.
name = "Elements";
str = ini.GetKeyValue("ExcelFiles", name);
if (!File.Exists(str))
{
Console.WriteLine($"error: {name} csv file could not be found.");
}
else
{
ExcelService.SaveAsCsv(str,
Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
dic.Add(name, Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
}
name = "Concepts";
str = ini.GetKeyValue("ExcelFiles", name);
if (!File.Exists(str))
{
Console.WriteLine($"error: {name} csv file could not be found.");
}
else
{
ExcelService.SaveAsCsv(str,
Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
dic.Add(name, Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
}
name = "Countries";
str = ini.GetKeyValue("ExcelFiles", name);
if (!File.Exists(str))
{
Console.WriteLine($"error: {name} csv file could not be found.");
}
else
{
ExcelService.SaveAsCsv(str,
Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
dic.Add(name, Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
}
name = "Regions";
str = ini.GetKeyValue("ExcelFiles", name);
if (!File.Exists(str))
{
Console.WriteLine($"error: {name} csv file could not be found.");
}
else
{
ExcelService.SaveAsCsv(str,
Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
dic.Add(name, Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
}
name = "Projects";
str = ini.GetKeyValue("ExcelFiles", name);
if (!File.Exists(str))
{
Console.WriteLine($"error: {name} csv file could not be found.");
}
else
{
ExcelService.SaveAsCsv(str,
Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
dic.Add(name, Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
}
name = "Publications";
str = ini.GetKeyValue("ExcelFiles", name);
if (!File.Exists(str))
{
Console.WriteLine($"error: {name} csv file could not be found.");
}
else
{
ExcelService.SaveAsCsv(str,
Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
dic.Add(name, Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
}
name = "People";
str = ini.GetKeyValue("ExcelFiles", name);
if (!File.Exists(str))
{
Console.WriteLine($"error: {name} csv file could not be found.");
}
else
{
ExcelService.SaveAsCsv(str,
Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
dic.Add(name, Environment.GetFolderPath(Environment.SpecialFolder.InternetCache) + $@"\{name}.csv");
}
str = dic["Elements"];
if (!File.Exists(str))
{
Console.WriteLine("error: Elements csv file could not be found.");
}
else
{
csvElements = CsvElement.FromFile(str);
}
str = dic["Concepts"];
if (!File.Exists(str))
{
Console.WriteLine("error: Concepts csv file could not be found.");
}
else
{
csvConcepts = CsvConcept.FromFile(str);
}
str = dic["Countries"];
if (!File.Exists(str))
{
Console.WriteLine("error: Countries csv file could not be found.");
}
else
{
csvCountries = CsvCountry.FromFile(str);
}
str = dic["Regions"];
if (!File.Exists(str))
{
Console.WriteLine("error: Regions csv file could not be found.");
}
else
{
csvRegions = CsvRegion.FromFile(str);
}
str = dic["People"];
if (!File.Exists(str))
{
Console.WriteLine("error: People csv file could not be found.");
}
else
{
csvPeoples = CsvPeople.FromFile(str);
}
str = dic["Projects"];
if (!File.Exists(str))
{
Console.WriteLine("error: Projects csv file could not be found.");
}
else
{
csvProjects = CsvProject.FromFile(str);
}
str = dic["Publications"];
if (!File.Exists(str))
{
Console.WriteLine("error: Publications csv file could not be found.");
}
else
{
csvPublications = CsvPublication.FromFile(str);
}
Console.WriteLine("CSV files has been read. Building graph_xx.json...");
Console.WriteLine("Converting...");
var graphData = await SerializationService.ConvertToGraphData(csvConcepts, csvElements, csvCountries, csvPeoples,
csvProjects, csvPublications, csvRegions);
Console.WriteLine("Building...");
SerializationService.BuildGraphData(path, graphData);
Console.WriteLine("Graph file has been build.");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.Write("[Info] Do you want to build locations files (txt/json) ? Y/N : ");
string resp = Console.ReadLine();
Console.ForegroundColor = ConsoleColor.Gray;
if (!string.IsNullOrEmpty(resp) && resp.ToLower() == "y")
{
locationBuild = true;
Console.WriteLine("Building location text file...");
SerializationService.BuildLocationFile(lpath, graphData, csvConcepts);
Console.WriteLine("Location text file has been build.");
Console.WriteLine("Building location json file...");
ConstellationLocationGenerator.Build(lpath, $"{Path.GetDirectoryName(lpath)}\\constellation-node-locations_.json");
Console.WriteLine("Location json file has been build.");
Console.WriteLine($" Location txt output path : {lpath}");
Console.WriteLine($" Location txt output path : {Path.GetDirectoryName(lpath)}\\constellation-node-locations_.json");
}
Console.WriteLine($" Output path : {path}");
Console.WriteLine("");
}
