Csv reports

[sumitrishi]

I need to customize a teststand sequence which currently generates an HTML report to additionally generate a csv report . The csv shall have the following values in it columsn
1st - Test No ( These can be auto generated also)
2nd - Test Dsecription
3rd - Units
4th - Lower Limit ( if any )
5th- Upper if Any
6th - Numerica Results( if Any)

I am pretty new to testand and have been struggling for some time with the property and invoke nodes . I will appreciate if someone can assist me with a sample of his code so that I can get past this stage .
I am using LabVIEW 6.1 and the way I was doing it was looking at addition of one extra step somewhere which intercepts the sequence context and format the data and puts it into a csv.

The seqeunce has tests that are nested to 2-3 levels and their report in HTML have indentations . In the csv they should just be listed in the order they are executed.Its like putting all of them in a big table irrespective of them being run as a test or sub-test

Thanking all in anticipation.

Sumit

[mfitzsimons]

I use a separate calls to LabVIEW VI to generate my CSV reports. Simple but effective. You can add one element at a time by calling multiple times and on the last element make CR (carriage Return) True.

You can also app is the whole string to write like:

"Test Number, Test Date, Test Time, Data, ...." then make add CR true to complete the entry.

Matt

[sumitrishi]

Thanks Matt. I am unable to open the file as I have 6.1 installed on my machine . Is it possible for you to give it to me in that version or may be a snapshot that could help ?

Thanks again .

Sumit

[mfitzsimons]

It will only let me save in 7.0 or 7.1. Function is only an open file (use append), write file (write at end), and close file. For write file just feed it a string like "time,date, data" with the commas separating the elements. For CR, append a carriage Return Constant (sorting palette).

Matt

[sumitrishi]

I think that wouldnt solve my problem .I canNOT make changes to the existing program. I can only add something towards the end that uses the results that has been stored in sequence context during the execution. And, may be in loop puts them out in a csv file.
Now where these results are stored what properties and what methods needs to be used to access results in this 'new step' is something on which I need help.

Thanks
Sumit

[RayFarmer]

hi sumitrishi,

You could just set the teststand report options to csv.

Regards
Ray Farmer

[Petri]

Hello,

In my current version of TestStand (v3.1) the .csv report type doesn't exists in the report options. Only an ASCII, XML or HTML options are available. The ASCII format doesn't correspond the .csv format. Has the csv option been included once in previous versions of TestStand report options or is there available examples how to do that through the report options window ?

If there is no example, could it be possible to add csv report type only modifying the UpdateArrayMeasurementList function in report.c file for modelsupport2.dll (with a drawback to have a modified dll) and creating a new ReportGen_csv.seq file ?

Regards,

Petri

[RayFarmer]

Hi,

Sorry, I was getting my self confused with the TestLimit setting "Doh"

Try this example for starters: http://sine.ni.com/apps/we/niepd_web_display.display_epd4?p_guid=B45EACE3DACA56A4E034080020E74861&p_...

Regards

Ray Farmer

[Dennis_Knutson]

Here's a sequence that I wrote for a CM that required csv files to import into their database. Just call it in your process model like you would the regular test report.

[Petri]

Thanks.

Attached a modified reportgen_csv.seq file to support multiple numeric limit test. Even the layout of csv is somewhat modified. Just store the file in your ..\national instruments\teststand 3.1\components\user\models\teststandmodels directory. 

Attached as well an example of calling sequence csv_report.seq. Change in the report options window the report format to ASCII text file.

These files requires version 3.1. 

Regards,

Petri