Everything posted by Chase E
Dynamic Attributes for Asset Tree
Chase E posted a topic in Seeq Data LabHello! I am trying to make an asset tree for my plant. Basically, I want to build a structure that contains the signals for different sections of my plant. However, these different sections have very little similarity. When I look at the documentation on Jupiter lab for building assets, each time an asset must be built, you must also build a custom class with pre-defined attributes for each asset. However, I do not want to build assets that have predefined attributes. Rather I want to build an asset for each major piece of equipment, and then have the flexibility to upload whatever signals are available for that given piece of equipment, without being confined to certain types of predefined signals. Is there a way to bulk create and upload an asset tree such that I have the flexibility to associate a dynamic number and type of attributes for each asset? So, for example, I would like the following structure for an asset tree, and I'm hoping to be able to do it with one bulk upload: Furnace 1: 2 temperature signal, 1 flow rate signal, 1 analyzer signal Furnace 2: 1 temperature signal, 2 flow rate signal, 2 analyzer signal Reactor: 4 flow rate signal, 1 temperature signal Compressor: 2 pressure tags Pump: 4 pressure tags
Querying a SEEQ Workbook TABLE from Excel using SEEQ API
Chase E replied to Chase E's topic in General Seeq DiscussionsThank you for the reply! So far OData is working pretty well for my needs. However, I get a weird issue with the data tables that I pull using the ODATA functionality... For some reason, the data auto-formats to a string/text data type once it enters the excel table. This makes it a little harder to work with because I can't run basic number formulas on the ODATA table (like max, min, avg, etc). But I'm still able to get the data into EXCEL, and that's a huge first step! Next step is figuring out how to have the data tables formatted appropriately, and then after that exploring options for making the data pulls a little faster (I have 3 ODATA queries for 3 different SEEQ worksheets, I might have to concolidate all the SEEQ signals and calcs to a single SEEQ workseet to make it a single ODATA query).
I've got an excel monitoring tool that our operators will use daily. I'd like to be able to build a functionality within the excel tool for pulling data directly from SEEQ into the excel tool. Ideally, I could build some VBA query that works in the background to pull the data from SEEQ using the API, and our operators just click a button to run the VBA code that will query the SEEQ API. Is there a way to do this? To pull data directly from SEEQ without leaving the EXCEL environment?