I have a number of questions regarding the Orion Datbase.
First I will preface with a description of my final objective to bring reason to my questions. I would like to create a resources for routers that will show information about circuits a certain router may have. Currently we have an excel spreadsheet with all the desired information. I would like to be able to add that information to a newly created Orion table and then use a custom resource to display that information.
So my questions are as follows:
1. Can you import data from an excel spread sheet (CSV) into a Orion Table? Can this be done via a script when updates to that info are needed when circuits change?
2. Can the creation of the table and the updates to the table be done while the Orin service is running? If so, will the new information be accurate and visible on the Orion Website?
3. I know that for the stock resources code such as Nodes.GetProperty("GroupStatus") gets the info from the database. Lets say I have a table CustomInfo with a Column of InfoID. would the command CustomInfo.GetProperty("InfoID") return the value that I want?
If there are already similar items in the content sharing I could not find them, so by all means point me in that direction.
Thanks in advance.