7 Accessing Your Data

Access Database

Note:

If using Windows 7 or 8, the *.mdb file may be located in a different directory than the default location. It is often found under your User account instead of Program Files. To easily find the location of the *.mdb file, search for "sts_gold.mdb" in the C drive.

Data received in each report from the STS Gold Controller is placed in a Microsoft® Access® database (*.mdb file) on the Home Station computer. New data is appended to the existing database. The program will save data downloaded to the following default directory: <C:\Program Files\Solinst\STS_Gold\db>. The location of the default directory may vary for different Windows operating systems (see note).


solinst sts telemetry systems accessing your data sts controller image

Figure 7-1 STS Database Folder

Note:

The Access database can be queried by your own macros or applications, to automatically check for updates and display the data in your own program, on a website, or in any way you choose.

solinst sts telemetry systems accessing your data sts controller image

Figure 7-2 STS Access Files

solinst sts telemetry systems accessing your data sts controller image

Figure 7-3 STS Access Data

 

View Using STS/RRL Software

STS/RRL Gold Software can be used for a quick check of the latest readings. Data can also be exported using the STS Software as *.xle, *.lev or *.csv files for use in other programs.

To view data from a specific site, click on the Site in the STS Administrator screen and click “Display Data”. Select the site from the list that opens and click OK.

Figure 7-4 Select STS Site


Figure 7-5 STS Site Data Screen


The data will be displayed in a table at the top of the window, the bottom portion of the window will show the data graphed. Data from each datalogger is shown in a separate tab (identified by serial number), Remote Site Data, including battery voltage is also displayed in a separate tab.