How do I create new variables from excel file import?

[dusty_g]

I'm sure this is simple, but how do I import an excel file full of new variables that are not defined in TestStand already?  I know how to do it when the variables already exist in TestStand but I have a lot of variables that I don't want to enter in manually.  Is there a way for TestStand to create the variables from the Excel file automatically?  I tried six variables, 3 already existed in TS and 3 did not.  This is the error that I get:

Sequence File: PSW_ITA_and_Card_Signature.seq
Sequence: ITA Signature Test

6 property value(s) were found.

3 property value(s) were imported from 10 row(s) of data

Warning:

Error evaluating expression:RunState.InitialSelection.SelectedFile.Data.FileGlobalDefaults.A12_A15_to_backplane_3A4 = ("A12-ANALOG-BUS-3 to BACKPLANE-BUS-3 & A12-ANALOG-BUS-4 to BACKPLANE-BUS-4 & A15-ANALOG-BUS-3 to BACKPLANE-BUS-3 & A15-ANALOG-BUS-4 to BACKPLANE-BUS-4")
Property does not exist.

Error evaluating expression:RunState.InitialSelection.SelectedFile.Data.FileGlobalDefaults.DMM_A12_BUS_3A4 = ("GPIJ24-A2toANALOG-BUS-3 & GPIJ24-A3toANALOG-BUS-4")
Property does not exist.

Error evaluating expression:RunState.InitialSelection.SelectedFile.Data.FileGlobalDefaults.Resistor_A15_BUS_3A4 = ("GPIJ24-J17 to ANALOG-BUS-3 & GPIJ24-J18 to ANALOG-BUS-4")
Property does not exist.

[RayFarmer]

Hi,

The Import/Export tool expects the properties to exist in TestStand already.

So you would have to write you own tool to do this, something along the lines of the Build Sequence File example found in TestStand/

Examples.

To insert a Variable/Property into a SequenceFile such as a FileGlobals you would use the PropertyObject.SetVal method but use option setting of 0x1 (Insert if Missing)