Jump to content

Data repository


Recommended Posts

I've got a request to take test records from multiple stations and put them into a central system (likely a database) to pull reports from everyone. We used to have software to do this, but it's now a dead product. My management wants to look at an "off the shelf" solution. I was wondering what people are using to perform reports (production summary, histograms, etc.) on their data. 


We've got a sister division that has used Diadem, so I'm somewhat aware of that and what we would have to do to get that up. We've considered a couple of vendors, which have their own issues. We've considered building our own again.

Link to comment

If you want an off-the-shelf product, you'll need to find one that understands the raw records.


What format is your records stored in?


I've done one TestStand project, and my client was happy to use TestStand's built-in reporting functionality. We configured the station such that each test produces an ATML file for easy viewing, and also inserts the data directly into a Microsoft SQL Server database for easy querying and processing.

Edited by JKSH
Link to comment

This might be way more than you are looking for in terms of functionality, but I am using a full cloud based Test Data Management system called http://www.skywats.com/.


It is a cloud base Test Results Database with Yield & Trent Analysis, UUT reports, Root Cause analysis and much much more. They provide a number of different ways of getting test results into the system, TestStand integration, LabVIEW Toolkit and also free trail.

  • Like 1
Link to comment

I've used DIAdem in the past, and it is quite flexible with data formats.  It supports several kinds, and then plugins can be made to support more, but with no additional plugins it works well with some Excel formats, and TDMS.  I know ATML works with a plugin, which is great for TestStand outputs.


That being said I have rolled my own (sorta) using the DataFinder toolkit and TDMS files.  You just point DataFinder to a folder of files to index, then you can perform queries with the LabVIEW API.  I made a neat interface and put it on a server so people could login and perform a search based on criteria they wanted.  Like the test completed after this date, ran by this user, on this tester, in this nest location, and passed.  Then my program could perform a basis Gage R&R showing how values changed between reports that met that criteria.

Link to comment

If you want an off-the-shelf product, you'll need to find one that understands the raw records.


What format is your records stored in?


I have a CSV file for the measurements and a TDMS file for the waveforms. The portion of my code that saves the test record is a plugin, so the file format of the record can be altered fairly easily.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.