コード例 #1
0
        public static async Task <GraphData> ConvertToGraphData(List <CsvConcept> concepts, List <CsvElement> elements, List <CsvCountry> countries,
                                                                List <CsvPeople> peoples, List <CsvProject> projects, List <CsvPublication> publications, List <CsvRegion> regions)
        {
            List <NodeElement>     nodeElements     = new List <NodeElement>();
            List <NodeCountry>     nodeCountries    = new List <NodeCountry>();
            List <NodeProject>     nodeProjects     = new List <NodeProject>();
            List <NodeVt>          nodeConcepts     = new List <NodeVt>();
            List <NodePublication> nodePublications = new List <NodePublication>();
            List <NodeCaseStudy>   nodePeople       = new List <NodeCaseStudy>();

            foreach (var item in elements)
            {
                nodeElements.Add(CsvElement.ToNodeElement(item));
            }
            foreach (var item in countries)
            {
                nodeCountries.Add(CsvCountry.ToNodeElement(item));
            }
            foreach (var item in regions)
            {
                nodeCountries.Add(CsvRegion.ToNodeElement(item));
            }
            foreach (var item in projects)
            {
                nodeProjects.Add(CsvProject.ToNodeElement(item));
            }
            foreach (var item in concepts)
            {
                nodeConcepts.Add(CsvConcept.ToNodeElement(item));
            }
            foreach (var item in publications)
            {
                nodePublications.Add(CsvPublication.ToNodeElement(item));
            }
            foreach (var item in peoples)
            {
                nodePeople.Add(CsvPeople.ToNodeElement(item));
            }

            List <EdgeItem> edgeItems = new List <EdgeItem>();

            foreach (var concept in concepts)
            {
                if (concept.LinkedElements.Contains(","))
                {
                    string[] items = concept.LinkedElements.Split(',');
                    foreach (var s in items)
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = s, weight = 2
                        });
                    }
                }
                else
                {
                    if (!string.IsNullOrEmpty(concept.LinkedElements))
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = concept.LinkedElements, weight = 2
                        });
                    }
                }
            }
            foreach (var concept in elements)
            {
                if (concept.LinkedElements.Contains(","))
                {
                    string[] items = concept.LinkedElements.Split(',');
                    foreach (var s in items)
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = s, weight = 2
                        });
                    }
                }
                else
                {
                    if (!string.IsNullOrEmpty(concept.LinkedElements))
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = concept.LinkedElements, weight = 2
                        });
                    }
                }
            }
            foreach (var concept in countries)
            {
                if (concept.LinkedElements.Contains(","))
                {
                    string[] items = concept.LinkedElements.Split(',');
                    foreach (var s in items)
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = s, weight = 2
                        });
                    }
                }
                else
                {
                    if (!string.IsNullOrEmpty(concept.LinkedElements))
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = concept.LinkedElements, weight = 2
                        });
                    }
                }
            }
            foreach (var concept in regions)
            {
                if (concept.LinkedElements.Contains(","))
                {
                    string[] items = concept.LinkedElements.Split(',');
                    foreach (var s in items)
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = s, weight = 2
                        });
                    }
                }
                else
                {
                    if (!string.IsNullOrEmpty(concept.LinkedElements))
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = concept.LinkedElements, weight = 2
                        });
                    }
                }
            }
            foreach (var concept in peoples)
            {
                if (concept.LinkedElements.Contains(","))
                {
                    string[] items = concept.LinkedElements.Split(',');
                    foreach (var s in items)
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = s, weight = 2
                        });
                    }
                }
                else
                {
                    if (!string.IsNullOrEmpty(concept.LinkedElements))
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = concept.LinkedElements, weight = 2
                        });
                    }
                }
            }
            foreach (var concept in projects)
            {
                if (concept.LinkedElements.Contains(","))
                {
                    string[] items = concept.LinkedElements.Split(',');
                    foreach (var s in items)
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = s, weight = 2
                        });
                    }
                }
                else
                {
                    if (!string.IsNullOrEmpty(concept.LinkedElements))
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = concept.LinkedElements, weight = 2
                        });
                    }
                }
            }
            foreach (var concept in publications)
            {
                if (concept.LinkedElements.Contains(","))
                {
                    string[] items = concept.LinkedElements.Split(',');
                    foreach (var s in items)
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = s, weight = 2
                        });
                    }
                }
                else
                {
                    if (!string.IsNullOrEmpty(concept.LinkedElements))
                    {
                        edgeItems.Add(new EdgeItem()
                        {
                            Object = concept.Name, predicate = "related", subject = concept.LinkedElements, weight = 2
                        });
                    }
                }
            }

            GraphData graphData = new GraphData()
            {
                Meta = new Meta()
                {
                    generated = "Generated with ontoUcmd", language = "en"
                },
                NodeElements = nodeElements, NodeCountries = nodeCountries, NodeProjects = nodeProjects, NodePublications = nodePublications,
                NodeVts      = nodeConcepts, NodeCaseStudies = nodePeople, EdgeItems = edgeItems
            };

            return(graphData);
        }
コード例 #2
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("");
        }