Example #1
0
        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("");
        }