NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Write to TestStand DataBase

Hi guys!

 

I'm using test stand and saving all data into the standar Database (access),

 

but I have others testers than I'm using just LabView (no TestStand Installed) and I would like save all test data into the TestStand dataBase, is any way to do that?

 

I'm not a DataBase expert, I just have basic knowledge, but I did a DataBase query some months ago, you can find find it here 

 

http://forums.ni.com/t5/NI-TestStand/TestStand-DataBase-Query/m-p/2866064

 

 

do any body make the oposite? save all data into TestStand Database using SQL commands?

 

Thank you.

 

knowledge

 

0 Kudos
Message 1 of 5
(4,382 Views)

Hi LuisMontoya, 

 

In case you haven't already seen these, here are some relevant tutorials and documents: 
Getting Started Logging to Databases Quickly with NI TestStand: http://www.ni.com/tutorial/51953/en/
Logging TestStand Results to a MySQL Database: http://www.ni.com/tutorial/3604/en/

Database Viewer Application: http://zone.ni.com/reference/en-XX/help/370052N-01/tsref/infotopics/dbviewer/

If you don't have TestStand Installed on a computer, you won't be able to save data into the TestStand dataBase. However, you can use one of the database connectivity systems that TestStand communicates with like Oracle, SQL Server, MySQL, or a Microsoft Access database.

Regarding the opposite, this tutorial might be relevant:
Creating a TestStand Database Schema from Scratch: http://www.ni.com/tutorial/6484/en/

Shalini M.
Partner Development Engineer
Alliance Partner Network
National Instruments
0 Kudos
Message 2 of 5
(4,347 Views)

Thank you Shalumdawg,

 

but yes I saw that links already but have no information about what I need to do.

 

I need something like this:

 

insert into UUT_RESULT ("PartNumber"....... )

values (" "," ",......)

 

the way as TestStand is sending all data into database.

 

 

0 Kudos
Message 3 of 5
(4,338 Views)

Did you see  <TestStand Installation Directory>/Components/Models/TeststandModels/Database ? This might give you some ideas. how Teststand does the database access.

0 Kudos
Message 4 of 5
(4,324 Views)

Yes I did Mkossman,

 

there are "Schemas" to get results only, NOT to insert test results.

 

but thank you, I will continue trying.

 

0 Kudos
Message 5 of 5
(4,301 Views)