FTView 9.0 Datalog

Hey guys, long time forum scavenger first time poster here!

So my company has been a long time user of RSView32 and we've grown quite accustomed to the ease of logging and more specifically the formatting.

We're now in the process of rolling out HMI's with FTView 9.0 and are trying to get data logs into a friendly format.

Right now we have SQL Server running on the same PC's as the FTView Local Station and we have our data logs setup over ODBC to log to the server which is working just fine. In the VBA we're trying to execute an SQL query that returns a modified version of the FloatTable; basically since it logs all of the tags vertically in the TagIndex column our SQL query returns each TagIndex as a separate column with the corresponding values/datetimes. We have the query working and now to my question:

We've noticed that sometimes at a given DateAndTime - Millitm there will only be a reading for one of the tags - example below:

----------------------------------------------
DateAndTime | Millitm | TagIndex | Val |
----------------------------------------------
12:00:00 | 200 | 1 | 20.5 | - Index 1 is analog
12:00:00 | 500 | 1 | 20.0 |
12:00:00 | 500 | 2 | 1 | - Index 2 is boolean
12:00:01 | 200 | 1 | 19.8 |
12:00:01 | 500 | 1 | 19.5 |
12:00:01 | 500 | 2 | 1 |

So what happens when we query to create a our modified table, the times where only one tag was logged will give us a reading of zero for the tag that wasn't read. This is especially annoying for boolean tags. Example of output table:

-------------------------------------------------------
DateAndTime | Millitm | TagIndex1 | TagIndex2 |
-------------------------------------------------------
12:00:00 | 200 | 20.5 | 0 |
12:00:00 | 500 | 20.0 | 1 |
12:00:01 | 200 | 19.8 | 0 |
12:00:01 | 500 | 19.5 | 1 |

Is there a way to force the log to always capture all tags for a given time? Does this only happen when you set the log to On Change instead of periodic? Thanks for any help!

Welcome to the forum!

I'm not familiar enough with the VBA side of things to give confident advice on this, so I think I'll leave it for others to chime in, but one minor tip with regard to your data columns in your post - you've obviously used a fixed width font to line everything up, but of course it doesn't render that way on the forum, and can be a little harder to interpret looking at it.

If you contain the text in "code" square brackets, i.e. [c0de]...data...[/c0de] (obviously with an "o" instead of a "0"), it displays it as fixed width and looks like you intended

Here's a cleaned up version of my tables. Thanks ASF!