Logging data to a custom database scheme

[Exle]

tl;dr: I want to log to a database with a mixed result of UUT-data (serialnumber) and Step-Data (measured voltages).

Long version: I am logging into an MySQL database. The db does not follow the default TestStand logging scheme by creating one table for the UUT and one for the results. Instead it should looks like this:

ID	Serialnumber	Voltage
1	123.456	5.2
2	353.556	5.1

The serialnumber is entered by the user. I use the Message Popup Step for this. It is saved into a local variable (Locals.serial).

When I configure the data which will be logged. I can not find my local variables.

Ok, so I guess I have to mark the variable to be logged. And that's the part where I am stuck:

• I can enter Locals.Seriennummer.AoIP in the Additional Results property. But this logs to the PROP_RESULT-Table when I use the built-in database scheme. This is not what I want.
• I have found this link which explains nearly exactly what I want to do. Except that it generates a table of steps and not a table of UUTs with the results of some selected steps.

[PatrikKaranNI]

Hi Exle,

Do you still experience challenge with logging additional values and creating your own schema?

Did you have a chance to see this tutorial, instead of the one you were linking in your post?
https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000000x1kICAQ&l=en-US

Hope this helps!

Regards,

[Exle]

Hi,

I am not using the built-in TestStand Log-Test-Results-To-Database anymore. Instead I am using the Database Steps. I open the table with my test results, write the test results how I want them and close my table. This works very good.

kind regards,

Christian