Extracting total runtime from various files / filtering over channel values

[m_tt]

Hi everyone,

We've been collecting some datas over the past months (using a cDaq system) and we'd like to extract from all these TDMS files (maybe 1 or 2 hundred files) a couple of infos : 

1. How long has the system been running
2. How many thermal cycles it has gone through

For the 1. : we'd like to filter the files and/or times when either the RPM or a certain temperatures crosses a threshold. I tried to do so with the DIADEM advanced search but while it does finds the right channels, I can't seem to "filter" over their values.

Regarding 2. : we would need to set a low threshold with an hysteresis to know whenever it cycles through it. Haven't found anything like it on Diadem so I'm turning to the community for some guidance.

Thanks for the input!

m_tt

[m_tt]

I've been venturing into VBS scripts but not sure I have the skill to pull it off.

One thing I'm stumbling upon : should I open all the files in a directory and then do an event search over it?
It seems a very ressource-consuming method...

m_tt

[ArmandoF]

Hello m_tt,

Both of your needs are good candidates for VBS Scripts.

Please find ressources hereafter to help you get started.

https://www.ni.com/en/shop/data-acquisition-and-control/application-software-for-data-acquisition-an...

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000000YHjBCAW&l=en-US

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z0000019MhESAU&l=en-US

https://www.vbsedit.com/scripts/

Hope it will help!

Have a nice day 🙂

Armando

[Brad_Turpin]

Hi m_tt,

Do you have multiple cycles stored in one data file?  I assume so.  In that case, are those multiple cycles all represented in a set of channels, i.e. exactly one RPM channel, exactly one Temperature channel, etc., or do you have each cycle stored to a separate channel group?

It sounds like your best path forward is to do some preprocessing of your data to put each cycle in a separate channel group, then store various metrics of that cycle as group properties.  Once that's been saved back to disk in a Search Area, you can use the DataFinder to assemble and analyze the portions of data you desire with combinations of query conditions.

The background here is that the DataFinder does NOT index channel values, only File, Group and Channel properties.  So in order to query the data portions you want, they need to be already sectioned out (per cycle) with metrics attached (as properties) to each section (cycle) of data.

Brad Turpin

DIAdem Product Support Engineer

National Instrumetns