obrien.david.j Posted January 6, 2020 Share Posted January 6, 2020 @SuncrestReef and I were in a different thread, that branched into graphing Apex data manually. I'm starting this thread to continue that discussion cleanly. Summary: John pasted an excel graph that he manually created. I lamented not knowing any automated Apex Datalog Extractor code. John replied with some links, but none were out of the box solutions. I decided to just give it a go manually. On 1/3/2020 at 2:44 PM, SuncrestReef said: There are several threads on XML in the Neptune Forums. I tinkered with it a year ago, but got frustrated and gave up on it. See: https://forum.neptunesystems.com/showthread.php?22148-Accessing-XML-datalog-amp-output-log-using-Microsoft-Office-365-Excel-on-a-Mac https://forum.neptunesystems.com/showthread.php?258-XML https://forum.neptunesystems.com/showthread.php?223-Quick-Apex-Graphs-using-Google-Chart&p=961 I downloaded all datalog and outlogs from my Apex. Looks like it stored Nov 26, 2019 - Jan 5, 2020 worth of data. Then manipulated into data I could graph. Wasn't simple, ran though Excel, then SAS-JMP. Was complicated by me re-naming my inputs a month ago, and both old and new names were recorded. I'll do a walk through of the steps in a post tonight. And show the results in a second... (Source Thread: 1 Quote Link to comment Share on other sites More sharing options...
obrien.david.j Posted January 6, 2020 Author Share Posted January 6, 2020 First cut at my tank data, in one view: 3 Quote Link to comment Share on other sites More sharing options...
Yourmedic Posted April 14, 2023 Share Posted April 14, 2023 Just looking for follow up information or where this is currently at? Did you find a way to have it auto export for you @obrien.david.j? Quote Link to comment Share on other sites More sharing options...
obrien.david.j Posted April 15, 2023 Author Share Posted April 15, 2023 I've created an excel file, which auto connects to your apex, downloads data, freeze it, and do basic formatting. I run it (manually) about every 3 weeks, because thats about as long as my apex stores data. With a big tab of data, I can then manipulate it into graphs (like above) when I'm interested. 1yrs worth of data just about breaks my PC. But at least I'm capable of looking back for trends when I'm trying to solve a problem. I'm happy to share the basic excel, how to configure it to your network, and how to run it. It's a bit finicky, but works. It does require Windows Excel 365, latest version. (no luck on a mac) Quote Link to comment Share on other sites More sharing options...
.thumb.jpg.fe177d4e243fa0a2f5c6c5891f6b1bca.jpg)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.