03-08-2018 07:28 AM
Hello everyone,
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.
03-08-2018 08:19 AM
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.
Regards,
03-08-2018 08:24 AM
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.
Cheers,
03-08-2018 08:39 AM
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!
Trent
03-08-2018 08:43 AM
Hello here is my excel file.
best regards
03-08-2018 08:59 AM
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.
03-08-2018 11:06 AM
Hi
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.
ftp://ftp.ni.com/pub/branches/germany/vipdays_09_sessions/Automotive_5_Automatische_Dodek.pdf (see Part1)
Hope this helps to see it is possible
regrads
Juergen
03-08-2018 01:31 PM
Hello
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
Anis
03-09-2018 03:44 PM
Hi Anis,
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.
Juergen
03-10-2018 12:33 PM
Hello j_dodek,
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.