NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Database filling from XML report of TS3

Does NI have a tool to fill-up an Oracle database from a XML report of TS3? The idea is to fill up the database during the night.
0 Kudos
Message 1 of 3
(3,145 Views)
I can't answer your question about NI having a tool, but we are facing a similar problem so I will share some of our ideas.

1. You could write your own XML parser that would read the file and load it into the database. Since it is a standard format, you should be able to find software that will make the parsing relatively easy.

2. You could load the file directly into an Oracle 9i database, passing it as a LOB parameter. You would need to write the code for loading the file (examples can be found on the internet) and you would probably need an Oracle expert to implement the XML parsing on the database side.

3. You could save the results container as a file, then later load the file into TestStand and use the standard database logging sequence. We tried a
dding the results container to StationGlobals, but have had problems saving all the data to disk.

4. You could modify the text report so that it creates the SQL statements required to enter your data into the database. Then the file can be loaded into the database as "dynamic SQL".

5. You could log the data to a local database, then later load it into the main database, as suggested by Dennis (http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RPAGEID=135&HOID=506500000008000000E13B0000&UCATEGORY_0=_8_&UCATEGORY_S=0).
0 Kudos
Message 2 of 3
(3,145 Views)
I'm doing this now with our SQL Server database. The database admin exported the schema as an XML file. I then modified the text report to create an XML file with that format. An import tool loads each XML file into the database periodically. Currently it is set to look for new XML files every 30 seconds but it can be set to run only during off hours. This is what we'll be doing with our off-shore contract manufacturer. The import tool was written internaly so I can't help you there much unfortunately. There is a commercial product called Arendar from
0 Kudos
Message 3 of 3
(3,145 Views)