We have been logging data to SQLite TapResult databases which has worked fairly well and I have created a number of SQl queries to work with the data.
I just found out that some of our operators have been saving the database after each test run, so now I have a number of files with data.
In order to do statistical analysis I need to combine these TapResult files into one SQL database.
Does anyone have a SQL or other script to do this?
Rob
There isn’t script as such at the moment, but the Run Explorer (Part of Keysight Test Automation) has an export feature. Where you can export all results. If the target of that export is SQLite, it will get merged into that.
If you are thinking that it would be far better with some kind of command line or script approach, then you can try opening an issue on the opentap issue tracker.
Rolf,
Thank you . I think using Run Explorer will work for now.
I do foresee that having a command line or script approach would be useful for cases where the data is save to multiple remote machines then needs to be integrated into the master database. For our DV and PV testing we often have laptops running at test houses without internet connection back to a server. In these cases it is a must to log local. The other case that has pushed us to use separate databases is that SQLite get rather slow when the database gets large.