I wanna know if it is possible to automatically create sequence files from excel test suites which contains actions and expected results then execute them in Teststand, without having to do that manually which takes tremendous amount of time.
thank you in advance for your answers.
Solved! Go to Solution.
Yes it is possible. I would have to see what your data looks like to give you more information and direction.
However, the TestStand API allows you to basically do most things in TestStand in an automated fashion.
I meant to send you this link: https://zone.ni.com/reference/en-XX/help/370052R-01/tsexamples/infotopics/buildsequenceapi_labview/
There is an example that shows how to build a sequence file using the API.
A potential alternative to generating all of these files would be to create a superset of your tests, use the property loader to import a list of test & limits from your excel file, and only run the necessary sequences from your sequence file.
It depends on your overall testing procedure if something like this makes more sense than generating files with the API.
Hope this helps!
what i want to do is turn existing test suites and test cases to TestStand format in order to do Hardware in The Loop testing, for example for an action putting a set_tag, for a check a get_tag, putting labels... and all of that programatically without doing it manually.
when ever it is possible i convert a complete test specification to a teststand sequence file.
In early years i have created a c# application that uses TS-API.
Today i am using a teststand sequncefile exactly as jigg mentioned , because when creating it - TS will give me a report 😉
In both solutions i first convert the excelfile in to a xml-file. So there is addtional interface to keep it flexible.
Hope this helps to see it is possible
thanks for your answers i will check that Api and try to undesrtand how it works, one last question, can i convert a sequence to a readable Xml file with an Api?
Thanks in Advance
yes you may save a sequnce file as xml (manually or with api).
But i would never create a xml file that TS can read.Thats extremley complicated(and will work only for a specific Version!!!). Always use the api to create a seuencefile.
Unfortunately when writing my fist message a did not look on your example. Your task is pretty difficult.
The structure is extremly plain, but not impossible when you just want to derive your steps from "expected result". Of Course best would be one step per cell.
I wish you good luck.
thank you for your answer, i wanna know something, i tried the sequence builder api that allows me to turn an xml file (present in a folder called 'Common') to a sequence file, i opened that xml file and it isn't complicated to read and very understandable, i wanna know how to do the exact opposite passing from a sequence file to an Xml file that looks like the one given in the examples folder ( i mean i changed the format of a sequence to XML then i opened it but it was a long complicated Xml fiLe)
The purpose behind doing that is to create automatically Xml files that will be turned to sequence files by using the Sequence builder Api.