NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Export custom step properties for all sequences based upon expression

I want to export only my custom step properties to a database. I realize this can be done one at a time but I'm looking for a more general, quicker solution since I have dozens of custom steps and many instances of each. I can probably do this, but if someone has already developed a method I could use the info. Thanks.
 
kph 
0 Kudos
Message 1 of 2
(2,826 Views)
Hi kph,

Unfortunately, there is not a straightforward way to solve this problem.  TestStand does not currently support any database configuration through programmatic means.  The customized database must be configured ahead of time.  I would handle the issue by setting up this database in configure >> Database Options. 

The quickest solution for customization would be to duplicate one of the default Schemas (for example, Generic Recordset) under the "Schema" tab.  Under the statements tab, you can then cut out all of the unwanted statements (it sounds like you'll want to cut out most of them) and add new statments for your custom steps.   In this step, be sure to reference your custom step type for each statement in the "Types to Log" field.

Under the Columns/Parameters tab, you can then add all of the properties you would like to save for each configured statement.

At this point, you can use TestStand to create a SQL script file to match the Schema you just created.  From the Schema tab, you can select the Build .sql File dialog box.  After saving and running the script, you will have successfully created the required tables for the custom schema. 

At this point, the custom properties should log to the database.

Hope this helps in your application development!
Andrew W. - Applications Engineer
Message 2 of 2
(2,809 Views)