Chase E Posted May 25, 2022 Share Posted May 25, 2022 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? Link to comment Share on other sites More sharing options...
Administrators Teddy Posted May 27, 2022 Administrators Share Posted May 27, 2022 It might be worth trying out Seeq’s OData export. Excel supports an OData feed so you can send data to Excel from Seeq with OData. I believe the live updating OData feed may require additional licensing. Here is a link to the OData documentation. https://support.seeq.com/space/KB/112868662/OData Export Link to comment Share on other sites More sharing options...
Seeq Team John Cox Posted May 27, 2022 Seeq Team Share Posted May 27, 2022 Hi Chase, Teddy has a great suggestion above on using Seeq's OData export. I also wanted to mention another option for your consideration: creating an Add-on tool in Seeq Workbench that has a button the operators click to pull the data. Seeq Add-ons use the Seeq Python Library module (SPy) with Seeq Data Lab. Add-ons can easily pull data into the Data Lab environment and create custom visualizations, calculations, charts, etc. using any Python library functionality, and all of this can be accessed from Seeq Workbench. This may or may not be a way to address your current need, but even if not, it may be a good solution for other applications in the future. There is a Seeq Add-on Gallery here: https://seeq12.github.io/gallery/ The following links provide additional information on how to create your own add-ons or install the open source add-ons: https://seeq.atlassian.net/wiki/spaces/KB/pages/2254536724/Add-ons Link to comment Share on other sites More sharing options...
Chase E Posted May 27, 2022 Author Share Posted May 27, 2022 Thank 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). Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now