Script to Check number of Passed Tests

[Kenny_K]

I have a test station that will save a TDMS file for each Day, and then in the day, a group will be created with a timestamp for each part tested and then the channels of data in each group.

We would like to run a report each day on the number of passed/failed tests.  Each group (ie each test) has custom properties to them, one of which is a string of the test result (aborted, passed, failed).

I am having trouble figuring out how to search the file for the custom properties and then being able to display that information.

What I want to have displayed is the number of total tests for the day (ie the number of groups), the number that passed, and the number that failed/aborted.

Then I wanted to list the groups (tests) that failed in a table.

I have tried to set up a variable text field on the report page, but I cannot seem to find the Test Result field in the special variables section.  Are the custom variables not availible for this?

Thanks.

[John_M.]

Hi Kenny,

I found another thread which seems to answer what you are asking about. Please take a look at Use TDMS attributes in DIAdem VBscript and see if that answers your question. If not, please clarify for us what you need to be able to do differently from the other thread.

Best Regards,

John M

[Kenny_K]

I was able to track down what I needed.

I did not have my tdms file in a location that the data finder normally looked, so even though I loaded it into the data portal, it had not be "indexed" by the datafinder, so the custom properties were not "availible" for me to search them.

Once I moved the file to a folder that datafinder was looking at, all of the properties were readily accessible and I was able to perform my search as I wanted.  Thanks.

[Brad_Turpin]

Hi Kenny,

I have a series of custom menus that make it much easier to analyze and report queried scalar properties, such as pass/fail and limit tests.  Let me know if you're interested.

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[Kenny_K]

Brad,

Very much so, yes please.

Thanks.

[Brad_Turpin]

Hi Kenny,

I posted the file to the NI outgoinng ftp site-- you'll have to grab it in the next few days before it gets automatically wiped off. 

Look for the "Using ResultsList Menus.doc" file in the main "CompanyName" folder, it will have installation instructions and step by step how-to-use information.  Also feel free to email me with questions at brad.turpin@ni.com.

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[jakidd]

Brad, I am interested in this as well. Is it possible to re-post this? thanks

[Jim West]

This is another example that shows if the Datafinder had query aggregate functions, the task would simple. The user would create a query like" For each group(test) where(query) Count (property)" Jim

[Brad_Turpin]

Hi jakidd,

I reposted the menu to our outgoing ftp site, you'll have a few days to download it.

Brad Turpin

DIAdem Product Support Engineer

National Instruments