Archiving [SQL is the way to go]

[MogaRaghu]

For a test rig application I need to save test data ( a combination of string and numeric fields ) and then be able to do the following with the collected data :

1. Retrieve and view specific result(s) based on a search criteria.

Some of the possible search queries are :

"Show me test data of Serial number xxx "
"Show me results of all tests done on mm-dd-yy"
"Show me the serial numbers of all tests that have passed on mm-dd-yy"

I have currently coded a VI where it is able to store the test data in spread sheet style using the (Build Array.vi , Array to SpreadSheet.vi and Write Character to file.vi).

I am yet to start coding for the retrieval part ( it does look difficult !). Before I do that, I was wondering if this is the right approach or LV has some other better way of putting data into data bases and retrieving them based on queries.

Has anybody handled such a case ? It would be nice to hear on details if so.

Thanks

Raghunathan

[bdougr]

I would use a database - Access or MySQL for data storage
once the data is there you can easily get it through SQL commands or even excel

SELECT * from database.resultstable WHERE database.date > #02/12/2005 14:00# and passfail = 'True'

The same querie will work with excel using the query wizard. Excel is great since you can easily put the data into pivot tables and send the reports to anyone.

Labview has the SPC toolkit that thru some additional effort can give you great process charts

Hope that helps... SQL is powerful and somewhat easy to learn

[MogaRaghu]

---

@bdougr wrote:

Labview has the SPC toolkit that thru some additional effort can give you great process charts

Hope that helps... SQL is powerful and somewhat easy to learn

---

Is the SPC tool kit a native component of the LV7.1 full development system ?


Thanks

Raghunathan

[Philip_Courtois]

Hi Raghunathan,

The SPC Toolkit is part can be purchased seperately or bundled with the Internet Toolkit and Database Toolset in a package called the Enterprise Connectivity Toolset. It also comes with the Professional versions of the Developer Suites.

[unclebump]

If you have the DSC module, you can save your results to memory tags in the tag engine. Then use the historical vi's to read data out of the Citadel database.